X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Freports_classes.inc;h=761ef43cb922364f0e28d5740e9ad38a9b5b70af;hb=de148378f0ada5ab90a8dbd63cf7c54adf65b6c9;hp=06eff1bd8e6fdc3f00e1131116bdb5a43b8a27c7;hpb=c7353ffde8fbcd970585936b006641dfaa1f7f77;p=fa-stable.git diff --git a/reporting/includes/reports_classes.inc b/reporting/includes/reports_classes.inc index 06eff1bd..761ef43c 100644 --- a/reporting/includes/reports_classes.inc +++ b/reporting/includes/reports_classes.inc @@ -138,12 +138,12 @@ class Report if ($param->param_type == 'DATEBEGINM') $date = begin_month($date); elseif ($param->param_type == 'DATEENDM') - $date = enc_month($date); + $date = end_month($date); elseif ($param->param_type == 'DATEBEGINTAX' || $param->param_type == 'DATEENDTAX') { $row = get_company_prefs(); $edate = add_months($date, -$row['tax_last']); - $edate = enc_month($edate); + $edate = end_month($edate); if ($param->param_type == 'DATEENDTAX') $date = $edate; else @@ -164,6 +164,10 @@ class Report $sel = array(_('No'), _("Yes")); $st .= dup_simple_name_list("RP_" . $this->id . "_$index", $sel); break; + case 'PAYMENT_LINK': + $sel = array(_("No Payment Link"), "PayPal"); + $st .= dup_simple_name_list("RP_" . $this->id . "_$index", $sel); + break; case 'COMPARE': $sel = array(_("Accumulated"), _("Period Y-1"), _("Budget")); $st .= dup_simple_name_list("RP_" . $this->id . "_$index", $sel); @@ -242,6 +246,16 @@ class Report FROM ".TB_PREF."debtors_master, ".TB_PREF."debtor_trans WHERE (type=10 OR type=11) AND ".TB_PREF."debtors_master.debtor_no=".TB_PREF."debtor_trans.debtor_no ORDER BY ".TB_PREF."debtor_trans.trans_no DESC"; $st .= dup_simple_codeandname_list($sql, "RP_" . $this->id . "_$index", $dummy); break; + case 'DELIVERY': + $DN = _("DN"); + $sql = "SELECT + concat(".TB_PREF."debtor_trans.trans_no, '-', ".TB_PREF."debtor_trans.type) AS TNO, concat(".TB_PREF."debtor_trans.trans_no, ' $DN ', + ".TB_PREF."debtors_master.name) as IName + FROM ".TB_PREF."debtors_master, ".TB_PREF."debtor_trans + WHERE type=13 AND ".TB_PREF."debtors_master.debtor_no=". + TB_PREF."debtor_trans.debtor_no ORDER BY ".TB_PREF."debtor_trans.trans_no DESC"; + $st .= dup_simple_codeandname_list($sql, "RP_" . $this->id . "_$index", $dummy); + break; case 'ORDERS': $sql = "SELECT ".TB_PREF."sales_orders.order_no, concat(".TB_PREF."sales_orders.order_no, '-', ".TB_PREF."debtors_master.name) as IName