public function RH_report($facility = NULL)
{
//Used to pick the kemsa code and assign it to elements displayed on the report
$rhtable = '';
if ($facility == NULL) {
$facility = $this->session->userdata('facility_id');
}
$user_id = $this->session->userdata('user_id');
$facility_info = tb_data::get_facility_name($facility);
$district_name_ = Districts::get_district_name_($facility_district);
$district_name = $this->session->userdata('district');
$data['facility_code'] = $facility_info['facility_code'];
$data['district_region_name'] = $district_name_['district'];
$data['facility_name'] = $facility_info['facility_name'];
$data['facility_type_'] = $facility_info['owner'];
$data['rh_data'] = $this->createrhreport($facility);
$data['content_view'] = "facility/facility_reports/facility_reports_RH_reports_v";
$data['sidebar'] = "shared_files/report_templates/side_bar_v";
$data['title'] = "RH Report";
$data['banner_text'] = "Facility RH Commodities Order";
// $view = 'shared_files/template/template';
$this->load->view($data['content_view'], $data);
}
public function create_program_report_pdf_template($report_id, $facility_code, $report_type)
{
if ($report_type == "malaria") {
//$report_time= strtotime($report_time);
$from_malaria_data_table = Malaria_Data::get_facility_report($report_id, $facility_code);
$from_malaria_data_table_count = count(Malaria_Data::get_facility_report($report_id, $facility_code));
foreach ($from_malaria_data_table as $report_details) {
$mfl = $report_details['facility_id'];
$commodity_code = $report_details['Kemsa_Code'];
$mydrug_name = Doctrine::getTable('Malaria_drugs')->findOneBykemsa_code($commodity_code);
$commodityname = $mydrug_name->drug_name;
$report_date = $report_details['Report_Date'];
$myobj = Doctrine::getTable('Facilities')->findOneByfacility_code($mfl);
$sub_county_id = $myobj->district;
$facility_name = $myobj->facility_name;
// get the order form details here
$myobj1 = Doctrine::getTable('Districts')->find($sub_county_id);
$sub_county_name = $myobj1->district;
$county = $myobj1->county;
$myobj2 = Doctrine::getTable('Counties')->find($county);
$county_name = $myobj2->county;
$myobj_order = Doctrine::getTable('users')->find($report_details['user_id']);
$creator_email = $myobj_order->email;
$creator_name1 = $myobj_order->fname;
$creator_name2 = $myobj_order->lname;
$creator_telephone = $myobj_order->telephone;
}
//create the table for displaying the order details
$html_body = "<table class='data-table' width=100%>\n\t\t\t<tr>\n\t\t\t\t<td>MFL No: {$mfl}</td> \n\t\t\t\t<td>Health Facility Name:<br/> {$facility_name}</td>\n\t\t\t\t<td>Level:</td>\n\t\t\t\t<td>Dispensary</td>\n\t\t\t\t<td>Health Centre</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>County: {$county_name}</td> \n\t\t\t\t<td> District: {$sub_county_name}</td>\n\t\t\t\t<td >Reporting Period <br/>\n\t\t\t\t\tStart Date: <br/> End Date: " . date('d M, Y', strtotime($report_date)) . "\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table>";
$html_body .= "\n\t\t<table class='data-table'>\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th><b>KEMSA Code</b></th>\n\t\t\t\t\t<th><b>Commodity Name</b></th>\n\t\t\t\t\t<th ><b>Beginning Balance</b></th>\n\t\t\t\t\t<th ><b>Quantity Received</b></th>\n\t\t\t\t\t<th ><b>Quantity Dispensed</b></th>\n\t\t\t\t\t<th ><b>Losses Excluding Expiries</b></th>\n\t\t\t\t\t<th ><b>Adjustments</b></th>\n\t\t\t\t\t<th ><b>Physical Count</b></th>\n\t\t\t\t\t<th ><b>Expired Drugs</b></th>\n\t\t\t\t\t<th ><b>Days Out of Stock</b></th>\n\t\t\t\t\t<th ><b>Report Total</b></th>\n\t\t\t\t</tr> \n\t\t\t</thead>\n\t\t\t<tbody>";
$html_body .= '<ol type="a">';
for ($i = 0; $i < $from_malaria_data_table_count; $i++) {
$mydrug_name = Doctrine::getTable('Malaria_drugs')->findOneBykemsa_code($from_malaria_data_table[$i]['Kemsa_Code']);
//$commodityname[$i] = $mydrug_name -> drug_name;
$adjs = $from_malaria_data_table[$i]['Positive_Adjustments'] + $from_malaria_data_table[$i]['Negative_Adjustments'];
$html_body .= "<tr>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Kemsa_Code'] . "</td>";
$html_body .= "<td>" . ($commodityname = $mydrug_name->drug_name . "</td>");
$html_body .= "<td>" . $from_malaria_data_table[$i]['Beginning_Balance'] . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Quantity_Received'] . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Quantity_Dispensed'] . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Losses_Excluding_Expiries'] . "</td>";
$html_body .= "<td>" . $adjs . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Physical_Count'] . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Expired_Drugs'] . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Days_Out_Stock'] . "</td>";
$html_body .= "<td>" . $from_malaria_data_table[$i]['Report_Total'] . "</td>";
$html_body .= "</tr>";
}
$html_body .= '</tbody></table></ol>';
} elseif ($report_type == "RH") {
$from_RH_data_table = RH_Drugs_Data::get_facility_report($report_id, $facility_code);
$from_RH_data_table_count = count(RH_Drugs_Data::get_facility_report($report_id, $facility_code));
foreach ($from_RH_data_table as $report_details) {
$mfl = $report_details['facility_id'];
$report_date = $report_details['Report_Date'];
$myobj = Doctrine::getTable('Facilities')->findOneByfacility_code($mfl);
$sub_county_id = $myobj->district;
$facility_name = $myobj->facility_name;
$myobj1 = Doctrine::getTable('Districts')->find($sub_county_id);
$sub_county_name = $myobj1->district;
$county = $myobj1->county;
$myobj2 = Doctrine::getTable('Counties')->find($county);
$county_name = $myobj2->county;
$myobj_order = Doctrine::getTable('users')->find($report_details['user_id']);
$creator_email = $myobj_order->email;
$creator_name1 = $myobj_order->fname;
$creator_name2 = $myobj_order->lname;
$creator_telephone = $myobj_order->telephone;
}
//create the table for displaying the order details
$html_body = "<table class='data-table' width=100%>\n\t\t\t\t<tr>\n\t\t\t\t\t<td>MFL No: {$mfl}</td> \n\t\t\t\t\t<td>Health Facility Name:<br/> {$facility_name}</td>\n\t\t\t\t\t<td>Level:</td>\n\t\t\t\t\t<td>Dispensary</td>\n\t\t\t\t\t<td>Health Centre</td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t\t<td>County: {$county_name}</td> \n\t\t\t\t\t<td> District: {$sub_county_name}</td>\n\t\t\t\t\t<td >Reporting Period <br/>\n\t\t\t\t\t\tStart Date: <br/> End Date: " . date('d M, Y', strtotime($report_date)) . "\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n\t\t\t</table>";
$html_body .= "\n\t\t\t<table class='data-table'>\n\t\t\t\t<thead>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th ><b>Beginning Balance</b></th>\n\t\t\t\t\t\t<th ><b>Quantity Received This Month</b></th>\n\t\t\t\t\t\t<th ><b>Quantity Dispensed</b></th>\n\t\t\t\t\t\t<th ><b>Losses</b></th>\n\t\t\t\t\t\t<th ><b>Adjustments</b></th>\n\t\t\t\t\t\t<th ><b>Ending Balance</b></th>\n\t\t\t\t\t\t<th ><b>Quantity Requested</b></th>\n\t\t\t\t\t</tr> \n\t\t\t\t</thead>\n\t\t\t\t<tbody>";
$html_body .= '<ol type="a">';
for ($i = 0; $i < $from_RH_data_table_count; $i++) {
$html_body .= "<tr>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Beginning_Balance'] . "</td>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Received_This_Month'] . "</td>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Dispensed'] . "</td>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Losses'] . "</td>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Adjustments'] . "</td>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Ending_Balance'] . "</td>";
$html_body .= "<td>" . $from_RH_data_table[$i]['Quantity_Requested'] . "</td>";
$html_body .= "</tr>";
}
$html_body .= '</tbody></table></ol>';
} elseif ($report_type == "TB") {
$from_TB_data_table = tb_data::get_all_other($report_id);
$from_TB_data_table_s2 = tb_data::get_all_other_2($report_id);
$from_TB_data_table_count = count(tb_data::get_all_other($report_id));
$tb_drug_names = tb_data::get_tb_drug_names();
foreach ($from_TB_data_table as $report_details) {
$mfl = $report_details['facility_code'];
$report_date = $report_details['report_date'];
$myobj = Doctrine::getTable('Facilities')->findOneByfacility_code($mfl);
$sub_county_id = $myobj->district;
$facility_name = $myobj->facility_name;
$myobj1 = Doctrine::getTable('Districts')->find($sub_county_id);
$sub_county_name = $myobj1->district;
$county = $myobj1->county;
$myobj2 = Doctrine::getTable('Counties')->find($county);
$county_name = $myobj2->county;
$myobj_order = Doctrine::getTable('users')->find($report_details['user_id']);
$creator_email = $myobj_order->email;
$creator_name1 = $myobj_order->fname;
$creator_name2 = $myobj_order->lname;
$creator_telephone = $myobj_order->telephone;
}
//create the table for displaying the order details
$html_body = "<table class='data-table' width=100%>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>MFL No: {$mfl}</td> \n\t\t\t\t\t\t<td>Health Facility Name:<br/> {$facility_name}</td>\n\t\t\t\t\t\t<td>Level:</td>\n\t\t\t\t\t\t<td>Dispensary</td>\n\t\t\t\t\t\t<td>Health Centre</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>County: {$county_name}</td> \n\t\t\t\t\t\t<td> District: {$sub_county_name}</td>\n\t\t\t\t\t\t<td >Reporting Period <br/>\n\t\t\t\t\t\t\tStart Date: <br/> End Date: " . date('d M, Y', strtotime($report_date)) . "\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
$html_body .= "\n\t\t\t\t<table class='data-table'>\n\t\t\t\t\t<thead>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th ><b>Drug Name</b></th>\n\t\t\t\t\t\t\t<th ><b>Pack</b></th>\n\t\t\t\t\t\t\t<th ><b>Beginning Date</b></th>\n\t\t\t\t\t\t\t<th ><b>Quantity Received This Month</b></th>\n\t\t\t\t\t\t\t<th ><b>Ending Date</b></th>\n\t\t\t\t\t\t\t<th ><b>Beginning Balance</b></th>\n\t\t\t\t\t\t\t<th ><b>Quantity Dispensed</b></th>\n\t\t\t\t\t\t\t<th ><b>Positive_Adjustments</b></th>\n\t\t\t\t\t\t\t<th ><b>Negative_Adjustments</b></th>\n\t\t\t\t\t\t\t<th ><b>Losses</b></th>\n\t\t\t\t\t\t\t<th ><b>Physical Count</b></th>\n\t\t\t\t\t\t\t<th ><b>Earliest Expiry</b></th>\n\t\t\t\t\t\t\t<th ><b>Quantity Requested</b></th>\n\t\t\t\t\t\t\t<th ><b>Report Date</b></th>\n\t\t\t\t\t\t</tr> \n\t\t\t\t\t</thead>\n\t\t\t\t\t<tbody>";
$html_body .= '<ol type="a">';
for ($i = 0; $i < $from_TB_data_table_count; $i++) {
$html_body .= "<tr>";
$html_body .= "<td>" . $tb_drug_names[$i]['drug_name'] . "</td>";
$html_body .= "<td>" . $tb_drug_names[$i]['unit_size'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['beginning_date'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['currently_recieved'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['ending_date'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['beginning_balance'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['quantity_dispensed'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['positive_adjustment'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['negative_adjustment'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['losses'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['physical_count'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['earliest_expiry'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['quantity_needed'] . "</td>";
$html_body .= "<td>" . $from_TB_data_table[$i]['report_date'] . "</td>";
$html_body .= "</tr>";
}
$html_body .= '</tbody></table></ol>';
} elseif ($report_type == "expiries") {
$years = array();
$month_names[] = array();
$year1 = $years[0] = date('Y');
$year2 = $years[1] = date('Y') + 1;
$year3 = $years[2] = date('Y') + 2;
$month_names[0] = 'January';
$month_names[1] = 'February';
$month_names[2] = 'March';
$month_names[3] = 'April';
$month_names[4] = 'May';
$month_names[5] = 'June';
$month_names[6] = 'July';
$month_names[7] = 'August';
$month_names[8] = 'September';
$month_names[9] = 'October';
$month_names[10] = 'November';
$month_names[11] = 'December';
$facility_code = isset($facility_code) ? $facility_code : $this->session->userdata('facility_id');
$expiry_data = Facility_stocks::expiries_report($facility_code);
$facility = $this->session->userdata('facility_id');
$user_id = $this->session->userdata('user_id');
$user_names = Users::get_user_names($user_id);
$data['user_names'] = $user_names[0]['fname'] . " " . $user_names[0]['lname'];
$expiry_data_ = Facility_stocks::expiries_report($facility_code);
$facility_info = tb_data::get_facility_name($facility_code);
$facility_name = $facility_info['facility_name'];
$facility_code_ = $facility_info['facility_code'];
$facility_district = $facility_info['district'];
$district_name_ = Districts::get_district_name_($facility_district);
$district_name = $this->session->userdata('district');
$data['facility_code'] = $facility_info['facility_code'];
$district_region_name = $district_name_['district'];
$data['facility_name'] = $facility_info['facility_name'];
$data['facility_type_'] = $facility_info['owner'];
// echo "<pre>";print_r($years);echo "</pre>";exit;
//$data['expiry_data'] = Facility_stocks::expiries_report($facility_code);
$facility_name = Facilities::get_facility_name_($facility_code)->toArray();
$data['facility_name'] = $facility_name[0]['facility_name'];
$yrs_no = count($years);
$months_no = count($month_names);
for ($i = 0; $i < $yrs_no; $i++) {
for ($j = 0; $j < $months_no; $j++) {
$final_date[] = $month_names[$j] . " " . $years[$i];
}
}
$html_body = '
<body>
<div>
<table width="100%" class="data-table">
<tbody>
<tr>
<th>Expiries Report</th>
</tr>
</table>
</div>
<table width="100%" class="data-table">
<tbody style = "display: table-row-group;vertical-align: middle;border-color: inherit;">
<form class ="form-control" id="tb_form" name="tb_form_">
<div>
<tr style = "display: table-row;vertical-align: inherit;border-color: inherit;">
<thead>
<th style = "border: 1px solid #ddd;" >Commodity</th>
<th style = "border: 1px solid #ddd;" >Batch No</th>
<th style = "border: 1px solid #ddd;" >Expiry Date</th>
<th colspan="12" style="text-align: center;border: 1px solid #ddd;">' . $year1 . '
</th>
<th colspan="12" style="text-align: center;border: 1px solid #ddd;">' . $year2 . '
</th>
<th colspan="12" style="text-align: center;border: 1px solid #ddd;">' . $year3 . '
</th>
</thead>
</tr>
<tr>
<thead>
<th style = "border: 1px solid #ddd;"></th>
<th style = "border: 1px solid #ddd;"></th>
<th style = "border: 1px solid #ddd;"></th>
<th style = "border: 1px solid #ddd;">J</th>
<th style = "border: 1px solid #ddd;">F</th>
<th style = "border: 1px solid #ddd;">M</th>
<th style = "border: 1px solid #ddd;">A</th>
<th style = "border: 1px solid #ddd;">M</th>
<th style = "border: 1px solid #ddd;">J</th>
<th style = "border: 1px solid #ddd;">J</th>
<th style = "border: 1px solid #ddd;" >A</th>
<th style = "border: 1px solid #ddd;" >S</th>
<th style = "border: 1px solid #ddd;" >O</th>
<th style = "border: 1px solid #ddd;" >N</th>
<th style = "border: 1px solid #ddd;" >D</th>
<th style = "border: 1px solid #ddd;" >J</th>
<th style = "border: 1px solid #ddd;" >F</th>
<th style = "border: 1px solid #ddd;" >M</th>
<th style = "border: 1px solid #ddd;" >A</th>
<th style = "border: 1px solid #ddd;" >M</th>
<th style = "border: 1px solid #ddd;" >J</th>
<th style = "border: 1px solid #ddd;" >J</th>
<th style = "border: 1px solid #ddd;" >A</th>
<th style = "border: 1px solid #ddd;" >S</th>
<th style = "border: 1px solid #ddd;" >O</th>
<th style = "border: 1px solid #ddd;" >N</th>
<th style = "border: 1px solid #ddd;" >D</th>
<th style = "border: 1px solid #ddd;" >J</th>
<th style = "border: 1px solid #ddd;" >F</th>
<th style = "border: 1px solid #ddd;" >M</th>
<th style = "border: 1px solid #ddd;" >A</th>
<th style = "border: 1px solid #ddd;" >M</th>
<th style = "border: 1px solid #ddd;" >J</th>
<th style = "border: 1px solid #ddd;" >J</th>
<th style = "border: 1px solid #ddd;" >A</th>
<th style = "border: 1px solid #ddd;" >S</th>
<th style = "border: 1px solid #ddd;" >O</th>
<th style = "border: 1px solid #ddd;" >N</th>
<th style = "border: 1px solid #ddd;" >D</th>
</thead>
</tr>
';
foreach ($expiry_data_ as $data) {
$checked = '<td><input type="checkbox" checked = "checked" disabled ></td>';
$unchecked = '<td><input type="checkbox" disabled ></td>';
$jan14 = $feb14 = $march14 = $april14 = $may14 = $june14 = $july14 = $aug14 = $sept14 = $oct14 = $nov14 = $dec14 = $unchecked;
$jan15 = $feb15 = $march15 = $april15 = $may15 = $june15 = $july15 = $aug15 = $sept15 = $oct15 = $nov15 = $dec15 = $unchecked;
$jan16 = $feb16 = $march16 = $april16 = $may16 = $june16 = $july16 = $aug16 = $sept16 = $oct16 = $nov16 = $dec16 = $unchecked;
$commodity = $data['commodity_name'];
$batch = $data['batch_no'];
$month = $data['expiry_month'];
// echo "<pre>";print_r($month);echo " </pre>";
// echo "<pre>";print_r($final_date);echo " </pre>";exit;
$html_body .= '
<tr>
<td>' . $commodity . '</td>
<td>' . $batch . '</td>
<td>
' . $data['expiry_date'] . '
</td>';
switch ($month) {
// 2014 SWITCH
case NULL:
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[0]:
$jan14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[1]:
$feb14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[2]:
$march14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[3]:
$april14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[4]:
$may14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[5]:
$june14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[6]:
$july14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[7]:
$aug14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[8]:
$sept14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[9]:
$oct14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[10]:
$nov14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[11]:
$dec14 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
// 2015
// 2015
case $final_date[12]:
$jan15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[13]:
$feb15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[14]:
$march15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[15]:
$april15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[16]:
$may15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[17]:
$june15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[18]:
$july15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[19]:
$aug15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[20]:
$sept15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[21]:
$oct15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[22]:
$nov15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[23]:
$dec15 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
// 2016
// 2016
case $final_date[24]:
$jan16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[25]:
$feb16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[26]:
$march16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[27]:
$april16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[28]:
$may16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[29]:
$june16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[30]:
$july16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[31]:
$aug16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[32]:
$sept16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[33]:
$oct16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[34]:
$nov16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
case $final_date[35]:
$dec16 = $checked;
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
default:
$html_body .= $jan14 . $feb14 . $march14 . $april14 . $may14 . $june14 . $july14 . $aug14 . $sept14 . $oct14 . $nov14 . $dec14;
$html_body .= $jan15 . $feb15 . $march15 . $april15 . $may15 . $june15 . $july15 . $aug15 . $sept15 . $oct15 . $nov15 . $dec15;
$html_body .= $jan16 . $feb16 . $march16 . $april16 . $may16 . $june16 . $july16 . $aug16 . $sept16 . $oct16 . $nov16 . $dec16;
break;
}
}
$html_body .= '</tr></div>
</form>
</tbody>
</table>
';
$pdf_data = array("pdf_title" => "Expiry Tracking Chart For {$facility_name}", 'pdf_html_body' => $pdf_body, 'pdf_view_option' => 'download', 'file_name' => $file_name);
$html_body['title'] = $pdf_data;
}
// echo "<pre>";print_r($html_body);echo "</pre>";exit;
return $html_body;
}
public function stocking_levels($county_id = NULL, $district_id = NULL, $facility_code = NULL, $commodity_id = NULL, $tracer_item = NULL, $division = NULL, $graph_type = NULL)
{
/*function does not take county if you give district,neither does it take district if you give facility. purpose: query optimisation*/
// $commodity_id = 456;
// echo $tracer_item;exit;
$county_id = $county_id == "NULL" ? null : $county_id;
$district_id = $district_id == "NULL" ? null : $district_id;
$graph_type = $graph_type == "NULL" ? null : $graph_type;
$facility_code = $facility_code == "NULL" ? null : $facility_code;
$tracer_item = $tracer_item == "NULL" ? null : $tracer_item;
$commodity_id = $commodity_id == "ALL" || $commodity_id == "NULL" ? null : $commodity_id;
$division_details = Dashboard_model::get_division_details($division);
// echo "<pre>";print_r($tracer_commodities);exit;
if (isset($division) && $division > 0) {
$page_title = $division_details[0]['division_name'];
$tracer = "NULL";
} else {
$tracer = 1;
$page_title = "Tracer Item";
}
$page_title = trim($page_title);
$graph_title = $page_title . ' National Stock Level';
if ($county_id > 0) {
$county_name = Counties::get_county_name($county_id);
$graph_title = $page_title . ' ' . $county_name['county'] . ' County Stock Level';
}
if ($district_id > 0) {
$district_name = Districts::get_district_name_($district_id);
$graph_title = $page_title . ' ' . $district_name['district'] . ' Sub-County Stock Level';
}
// echo $tracer_item;exit;
// echo is_null($district_id);
$filter = '';
$filter .= $county_id > 0 && is_null($district_id) ? " AND counties.id = {$county_id}" : NULL;
$filter .= $district_id > 0 && is_null($county_id) ? " AND districts.id = {$district_id}" : NULL;
$filter .= $facility_code > 0 && is_null($county_id) && is_null($district_id) ? " AND facilities.facility_code = {$facility_code}" : NULL;
$filter .= $commodity_id > 0 ? " AND commodities.id = {$commodity_id} " : NULL;
$filter .= $tracer_item > 0 ? " AND commodities.tracer_item = 1 " : NULL;
if ($division != 5) {
$filter .= $division > 0 ? " AND commodities.commodity_division = {$division}" : NULL;
}
// echo $filter;exit;
/*echo "SELECT
commodities.id,
commodities.commodity_name,
SUM(facility_stocks.current_balance) AS unit_balance,
SUM(facility_stocks.current_balance) / commodities.total_commodity_units AS pack_balance,
commodities.total_commodity_units
FROM
hcmp_rtk.facility_stocks
INNER JOIN
facilities ON facility_stocks.facility_code = facilities.facility_code
INNER JOIN
districts ON facilities.district = districts.id
INNER JOIN
counties ON districts.county = counties.id
INNER JOIN
commodities ON facility_stocks.commodity_id = commodities.id
WHERE
commodities.status = 1
$filter
GROUP BY commodities.id ORDER BY commodities.commodity_name ASC";exit;*/
$stocking_levels = $this->db->query("\n\t\t\tSELECT \n\t\t\t commodities.id,\n\t\t\t commodities.commodity_name,\n\t\t\t SUM(facility_stocks.current_balance) AS unit_balance,\n\t\t\t SUM(facility_stocks.current_balance) / commodities.total_commodity_units AS pack_balance,\n\t\t\t commodities.total_commodity_units\n\t\t\tFROM\n\t\t\t hcmp_rtk.facility_stocks\n\t\t\t INNER JOIN\n\t\t\t facilities ON facility_stocks.facility_code = facilities.facility_code\n\t\t\t INNER JOIN\n\t\t\t districts ON facilities.district = districts.id\n\t\t\t INNER JOIN\n\t\t\t counties ON districts.county = counties.id\n\t\t\t INNER JOIN\n\t\t\t commodities ON facility_stocks.commodity_id = commodities.id\n\t\t\tWHERE\n\t\t\t commodities.status = 1\n\t\t\t {$filter}\n\t\t\tGROUP BY commodities.id ORDER BY commodities.commodity_name ASC\n\t\t")->result_array();
// echo "<pre>"; print_r($stocking_levels); exit;
/*
$category_data = array();
$series_data = $series_data_ = array();
$temp_array = $temp_array_ = array();
$graph_data = array();
$graph_type = '';
foreach ($stocking_levels as $data) :
$series_data = array_merge($series_data, array($data["commodity_name"] => (int)$data['cur_bal_packs']/(int)$data['amc_packs']));
$category_data = array_merge($category_data, array($data["commodity_name"]));
endforeach;
*/
/*CODE FOR MULTI BAR COLUMN*/
$graph_data = array();
$graph_data = array_merge($graph_data, array("graph_id" => 'dem_graph_mos'));
$graph_data = array_merge($graph_data, array("graph_title" => $graph_title));
$graph_data = array_merge($graph_data, array("color" => "['#7CB5EC', '#434348']"));
$graph_data = array_merge($graph_data, array("graph_type" => 'bar'));
// $graph_data=array_merge($graph_data,array("graph_yaxis_title"=>'National Stock Level (Units and Packs)'));
$graph_data = array_merge($graph_data, array("graph_categories" => array()));
// $graph_data=array_merge($graph_data,array("series_data"=>array("Pack Balance"=>array(),"Unit Balance"=>array())));
$graph_data = array_merge($graph_data, array("series_data" => array("Pack Balance" => array())));
$graph_data['stacking'] = 'normal';
foreach ($stocking_levels as $stock_level) {
// $category_name = $stock_level['commodity_name'].' ('.$facility_stock_['source_name'].')';
$category_name = $stock_level['commodity_name'];
$graph_data['graph_categories'] = array_merge($graph_data['graph_categories'], array($category_name));
// $graph_data['series_data']['Unit Balance']=array_merge($graph_data['series_data']['Unit Balance'],array((float) $stock_level['unit_balance']));
$graph_data['series_data']['Pack Balance'] = array_merge($graph_data['series_data']['Pack Balance'], array((double) $stock_level['pack_balance']));
}
// echo "<pre>";print_r($graph_data);exit;
/*END OF THAT TITLE OVER THERE*/
// echo "<pre>";print_r($graph_data);echo "</pre>";exit;
/*
$graph_type = 'bar';
$graph_data = array_merge($graph_data, array("graph_id" => 'dem_graph_mos'));
$graph_data = array_merge($graph_data, array("graph_title" => "$title Stock Level in Months of Stock (MOS)"));
$graph_data = array_merge($graph_data, array("graph_type" => $graph_type));
$graph_data = array_merge($graph_data, array("color" => "['#4572A7','#FFF263', '#6AF9C4']"));
$graph_data = array_merge($graph_data, array("graph_yaxis_title" => "MOS"));
$graph_data = array_merge($graph_data, array("graph_categories" => $category_data));
// $graph_data = array_merge($graph_data, array("series_data" => array('total' => $series_data)));
$graph_data=array_merge($graph_data,array("series_data"=>array("Unit Balance"=>array(),"Pack Balance"=>array())));
$data = array();
*/
$data['high_graph'] = $this->hcmp_functions->create_high_chart_graph($graph_data);
// echo "<pre>";print_r($data['high_graph']);exit;
$data['graph_id'] = 'dem_graph_mos';
if ($graph_type == "excel") {
// print_r($_GET); exit;
// echo "<pre>"; print_r($stocking_levels); exit;
$excel_data = array('doc_creator' => "HCMP", 'doc_title' => $page_title, 'file_name' => $page_title);
$row_data = array();
$column_data = array("Commoidity Name", "Unit Balance", "Pack Balance", "Total Commodity Units");
foreach ($stocking_levels as $stocking_levels) {
array_push($row_data, array($stocking_levels['commodity_name'], $stocking_levels['unit_balance'], $stocking_levels['pack_balance'], $stocking_levels['total_commodity_units']));
}
$excel_data['column_data'] = $column_data;
$excel_data['row_data'] = $row_data;
$this->hcmp_functions->create_excel($excel_data);
}
return $this->load->view("shared_files/report_templates/high_charts_template_v_national", $data);
/*END OF THIS OLD SH!T*/
}
