task/notific_p.php at master · aditya169/task · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<!--
//============================================================+
// File name   : notific_p.php
//
// Description : Display notifications for poster's account
//
// Author:  Aditya Mathur
//
// (c) Copyright:
//               Aditya Mathur
//               eztasker.com
//
// License:
//    Copyright (C) 2014 Aditya Mathur - eztasker.com
//============================================================+
-->
<script type="text/javascript">
$(document).ready(function(){

	$(".view_comments").click(function() {
		var ID = $(this).attr("id");
		$.ajax({
			type: "POST",
			url: "./notific_p_ajax.php",	 //where data to be post.
			data: "id="+ ID, 				 //What data to be post.
			cache: false,					 //do not put in cache.
			success: function(html){
				$("#view_comments"+ID).prepend(html);
				$("#view"+ID).remove();
				$("#two_comments"+ID).remove();
			}
		});
		return false;
	});

});

</script>

<link rel="stylesheet"	href=""  type="text/css" />

<div id="menu">
	<ul>
		<li>
			<a href="#" style="padding:10px 0;">
			<img src="images/images.png" style="width: 21px;" />
			<?php
				require_once './includes/db_config.php';
				connect();
				$sql=mysql_query("select * from task_applied where accepted_flag=0 AND poster_id=$pid");
				$count=mysql_num_rows($sql);
				if($count!=0){
					echo '<span id="mes">'.$count.'</span>';
				}
			?>
			</a>

		<ul class="sub-menu">
			<?php
			$msql=mysql_query("select * from task_applied where accepted_flag=0 AND poster_id=$pid order by id");
			while($row=mysql_fetch_array($msql))
				$id=$row['id'];
			?>
			<li class="egg">
			<div class="toppointer"><img src="images/top.png" /></div>
				<?php

				$sql=mysql_query("select * from task_applied where accepted_flag=0 AND poster_id=$pid order by id");
				$count=mysql_num_rows($sql);

				if($count>2){
					$second_count=$count-2;
				}else {
					$second_count=0;
				}
				?>

				<div id="view_comments<?php echo $id; ?>"></div>
				<div id="two_comments<?php echo $id; ?>">

				<?php

				$listsql=mysql_query("select * from task_applied, worker_profile
					where   task_applied.worker_id = worker_profile.worker_id
					AND		accepted_flag=0
					And 	poster_id=$pid  order by id limit $second_count,2 ");

				while($rowsmall=mysql_fetch_array($listsql))
				{
					$id=$rowsmall['id'];
					$wid=$rowsmall['worker_id'];
					$comment=$rowsmall['comment'];
					$task_id=$rowsmall['task_id'];
					$wname=$rowsmall['fname']." ".$rowsmall['lname'];
					$rs=mysql_query("select title from task where task_id=$task_id");
					$row5=mysql_fetch_array($rs);
					$task_title=$row5['title'];

					?>

					<div class="comment_ui">
						<div class="comment_text">
							<div  class="comment_actual_text">
								<?php echo $wname;?> made offer for your task: <?php echo $task_title;?>
							</div>
						</div>
					</div>
					<?php
				}
					?>

				<div class="bbbbbbb" id="view<?php echo $id; ?>">
					<div style="background-color: #F7F7F7; border-bottom-left-radius: 3px; border-bottom-right-radius: 3px; position: relative; z-index: 100; padding:8px; cursor:pointer;">
					<?php if($count>0){?>
						<a href="#" class="view_comments" id="<?php echo $id; ?>">View all <?php if($count>1){echo $count." offers";}else{echo " offers";}?></a>
					<?php }else{?>
						<a href="#" > No New Offer</a>
					<?php }?>
					</div>
				</div>

			</li>
			<?php //} ?>
		</ul>
		</li>
	</ul>
</div>
</div>