public static function update_facility_order_details_table($data_array)
{
$o = new facility_order_details();
$o->fromArray($data_array);
$o->save();
return TRUE;
}
public function aggragate_order_new_sorf($order_id)
{
$order_id_array = explode("_", $order_id);
$facility_name = array();
$order_id = array();
$order_total = array("", "", "", "");
$order_total_all = 0;
$order_total_all_items = 0;
foreach ($order_id_array as $single_order_id) {
//get the facility names from the orders
if ($single_order_id > 0) {
$test = facility_orders::get_order_($single_order_id);
$order_id = array_merge($order_id, array($single_order_id));
foreach ($test as $test_) {
$order_total = array_merge($order_total, array("", $test_->order_total));
$order_total_all = $order_total_all + $test_->order_total;
foreach ($test_->facility_detail as $facility_data) {
array_push($facility_name, "{$facility_data->facility_name}", '');
}
}
}
}
array_push($order_total, $order_total_all);
array_push($facility_name, "TOTAL");
//combine all of them
$stock_data = Commodities::get_all_from_supllier(1);
$from_stock_data = count($stock_data);
//get items from a supplier
$excel_data = array('doc_creator' => "HCMP", 'doc_title' => 'test ', 'file_name' => 'test');
$row_data = array(array("Product Code", "Item description(Name/form/strength)", "Order unit size", "Price"));
foreach ($order_id as $order_id_) {
array_push($row_data[0], "Quantity to Order", "Total");
//push this to go with each facility
}
$column_data = array("", "", "FACILITY NAME", "");
$column_data = array_merge($column_data, $facility_name);
$excel_data['column_data'] = $column_data;
for ($i = 0; $i < $from_stock_data; $i++) {
$total_all = 0;
$temp_array = array();
$temp_array_ = array();
if ($i == 0) {
//push the first sub category
array_push($row_data, array($stock_data[$i]["sub_category_name"], "", "", "", ""));
} else {
if ($stock_data[$i]['sub_category_name'] != $stock_data[$i - 1]['sub_category_name']) {
//push the first sub category
array_push($row_data, array($stock_data[$i]["sub_category_name"], "", "", "", ""));
}
}
foreach ($order_id as $order_id_) {
$total = facility_order_details::get_order_details_from_order($order_id_, $stock_data[$i]["commodity_id"]);
if (count($total) == 0) {
array_push($temp_array, 0, 0);
} else {
$total_ = $total[0]['total'] * str_replace(",", '', $stock_data[$i]["unit_cost"]);
array_push($temp_array, $total[0]['total'], $total_);
$total_all = $total_all + $total_;
$order_total_all_items = $order_total_all_items + $total_;
}
}
$temp_array_ = array($stock_data[$i]["commodity_code"], $stock_data[$i]["commodity_name"], $stock_data[$i]["unit_size"], $stock_data[$i]["unit_cost"]);
$temp_array_ = array_merge($temp_array_, $temp_array);
array_push($temp_array_, $total_all);
array_push($row_data, $temp_array_);
}
array_push($row_data, $order_total);
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
}
public function create_order_delivery_color_coded_table($order_id)
{
// get the order and order details here
$detail_list = facility_order_details::get_order_details($order_id, true);
$dates = facility_orders::get_order_($order_id)->toArray();
$facility_name = Facilities::get_facility_name_($dates[0]['facility_code'])->toArray();
$facility_name = $facility_name[0]['facility_name'];
//set up the details
$table_body = "";
$total_fill_rate = 0;
$order_value = 0;
//get the lead time
$ts1 = strtotime(date($dates[0]["order_date"]));
$ts2 = strtotime(date($dates[0]["deliver_date"]));
$seconds_diff = $ts2 - $ts1;
//strtotime($a_date) ? date('d M, Y', strtotime($a_date)) : "N/A";
$date_diff = strtotime($dates[0]["deliver_date"]) ? floor($seconds_diff / 3600 / 24) : "N/A";
$order_date = strtotime($dates[0]["order_date"]) ? date('D j M, Y', $ts1) : "N/A";
$deliver_date = strtotime($dates[0]["deliver_date"]) ? date('D j M, Y', $ts2) : "N/A";
$kemsa_order_no = $dates[0]['kemsa_order_id'];
$order_total = number_format($dates[0]['order_total'], 2, '.', ',');
$actual_order_total = number_format($date[0]['deliver_total'], 2, '.', ',');
$tester = count($detail_list);
if ($tester == 0) {
} else {
foreach ($detail_list as $rows) {
//setting the values to display
$received = $rows['quantity_recieved'];
$price = $rows['unit_cost'];
$ordered = $rows['quantity_ordered_unit'];
$code = $rows['commodity_id'];
$drug_name = $rows['commodity_name'];
$kemsa_code = $rows['commodity_code'];
$unit_size = $rows['unit_size'];
$total_units = $rows['total_commodity_units'];
$cat_name = $rows['sub_category_name'];
$received = round(@$received / $total_units);
$fill_rate = round(@($received / $ordered) * 100);
$total = $price * $ordered;
$total_ = $price * $received;
$total_fill_rate = $total_fill_rate + $fill_rate;
switch (true) {
case $fill_rate == 0:
$table_body .= "<tr style='background-color: #FBBBB9;'>";
$table_body .= "<td>{$cat_name}</td>";
$table_body .= '<td>' . $drug_name . '</td><td>' . $kemsa_code . '</td>' . '<td>' . $unit_size . '</td>';
$table_body .= '<td>' . $price . '</td>';
$table_body .= '<td>' . $ordered . '</td>';
$table_body .= '<td>' . number_format($total, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $received . '</td>';
$table_body .= '<td>' . number_format($total_, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $fill_rate . '% ' . '</td>';
$table_body .= '</tr>';
break;
case $fill_rate <= 60:
$table_body .= "<tr style=' background-color: #FAF8CC;'>";
$table_body .= "<td>{$cat_name}</td>";
$table_body .= '<td>' . $drug_name . '</td><td>' . $kemsa_code . '</td>' . '<td>' . $unit_size . '</td>';
$table_body .= '<td>' . $price . '</td>';
$table_body .= '<td>' . $ordered . '</td>';
$table_body .= '<td>' . number_format($total, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $received . '</td>';
$table_body .= '<td>' . number_format($total_, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $fill_rate . '% ' . '</td>';
$table_body .= '</tr>';
break;
case $fill_rate > 100.01:
case $fill_rate == 100.01:
$table_body .= "<tr style='background-color: #ea1e17'>";
$table_body .= "<td>{$cat_name}</td>";
$table_body .= '<td>' . $drug_name . '</td><td>' . $kemsa_code . '</td>' . '<td>' . $unit_size . '</td>';
$table_body .= '<td>' . $price . '</td>';
$table_body .= '<td>' . $ordered . '</td>';
$table_body .= '<td>' . number_format($total, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $received . '</td>';
$table_body .= '<td>' . number_format($total_, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $fill_rate . '% ' . '</td>';
$table_body .= '</tr>';
break;
case $fill_rate == 100:
$table_body .= "<tr style=' background-color: #C3FDB8;'>";
$table_body .= "<td>{$cat_name}</td>";
$table_body .= '<td>' . $drug_name . '</td><td>' . $kemsa_code . '</td>' . '<td>' . $unit_size . '</td>';
$table_body .= '<td>' . $price . '</td>';
$table_body .= '<td>' . $ordered . '</td>';
$table_body .= '<td>' . number_format($total, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $received . '</td>';
$table_body .= '<td>' . number_format($total_, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $fill_rate . '% ' . '</td>';
$table_body .= '</tr>';
break;
default:
$table_body .= "<tr>";
$table_body .= "<td>{$cat_name}</td>";
$table_body .= '<td>' . $drug_name . '</td><td>' . $kemsa_code . '</td>' . '<td>' . $unit_size . '</td>';
$table_body .= '<td>' . $price . '</td>';
$table_body .= '<td>' . $ordered . '</td>';
$table_body .= '<td>' . number_format($total, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $received . '</td>';
$table_body .= '<td>' . number_format($total_, 2, '.', ',') . '</td>';
$table_body .= '<td>' . $fill_rate . '% ' . '</td>';
$table_body .= '</tr>';
break;
}
}
$order_value = round($total_fill_rate / count($detail_list), 0, PHP_ROUND_HALF_UP);
}
$message = <<<HTML_DATA
\t<table>
\t\t\t<tr>
\t\t<th colspan='11'>
\t\t<p>{$facility_name}</p>
\t\t<p>Fill rate(Quantity Ordered/Quantity Received)</p>
<p style="letter-spacing: 1px;font-weight: bold;text-shadow: 0 1px rgba(0, 0, 0, 0.1);">
Facility Order No {$order_id}| KEMSA Order No {$kemsa_order_no} | Total ordered value(ksh) {$order_total} | Total recieved order value(ksh) {$actual_order_total} |Date Ordered {$order_date}| Date Delivered {$deliver_date}| Order lead Time {$date_diff}; day(s)</p>
\t\t</th>
\t\t</tr>
\t\t<tr>
\t\t<th width="50px" style="background-color: #C3FDB8; "></th>
\t\t<th>Full Delivery 100%</th>
\t\t<th width="50px" style="background-color:#FFFFFF"></th>
\t\t<th>Ok Delivery 60%-less than 100%</th>
\t\t<th width="50px" style="background-color:#FAF8CC;"></th>
\t\t<th>Partial Delivery less than 60% </th>
\t\t<th width="50px" style="background-color:#FBBBB9;"></th>
\t\t<th>Problematic Delivery 0% </th>
\t\t<th width="50px" style="background-color:#ea1e17;"></th>
\t\t<th>Problematic Delivery over 100%</th>
\t\t</tr></table> </br></n>
<table id="main1" width="100%" class="row-fluid table table-bordered">
\t<thead>
\t\t<tr>
\t\t<th><strong>Category</strong></th>
\t\t<th><strong>Description</strong></th>
\t\t<th><strong>Commodity Code</strong></th>
\t\t<th><strong>Unit Size</strong></th>
\t\t<th><strong>Unit Cost Ksh</strong></th>
\t\t<th><strong>Quantity Ordered</strong></th>
\t\t<th><strong>Total Cost</strong></th>
\t\t<th><strong>Quantity Received</strong></th>
\t\t<th><strong>Total Cost</strong></th>
\t\t<th><strong>Fill rate</strong></th>\t
\t\t</tr>
\t</thead>
\t<tbody>\t
\t\t {$table_body}\t
\t</tbody>
</table>
<br></n>
HTML_DATA;
return array('table' => $message, 'date_ordered' => $order_date, 'date_received' => $deliver_date, 'order_total' => $order_total, 'actual_order_total' => $actual_order_total, 'lead_time' => $date_diff, 'facility_name' => $facility_name);
}
public function update_meds_order_delivery($order_id)
{
$facility_code = $this->session->userdata('facility_id');
$data['content_view'] = "facility/facility_orders/update_order_delivery_from_meds_v";
$data['title'] = "Facility Update Order Delivery";
$data['facility_commodity_list'] = Commodities::get_all_from_meds(2);
$data['order_details'] = facility_order_details::get_order_details($order_id);
$data['general_order_details'] = facility_orders::get_order_($order_id);
$data['banner_text'] = "Facility MEDS Update Order Delivery";
$ordered_by = $data['general_order_details'][0]['ordered_by'];
$data['ordered_by'] = users::get_user_names($ordered_by);
$this->load->view('shared_files/template/template', $data);
}
public function update_order_delivery($order_id)
{
$facility_code = $this->session->userdata('facility_id');
$data['content_view'] = "facility/facility_orders/update_order_delivery_from_kemsa_v";
$data['title'] = "Facility Update Order Delivery";
$data['facility_commodity_list'] = Commodities::get_all_from_supllier(1);
$data['order_details'] = facility_order_details::get_order_details($order_id);
$data['general_order_details'] = facility_orders::get_order_($order_id);
$data['banner_text'] = "Facility Update Order Delivery";
$this->load->view('shared_files/template/template', $data);
}
