0 && sum(case when b.ds_status = 'Z0' then 1 else 0 end) is not null then sum(case when b.ds_status = 'Z0' then 1 else 0 end)/count(*)*100 else 0 end rate_success
FROM aap_master a
inner join tender_master b
on (
a.cd_dealer = b.cd_dealer
)
WHERE a.cd_dealer_p = $cd_dealer AND a.ds_delind='N' ";
*/
$sql_h = "
SELECT
cd_dealer_p
, nm_company_p
, case when dt_lastlogin_p is null then '' else dt_lastlogin_p end dt_lastlogin_p
, nm_deposit_p
, cnt_tender
, case when cnt_success is null then 0 else cnt_success end cnt_success
, case when cnt_tender > 0 && cnt_success is not null then cnt_success/cnt_tender*100 else 0 end rate_success
, case when sum_score_postscript > 0 && cnt_success > 0 then sum_score_postscript/cnt_success else 0 end avg_score_postscript
FROM
(
SELECT
cd_dealer_p
, nm_name nm_company_p
, dt_lastlogin dt_lastlogin_p
, nm_deposit nm_deposit_p
FROM aap_master
where cd_dealer = $cd_dealer
) c
,
(
SELECT
sum(case when b.ds_status = 'Z0' then s.nm_score_postscript else 0 end) sum_score_postscript
, count(*) cnt_tender
, sum(case when b.ds_status = 'Z0' then 1 else 0 end) cnt_success
FROM aap_master a
inner join tender_master b
on (
a.cd_dealer = b.cd_dealer
and a.cd_dealer_p = $cd_dealer AND a.ds_delind='N'
AND b.ds_delind = 'N'
)
inner join sale_master s
on (
b.cd_sale = s.cd_sale
and s.ds_status = 'ZS'
)
) d ";
$col=mysql_fetch_array(mysql_query($sql_h));
if (!empty($col['cd_dealer_p'])){
$cd_dealer_p = $col['cd_dealer_p'];
$nm_company_p = $col['nm_company_p'];
$dt_lastlogin_p = $col['dt_lastlogin_p'];
$nm_deposit_p = $col['nm_deposit_p'];
$cnt_tender = $col['cnt_tender'];
$cnt_success = $col['cnt_success'];
$rate_success = $col['rate_success'];
$avg_score_postscript = $col['avg_score_postscript'];
}else{
$cd_deler_p = "";
$nm_company_p = "";
$dt_lastlogin_p = "";
$nm_deposit_p = "";
$cnt_tender = "";
$cnt_success = "";
$rate_success = "";
$avg_score_postscript = "";
}
?>