| S/L |
ZONE NAME |
SALES |
Total |
DAMAGE |
Total |
SALES/DAMAGE RATIO |
| |
|
A |
B |
C |
M |
|
A |
B |
C |
M |
|
A |
B |
C |
M |
ZONE_CODE;
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='A' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'sqlmona'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='B' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'sqlmonb'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='C' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'sqlmonc'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='M' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_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'.$ZONE_CODE} = ${'totalr'.$ZONE_CODE} + ${'total'};
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a,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_type='Distributor' and d.product_group='A' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'dsqlmona'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a,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_type='Distributor' and d.product_group='B' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'dsqlmonb'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a ,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_type='Distributor' and d.product_group='C' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'dsqlmonc'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a ,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_type='Distributor' and d.product_group='M' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_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'.$ZONE_CODE} = ${'dtotalr'.$ZONE_CODE} + ${'dtotal'};
?>
|
ZONE_NAME?> |
|
|
|
|
|
|
|
|
|
|
%
|
% |
% |
% |
| Total |
|
|
|
|
|
|
|
|
|
|
% |
% |
% |
% |
|
| |
Last Year Same Time Position
Period: to |
| |
| S/L |
ZONE NAME |
SALES |
Total |
DAMAGE |
Total |
SALES/DAMAGE RATIO |
| |
|
A |
B |
C |
M |
|
A |
B |
C |
M |
|
A |
B |
C |
M |
ZONE_CODE;
${'totalr'.$ZONE_CODE} = 0;
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='A' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'sqlmona'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='B' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'sqlmonb'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='C' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'sqlmonc'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d,area a where c.chalan_date between '".$f_date."' and '".$t_date."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.product_group='M' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_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'.$ZONE_CODE} = ${'totalr'.$ZONE_CODE} + ${'total'};
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a ,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_type='Distributor' and d.product_group='A' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'dsqlmona'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a ,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_type='Distributor' and d.product_group='B' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'dsqlmonb'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a ,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_type='Distributor' and d.product_group='C' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_CODE."'".$con;
${'dsqlmonc'} = mysqli_fetch_row(db_query($sqql));
$sqql = "select sum(c.amount) from warehouse_damage_receive_detail c,dealer_info d,area a ,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_type='Distributor' and d.product_group='M' and d.area_code=a.AREA_CODE and a.ZONE_ID='".$ZONE_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'.$ZONE_CODE} = ${'dtotalr'.$ZONE_CODE} + ${'dtotal'};
?>
|
ZONE_NAME?> |
|
|
|
|
|
|
|
|
|
|
%
|
% |
% |
% |
| Total |
|
|
|
|
|
|
|
|
|
|
% |
% |
% |
% |
|