useAdobeCJK = true; // Default setting in config.php
// You can set this to false if you have defined other CJK fonts
$mpdf->SetAutoFont(AUTOFONT_ALL); // AUTOFONT_CJK | AUTOFONT_THAIVIET | AUTOFONT_RTL | AUTOFONT_INDIC // AUTOFONT_ALL
// () = default ALL, 0 turns OFF (default initially)
$HeadingRowStyleFirst = '';
$HeadingRowStyleOther = '';
$RowStyleFirst = '';
$RowStyleOther = '';
$CustomerCd = '';
$IdSubdealer = '';
$CompanyCd = '';
$where_str = '';
$calltype = '';
$phone_details = '';
$phone_count = 0;
$DTS = date("d-m-Y");
$DTE = date("d-m-Y");
if(isset($_GET['CustomerCd']) && $_GET['CustomerCd'] !=''){
$CustomerCd = $_GET['CustomerCd'];
}
if(isset($_GET['IdSubdealer']) && $_GET['IdSubdealer'] !=''){
$IdSubdealer = $_GET['IdSubdealer'];
$where_str .= "AND pc.SubDealerCd='".$IdSubdealer."'";
}
if(isset($_GET['call_type_cd']) && $_GET['call_type_cd'] !=''){
$calltype = $_GET['call_type_cd'];
}
$arrCallType = $classSpecial->getCallType($calltype);
$call_type_cd_array = array();
foreach($arrCallType as $index => $value){
$call_type_cd_array['call_type_cd'][] = $arrCallType[$index]['call_type_cd'];
}
$CallType = implode("','", $call_type_cd_array['call_type_cd']);
$listData = $classSpecial->getPhoneUserList($CustomerCd);
$DTSAnsi = $classBusiLogic->convertDate($DTS, TRUE, 1);
$DTEAnsi = $classBusiLogic->convertDate($DTE, TRUE, 1);
$date_array = $classSpecial->createDateRangeArray($DTSAnsi,$DTEAnsi);
$HeadingRowStyleFirst = 'Style="font-size: 12px; font-weight: bold;border-bottom:1px solid grey;border-left:1px solid grey;border-right:1px solid grey;"';
$HeadingRowStyleOther = 'Style="font-size: 12px; font-weight: bold;border-bottom:1px solid grey;border-right:1px solid grey;"';
$RowStyleFirst = 'Style="font-size: 10px; font-weight: bold;border-bottom:1px solid grey;border-left:1px solid grey;border-right:1px solid grey;"';
$RowStyleOther = 'Style="font-size: 10px; font-weight: bold;border-bottom:1px solid grey;border-right:1px solid grey;"';
$summary_html = '';
$summary_html .= '
| Summary Dealer Phone Call Report |
| Sr.No |
Firm Name & Station |
Received |
Remark |
Date |
| Time |
Status |
';
$rowcnt = 0;
$srno = 1;
foreach($listData as $curRow){
$Customer = $curRow['Customer'];
foreach($date_array AS $index => $value){
$date_added = $date_array[$index];
$reason = ' ';
$status = 'Not Received';
$late_time = strtotime('07:45 PM');
$time = "-";
$reportFill = $classSpecial->getSummaryPhCall($date_added, $curRow['CustomerCd']);
if(!empty($reportFill)){
$reason = $reportFill[0]['reason'];
$time = date('h:i A',strtotime($reportFill[0]['date_added']));
if(strtotime($time) > $late_time){
$status = 'Late Received';
}else{
$status = $reportFill[0]['status'];
}
}
switch ($status){
case 'Not Received':
$bgcolor = 'bgcolor="#FF0000"';
break;
case 'Late Received':
$bgcolor = 'bgcolor="#FFFF00"';
break;
case 'Nil Record':
$bgcolor = 'bgcolor="#0000CD"';
break;
default :
$bgcolor = 'bgcolor="#008000"';
break;
}
$rowcnt++;
$summary_html .= '
| '.$srno.' |
'.strtoupper($Customer).' |
'.$time.' |
'.$status.' |
'.$reason.' |
'.date('d-m-Y',strtotime($date_added)).' |
';
$srno++;
}
}
$summary_html .= '
|
Color Display Chart
| Received |
|
| Late Recd. |
|
| Nil Recd. |
|
| Not Recd |
|
|
';
if($rowcnt > 0 ){
$mpdf->AddPages('L');
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
') ;
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
','E') ;
$mpdf->WriteHTML($summary_html);
}
$phone_count = 0;
$HeadingRowStyleFirst = '';
$HeadingRowStyleOther = '';
$RowStyleFirst = '';
$RowStyleOther = '';
$HeadingRowStyleFirst = 'Style="font-size: 16px; font-weight: bold;border-bottom:1px solid grey;border-left:1px solid grey;border-right:1px solid grey;"';
$HeadingRowStyleOther = 'Style="font-size: 16px; font-weight: bold;border-bottom:1px solid grey;border-right:1px solid grey;"';
$Rowfirst = 'Style="font-size: 16px; border-bottom:1px solid grey;border-left:1px solid grey;border-right:1px solid grey;"';
$Row = 'Style="font-size: 16px; border-bottom:1px solid grey;border-right:1px solid grey;"';
foreach($listData as $curRow){
$CustomerCd = $curRow['CustomerCd'];
$str = "AND pc.CustomerCd='".$CustomerCd."'";
$phone_details = $classSpecial->pdfreportPhoneCall($DTS, $DTE, $CallType, $str ,$where_str);
if(!empty($phone_details) && sizeof($phone_details) > 0){
$prevCustomerCd = 0;
$prevCallType = '';
$html_str = '';
$phone_data_array = array();
$phone_count = 0;
foreach($phone_details AS $key => $value) {
$phone_count++;
$currentCustomerCd = $phone_details[$key]['CustomerCd'];
if($currentCustomerCd != $prevCustomerCd){
$prevCustomerCd = $currentCustomerCd;
$html_str .= '
| Phone Daily Report |
'.($DTS==$DTE ? ' As On ' . $DTS : ' For ' . $DTS . ' To ' . $DTE).' |
| Phone Daily Report By - '. strtoupper($phone_details[$key]['CustomerName']).' |
';
}
$currentCallType = $phone_details[$key]['call_type_cd'];
if($currentCallType != $prevCallType){
$Sr_No = 0;
$prevCallType = $currentCallType;
$html_str .= '
'.$phone_details[$key]['call_type_name'].' |
|
| Sr.No |
Firm Name |
ST |
Person |
Time |
L/M |
Contact By |
Date |
Message |
';
}
$Sr_No++;
$style = '';
$state_cd = '';
$msg_style = 'style="background-color:#ffffff; font-size:16px;border-right: 1px solid grey;border-bottom: 1px solid grey;"';
if($phone_details[$key]['priority_flag'] == '1'){
$msg_style = 'style="background-color:#ffffff; color:red;border-right: 1px solid grey;border-bottom: 1px solid grey;font-size:16px;"';
}
$state_cd = $phone_details[$key]['StateCd'];
$html_str .='| '. $Sr_No.' |
'. $phone_details[$key]['SubDealerName'].' |
'. $state_cd.' |
'. $phone_details[$key]['Person'].' |
'. date('H:i',strtotime($phone_details[$key]['call_time'])).' |
'. $phone_details[$key]['contact_medium'].' |
'. $phone_details[$key]['ContactBy'].' |
'. date('d-m-Y' ,strtotime($phone_details[$key]['date_added'])).' |
'. $phone_details[$key]['message'].' |
';
}
$html_str .='
';
if($phone_count > 0){
$html = $html_str;
$mpdf->AddPages('L');
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
') ;
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
','E') ;
$mpdf->WriteHTML($html);
}
}
}
if($phone_count == 0){
$html_str .= '| No phone record exist!!!! |
';
$mpdf->AddPages('L');
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
') ;
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
','E') ;
$mpdf->WriteHTML($html_str);
}
$filename = "dealer_phone_report_";
$Date = date('d-m-Y');
$filename = $filename.$Date;
$content = $mpdf->Output("", "S");
$html_message = 'Dear Sir,
Please find the attached Daily Dealer Phone Report file.
Thanks & Regards!!
B2B Solar Explosives';
$mailer = new Swift_Mailer(new Swift_MailTransport()); // Create new instance of SwiftMailer
$message = Swift_Message::newInstance()
->setSubject('Auto Mail Daily Dealer Phone Report of '.$Date) // Message subject
// ->setTo(array('rahul@solargroup.com' => 'Rahul Sir', 'r.somani@solargroup.com' => 'R.Somaniji', 'm.bhalerao@solargroup.com' => 'M.Bhaleraoji', 'k.bhadada@solargroup.com' => 'K.Bhadadaji', 'kcn@solargroup.com' => 'kcn@solargroup.com', 'bhl1@solargroup.com'=>'Abhishek', 'websupport@solargroup.com' => 'Web Support')) // Array of people to send to
->setTo(array( 'websupport@solargroup.com' => 'Web Support', 'rajesh.watkar@solargroup.com' =>'Rajesh Sir')) // Array of people to send to
->setFrom(array('b2b.solarexplosives@gmail.com' => 'Admin@B2B.SolarExplosives')) // From:
->setBody($html_message, 'text/html') // Attach that HTML message from earlier
->attach(Swift_Attachment::newInstance($content, $filename, 'application/pdf')); // Attach the generated PDF from earlier
// Send the email, and show user message
if ($mailer->send($message)) {
//echo "";
}else {
//echo "";
}
//============================================================+
// END OF FILE
//============================================================+
?>