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)
$CustomerCd = $_GET['CustomerCd'];
$Year = $_GET['Year'];
$Month = $_GET['Month'];
$Date = $_GET['Date'];
$listData = $classBusiLogic->getDealerSubdealerAEDAllocation($CustomerCd, $Year, $Month);
$HeadingRowStyleFirst = '';
$HeadingRowStyleOther = '';
$RowStyleFirst = '';
$RowStyleOther = '';
$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;"';
$html_str .='
| Total AED Dispatch Planning |
| S No. |
Dealer Name |
Supreme AED |
Solar AED |
| Qty |
Date |
Qty |
Date |
';
$rowcnt = 0;
$Dsrno = 1;
$CustomerCd = $listData[0]['CustomerCd'];
$Dealer_Name = $listData[0]['Dealer_Name'];
$Customer_SupremeAED_Date = $classBusiLogic->convertDate($listData[0]['Customer_SupremeAED_Date'], False, 1);
$Customer_SupremeAED_Qty = $listData[0]['Customer_SupremeAED_Qty'];
$Customer_SolarAED_Date = $classBusiLogic->convertDate($listData[0]['Customer_SolarAED_Date'], False, 1);
$Customer_SolarAED_Qty = $listData[0]['Customer_SolarAED_Qty'];
$html_str .= '
| '.$Dsrno.' |
'.strtoupper($Dealer_Name).' |
'.$Customer_SupremeAED_Qty.' |
'.$Customer_SupremeAED_Date.' |
'.$Customer_SolarAED_Qty.' |
'.$Customer_SolarAED_Date.' |
';
$Dsrno++;
$html_str .= '
|
';
$html_str .='
| Subdealers AED Planning |
| S No. |
Subdealer Name |
Supreme AED |
Solar AED |
| Qty |
Date |
Qty |
Date |
';
$rowcnt = 0;
$srno = 1;
$total_supremeAED= 0;
$total_solarAED= 0;
foreach($listData as $curRow){
$SubdealerCd = $curRow['SubdealerCd'];
$Subdealer_Name = $curRow['subdealer_Name'];
$SubdealerSupremeAED_Date = $classBusiLogic->convertDate($curRow['SubdealerSupremeAED_Date'], False, 1);
$SubdealerSupremeAED_Qty = $curRow['SubdealerSupremeAED_Qty'];
$SubdealerSolarAED_Date = $classBusiLogic->convertDate($curRow['SubdealerSolarAED_Date'], False, 1);
$SubdealerSolarAED_Qty = $curRow['SubdealerSolarAED_Qty'];
$html_str .= '
| '.$srno.' |
'.strtoupper($Subdealer_Name).' |
'.$SubdealerSupremeAED_Qty.' |
'.$SubdealerSupremeAED_Date.' |
'.$SubdealerSolarAED_Qty.' |
'.$SubdealerSolarAED_Date.' |
';
$srno++;
$total_supremeAED = $total_supremeAED+$SubdealerSupremeAED_Qty;
$total_solarAED = $total_solarAED+$SubdealerSolarAED_Qty;
}
$html_str .= '
|
Total |
'.$total_supremeAED.' |
|
'.$total_solarAED.' |
|
';
$html_str .= '
|
';
//if(count($listData)==0){
//$html_str .= '| No phone record exist!!!! |
';
// }
$mpdf->AddPages('P');
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
') ;
$mpdf->setHTMLFooter('{PAGENO} / {nbpg}
','E') ;
$mpdf->WriteHTML($html_str);
//print_r($listData);
$filename = "Dealer_subdealer_AED_Aloocation";
$Date = date('d-m-Y');
$filename = $filename.$Date;
$EmailIdarr = Explode(';', $listData[0]['CustomerEmailId']);
$EmailId='';
foreach($EmailIdarr as $email){
$EmailId .="'".$email."',";
}
$EmailId = rtrim($EmailId, ',');
//echo $html_str;
$content = $mpdf->Output("", "S");
$html_message = 'Dear Sir,
Based on the allocation update provided by you to our Subdealer Representative please find attached reference data sheet.
Thank You
Customer Service Department';
$mailer = new Swift_Mailer(new Swift_MailTransport()); // Create new instance of SwiftMailer
$message = Swift_Message::newInstance()
->setSubject('AED Planning '.$Date) // Message subject
->setTo(array( 'websupport@solargroup.com')) // Array of people to send to
//->setTo(array($EmailId)) // 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 "";
// echo "";
}else {
echo "";
}
//============================================================+
// END OF FILE
//============================================================+
?>