}
function getDisplay()
{
- global $path_to_root, $use_date_picker;
+ global $comp_path, $path_to_root, $use_date_picker;
+
+ $rep_file = $comp_path.'/'.user_company().
+ "/reporting/rep".$this->id.".php";
+ if (!file_exists($rep_file))
+ $rep_file = $path_to_root ."/reporting/rep".$this->id.".php";
+
$st = "
<script language='javascript'>
function displayReport_" . $this->id . "() {
window.open('','REP_WINDOW','toolbar=no,scrollbar=no,resizable=yes,menubar=no');
document.forms[0].target='REP_WINDOW';
- document.forms[0].action= '" . $path_to_root . "/reporting/rep" . $this->id . ".php';
+ document.forms[0].action= '$rep_file';
document.forms[0].submit();
}
function checkDate(pObj) {
$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);
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