getDealerSubdealerAEDAllocation($CustomerCd, $Year, $Month, $AEDAllotment_Id); $HeadingRowStyleFirst = ''; $HeadingRowStyleOther = ''; $RowStyleFirst = ''; $RowStyleOther = ''; $html_str = ''; //print_r($listData); $html_str .='

Total AED Planning

'; $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_SolarAED18_Qty + $Customer_SolarAED18_ReserveQty_Open).' '.($Customer_SolarAED30_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'] : ""; $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 = ($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).'

'; echo $html_str ; ?>