function customer_age($cusnum, $days, $fcid, $loc) { $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } $sql = "\n\tSELECT sum(amount) FROM cubit.stmnt\n\tWHERE cusnum='{$cusnum}' AND\n\t\tdate BETWEEN '" . extlib_ago($ldays) . "' AND '" . extlib_ago($days - 29) . "'"; $amount_rslt = db_exec($sql) or errDie("Unable to retrieve aging."); $amount = pg_fetch_result($amount_rslt, 0); return sprint($amount); }
function age($supid, $days) { $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } # Get the current outstanding $sql = "SELECT sum(balance) FROM suppurch WHERE supid = '{$supid}' AND pdate >='" . extlib_ago($ldays) . "' AND pdate <='" . extlib_ago($days - 30) . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); /* # Get the current outstanding $sql = "SELECT sum(balance) FROM purch_int WHERE supid = '$supid' AND balance > 0 AND received = 'y' AND pdate >='".extlib_ago($days)."' AND pdate <='".extlib_ago($days-30)."'"; $rsint = db_exec($sql) or errDie("Unable to access database"); $sumint = pg_fetch_array($rsint); */ # Take care of nasty zero return $sum['sum'] += 0; }
function age($cusnum, $days) { $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } # Get the current oustanding $sql = "SELECT sum(balance) FROM invoices WHERE cusnum = '{$cusnum}' AND printed = 'y' AND odate >='" . extlib_ago($ldays) . "' AND odate <='" . extlib_ago($days - 30) . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); # Get the current oustanding on transactions $sql = "SELECT sum(balance) FROM custran WHERE cusnum = '{$cusnum}' AND odate >='" . extlib_ago($ldays) . "' AND odate <='" . extlib_ago($days - 30) . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sumb = pg_fetch_array($rs); # Take care of nasty zero return $sum['sum'] + $sumb['sum'] + 0; }
function sage($supid, $days) { $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } # Get the current outstanding $sql = "SELECT sum(fbalance) FROM suppurch WHERE supid = '{$supid}' AND pdate >='" . extlib_ago($ldays) . "' AND pdate <='" . extlib_ago($days - 30) . "' AND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); # Take care of nasty zero return $sum['sum'] += 0; }
function age($cusnum, $days) { $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } if (div_isset("DEBT_AGE", "mon")) { switch ($days) { case 29: return ageage($cusnum, 0); case 59: return ageage($cusnum, 1); case 89: return ageage($cusnum, 2); case 119: return ageage($cusnum, 3); case 149: return ageage($cusnum, 4); } } # Get the current oustanding $sql = "SELECT sum(balance) FROM cubit.invoices\n\t\t\tWHERE cusnum = '{$cusnum}' AND printed = 'y'\n\t\t\t\tAND odate >='" . extlib_ago($ldays) . "'\n\t\t\t\tAND odate <'" . extlib_ago($days - 30) . "'\n\t\t\t\tAND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); # Get the current oustanding on transactions $sql = "SELECT sum(balance) FROM cubit.custran\n\t\t\tWHERE cusnum = '{$cusnum}' AND odate >='" . extlib_ago($ldays) . "'\n\t\t\t\tAND odate <'" . extlib_ago($days - 30) . "'\n\t\t\t\tAND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sumb = pg_fetch_array($rs); # Take care of nasty zero return sprint($sum['sum'] + $sumb['sum']); }
function age($cusnum, $days, $fcid, $loc) { $rate = getRate($fcid); $bal = "balance"; if ($loc == 'int') { $bal = "fbalance"; $rate = 1; } if ($rate == 0) { $rate = 1; } $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } # Get the current oustanding $sql = "SELECT sum({$bal}) FROM invoices WHERE cusnum = '{$cusnum}' AND printed = 'y' AND odate >='" . extlib_ago($ldays) . "' AND odate <'" . extlib_ago($days - 30) . "' AND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); # Get the current oustanding on transactions $sql = "SELECT sum({$bal}) FROM custran WHERE cusnum = '{$cusnum}' AND odate >='" . extlib_ago($ldays) . "' AND odate <'" . extlib_ago($days - 30) . "' AND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sumb = pg_fetch_array($rs); # Take care of nasty zero return sprint($sum['sum'] + $sumb['sum'] + 0); }
function age($supid, $days) { $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } $getfromyear = date("Y"); $gettoyear = date("Y"); $month = date("m"); #use customer statement date for default $get_stmnt = "SELECT setdays FROM suppliers WHERE supid = '{$supid}' LIMIT 1"; $run_stmnt = db_exec($get_stmnt) or errDie("Unable to get statement date information."); if (pg_numrows($run_stmnt) < 1) { $stmnt_day = date("d"); } else { $stmnt_day = pg_fetch_result($run_stmnt, 0, 0); } if ($stmnt_day == "0") { $stmnt_day = date("d", mktime(0, 0, 0, $month + 1, 0, $gettoyear)); } $stmnt_date = "{$gettoyear}-{$month}-{$stmnt_day}"; if ($days == 29) { #current $from_date = date("Y-m-d", mktime(0, 0, 0, $month, $stmnt_day, $gettoyear)); $to_date = date("Y-m-d", mktime(0, 0, 0, $month + 1, $stmnt_day - 1, $gettoyear)); } elseif ($days == 59) { #30 days $from_date = date("Y-m-d", mktime(0, 0, 0, $month - 1, $stmnt_day, $gettoyear)); $to_date = date("Y-m-d", mktime(0, 0, 0, $month, $stmnt_day - 1, $gettoyear)); } elseif ($days == 89) { #60 days $from_date = date("Y-m-d", mktime(0, 0, 0, $month - 2, $stmnt_day, $gettoyear)); $to_date = date("Y-m-d", mktime(0, 0, 0, $month - 1, $stmnt_day - 1, $gettoyear)); } elseif ($days == 119) { #90 days $from_date = date("Y-m-d", mktime(0, 0, 0, $month - 3, $stmnt_day, $gettoyear)); $to_date = date("Y-m-d", mktime(0, 0, 0, $month - 2, $stmnt_day - 1, $gettoyear)); } elseif ($days == 149) { #120 days $from_date = date("Y-m-d", mktime(0, 0, 0, $month - 4, $stmnt_day, $gettoyear - 5)); $to_date = date("Y-m-d", mktime(0, 0, 0, $month - 3, $stmnt_day - 1, $gettoyear)); } else { $from_date = $stmnt_date; $to_date = $stmnt_date; } $oldmethod = TRUE; $newmethod = FALSE; // check allocation state $get_check = "SELECT id, allocation_linked FROM cubit.sup_stmnt WHERE supid = '{$supid}'"; $run_check = db_exec($get_check) or errDie("Unable to get allocation check information."); if (pg_numrows($run_check) > 0) { while ($tarr = pg_fetch_array($run_check)) { if (strlen($tarr['allocation_linked']) > 0) { $old_method = FALSE; $newmethod = TRUE; } } } if ($newmethod) { $get_entries = "\n\t\t\tSELECT amount, allocation_balance FROM cubit.sup_stmnt \n\t\t\tWHERE supid = '{$supid}' AND edate BETWEEN '{$from_date}' AND '{$to_date}'"; $run_entries = db_exec($get_entries) or errDie("Unable to get statement information"); if (pg_numrows($run_entries) < 1) { $amount = 0; } else { while ($aarr = pg_fetch_array($run_entries)) { if ($aarr['amount'] > 0) { $amount += $aarr['allocation_balance']; } else { $amount -= $aarr['allocation_balance']; } } } return sprint($amount); } else { # Get the current outstanding $sql = "\n\t\t\tSELECT sum(balance) \n\t\t\tFROM suppurch \n\t\t\tWHERE supid = '{$supid}' AND pdate >='" . extlib_ago($ldays) . "' AND pdate <'" . extlib_ago($days - 30) . "' AND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); /* # Get the current outstanding $sql = "SELECT sum(balance) FROM purch_int WHERE supid = '$supid' AND balance > 0 AND received = 'y' AND pdate >='".extlib_ago($days)."' AND pdate <='".extlib_ago($days-30)."'"; $rsint = db_exec($sql) or errDie("Unable to access database"); $sumint = pg_fetch_array($rsint); */ # Take care of nasty zero return sprint($sum['sum']); } }
function age($supid, $days, $loc) { $bal = "balance"; if ($loc == 'int') { $bal = "fbalance"; } $ldays = $days; if ($days == 149) { $ldays = 365 * 10; } db_connect(); # Get the current outstanding $sql = "SELECT sum({$bal}) FROM suppurch WHERE supid = '{$supid}' AND pdate >='" . extlib_ago($ldays) . "' AND pdate <='" . extlib_ago($days - 30) . "' AND div = '" . USER_DIV . "'"; $rs = db_exec($sql) or errDie("Unable to access database"); $sum = pg_fetch_array($rs); # Take care of nasty zero return sprint($sum['sum'] += 0); }