{
global $path_to_root, $SysPrefs,
$type_shortcuts;
-
+ $day_range = (isset($SysPrefs->max_days_in_docs) ? $SysPrefs->max_days_in_docs : 180);
$st = '';
switch ($type)
{
.TB_PREF."debtor_trans debtor_trans LEFT JOIN ".TB_PREF."voided AS vd ON debtor_trans.type=vd.type AND
debtor_trans.trans_no=vd.id
WHERE debtor_trans.type=".ST_SALESINVOICE." AND debtor.debtor_no=debtor_trans.debtor_no AND ISNULL(vd.id)
+ AND debtor_trans.tran_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
ORDER BY debtor_trans.trans_no DESC";
return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false));
.TB_PREF."debtor_trans debtor_trans LEFT JOIN ".TB_PREF."voided AS vd ON debtor_trans.type=vd.type AND
debtor_trans.trans_no=vd.id
WHERE debtor_trans.type=".ST_CUSTCREDIT." AND debtor.debtor_no=debtor_trans.debtor_no AND ISNULL(vd.id)
+ AND debtor_trans.tran_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
ORDER BY debtor_trans.trans_no DESC";
return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false));
.TB_PREF."debtor_trans debtor_trans LEFT JOIN ".TB_PREF."voided AS vd ON debtor_trans.type=vd.type AND
debtor_trans.trans_no=vd.id
WHERE debtor_trans.type=".ST_CUSTDELIVERY." AND debtor.debtor_no=debtor_trans.debtor_no AND ISNULL(vd.id)
+ AND debtor_trans.tran_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
ORDER BY debtor_trans.trans_no DESC";
return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false));
$sql = "SELECT sorder.order_no, concat(sorder.$ref, '-', debtor.name) as IName
FROM ".TB_PREF."debtors_master debtor,"
.TB_PREF."sales_orders sorder
- WHERE debtor.debtor_no=sorder.debtor_no AND sorder.trans_type=".ST_SALESORDER
- ." ORDER BY sorder.order_no DESC";
+ WHERE debtor.debtor_no=sorder.debtor_no AND sorder.trans_type=".ST_SALESORDER."
+ AND sorder.ord_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
+ ORDER BY sorder.order_no DESC";
return combo_input($name, '', $sql, 'order_no', 'IName',array('order'=>false));
case 'QUOTATIONS':
$sql = "SELECT sorder.order_no, concat(sorder.$ref, '-', debtor.name) as IName
FROM ".TB_PREF."debtors_master debtor,"
.TB_PREF."sales_orders sorder
- WHERE debtor.debtor_no=sorder.debtor_no AND sorder.trans_type=".ST_SALESQUOTE
- ." ORDER BY sorder.order_no DESC";
+ WHERE debtor.debtor_no=sorder.debtor_no AND sorder.trans_type=".ST_SALESQUOTE."
+ AND sorder.ord_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
+ ORDER BY sorder.order_no DESC";
return combo_input($name, '', $sql, 'order_no', 'IName',array('order'=>false));
case 'PO':
FROM ".TB_PREF."suppliers supplier,"
.TB_PREF."purch_orders po
WHERE supplier.supplier_id=po.supplier_id
+ AND po.ord_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
ORDER BY po.order_no DESC";
return combo_input($name, '', $sql, 'order_no', 'IName',array('order'=>false));
.TB_PREF."supp_trans trans LEFT JOIN ".TB_PREF."voided AS vd ON trans.type=vd.type AND trans.trans_no=vd.id
WHERE trans.type IN(".ST_BANKPAYMENT.",".ST_SUPPAYMENT.",".ST_SUPPCREDIT.") AND
supplier.supplier_id=trans.supplier_id AND ISNULL(vd.id)
+ AND trans.tran_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
ORDER BY trans.trans_no DESC";
return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false));
.TB_PREF."debtor_trans trans LEFT JOIN ".TB_PREF."voided AS vd ON trans.type=vd.type AND trans.trans_no=vd.id
WHERE trans.type IN(".ST_BANKDEPOSIT.",".ST_CUSTPAYMENT.",".ST_CUSTCREDIT.") AND
debtor.debtor_no=trans.debtor_no AND ISNULL(vd.id)
+ AND trans.tran_date > SUBDATE(CURRENT_DATE, INTERVAL $day_range DAY)
ORDER BY trans.trans_no DESC";
return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false));