86 lines
3.3 KiB
PHP
86 lines
3.3 KiB
PHP
<?php
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
include('includes/config/config.php');
|
|
|
|
$assign_checkup_id=$_REQUEST['assign_checkup_id'];
|
|
//echo $assign_checkup_id;
|
|
//echo dfjfhdjfj;
|
|
$credit_to=$_REQUEST['credit_to'];
|
|
$checkup_mgmt_name=$_REQUEST['checkup_mgmt_name'];
|
|
$checkup_schedule=$_REQUEST['schedule_id'];
|
|
$employee_cat="";
|
|
if($credit_to=='2')
|
|
$employee_cat=implode(",",$_REQUEST['employee_cat']);
|
|
|
|
|
|
$initquery="";
|
|
$endquery="";
|
|
if(!empty($assign_checkup_id)){
|
|
//update case
|
|
$initquery = "update ";
|
|
$endquery=" where assign_checkup_id = '".$assign_checkup_id."' ";
|
|
|
|
}
|
|
else {
|
|
//insert case
|
|
$initquery = "INSERT INTO ";
|
|
}
|
|
$query = $initquery." assign_checkup set credit_to = '".$credit_to."',date_assigned=STR_TO_DATE('".$_POST['assign_date']."', '%d/%m/%Y') , emp_cat_id='$employee_cat' ,assign_checkup_id='$assign_checkup_id',checkup_schedule='$schedule_id' $endquery ";
|
|
echo $query;
|
|
|
|
|
|
$result = @mysqli_query($conn,$query);
|
|
if(empty($assign_checkup_id))
|
|
$assign_checkup_id=@mysqli_insert_id();
|
|
//echo $assign_checkup_id;
|
|
if(!empty($assign_checkup_id)){
|
|
//update case
|
|
$query_delete_employee_assign_checkup="delete from employee_assign_checkup where assign_checkup_id='$assign_checkup_id'";
|
|
//echo $query_delete_employee_assign_checkup;
|
|
@mysqli_query($conn,$query_delete_employee_assign_checkup);
|
|
}
|
|
if($credit_to=='1'){
|
|
|
|
$query_employee="select id from employee";
|
|
//echo $query_employee;
|
|
$result_employee = @mysqli_query($conn,$query_employee);
|
|
//echo $result_employee;
|
|
while($row_employee=@mysqli_fetch_assoc($result_employee)){
|
|
//echo $row_employee['id'];
|
|
$query_employee_assign_checkup="insert into employee_assign_checkup set emp_id='".$row_employee['id']."' ,assign_checkup_id='$assign_checkup_id' ,checkup_schedule_id='$checkup_schedule' ,assign_date=STR_TO_DATE('".$_POST['assign_date']."', '%d/%m/%Y') ";
|
|
//echo $query_employee_assign_training;
|
|
@mysqli_query($conn,$query_employee_assign_checkup);
|
|
}
|
|
|
|
}else if($credit_to=='2'){
|
|
$emp_cat_id_array=$_REQUEST['employee_cat'];
|
|
$query_employee="select id from patient_master where ";
|
|
for($i=0;$i<count($emp_cat_id_array);$i++){
|
|
if($i==count($emp_cat_id_array)-1)
|
|
$query_employee=$query_employee.'emp_cat_id='.$emp_cat_id_array[$i];
|
|
else
|
|
$query_employee=$query_employee.'emp_cat_id='.$emp_cat_id_array[$i].' or ';
|
|
}
|
|
|
|
//echo $query_employee;
|
|
$result_employee = @mysqli_query($conn,$query_employee);
|
|
//echo $result_employee;
|
|
while($row_employee=@mysqli_fetch_assoc($result_employee)){
|
|
//echo $row_employee['id'];
|
|
$query_employee_assign_checkup="insert into employee_assign_checkup set emp_id='".$row_employee['id']."' ,assign_checkup_id='$assign_checkup_id',checkup_schedule_id='$checkup_schedule' ,assign_date=STR_TO_DATE('".$_POST['assign_date']."', '%d/%m/%Y') ";
|
|
//echo $query_employee_assign_checkup;
|
|
@mysqli_query($conn,$query_employee_assign_checkup);
|
|
}
|
|
|
|
} else if($credit_to=='3'){
|
|
|
|
$emp_cat_id_array=$_REQUEST['employee_cat'];
|
|
|
|
//echo $row_employee['id'];
|
|
$query_employee_assign_checkup="insert into employee_assign_checkup set emp_id='".$_REQUEST['employee_id']."' ,assign_checkup_id='$assign_checkup_id',checkup_schedule_id='$checkup_schedule' ,assign_date=STR_TO_DATE('".$_POST['assign_date']."', '%d/%m/%Y') ";
|
|
//echo $query_employee_assign_training;
|
|
@mysqli_query($conn,$query_employee_assign_checkup);
|
|
|
|
}
|
|
|
|
?>
|