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);
}
}
}
?>
date_default_timezone_set('Asia/Kolkata');
$date_new_123_free_job = date('Y-m-d', time());
$date_123_new_free_job = date('Y-m-d H:i:s ', time());
$Query_job_move_free_job = "SELECT id,job_create_date,job_priority from tbl_job_details where job_status='1' and q_freelance_status='1' and id NOT IN(SELECT job_id from `tbl_employee_changes`) ";
$name_s_free_job=$DB->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_job_qc = "SELECT id,emp_view,emp_view_date,job_est_time,job_assigned_time from tbl_job_details where job_status='1' and (freelance_id='1' || q_freelance_status='1') and id IN(SELECT job_id from `tbl_employee_changes`)";
$name_s_qc=$DB->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;?>
if($differenceInSeconds_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;
?>
if($date_dif>7)
{
?>
}
else
{
?>
'0')
{ ?> style="background-color:#9999FF;" } else { ?>
if($job_priority==8)
{
?>
style="background-color:#FF0000"
}
else
{
?>
class="odd gradeX warning"
}
} ?>>
}
?>
echo $id;?> |
$Query1_clie = "SELECT concern_name,local,local_status FROM `tbl_client_details` where id='$client_id' ";
$name2_clie=$DB->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();
?>
if($new_local==1 && $new_local_status==1)
{
$name_myt = mysql_query("SELECT * from tbl_local_due_time where job_id='$id' ");
$row12_myt = mysql_fetch_array($name_myt);
date_default_timezone_set('Asia/Kolkata');
$create_dat_123e=$row12_myt['due_sec'];
$emp_view_date_123 = date('Y-m-d H:i:s', time());
$dateinsec=strtotime($job_create_date);
$newdate=$dateinsec+$create_dat_123e;
?>
echo date('Y-m-d H:i A',$newdate);?>
echo date('Y-m-d H:i:s',$newdate);?>
echo date('Y-m-d h:i A',$newdate);?>
}
?>
|
query($Queryclient123);
$rowclient1233 = mysql_fetch_array($nameclient213);
//$DB->Multicoloums();
?>
" style="color:#337ab7"> |
|
echo $otime[0];?>: echo $otime[1];?>
--:--:--
|
if($emp_view=='1') { ?>Started } ?> if($emp_view=='0') { ?>Not Started } ?> if($share_status=='1') { ?> -Sharing } ?> |
|
query($Queryclient123);
$num_rows = mysql_num_rows($nameclient2123);
//$DB->Multicoloums();
?>
/*if($num_rows>0)
{*/
?>
'
?>
if($emp_view=='0') {
?>
Move
}
?>
/* }*/
?>
'
// ?>
|
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;
}
?>
if($num_qc_r_prime==0)
{
?>
'0')
{ ?> style="color:#9966FF" } else { ?> style="color:#FF0000" } ?> >
}
?>
if($num_qc_r_prime>0)
{
?>
'0')
{ ?> style="color:#9966FF" } else { ?> style="color:#9933FF" } ?> >
}
?>
echo $id;?>
|
$Query1_clie = "SELECT concern_name FROM `tbl_client_details` where id='$client_id' ";
$name2_clie=$DB->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();
?>
Freelance-
|
|
echo $otime[0];?>: echo $otime[1];?>
--:--:--
|
if($emp_view=='1') { ?>Started } ?> if($emp_view=='0') { ?>Not Started } ?> if($share_status=='1') { ?> -Sharing } ?> |
|
query($Queryclient123);
$num_rows = mysql_num_rows($nameclient2123);
//$DB->Multicoloums();
?>
/*if($num_rows>0)
{*/
?>
'
?>
if($emp_view=='0') {
?>
Move
}
?>
/* }*/
?>
'
// ?>
|
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" } else { ?> style="color:#CC6666" } ?> >
echo $id;?> |
$Query1_clie = "SELECT concern_name FROM `tbl_client_details` where id='$client_id' ";
$name2_clie=$DB->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();
?>
Freelance-
|
|
echo $otime[0];?>: echo $otime[1];?> |
if($emp_view=='1') { ?>Started } ?> if($emp_view=='0') { ?>Not Started } ?> if($share_status=='1') { ?> -Sharing } ?> |
|
query($Queryclient123);
$num_rows = mysql_num_rows($nameclient2123);
//$DB->Multicoloums();
?>
/*if($num_rows>0)
{*/
?>
'
?>
if($emp_view=='0') {
?>
Move
}
?>
/* }*/
?>
'
// ?>
|