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 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);
}
