weight => { op => '>', value => 0 },
},
extra_sql =>
- "AND payby IN ('CARD', 'DCRD') ".
+ "AND cust_payby.payby IN ('CARD', 'DCRD') ".
'AND '.
$FS::CurrentUser::CurrentUser->agentnums_sql( table => 'cust_main' ),
});
weight => { op => '>', value => 0 },
},
extra_sql =>
- "AND payby IN ('CHEK','DCHEK','DCHK') ".
+ "AND cust_payby.payby IN ('CHEK','DCHEK','DCHK') ".
'AND '.
$FS::CurrentUser::CurrentUser->agentnums_sql( table => 'cust_main' ),
});
order_by => " ORDER BY weight DESC ",
extra_sql =>
"AND (
- payby IN ('CHEK','DCHK','DCHEK')
- OR ( paydate > '".$target_dt->ymd."')
+ cust_payby.payby IN ('CHEK','DCHK','DCHEK')
+ OR ( cust_payby.paydate > '".$target_dt->ymd."')
)
AND " . $FS::CurrentUser::CurrentUser->agentnums_sql
. ($agentnum ? "AND cust_main.agentnum = $agentnum" : ''),