query($Query_pay_date_new); $row_12_123=mysql_fetch_array($name_pay_date_new); $n_pay_date_status=$row_12_123['status']; if($n_pay_date_status==1 ) { $new_s="Show"; } if($n_pay_date_status==0 ) { $new_s="Hide"; } ?>
Pending Jobs
Training Jobs query($Query_job_move); while($row_job_move = mysql_fetch_array($name_s)) { $new_id=$row_job_move['id']; $emp_view_date=$row_job_move['emp_view_date']; $job_est_time_to=$row_job_move['job_est_time']; $emp_view_to=$row_job_move['emp_view']; $job_assigned_time_to=$row_job_move['job_assigned_time']; $free_emp_id=$row_job_move['free_emp_id']; $est_name_to=($job_est_time_to.':00'); $str_time1= "$est_name_to"; $str_time1 = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", $str_time1); sscanf($str_time1, "%d:%d:%d", $hours, $minutes, $seconds); $time_seconds1_1_2 = $hours * 3600 + $minutes * 60 + $seconds; if($time_seconds1_1_2<7200) { $new_time=3600; } else { $new_time=0; } $new_time_seconds1=($time_seconds1_1_2/7200); $new_time_seconds1_2 = (int)$new_time_seconds1; $new_time_seconds1_3 = ($new_time_seconds1_2*3600); $time_seconds1_1=(($time_seconds1_1_2+$new_time)+$new_time_seconds1_3) ; if($emp_view_to==1) { $timeFirst = strtotime($emp_view_date); $timeSecond = strtotime($date_123_new); $differenceInSeconds = $timeSecond - $timeFirst; if($differenceInSeconds>$time_seconds1_1) { /*finishtime*/ $est_name=($job_est_time_to.':00'); $str_time = "$est_name"; $str_time = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", $str_time); sscanf($str_time, "%d:%d:%d", $hours, $minutes, $seconds); $time_seconds1 = $hours * 3600 + $minutes * 60 + $seconds; $time_seconds=($time_seconds1+3600); $seconds = $time_seconds; $date_now = $emp_view_date; $finish_time=date("Y-m-d H:i:s", (strtotime(date($date_now)) + $seconds)); /*finishtime*/ $iya=1; $Query_s="INSERT INTO tbl_canceljobs VALUES (NULL,'" .$new_id."','".$free_emp_id."','2', ' " .$date_123_new."',' " .$emp_view_date."',' " .$finish_time."')"; $DB->query($Query_s); $Query="UPDATE tbl_job_details SET job_status='0',freelance_id='0',emp_view='0',working_status='0',emp_view_date='',free_emp_id='0' WHERE `id`='$new_id'"; $DB->query($Query); $Delete_Question = "DELETE FROM tbl_free_time_user WHERE job_id='".$new_id."'"; $DB->query($Delete_Question); } else { $iya=3; } } if($emp_view_to==0) { $timeFirst = strtotime($job_assigned_time_to); $timeSecond = strtotime($date_123_new); $differenceInSeconds = $timeSecond - $timeFirst; $new_sec=(54000-$time_seconds1_1); if($differenceInSeconds>$new_sec) { $Query="UPDATE tbl_job_details SET emp_view='0',working_status='0',emp_view_date='',job_status='0',free_emp_id='0',job_assigned_time='',freelance_id='0' WHERE `id`='$new_id'"; $DB->query($Query); $Delete_Question = "DELETE FROM tbl_free_time_user WHERE job_id='".$new_id."'"; $DB->query($Delete_Question); } } } ?> query($Query_job_move_free_job); while($row_job_move_free_job = mysql_fetch_array($name_s_free_job)) { $job_job_create_date_free=$row_job_move_free_job['job_create_date']; $job_job_priority_free=$row_job_move_free_job['job_priority']; $new_id_1_2_3=$row_job_move_free_job['id']; if($job_job_priority_free==2) { $job_due_time_1=$row["job_create_date"]; $job_due_time= date("Y-m-d H:i:s", strtotime($job_due_time_1 . " +2 hours")); $f_j_d_t=(2*3600); } if($job_job_priority_free==3) { $job_due_time_1=$row["job_create_date"]; $job_due_time= date("Y-m-d H:i:s", strtotime($job_due_time_1 . " +5 hours")); $f_j_d_t=(5*3600); } if($job_job_priority_free==4) { $job_due_time_1=$row["job_create_date"]; $job_due_time= date("Y-m-d H:i:s", strtotime($job_due_time_1 . " +8 hours")); $f_j_d_t=(8*3600); } if($job_job_priority_free==5) { $job_due_time_1=$row["job_create_date"]; $job_due_time= date("Y-m-d H:i:s", strtotime($job_due_time_1 . " +10 hours")); $f_j_d_t=(10*3600); } if($job_job_priority_free==6) { $job_due_time_1=$row["job_create_date"]; $job_due_time= date("Y-m-d H:i:s", strtotime($job_due_time_1 . " +14 hours")); $f_j_d_t=(14*3600); } if($job_job_priority_free==7) { $job_due_time_1=$row["job_create_date"]; $job_due_time= date("Y-m-d H:i:s", strtotime($job_due_time_1 . " +18 hours")); $f_j_d_t=(18*3600); } /*totsec*/ $timeFirst_free = strtotime($job_job_create_date_free); $timeSecond_free = strtotime($date_123_new_free_job); $differenceInSeconds_free = $timeSecond_free - $timeFirst_free; /*totsec*/ if($differenceInSeconds_free>$f_j_d_t) { $Query_f_d="UPDATE tbl_job_details SET job_status='0',q_freelance_id='',q_freelance_status='' WHERE `id`='$new_id_1_2_3'"; $DB->query($Query_f_d); $Query = "delete from prime_jobs where job_id='".new_id_1_2_3."'"; $DB->query($Query); } } ?> query($Query_job_qc); while($row_job_det = mysql_fetch_array($name_s_qc)) { $new_job_id=$row_job_det['id']; $Qu_qc = "SELECT max(id) as newww from tbl_employee_changes where job_id='$new_job_id' "; $name_s_qc_1=$DB->query($Qu_qc); $row_qc = mysql_fetch_array($name_s_qc_1); $neww_qc=$row_qc['newww']; $Query_new_qc = "SELECT qc_datetime,supervisor_desdcription,reassigning from tbl_employee_changes where id='$neww_qc' "; $name_s_qc_2=$DB->query($Query_new_qc); $row_new_qc = mysql_fetch_array($name_s_qc_2); $error_marked_comment_qc=$row_new_qc['supervisor_desdcription']; $reassigning_qc=$row_new_qc['reassigning']; $new_date_n=$row_new_qc['qc_datetime']; $timeFirst_qc = strtotime($new_date_n); $timeSecond_qc = strtotime($date_123_new); $differenceInSeconds_qc = $timeSecond_qc - $timeFirst_qc;?> 7200) { $Query_job_change ="SELECT img_name from tbl_employee_changes_img where emp_changes_id='$neww_qc' "; $name_s_qc_3=$DB->query($Query_job_change); $row_job_change = mysql_fetch_array($name_s_qc_3); $new_job_name=$row_job_change['img_name']; $Query_job = "SELECT job_description,client_id from tbl_job_details where id='$new_job_id' "; $name_s_qc_4=$DB->query($Query_job); $row_job = mysql_fetch_array($name_s_qc_4); $des=trim(addslashes($row_job['job_description'])); $client_id=$row_job['client_id']; $cor_mark=1; $Query="UPDATE tbl_job_details SET correction_mark='$cor_mark',job_status='3',error_marked_comment='". trim(addslashes( $error_marked_comment_qc) )."',reassigning='". trim(addslashes( $reassigning_qc) )."',cancel_sta='1' WHERE `id`='$new_job_id'"; $name_s_qc_5=$DB->query($Query); $Delete_Question = "DELETE FROM tbl_free_time_user WHERE job_id='".$new_job_id."'"; $DB->query($Delete_Question); $Queryc="INSERT INTO tbl_job_details VALUES (NULL,'','".$new_job_name."','".$des."','1','NO PO','','6','','','".$date_123_new."','','','', '".$client_id."','','','','','','','','','','','','','','','','','','','','','','".$new_job_id."','','','','','','','','')"; $name_s_qc_6=$DB->query($Queryc); } } if($n_pay_date_status==1 ) { $Query = "SELECT * FROM `tbl_job_details` where job_status='1' and freelance_id='0' and q_freelance_status='0' and job_priority!='10' order by emp_view desc,job_priority asc,job_create_date "; } if($n_pay_date_status==0 ) { $Query = "SELECT * FROM `tbl_job_details` where job_status='1' and freelance_id='0' and q_freelance_status='0' order by emp_view desc,job_priority asc,job_create_date "; } $name=$DB->query($Query); while ($row = mysql_fetch_array($name)) { //while ($DB->Multicoloums()) { $job_type=$row["job_type"]; $job_create_date=$row["job_create_date"]; $client_id=$row["client_id"]; $job_priority=$row["job_priority"]; $emp_id=$row["emp_id"]; $id= $row["id"]; $emp_view=$row["emp_view"]; $share_status=$row["share_status"]; $job_est_time_new=$row["job_completed_date"]; $job_est_time=$row['job_est_time']; $str_time_pata_s = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "$1:$2:00", $job_est_time); sscanf($str_time_pata_s, "%d:%d:%d", $hours, $minutes, $seconds); $time_seconds_pata_s = $hours * 3600 + $minutes * 60 + $seconds; $otime=explode(":",$job_est_time); $Query_qc_r = "SELECT * FROM `tbl_employee_changes` where job_id='$id' "; $name_qc_r=$DB->query($Query_qc_r); $num_qc_r = mysql_num_rows($name_qc_r); if($num_qc_r>'0') { $num_qc_r; } $Queryclient1_c_m = "SELECT * FROM `tbl_client_details` where id='$client_id' "; $nameclient2_c_m=$DB->query($Queryclient1_c_m); $rowclient1_c_m = mysql_fetch_array($nameclient2_c_m); $cl_financial_email=$rowclient1_c_m["financial_email"]; $Query_last_invoice = "SELECT MIN(added_date) as min,id,client_id,order_id from tbl_job_email where client_id IN(SELECT id from `tbl_client_details` where financial_email='".$cl_financial_email."' and local!='1' and local_status!='1' ) "; $name_last_invoice=$DB->query($Query_last_invoice); $noo=mysql_num_rows($name_last_invoice); if($noo=='') { $para='1'; } $row_last_invoice = mysql_fetch_array($name_last_invoice); $last_payment=$row_last_invoice['min']; $last_client_id=$row_last_invoice['client_id']; date_default_timezone_set('Asia/Kolkata'); $date = date('Y-m-d H:i:s ', time()); $date_dif=0; if($last_payment!='') { $date1=strtotime("$last_payment"); $date2=strtotime("$date"); $datediff = $date2 - $date1; $date_dif= floor($datediff/(60*60*24)); } $date_dif; ?> 7) { ?> '0') { ?> style="background-color:#9999FF;" style="background-color:#FF0000" class="odd gradeX warning" > query($Query1_clie); $row1_clie = mysql_fetch_array($name2_clie); $new_local=$row1_clie['local']; $new_local_status=$row1_clie['local_status']; ?> query($Query1); $row1 = mysql_fetch_array($name2); //$DB->Multicoloums(); ?> query($Queryclient1); $rowclient1 = mysql_fetch_array($nameclient2); //$DB->Multicoloums(); ?> query($Queryclient123); $rowclient1233 = mysql_fetch_array($nameclient213); //$DB->Multicoloums(); ?> query($Query); while ($row = mysql_fetch_array($name)) { //while ($DB->Multicoloums()) { $job_type=$row["job_type"]; $job_create_date=$row["job_create_date"]; $client_id=$row["client_id"]; $job_priority=$row["job_priority"]; $emp_id=$row["emp_id"]; $id= $row["id"]; $job_est_time=$row['job_est_time']; $str_time_pata_s = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "$1:$2:00", $job_est_time); sscanf($str_time_pata_s, "%d:%d:%d", $hours, $minutes, $seconds); $time_seconds_pata_s = $hours * 3600 + $minutes * 60 + $seconds; $otime=explode(":",$job_est_time); $otime=explode(":",$job_est_time); $emp_view=$row["emp_view"]; $share_status=$row["share_status"]; $free_emp_id=$row["free_emp_id"]; $Query_qc_r = "SELECT * FROM `tbl_employee_changes` where job_id='$id' "; $name_qc_r=$DB->query($Query_qc_r); $num_qc_r = mysql_num_rows($name_qc_r); $Query_qc_r_prime = "SELECT id FROM `prime_jobs` where job_id='$id' "; $name_qc_r_prime=$DB->query($Query_qc_r_prime); $num_qc_r_prime = mysql_num_rows($name_qc_r_prime); if($num_qc_r>'0') { $num_qc_r; } ?> '0') { ?> style="color:#9966FF" style="color:#FF0000" > 0) { ?> '0') { ?> style="color:#9966FF" style="color:#9933FF" > query($Query1_clie); $row1_clie = mysql_fetch_array($name2_clie); ?> query($Query1); $row1 = mysql_fetch_array($name2); //$DB->Multicoloums(); ?> query($Queryclient1); $rowclient1 = mysql_fetch_array($nameclient2); //$DB->Multicoloums(); ?> query($Queryclient123); $rowclient1233 = mysql_fetch_array($nameclient213); $journalName_free = $rowclient1233['name']; $journalName_free=strtolower($journalName_free); $journalName_free=ucfirst($journalName_free); $journalName_free=ucwords($journalName_free,"."); $journalName_free=ucwords($journalName_free," "); //$DB->Multicoloums(); ?> query($Query); while ($row = mysql_fetch_array($name)) { //while ($DB->Multicoloums()) { $job_type=$row["job_type"]; $job_create_date=$row["job_create_date"]; $client_id=$row["client_id"]; $job_priority=$row["job_priority"]; $emp_id=$row["emp_id"]; $id= $row["id"]; $job_est_time=$row['job_est_time']; $otime=explode(":",$job_est_time); $emp_view=$row["emp_view"]; $share_status=$row["share_status"]; $free_emp_id=$row["q_freelance_id"]; $Query_qc_r = "SELECT * FROM `tbl_employee_changes` where job_id='$id' "; $name_qc_r=$DB->query($Query_qc_r); $num_qc_r = mysql_num_rows($name_qc_r); if($num_qc_r>'0') { $num_qc_r; } ?> '0') { ?> style="color:#9966FF" style="color:#CC6666" > query($Query1_clie); $row1_clie = mysql_fetch_array($name2_clie); ?> query($Query1); $row1 = mysql_fetch_array($name2); //$DB->Multicoloums(); ?> query($Queryclient1); $rowclient1 = mysql_fetch_array($nameclient2); //$DB->Multicoloums(); ?> query($Queryclient123); $rowclient1233 = mysql_fetch_array($nameclient213); $journalName_free = $rowclient1233['name']; $journalName_free=strtolower($journalName_free); $journalName_free=ucfirst($journalName_free); $journalName_free=ucwords($journalName_free,"."); $journalName_free=ucwords($journalName_free," "); //$DB->Multicoloums(); ?>
Order Id Company Name Job Name Job Type Priority Designer Name Admin Est Designer Est Status Job Uploaded Time Action

" style="color:#337ab7"> :
--:--:--
Started Not Started -Sharing query($Queryclient123); $num_rows = mysql_num_rows($nameclient2123); //$DB->Multicoloums(); ?>
  0) {*/ ?> ' ?>   Move ' // ?>
Freelance- :
--:--:--
Started Not Started -Sharing query($Queryclient123); $num_rows = mysql_num_rows($nameclient2123); //$DB->Multicoloums(); ?>
  0) {*/ ?> ' ?>   Move ' // ?>
Freelance- : Started Not Started -Sharing query($Queryclient123); $num_rows = mysql_num_rows($nameclient2123); //$DB->Multicoloums(); ?>
  0) {*/ ?> ' ?>   Move ' // ?>