| S/L |
DEALER NAME |
SALES |
Total |
DAMAGE |
Total |
SALES/DAMAGE RATIO |
| |
|
A |
B |
C |
M |
|
A |
B |
C |
M |
|
A |
B |
C |
M |
dealer_code;
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'sqlmona'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'sqlmonb'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'sqlmonc'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'sqlmonm'} = mysqli_fetch_row(db_query($sqql));
${'totala'} = ${'totala'} + ${'sqlmona'}[0];
${'totalb'} = ${'totalb'} + ${'sqlmonb'}[0];
${'totalc'} = ${'totalc'} + ${'sqlmonc'}[0];
${'totalm'} = ${'totalm'} + ${'sqlmonm'}[0];
${'total'} = ${'sqlmona'}[0] + ${'sqlmonb'}[0] + ${'sqlmonc'}[0] + ${'sqlmonm'}[0];
${'totalall'} = ${'totalall'} + ${'total'};
${'totalr'.$dealer_code} = ${'totalr'.$dealer_code} + ${'total'};
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,damage_cause dc where dc.payable='Yes' and dc.id=c.receive_type and c.or_date between '".$f_date."' and '".$t_date."' and c.vendor_id=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'dsqlmona'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,damage_cause dc where dc.payable='Yes' and dc.id=c.receive_type and c.or_date between '".$f_date."' and '".$t_date."' and c.vendor_id=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'dsqlmonb'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,damage_cause dc where dc.payable='Yes' and dc.id=c.receive_type and c.or_date between '".$f_date."' and '".$t_date."' and c.vendor_id=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'dsqlmonc'} = mysqli_fetch_row(db_query($sqql));
echo $sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,damage_cause dc where dc.payable='Yes' and dc.id=c.receive_type and c.or_date between '".$f_date."' and '".$t_date."' and c.vendor_id=d.dealer_code and d.dealer_code='".$dealer_code."'".$con;
${'dsqlmonm'} = mysqli_fetch_row(db_query($sqql));
${'dtotala'} = ${'dtotala'} + ${'dsqlmona'}[0];
${'dtotalb'} = ${'dtotalb'} + ${'dsqlmonb'}[0];
${'dtotalc'} = ${'dtotalc'} + ${'dsqlmonc'}[0];
${'dtotalm'} = ${'dtotalm'} + ${'dsqlmonm'}[0];
${'dtotal'} = ${'dsqlmona'}[0] + ${'dsqlmonb'}[0] + ${'dsqlmonc'}[0] + ${'dsqlmonm'}[0];
${'dtotalall'} = ${'dtotalall'} + ${'dtotal'};
${'dtotalr'.$dealer_code} = ${'dtotalr'.$dealer_code} + ${'dtotal'};
?>
|
dealer_name?> |
|
|
|
|
|
|
|
|
|
|
%
|
% |
% |
% |
| Total |
|
|
|
|
|
|
|
|
|
|
% |
% |
% |
% |
|