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