379 lines
18 KiB
PHP
379 lines
18 KiB
PHP
|
<?php include('techsyn_header.php');
|
||
|
|
error_reporting(E_ERROR | E_WARNING | E_PARSE);
|
||
|
|
?>
|
||
|
|
<!-- Main Content Container for sid and body-->
|
||
|
|
<div class="main-container ace-save-state" id="main-container">
|
||
|
|
<script type="text/javascript">
|
||
|
|
try {
|
||
|
|
ace.settings.loadState('main-container')
|
||
|
|
} catch (e) {}
|
||
|
|
</script>
|
||
|
|
<?php include('techsyn_sidebar.php'); ?>
|
||
|
|
|
||
|
|
<!--breadcrumb-->
|
||
|
|
<?php
|
||
|
|
|
||
|
|
?>
|
||
|
|
|
||
|
|
<div class="main-content">
|
||
|
|
<div class="main-content-inner">
|
||
|
|
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
|
||
|
|
<ul class="breadcrumb">
|
||
|
|
<li class="active">Upload Excel For CSR Program List</li>
|
||
|
|
<li class="active">Upload Excel</li>
|
||
|
|
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<!-- End of breadcrumb -->
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="box-body" style="overflow: scroll; background-color: white;">
|
||
|
|
<form action="" method="post" name="frmExcelImport" id="frmExcelImport" enctype="multipart/form-data">
|
||
|
|
<!-- <div class="panel panel-info" style="margin-top:50px"> -->
|
||
|
|
|
||
|
|
<!-- <div class="panel-heading"><b</b></div> -->
|
||
|
|
<div class="panel-body">
|
||
|
|
|
||
|
|
<div class="form-group">
|
||
|
|
<!-- <div class="col-xs-1">
|
||
|
|
</div> -->
|
||
|
|
<div class="col-xs-9">
|
||
|
|
<!-- <div style="margin-top: 20px;" class='row col-xs-9'>
|
||
|
|
|
||
|
|
<label align='left' style="width:365px;">Usage
|
||
|
|
Date</label>
|
||
|
|
<div class="input style="color: black;"-group date" style="width:20%">
|
||
|
|
|
||
|
|
<div class="input style="color: black;"-group-addon">
|
||
|
|
<i class="fa fa-calendar"></i>
|
||
|
|
</div>
|
||
|
|
<input style="color: black;" class="form-control date-picker" name="proc_date<?= $i ?>"
|
||
|
|
id="proc_date<?= $i ?>" type="text"
|
||
|
|
value="<?php echo date_format(date_create($row_proc['usage_date']), "d/m/Y") ?>"
|
||
|
|
data-date-format="dd/mm/yyyy" />
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
</div> -->
|
||
|
|
<?php
|
||
|
|
$inserts = 0;
|
||
|
|
$updates = 0;
|
||
|
|
$temp_csr_program_id = $_REQUEST['temp_csr_program_id'];
|
||
|
|
$temp_csr_program_id = explode(',', $temp_csr_program_id);
|
||
|
|
error_log('interm id= ' . $temp_csr_program_id);
|
||
|
|
?>
|
||
|
|
<table>
|
||
|
|
|
||
|
|
|
||
|
|
<tr style="background-color: #eeeeee; color:black;">
|
||
|
|
<td align="center"><strong>Program Name</td>
|
||
|
|
<td align="center"><strong>PROGRAM DETAILS</td>
|
||
|
|
<td align="center"><strong>PROGRAM LOCATION</td>
|
||
|
|
<td align="center"><strong>START DATE TIME</td>
|
||
|
|
<td align="center"><strong>END DATE TIME</td>
|
||
|
|
<td align="center"><strong>COORDINATOR NAME</td>
|
||
|
|
<td align="center"><strong>SUB-COORDINATOR NAME</td>
|
||
|
|
<td align="center"><strong>TOTAL PARTICIPATE</td>
|
||
|
|
<td align="center"><strong>PROGRAM REMARKS</td>
|
||
|
|
<td align="center"><strong>PARTICIPANT TYPE</td>
|
||
|
|
<td align="center"><strong>PARTICIPATE NAME</td>
|
||
|
|
<td align="center"><strong>ADDRESS</td>
|
||
|
|
<td align="center"><strong>PHONE</td>
|
||
|
|
<td align="center"><strong>VITALS CHECKED</td>
|
||
|
|
<td align="center"><strong>ITEMS GIVEN</td>
|
||
|
|
<td align="center"><strong>TOTAL COST</td>
|
||
|
|
<td align="center"><strong>REMARKS</td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
for ($i = 0; $i < count($temp_csr_program_id); $i++) {
|
||
|
|
if ($temp_csr_program_id[$i] != null || $temp_csr_program_id[$i] != '' || $temp_csr_program_id[$i] != 0) {
|
||
|
|
$ref_no = '';
|
||
|
|
?>
|
||
|
|
<?php $proc_item_sql = "select * from temporary_csr_program where temp_csr_id='" . $temp_csr_program_id[$i] . "'";
|
||
|
|
|
||
|
|
error_log($proc_item_sql);
|
||
|
|
|
||
|
|
$result_item_sql = mysqli_query($conn, $proc_item_sql);
|
||
|
|
$num = mysqli_num_rows($result_item_sql);
|
||
|
|
if ($num != 0 || $num != null) {
|
||
|
|
?>
|
||
|
|
<tr>
|
||
|
|
<?php
|
||
|
|
|
||
|
|
while ($row_item_proc = mysqli_fetch_array($result_item_sql)) {
|
||
|
|
error_log('update_q' . $proc_item_update);
|
||
|
|
$date = date_create($row_item_proc['usage_date']);
|
||
|
|
$usage_date = date_format($date, "d-m-Y");
|
||
|
|
?>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="program_name<?php echo $i ?>" id="program_name<?php echo $i ?>" value="<?php echo $row_item_proc['program_name'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="program_details<?php echo $i ?>" id="program_details<?php echo $i ?>" value="<?php echo $row_item_proc['program_details'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="location<?php echo $i ?>" id="location<?php echo $i ?>" value="<?php echo $row_item_proc['location'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="start_date_time<?php echo $i ?>" id="start_date_time<?php echo $i ?>" value="<?php echo $row_item_proc['start_date_time'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="end_date_time<?php echo $i ?>" id="end_date_time<?php echo $i ?>" value="<?php echo $row_item_proc['end_date_time'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="coordinator_name<?php echo $i ?>" id="coordinator_name<?php echo $i ?>" value="<?php echo $row_item_proc['coordinator_name'] ?>">
|
||
|
|
</td>
|
||
|
|
<td><input style="color: black;" type="text" name="sub_coordinator_name<?php echo $i ?>" id="sub_coordinator_name<?php echo $i ?>" value="<?php echo $row_item_proc['sub_coordinator_name'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="total_participate<?php echo $i ?>" id="total_participate<?php echo $i ?>" value="<?php echo $row_item_proc['total_participate'] ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
|
||
|
|
<td><input style="color: black;" type="text" name="remarks<?php echo $i ?>" id="remarks<?php echo $i ?>" value="<?php echo $row_item_proc['remarks'] ?>">
|
||
|
|
</td>
|
||
|
|
<?php
|
||
|
|
$participate_type = getFieldFromTable('participate_type', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="participate_type<?php echo $i ?>" id="participate_type<?php echo $i ?>" value="<?php echo $participate_type ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$participate_name = getFieldFromTable('participate_name', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="participate_name<?php echo $i ?>" id="participate_name<?php echo $i ?>" value="<?php echo $participate_name ?>">
|
||
|
|
</td>
|
||
|
|
<?php
|
||
|
|
$address = getFieldFromTable('address', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="address<?php echo $i ?>" id="address<?php echo $i ?>" value="<?php echo $address ?>">
|
||
|
|
</td>
|
||
|
|
<?php
|
||
|
|
$contact = getFieldFromTable('contact', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="contact<?php echo $i ?>" id="contact<?php echo $i ?>" value="<?php echo $contact ?>">
|
||
|
|
</td>
|
||
|
|
<?php
|
||
|
|
$vitals_check = getFieldFromTable('vitals_check', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="vitals_check<?php echo $i ?>" id="vitals_check<?php echo $i ?>" value="<?php echo $vitals_check ?>">
|
||
|
|
</td>
|
||
|
|
<?php
|
||
|
|
$item_id = getFieldFromTable('item_id', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="ambulance_details<?php echo $i ?>" id="ambulance_details<?php echo $i ?>" value="<?php echo $item_id ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$total_cost = getFieldFromTable('total_cost', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="ambulance_details<?php echo $i ?>" id="ambulance_details<?php echo $i ?>" value="<?php echo $total_cost ?>">
|
||
|
|
</td>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$remarks = getFieldFromTable('remarks', 'temporary_participate_csr_program', 'temp_csr_id', $row_item_proc['temp_csr_id']);
|
||
|
|
?>
|
||
|
|
<td><input style="color: black;" type="text" name="ambulance_details<?php echo $i ?>" id="ambulance_details<?php echo $i ?>" value="<?php echo $remarks ?>">
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
|
||
|
|
} ?>
|
||
|
|
<?php }
|
||
|
|
}
|
||
|
|
} ?>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</form>
|
||
|
|
<center>
|
||
|
|
<button type="button" onclick="approve_usage()" name="import" value="1" id="submit" class="btn btn-primary">
|
||
|
|
Approve</button>
|
||
|
|
<button type="button" onclick="delete_interm()" name="cancel" id="cancel" class="btn ">
|
||
|
|
Cancel</button>
|
||
|
|
</center>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
<?php include('techsyn_footer.php'); ?>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<style>
|
||
|
|
body {
|
||
|
|
font-family: Arial;
|
||
|
|
width: 100%;
|
||
|
|
}
|
||
|
|
|
||
|
|
.outer-container {
|
||
|
|
background: #F0F0F0;
|
||
|
|
border: #e0dfdf 1px solid;
|
||
|
|
padding: 40px 20px;
|
||
|
|
border-radius: 2px;
|
||
|
|
}
|
||
|
|
|
||
|
|
.btn-submit {
|
||
|
|
background: #333;
|
||
|
|
border: #1d1d1d 1px solid;
|
||
|
|
border-radius: 2px;
|
||
|
|
color: #f0f0f0;
|
||
|
|
cursor: pointer;
|
||
|
|
padding: 5px 20px;
|
||
|
|
font-size: 0.9em;
|
||
|
|
}
|
||
|
|
|
||
|
|
.tutorial-table {
|
||
|
|
margin-top: 40px;
|
||
|
|
font-size: 0.8em;
|
||
|
|
border-collapse: collapse;
|
||
|
|
width: 100%;
|
||
|
|
}
|
||
|
|
|
||
|
|
.tutorial-table th {
|
||
|
|
background: #f0f0f0;
|
||
|
|
border-bottom: 1px solid #dddddd;
|
||
|
|
padding: 8px;
|
||
|
|
text-align: left;
|
||
|
|
}
|
||
|
|
|
||
|
|
.tutorial-table td {
|
||
|
|
background: #FFF;
|
||
|
|
border-bottom: 1px solid #dddddd;
|
||
|
|
padding: 8px;
|
||
|
|
text-align: left;
|
||
|
|
}
|
||
|
|
|
||
|
|
#response {
|
||
|
|
padding: 10px;
|
||
|
|
margin-top: 10px;
|
||
|
|
border-radius: 2px;
|
||
|
|
display: none;
|
||
|
|
}
|
||
|
|
|
||
|
|
.success {
|
||
|
|
background: #c7efd9;
|
||
|
|
border: #bbe2cd 1px solid;
|
||
|
|
}
|
||
|
|
|
||
|
|
.error {
|
||
|
|
background: #fbcfcf;
|
||
|
|
border: #f3c6c7 1px solid;
|
||
|
|
}
|
||
|
|
|
||
|
|
div#response.display-block {
|
||
|
|
display: block;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
<script>
|
||
|
|
$('#frmExcelImport').on('submit', function(event) {
|
||
|
|
event.preventDefault();
|
||
|
|
$.ajax({
|
||
|
|
url: "upload_excel_procurement_script.php",
|
||
|
|
method: "POST",
|
||
|
|
data: new FormData(this),
|
||
|
|
contentType: false,
|
||
|
|
processData: false,
|
||
|
|
dataType: 'json',
|
||
|
|
success: function(data) {
|
||
|
|
|
||
|
|
location.href = 'upload_excel_procurement_script.php';
|
||
|
|
},
|
||
|
|
error: function(data) {
|
||
|
|
BootstrapDialog.alert('Data uploading failed');
|
||
|
|
}
|
||
|
|
});
|
||
|
|
})
|
||
|
|
|
||
|
|
|
||
|
|
function delete_interm() {
|
||
|
|
let usage_id = <?php $interm_id = $_REQUEST['temp_csr_program_id'];
|
||
|
|
$interm_id = explode(',', $interm_id);
|
||
|
|
echo json_encode($interm_id);
|
||
|
|
|
||
|
|
?>;
|
||
|
|
BootstrapDialog.confirm('Are you sure to Cancel CSR Program ?', function(result) {
|
||
|
|
if (result) {
|
||
|
|
$.ajax({
|
||
|
|
url: 'delete_temp_csr_pro_upload.php',
|
||
|
|
type: "POST",
|
||
|
|
success: function(data) {
|
||
|
|
BootstrapDialog.alert('CSR Program Deleted Successfully.');
|
||
|
|
location.href = 'csr_pro_list.php';
|
||
|
|
return;
|
||
|
|
},
|
||
|
|
error: function(data) {
|
||
|
|
BootstrapDialog.alert('Error Deleting CSR Program');
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
}
|
||
|
|
})
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
function approve_usage() {
|
||
|
|
let usage_id = <?php $interm_id = $_REQUEST['temp_csr_program_id'];
|
||
|
|
$interm_id = explode(',', $interm_id);
|
||
|
|
|
||
|
|
echo json_encode($interm_id);
|
||
|
|
|
||
|
|
?>;
|
||
|
|
|
||
|
|
BootstrapDialog.confirm('Are you sure to ' +
|
||
|
|
'<?php if ($updates != 0) {
|
||
|
|
echo 'Update :' . $updates . ',';
|
||
|
|
} ?>' +
|
||
|
|
'<?php if ($inserts != 0) {
|
||
|
|
echo 'Insert :' . $inserts;
|
||
|
|
} ?>' + ' CSR Program Data ?',
|
||
|
|
function(result) {
|
||
|
|
if (result) {
|
||
|
|
$.ajax({
|
||
|
|
url: 'upload_excel_csr_script.php',
|
||
|
|
type: "POST",
|
||
|
|
data: {
|
||
|
|
|
||
|
|
usage_id: usage_id,
|
||
|
|
},
|
||
|
|
success: function(data) {
|
||
|
|
|
||
|
|
BootstrapDialog.alert('CSR Program Data Save Successfully.');
|
||
|
|
location.href = 'csr_pro_list.php';
|
||
|
|
return;
|
||
|
|
},
|
||
|
|
error: function(data) {
|
||
|
|
BootstrapDialog.alert('Error CSR Program Data ');
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
</script>
|