| Particulars |
SIIL |
EEL |
Total |
| SED 1.5 |
SED 1.8 |
SED 3.0 |
EED 1.5 |
EED 1.5 US |
EED 1.8 |
EED 3.0 |
| Opening Stock For 1 st Day | ';
$i=0;
foreach($array_item as $item){
$sql = "SELECT B.Dispatch From scm_solar_sc.scm_stock_sales A JOIN scm_solar_sc.scm_stock_sales_item B ON A.StockSalesID = B.StockSalesID
WHERE B.ItemCd IN ($item) and SectorCd ='T' and DATE(A.DateAdded)='$first_day_this_month'";
$Opening = $objSolarCustomer->execSelectQuery($sql);
if($Opening[0]['Dispatch']=='' || $Opening[0]['Dispatch']=='0' ){
$sql = "SELECT B.Dispatch From scm_solar_sc.scm_stock_sales A JOIN scm_solar_sc.scm_stock_sales_item B ON A.StockSalesID = B.StockSalesID
WHERE B.ItemCd IN ($item) and SectorCd ='T' and DATE(A.DateAdded)='$second_day_this_month'";
$Opening = $objSolarCustomer->execSelectQuery($sql);
}
$openingstk=$Opening[0]['Dispatch'];
if($item== '20002672'){
$openingstk=$openingstk*1000;
}
else{ $openingstk=$openingstk*1500; }
$openingstock[$i]=$openingstk;
$html_str .=''. sprintf("%.3f", $openingstk) .' | ';
$totalopeningstk= $totalopeningstk+$openingstk;
$i++;
}
$html_str .=''.sprintf("%.3f", $totalopeningstk) .' |
| Total Up to Dispatch for this Month | ';
$j=0;
foreach($array_item as $item){
$sql = "SELECT sum(A.DespatchedQty) as DespatchedQty From so_expdet_magazine_item A JOIN
so_expdet B ON A.IdExpDet= B.IdExpdet JOIN so_expdet_magazine C ON A.IdExpDet= C.IdExpdet and A.MagazineCd=C.MagazineCd WHERE A.ItemCd IN ($item)
and StatusCd IN ('C', 'B') and DATE(C.SAPInvDate) between '$first_day_this_month' and '$last_day_this_month'" ;
$UptoDisp = $objSolarCustomer->execSelectQuery($sql);
$uptodisptch[$j]=$UptoDisp[0]['DespatchedQty'];
$html_str .=''. sprintf("%.3f", $UptoDisp[0]["DespatchedQty"]) .' | ';
$totaldispatch=$totaldispatch+$UptoDisp[0]['DespatchedQty'];
$j++;
}
$html_str .=''. sprintf("%.3f", $totaldispatch) .' |
| Closing Todays Stock | ';
$k=0;
foreach($array_item as $item){
$sql = "SELECT B.Stock From scm_solar_sc.scm_stock_sales A JOIN scm_solar_sc.scm_stock_sales_item B ON A.StockSalesID = B.StockSalesID
WHERE B.ItemCd IN ($item) and SectorCd ='T' and DATE(A.DateAdded)='$curdate'";
$Closing = $objSolarCustomer->execSelectQuery($sql);
$closingstk=$Closing[0]['Stock'];
if($item== '20002672'){
$closingstk=$closingstk*1000;
}
else{ $closingstk=$closingstk*1500; }
$closingstock[$k]=$closingstk;
$html_str .=''. sprintf("%.3f", $closingstk) .' | ';
$totalclosingingstk=$totalclosingingstk+$closingstk;
$k++;
}
$SEDProd15= $closingstock[0]+$uptodisptch[0]-$openingstock[0];
$SEDProd18= $closingstock[1]+$uptodisptch[1]-$openingstock[1];
$SEDProd30= $closingstock[2]+$uptodisptch[2]-$openingstock[2];
$EEDProd15= $closingstock[3]+$uptodisptch[3]-$openingstock[3];
$EEDProd15US= $closingstock[4]+$uptodisptch[4]-$openingstock[4];
$EEDProd18= $closingstock[5]+$uptodisptch[5]-$openingstock[5];
$EEDProd30= $closingstock[6]+$uptodisptch[6]-$openingstock[6];
$totalproduction=$SEDProd15+$SEDProd18+$SEDProd30+$EEDProd15+$EEDProd15US+$EEDProd18+$EEDProd30;
$uptodays=date('d');
$html_str .=''. sprintf("%.3f", $totalclosingingstk) .' |
| Production of This Month |
'. sprintf("%.3f", $SEDProd15).' |
'. sprintf("%.3f", $SEDProd18).' |
'. sprintf("%.3f", $SEDProd30).' |
'. sprintf("%.3f", $EEDProd15).' |
'. sprintf("%.3f", $EEDProd15US).' |
'. sprintf("%.3f", $EEDProd18) .' |
'. sprintf("%.3f", $EEDProd30) .' |
'. sprintf("%.3f", $totalproduction) .' |
';
$html_str .='
| Average Production |
'. sprintf("%.3f", $SEDProd15/$uptodays) .' |
'. sprintf("%.3f", $SEDProd18/$uptodays) .' |
'. sprintf("%.3f", $SEDProd30/$uptodays) .' |
'. sprintf("%.3f", $EEDProd15/$uptodays) .' |
'. sprintf("%.3f", $EEDProd15US/$uptodays) .' |
'. sprintf("%.3f", $EEDProd18/$uptodays) .' |
'. sprintf("%.3f", $EEDProd30/$uptodays) .' |
'. sprintf("%.3f", $totalproduction/$uptodays) .' |
';
$html_str .='