/home/ivan/src/sit/branches/3.x/lib/contract.inc.php

Go to the documentation of this file.

<?php
// contract.inc.php - functions relating to contracts
//
// SiT (Support Incident Tracker) - Support call tracking system
// Copyright (C) 2010-2011 The Support Incident Tracker Project
// Copyright (C) 2000-2009 Salford Software Ltd. and Contributors
//
// This software may be used and distributed according to the terms
// of the GNU General Public License, incorporated herein by reference.

// Prevent script from being run directly (ie. it must always be included
if (realpath(__FILE__) == realpath($_SERVER['SCRIPT_FILENAME']))
{
    exit;
}

require_once (APPLICATION_LIBPATH . 'base.inc.php');

function guess_contract_id($contactid)
{
    global $dbSupportContacts;

    $contactid = intval($contactid);
    $sql = "SELECT * FROM `{$dbSupportContacts}` ";
    $sql .= "WHERE contactid = '{$contactid}'";
    $result = mysql_query($sql);
    if (mysql_error()) trigger_error(mysql_error(),E_USER_ERROR);

    $num_contracts = mysql_num_rows($result);

    if ($num_contracts == 0)
    {
        $contractid = FALSE;
    }
    elseif ($num_contracts == 1)
    {
        $row = mysql_fetch_object($result);
        $contractid = $row->id;
    }
    else
    {
        //to complete as a programming exercise
    }

    return $contractid;
}

function contract_slatag($maintid)
{
    $maintid = intval($maintid);
    $slaid = db_read_column('servicelevelid', $GLOBALS['dbMaintenance'], $maintid);
    
    $sql = "SELECT tag FROM `{$GLOBALS['dbServiceLevels']}` WHERE id = {$slaid} LIMIT 1";
    $result = mysql_query($sql);
    $obj = mysql_fetch_object($result);
    
    return $obj->tag;
}

?>