public function add_bed_allotment($data)
{
global $wpdb;
$table_bedallotment = $wpdb->prefix . 'hmgt_bed_allotment';
$table_hmgt_assign_type = $wpdb->prefix . 'hmgt_assign_type';
$table_hmgt_guardian = $wpdb->prefix . 'hmgt_inpatient_guardian';
$table_hmgt_bed = $wpdb->prefix . 'hmgt_bed';
$table_hmgt_history = $wpdb->prefix . 'hmgt_history';
$table_hmgt_charges = $wpdb->prefix . 'hmgt_charges';
//-------usersmeta table data--------------
$bedallotmnetdata['bed_number'] = $data['bed_number'];
$bedallotmnetdata['bed_type_id'] = $_POST['bed_type_id'];
$bedallotmnetdata['patient_id'] = $_POST['patient_id'];
$bedallotmnetdata['patient_status'] = $_POST['patient_status'];
$bedallotmnetdata['allotment_date'] = $_POST['allotment_date'];
$bedallotmnetdata['discharge_time'] = $_POST['discharge_time'];
$bedallotmnetdata['allotment_description'] = $_POST['allotment_description'];
$bedallotmnetdata['created_date'] = date("Y-m-d");
$bedallotmnetdata['allotment_by'] = get_current_user_id();
$guardian = get_guardian_name($_POST['patient_id']);
$patient_satus['patient_status'] = $_POST['patient_status'];
$patient_id['patient_id'] = $_POST['patient_id'];
if (!empty($guardian)) {
$result = $wpdb->update($table_hmgt_guardian, $patient_satus, $patient_id);
} else {
$wpdb->insert($table_hmgt_guardian, array("patient_status" => $_POST['patient_status'], "patient_id" => $_POST['patient_id']));
}
if ($bedallotmnetdata['discharge_time'] >= date('Y-m-d')) {
$bed['status'] = 1;
$bedid['bed_id'] = $data['bed_number'];
//$result=$wpdb->update( $table_hmgt_bed, $bed,$bedid);
}
$history['patient_id'] = $_POST['patient_id'];
$history['status'] = $_POST['patient_status'];
$history['bed_number'] = $data['bed_number'];
if (!empty($guardian)) {
$history['guardian_name'] = $guardian->first_name . " " . $guardian->last_name;
} else {
$history['guardian_name'] = "";
}
$history['history_type'] = "bed_assign";
$history['history_date'] = date("Y-m-d H:i:s");
$history['created_by'] = get_current_user_id();
$bed_type = $this->get_bedtype_name($bedallotmnetdata['bed_type_id']);
$bed_number = $this->get_bed_number($bedallotmnetdata['bed_number']);
$charge_type = 'Bed charge';
$startTimeStamp = strtotime($bedallotmnetdata['allotment_date']);
$endTimeStamp = strtotime($bedallotmnetdata['discharge_time']);
$timeDiff = abs($endTimeStamp - $startTimeStamp);
$numberDays = $timeDiff / 86400;
// 86400 seconds in one day
// and you might want to convert to integer
$numberDays = intval($numberDays) + 1;
$get_bedrow = $this->get_single_bed($bedallotmnetdata['bed_number']);
$single_bed_charge = $get_bedrow->bed_charges;
$total_bed_charge = $single_bed_charge * $numberDays;
$charge_data['charge_label'] = 'Bed Charges';
$charge_data['charge_type'] = 'bed';
$charge_data['room_number'] = $bed_number;
$charge_data['bed_type'] = $bed_type;
$charge_data['charges'] = $total_bed_charge;
$charge_data['patient_id'] = $bedallotmnetdata['patient_id'];
$charge_data['status'] = 0;
$charge_data['created_date'] = date("Y-m-d");
$charge_data['created_by'] = get_current_user_id();
if ($data['action'] == 'edit') {
$allotmentid['bed_allotment_id'] = $data['allotment_id'];
$charge_referid['refer_id'] = $data['allotment_id'];
$charge_referid['charge_type'] = 'bed';
$result = $wpdb->update($table_bedallotment, $bedallotmnetdata, $allotmentid);
$this->delete_assign_byparent($allotmentid['bed_allotment_id']);
if (!empty($data['nurse'])) {
foreach ($data['nurse'] as $id) {
$assign_data['child_id'] = $id;
$assign_data['parent_id'] = $allotmentid['bed_allotment_id'];
$assign_data['assign_type'] = 'nurse-bedallotment';
$assign_data['assign_date'] = date("Y-m-d");
$assign_data['assign_by'] = get_current_user_id();
$wpdb->insert($table_hmgt_assign_type, $assign_data);
}
}
$wpdb->update($table_hmgt_charges, $charge_data, $charge_referid);
hmgt_append_audit_log('update bed allotment detail ', get_current_user_id());
return $result;
} else {
$result = $wpdb->insert($table_bedallotment, $bedallotmnetdata);
$allotment_id = $wpdb->insert_id;
hmgt_append_audit_log('Add new bed allotment ', get_current_user_id());
if (!empty($data['nurse'])) {
foreach ($data['nurse'] as $id) {
$assign_data['child_id'] = $id;
$assign_data['parent_id'] = $allotment_id;
$assign_data['assign_type'] = 'nurse-bedallotment';
$assign_data['assign_date'] = date("Y-m-d");
$assign_data['assign_by'] = get_current_user_id();
$wpdb->insert($table_hmgt_assign_type, $assign_data);
}
}
$charge_data['refer_id'] = $allotment_id;
$history['parent_id'] = $allotment_id;
$wpdb->insert($table_hmgt_charges, $charge_data);
$wpdb->insert($table_hmgt_history, $history);
return $result;
}
}
public function hmgt_add_operation_theater($data)
{
global $wpdb;
$table_ot = $wpdb->prefix . 'hmgt_ot';
$table_hmgt_assign_type = $wpdb->prefix . 'hmgt_assign_type';
$table_hmgt_charges = $wpdb->prefix . 'hmgt_charges';
$table_hmgt_history = $wpdb->prefix . 'hmgt_history';
$table_hmgt_guardian = $wpdb->prefix . 'hmgt_inpatient_guardian';
//-------usersmeta table data--------------
$ot_data['operation_title'] = $data['operation_title'];
$ot_data['patient_id'] = $data['patient_id'];
$ot_data['patient_status'] = $data['patient_status'];
$ot_data['bed_type_id'] = $data['bed_type_id'];
$ot_data['bednumber'] = $data['bednumber'];
$ot_data['operation_date'] = $data['operation_date'];
$ot_data['operation_time'] = $data['operation_time'];
$ot_data['ot_description'] = $data['ot_description'];
$ot_data['operation_charge'] = $data['operation_charge'];
$ot_data['ot_create_date'] = date("Y-m-d");
$ot_data['ot_create_by'] = get_current_user_id();
// $ot_data['doctor_id']=$data['doctor'];
$guardian = get_guardian_name($_POST['patient_id']);
$history['patient_id'] = $_POST['patient_id'];
$history['status'] = $_POST['patient_status'];
$history['bed_number'] = $data['bednumber'];
if (!empty($guardian)) {
$history['guardian_name'] = $guardian->first_name . " " . $guardian->last_name;
} else {
$history['guardian_name'] = "";
}
$history['history_type'] = "operation";
$history['history_date'] = date("Y-m-d H:i:s");
$history['created_by'] = get_current_user_id();
$bed_type = $this->get_bedtype_name($ot_data['bed_type_id']);
$bed_number = $this->get_bed_number($ot_data['bednumber']);
$get_bedrow = $this->get_single_bed($ot_data['bednumber']);
$single_bed_charge = $get_bedrow->bed_charges;
$total_bed_charge = $single_bed_charge + $ot_data['operation_charge'];
$charge_data['charge_label'] = 'operation Charge';
$charge_data['charge_type'] = 'operation';
$charge_data['room_number'] = $bed_number;
$charge_data['bed_type'] = $bed_type;
$charge_data['charges'] = $total_bed_charge;
$charge_data['patient_id'] = $ot_data['patient_id'];
$charge_data['status'] = 0;
//$charge_data['refer_id']=1;
$charge_data['created_date'] = date("Y-m-d");
$charge_data['created_by'] = get_current_user_id();
$patient_satus['patient_status'] = $_POST['patient_status'];
$patient_id['patient_id'] = $_POST['patient_id'];
if (!empty($guardian)) {
$result = $wpdb->update($table_hmgt_guardian, $patient_satus, $patient_id);
} else {
$wpdb->insert($table_hmgt_guardian, array("patient_status" => $_POST['patient_status'], "patient_id" => $_POST['patient_id']));
}
//$result=$wpdb->update( $table_hmgt_guardian, $patient_satus,$patient_id);
if ($data['action'] == 'edit') {
$ot_id['operation_id'] = $data['operation_id'];
$charge_referid['refer_id'] = $data['operation_id'];
$charge_referid['charge_type'] = 'operation';
$result = $wpdb->update($table_ot, $ot_data, $ot_id);
$this->delete_assign_byparant($ot_id['operation_id']);
if (!empty($data['doctor'])) {
foreach ($data['doctor'] as $id) {
$assign_data['child_id'] = $id;
$assign_data['parent_id'] = $data['operation_id'];
$assign_data['assign_type'] = 'operation_theater';
$assign_data['assign_date'] = date("Y-m-d");
$assign_data['assign_by'] = get_current_user_id();
$wpdb->insert($table_hmgt_assign_type, $assign_data);
}
}
$wpdb->update($table_hmgt_charges, $charge_data, $charge_referid);
hmgt_append_audit_log('Update operation detail ', get_current_user_id());
return $result;
} else {
$result = $wpdb->insert($table_ot, $ot_data);
$ot_id = $wpdb->insert_id;
$charge_data['refer_id'] = $ot_id;
if (!empty($data['doctor'])) {
foreach ($data['doctor'] as $id) {
$assign_data['child_id'] = $id;
$assign_data['parent_id'] = $ot_id;
$assign_data['assign_type'] = 'operation_theater';
$assign_data['assign_date'] = date("Y-m-d");
$assign_data['assign_by'] = get_current_user_id();
$wpdb->insert($table_hmgt_assign_type, $assign_data);
}
}
hmgt_append_audit_log('Add new operation detail ', get_current_user_id());
$wpdb->insert($table_hmgt_charges, $charge_data);
$wpdb->insert($table_hmgt_history, $history);
return $result;
}
return $result;
}
