Example #1
0
    function showTaskForProject($record, $listonly = 0, $assigned_to_module = '', $assigned_to_module_id = '', $assigned_to = '', $upcomming = '', $completed = '', $showday = '', $complete_task = '')
    {
        ?>
	  <table id="display_search" class="event_form small_text" width="100%">
	   <tbody>	
	   <?php 
        $i = 1;
        while ($row = $this->db->fetch_array($record)) {
            if ($i % 2 == 0) {
                ?>
				<tr class="even">
			<?php 
            } else {
                ?>
				<tr class="odd">
			<?php 
            }
            ?>
		<td>	 
			<div id="divmaintask_<?php 
            echo $row[task_id];
            ?>
">
			<?php 
            if ($complete_task != 'yes') {
                if ($row['completed'] == 'Yes') {
                    ?>
					<div style="color:#CCCCCC" id="taskmain<?php 
                    echo $row[task_id];
                    ?>
" <?php 
                    if (!$listonly) {
                        ?>
												onmouseover="document.getElementById('<?php 
                        echo $row[task_id];
                        ?>
').style.display='';
															 document.getElementById('task_action_<?php 
                        echo $row[task_id];
                        ?>
').style.display=''; " 
												onmouseout="document.getElementById('<?php 
                        echo $row[task_id];
                        ?>
').style.display='none'; 
														   document.getElementById('task_action_<?php 
                        echo $row[task_id];
                        ?>
').style.display='none';" 			
													   <?php 
                    }
                    ?>
 class="<?php 
                    if (!$listonly) {
                        echo 'task_padding';
                    }
                    ?>
">
				<?php 
                    if (!$listonly) {
                        ?>
						<span id="task_action_<?php 
                        echo $row[task_id];
                        ?>
"  style="display:none; " class="task_action">				
								<a href="edit_task.php?task_id=<?php 
                        echo $row[task_id];
                        ?>
" onClick="">
								<img src="images/edit.gif" border="0"  align="absmiddle"/></a>&nbsp;
								<a href="#" onClick="if(confirm('Are you sure ?')){	task.DeleteTask(<?php 
                        echo $row[task_id];
                        ?>
,
															   {onUpdate: function(response,root)
															   {document.getElementById('divmaintask_<?php 
                        echo $row[task_id];
                        ?>
').innerHTML='';},
																target: 'taskmain<?php 
                        echo $row[task_id];
                        ?>
', preloader:'prl'});
													 } else return false;">
								<img src="images/trash.gif" border="0"  align="absmiddle"/>&nbsp;</a>
						</span>
				<?php 
                    }
                    ?>
				<table width="100%">
					<tr>
						<td width="2%">					
							<input type="checkbox" name="chk_task[]" id="chk_task[]" disabled="disabled" checked="checked">
						</td>
						<td width="2%">&nbsp;</td>
						<td width="27%" align="left">
						   <span style="font-weight:bold; font-size:16px" id="taskdiv<?php 
                    echo $row[task_id];
                    ?>
" class="complete" >
						 	  <span class="small_text"><?php 
                    echo $row['title'];
                    ?>
</span>
							</span>
						</td>			   
						<td width="10%" align="left">
							<span class="complete" style="margin-left:70px; margin-right:20px">
								<img src="images/chat_bubble.gif" />
								<?php 
                    /*$sql_note = "Select * from ".TBL_NOTE_STATUS." where module_id = '$row[task_id]' and module_name = 'Task'";
                    		$result_note=$this->db->query($sql_note,__FILE__,__lINE__);
                    		if($this->db->num_rows($result_note)>0){
                    			while($row_note = $this->db->fetch_array($result_note)){
                    				if($row_note['note_status']=='unread'){
                    					$note_status='unread';
                    					$note_id=$row_note['note_id'];
                    				}
                    				else if($row_note['note_status']=='read'){
                    					$note_status='read';
                    					$note_id=$row_note['note_id'];
                    				}	
                    			}				
                    			echo $this->returnNoteLink($row['task_id'],$note_id,$note_status,'task');
                    		}
                    		else{
                    			echo $this->returnNoteLink($row['project_id']);
                    		}					
                    		*/
                    ?>
							</span>
						</td>
						<td width="10%">
							<span id="task_document">
								<?php 
                    $sql_doc = "Select * from " . TASKS . " where task_id = '{$row['task_id']}'";
                    $result_doc = $this->db->query($sql_doc, __FILE__, __LINE__);
                    while ($row_doc = $this->db->fetch_array($result_doc)) {
                        echo $this->returnDocumentLink($row_doc['doc_name'], $row_doc['doc_server_name'], 'complete');
                    }
                    ?>
							</span>	
						</td>
						<td width="35%" align="right">							
							<span class="complete" style="float:right">
								<span class="complete">
								<?php 
                    if ($assigned_to != '' or $upcomming != '') {
                        $user = new User();
                        echo $user->GetUserNameById($row['completed_by']);
                    }
                    ?>
								 </span>
							 </span>
						</td>
					</tr>
				</table>				 
			</div>	
		  <?php 
                }
                // End of If Condition
                if ($row['completed'] == 'No') {
                    ?>
			<div id="taskmain<?php 
                    echo $row[task_id];
                    ?>
" <?php 
                    if (!$listonly) {
                        ?>
									onmouseover="document.getElementById('<?php 
                        echo $row[task_id];
                        ?>
').style.display='';
												 document.getElementById('task_action_<?php 
                        echo $row[task_id];
                        ?>
').style.display=''; " 
									onmouseout="document.getElementById('<?php 
                        echo $row[task_id];
                        ?>
').style.display='none'; 
											   document.getElementById('task_action_<?php 
                        echo $row[task_id];
                        ?>
').style.display='none';" 			
										   <?php 
                    }
                    ?>
 class="<?php 
                    if (!$listonly) {
                        echo 'task_padding';
                    }
                    ?>
">
				<?php 
                    if (!$listonly) {
                        ?>
						<span id="task_action_<?php 
                        echo $row[task_id];
                        ?>
"  style="display:none; " class="task_action">				
								<a href="edit_task.php?task_id=<?php 
                        echo $row[task_id];
                        ?>
" onClick="">
								<img src="images/edit.gif" border="0"  align="absmiddle"/></a>&nbsp;
								<a href="#" onClick="if(confirm('Are you sure ?')){	task.DeleteTask(<?php 
                        echo $row[task_id];
                        ?>
,
															   {onUpdate: function(response,root)
															   {document.getElementById('divmaintask_<?php 
                        echo $row[task_id];
                        ?>
').innerHTML='';},
																target: 'taskmain<?php 
                        echo $row[task_id];
                        ?>
', preloader:'prl'});
													 } else return false;">
								<img src="images/trash.gif" border="0"  align="absmiddle"/>&nbsp;</a>
						</span>
				<?php 
                    }
                    ?>
					
				<table class="table" width="100%">
					<tr>
						<td width="2%">	
							<input type="checkbox" name="chk_task[]" id="chk_task[]" onClick="javascript: 
								document.getElementById('taskdiv<?php 
                    echo $row[task_id];
                    ?>
').className=<?php 
                    if ($row[completed] == 'Yes') {
                        ?>
'' <?php 
                    } else {
                        ?>
'complete'<?php 
                    }
                    ?>
; 
										task.Complete_Task(<?php 
                    echo $row[task_id];
                    ?>
,  
										<?php 
                    if (!$listonly) {
                        ?>
												document.getElementById('contact_id').value,
												document.getElementById('category').value, 
												<?php 
                    } else {
                        ?>
							
												'','',
												<?php 
                    }
                    ?>
												'<?php 
                    echo $listonly;
                    ?>
',
												'<?php 
                    echo $assigned_to_module;
                    ?>
',
												'<?php 
                    echo $assigned_to_module_id;
                    ?>
',
												'search',
												'<?php 
                    echo $_SESSION[user_id];
                    ?>
',
												{target: 'divmaintask_<?php 
                    echo $row[task_id];
                    ?>
', preloader:'prl'});">
						</td>
						<td width="2%">					
							<span id="importance_<?php 
                    echo $row['task_id'];
                    ?>
">
								<?php 
                    echo $this->returnImportance($row['task_id'], $row['importance_type_id'], 'task');
                    ?>
							</span>
						</td>
						<td width="26%" align="left">
							<span style="color:#009933; font-weight:bold; font-size:16px" id="taskdiv<?php 
                    echo $row[task_id];
                    ?>
" >
								<span class="small_text">
									<a href="javascript:void(0);" onclick="project_new.showTaskDetails('local',
																				'<?php 
                    echo $row['task_id'];
                    ?>
',
																				'<?php 
                    echo $assigned_to_module_id;
                    ?>
',
																				{onUpdate: function(response,root){ 
																					document.getElementById('divProduct').innerHTML=response;
																					document.getElementById('divAddTask').style.display='none';
																					start_cal();
																					autosuggest4(); }});"><?php 
                    echo $row['title'];
                    ?>
</a>
								</span>
							</span>
						</td>
						<td width="5%" align="left">
							<span id="task_note<?php 
                    echo $row['task_id'];
                    ?>
" style="margin-left:70px; margin-right:20px">
								<?php 
                    $sql_note = "Select * from " . TBL_NOTE_STATUS . " where module_id = '{$row['task_id']}' and module_name = 'Task'";
                    $result_note = $this->db->query($sql_note, __FILE__, __LINE__);
                    if ($this->db->num_rows($result_note) > 0) {
                        while ($row_note = $this->db->fetch_array($result_note)) {
                            if ($row_note['note_status'] == 'unread') {
                                $note_status = 'unread';
                                $note_id = $row_note['note_id'];
                            } else {
                                if ($row_note['note_status'] == 'read') {
                                    $note_status = 'read';
                                    $note_id = $row_note['note_id'];
                                }
                            }
                        }
                        echo $this->returnNoteLink($row['task_id'], $note_id, $note_status, 'task_note');
                    } else {
                        echo $this->returnNoteLink($row['task_id'], '', '', 'task_note');
                    }
                    ?>
							</span>
						</td>
						<td width="10%">				
							<span id="task_document">
								<?php 
                    $sql_doc = "Select * from " . TASKS . " where task_id = '{$row['task_id']}'";
                    $result_doc = $this->db->query($sql_doc, __FILE__, __LINE__);
                    while ($row_doc = $this->db->fetch_array($result_doc)) {
                        echo $this->returnDocumentLink($row_doc['doc_name'], $row_doc['doc_server_name']);
                    }
                    ?>
							</span>				
						</td>			
						<td width="35%" align="right">
							<span class="small_text" style="float:right"> 
								<?php 
                    if ($assigned_to != '' or $upcomming != '') {
                        $user = new User();
                        echo $user->GetUserNameById($row[user_id]);
                    }
                    ?>
							</span>
						</td>
					</tr>
				</table>				
			</div>		  
		  <?php 
                }
            } else {
                ?>
					<div style="color:#CCCCCC" id="taskmain<?php 
                echo $row[task_id];
                ?>
" <?php 
                if (!$listonly) {
                    ?>
												onmouseover="document.getElementById('<?php 
                    echo $row[task_id];
                    ?>
').style.display='';
															 document.getElementById('task_action_<?php 
                    echo $row[task_id];
                    ?>
').style.display=''; " 
												onmouseout="document.getElementById('<?php 
                    echo $row[task_id];
                    ?>
').style.display='none'; 
														   document.getElementById('task_action_<?php 
                    echo $row[task_id];
                    ?>
').style.display='none';" 			
													   <?php 
                }
                ?>
 class="<?php 
                if (!$listonly) {
                    echo 'task_padding';
                }
                ?>
">
				<?php 
                if (!$listonly) {
                    ?>
						<span id="task_action_<?php 
                    echo $row[task_id];
                    ?>
"  style="display:none; " class="task_action">				
								<a href="edit_task.php?task_id=<?php 
                    echo $row[task_id];
                    ?>
" onClick="">
								<img src="images/edit.gif" border="0"  align="absmiddle"/></a>&nbsp;
								<a href="#" onClick="if(confirm('Are you sure ?')){	task.DeleteTask(<?php 
                    echo $row[task_id];
                    ?>
,
															   {onUpdate: function(response,root)
															   {document.getElementById('divmaintask_<?php 
                    echo $row[task_id];
                    ?>
').innerHTML='';},
																target: 'taskmain<?php 
                    echo $row[task_id];
                    ?>
', preloader:'prl'});
													 } else return false;">
								<img src="images/trash.gif" border="0"  align="absmiddle"/>&nbsp;</a>
						</span>
				<?php 
                }
                ?>
				<table width="100%">
					<tr>
						<td width="2%">					
							<input type="checkbox" name="chk_task[]" id="chk_task[]" disabled="disabled" checked="checked">
						</td>
						<td width="2%">&nbsp;</td>
						<td width="27%" align="left">
						   <span style="font-weight:bold; font-size:16px" id="taskdiv<?php 
                echo $row[task_id];
                ?>
" class="complete" >
						 	  <span class="small_text"><?php 
                echo $row['title'];
                ?>
</span>
							</span>
						</td>			   
						<td width="10%" align="left">
							<span class="complete" style="margin-left:70px; margin-right:20px">
								<img src="images/chat_bubble.gif" />
								<?php 
                /*$sql_note = "Select * from ".TBL_NOTE_STATUS." where module_id = '$row[task_id]' and module_name = 'Task'";
                		$result_note=$this->db->query($sql_note,__FILE__,__lINE__);
                		if($this->db->num_rows($result_note)>0){
                			while($row_note = $this->db->fetch_array($result_note)){
                				if($row_note['note_status']=='unread'){
                					$note_status='unread';
                					$note_id=$row_note['note_id'];
                				}
                				else if($row_note['note_status']=='read'){
                					$note_status='read';
                					$note_id=$row_note['note_id'];
                				}	
                			}				
                			echo $this->returnNoteLink($row['task_id'],$note_id,$note_status,'task');
                		}
                		else{
                			echo $this->returnNoteLink($row['project_id']);
                		}					
                		*/
                ?>
							</span>
						</td>
						<td width="10%">
							<span id="task_document">
								<?php 
                $sql_doc = "Select * from " . TASKS . " where task_id = '{$row['task_id']}'";
                $result_doc = $this->db->query($sql_doc, __FILE__, __LINE__);
                while ($row_doc = $this->db->fetch_array($result_doc)) {
                    echo $this->returnDocumentLink($row_doc['doc_name'], $row_doc['doc_server_name'], 'complete');
                }
                ?>
							</span>	
						</td>
						<td width="35%" align="right">							
							<span class="complete" style="float:right">
								<span class="complete">
								<?php 
                if ($assigned_to != '' or $upcomming != '') {
                    $user = new User();
                    echo $user->GetUserNameById($row['completed_by']);
                }
                ?>
								 </span>
							 </span>
						</td>
					</tr>
				</table>				 
			</div>	
		  <?php 
            }
            $i++;
        }
        ?>
	</div>	
	</td>
	</tr>
	</tbody>
	</table>
	<?php 
    }