94 lines
5.1 KiB
PHP
94 lines
5.1 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
error_log("Start Printing Request Attributes");
|
|
$requestStr = "";
|
|
// foreach ($_REQUEST as $key => $value) {
|
|
// $requestStr .= $key . " : " . $value . "\n";
|
|
// error_log($key . " : " . $value . "<br />\r\n");
|
|
// }
|
|
error_log("End Printing Request Attributes");
|
|
save_log($requestStr, 'CSR PROGRAM', 'SAVE', 'save_csr_form.php');
|
|
$noOfRows = $_POST['count_items'];
|
|
error_log("rows: " . $noOfRows);
|
|
|
|
|
|
|
|
|
|
|
|
// $dis_agncy = $_POST['dis_agncy'];
|
|
|
|
//echo "hello".$noOfRows;
|
|
$program_name = $_REQUEST['program_name'];
|
|
$program_details = $_REQUEST['program_details'];
|
|
$program_location = $_REQUEST['program_location'];
|
|
$program_location=implode(',',$program_location);
|
|
|
|
$activity = $_REQUEST['activity'];
|
|
$activity=implode(',',$activity);
|
|
|
|
$start_date_time = $_REQUEST['start_date_time'];
|
|
$end_date_time = $_REQUEST['end_date_time'];
|
|
$coordinator = $_REQUEST['coordinator'];
|
|
$sub_coordinator = $_REQUEST['sub_coordinator'];
|
|
$remarks = $_REQUEST['remarks'];
|
|
$csr_id = $_REQUEST['csr_id'];
|
|
$type = $_REQUEST['type'];
|
|
$saleing = $_REQUEST['saleing'];
|
|
|
|
|
|
$total_budget = $_REQUEST['total_budget'];
|
|
$purpose = $_REQUEST['purpose'];
|
|
$program_code = $_REQUEST['program_code'];
|
|
$status = $_REQUEST['status'];
|
|
|
|
$approved_total_budget = $_REQUEST['approved_total_budget'];
|
|
$approved_target_beneficiary_count = $_REQUEST['approved_target_beneficiary_count'];
|
|
$approval_date_time = $_REQUEST['approval_date_time'];
|
|
$approver_remarks = $_REQUEST['approver_remarks'];
|
|
|
|
|
|
if (!empty($csr_id)) {
|
|
// $curr_status=getTableFieldValue('csr_program','status','csr_id',$csr_id);
|
|
// // error_log($curr_status);
|
|
// $approver_str='';
|
|
// if($status=='Approved' && $curr_status=='Pending'){
|
|
// $approver_str= ' , approver="'.$_SESSION['user_id'].'"';
|
|
// }
|
|
$sqlCSR = "UPDATE `csr_program` SET `program_name`='$program_name' $approver_str ,`approved_target_beneficiary_count`='$approved_target_beneficiary_count',`approver_remarks`='$approver_remarks',`approved_total_budget`='$approved_total_budget',`program_code`='$program_code',`purpose`='$purpose',`total_budget`='$total_budget',`program_details`='$program_details',`activity`='$activity',`location`='$program_location',`target_beneficiary_count`='$target_beneficiary_count',`start_date_time`='$start_date_time',`end_date_time`='$end_date_time',`coordinator_name`='$coordinator',`sub_coordinator_name`='$sub_coordinator',`total_participate`='$noOfRows',`remarks`='$remarks',`type`='$type',`saleing` = '$saleing',`status`='$status',`approval_date_time`='$approval_date_time' WHERE `csr_id`='$csr_id'";
|
|
} else {
|
|
$sqlCSR = "INSERT INTO `csr_program`(`program_code`,`purpose`,`program_name`, `program_details`,`activity`, `location`, `start_date_time`, `end_date_time`, `coordinator_name`, `sub_coordinator_name`, `total_participate`, `remarks`,`type`,`saleing`,`status`,`total_budget`,`target_beneficiary_count`,`approved_target_beneficiary_count`,`approver_remarks`,`approved_total_budget`,`approval_date_time`,`creater`) VALUES ('$program_code','$purpose','$program_name','$program_details','$activity','$program_location','$start_date_time','$end_date_time','$coordinator','$sub_coordinator','$noOfRows','$remarks','$type','$saleing','$status','$total_budget','$target_beneficiary_count','$approved_target_beneficiary_count','$approver_remarks','$approved_total_budget','$approval_date_time','".$_SESSION['user_id']."')";
|
|
}
|
|
|
|
error_log($sqlCSR . " CSR");
|
|
|
|
$result = mysqli_query($conn, $sqlCSR);
|
|
|
|
if (empty($csr_id)) {
|
|
$cid = mysqli_insert_id($conn);
|
|
} else {
|
|
$cid = $csr_id;
|
|
}
|
|
|
|
|
|
$query_initial = "";
|
|
$endquery = "";
|
|
begin();
|
|
$csr_id = $_REQUEST['csr_id'];
|
|
// for ($i = 0; $i < $noOfRows; $i++) {
|
|
// // $item_ids = implode(',', ${"item_id$i"});
|
|
// // error_log(${"participate_csr_program_id$i"} . " IDDDDD");
|
|
// if (!empty(${"participate_csr_program_id$i"})) {
|
|
// $query_initial = "UPDATE participate_csr_program set csr_id = '$cid', participate_type = '" . ${"participate_type$i"} . "', participate_name = '" . ${"participate_nameone$i"} . "',patient_id = '" . ${"participate_nametwo$i"} . "' , address = '" . ${"address$i"} . "' , contact = '" . ${"contact$i"} . "' ,vitals_check = '" . ${"vitals$i"} . "',item_id = '" . ${"item_id$i"} . "',unit = '" . ${"unit$i"} . "',qty = '" . ${"qty$i"} . "',total_cost = '" . ${"total_cost$i"} . "',remarks = '" . ${"remarks$i"} . "' where participate_csr_program_id = '" . ${"participate_csr_program_id$i"} . "' ";
|
|
// } else {
|
|
// $query_initial = "INSERT into participate_csr_program set csr_id = '$cid', participate_type = '" . ${"participate_type$i"} . "', participate_name = '" . ${"participate_nameone$i"} . "',patient_id = '" . ${"participate_nametwo$i"} . "' , address = '" . ${"address$i"} . "' , contact = '" . ${"contact$i"} . "' ,vitals_check = '" . ${"vitals$i"} . "',item_id = '" . ${"item_id$i"} . "',unit = '" . ${"unit$i"} . "',qty = '" . ${"qty$i"} . "',total_cost = '" . ${"total_cost$i"} . "',remarks = '" . ${"remarks$i"} . "'";
|
|
// }
|
|
// error_log($query_initial . " DM QUERY");
|
|
// if (!$result = @mysqli_query($conn, $query_initial)) {
|
|
// rollback();
|
|
// exit(error_log(mysqli_error($conn)));
|
|
// }
|
|
// }
|
|
commit();
|