Order Id |
echo $row_order_1['id'];?> |
Job Name |
echo $row_order_1['job_name'];?>
|
Description
$hours_123=sprintf("%02d", $hours_123) ;
$minutes_123=sprintf("%02d", $minutes_123) ;
?>
|
echo $row_order_1['job_description'];?> |
Incoming File
|
if($c_id=='0')
{
?>
$Query123 = mysql_query("SELECT image_name FROM `tbl_job_details_img` WHERE `job_id`='$id' ");
while ($row1 = mysql_fetch_array($Query123)) {
$image_name= $row1["image_name"];
?>
echo $image_name;?>
";
}
?>
}
else
{
?>
$Query123 = mysql_query("SELECT image_name FROM `tbl_job_details_img` WHERE `job_id`='$c_id' ");
while ($row1 = mysql_fetch_array($Query123)) {
$image_name= $row1["image_name"];
?>
echo $image_name;?>
";
}
?>
$Query_v_1 = mysql_query("SELECT id,freelance_id FROM `tbl_job_details` where id='$c_id' ");
$row_v_1 = mysql_fetch_array($Query_v_1);
$freee_id=$row_v_1['freelance_id'];
if($freee_id=='1')
{
$Query45321 = mysql_query("SELECT max(id) as newww,emp_id,job_id from tbl_employee_changes where job_id='$c_id' ");
$row1245312 = mysql_fetch_array($Query45321);
$newwwww=$row1245312['newww'];
$Query_change_img = mysql_query("SELECT id,complete FROM `tbl_employee_changes` where id='$newwwww' ");
}
else
{
$Query_change_img = mysql_query("SELECT id,complete FROM `tbl_employee_changes` where job_id='$c_id' and complete='3' ");
}
$row_change_img = mysql_fetch_array($Query_change_img);
$row_1=$row_change_img['id'];
$Query123 = mysql_query("SELECT img_name FROM `tbl_employee_changes_img` WHERE `emp_changes_id`='$row_1' ");
while ($row1 = mysql_fetch_array($Query123)) {
$image_name_123= $row1["img_name"];
?>
echo $image_name_123;?>
";
}
?>
}
?> |
Job Started Time
|
$time1 = strtotime("$emp_view_date"); ?>
|
Job Finished Time
|
|
$id=$_REQUEST['id'];
$Query45321 = mysql_query("SELECT max(id) as newww,emp_id,job_id from tbl_employee_changes where emp_id='$sessionid' and job_id='$id' ");
$row1245312 = mysql_fetch_array($Query45321);
$newwwww=$row1245312['newww'];
$Que_man = mysql_query("SELECT supervisor_desdcription,employee_description,status,job_colour,reassigning,id from tbl_employee_changes where emp_id='$sessionid' and job_id='$id' and id='$newwwww' ");
$row12 = mysql_fetch_array($Que_man);
$num_row_new_view = mysql_num_rows($Que_man);
$employee_changes_id=$row12["employee_changes_id"];
$supervisor_desdcription=$row12["supervisor_desdcription"];
$employee_description=$row12["employee_description"];
$employee_status=$row12["status"];
$job_colour=$row12["job_colour"];
$reassigning=$row12["reassigning"];
$newid= $row12['id'];
?>
Start Time
|
--:--:-- |
if( $num_row_new_view > 0)
{
?>
Reassigning Reason
|
echo $reassigning;?>
|
Error Comments
|
|
Completed File |
|
}
?>
Job Colour |
|
Artist Comments |
|
Upload Image
|
|