PHP ErrorLog::writeLogの例

コード例 #1

ファイル: gettimedailyentryreview.php プロジェクト: yellowrangler/selfemployment

//---------------------------------------------------------------
$sql = "SELECT \n\tPDT.id as projectdailytimeid, \n\tprojectid,\n\tDATE_FORMAT(enterdate,'%m/%d/%y') as fenterdate,\n\tPT.name as projectname, CT.name as clientname,\n\tFORMAT(SUM(timeinterval),2) as finterval,\n\tintervaldescription\n\tFROM projectdailytimetbl PDT \n\tLEFT JOIN projecttbl PT ON PT.id = PDT.projectid\n\tLEFT JOIN clienttbl CT ON CT.id = PT.clientid\n\tWHERE enterdate >= '{$fromdateTS}' AND enterdate <= '{$todateTS}'";
if ($clientid != "0") {
    $sql .= "AND clientid = '{$clientid}' ";
}
if ($projectid != "0") {
    $sql .= "AND projectid = '{$projectid}' ";
}
$sql .= "GROUP BY PT.name, enterdate ORDER BY PT.name";
// print $sql;
// die();
$sql_result = @mysql_query($sql, $dbConn);
if (!$sql_result) {
    $log = new ErrorLog("logs/");
    $sqlerr = mysql_error();
    $log->writeLog("SQL error: {$sqlerr} - Error doing get time entry daily project review list select");
    $log->writeLog("SQL: {$sql}");
    $rv = "";
    exit($rv);
}
$count = mysql_num_rows($sql_result);
if ($count > 0) {
    $rows = array();
    while ($row = mysql_fetch_assoc($sql_result)) {
        $results[] = $row;
    }
}
//
// close db connection
//
mysql_close($dbConn);

コード例 #2

ファイル: addupdateclient.php プロジェクト: yellowrangler/selfemployment

        $log->writeLog("SQL: {$sql}");
        $rv = "";
        exit($rv);
    }
    $clientid = mysql_insert_id($dbConn);
} else {
    //--------------------------------------
    // we are an update
    //--------------------------------------
    $sql = "UPDATE clienttbl\n\t\t\tSET name = '{$clientname}', \n\t\t\taddress1 = '{$clientaddress1}', \n\t\t\taddress2 = '{$clientaddress2}',\n\t\t\tcity = '{$clientcity}',\n\t\t\tstate = '{$clientstate}',\n\t\t\tzip = '{$clientzip}',\n\t\t\tstatus = '{$clientstatus}', \n\t\t\trate = '{$clientrate}'\n\t\t\tWHERE id = '{$clientid}'\n\t\t\t";
    // print $sql;
    $sql_result = @mysql_query($sql, $dbConn);
    if (!$sql_result) {
        $log = new ErrorLog("logs/");
        $sqlerr = mysql_error();
        $log->writeLog("SQL error: {$sqlerr} - Error doing update client for add/update client details");
        $log->writeLog("SQL: {$sql}");
        $rv = "";
        exit($rv);
    }
}
//
// close db connection
//
mysql_close($dbConn);
//
// logging
//
// $returnArrayLog->writeLog("Patient List request ended.");
//
// pass back info

コード例 #3

ファイル: updatetimedailyentry.php プロジェクト: yellowrangler/selfemployment

}
//---------------------------------------------------------------
// add daily time entered using information passed.
//---------------------------------------------------------------
$sql = "UPDATE projectdailytimetbl \n\tSET projectid = {$projectid},\t\n\tenterdate ='{$entrydateTS}',\n\tstarttime = '{$starttimeTS}',";
if ($stoptimeTS != "") {
    $sql = $sql . "stoptime = '{$stoptimeTS}',";
}
$sql = $sql . "timeinterval = {$interval},\n\tintervaldescription = '{$comment}'\n\tWHERE id = {$projectdailytimeid}";
// print $sql;
$rv = "";
$sql_result = @mysql_query($sql, $dbConn);
if (!$sql_result) {
    $log = new ErrorLog("logs/");
    $sqlerr = mysql_error();
    $log->writeLog("SQL error: {$sqlerr} - Error doing insert to add daily time");
    $log->writeLog("SQL: {$sql}");
    exit($rv);
}
//
// close db connection
//
mysql_close($dbConn);
//
// logging
//
// $returnArrayLog->writeLog("Patient List request ended.");
//
// pass back info
//
exit($rv);

コード例 #4

ファイル: deletetimedailyentry.php プロジェクト: yellowrangler/selfemployment

    $log->writeLog("DB error: {$dberr} - Error selecting db Unable to delete daily time entry.");
    $rv = "";
    exit($rv);
}
//---------------------------------------------------------------
// delete daily time entered using information passed.
//---------------------------------------------------------------
$sql = "DELETE FROM projectdailytimetbl\nWHERE id = {$projectdailytimeid}";
// print $sql;
// die();
$rv = "";
$sql_result = @mysql_query($sql, $dbConn);
if (!$sql_result) {
    $log = new ErrorLog("logs/");
    $sqlerr = mysql_error();
    $log->writeLog("SQL error: {$sqlerr} - Error doing delete to daily time");
    $log->writeLog("SQL: {$sql}");
    exit($rv);
}
//
// close db connection
//
mysql_close($dbConn);
//
// logging
//
// $returnArrayLog->writeLog("Patient List request ended.");
//
// pass back info
//
exit($rv);

コード例 #5

ファイル: getclientprojects.php プロジェクト: yellowrangler/selfemployment

if (!mysql_select_db($DBschema, $dbConn)) {
    $log = new ErrorLog("logs/");
    $dberr = mysql_error();
    $log->writeLog("DB error: {$dberr} - Error selecting db Unable to get client project list.");
    $rv = "";
    exit($rv);
}
//---------------------------------------------------------------
// get patient information using information passed. limit 5
//---------------------------------------------------------------
$sql = "SELECT P.id as projectid, \nP.clientid as clientid, \nP.name as projectname,\nC.name as contactname,\ndeskphone as contactdeskphone,\nmobilephone as contactmobilephone,\nemail as contactemail\nFROM projecttbl P\nLEFT JOIN contactstbl C ON C.id = P.contactid\nWHERE P.clientid = {$clientid}";
$sql_result = @mysql_query($sql, $dbConn);
if (!$sql_result) {
    $log = new ErrorLog("logs/");
    $sqlerr = mysql_error();
    $log->writeLog("SQL error: {$sqlerr} - Error doing get client project list select");
    $log->writeLog("SQL: {$sql}");
    $rv = "";
    exit($rv);
}
$count = mysql_num_rows($sql_result);
if ($count > 0) {
    $rows = array();
    while ($row = mysql_fetch_assoc($sql_result)) {
        $results[] = $row;
    }
}
//
// close db connection
//
mysql_close($dbConn);

コード例 #6

ファイル: getclientdetails.php プロジェクト: yellowrangler/selfemployment

if (!mysql_select_db($DBschema, $dbConn)) {
    $log = new ErrorLog("logs/");
    $dberr = mysql_error();
    $log->writeLog("DB error: {$dberr} - Error selecting db Unable to get client details.");
    $rv = "";
    exit($rv);
}
//---------------------------------------------------------------
// get patient information using information passed. limit 5
//---------------------------------------------------------------
$sql = "SELECT * FROM clienttbl WHERE id = {$clientid}";
$sql_result = @mysql_query($sql, $dbConn);
if (!$sql_result) {
    $log = new ErrorLog("logs/");
    $sqlerr = mysql_error();
    $log->writeLog("SQL error: {$sqlerr} - Error doing get client details select");
    $log->writeLog("SQL: {$sql}");
    $rv = "";
    exit($rv);
}
$count = mysql_num_rows($sql_result);
if ($count > 0) {
    $results = mysql_fetch_assoc($sql_result);
}
//
// close db connection
//
mysql_close($dbConn);
//
// logging
//

コード例 #7

ファイル: getclients.php プロジェクト: yellowrangler/selfemployment

    $dberr = mysql_error();
    $rv = "DB error: {$dberr} - Error selecting db Unable to get client list.";
    $log->writeLog($rv);
    print $rv;
    exit($rv);
}
//---------------------------------------------------------------
// get patient information using information passed. limit 5
//---------------------------------------------------------------
$sql = "SELECT * FROM clienttbl";
$sql_result = @mysql_query($sql, $dbConn);
if (!$sql_result) {
    $log = new ErrorLog("logs/");
    $sqlerr = mysql_error();
    $rv = "SQL error: {$sqlerr} - Error doing get client list select. SQL = {$sql}";
    $log->writeLog($rv);
    print $rv;
    exit($rv);
}
$count = mysql_num_rows($sql_result);
if ($count > 0) {
    $rows = array();
    while ($row = mysql_fetch_assoc($sql_result)) {
        $results[] = $row;
    }
}
//
// close db connection
//
mysql_close($dbConn);
//