|
Support Incident Tracker GIT4.x
|
|
Support Incident Tracker GIT4.x
|
Go to the source code of this file.
Enumerations | |
| enum | BILLING_APPROVED |
| enum | BILLING_AWAITINGAPPROVAL |
| enum | BILLING_RESERVED |
Functions | |
| does_contact_have_billable_contract ($contactid) | |
| get_billable_contract_id ($contactid) | |
| get_site_billable_contract_id ($siteid) | |
| get_service_percentage ($maintid) | |
| is_contract_timed ($contractid) | |
| update_last_billed_time ($serviceid, $date) | |
| get_billable_multiplier ($dayofweek, $hour, $billingmatrix= 'Default') | |
| get_all_available_multipliers ($matrixid='') | |
| get_unit_rate ($contractid, $date='') | |
| get_service_unitrate ($serviceid) | |
| get_service_incidentrate ($serviceid) | |
| get_serviceid ($contractid, $date= '') | |
| get_contract_balance ($contractid, $includenonapproved=FALSE, $showonlycurrentlyvalid=TRUE, $includereserved=TRUE) | |
| get_overdraft ($contractid) | |
| reserve_monies ($serviceid, $linktype, $linkref, $amount, $description) | |
| transition_reserved_monites ($transactionid, $amount, $description='') | |
| unreserve_monies ($transactionid, $linktype) | |
| update_reservation ($transactionid, $amount, $description='') | |
| update_transaction ($transactionid, $amount, $description='', $status) | |
| close_billable_incident ($incidentid) | |
| approve_incident_transaction ($transactionid) | |
| update_contract_balance ($contractid, $description, $amount, $serviceid='', $transactionid='', $totalunits=0, $totalbillableunits=0, $totalrefunds=0) | |
| maintid_from_transaction ($transactionid) | |
| contract_transaction_total ($contractid, $status) | |
| service_transaction_total ($serviceid, $status) | |
| get_service_balance ($serviceid, $includeawaitingapproval=TRUE, $includereserved=TRUE) | |
| is_billable_incident_approved ($incidentid) | |
| get_incident_transactionid ($incidentid) | |
| contract_service_table ($contractid, $billing) | |
| get_incident_billing_details ($incidentid) | |
| group_billing_periods (&$count, $countType, $activity, $period) | |
| make_incident_billing_array ($incidentid, $totals=TRUE) | |
| billable_units_site ($siteid, $startdate=0, $enddate=0) | |
| get_incident_billable_breakdown_array ($incidentid) | |
| contract_unit_balance ($contractid, $includenonapproved=FALSE, $includereserved=TRUE, $showonlycurrentlyvalid=TRUE) | |
| contract_balance ($contractid, $includenonapproved=FALSE, $includereserved=TRUE, $showonlycurrentlyvalid=TRUE) | |
| transactions_report ($serviceid, $startdate, $enddate, $sites, $display, $sitebreakdown=TRUE, $showfoc=TRUE, $focaszero=FALSE, $includeawaitingapproval=TRUE, $includereserved=TRUE) | |
| service_dropdown_contract ($contractid, $name, $selected=0) | |
| service_dropdown_site ($siteid, $name, $selected=0) | |
| is_transaction_approved ($transactionid) | |
| enum BILLING_APPROVED |
Definition at line 17 of file billing.inc.php.
Definition at line 18 of file billing.inc.php.
| enum BILLING_RESERVED |
Definition at line 19 of file billing.inc.php.
| approve_incident_transaction | ( | $ | transactionid | ) |
Function to approve an incident, this adds a transaction and confirms the 'bill' is correct.
| incidentid | ID of the incident to approve |
Definition at line 775 of file billing.inc.php.
References $CONFIG, $dbLinks, $incidentid, $result, $s, $serviceid, $sql, $strUnits, E_USER_WARNING, get_all_available_multipliers(), get_incident_billable_breakdown_array(), get_unit_rate(), incident_maintid(), and update_contract_balance().
{
global $dbLinks, $sit, $CONFIG, $strUnits;
$rtnvalue = TRUE;
// Check transaction exists, and is awaiting approval and is an incident
$sql = "SELECT l.linkcolref, t.serviceid FROM `{$GLOBALS['dbLinks']}` AS l, `{$GLOBALS['dbTransactions']}` AS t ";
$sql .= "WHERE t.transactionid = l.origcolref AND t.transactionstatus = ".BILLING_AWAITINGAPPROVAL." AND l.linktype = 6 AND t.transactionid = {$transactionid}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error identify incident transaction. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
list($incidentid, $serviceid) = mysql_fetch_row($result);
$bills = get_incident_billable_breakdown_array($incidentid);
$multipliers = get_all_available_multipliers();
$totalunits = 0;
$totalbillableunits = 0;
$totalrefunds = 0;
foreach ($bills AS $bill)
{
foreach ($multipliers AS $m)
{
$a[$m] += $bill[$m]['count'];
}
}
foreach ($multipliers AS $m)
{
$s .= sprintf($GLOBALS['strXUnitsAtX'], $a[$m], $m);
$totalbillableunits += ($m * $a[$m]);
$totalunits += $a[$m];
}
$unitrate = get_unit_rate(incident_maintid($incidentid));
$totalrefunds += $bills['refunds'];
$cost = (($totalbillableunits += $totalrefunds) * $unitrate) * -1;
$desc = trim("Incident {$incidentid}: {$totalbillableunits}: {$strUnits} @ {$CONFIG['currency_symbol']}{$unitrate}. {$s}"); //FIXME i18n
$rtn = update_contract_balance(incident_maintid($incidentid), $desc, $cost, $serviceid, $transactionid, $totalunits, $totalbillableunits, $totalrefunds);
if ($rtn == FALSE)
{
$rtnvalue = FALSE;
}
}
else
{
$rtnvalue = FALSE;
}
return $rtnvalue;
}
| billable_units_site | ( | $ | siteid, |
| $ | startdate = 0, |
||
| $ | enddate = 0 |
||
| ) |
Returns the amount of billable units used for a site with the option of filtering by date
| int | $siteid | The siteid to report on |
| int | $startdate | unixtimestamp on the start date to filter by |
| int | $enddate | unixtimestamp on the end date to filter by |
Definition at line 1528 of file billing.inc.php.
References $enddate, $obj, $result, $sql, $startdate, E_USER_WARNING, and make_incident_billing_array().
{
$sql = "SELECT i.id FROM `{$GLOBALS['dbIncidents']}` AS i, `{$GLOBALS['dbContacts']}` AS c ";
$sql .= "WHERE c.id = i.contact AND c.siteid = {$siteid} ";
if ($startdate != 0)
{
$sql .= "AND closed >= {$startdate} ";
}
if ($enddate != 0)
{
$sql .= "AND closed <= {$enddate} ";
}
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
$units = 0;
if (mysql_num_rows($result) > 0)
{
while ($obj = mysql_fetch_object($result))
{
$a = make_incident_billing_array($obj->id);
$units += $a[-1]['totalcustomerperiods'];
}
}
return $units;
}
| close_billable_incident | ( | $ | incidentid | ) |
Do the necessary tasks to billable incidents on closure, including creating transactions
| int | $incidentid | The incident ID to do the close on, if its not a billable incident then no actions are performed |
Definition at line 665 of file billing.inc.php.
References $contractid, $date, $incidentid, $now, $result, $s, $serviceid, $sql, E_USER_ERROR, E_USER_WARNING, get_all_available_multipliers(), get_incident_billable_breakdown_array(), get_serviceid(), get_unit_rate(), and incident_maintid().
Referenced by saction_CloseIncidents().
{
global $now, $sit;
$rtnvalue = TRUE;
$sql = "SELECT i.maintenanceid FROM `{$GLOBALS['dbIncidents']}` AS i, `{$GLOBALS['dbServiceLevels']}` AS sl ";
$sql .= "WHERE i.servicelevel = sl.tag AND i.priority = sl.priority AND i.id = {$incidentid} AND sl.timed = 'yes'";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error("Error identifying if incident was timed ".mysql_error(), E_USER_WARNING);
$rtnvalue = FALSE;
}
if (mysql_num_rows($result) > 0)
{
// Was logged against a timed contract
list($contractid) = mysql_fetch_row($result);
$duration = 0;
$sql = "SELECT SUM(duration) FROM `{$GLOBALS['dbUpdates']}` WHERE incidentid = {$incidentid}";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error("Error getting duration for billable incident. ".mysql_error(), E_USER_WARNING);
$rtnvalue = FALSE;
}
list($duration) = mysql_fetch_row($result);
if ($duration > 0)
{
// There where activities on this update so add to the transactions table
$bills = get_incident_billable_breakdown_array($incidentid);
$multipliers = get_all_available_multipliers();
$totalunits = 0;
$totalbillableunits = 0;
$totalrefunds = 0;
foreach ($bills AS $bill)
{
foreach ($multipliers AS $m)
{
$a[$m] += $bill[$m]['count'];
}
}
foreach ($multipliers AS $m)
{
$s .= sprintf($GLOBALS['strXUnitsAtX'], $a[$m], $m);
$totalunits += $a[$m];
$totalbillableunits += ($m * $a[$m]);
}
$unitrate = get_unit_rate(incident_maintid($incidentid));
$totalrefunds = $bills['refunds'];
// $numberofunits += $bills['refunds'];
$cost = (($totalbillableunits + $totalrefunds) * $unitrate) * -1;
$desc = trim("{$numberofunits} {$strUnits} @ {$CONFIG['currency_symbol']}{$unitrate} for incident {$incidentid}. {$s}"); //FIXME i18n
// $rtn = update_contract_balance(incident_maintid($incidentid), $desc, $cost);
// Add transaction
$serviceid = get_serviceid($contractid);
if ($serviceid < 1) trigger_error("Invalid service ID",E_USER_ERROR);
$date = date('Y-m-d H:i:s', $now);
$sql = "INSERT INTO `{$GLOBALS['dbTransactions']}` (serviceid, totalunits, totalbillableunits, totalrefunds, amount, description, userid, dateupdated, transactionstatus) ";
$sql .= "VALUES ('{$serviceid}', '{$totalunits}', '{$totalbillableunits}', '{$totalrefunds}', '{$cost}', '{$desc}', '{$_SESSION['userid']}', '{$date}', '".BILLING_AWAITINGAPPROVAL."')";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error("Error inserting transaction. ".mysql_error(), E_USER_WARNING);
$rtnvalue = FALSE;
}
$transactionid = mysql_insert_id();
if ($transactionid != FALSE)
{
$sql = "INSERT INTO `{$GLOBALS['dbLinks']}` VALUES (6, {$transactionid}, {$incidentid}, 'left', {$_SESSION['userid']})";
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1)
{
trigger_error("Link transaction on closure failed",E_USER_ERROR);
$rtnvalue = FALSE;
}
}
}
}
return $rtnvalue;
}
| contract_balance | ( | $ | contractid, |
| $ | includenonapproved = FALSE, |
||
| $ | includereserved = TRUE, |
||
| $ | showonlycurrentlyvalid = TRUE |
||
| ) |
| int | $contractid,. | Contract ID of the contract to show a balance for |
Definition at line 1693 of file billing.inc.php.
References $contractid, $dbService, $now, $result, $sql, contract_transaction_total(), and E_USER_WARNING.
{
global $now, $dbService;
$unitbalance = 0;
$sql = "SELECT * FROM `{$dbService}` WHERE contractid = {$contractid} ";
if ($showonlycurrentlyvalid)
{
$sql .= "AND UNIX_TIMESTAMP(startdate) <= {$now} ";
$sql .= "AND UNIX_TIMESTAMP(enddate) >= {$now} ";
}
$sql .= "ORDER BY enddate DESC";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
while ($service = mysql_fetch_object($result))
{
$balance += round($service->balance);
}
}
if ($includenonapproved)
{
$awaiting = contract_transaction_total($contractid, BILLING_AWAITINGAPPROVAL);
if ($awaiting != 0) $balance += round($awaiting);
}
if ($includereserved)
{
$reserved = contract_transaction_total($contractid, BILLING_RESERVED);
if ($reserved != 0) $balance += round($reserved);
}
return $balance;
}
| contract_service_table | ( | $ | contractid, |
| $ | billing | ||
| ) |
HTML table showing a summary of current contract service periods
| int | $contractid,. | Contract ID of the contract to show service for |
| bool | $billing,. | Show billing info when TRUE, hide it when FALSE |
Definition at line 1086 of file billing.inc.php.
References $CONFIG, $dbService, $expired, $now, $operations, $result, $shade, $sql, E_USER_WARNING, elseif, get_service_balance(), html_action_links(), ldate(), mysql2date(), and service_transaction_total().
Referenced by contract_details().
{
global $CONFIG, $dbService, $now;
$sql = "SELECT * FROM `{$dbService}` WHERE contractid = {$contractid} ORDER BY enddate DESC";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
$shade = 'shade1';
$html = "\n<table class='maintable' id='contractservicetable'>";
$html .= "<tr>";
if ($billing) $html .= "<th></th>";
$html .= "<th>{$GLOBALS['strStartDate']}</th><th>{$GLOBALS['strEndDate']}</th>";
if ($billing)
{
$html .= "<th>{$GLOBALS['strAvailableBalance']}</th>";
}
$html .= "<th>{$GLOBALS['strActions']}</th>";
$html .= "</tr>\n";
while ($service = mysql_fetch_object($result))
{
$service->startdate = mysql2date($service->startdate . '09:00');
$service->enddate = mysql2date($service->enddate . '17:00');
$service->lastbilled = mysql2date($service->lastbilled);
$expired = false;
$future = false;
if ($service->enddate < $now) $expired = true;
if ($service->startdate > $now) $future = true;
if ($future)
{
$shade = 'notice';
}
elseif ($expired)
{
$shade = 'expired';
}
$html .= "<tr class='{$shade}'>";
if ($billing)
{
$balance = get_service_balance($service->serviceid);
$awaitingapproval = service_transaction_total($service->serviceid, BILLING_AWAITINGAPPROVAL) * -1;
$reserved = service_transaction_total($service->serviceid, BILLING_RESERVED) * -1;
$span = "<strong>{$GLOBALS['strServiceID']}:</strong> {$service->serviceid}<br />";
if (!empty($service->title))
{
$span .= "<strong>{$GLOBALS['strTitle']}</strong>: {$service->title}<br />";
}
if (!empty($service->notes))
{
$span .= "<strong>{$GLOBALS['strNotes']}</strong>: {$service->notes}<br />";
}
if (!empty($service->cust_ref))
{
$span .= "<strong>{$GLOBALS['strCustomerReference']}</strong>: {$service->cust_ref}";
if ($service->cust_ref_date != "1970-01-01")
{
$span .= " - <strong>{$GLOBALS['strCustomerReferenceDate']}</strong>: {$service->cust_ref_date}";
}
$span .= "<br />";
}
if ($service->creditamount != 0)
{
$span .= "<strong>{$GLOBALS['strCreditAmount']}</strong>: {$CONFIG['currency_symbol']}".number_format($service->creditamount, 2)."<br />";
}
if ($service->unitrate != 0)
{
$span .= "<strong>{$GLOBALS['strUnitRate']}</strong>: {$CONFIG['currency_symbol']}{$service->unitrate}<br />";
}
$span .= "<strong>{$GLOBALS['strBillingMatrix']}</string>: {$service->billingmatrix}<br />";
if ($balance != $service->balance)
{
$span .= "<strong>{$GLOBALS['strBalance']}</strong>: {$CONFIG['currency_symbol']}".number_format($service->balance, 2)."<br />";
if ($awaitingapproval != FALSE)
{
$span .= "<strong>{$GLOBALS['strAwaitingApproval']}</strong>: {$CONFIG['currency_symbol']}".number_format($awaitingapproval, 2)."<br />";
}
if ($reserved != FALSE)
{
$span .= "<strong>{$GLOBALS['strReserved']}</strong>: {$CONFIG['currency_symbol']}".number_format($reserved, 2)."<br />";
}
$span .= "<strong>{$GLOBALS['strAvailableBalance']}</strong>: ";
if (!$expired)
{
$span .= "{$CONFIG['currency_symbol']}".number_format($balance, 2);
}
else
{
$span .= $GLOBALS['strExpired'];
}
$span .= "<br />";
}
if ($service->lastbilled > 0)
{
$span .= "<strong>{$GLOBALS['strLastBilled']}</strong>: ".ldate($CONFIG['dateformat_date'], $service->lastbilled)."<br />";
}
if ($service->foc == 'yes')
{
$span .= "<strong>{$GLOBALS['strFreeOfCharge']}</strong>";
}
$html .= "<td><a name='billingicon' class='info'>".icon('billing', 16);
if (!empty($span))
{
$html .= "<span>{$span}</span>";
}
$html .= "</a></td>";
$html .= "<td><a href='transactions.php?serviceid={$service->serviceid}' class='info'>".ldate($CONFIG['dateformat_date'], $service->startdate);
if (!empty($span))
{
$html .= "<span>{$span}</span>";
}
$html .= "</a></td>";
}
else
{
$html .= "<td>".ldate($CONFIG['dateformat_date'],$service->startdate);
$html .= "</td>";
}
$html .= "<td>";
$html .= ldate($CONFIG['dateformat_date'], $service->enddate)."</td>";
if ($billing)
{
$html .= "<td>{$CONFIG['currency_symbol']}";
if (!$expired) $html .= number_format($balance, 2);
else $html .= "0";
$html .= "</td>";
}
$html .= "<td>";
$operations[$GLOBALS['strEditService']] = array('url' => "contract_edit_service.php?mode=editservice&serviceid={$service->serviceid}&contractid={$contractid}", 'perm' => PERM_SERVICE_EDIT);
if ($billing)
{
$operations[$GLOBALS['strEditBalance']] = array('url' => "contract_edit_service.php?mode=showform&sourceservice={$service->serviceid}&contractid={$contractid}", 'perm' => PERM_SERVICE_BALANCE_EDIT);
$operations[$GLOBALS['strViewTransactions']] = array('url' => "transactions.php?serviceid={$service->serviceid}", 'perm' => PERM_BILLING_TRANSACTION_VIEW);
}
$html .= html_action_links($operations);
$html .= "</td></tr>\n";
if ($shade == 'shade1') $shade = 'shade2';
else $shade = 'shade1';
}
$html .= "</table>\n";
}
return $html;
}
| contract_transaction_total | ( | $ | contractid, |
| $ | status | ||
| ) |
Returns the total value of inicidents in a particular status
| int | $contractid,. | Contract ID of the contract to find total value of inicdents awaiting approval |
| int | $status | The type you are after e.g. BILLING_AWAITINGAPPROVAL, BILLING_APPROVED, BILLING_RESERVED |
Definition at line 956 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
Referenced by contract_balance(), contract_unit_balance(), and get_contract_balance().
{
$rtnvalue = FALSE;
$sql = "SELECT SUM(t.amount) FROM `{$GLOBALS['dbTransactions']}` AS t, `{$GLOBALS['dbService']}` AS s ";
$sql .= "WHERE s.serviceid = t.serviceid AND s.contractid = {$contractid} AND t.transactionstatus = '{$status}'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting total for type {$status}. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
list($rtnvalue) = mysql_fetch_row($result);
}
return $rtnvalue;
}
| contract_unit_balance | ( | $ | contractid, |
| $ | includenonapproved = FALSE, |
||
| $ | includereserved = TRUE, |
||
| $ | showonlycurrentlyvalid = TRUE |
||
| ) |
| int | $contractid,. | Contract ID of the contract to show a balance for |
Definition at line 1643 of file billing.inc.php.
References $contractid, $dbService, $now, $result, $sql, contract_transaction_total(), E_USER_WARNING, and get_billable_multiplier().
{
global $now, $dbService;
$unitbalance = 0;
$sql = "SELECT * FROM `{$dbService}` WHERE contractid = {$contractid} ";
if ($showonlycurrentlyvalid)
{
$sql .= "AND UNIX_TIMESTAMP(startdate) <= {$now} ";
$sql .= "AND UNIX_TIMESTAMP(enddate) >= {$now} ";
}
$sql .= "ORDER BY enddate DESC";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
while ($service = mysql_fetch_object($result))
{
$multiplier = get_billable_multiplier(strtolower(date('D', $now)), date('G', $now));
$unitamount = $service->unitrate * $multiplier;
if ($unitamount > 0 AND $service->balance != 0) $unitbalance += round($service->balance / $unitamount);
}
if ($includenonapproved)
{
$awaiting = contract_transaction_total($contractid, BILLING_AWAITINGAPPROVAL);
if ($awaiting != 0) $unitbalance += round($awaiting / $unitamount);
}
if ($includereserved)
{
$reserved = contract_transaction_total($contractid, BILLING_RESERVED);
if ($reserved != 0) $unitbalance += round($reserved / $unitamount);
}
}
return $unitbalance;
}
| does_contact_have_billable_contract | ( | $ | contactid | ) |
Returns if the contact has a timed contract or if the site does in the case of the contact not.
| int | $contactid |
Definition at line 27 of file billing.inc.php.
References $contactid, $now, $obj, $result, $return, $siteid, $sql, contact_siteid(), E_USER_ERROR, and E_USER_WARNING.
{
global $now;
$return = NO_BILLABLE_CONTRACT;
$siteid = contact_siteid($contactid);
$sql = "SELECT DISTINCT m.id FROM `{$GLOBALS['dbMaintenance']}` AS m, `{$GLOBALS['dbServiceLevels']}` AS sl ";
$sql .= "WHERE m.servicelevel = sl.tag AND sl.timed = 'yes' AND m.site = {$siteid} ";
$sql .= "AND m.expirydate > {$now} AND m.term != 'yes'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
// We have some billable/timed contracts
$return = SITE_HAS_BILLABLE_CONTRACT;
// check if the contact is listed on one of these
while ($obj = mysql_fetch_object($result))
{
$sqlcontact = "SELECT * FROM `{$GLOBALS['dbSupportContacts']}` ";
$sqlcontact .= "WHERE maintenanceid = {$obj->id} AND contactid = {$contactid}";
$resultcontact = mysql_query($sqlcontact);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_ERROR);
if (mysql_num_rows($resultcontact) > 0)
{
$return = CONTACT_HAS_BILLABLE_CONTRACT;
break;
}
}
}
return $return;
}
| get_all_available_multipliers | ( | $ | matrixid = '' | ) |
Function to get an array of all billing multipliers for a billing matrix
| String | $matrixid | The TAG of the billing matrix being used, defaults to 'Default' |
Definition at line 259 of file billing.inc.php.
References $obj, $result, $sql, and E_USER_WARNING.
Referenced by approve_incident_transaction(), and close_billable_incident().
{
$days = array('mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'sun', 'holiday');
foreach ($days AS $d)
{
$sql = "SELECT DISTINCT({$d}) AS day FROM `{$GLOBALS['dbBillingMatrix']}` ";
if (!empty($matrixid)) $sql .= " WHERE tag = '{$matrixid}'";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
while ($obj = mysql_fetch_object($result))
{
$a[$obj->day] = $obj->day;
}
}
ksort($a);
return $a;
}
| get_billable_contract_id | ( | $ | contactid | ) |
Gets the billable contract ID for a contact, if multiple exist then the first one is choosen
| int | $contactid | - The contact ID you want to find the contract for |
Definition at line 73 of file billing.inc.php.
References $contactid, $now, $result, $return, $siteid, $sql, contact_siteid(), and E_USER_WARNING.
{
global $now;
$return = -1;
$siteid = contact_siteid($contactid);
$sql = "SELECT DISTINCT m.id FROM `{$GLOBALS['dbMaintenance']}` AS m, `{$GLOBALS['dbServiceLevels']}` AS sl ";
$sql .= "WHERE m.servicelevel = sl.tag AND sl.timed = 'yes' AND m.site = {$siteid} ";
$sql .= "AND m.expirydate > {$now} AND m.term != 'yes'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
$return = mysql_fetch_object($result)->id;
}
return $return;
}
| get_billable_multiplier | ( | $ | dayofweek, |
| $ | hour, | ||
| $ | billingmatrix = 'Default' |
||
| ) |
Find the billing multiple that should be applied given the day, time and matrix in use
| string | $dayofweek | 'mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'sun' or 'holiday' |
| int | $hour | The hour in the day, values in the range 0 - 23 |
| string | $billingmatrix | The billing matrix to get the multiple from, defaults to 'Default' |
Definition at line 230 of file billing.inc.php.
References $obj, $result, $sql, and E_USER_WARNING.
Referenced by contract_details(), contract_unit_balance(), and get_incident_billable_breakdown_array().
{
$sql = "SELECT `{$dayofweek}` AS rate FROM {$GLOBALS['dbBillingMatrix']} WHERE hour = {$hour} AND tag = '{$billingmatrix}'";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
$rate = 1;
if (mysql_num_rows($result) > 0)
{
$obj = mysql_fetch_object($result);
$rate = $obj->rate;
}
return $rate;
}
| get_contract_balance | ( | $ | contractid, |
| $ | includenonapproved = FALSE, |
||
| $ | showonlycurrentlyvalid = TRUE, |
||
| $ | includereserved = TRUE |
||
| ) |
Get the current contract balance
| int | $contractid,. | Contract ID of the contract to credit |
| bool | $includenonapproved,. | Include incidents which have not been approved |
| bool | $showonlycurrentlyvalue | - Show only contracts which have valid NOW() - i.e. startdate less than NOW() and endate greate than NOW() |
| bool | $includereserved | - Deduct the reseved amount from the returned balance |
Definition at line 417 of file billing.inc.php.
References $contractid, $dbService, $now, $result, $sql, contract_transaction_total(), and E_USER_WARNING.
Referenced by contract_details().
{
global $dbService, $now;
$balance = 0.00;
$sql = "SELECT SUM(balance) FROM `{$dbService}` ";
$sql .= "WHERE contractid = {$contractid} ";
if ($showonlycurrentlyvalid)
{
$sql .= "AND UNIX_TIMESTAMP(startdate) <= {$now} ";
$sql .= "AND UNIX_TIMESTAMP(enddate) >= {$now} ";
}
$result = mysql_query($sql);
if (mysql_error()) trigger_error(mysql_error(), E_USER_WARNING);
list($balance) = mysql_fetch_row($result);
if ($includenonapproved)
{
// Need to get sum of non approved incidents for this contract and deduct
$balance += contract_transaction_total($contractid, BILLING_AWAITINGAPPROVAL);
}
if ($includereserved)
{
$balance += contract_transaction_total($contractid, BILLING_RESERVED);
}
return $balance;
}
| get_incident_billable_breakdown_array | ( | $ | incidentid | ) |
Function to make an array with the number of units at each billable multiplier, broken down by engineer
| int | $incidentid | The inicident to create the billing breakdown for |
Definition at line 1571 of file billing.inc.php.
References $day, $incidentid, $month, $result, $serviceid, $sql, $year, E_USER_WARNING, get_billable_multiplier(), get_serviceid(), incident_maintid(), is_day_bank_holiday(), and make_incident_billing_array().
Referenced by approve_incident_transaction(), and close_billable_incident().
{
$billable = make_incident_billing_array($incidentid, FALSE);
$billingmatrix = '';
$serviceid = get_serviceid(incident_maintid($incidentid));
$sql = "SELECT billingmatrix FROM `{$GLOBALS['dbService']}` WHERE serviceid = {$serviceid}";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error("Unable to get billing matrix for service {$serviceid} ".mysql_error(),E_USER_WARNING);
}
list($billingmatrix) = mysql_fetch_row($result);
//echo "<pre>";
//print_r($billable);
//echo "</pre>";
if (!empty($billable))
{
foreach ($billable AS $engineer)
{
if (is_array($engineer) AND empty($engineer['refunds']))
{
$engineerName = $engineer['owner'];
foreach ($engineer['customerperiods'] AS $period)
{
// $period is the start time
$day = date('D', $period);
$hour = date('H', $period);
$dayNumber = date('d', $period);
$month = date('n', $period);
$year = date('Y', $period);
// echo "DAY {$day} HOUR {$hour}";
$dayofweek = strtolower($day);
if (is_day_bank_holiday($dayNumber, $month, $year))
{
$dayofweek = "holiday";
}
$multiplier = get_billable_multiplier($dayofweek, $hour, $billingmatrix);
$billing[$engineerName]['owner'] = $engineerName;
$billing[$engineerName][$multiplier]['multiplier'] = $multiplier;
if (empty($billing[$engineerName][$multiplier]['count']))
{
$billing[$engineerName][$multiplier]['count'] = 0;
}
$billing[$engineerName][$multiplier]['count']++;
}
}
}
if (!empty($billable[-1]['refunds'])) $billing['refunds'] = $billable[-1]['refunds'];
}
return $billing;
}
| get_incident_billing_details | ( | $ | incidentid | ) |
Creates a billing array containing an entry for every activity that has happened for the duration of the incident specfified.
| int | $incidentid | - Incident number of the incident to create the array from |
Definition at line 1258 of file billing.inc.php.
References $obj, $result, $sql, and E_USER_WARNING.
Referenced by make_incident_billing_array().
{
/*
$array[owner][] = array(owner, starttime, duration)
*/
$sql = "SELECT * FROM `{$GLOBALS['dbUpdates']}` WHERE incidentid = {$incidentid} AND duration IS NOT NULL";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
if (mysql_num_rows($result) > 0)
{
while($obj = mysql_fetch_object($result))
{
if ($obj->duration > 0)
{
$temparray['owner'] = $obj->userid;
$temparray['starttime'] = ($obj->timestamp-($obj->duration*60));
$temparray['duration'] = $obj->duration;
$billing[$obj->userid][] = $temparray;
}
else
{
if (empty($billing['refunds'])) $billing['refunds'] = 0;
$billing['refunds'] += $obj->duration;
}
}
}
return $billing;
}
| get_incident_transactionid | ( | $ | incidentid | ) |
Gets the transactionID for an incident
| int | $incidentid | The incidentID |
Definition at line 1058 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
{
$rtnvalue = FALSE;
$sql = "SELECT origcolref ";
$sql .= "FROM `{$GLOBALS['dbLinks']}` AS l, `{$GLOBALS['dbTransactions']}` AS t ";
$sql .= "WHERE l.linktype = 6 ";
$sql .= "AND l.origcolref = t.transactionid ";
$sql .= "AND linkcolref = {$incidentid} ";
$sql .= "AND direction = 'left' ";
$result = mysql_query($sql);
if (mysql_error()) trigger_error(mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
list($rtnvalue) = mysql_fetch_row($result);
}
return $rtnvalue;
}
| get_overdraft | ( | $ | contractid | ) |
Get the overdraft limit for a contract
| int | $contractid | - The contract to check on |
Definition at line 454 of file billing.inc.php.
References $result, $sql, $tag, and E_USER_WARNING.
{
$rtnvalue = FALSE;
$sql = "SELECT DISTINCT sl.tag FROM `{$GLOBALS['dbServiceLevels']}` AS sl, `{$GLOBALS['dbMaintenance']}` AS m ";
$sql .= "WHERE m.servicelevel = sl.tag AND m.id = {$contractid}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting servicelevel details. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) == 1)
{
list($tag) = mysql_fetch_row($result);
$sql = "SELECT DISTINCT limit FROM `{$GLOBALS['dbBillingPeriods']}` ";
$sql .= "WHERE AND tag = '{$tag}'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting servicelevel details. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) == 1)
{
list($rtnvalue) = mysql_fetch_row($result);
}
}
return $rtnvalue;
}
| get_service_balance | ( | $ | serviceid, |
| $ | includeawaitingapproval = TRUE, |
||
| $ | includereserved = TRUE |
||
| ) |
Get the current balance of a service
| int | $serviceid,. | Service ID of the service to get the balance for |
| int | $includeawaitingapproval,. | Deduct the total awaiting approval from the balance |
| int | $includereserved,. | Deduct the total reserved from the balance |
Definition at line 1004 of file billing.inc.php.
References $dbService, $result, $serviceid, $sql, E_USER_WARNING, and service_transaction_total().
Referenced by contract_service_table(), and reserve_monies().
{
global $dbService;
$balance = FALSE;
$sql = "SELECT balance FROM `{$dbService}` WHERE serviceid = {$serviceid}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error(mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) == 1)
{
list($balance) = mysql_fetch_row($result);
if ($includeawaitingapproval)
{
$balance += service_transaction_total($serviceid, BILLING_AWAITINGAPPROVAL);
}
if ($includereserved)
{
$balance += service_transaction_total($serviceid, BILLING_RESERVED);
}
}
return $balance;
}
| get_service_incidentrate | ( | $ | serviceid | ) |
Returns the incident rate for a service
| int | $serviceid | - The serviceID to get the incident rate for |
Definition at line 343 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
{
$rtnvalue = FALSE;
$sql = "SELECT incidentrate FROM `{$GLOBALS['dbService']}` AS p WHERE serviceid = {$serviceid}";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
if (mysql_num_rows($result) > 0)
{
list($rtnvalue) = mysql_fetch_row($result);
}
return $rtnvalue;
}
| get_service_percentage | ( | $ | maintid | ) |
Returns the percentage remaining for ALL services on a contract
| int | $mainid | - contract ID |
Definition at line 132 of file billing.inc.php.
References $dbService, $result, $return, $sql, $total, and E_USER_WARNING.
{
global $dbService;
$sql = "SELECT * FROM `{$dbService}` ";
$sql .= "WHERE contractid = {$maintid}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
$num = 0;
while ($service = mysql_fetch_object($result))
{
$total += (float) $service->balance / (float) $service->creditamount;
$num++;
}
$return = (float) $total / (float) $num;
}
else
{
$return = FALSE;
}
return $return;
}
| get_service_unitrate | ( | $ | serviceid | ) |
Returns the unit rate for a service
| int | $serviceid | - The serviceID to get the unit rate for |
Definition at line 316 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
Referenced by get_unit_rate().
{
$rtnvalue = FALSE;
$sql = "SELECT unitrate FROM `{$GLOBALS['dbService']}` AS p WHERE serviceid = {$serviceid}";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
if (mysql_num_rows($result) > 0)
{
list($rtnvalue) = mysql_fetch_row($result);
}
return $rtnvalue;
}
| get_serviceid | ( | $ | contractid, |
| $ | date = '' |
||
| ) |
| int | $contractid | The Contract ID |
| int | $date | UNIX timestamp. The function will look for service that is current as of this timestamp |
Definition at line 370 of file billing.inc.php.
References $CONFIG, $date, $now, $result, $serviceid, $sql, and E_USER_WARNING.
Referenced by close_billable_incident(), get_incident_billable_breakdown_array(), get_unit_rate(), and update_contract_balance().
{
global $now, $CONFIG;
if (empty($date)) $date = $now;
$sql = "SELECT serviceid FROM `{$GLOBALS['dbService']}` AS s ";
$sql .= "WHERE contractid = {$contractid} AND UNIX_TIMESTAMP(startdate) <= {$date} ";
$sql .= "AND UNIX_TIMESTAMP(enddate) > {$date} ";
$sql .= "AND (balance > 0 OR (select count(1) FROM `{$GLOBALS['dbService']}` WHERE contractid = s.contractid AND balance > 0) = 0) ";
if (!$CONFIG['billing_allow_incident_approval_against_overdrawn_service'])
{
$sql .= "AND balance > 0 ";
}
$sql .= "ORDER BY priority DESC, enddate ASC, balance DESC LIMIT 1";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
$serviceid = -1;
if (mysql_num_rows($result) > 0)
{
list($serviceid) = mysql_fetch_row($result);
}
return $serviceid;
}
| get_site_billable_contract_id | ( | $ | siteid | ) |
Gte sthe billable contract ID for a site, if multiple exist then the first one is choosen
| int | $siteid | - The site ID you want to find the contract for |
Definition at line 103 of file billing.inc.php.
References $now, $result, $return, $sql, and E_USER_WARNING.
{
global $now;
$return = -1;
$sql = "SELECT DISTINCT m.id FROM `{$GLOBALS['dbMaintenance']}` AS m, `{$GLOBALS['dbServiceLevels']}` AS sl ";
$sql .= "WHERE m.servicelevel = sl.tag AND sl.timed = 'yes' AND m.site = {$siteid} ";
$sql .= "AND m.expirydate > {$now} AND m.term != 'yes'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
$return = mysql_fetch_object($result)->id;
}
return $return;
}
| get_unit_rate | ( | $ | contractid, |
| $ | date = '' |
||
| ) |
Function to find the most applicable unit rate for a particular contract
| int | $contractid | - The contract id |
| string | $date | UNIX timestamp. The function will look for service that is current as of this timestamp |
Definition at line 293 of file billing.inc.php.
References $contractid, $date, $serviceid, get_service_unitrate(), and get_serviceid().
Referenced by approve_incident_transaction(), and close_billable_incident().
{
$serviceid = get_serviceid($contractid, $date);
if ($serviceid != -1)
{
$unitrate = get_service_unitrate($serviceid);
}
else
{
$unitrate = -1;
}
return $unitrate;
}
| group_billing_periods | ( | &$ | count, |
| $ | countType, | ||
| $ | activity, | ||
| $ | period | ||
| ) |
Takes an array of engineer/times of services and groups them so we have only periods which should be charged for. This takes into account tasks started in the same period by the same engineer e.g. task started at 17:00 for 10 mins another at 17:30 for 10 mins with a period of 60mins only one is reported
| array | $count | (Passed by reference) The array to return into, either the 'engineer' or 'customer' element see $countType |
| string | $countType | The counttype we are doing so either engineer or customer |
| array | $activity | The current activity |
| int | $period | The billing period to group to (in seconds) |
Definition at line 1305 of file billing.inc.php.
References $count.
Referenced by make_incident_billing_array().
{
$duration = $activity['duration'] * 60;
$startTime = $activity['starttime'];
if (!empty($count[$countType]))
{
while ($duration > 0)
{
$saved = "false";
foreach ($count[$countType] AS $ind)
{
/*
echo "<pre>";
print_r($ind);
echo "</pre>";
*/
//echo "IN:{$ind}:START:{$act['starttime']}:ENG:{$engineerPeriod}<br />";
if($ind <= $activity['starttime'] AND $ind <= ($activity['starttime'] + $period))
{
//echo "IND:{$ind}:START:{$act['starttime']}<br />";
// already have something which starts in this period just need to check it fits in the period
if($ind + $period > $activity['starttime'] + $duration)
{
$remainderInPeriod = ($ind + $period) - $activity['starttime'];
$duration -= $remainderInPeriod;
$saved = "true";
}
}
}
//echo "Saved: {$saved}<br />";
// This section runs when there are no engineer or customer billing period totals yet (first iteration)
if ($saved == "false" AND $activity['duration'] > 0)
{
//echo "BB:".$activity['starttime'].":SAVED:{$saved}:DUR:{$activity['duration']}<br />";
// need to add a new block
$count[$countType][$startTime] = $startTime;
$startTime += $period;
$duration -= $period;
}
}
}
else
{
$count[$countType][$activity['starttime']] = $activity['starttime'];
$localDur = $duration - $period;
while ($localDur > 0)
{
$startTime += $period;
$count[$countType][$startTime] = $startTime;
$localDur -= $period; // was just -
}
}
}
| is_billable_incident_approved | ( | $ | incidentid | ) |
Function to identify if incident has been approved for billing
Definition at line 1035 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
{
$sql = "SELECT DISTINCT origcolref, linkcolref ";
$sql .= "FROM `{$GLOBALS['dbLinks']}` AS l, `{$GLOBALS['dbTransactions']}` AS t ";
$sql .= "WHERE l.linktype = 6 ";
$sql .= "AND l.origcolref = t.transactionid ";
$sql .= "AND linkcolref = {$incidentid} ";
$sql .= "AND direction = 'left' ";
$sql .= "AND t.transactionstatus = '".BILLING_APPROVED."'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error(mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0) return TRUE;
else return FALSE;
}
| is_contract_timed | ( | $ | contractid | ) |
Does a contract have a service level which is timed / billed
| int | $contractid |
Definition at line 167 of file billing.inc.php.
References $dbMaintenance, $dbServiceLevels, $result, $sql, and E_USER_WARNING.
{
global $dbMaintenance, $dbServiceLevels;
$timed = FALSE;
$sql = "SELECT timed FROM `{$dbMaintenance}` AS m, `{$dbServiceLevels}` AS sl ";
$sql .= "WHERE m.servicelevel = sl.tag AND m.id = {$contractid}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
list($timed) = mysql_fetch_row($result);
if ($timed == 'yes')
{
return TRUE;
}
else
{
return FALSE;
}
}
| is_transaction_approved | ( | $ | transactionid | ) |
Identify if a transaction has been approved or not
| int | $transactionid | The transaction ID to check |
Definition at line 2118 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
{
$sql = "SELECT transactionid FROM `{$GLOBALS['dbTransactions']}` WHERE transactionid = {$transactionid} AND transactionstaus = ".BILLING_APPROVED;
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting services. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0) return TRUE;
else return FALSE;
}
| maintid_from_transaction | ( | $ | transactionid | ) |
Gets the maintenanceID for a incident transaction
| int | $transactionid | The transaction ID to get the maintenance id from |
Definition at line 932 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
{
$rtnvalue = -1;
$sql = "SELECT i.maintenanceid FROM `{$GLOBALS['dbLinks']}` AS l, `{$GLOBALS['dbIncidents']}` AS i WHERE ";
$sql .= "l.origcolref = {$transactionid} AND l.linkcolref = i.id AND l.linktype = 6";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting maintid for transaction. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
list($rtnvalue) = mysql_fetch_row($result);
}
return $rtnvalue;
}
| make_incident_billing_array | ( | $ | incidentid, |
| $ | totals = TRUE |
||
| ) |
| int | $incidentid,. | Incident ID |
| bool | $totals,. | Set to TRUE to include period totals in the array |
| bool | FALSE - Failure |
| array | billing array |
Definition at line 1375 of file billing.inc.php.
References $count, $incident, $incidentid, $owner, $priority, $result, $servicelevel_tag, $sql, $totals, E_USER_WARNING, get_incident_billing_details(), group_billing_periods(), and user_realname().
Referenced by billable_units_site(), and get_incident_billable_breakdown_array().
{
$billing = get_incident_billing_details($incidentid);
// echo "<pre>";
// print_r($billing);
// echo "</pre><hr />";
$sql = "SELECT servicelevel, priority FROM `{$GLOBALS['dbIncidents']}` WHERE id = {$incidentid}";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_WARNING);
return FALSE;
}
$incident = mysql_fetch_object($result);
$servicelevel_tag = $incident->servicelevel;
$priority = $incident->priority;
if (!empty($billing))
{
$billingSQL = "SELECT * FROM `{$GLOBALS['dbBillingPeriods']}` WHERE tag='{$servicelevel_tag}' AND priority='{$priority}'";
/*
echo "<pre>";
print_r($billing);
echo "</pre>";
echo "<pre>";
print_r(make_billing_array($incidentid));
echo "</pre>";
*/
//echo $billingSQL;
$billingresult = mysql_query($billingSQL);
// echo $billingSQL;
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
$billingObj = mysql_fetch_object($billingresult);
unset($billingresult);
$engineerPeriod = $billingObj->engineerperiod * 60; //to seconds
$customerPeriod = $billingObj->customerperiod * 60;
if (empty($engineerPeriod) OR $engineerPeriod == 0) $engineerPeriod = 3600;
if (empty($customerPeriod) OR $customerPeriod == 0) $customerPeriod = 3600;
/*
echo "<pre>";
print_r($billing);
echo "</pre>";
*/
$count = array();
// Loop over each activity that happened during the duration of the incident
// Grouped by Engineer - and then calculate totals
foreach ($billing AS $engineer)
{
/*
[eng][starttime]
*/
if (is_array($engineer))
{
$owner = "";
$duration = 0;
unset($count);
$count = array();
$count['engineer'];
$count['customer'];
foreach ($engineer AS $activity)
{
$owner = user_realname($activity['owner']);
$duration += $activity['duration'];
/*
echo "<pre>";
print_r($count);
echo "</pre>";
*/
group_billing_periods($count, 'engineer', $activity, $engineerPeriod);
// Optimisation no need to compute again if we already have the details
if ($engineerPeriod != $customerPeriod)
{
group_billing_periods($count, 'customer', $activity, $customerPeriod);
}
else
{
$count['customer'] = $count['engineer'];
}
}
$tduration += $duration;
$totalengineerperiods += sizeof($count['engineer']);
$totalcustomerperiods += sizeof($count['customer']);
/*
echo "<pre>";
print_r($count);
echo "</pre>";
*/
$billing_a[$activity['owner']]['owner'] = $owner;
$billing_a[$activity['owner']]['duration'] = $duration;
$billing_a[$activity['owner']]['engineerperiods'] = $count['engineer'];
$billing_a[$activity['owner']]['customerperiods'] = $count['customer'];
}
if ($totals == TRUE)
{
if (empty($totalengineerperiods)) $totalengineerperiods = 0;
if (empty($totalcustomerperiods)) $totalcustomerperiods = 0;
if (empty($tduration)) $tduration = 0;
$billing_a[-1]['totalduration'] = $tduration;
$billing_a[-1]['totalengineerperiods'] = $totalengineerperiods;
$billing_a[-1]['totalcustomerperiods'] = $totalcustomerperiods;
$billing_a[-1]['customerperiod'] = $customerPeriod;
$billing_a[-1]['engineerperiod'] = $engineerPeriod;
}
if (!empty($billing['refunds'])) $billing_a[-1]['refunds'] = $billing['refunds']/$customerPeriod; // return refunds as a number of units
else $billing_a[-1]['refunds'] = 0;
}
}
//echo "<pre>";
//print_r($billing_a);
//echo "</pre>";
return $billing_a;
}
| reserve_monies | ( | $ | serviceid, |
| $ | linktype, | ||
| $ | linkref, | ||
| $ | amount, | ||
| $ | description | ||
| ) |
Reserve monies from a serviceid
| int | $serviceid | - The serviceID to reserve monies from |
| int | $linktype | - The type of link to create between the transaction and the reserve type |
| int | $linkref | - The ID to link this transaction to |
| int | $amount | - The positive amount of money to reserve |
| string | $description | - A description to put on the reservation |
Definition at line 489 of file billing.inc.php.
References $amount, $now, $result, $serviceid, $sql, E_USER_ERROR, E_USER_WARNING, and get_service_balance().
{
global $now, $sit;
$rtnvalue = FALSE;
$balance = get_service_balance($serviceid, TRUE, TRUE);
// TODO take into account overdraft limit
$amount *= -1;
if ($balance != FALSE)
{
$sql = "INSERT INTO `{$GLOBALS['dbTransactions']}` (serviceid, amount, description, userid, dateupdated, transactionstatus) ";
$sql .= "VALUES ('{$serviceid}', '{$amount}', '{$description}', '{$_SESSION['userid']}', '".date('Y-m-d H:i:s', $now)."', '".BILLING_RESERVED."')";
$result = mysql_query($sql);
if (mysql_error())
{
trigger_error("Error inserting transaction. ".mysql_error(), E_USER_WARNING);
$rtnvalue = FALSE;
}
$rtnvalue = mysql_insert_id();
if ($rtnvalue != FALSE)
{
$sql = "INSERT INTO `{$GLOBALS['dbLinks']}` VALUES ({$linktype}, {$rtnvalue}, {$linkref}, 'left', '{$_SESSION['userid']}')";
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1)
{
trigger_error("Link reservation failed",E_USER_ERROR);
$rtnvalue = FALSE;
}
}
}
return $rtnvalue;
}
| service_dropdown_contract | ( | $ | contractid, |
| $ | name, | ||
| $ | selected = 0 |
||
| ) |
Produces a HTML dropdown of all valid services for a contract
| int | $contractid | The contract ID to report on |
| int | $name | name for the dropdown |
| int | $selected | The service ID to select |
Definition at line 2039 of file billing.inc.php.
References $CONFIG, $now, $obj, $result, $selected, $sql, and E_USER_WARNING.
{
global $now, $CONFIG;
$sql = "SELECT * FROM `{$GLOBALS['dbService']}` WHERE contractid = {$contractid} ";
$sql .= "AND UNIX_TIMESTAMP(startdate) <= {$now} AND UNIX_TIMESTAMP(enddate) >= {$now}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting services. ".mysql_error(), E_USER_WARNING);
$html = FALSE;
if (mysql_num_rows($result) > 0)
{
$html = "<select name='{$name}' id={$name}>\n";
$html .= "<option value='0' ";
if ($selected == 0) $html .= " selected='selected' ";
$html .= "></option>";
while ($obj = mysql_fetch_object($result))
{
$html .= "<option value='{$obj->serviceid}' ";
if ($selected == $obj->serviceid) $html .= " selected='selected' ";
$html .= ">{$CONFIG['currency_symbol']}".get_service_balance($obj->serviceid, TRUE, TRUE);
$html .= " ({$obj->startdate} - {$obj->enddate})</option>";
}
$html .= "</select>\n";
}
return $html;
}
| service_dropdown_site | ( | $ | siteid, |
| $ | name, | ||
| $ | selected = 0 |
||
| ) |
Produces a HTML dropdown of all valid services for a site
| int | $contractid | The contract ID to report on |
| int | $name | name for the dropdown |
| int | $selected | The service ID to select |
Definition at line 2077 of file billing.inc.php.
References $CONFIG, $now, $obj, $result, $selected, $sql, and E_USER_WARNING.
{
global $now, $CONFIG;
$sql = "SELECT s.* FROM `{$GLOBALS['dbService']}` AS s, `{$GLOBALS['dbMaintenance']}` AS m ";
$sql .= "WHERE s.contractid = m.id AND m.site = {$siteid} ";
$sql .= "AND UNIX_TIMESTAMP(s.startdate) <= {$now} AND UNIX_TIMESTAMP(s.enddate) >= {$now}";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting services. ".mysql_error(), E_USER_WARNING);
$html = FALSE;
if (mysql_num_rows($result) > 0)
{
$html = "<select name='{$name}' id={$name}>\n";
$html .= "<option value='0' ";
if ($selected == 0) $html .= " selected='selected' ";
$html .= "></option>";
while ($obj = mysql_fetch_object($result))
{
$html .= "<option value='{$obj->serviceid}' ";
if ($selected == $obj->serviceid) $html .= " selected='selected' ";
$html .= ">{$CONFIG['currency_symbol']}".get_service_balance($obj->serviceid, TRUE, TRUE);
$html .= " ({$obj->startdate} - {$obj->enddate})</option>";
}
$html .= "</select>\n";
}
else
{
$html = "No services currently valid";
}
return $html;
}
| service_transaction_total | ( | $ | serviceid, |
| $ | status | ||
| ) |
Get the total of all transactions on a particular service of a certain type
| int | $serviceid | The serviceID to report on |
| int | $status | The status' to get the transaction report for' |
Definition at line 980 of file billing.inc.php.
References $result, $sql, and E_USER_WARNING.
Referenced by contract_service_table(), and get_service_balance().
{
$rtnvalue = FALSE;
$sql = "SELECT SUM(amount) FROM `{$GLOBALS['dbTransactions']}` ";
$sql .= "WHERE serviceid = {$serviceid} AND transactionstatus = '{$status}'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("Error getting total for type {$status}. ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
list($rtnvalue) = mysql_fetch_row($result);
}
return $rtnvalue;
}
| transactions_report | ( | $ | serviceid, |
| $ | startdate, | ||
| $ | enddate, | ||
| $ | sites, | ||
| $ | display, | ||
| $ | sitebreakdown = TRUE, |
||
| $ | showfoc = TRUE, |
||
| $ | focaszero = FALSE, |
||
| $ | includeawaitingapproval = TRUE, |
||
| $ | includereserved = TRUE |
||
| ) |
Function to display/generate the transactions table
| int | $serviceid | - The service ID to show transactons for |
| Date | $startdate | - Date in format yyyy-mm-dd when you want to start the report from |
| Date | $enddate | - Date in format yyyy-mm-dd when you want to end the report, empty means today |
| int[] | $sites - Array of sites to report on | |
| String | $display | either csv or html |
| boolean | $sitebreakdown | - Breakdown per site |
| boolean | $showfoc | - Show free of charge as well (defaults to true); |
| boolean | $includeawaitingapproval | - Include transactions awaiting approval |
| boolean | $includereserved | - Include reserved transactions |
Definition at line 1749 of file billing.inc.php.
References $CONFIG, $csv_currency, $display, $enddate, $focaszero, $result, $s, $serviceid, $shade, $showfoc, $site, $sitebreakdown, $sites, $sitestr, $sql, $startdate, $text, $total, clean_int(), E_USER_WARNING, elseif, mysql2date(), and site_name().
Referenced by saction_MailPreviousMonthsTransactions().
{
global $CONFIG;
$csv_currency = html_entity_decode($CONFIG['currency_symbol'], ENT_NOQUOTES, "ISO-8859-15"); // Note using -15 as -1 doesnt support euro
$sql = "SELECT DISTINCT t.*, m.site, p.foc, p.cust_ref, p.cust_ref_date, p.title, p.notes ";
$sql .= "FROM `{$GLOBALS['dbTransactions']}` AS t, `{$GLOBALS['dbService']}` AS p, ";
$sql .= "`{$GLOBALS['dbMaintenance']}` AS m, `{$GLOBALS['dbServiceLevels']}` AS sl, `{$GLOBALS['dbSites']}` AS s ";
$sql .= "WHERE t.serviceid = p.serviceid AND p.contractid = m.id "; // AND t.date <= '{$enddateorig}' ";
$sql .= "AND m.servicelevel = sl.tag AND sl.timed = 'yes' AND m.site = s.id ";
if ($serviceid > 0) $sql .= "AND t.serviceid = {$serviceid} ";
if (!empty($startdate)) $sql .= "AND t.dateupdated >= '{$startdate}' ";
if (!empty($enddate)) $sql .= "AND t.dateupdated <= '{$enddate}' ";
$orsql[] = "t.transactionstatus = ".BILLING_APPROVED;
if ($includeawaitingapproval) $orsql[] = "t.transactionstatus = ".BILLING_AWAITINGAPPROVAL;
if ($includereserved) $orsql[] = "t.transactionstatus = ".BILLING_RESERVED;
$o = implode(" OR ", $orsql);
$sql .= "AND ($o) ";
if (!$showfoc) $sql .= "AND p.foc = 'no' ";
if (!empty($sites))
{
$sitestr = '';
foreach ($sites AS $s)
{
$s = clean_int($s);
if (empty($sitestr)) $sitestr .= "m.site = {$s} ";
else $sitestr .= "OR m.site = {$s} ";
}
$sql .= "AND {$sitestr} ";
}
if (!empty($site)) $sql .= "AND m.site = {$site} ";
$sql .= "ORDER BY t.dateupdated, s.name ";
$result = mysql_query($sql);
if (mysql_error()) trigger_error("MySQL Query Error ".mysql_error(), E_USER_WARNING);
if (mysql_num_rows($result) > 0)
{
$shade = 'shade1';
$total = 0;
$totalcredit = 0;
$totaldebit = 0;
$details = '';
while ($transaction = mysql_fetch_object($result))
{
if ($display == 'html')
{
if ($serviceid > 0 AND empty($details))
{
if (!empty($transaction->cust_ref))
{
$details .= "<tr>";
$details .= "<th>{$GLOBALS['strCustomerReference']}</th><td>{$transaction->cust_ref}</td>";
if ($transaction->cust_ref_date != "1970-01-01")
{
$details .= "<th>{$GLOBALS['strCustomerReferenceDate']}</th><td>{$transaction->cust_ref_date}</td>";
}
$details .= "</tr>";
}
if (!empty($transaction->title))
{
$details .= "<tr><th>{$GLOBALS['strTitle']}</th><td>{$transaction->title}</td></tr>";
}
if (!empty($transaction->notes))
{
$details .= "<tr><th>{$GLOBALS['strNotes']}</th><td>{$transaction->notes}</td></tr>";
}
}
$str = "<tr class='$shade'>";
$str .= "<td>" . date($CONFIG['dateformat_datetime'], mysql2date($transaction->dateupdated)) . "</td>";
$str .= "<td>{$transaction->transactionid}</td>";
$str .= "<td>{$transaction->serviceid}</td>";
$str .= "<td>".site_name($transaction->site)."</td>";
$str .= "<td>{$transaction->description}</td>";
$str .= "<td>";
switch ($transaction->transactionstatus)
{
case BILLING_APPROVED: $str .= $GLOBALS['strApproved'];
break;
case BILLING_AWAITINGAPPROVAL: $str .= $GLOBALS['strAwaitingApproval'];
break;
case BILLING_RESERVED: $str .= $GLOBALS['strReserved'];
break;
}
$str .= "</td>";
}
elseif ($display == 'csv')
{
if ($serviceid > 0 AND empty($details))
{
if (!empty($transaction->cust_ref))
{
$details .= "\"{$GLOBALS['strCustomerReference']}\",\"{$transaction->cust_ref}\",";
if ($transaction->cust_ref_date != "1970-01-01")
{
$details .= "\"{$GLOBALS['strCustomerReferenceDate']}\",\"{$transaction->cust_ref_date}\",";
}
$details .= "\n";
}
if (!empty($transaction->title))
{
$details .= "\"{$GLOBALS['strTitle']}\",\"{$transaction->title}\"\n";
}
if (!empty($transaction->notes))
{
$details .= "\"{$GLOBALS['strNotes']}\",\"{$transaction->notes}\"\n";
}
}
$str = "\"" . date($CONFIG['dateformat_datetime'], mysql2date($transaction->dateupdated)) . "\",";
$str .= "\"{$transaction->transactionid}\",";
$str .= "\"{$transaction->serviceid}\",\"";
$str .= site_name($transaction->site)."\",";
$str .= "\"".html_entity_decode($transaction->description)."\",";
$str .= "\"";
switch ($transaction->transactionstatus)
{
case BILLING_APPROVED:
$str .= $GLOBALS['strApproved'];
break;
case BILLING_AWAITINGAPPROVAL:
$str .= $GLOBALS['strAwaitingApproval'];
break;
case BILLING_RESERVED:
$str .= $GLOBALS['strReserved'];
break;
}
$str .= "\",";
}
if ($focaszero AND $transaction->foc == 'yes')
{
$transaction->amount = 0;
}
$total += $transaction->amount;
if ($transaction->amount < 0)
{
$totaldebit += $transaction->amount;
if ($display == 'html')
{
$str .= "<td></td><td>{$CONFIG['currency_symbol']}".number_format($transaction->amount, 2)."</td>";
}
elseif ($display == 'csv')
{
$str .= ",\"{$csv_currency}".number_format($transaction->amount, 2)."\",";
}
}
else
{
$totalcredit += $transaction->amount;
if ($display == 'html')
{
$str .= "<td>{$CONFIG['currency_symbol']}".number_format($transaction->amount, 2)."</td><td></td>";
}
elseif ($display == 'csv')
{
$str .= "\"{$csv_currency}".number_format($transaction->amount, 2)."\",,";
}
}
if ($display == 'html') $str .= "</tr>";
elseif ($display == 'csv') $str .= "\n";
if ($sitebreakdown == TRUE)
{
$table[$transaction->site]['site'] = site_name($transaction->site);
$table[$transaction->site]['str'] .= $str;
if ($transaction->amount < 0)
{
$table[$transaction->site]['debit'] += $transaction->amount;
}
else
{
$table[$transaction->site]['credit'] += $transaction->amount;
}
}
else
{
$table .= $str;
}
if ($shade == 'shade1') $shade = 'shade2';
else $shade = 'shade1';
}
if ($sitebreakdown == TRUE)
{
foreach ($table AS $e)
{
if ($display == 'html')
{
$text .= "<h3>{$e['site']}</h3>";
$text .= "<table align='center' width='60%'>";
//echo "<tr><th colspan='7'>{$e['site']}</th></tr>";
$text .= "<tr><th>{$GLOBALS['strDate']}</th><th>{$GLOBALS['strID']}</th><th>{$GLOBALS['strServiceID']}</th>";
$text .= "<th>{$GLOBALS['strSite']}</th><th>{$GLOBALS['strDescription']}</th><th>{$GLOBALS['strCredit']}</th><th>{$GLOBALS['strDebit']}</th></tr>";
$text .= $e['str'];
$text .= "<tr><td colspan='5' align='right'>{$GLOBALS['strTotal']}</td>";
$text .= "<td>{$CONFIG['currency_symbol']}".number_format($e['credit'], 2)."</td>";
$text .= "<td>{$CONFIG['currency_symbol']}".number_format($e['debit'], 2)."</td></tr>";
$text .= "</table>";
}
elseif ($display == 'csv')
{
$text .= "\"{$e['site']}\"\n\n";
$text .= "\"{$GLOBALS['strDate']}\",\"{$GLOBALS['strID']}\",\"{$GLOBALS['strServiceID']}\",";
$text .= "\"{$GLOBALS['strSite']}\",\"{$GLOBALS['strDescription']}\",\"{$GLOBALS['strCredit']}\",\"{$GLOBALS['strDebit']}\"\n";
$text .= $e['str'];
$text .= ",,,,{$GLOBALS['strTotal']},";
$text .= "\"{$csv_currency}".number_format($e['credit'], 2)."\",\"";
$text .="{$csv_currency}".number_format($e['debit'], 2)."\"\n";
}
}
}
else
{
if ($display == 'html')
{
if (!empty($details))
{
// Dont need to worry about this in the above section as sitebreakdown and serviceid are multually exclusive
$text .= "<div><table class='maintable'>{$details}</table></div>";
}
$text .= "<table class='maintable'>";
$text .= "<tr><th>{$GLOBALS['strDate']}</th><th>{$GLOBALS['strID']}</th><th>{$GLOBALS['strServiceID']}</th>";
$text .= "<th>{$GLOBALS['strSite']}</th>";
$text .= "<th>{$GLOBALS['strDescription']}</th><th>{$GLOBALS['strStatus']}</th><th>{$GLOBALS['strCredit']}</th><th>{$GLOBALS['strDebit']}</th></tr>";
$text .= $table;
$text .= "<tfoot><tr><td colspan='6' align='right'>{$GLOBALS['strTOTALS']}</td>";
$text .= "<td>{$CONFIG['currency_symbol']}".number_format($totalcredit, 2)."</td>";
$text .= "<td>{$CONFIG['currency_symbol']}".number_format($totaldebit, 2)."</td></tr></tfoot>";
$text .= "</table>";
}
elseif ($display == 'csv')
{
if (!empty($details))
{
$text .= $details;
}
$text .= "\"{$GLOBALS['strDate']}\",\"{$GLOBALS['strID']}\",\"{$GLOBALS['strServiceID']}\",";
$text .= "\"{$GLOBALS['strSite']}\",";
$text .= "\"{$GLOBALS['strDescription']}\",\"{$GLOBALS['strStatus']}\",\"{$GLOBALS['strCredit']}\",\"{$GLOBALS['strDebit']}\"\n";
$text .= $table;
$text .= ",,,,{$GLOBALS['strTOTALS']},";
$text .= "\"{$csv_currency}".number_format($totalcredit, 2)."\",\"";
$text .= "{$csv_currency}".number_format($totaldebit, 2)."\"\n";
}
}
}
else
{
if ($display == 'html')
{
$text = "<p align='center'>{$GLOBALS['strNoTransactionsMatchYourSearch']}</p>";
}
elseif ($display == 'csv')
{
$text = $GLOBALS['strNoTransactionsMatchYourSearch']."\n";
}
}
return $text;
}
| transition_reserved_monites | ( | $ | transactionid, |
| $ | amount, | ||
| $ | description = '' |
||
| ) |
Transitions reserved monies to awaitingapproval
| int | $transactionid | The transaction ID to transition |
| int | $amount | The final amount to charge |
| string | $description | (optional) The description to update the transaction with |
Definition at line 541 of file billing.inc.php.
References $sql, and E_USER_ERROR.
{
$rtnvalue = TRUE;
$sql = "UPDATE `{$GLOBALS['dbTransactions']}` SET amount = {$amount}, transactionstatus = ".BILLING_AWAITINGAPPROVAL." ";
if (!empty($description))
{
$sql .= ", description = '{$description}' ";
}
$sql .= "WHERE transactionid = {$transactionid} AND transactionstatus = ".BILLING_RESERVED;
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(), E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1)
{
trigger_error("Transition reserved monies failed {$sql}",E_USER_ERROR);
$rtnvalue = FALSE;
}
return $rtnvalue;
}
| unreserve_monies | ( | $ | transactionid, |
| $ | linktype | ||
| ) |
Unreserve a reserved transaction, this removes the transaction thus removing the reservation
| int | $transactionid | - The transaction to unreserv |
Definition at line 573 of file billing.inc.php.
References $sql, and E_USER_ERROR.
{
$rtnvalue = FALSE;
$sql = "DELETE FROM `{$GLOBALS['dbTransactions']}` WHERE transactionid = {$transactionid} AND transactionstatus = ".BILLING_RESERVED;
mysql_query($sql);
if (mysql_error()) trigger_error("Error unreserving monies ".mysql_error(), E_USER_ERROR);
if (mysql_affected_rows() == 1) $rtnvalue = TRUE;
if ($rtnvalue != FALSE)
{
$sql = "DELETE FROM `{$GLOBALS['dbLinks']}` WHERE linktype = {$linktype} AND origcolref = {$transactionid}";
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1)
{
trigger_error("Link deletion failed",E_USER_ERROR);
$rtnvalue = FALSE;
}
}
return $rtnvalue;
}
| update_contract_balance | ( | $ | contractid, |
| $ | description, | ||
| $ | amount, | ||
| $ | serviceid = '', |
||
| $ | transactionid = '', |
||
| $ | totalunits = 0, |
||
| $ | totalbillableunits = 0, |
||
| $ | totalrefunds = 0 |
||
| ) |
Update contract balance by an amount and log a transaction to record the change
| int | $contractid,. | Contract ID of the contract to credit |
| string | $description,. | A useful description of the transaction |
| float | $amount,. | The amount to credit or debit to the contract balance positive for credit and negative for debit |
| int | $serviceid,. | optional serviceid to use. This is calculated if ommitted. |
| int | $transaction | - the transaction you are approving |
| int | $totalunits | - The number of units that are being approved - before the multiplier |
| int | $totalbillableunits | - The number of units charged to the customer (after the multiplier) |
| int | $totalrefunds | - Total number of units refunded to the customer |
Definition at line 852 of file billing.inc.php.
References $amount, $contractid, $date, $dbService, $dbTransactions, $now, $result, $serviceid, $sql, E_USER_ERROR, and get_serviceid().
Referenced by approve_incident_transaction().
{
global $now, $dbService, $dbTransactions;
$rtnvalue = TRUE;
if (empty($totalunits)) $totalunits = -1;
if (empty($totalbillableunits)) $totalbillableunits = -1;
if (empty($totalrefunds)) $totalrefunds = 0;
if ($serviceid == '')
{
// Find the correct service record to update
$serviceid = get_serviceid($contractid);
if ($serviceid < 1) trigger_error("Invalid service ID",E_USER_ERROR);
}
if (trim($amount) == '') $amount = 0;
$date = date('Y-m-d H:i:s', $now);
// Update the balance
$sql = "UPDATE `{$dbService}` SET balance = (balance + {$amount}) WHERE serviceid = '{$serviceid}' LIMIT 1";
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1 AND $amount != 0)
{
trigger_error("Contract balance update failed",E_USER_ERROR);
$rtnvalue = FALSE;
}
if ($rtnvalue != FALSE)
{
// Log the transaction
if (empty($transactionid))
{
$sql = "INSERT INTO `{$dbTransactions}` (serviceid, totalunits, totalbillableunits, totalrefunds, amount, description, userid, dateupdated, transactionstatus) ";
$sql .= "VALUES ('{$serviceid}', '{$totalunits}', '{$totalbillableunits}', '{$totalrefunds}', '{$amount}', '{$description}', '{$_SESSION['userid']}', '{$date}', '".BILLING_APPROVED."')";
$result = mysql_query($sql);
$rtnvalue = mysql_insert_id();
}
else
{
$sql = "UPDATE `{$dbTransactions}` SET serviceid = {$serviceid}, totalunits = {$totalunits}, totalbillableunits = {$totalbillableunits}, totalrefunds = {$totalrefunds} ";
$sql .= ", amount = {$amount}, userid = {$_SESSION['userid']} , dateupdated = '{$date}', transactionstatus = '".BILLING_APPROVED."' ";
if (!empty($description))
{
$sql .= ", description = '{$description}' ";
}
$sql .= "WHERE transactionid = {$transactionid}";
$result = mysql_query($sql);
$rtnvalue = $transactionid;
}
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1)
{
trigger_error("Transaction insert failed",E_USER_ERROR);
$rtnvalue = FALSE;
}
}
return $rtnvalue;
}
| update_last_billed_time | ( | $ | serviceid, |
| $ | date | ||
| ) |
Set the last billing time on a service
| int | $serviceid | - service ID |
| string | $date | - Date (in format YYYY-MM-DD) to set the last billing time to |
Definition at line 194 of file billing.inc.php.
References $date, $dbService, $serviceid, $sql, and E_USER_ERROR.
{
global $dbService;
$rtnvalue = FALSE;
if (!empty($serviceid) AND !empty($date))
{
$rtnvalue = TRUE;
$sql .= "UPDATE `{$dbService}` SET lastbilled = '{$date}' WHERE serviceid = {$serviceid}";
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(), E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() < 1)
{
trigger_error("Approval failed", E_USER_ERROR);
$rtnvalue = FALSE;
}
}
return $rtnvalue;
}
| update_reservation | ( | $ | transactionid, |
| $ | amount, | ||
| $ | description = '' |
||
| ) |
Updates the amount and optionally the description on a transaction awaiting reservation
| int | $transactionid | The transaction ID to update |
| int | $amount | The amount to set the transaction to |
| string | $description | (optional) the description to set on the transaction |
Definition at line 610 of file billing.inc.php.
References $amount, and update_transaction().
{
return update_transaction($transactionid, $amount, $description, BILLING_RESERVED);
}
| update_transaction | ( | $ | transactionid, |
| $ | amount, | ||
| $ | description = '', |
||
| $ | status | ||
| ) |
Updates a transacction which which be either waiting approval or reserved
| int | $transactionid | The transaction ID to update |
| int | $amount | The amount to set the transaction to |
| string | $description | (optional) the description to set on the transaction |
| int | $status | either RESERVERED or BILLING_AWAITINGAPPROVAL |
Definition at line 625 of file billing.inc.php.
References $sql, $status, E_USER_ERROR, and exit.
Referenced by update_reservation().
{
if ($status == BILLING_APPROVED)
{
trigger_error("You cant change a approved transaction", E_USER_ERROR);
exit;
}
$rtnvalue = FALSE;
// Note we dont need to check its awaiting reservation as we check this when doing the update
if (is_numeric($transactionid))
{
$sql = "UPDATE `{$GLOBALS['dbTransactions']}` SET amount = '{$amount}' ";
if (!empty($description))
{
$sql .= ", description = '{$description}' ";
}
$sql .= "WHERE transactionid = {$transactionid} AND transactionstatus = {$status}";
mysql_query($sql);
if (mysql_error())
{
trigger_error(mysql_error(),E_USER_ERROR);
$rtnvalue = FALSE;
}
if (mysql_affected_rows() > 0)
{
$rtnvalue = TRUE;
}
}
return $rtnvalue;
}
| For more help developing with SiT! see http://sitracker.org/wiki/DevelopmentHowTo | © 2008-2011 Support Incident Tracker |
 |