public function outputPdfFileComplianceComplete($strReportName, $arrResults, $booOutputHtml = false) { $strHtml = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"><html><head><link rel=\"stylesheet\" type=\"text/css\" media=\"all\" href=\"https://www.iworkaudit.com/includes/css/report.css\" /></head>"; $strHtml .= "<body><div>"; $strHtml .= "<table><tr><td>"; $strHtml .= "<h1>Youaudit Report</h1>"; $strHtml .= "<h2>" . $strReportName . "</h2>"; $strHtml .= "</td><td class=\"right\">"; $logo = 'logo.png'; $strHtml .= "<img alt=\"Youaudit\" src='brochure/logo/" . $logo . "'>"; $strHtml .= "</td></tr></table>"; $strHtml .= "<table class=\"report\">"; $strHtml .= "<thead>"; $strHtml .= "<tr>"; $strHtml .= "<th>Date</th>"; $strHtml .= "<th>QR Code</th>"; $strHtml .= "<th>Serial No</th>"; $strHtml .= "<th>Manufacturer & Model</th>"; $strHtml .= "<th>Category</th>"; $strHtml .= "<th>Check Name</th>"; $strHtml .= "<th>Mandatory</th>"; $strHtml .= "</tr>"; $strHtml .= "</thead><tbody>"; foreach ($arrResults as $test) { $strHtml .= "<tr>"; $date_ex = explode('-', $test['test_date']); $test['test_date'] = $date_ex[2] . "-" . $date_ex[1] . "-" . $date_ex[0]; $strHtml .= "<td>" . $test['test_date'] . "</td>"; $strHtml .= "<td><a href=\"/iwa/items/view/" . $test['test_item_id'] . "\">" . $test['barcode'] . "</a></td>"; $strHtml .= "<td>" . $test['serial_number'] . "</td>"; $strHtml .= "<td>" . $test['manufacturer'] . " " . $test['model'] . "</td>"; $strHtml .= "<td>" . $test['name'] . "</td>"; $strHtml .= "<td>" . $test['test_type_name'] . "</td>"; if ($test['test_type_mandatory'] == 1) { $strHtml .= "<td>Yes</td>"; } else { $strHtml .= "<td>No</td>"; } $strHtml .= "</tr>"; } $strHtml .= "</tbody>"; $strHtml .= "<tfoot><tr>"; $strHtml .= "</table>"; $strHtml .= "<p>Produced by " . $this->session->userdata('objSystemUser')->firstname . " " . $this->session->userdata('objSystemUser')->lastname . " (" . $this->session->userdata('objSystemUser')->username . ") on " . date('d/m/Y') . "</p>"; $strHtml .= "</div></body></html>"; if (!$booOutputHtml) { $this->load->library('Mpdf'); $mpdf = new Pdf('en-GB', 'A4'); $mpdf->setFooter('{PAGENO} of {nb}'); $mpdf->WriteHTML($strHtml); $mpdf->Output("iwareport_" . date('Ymd_His') . ".pdf", "D"); } else { echo $strHtml; die; } }
public function outputPdfFile($strReportName, $arrFields, $arrResults, $booOutputHtml = false) { $arrPageData['arrSessionData'] = $this->session->userdata; $strHtml = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"><html><head><link rel=\"stylesheet\" type=\"text/css\" media=\"all\" href=\"includes/css/report.css\" /></head>"; $strHtml .= "<body><div>"; $strHtml .= "<table><tr><td>"; $strHtml .= "<h1>" . $this->session->userdata('objSystemUser')->firstname . " " . $this->session->userdata('objSystemUser')->lastname . "/" . $this->session->userdata('objSystemUser')->accountname . "</h1>"; $strHtml .= "<h2>" . $strReportName . "</h2>"; $strHtml .= "</td><td class=\"right\">"; $logo = 'logo.png'; if (isset($this->session->userdata['theme_design']->logo)) { $logo = $this->session->userdata['theme_design']->logo; } $strHtml .= "<img alt=\"ictracker\" src='brochure/logo/" . $logo . "'>"; $strHtml .= "</td></tr></table>"; $strHtml .= "<table class=\"report\">"; $strHtml .= "<thead>"; $strHtml .= "<tr style='background-color:#00AEEF'>"; foreach ($arrFields as $arrReportField) { $strHtml .= "<th style='color:white'>" . $arrReportField['strName'] . "</th>"; } $strHtml .= "</tr>"; $strHtml .= "</thead><tbody>"; $arrTotals = array(); foreach ($arrResults as $objItem) { $strHtml .= "<tr>"; $arrPageData['arrSessionData'] = $this->session->userdata; foreach ($arrFields as $arrReportField) { // var_dump($arrReportField); $strHtml .= "<td style='height:50px:'>"; if (array_key_exists('strConversion', $arrReportField)) { switch ($arrReportField['strConversion']) { case 'dt': if ($objItem['dt'] != '') { $strHtml .= date('d/m/Y', strtotime($objItem['dt'])); } else { $strHtml .= "Unknown"; } break; case 'date': $arrDate = explode('-', $objItem->{$arrReportField['strFieldReference']}); if (count($arrDate) > 1) { $strHtml .= $arrDate[2] . "/" . $arrDate[1] . "/" . $arrDate[0]; } else { $strHtml .= "Unknown"; } break; case 'datetime': $arrDateTime = explode(' ', $objItem->{$arrReportField['strFieldReference']}); $strTime = $arrDateTime[1]; $arrDate = explode('-', $arrDateTime[0]); $strHtml .= $arrDate[2] . "/" . $arrDate[1] . "/" . $arrDate[0] . " " . $strTime; break; case 'pat_result': if ($objItem->{$arrReportField['strFieldReference']} === null) { $strHtml.="-"; } else { if ($objItem->{$arrReportField['strFieldReference']} == 1) { $strHtml.="Pass"; } else { $strHtml.="Fail"; } } break; case 'price': $strHtml .= $currency . $objItem->{$arrReportField['strFieldReference']}; break; case 'img': if ($objItem['photo_id']) { if (strpos($objItem['photo_id'], ',')) { $photos = explode(',', $objItem['photo_id']); for ($i = 0; $i < count($photos); $i++) { $image = $this->db->select('path')->where('id', $photos[$i])->get('photos')->row(); $strHtml .= "<img width='20' height='20' src='" . base_url() . $image->path . "'>"; } } else { $image = $this->db->select('path')->where('id', $objItem['photo_id'])->get('photos')->row(); $strHtml .= "<img width='20' height='20' src='" . base_url() . $image->path . "'>"; } } } } else { $strHtml .= $objItem[$arrReportField['strFieldReference']]; } if (array_key_exists('arrFooter', $arrReportField) && array_key_exists('booTotal', $arrReportField['arrFooter'])) { if (array_key_exists($arrReportField['strFieldReference'], $arrTotals)) { $arrTotals[$arrReportField['strFieldReference']] += $objItem[$arrReportField['strFieldReference']]; } else { $arrTotals[$arrReportField['strFieldReference']] = $objItem[$arrReportField['strFieldReference']]; } } $strHtml .= "</td>"; } $strHtml .= "</tr>"; } $strHtml .= "</tbody>"; $strHtml .= "<tfoot><tr>"; foreach ($arrFields as $arrReportField) { if (array_key_exists('arrFooter', $arrReportField)) { if (array_key_exists('booTotal', $arrReportField['arrFooter']) && $arrReportField['arrFooter']['booTotal']) { $strHtml .= "<td>"; if (array_key_exists('strConversion', $arrReportField) && ($arrReportField['strConversion'] == "price")) { $strHtml .= $currency; } $strHtml .= $arrTotals[$arrReportField['strFieldReference']]; $strHtml .= "</td>"; } else { if (array_key_exists('booTotalLabel', $arrReportField['arrFooter']) && $arrReportField['arrFooter']['booTotalLabel']) { $strHtml .= "<td"; if (array_key_exists('intColSpan', $arrReportField['arrFooter']) && ($arrReportField['arrFooter']['intColSpan'] > 0)) { $strHtml .= " colspan=\"" . $arrReportField['arrFooter']['intColSpan'] . "\""; } $strHtml .= " class=\"right\">"; $strHtml .= "Totals</td>"; } } } } $strHtml .= "</tr></tfoot>"; $strHtml .= "</table>"; $strHtml .= "<p>Produced by " . $arrPageData['arrSessionData']["objSystemUser"]->firstname . " " . $arrPageData['arrSessionData']["objSystemUser"]->lastname . " (" . $arrPageData['arrSessionData']["objSystemUser"]->username . ") on " . date('d/m/Y') . "</p>"; $strHtml .= "</div></body></html>"; if (!$booOutputHtml) { $this->load->library('Mpdf'); $mpdf = new Pdf('en-GB', 'A4'); $mpdf->setFooter('{PAGENO} of {nb}'); $mpdf->WriteHTML($strHtml); $mpdf->Output("YouAudit_" . date('Ymd_His') . ".pdf", "D"); } else { echo $strHtml; die(); } }
function mailroutine($customer_data) { $new_file = $_SERVER['DOCUMENT_ROOT'] . '/iwa/excel_file/isareport_' . date('Ymd_His') . '.pdf'; $curr_count = (int) $this->count_routine; $total_count = count($customer_data); if ($total_count > $curr_count) { if ((int) $customer_data[$this->count_routine]['account_id'] > 0) { $table = $this->getDues($customer_data[$this->count_routine]['account_id'], $customer_data[$this->count_routine]['id']); $this->load->library('Mpdf'); $mpdf = new Pdf('en-GB', 'A4'); $mpdf->setFooter('{PAGENO} of {nb}'); $mpdf->WriteHTML($table); $mpdf->Output($new_file, "F"); $this->load->library('email'); $this->email->from("*****@*****.**", "Due Compliance"); // $this->email->to('*****@*****.**'); $this->email->to($customer_data[$this->count_routine]['username']); $this->email->subject('Due Compliance List'); $this->email->message('Due Compliance list is attached with pdf (Testing) '); $this->email->attach($new_file); $this->email->send(); $this->count_routine = $this->count_routine + 1; $this->email->clear(TRUE); $this->mailroutine($customer_data); } else { $this->count_routine = $this->count_routine + 1; $this->mailroutine($customer_data); } } }
public function outputPdfFile($strReportName, $arrFields, $arrResults, $booOutputHtml = false) { $strHtml = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"><html><head><link rel=\"stylesheet\" type=\"text/css\" media=\"all\" href=\"includes/css/report.css\" /></head>"; $strHtml .= "<body><div>"; $strHtml .= "<table><tr><td>"; $strHtml .= "<h1>YouAudit Report</h1>"; $strHtml .= "<h2>" . $strReportName . "</h2>"; $strHtml .= "</td><td class=\"right\">"; $logo = 'logo.png'; if (isset($this->session->userdata['theme_design']->logo)) { $logo = $this->session->userdata['theme_design']->logo; } $strHtml .= "<img alt=\"ictracker\" src='brochure/logo/" . $logo . "'>"; $strHtml .= "</td></tr></table>"; $strHtml .= "<table class=\"report\">"; $strHtml .= "<thead >"; $strHtml .= "<tr style='background-color:#00AEEF'>"; foreach ($arrFields as $arrReportField) { $strHtml .= "<th style='color:white'>" . $arrReportField['strName'] . "</th>"; } $strHtml .= "</tr>"; $strHtml .= "</thead><tbody>"; $arrTotals = array(); foreach ($arrResults as $objItem) { $strHtml .= "<tr>"; $arrPageData['arrSessionData'] = $this->session->userdata; foreach ($arrFields as $arrReportField) { $strHtml .= "<td style='height:50px'>"; if (array_key_exists('strConversion', $arrReportField)) { switch ($arrReportField['strConversion']) { case 'compliance': if ($objItem['compliance'] == 1) { $strHtml .= 'YES'; } else { $strHtml .= "NO"; } break; case 'fleet': if ($objItem['fleet'] == 1) { $strHtml .= 'YES'; } else { $strHtml .= "NO"; } break; case 'condition_module': if ($objItem['condition_module'] == 1) { $strHtml .= 'YES'; } else { $strHtml .= "NO"; } break; case 'depereciation_module': if ($objItem['depereciation_module'] == 1) { $strHtml .= 'YES'; } else { $strHtml .= "NO"; } break; case 'reporting_module': if ($objItem['reporting_module'] == 1) { $strHtml .= 'YES'; } else { $strHtml .= "NO"; } break; case 'create_date': $strHtml .= date('d/m/Y', $objItem['create_date']); break; case 'owner': $owner = json_decode($objItem['owner']); if (!empty($owner)) { foreach ($owner as $val) { if ($val == '') { $strHtml .= "N/A"; $strHtml .= "<br>"; } else { $strHtml .= $val; $strHtml .= "<br>"; } } } else { $strHtml .= "N/A"; } break; case 'category': $category = json_decode($objItem['category']); if (!empty($category)) { foreach ($category as $cat) { if ($cat == '') { $strHtml .= "N/A"; $strHtml .= "<br>"; } else { $strHtml .= $cat; $strHtml .= "<br>"; } } } else { $strHtml .= 'N/A'; } break; case 'manu': $manu = json_decode($objItem['manu']); if (!empty($manu)) { foreach ($manu as $man) { if ($man == '') { $strHtml .= "N/A"; $strHtml .= "<br>"; } else { $strHtml .= $man; $strHtml .= "<br>"; } } } else { $strHtml .= "N/A"; } break; case 'manufacturer': $manufacturer = json_decode($objItem['manufacturer']); if (!empty($manufacturer)) { foreach ($manufacturer as $manufact) { if ($manufact == '') { $strHtml .= "N/A"; $strHtml .= "<br>"; } else { $strHtml .= $manufact; $strHtml .= "<br>"; } } } else { $strHtml .= "N/A"; } break; } } else { $strHtml .= $objItem[$arrReportField['strFieldReference']]; } if (array_key_exists('arrFooter', $arrReportField) && array_key_exists('booTotal', $arrReportField['arrFooter'])) { if (array_key_exists($arrReportField['strFieldReference'], $arrTotals)) { $arrTotals[$arrReportField['strFieldReference']] += $objItem[$arrReportField['strFieldReference']]; } else { $arrTotals[$arrReportField['strFieldReference']] = $objItem[$arrReportField['strFieldReference']]; } } $strHtml .= "</td>"; } $strHtml .= "</tr>"; } $strHtml .= "</tbody>"; $strHtml .= "<tfoot><tr>"; foreach ($arrFields as $arrReportField) { if (array_key_exists('arrFooter', $arrReportField)) { if (array_key_exists('booTotal', $arrReportField['arrFooter']) && $arrReportField['arrFooter']['booTotal']) { $strHtml .= "<td>"; if (array_key_exists('strConversion', $arrReportField) && ($arrReportField['strConversion'] == "price")) { $strHtml .= $currency; } $strHtml .= $arrTotals[$arrReportField['strFieldReference']]; $strHtml .= "</td>"; } else { if (array_key_exists('booTotalLabel', $arrReportField['arrFooter']) && $arrReportField['arrFooter']['booTotalLabel']) { $strHtml .= "<td"; if (array_key_exists('intColSpan', $arrReportField['arrFooter']) && ($arrReportField['arrFooter']['intColSpan'] > 0)) { $strHtml .= " colspan=\"" . $arrReportField['arrFooter']['intColSpan'] . "\""; } $strHtml .= " class=\"right\">"; $strHtml .= "Totals</td>"; } } } } $strHtml .= "</tr></tfoot>"; $strHtml .= "</table>"; if (($arrPageData['arrSessionData']["objAdminUser"])) { $strHtml .= "<p>Produced by " . $arrPageData['arrSessionData']["objAdminUser"]->firstname . " " . $arrPageData['arrSessionData']["objAdminUser"]->lastname . " (" . $arrPageData['arrSessionData']["objAdminUser"]->username . ") on " . date('d/m/Y') . "</p>"; $strHtml .= "</div></body></html>"; } else { $strHtml .= "<p>Produced by " . $arrPageData['arrSessionData']['YouAuditSystemAdmin']['firstname'] . " " . $arrPageData['arrSessionData']['YouAuditSystemAdmin']['lastname'] . " (" . $arrPageData['arrSessionData']['YouAuditSystemAdmin']['username'] . ") on " . date('d/m/Y') . "</p>"; $strHtml .= "</div></body></html>"; } if (!$booOutputHtml) { $this->load->library('Mpdf'); $mpdf = new Pdf('en-GB', 'A4'); $mpdf->setFooter('{PAGENO} of {nb}'); $mpdf->WriteHTML($strHtml); $mpdf->Output("YouAudit_" . date('Ymd_His') . ".pdf", "D"); } else { echo $strHtml; die(); } }
public function exportPdfFile($allData, $filename = "isareport") { $this->load->model('accounts_model'); $booOutputHtml = false; $data['allData'] = $allData; $data['title'] = $filename; // $data['accountDetails'] = $this->accounts_model->getOne($this->session->userdata('objSystemUser')->accountid); $strHtml = $this->load->view('items/exporttopdf', $data, true); // echo $strHtml;die; if (!$booOutputHtml) { $this->load->library('Mpdf'); $mpdf = new Pdf('en-GB', 'A4'); $mpdf->setHeader($filename); $mpdf->setFooter('{PAGENO} of {nb}'); $mpdf->WriteHTML($strHtml); $mpdf->Output("$filename.pdf", "D"); } else { echo $strHtml; die(); } }
public function outputPdfFile($strReportName, $arrFields, $arrResults, $booOutputHtml = false) { $this->load->model('accounts_model'); $currency = $this->accounts_model->getCurrencySym($this->session->userdata('objSystemUser')->currency); $strHtml = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"><html><head><link rel=\"stylesheet\" type=\"text/css\" media=\"all\" href=\"includes/css/report.css\" /></head>"; $strHtml .= "<body><div>"; $strHtml .= "<table><tr><td>"; $strHtml .= "<h1>" . $this->session->userdata('objSystemUser')->firstname . " " . $this->session->userdata('objSystemUser')->lastname . "/" . $this->session->userdata('objSystemUser')->accountname . "</h1>"; $strHtml .= "<h2>" . $strReportName . "</h2>"; $strHtml .= "</td><td class=\"right\">"; $logo = 'logo.png'; if (isset($this->session->userdata['theme_design']->logo)) { $logo = $this->session->userdata['theme_design']->logo; } $strHtml .= "<img alt=\"ictracker\" src='brochure/logo/" . $logo . "'>"; $strHtml .= "</td></tr></table>"; $strHtml .= "<table class=\"report\">"; $strHtml .= "<thead>"; $strHtml .= "<tr style='background-color:#00AEEF'>"; foreach ($arrFields as $arrReportField) { $strHtml .= "<th style='color:#FFFFFF'>" . $arrReportField['strName'] . "</th>"; } $strHtml .= "</tr>"; $strHtml .= "</thead><tbody>"; $arrTotals = array(); foreach ($arrResults as $objItem) { $strHtml .= "<tr>"; foreach ($arrFields as $arrReportField) { $strHtml .= "<td style='height:50px'>"; if (array_key_exists('strConversion', $arrReportField)) { switch ($arrReportField['strConversion']) { case 'date': $arrDate = explode('-', $objItem->{$arrReportField['strFieldReference']}); if (count($arrDate) > 1) { $strHtml .= $arrDate[2] . "/" . $arrDate[1] . "/" . $arrDate[0]; } else { $strHtml .= "Unknown"; } break; case 'datetime': $arrDateTime = explode(' ', $objItem->{$arrReportField['strFieldReference']}); $strTime = $arrDateTime[1]; $arrDate = explode('-', $arrDateTime[0]); $strHtml .= $arrDate[2] . "/" . $arrDate[1] . "/" . $arrDate[0] . " " . $strTime; break; case 'owner': if ($objItem['owner'] == 1) { $strHtml.="Yes"; } else { $strHtml.="No"; } break; case 'price': $strHtml .= $currency . $objItem->{$arrReportField['strFieldReference']}; break; } } else { $strHtml .= $objItem[$arrReportField['strFieldReference']]; } if (array_key_exists('arrFooter', $arrReportField) && array_key_exists('booTotal', $arrReportField['arrFooter'])) { if (array_key_exists($arrReportField['strFieldReference'], $arrTotals)) { $arrTotals[$arrReportField['strFieldReference']] += $objItem[$arrReportField['strFieldReference']]; } else { $arrTotals[$arrReportField['strFieldReference']] = $objItem[$arrReportField['strFieldReference']]; } } $strHtml .= "</td>"; } $strHtml .= "</tr>"; } $strHtml .= "</tbody>"; $strHtml .= "<tfoot><tr>"; foreach ($arrFields as $arrReportField) { if (array_key_exists('arrFooter', $arrReportField)) { if (array_key_exists('booTotal', $arrReportField['arrFooter']) && $arrReportField['arrFooter']['booTotal']) { $strHtml .= "<td>"; if (array_key_exists('strConversion', $arrReportField) && ($arrReportField['strConversion'] == "price")) { $strHtml .= $currency; } $strHtml .= $arrTotals[$arrReportField['strFieldReference']]; $strHtml .= "</td>"; } else { if (array_key_exists('booTotalLabel', $arrReportField['arrFooter']) && $arrReportField['arrFooter']['booTotalLabel']) { $strHtml .= "<td"; if (array_key_exists('intColSpan', $arrReportField['arrFooter']) && ($arrReportField['arrFooter']['intColSpan'] > 0)) { $strHtml .= " colspan=\"" . $arrReportField['arrFooter']['intColSpan'] . "\""; } $strHtml .= " class=\"right\">"; $strHtml .= "Totals</td>"; } } } } $strHtml .= "</tr></tfoot>"; $strHtml .= "</table>"; $strHtml .= "<p>Produced by " . $this->session->userdata('objSystemUser')->firstname . " " . $this->session->userdata('objSystemUser')->lastname . " (" . $this->session->userdata('objSystemUser')->username . ") on " . date('d/m/Y') . "</p>"; $strHtml .= "</div></body></html>"; if (!$booOutputHtml) { $this->load->library('Mpdf'); $mpdf = new Pdf('en-GB', 'A4'); $mpdf->setFooter('{PAGENO} of {nb}'); $mpdf->WriteHTML($strHtml); $mpdf->Output("YouAudit_" . date('Ymd_His') . ".pdf", "D"); } else { echo $strHtml; die(); } }