//--------------------------------------------------------------- $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);
$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
} //--------------------------------------------------------------- // 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);
$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);
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);
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 //
$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); //