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']; $AEDAllotment_Id = $_GET['AEDAllotment_Id']; $listData = $classBusiLogic->getDealerSubdealerAEDAllocation($CustomerCd, $Year, $Month, $AEDAllotment_Id); $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 Planning
Date & Time : '. date('d-m-Y H:i:s') .'
'; $rowcnt = 0; $Dsrno = 1; $CustomerCd = $listData[0]['CustomerCd']; $Dealer_Name = $listData[0]['Dealer_Name']; $Customer_SupremeAED15_Date = $classBusiLogic->convertDate($listData[0]['Customer_SupremeAED15_Date'], False, 1); $Customer_SupremeAED15_Qty = ($listData[0]['Customer_SupremeAED15_Qty']) ? $listData[0]['Customer_SupremeAED15_Qty'] : "" ; $Customer_SupremeAED15US_Date = $classBusiLogic->convertDate($listData[0]['Customer_SupremeAED15US_Date'], False, 1); $Customer_SupremeAED15US_Qty = ($listData[0]['Customer_SupremeAED15US_Qty']) ? $listData[0]['Customer_SupremeAED15US_Qty'] : "" ; $Customer_SupremeAED18_Date = $classBusiLogic->convertDate($listData[0]['Customer_SupremeAED18_Date'], False, 1); $Customer_SupremeAED18_Qty = ($listData[0]['Customer_SupremeAED18_Qty']) ? $listData[0]['Customer_SupremeAED18_Qty'] : "" ; $Customer_SupremeAED30_Date = $classBusiLogic->convertDate($listData[0]['Customer_SupremeAED30_Date'], False, 1); $Customer_SupremeAED30_Qty = ($listData[0]['Customer_SupremeAED30_Qty'])? $listData[0]['Customer_SupremeAED30_Qty'] : "" ; $Customer_SolarAED15_Date = $classBusiLogic->convertDate($listData[0]['Customer_SolarAED15_Date'], False, 1); $Customer_SolarAED15_Qty = ($listData[0]['Customer_SolarAED15_Qty']) ? $listData[0]['Customer_SolarAED15_Qty'] : "" ; $Customer_SolarAED18_Date = $classBusiLogic->convertDate($listData[0]['Customer_SolarAED18_Date'], False, 1); $Customer_SolarAED18_Qty = ($listData[0]['Customer_SolarAED18_Qty']) ? $listData[0]['Customer_SolarAED18_Qty'] : "" ; $Customer_SolarAED30_Date = $classBusiLogic->convertDate($listData[0]['Customer_SolarAED30_Date'], False, 1); $Customer_SolarAED30_Qty = ($listData[0]['Customer_SolarAED30_Qty']) ? $listData[0]['Customer_SolarAED30_Qty'] : "" ; $Customer_SupremeAED15_ReserveQty_Open = ($listData[0]['Customer_SupremeAED15_ReserveQty_Open']) ? $listData[0]['Customer_SupremeAED15_ReserveQty_Open'] : "" ; $Customer_SupremeAED15US_ReserveQty_Open = ($listData[0]['Customer_SupremeAED15US_ReserveQty_Open']) ? $listData[0]['Customer_SupremeAED15US_ReserveQty_Open'] : "" ; $Customer_SupremeAED18_ReserveQty_Open = ($listData[0]['Customer_SupremeAED18_ReserveQty_Open']) ? $listData[0]['Customer_SupremeAED18_ReserveQty_Open'] : "" ; $Customer_SupremeAED30_ReserveQty_Open = ($listData[0]['Customer_SupremeAED30_ReserveQty_Open']) ? $listData[0]['Customer_SupremeAED30_ReserveQty_Open'] : "" ; $Customer_SolarAED15_ReserveQty_Open = ($listData[0]['Customer_SolarAED15_ReserveQty_Open']) ? $listData[0]['Customer_SolarAED15_ReserveQty_Open'] : "" ; $Customer_SolarAED18_ReserveQty_Open = ($listData[0]['Customer_SolarAED18_ReserveQty_Open']) ? $listData[0]['Customer_SolarAED18_ReserveQty_Open'] : "" ; $Customer_SolarAED30_ReserveQty_Open = ($listData[0]['Customer_SolarAED30_ReserveQty_Open']) ? $listData[0]['Customer_SolarAED30_ReserveQty_Open'] : "" ; $totalAED15 = ($Customer_SupremeAED15_Qty + $Customer_SupremeAED15US_Qty + $Customer_SolarAED15_Qty) ? ($Customer_SupremeAED15_Qty + $Customer_SupremeAED15US_Qty + $Customer_SolarAED15_Qty) : ''; $totalAED18 = ($Customer_SupremeAED18_Qty + $Customer_SolarAED18_Qty) ? ($Customer_SupremeAED18_Qty + $Customer_SolarAED18_Qty) : ''; $totalAED30 = ($Customer_SupremeAED30_Qty + $Customer_SolarAED30_Qty) ? ($Customer_SupremeAED30_Qty + $Customer_SolarAED30_Qty) : ''; $html_str .= ''; $html_str .= ''; $total_Cus_SupremeAED15_Qty = $Customer_SupremeAED15_Qty + $Customer_SupremeAED15_ReserveQty_Open; $total_Cus_SupremeAED15US_Qty = $Customer_SupremeAED15US_Qty + $Customer_SupremeAED15US_ReserveQty_Open; $total_Cus_SupremeAED18_Qty = $Customer_SupremeAED18_Qty + $Customer_SupremeAED18_ReserveQty_Open; $total_Cus_SupremeAED30_Qty = $Customer_SupremeAED30_Qty + $Customer_SupremeAED30_ReserveQty_Open; $total_Cus_SolarAED15_Qty = $Customer_SolarAED15_Qty + $Customer_SolarAED15_ReserveQty_Open; $total_Cus_SolarAED18_Qty = $Customer_SolarAED18_Qty + $Customer_SolarAED18_ReserveQty_Open; $total_Cus_SolarAED30_Qty = $Customer_SolarAED30_Qty + $Customer_SolarAED30_ReserveQty_Open; $html_str .= ''; $Dsrno++; $html_str .= '
S No. Dealer Name Supreme AED Solar AED Total AED
AED 1.5 AED 1.5 US AED 1.8 AED 3.0 AED 1.5 AED 1.8 AED 3.0 AED 1.5 AED 1.8 AED 3.0
'.$Dsrno.' '.strtoupper($Dealer_Name).' '.$Customer_SupremeAED15_Qty.' '.$Customer_SupremeAED15US_Qty.' '.$Customer_SupremeAED18_Qty.' '.$Customer_SupremeAED30_Qty.' '.$Customer_SolarAED15_Qty.' '.$Customer_SolarAED18_Qty.' '.$Customer_SolarAED30_Qty.' '.($totalAED15).' '.($totalAED18).' '.($totalAED30).'
Reserve Stock '.$Customer_SupremeAED15_ReserveQty_Open.' '.$Customer_SupremeAED15US_ReserveQty_Open.' '.$Customer_SupremeAED18_ReserveQty_Open.' '.$Customer_SupremeAED30_ReserveQty_Open.' '.$Customer_SolarAED15_ReserveQty_Open.' '.$Customer_SolarAED18_ReserveQty_Open.' '.$Customer_SolarAED30_ReserveQty_Open.'
Total Stock '.($Customer_SupremeAED15_Qty + $Customer_SupremeAED15_ReserveQty_Open).' '.($Customer_SupremeAED15US_Qty + $Customer_SupremeAED15US_ReserveQty_Open).' '.($Customer_SupremeAED18_Qty + $Customer_SupremeAED18_ReserveQty_Open).' '.($Customer_SupremeAED30_Qty + $Customer_SupremeAED30_ReserveQty_Open).' '.($Customer_SolarAED15_Qty + $Customer_SolarAED15_ReserveQty_Open).' '.($Customer_SolarAED15_Qty + $Customer_SolarAED18_ReserveQty_Open).' '.($Customer_SolarAED15_Qty + $Customer_SolarAED30_ReserveQty_Open).'

'; $html_str .='
Subdealers AED Planning
'; $rowcnt = 0; $srno = 1; $total_supremeAED15= 0; $total_supremeAED15US= 0; $total_supremeAED18= 0; $total_supremeAED30= 0; $total_solarAED15= 0; $total_solarAED18= 0; $total_solarAED30= 0; foreach($listData as $curRow){ $SubdealerCd = $curRow['SubdealerCd']; $Subdealer_Name = $curRow['subdealer_Name']; $Subdealer_SupremeAED15_Date = $classBusiLogic->convertDate($curRow['Subdealer_SupremeAED15_Date'], False, 1); $Subdealer_SupremeAED15_Qty = ($curRow['Subdealer_SupremeAED15_Qty']) ? $curRow['Subdealer_SupremeAED15_Qty'] : ""; $Subdealer_SupremeAED15US_Date = $classBusiLogic->convertDate($curRow['Subdealer_SupremeAED15US_Date'], False, 1); $Subdealer_SupremeAED15US_Qty = ($curRow['Subdealer_SupremeAED15US_Qty'] ) ? $curRow['Subdealer_SupremeAED15US_Qty'] : ""; $Subdealer_SupremeAED18_Date = $classBusiLogic->convertDate($curRow['Subdealer_SupremeAED18_Date'], False, 1); $Subdealer_SupremeAED18_Qty = ($curRow['Subdealer_SupremeAED18_Qty']) ? $curRow['Subdealer_SupremeAED18_Qty'] : ""; $Subdealer_SupremeAED30_Date = $classBusiLogic->convertDate($curRow['Subdealer_SupremeAED30_Date'], False, 1); $Subdealer_SupremeAED30_Qty = ($curRow['Subdealer_SupremeAED30_Qty']) ? $curRow['Subdealer_SupremeAED30_Qty'] : ""; $Subdealer_SolarAED15_Date = $classBusiLogic->convertDate($curRow['Subdealer_SolarAED15_Date'], False, 1); $Subdealer_SolarAED15_Qty = ($curRow['Subdealer_SolarAED15_Qty'] ) ? $curRow['Subdealer_SolarAED15_Qty'] : ""; $Subdealer_SolarAED18_Date = $classBusiLogic->convertDate($curRow['Subdealer_SolarAED18_Date'], False, 1); $Subdealer_SolarAED18_Qty = ($curRow['Subdealer_SolarAED18_Qty'] ) ? $curRow['Subdealer_SolarAED18_Qty'] : "" ; $Subdealer_SolarAED30_Date = $classBusiLogic->convertDate($curRow['Subdealer_SolarAED30_Date'], False, 1); $Subdealer_SolarAED30_Qty = ($curRow['Subdealer_SolarAED30_Qty'] ) ? $curRow['Subdealer_SolarAED30_Qty'] : ""; $Subdealer_MobileNo = $curRow['SubdealerMobileNo']; $return1 = $classBusiLogic->SMSAlertSubdealerSupremeAEDAllocation($Dealer_Name, $Subdealer_Name, $Subdealer_SupremeAED15_Date, $Subdealer_SupremeAED15_Qty, $Subdealer_SupremeAED15US_Date, $Subdealer_SupremeAED15US_Qty, $Subdealer_SupremeAED18_Date , $Subdealer_SupremeAED18_Qty, $Subdealer_SupremeAED30_Date, $Subdealer_SupremeAED30_Qty, $Subdealer_MobileNo); $return2 = $classBusiLogic->SMSAlertSubdealerSolarAEDAllocation($Dealer_Name, $Subdealer_Name, $Subdealer_SolarAED15_Date, $Subdealer_SolarAED15_Qty , $Subdealer_SolarAED18_Date, $Subdealer_SolarAED18_Qty, $Subdealer_SolarAED30_Date, $Subdealer_SolarAED30_Qty, $Subdealer_MobileNo); $html_str .= ''; $srno++; $total_supremeAED15 = ($total_supremeAED15+$Subdealer_SupremeAED15_Qty) ? $total_supremeAED15+$Subdealer_SupremeAED15_Qty : ""; $total_supremeAED15US = ($total_supremeAED15US+$Subdealer_SupremeAED15US_Qty) ? $total_supremeAED15US+$Subdealer_SupremeAED15US_Qty : ""; $total_supremeAED18 = ($total_supremeAED18+$Subdealer_SupremeAED18_Qty) ? $total_supremeAED18+$Subdealer_SupremeAED18_Qty : ""; $total_supremeAED30 = ($total_supremeAED30+$Subdealer_SupremeAED30_Qty) ? $total_supremeAED30+$Subdealer_SupremeAED30_Qty : ""; $total_solarAED15 = ($total_solarAED15+$Subdealer_SolarAED15_Qty) ? $total_solarAED15+$Subdealer_SolarAED15_Qty : ""; $total_solarAED18 = ($total_solarAED18+$Subdealer_SolarAED18_Qty) ? $total_solarAED18+$Subdealer_SolarAED18_Qty : ""; $total_solarAED30 = ($total_solarAED30+$Subdealer_SolarAED30_Qty) ? $total_solarAED30+$Subdealer_SolarAED30_Qty : ""; } $html_str .= ''; /*$remainSupremeAED15 = ($Customer_SupremeAED15_Qty-$total_supremeAED15)? ($Customer_SupremeAED15_Qty-$total_supremeAED15): ""; $remainSupremeAED15US = ($Customer_SupremeAED15US_Qty-$total_supremeAED15US)? ($Customer_SupremeAED15US_Qty-$total_supremeAED15US) : ""; $remainSupremeAED18 = ($Customer_SupremeAED18_Qty-$total_supremeAED18) ? ($Customer_SupremeAED18_Qty-$total_supremeAED18) : ""; $remainSupremeAED30 = ($Customer_SupremeAED30_Qty-$total_supremeAED30) ? ($Customer_SupremeAED30_Qty-$total_supremeAED30) : ""; $remainSolarAED15 = ($Customer_SolarAED15_Qty-$total_solarAED15) ? ($Customer_SolarAED15_Qty-$total_solarAED15) : ""; $remainSolarAED18 = ($Customer_SolarAED18_Qty-$total_solarAED18) ? ($Customer_SolarAED18_Qty-$total_solarAED18) : ""; $remainSolarAED30 = ($Customer_SolarAED30_Qty-$total_solarAED30) ? ($Customer_SolarAED30_Qty-$total_solarAED30) : ""; */ $remainSupremeAED15 = ($total_Cus_SupremeAED15_Qty-$total_supremeAED15)? ($total_Cus_SupremeAED15_Qty-$total_supremeAED15): ""; $remainSupremeAED15US = ($total_Cus_SupremeAED15US_Qty-$total_supremeAED15US)? ($total_Cus_SupremeAED15US_Qty-$total_supremeAED15US) : ""; $remainSupremeAED18 = ($total_Cus_SupremeAED18_Qty-$total_supremeAED18) ? ($total_Cus_SupremeAED18_Qty-$total_supremeAED18) : ""; $remainSupremeAED30 = ($total_Cus_SupremeAED30_Qty-$total_supremeAED30) ? ($total_Cus_SupremeAED30_Qty-$total_supremeAED30) : ""; $remainSolarAED15 = ($total_Cus_SolarAED15_Qty-$total_solarAED15) ? ($total_Cus_SolarAED15_Qty-$total_solarAED15) : ""; $remainSolarAED18 = ($total_Cus_SolarAED18_Qty-$total_solarAED18) ? ($total_Cus_SolarAED18_Qty-$total_solarAED18) : ""; $remainSolarAED30 = ($total_Cus_SolarAED30_Qty-$total_solarAED30) ? ($total_Cus_SolarAED30_Qty-$total_solarAED30) : ""; $html_str .= ''; $html_str .= '
S No. Subdealer Name Supreme AED Solar AED
AED 1.5 AED 1.5 US AED 1.8 AED 3.0 AED 1.5 AED 1.8 AED 3.0
'.$srno.' '.strtoupper($Subdealer_Name).' '.$Subdealer_SupremeAED15_Qty .' '.$Subdealer_SupremeAED15US_Qty.' '.$Subdealer_SupremeAED18_Qty.' '.$Subdealer_SupremeAED30_Qty.' '.$Subdealer_SolarAED15_Qty.' '.$Subdealer_SolarAED18_Qty.' '.$Subdealer_SolarAED30_Qty.'
Total '.$total_supremeAED15.' '.$total_supremeAED15US.' '.$total_supremeAED18.' '.$total_supremeAED30.' '.$total_solarAED15.' '.$total_solarAED18.' '.$total_solarAED30.'
Reserve Stock '.($remainSupremeAED15) .' '.($remainSupremeAED15US).' '.($remainSupremeAED18).' '.($remainSupremeAED30).' '.($remainSolarAED15).' '.($remainSolarAED18).' '.($remainSolarAED30).'
'; //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_Planning "; $Date = date('d-m-Y'); $filename = $filename.$Date.'.pdf'; $EmailIdarr = Explode(';', $listData[0]['CustomerEmailId']); $EmailId=''; foreach($EmailIdarr as $email){ $EmailId .=$email; } $EmailId = rtrim($EmailId, ','); //echo $EmailId; //->setTo(array('rahul@solargroup.com', 'r.somani@solargroup.com')) //echo $html_str; $content = $mpdf->Output("", "S"); $html_message = '

Dear '.$Dealer_Name.',

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 ->setBcc(array('solartrade@solargroup.com', 'tsm3@solargroup.com')) // Array of people to send to ->setFrom(array('infob2b@solargroup.com' => 'InfoB2B@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 ""; } //$content = $mpdf->Output("", "S"); //============================================================+ // END OF FILE //============================================================+ ?>