" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_buildapp_byitem($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLBUILDAPP WHERE ITEMID=" . $id . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_buildapp_bybuild($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLBUILDAPP WHERE BUILDID=" . $id . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_ent_bed($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLPACKAGES WHERE PKGID=" . $id . " and ENTID=" . $_SESSION["userentid"] .";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_ent_bed_options($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLPKGPARTS WHERE ENTPARID=" . $id . " and ENTID=" . $_SESSION["userentid"] .";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_ent_bed_options_by_kit($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE ";
$sql .= " FROM TBLPKGPARTS";
$sql .= " WHERE ENTID=" . $_SESSION["userentid"];
$sql .= " and PKGID=" . $id .";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_ent_bed_options_by_item($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE ";
$sql .= " FROM TBLPKGPARTS";
$sql .= " WHERE ENTID=" . $_SESSION["userentid"] .";";
$sql .= " and PARTID=" . $id .";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_include($id, $entid) {
//Deletes a kit part.
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLPKGPARTS";
$sql .= " WHERE ENTPARID=" . $id . "";
$sql .= " and ENTID=" . $entid . ";";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_sessions_member($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLSESSION WHERE MEMBERID=" . $id . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_quoteheaderspecs($qid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLQUOTEHEADERSPECS WHERE QUOTEHEADERID=" . $qid . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_quoteline($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLQUOTELINES WHERE QUOTELINEID=" . $id . ";";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_quotelines_byno($hid,$qlno) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLQUOTELINES WHERE QUOTEHEADERID=" . $hid . " and QLLINENO = " . $qlno . ";";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_quotelines($qid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLQUOTELINES WHERE QUOTEHEADERID=" . $qid . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function delete_terms($entid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "DELETE FROM TBLQUOTETERMS WHERE ENTID=" . $entid . " and ENTID=" . $_SESSION["userentid"] .";";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error in db/delete function: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function duplicate_buildapp($item,$itemfromid) {
//Creates a new row in the TBLBUILDAPP table from the given item
//Used to duplicate builds to a new pacakge. (ie. 2023 Ford to 2024 Ford)
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLBUILDAPP (BUILDID,ITEMID)";
$sql .= "(SELECT BUILDID," . $item;
$sql .= " FROM TBLBUILDAPP";
$sql .= " WHERE ITEMID=" . $itemfromid . ")";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function duplicate_quotelines($newqid,$oldqid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLQUOTELINES (QUOTEHEADERID, QLLINENO,";
$sql .= " QLTYPE, QLCOSTTYPE, SOURCEID, QLDESC, QLPARTNO, QLLABORHRS,";
$sql .= " QLLABORCOST, QLLABORPRICE, QLPARTQTY, QLMATCOST, QLMATPRICE,";
$sql .= " QLPROFIT, QLTOTAL, QLLINEPROFIT, QLLINETOTAL, CREATEDBY,";
$sql .= "MODIFIEDBY, CREATEDDATE, MODIFIEDDATE)";
$sql .= "(SELECT $newqid, QLLINENO,";
$sql .= " QLTYPE, QLCOSTTYPE, SOURCEID, QLDESC, QLPARTNO, QLLABORHRS,";
$sql .= " QLLABORCOST, QLLABORPRICE, QLPARTQTY, QLMATCOST, QLMATPRICE,";
$sql .= " QLPROFIT, QLTOTAL, QLLINEPROFIT, QLLINETOTAL, CREATEDBY,";
$sql .= "MODIFIEDBY, CREATEDDATE, MODIFIEDDATE";
$sql .= " FROM TBLQUOTELINES";
$sql .= " WHERE QUOTEHEADERID=" . $oldqid . ")";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function Insert_Build_App($buildid,$itemid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLBUILDAPP (BUILDID, ITEMID)
VALUES ('$buildid','$itemid');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_ent($entname,$entadd,$entadd2,$entcity,$entstate, $entzip,$entdomain,$entdefpw,$createddate,$createdby,$modifieddate,$modifiedby) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes and force upper where appropriate
$entname = strtoupper(str_replace(array('\'', '"'), "", $entname));
$sql = "INSERT INTO TBLENTERPRISE (ENTNAME, ENTADD, ENTADD2, ENTCITY, ENTSTATE, ENTZIP, ENTDOMAIN, ENTDEFPW, CREATEDDATE,CREATEDBY,MODIFIEDDATE,MODIFIEDBY)
VALUES ('$entname','$entadd','$entadd2','$entcity','$entstate','$entzip','$entdomain','$entdefpw','$createddate','$createdby','$modifieddate','$modifiedby');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_control($entid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLCONTROLS (ENTID)
VALUES ($entid);";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_ent_bed($pkgid, $entid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLPACKAGES (PKGID, ENTID)
VALUES ($pkgid, $entid);";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_ent_bed_option($entid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLPKGPARTS (ENTID) VALUES ($entid);";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_ent_com($partid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLPARTS (PARTID)
VALUES ($partid);";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_ent_kit_item($entid,$pkgid,$parname,$PARTID,$parvalue) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLPKGPARTS (ENTID,PKGID,PARNAME,PARTID,PARVALUE) VALUES ($entid,$pkgid,'$parname',$PARTID,'$parvalue');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_quoteheader($quoteno,$entid, $storeid,$ownerid,$expiredate, $createddate,$createdby,$modifieddate,$modifiedby) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes and force upper where appropriate
$sql = "INSERT INTO TBLQUOTEHEADER (QUOTENO,ENTID,STOREID,OWNERID,EXPIREDATE,CREATEDDATE,CREATEDBY,MODIFIEDDATE,MODIFIEDBY)
VALUES ('$quoteno',$entid,$storeid,'$ownerid','$expiredate','$createddate','$createdby','$modifieddate','$modifiedby');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_quoteheaderspec($quoteheaderid,$paremeter,$value) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes and force upper where appropriate
$sql = "INSERT INTO TBLQUOTEHEADERSPECS (QUOTEHEADERID,PARAMETER,PARAMETERVALUE)
VALUES ($quoteheaderid,'$paremeter','$value');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function insert_quoteline($qid,$qltype,$qcosttype,$sourceid, $qdesc,$qlineno,$qpartqty,$qpartno,$qlaborhours,$qlaborcost,$qlaborpirce,$qmatcost,$qmatprice,$qprofit,$qtotal,$qlineprofit,$qlinetotal,$createdby,$modifiedby,$createddate,$modifieddate) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLQUOTELINES (QUOTEHEADERID,QLTYPE, QLCOSTTYPE, SOURCEID, QLDESC,QLLINENO, QLPARTQTY, QLPARTNO, QLLABORHRS,QLLABORCOST, QLLABORPRICE, QLMATCOST, QLMATPRICE, QLPROFIT, QLTOTAL,QLLINEPROFIT, QLLINETOTAL,CREATEDBY,MODIFIEDBY,CREATEDDATE,MODIFIEDDATE)
VALUES ($qid,$qltype,$qcosttype,'$sourceid','$qdesc',$qlineno,$qpartqty,'$qpartno',$qlaborhours,$qlaborcost,$qlaborpirce,$qmatcost,$qmatprice,$qprofit,$qtotal,$qlineprofit,$qlinetotal,$createdby,$modifiedby,'$createddate','$modifieddate');";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_close($conn);
}
//***********************************************************************************
function insert_history($headerid, $itemid, $description, $notes, $memberid, $currdatetime) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes
$description = str_replace(array('\'', '"'), "", $description);
$notes = str_replace(array('\'', '"'), "", $notes);
$sql = "
INSERT INTO TBLHISTORY (HISTHEADERID, HISTITEMID, HISTDESC, HISTNOTES, HISTBY, HISTCREATEDDATE)
VALUES ($headerid,$itemid,'$description','$notes',$memberid,'$currdatetime');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function insert_member($memberuserid, $entid){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLMEMBERS (MEMBERUSERID,MEMBERENTID) ";
$sql .= "VALUES ('$memberuserid', '$entid');";
if (mysqli_query($conn, $sql)) {
} else {
echo "insert_member=Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_close($conn);
}
//***********************************************************************************
function insert_notify($entity, $entityid, $notifydesc,$memberid,$currdate) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "
INSERT INTO TBLNOTIFY (NOTIFYENTITY, NOTIFYENTITYID, NOTIFYDESC, NOTIFYMEMBERID, CREATEDDATE)
VALUES ('$entity','$entityid', '$notifydesc','$memberid','$currdate');";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function insert_session($memberid, $sessionid, $expire,$created) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLSESSION (SESSIONID, MEMBERID, CREATEDDATE, EXPIREDATE) VALUES ('$sessionid', $memberid,'$created','$expire');";
if (mysqli_query($conn, $sql)) {
} else {
echo "insert_session=Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function insert_store($entid, $createdby) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes and force upper where appropriate
$storename = strtoupper(str_replace(array('\'', '"'), "", $storename));
$sql = "INSERT INTO TBLSTORE (ENTID, CREATEDBY)
VALUES ($entid, $createdby);";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_free_result($newid);
mysqli_close($conn);
}
//***********************************************************************************
function insert_terms($entid, $terms) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "INSERT INTO TBLQUOTETERMS (ENTID, TERMS)";
$sql .= " VALUES ($entid, '$terms');";
if (mysqli_query($conn, $sql)) {
} else {
echo "insert_terms=Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_close($conn);
}
//***********************************************************************************
function insert_ticketitems($headerid, $itemid, $tidescription, $WCID, $duedate, $sortorder, $worktime, $itemnotes, $membername,$createddate) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes
$tidescription = str_replace(array('\'', '"'), "", $tidescription);
$itemnotes = str_replace(array('\'', '"'), "", $itemnotes);
$sql = "INSERT INTO TBLTICKETITEM (HEADERID, ITEMID, TIDESCRIPTION, WCID, DUEDATE, SORTORDER, WORKTIME, ITEMNOTES, TICREATEDBY, TICREATEDDATE, TIMODIFIEDBY, TIMODIFIEDDATE)";
$sql .= " VALUES ($headerid, $itemid,'$tidescription',$WCID,'$duedate',$sortorder,$worktime,'$itemnotes','$membername','$createddate','$membername','$createddate');";
if (mysqli_query($conn, $sql)) {
} else {
echo "insert_ticketitems=Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_close($conn);
}
//***********************************************************************************
function insert_wc($wcname, $wclocation, $dayhourlimits, $sathourlimits, $dlid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes
$wcname = str_replace(array('\'', '"'), "", $wcname);
$wclocation = str_replace(array('\'', '"'), "", $wclocation);
$dayhourlimits = str_replace(array('\'', '"'), "", $dayhourlimits);
$sql = "
INSERT INTO TBLWORKCENTERS (WCNAME,WCLOCATION,DAYHOURLIMITS, SATHOURLIMITS,DLID)
VALUES ('$wcname','$wclocation','$dayhourlimits','$sathourlimits',$dlid);";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
$newid = mysqli_insert_id($conn);
return $newid;
mysqli_close($conn);
}
//***********************************************************************************
function insert_wc_std($itemid, $wcid, $worktime, $curetime) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "
INSERT INTO TBLWORKCENTERSTD (WCID,ITEMID,WORKTIME,CURETIME,CREATEDDATE,MODIFIEDDATE)
VALUES ('$wcid','$itemid','$worktime','$curetime',now(),now());";
if (mysqli_query($conn, $sql)) {
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//******************************************************************************
function update_build($qid,$buildid,$vehdesc,$modifieddate, $userid){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLQUOTEHEADER SET ";
$sql .= "BUILDID=" . $buildid . ", ";
$sql .= "VEHDESC='" . $vehdesc . "', ";
$sql .= "MODIFIEDDATE='" . $modifieddate . "', ";
$sql .= "MODIFIEDBY='" . $userid . "'";
$sql .= " WHERE QUOTEHEADERID = " . $qid . "";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//******************************************************************************
function update_control($cid,$entid,$groupid,$orderid, $label,$item,$type,$qty, $modifiedby){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLCONTROLS SET ";
if (isset($entid)) {
$sql .= "ENTID=" . $entid . ", ";
}
if (isset($groupid)) {
$sql .= "GROUPID='" . $groupid . "', ";
}
if (isset($orderid)) {
$sql .= "ORDERID='" . $orderid . "', ";
}
if (isset($label)) {
$sql .= "LABEL='" . $label . "', ";
}
if (isset($item)) {
$sql .= "ITEM='" . $item . "', ";
}
if (isset($type)) {
$sql .= "TYPE='" . $type . "', ";
}
$sql .= " MODIFIEDBY=" . $modifiedby. ", ";
$sql .= " MODIFIEDDATE=now()";
$sql .= " WHERE CONTROLID=" . $cid;
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//******************************************************************************
function update_store($storeid,$entid,$name,$location, $address,$city,$state,$zip, $storephone, $markuppct, $imagefile, $storeip,$active, $modifiedby){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLSTORE SET ";
if (isset($entid)) {
$sql .= "ENTID=" . $entid . ", ";
}
if (isset($name)) {
$sql .= "STORENAME='" . $name . "', ";
}
if (isset($location)) {
$sql .= "LOCATION='" . $location . "', ";
}
if (isset($address)) {
$sql .= "ADDRESS='" . $address . "', ";
}
if (isset($city)) {
$sql .= "CITY='" . $city . "', ";
}
if (isset($state)) {
$sql .= "STATE='" . $state . "', ";
}
if (isset($zip)) {
$sql .= "ZIP='" . $zip . "', ";
}
if (isset($storephone)) {
$sql .= "STOREPHONE='" . $storephone . "', ";
}
if (isset($markuppct)) {
$sql .= "MARKUPPCT='" . $markuppct . "', ";
}
if (isset($imagefile)) {
$sql .= "LOGOFILE='" . $imagefile . "', ";
}
if (isset($storeip)) {
$sql .= "STOREIP='" . $storeip . "', ";
}
if (isset($storeip)) {
$sql .= "ACTIVE=" . $active . ", ";
}
$sql .= " MODIFIEDBY=" . $modifiedby. ", ";
$sql .= " MODIFIEDDATE=now()";
$sql .= " WHERE STOREID=" . $storeid;
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//******************************************************************************
function update_enterprise($entid,$entname,$entadd,$entadd2,$entcity,$entstate,$entzip,$entdomain,$entdefpw,$modifiedddate, $modifiedby){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes and force upper in appropiate fields
$entname = str_replace(array('\'', '"'), "", $entname);
$entadd = str_replace(array('\'', '"'), "", $entadd);
$entadd2 = str_replace(array('\'', '"'), "", $entadd2);
$entcity = str_replace(array('\'', '"'), "", $entcity);
$entstate = str_replace(array('\'', '"'), "", $entstate);
$entzip = str_replace(array('\'', '"'), "", $entzip);
$sql = "UPDATE TBLENT SET ";
$sql .= "ENTNAME='" . $entname . "', ";
$sql .= "ENTADD='" . $entadd . "', ";
$sql .= "ENTADD2='" . $entadd2 . "', ";
$sql .= "ENTCITY='" . $entcity . "', ";
$sql .= "ENTSTATE='" . $entstate . "', ";
$sql .= "ENTZIP=" . $entzip . ", ";
$sql .= "ENTDOMAIN='" . $entdomain . "', ";
$sql .= "ENTDEFPW='" . $entdefpw . "', ";
$sql .= "MODIFIEDDATE='" . $modifiedddate . "'";
$sql .= " WHERE ENTID = " . $entid . ";";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_ent_bed($pkgid, $entid, $producttypeid, $bedstatus, $bedmodelid, $mfgid, $installtypeid, $makemodelid, $cabaxle, $rearwheelid, $framewidth, $bedlength, $bedwidth, $partnumber, $proddesc, $installlabor, $bedbookprice, $wholesalerate,$surcharge,$dealercost,$totalcost,$markup,$markuppct,$markuphold,$msrpretail,$note, $imgfile) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLPACKAGES SET ";
If ($entid != NULL) {
$sql .= "ENTID=" . $entid . ", ";
}
If ($producttypeid != NULL) {
$sql .= "PRODUCTTYPEID=" . $producttypeid . ", ";
}
If ($bedstatus != NULL) {
$sql .= "BEDSTATUS=" . $bedstatus . ", ";
}
If ($mfgid != NULL) {
$sql .= "MFGID=" . $mfgid . ", ";
}
If ($bedmodelid != NULL) {
$sql .= "BEDMODELID=" . $bedmodelid . ", ";
}
If ($installtypeid != NULL) {
$sql .= "INSTALLTYPEID=" . $installtypeid . ", ";
}
If ($makemodelid != NULL) {
$sql .= "MAKEMODELID=" . $makemodelid . ", ";
}
If ($cabaxle != NULL) {
$sql .= "CABAXLE =" . $cabaxle . ", ";
}
If ($framewidth != NULL) {
$sql .= "FRAMEWIDTH=" . $framewidth . ", ";
}
If ($bedlength != NULL) {
$sql .= "BEDLENGTH=" . $bedlength . ", ";
}
If ($bedwidth != NULL) {
$sql .= "BEDWIDTH=" . $bedwidth . ", ";
}
If ($partnumber != NULL) {
$sql .= "PARTNUMBER='" . $partnumber . "', ";
}
If ($proddesc != NULL) {
$proddesc = str_replace('"', "''", $proddesc);
$sql .= "PRODDESC=\"" . $proddesc . "\", ";
}
If ($installlabor != NULL) {
$sql .= "INSTALLLABOR=" . $installlabor . ", ";
}
If ($bedbookprice != NULL) {
$sql .= "BEDBOOKPRICE=" . $bedbookprice . ", ";
}
If ($wholesalerate != NULL) {
$sql .= "WHOLESALEDISC=" . $wholesalerate . ", ";
}
If ($surcharge != NULL) {
$sql .= "SURCHARGEPCT=" . $surcharge . ", ";
}
If ($dealercost != NULL) {
$sql .= "DEALERCOST=" . $dealercost . ", ";
}
If ($totalcost != NULL) {
$sql .= "TOTALCOST=" . $totalcost . ", ";
}
If ($markup != NULL) {
$sql .= "MARKUP=" . $markup . ", ";
}
If ($markuppct != NULL) {
$sql .= "MARKUPPCT=" . $markuppct . ", ";
}
If ($markuphold != NULL) {
$sql .= "MARKUPHOLD=" . $markuphold . ", ";
}
If ($msrpretail != NULL) {
$sql .= "MSRPRETAIL=" . $msrpretail . ", ";
}
If ($imgfile != NULL) {
$sql .= "IMAGEFILE='" . $imgfile . "', ";
}
$sql .= "NOTE='" . $note . "', ";
$sql .= "MODIFIEDDATE=UTC_TIMESTAMP";
$sql .= " WHERE PKGID = " . $pkgid . "";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_ent_part($partid, $entid, $cat, $subcat , $statusid, $mfgid, $partno, $partdesc, $partdescext, $cost, $costlabor, $price, $labor, $wholesaledisc, $surcharge, $qtyper, $markup, $markuppct, $markuphold, $opdesc, $imagefile, $imagelabel, $specpage) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLPARTS SET ";
If ($entid != NULL) {
$sql .= "ENTID=" . $entid . ", ";
}
If ($cat != NULL) {
$sql .= "CAT='" . $cat . "', ";
}
If ($subcat != NULL) {
$sql .= "SUBCAT='" . $subcat . "', ";
}
If ($statusid != NULL) {
$sql .= "STATUSID='" . $statusid . "', ";
}
If ($mfgid != NULL) {
$sql .= "MFGID='" . $mfgid . "', ";
}
If ($partno != NULL) {
$sql .= "PARTNO='" . $partno . "', ";
}
If ($partdesc != NULL) {
$sql .= "PARTDESC='" . $partdesc . "', ";
}
If ($partdescext != NULL) {
$sql .= "PARTDESCEXT='" . $partdescext . "', ";
}
If ($cost != NULL) {
$sql .= "COST =" . $cost . ", ";
}
If ($costlabor != NULL) {
$sql .= "COSTLABOR=" . $costlabor . ", ";
}
If ($price != NULL) {
$sql .= "PRICE=" . $price . ", ";
}
If ($labor != NULL) {
$sql .= "LABOR=" . $labor . ", ";
}
If ($wholesaledisc != NULL) {
$sql .= "WHOLESALEDISC=" . $wholesaledisc . ", ";
}
If ($surcharge != NULL) {
$sql .= "SURCHARGEPCT=" . $surcharge . ", ";
}
If ($qtyper != NULL) {
$sql .= "QTYPER=" . $qtyper . ", ";
}
If ($markup != NULL) {
$sql .= "MARKUP=" . $markup . ", ";
}
If ($markuppct != NULL) {
$sql .= "MARKUPPCT=" . $markuppct . ", ";
}
If ($markuphold != NULL) {
$sql .= "MARKUPHOLD=" . $markuphold . ", ";
}
If ($opdesc != NULL) {
$sql .= "OPDESC='" . $opdesc . "', ";
}
If ($imagefile != NULL) {
$sql .= "IMAGEFILE='" . $imagefile . "', ";
}
If ($imagelabel != NULL) {
$sql .= "IMAGELABEL='" . $imagelabel . "', ";
}
If ($specpage != NULL) {
$sql .= "SPECPAGE='" . $specpage . "', ";
}
$sql .= "MODIFIEDDATE=UTC_TIMESTAMP";
$sql .= " WHERE PARTID = " . $partid . "";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_ent_model($bedmodelid, $entid, $active, $bedmfg, $bedmodel, $beddesc, $material, $notes, $imagefile, $specpage) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLBEDMODELS SET ";
If ($entid != NULL) {
$sql .= "ENTID=" . $entid . ", ";
}
If ($active != NULL) {
$sql .= "ACTIVE='" . $active . "', ";
}
If ($bedmfg != NULL) {
$sql .= "BEDMFG='" . $bedmfg . "', ";
}
If ($bedmodel != NULL) {
$sql .= "BEDMODEL='" . $bedmodel . "', ";
}
If ($beddesc != NULL) {
$sql .= "BEDDESC ='" . $beddesc . "', ";
}
If ($material != NULL) {
$sql .= "MATERIAL='" . $material . "', ";
}
If ($notes != NULL) {
$sql .= "NOTES='" . $notes . "', ";
}
If ($imagefile != NULL) {
$sql .= "IMAGEFILE='" . $imagefile . "', ";
}
If ($specpage != NULL) {
$sql .= "SPECPAGE='" . $specpage . "', ";
}
$sql .= "NOTES='" . $notes . "', ";
$sql .= "MODIFIEDDATE=UTC_TIMESTAMP";
$sql .= " WHERE BEDMODELID = " . $bedmodelid . "";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//******************************************************************************
function update_ent_settings($entid,$markuppct,$laborcost,$laborprice,$entdefpw,$entdomain,$modifiedddate,$modifiedby){
//connect to db
//Updates the enterprise settings
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLENT SET ";
$sql .= "ENTMRKUPPCT='" . $markuppct . "', ";
$sql .= "ENTLBRCOST='" . $laborcost . "', ";
$sql .= "ENTLBRPRICE='" . $laborprice . "', ";
$sql .= "ENTDEFPW='" . $entdefpw . "', ";
$sql .= "ENTDOMAIN='" . $entdomain . "', ";
$sql .= "MODIFIEDBY='" . $modifiedby . "', ";
$sql .= "MODIFIEDDATE='" . $modifiedddate . "'";
$sql .= " WHERE ENTID = " . $entid . ";";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_freightline($qid,$qmatcost,$modifiedby,$modifieddate){
//Update the dedicated quote line for freight
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLQUOTELINES SET";
If ($qmatcost != NULL) {
$sql .= " QLMATCOST='" . $qmatcost . "', ";
}
If ($modifiedby != NULL) {
$sql .= " MODIFIEDBY='" . $modifiedby . "', ";
}
If ($modifieddate != NULL) {
$sql .= " MODIFIEDDATE='" . $modifieddate . "' ";
}
$sql .= " WHERE QLLINENO = 999";
$sql .= " and QUOTEHEADERID = " . $qid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//******************************************************************************
function update_header($qid, $entid, $custname, $custemail, $ownerid, $stockvin, $buildid, $vehdesc, $notes, $quoteno, $expiredate, $storeid, $statusid,$completedby,$modifieddate, $userid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLQUOTEHEADER SET ";
If ($entid != NULL) {
$sql .= "ENTID='" . $entid . "', ";
}
If ($custname != NULL) {
$sql .= "CUSTNAME='" . $custname . "', ";
}
If ($custemail != NULL) {
$sql .= "CUSTEMAIL='" . $custemail . "', ";
}
If ($ownerid != NULL) {
$sql .= "OWNERID=" . $ownerid . ", ";
}
If ($stockvin != NULL) {
$sql .= "STOCKVIN='" . $stockvin . "', ";
}
If ($buildid != NULL) {
$sql .= "BUILDID='" . $buildid . "', ";
}
If ($vehdesc != NULL) {
$sql .= "VEHDESC='" . $vehdesc . "', ";
}
If ($quoteno != NULL) {
$sql .= "QUOTENO ='" . $quoteno . "', ";
}
If ($expiredate != NULL) {
$sql .= "EXPIREDATE ='" . $expiredate . "', ";
}
If ($storeid != NULL) {
$sql .= "STOREID=" . $storeid . ", ";
}
If ($statusid != NULL) {
$sql .= "STATUSID=" . $statusid . ", ";
}
$sql .= "NOTES='" . $notes . "', ";
$sql .= "MODIFIEDDATE='" . $modifieddate . "', ";
$sql .= "MODIFIEDBY='" . $userid . "'";
$sql .= " WHERE QUOTEHEADERID = " . $qid . "";
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_item($ticketitemid, $field, $value) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
if (isset($ticketitemid)) {
$sql = "UPDATE TBLTICKETITEM SET " . $field . "='" . $value . "' WHERE TICKETITEMID = " . $ticketitemid . ";";
}
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_item_cleardue($id,$sortid) {
//Clears all item due dates for a ticket greater than a specific sort order.
//Used at the start of the scheduler to clear a ticket to be scheduled.
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
if (isset($id)) {
$sql = "UPDATE TBLTICKETITEM SET DUEDATE='9999-12-31'";
$sql .= "WHERE";
$sql .= " HEADERID = " . $id;
$sql .= " and SORTORDER >= " . $sortid;
$sql .= " and COMPLETED='9999-12-31 23:59:59'";
}
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_item_holdall($id) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
if (isset($id)) {
$sql = "UPDATE TBLTICKETITEM SET DUEDATE='9999-12-31'";
$sql .= "WHERE";
$sql .= " HEADERID = " . $id;
$sql .= " and COMPLETED='9999-12-31 23:59:59'";
}
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_items_close_all($headerid,$completeddate,$completedby){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
$sql = "UPDATE TBLTICKETITEM SET ";
$sql .= "TICOMPLETEDBY='" . $completedby . "', ";
$sql .= "COMPLETED='" . $completeddate . "'";
$sql .= " WHERE HEADERID = " . $headerid . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update($table, $headerid, $filter, $field, $value) {
//General Update function to send any misc updates to the database.
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
if (isset($table) and isset($headerid) and isset($filter)) {
$sql = "UPDATE " . $table . " SET " . $field . "='" . $value . "' WHERE " . $filter . ";";
}
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_kit_cost($pkid){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLPACKAGES eb";
$sql .= " JOIN ( SELECT ep.PKGID, SUM(op.COSTLABOR * ep.PARVALUE) as 'COSTTOTAL'";
$sql .= " FROM TBLPKGPARTS ep, TBLPARTS op ";
$sql .= " WHERE op.PARNAME = 'INCLUDED'";
$sql .= " and ep.PARTID = op.PARTID";
$sql .= " and ep.PKGID = " . $pkid;
$sql .= " GROUP BY ep.ENTID) kt";
$sql .= " ON kt.PKGID = eb.PKGID";
$sql .= " SET eb.BEDBOOKPRICE = kt.COSTTOTAL";
$sql .= " WHERE eb.PKGID = " . $pkid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_kit_cost_by_part($pid, $entid){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLPACKAGES eb";
$sql .= " JOIN ( SELECT ep.PKGID, ROUND(SUM(op.COSTLABOR * ep.PARVALUE),2) as 'COSTTOTAL'";
$sql .= " FROM TBLPKGPARTS ep, TBLPARTS op";
$sql .= " WHERE ep.PARTID = op.PARTID";
$sql .= " and ep.ENTID=" . $entid;
$sql .= " GROUP BY ep.PKGID) kt";
$sql .= " ON kt.PKGID = eb.PKGID";
$sql .= " JOIN ( SELECT PKGID";
$sql .= " FROM TBLPKGPARTS";
$sql .= " WHERE PARTID = " . $pid;
$sql .= " and ENTID = " . $entid . ") pp";
$sql .= " ON pp.PKGID = eb.PKGID";
$sql .= " SET eb.BEDBOOKPRICE = kt.COSTTOTAL";
$sql .= " WHERE eb.ENTID=" . $entid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_kit_dealercost_by_part($pid, $entid){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLPACKAGES eb";
$sql .= " JOIN(SELECT PKGID";
$sql .= " FROM TBLPKGPARTS";
$sql .= " WHERE PARTID = " . $pid . " AND ENTID = " . $entid . ") pp";
$sql .= " ON pp.PKGID = eb.PKGID";
$sql .= " SET eb.DEALERCOST = ROUND(eb.BEDBOOKPRICE *((1 -(eb.WHOLESALEDISC / 100)) * (1 +(eb.SURCHARGEPCT / 100))),2)";
$sql .= " WHERE eb.ENTID = " . $entid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_kit_laborcost_by_part($pid, $entid, $entlbrrate){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLPACKAGES eb";
$sql .= " JOIN ( SELECT PKGID";
$sql .= " FROM TBLPKGPARTS";
$sql .= " WHERE PARTID = " . $pid;
$sql .= " and ENTID = " . $entid . ") pp";
$sql .= " ON pp.PKGID = eb.PKGID";
$sql .= " SET eb.TOTALCOST = ROUND(eb.DEALERCOST + (eb.INSTALLLABOR * " . $entlbrrate . "),2)";
$sql .= " WHERE eb.ENTID=" . $entid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_kit_price_by_part($pid, $entid){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLPACKAGES eb";
$sql .= " JOIN( SELECT PKGID";
$sql .= " FROM TBLPKGPARTS";
$sql .= " WHERE PARTID = " . $pid . " AND ENTID = " . $entid . ") pp";
$sql .= " ON pp.PKGID = eb.PKGID";
$sql .= " SET eb.MSRPRETAIL = ROUND(IF(eb.MARKUPHOLD = 0,eb.TOTALCOST + eb.MARKUP, eb.TOTALCOST +(eb.MARKUPPCT * eb.TOTALCOST)),2),";
$sql .= " eb.MARKUP = IF(eb.MARKUPHOLD = 0,eb.MARKUP,ROUND((eb.MARKUPPCT * eb.TOTALCOST),2)),";
$sql .= " eb.MARKUPPCT = IF(eb.MARKUPHOLD = 0,ROUND((eb.MARKUP / eb.TOTALCOST) * 100,2),eb.MARKUPPCT)";
$sql .= " WHERE eb.ENTID = " . $entid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//**
//***********************************************************************************
function update_last_login($id, $ip, $datetime) {
//Update last logged in date.
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
$sql = "UPDATE TBLMEMBERS SET";
$sql .= " LASTLOGIN = '" . $datetime . "', ";
$sql .= " LASTIP='" . $ip . "'";
$sql .= " WHERE MEMBERID = " . $id . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_line_number($qid, $oldno, $newno) {
//updates the line number.
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ":Could not connect: " . mysqli_error($conn));
}
$sql = "UPDATE TBLQUOTELINES SET";
$sql .= " QLLINENO = " . $newno . " ";
$sql .= " WHERE QUOTEHEADERID = " . $qid;
$sql .= " and QLLINENO = " . $oldno;
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_member($entid, $memberid, $memberuserid, $membername, $memberemail, $membercell, $membercarrier, $membertext, $memberrole, $storeid, $active, $storeadmin, $editheader, $edititem, $entadmin, $showcost){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLMEMBERS SET";
if (isset($entid)) {
$sql .= " MEMBERENTID='" . $entid . "',";
}
if (isset($memberuserid)) {
$sql .= " MEMBERUSERID='" . $memberuserid . "',";
}
if (isset($membername)) {
$sql .= " MEMBERNAME='" . $membername . "',";
}
if (isset($memberemail)) {
$sql .= " MEMBEREMAIL='" . $memberemail . "',";
}
if (isset($membercell)) {
$sql .= " MEMBERCELL='" . $membercell . "',";
}
if (isset($membercarrier)) {
$sql .= " MEMBERCARRIER='" . $membercarrier . "',";
}
if (isset($membercarrier)) {
$sql .= " MEMBERTEXT='" . $membertext . "',";
}
if (isset($memberrole)) {
$sql .= " MEMBERROLE='" . $memberrole . "',";
}
if (isset($storeid)) {
$sql .= " STOREID='" . $storeid . "',";
}
if (isset($active)) {
$sql .= " ACTIVE='" . $active . "',";
}
if (isset($storeadmin)) {
$sql .= " STOREADMIN='" . $storeadmin . "',";
}
if (isset($editheader)) {
$sql .= " EDITHEADER='" . $editheader . "',";
}
if (isset($edititem)) {
$sql .= " EDITITEM='" . $edititem . "',";
}
if (isset($entadmin)) {
$sql .= " ENTADMIN='" . $entadmin . "',";
}
if (isset($showcost)) {
$sql .= " SHOWCOST ='" . $showcost . "',";
}
$sql .= " MODIFIEDDATE=now()";
$sql .= " WHERE MEMBERID=" . $memberid;
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_member_pw($memberid,$pwd,$flagreset) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLMEMBERS SET ";
$sql .= " MEMBERPASSWORD='" . $pwd . "',";
$sql .= " FLAGRESETPW='" . $flagreset . "',";
$sql .= " MODIFIEDDATE=now()";
$sql .= " WHERE MEMBERID=" . $memberid;
//Write_data(__FUNCTION__ . ">>" . __LINE__ . ">>" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_notify_sent($notifyentity, $runtime) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//5 minutes before runtime
$pasttime = date("Y-m-d H:i:s", strtotime($runtime)-(60*5));
$sql = "UPDATE TBLNOTIFY SET";
$sql .= " SENTDATE='" . $runtime . "'";
$sql .= " WHERE NOTIFYENTITY='" . $notifyentity . "'";
$sql .= " and CREATEDDATE <='" . $pasttime . "'";
$sql .= " and SENTDATE = '0000-00-00 00:00:00'";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_quoteline($qlid, $qid,$qtype,$costype,$qdesc,$qlineno,$qpartqty,$qpartno,$qlaborhours,$qlaborcost,$qlaborprice,$qmatcost,$qmatprice,$qprofit,$qtotal,$qlineprofit,$qlinetotal,$createdby,$modifiedby,$createddate,$modifieddate){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLQUOTELINES SET";
If ($qtype != NULL) {
$sql .= " QLTYPE=\"" . $qtype . "\", ";
}
If ($qdesc != NULL) {
$sql .= " QLDESC=\"" . $qdesc . "\", ";
}
If ($qlineno != NULL) {
$sql .= " QLLINENO='" . $qlineno . "', ";
}
If ($qpartno != NULL) {
$sql .= " QLPARTNO='" . $qpartno . "', ";
}
If ($qlaborhours != NULL) {
$sql .= " QLLABORHRS='" . $qlaborhours . "', ";
}
If ($qlaborcost != NULL) {
$sql .= " QLLABORCOST='" . $qlaborcost . "', ";
}
If ($qlaborprice != NULL) {
$sql .= " QLLABORPRICE='" . $qlaborprice . "', ";
}
If ($qpartqty != NULL) {
$sql .= " QLPARTQTY='" . $qpartqty . "', ";
}
If ($qmatcost != NULL) {
$sql .= " QLMATCOST='" . $qmatcost . "', ";
}
If ($qmatprice != NULL) {
$sql .= " QLMATPRICE='" . $qmatprice . "', ";
}
If ($qprofit != NULL) {
$sql .= " QLPROFIT='" . $qprofit . "', ";
}
If ($qtotal != NULL) {
$sql .= " QLTOTAL='" . $qtotal . "', ";
}
If ($qlineprofit != NULL) {
$sql .= " QLLINEPROFIT='" . $qlineprofit . "', ";
}
If ($qlinetotal != NULL) {
$sql .= " QLLINETOTAL='" . $qlinetotal . "', ";
}
If ($modifiedby != NULL) {
$sql .= " MODIFIEDBY='" . $modifiedby . "', ";
}
If ($modifiedby != NULL) {
$sql .= " MODIFIEDBY='" . $modifiedby . "', ";
}
If ($modifieddate != NULL) {
$sql .= " MODIFIEDDATE='" . $modifieddate . "' ";
}
$sql .= " WHERE QUOTELINEID = " . $qlid;
$sql .= " and QUOTEHEADERID = " . $qid;
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_quoteline_amount($qid, $qlno){
//Updates the cost, profit and price of the quote line.
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLQUOTELINES ql";
$sql .= " JOIN ( SELECT QUOTEHEADERID, QLLINENO, SUM(QLMATCOST * QLPARTQTY) as 'COSTTOTAL',";
$sql .= " SUM(QLMATPRICE * QLPARTQTY) as 'PRICETOTAL',";
$sql .= " SUM(QLMATPRICE * QLPARTQTY) - SUM(QLMATCOST * QLPARTQTY) as 'PROFITTOTAL'";
$sql .= " FROM TBLQUOTELINES ql";
$sql .= " WHERE ql.QUOTEHEADERID = " . $qid;
$sql .= " and ql.QLLINENO = " . $qlno;
$sql .= " and ql.QLTYPE in (2,4)";
$sql .= " ) lt";
$sql .= " ON lt.QUOTEHEADERID = ql.QUOTEHEADERID and lt.QLLINENO = ql.QLLINENO";
$sql .= " SET ql.QLMATCOST = lt.COSTTOTAL,ql.QLTOTAL = lt.PRICETOTAL,ql.QLPROFIT = lt.PROFITTOTAL";
$sql .= " WHERE ql.QUOTEHEADERID = " . $qid;
$sql .= " and ql.QLLINENO = " . $qlno;
$sql .= " and ql.QLTYPE = 1";
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_quoteline_amounts($qid, $qlid, $qlno){
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
$sql = "UPDATE TBLQUOTELINES ql";
$sql .= " JOIN ( SELECT QUOTEHEADERID, QLLINENO, SUM(QLMATCOST * QLPARTQTY) as 'COSTTOTAL',";
$sql .= " SUM(QLMATPRICE * QLPARTQTY) as 'PRICETOTAL',";
$sql .= " SUM(QLMATPRICE * QLPARTQTY) - SUM(QLMATCOST * QLPARTQTY) as 'PROFITTOTAL'";
$sql .= " FROM TBLQUOTELINES ql";
$sql .= " WHERE ql.QUOTEHEADERID = " . $qid;
$sql .= " and ql.QLLINENO = " . $qlno;
$sql .= " and ql.QLTYPE =2";
$sql .= " ) lt";
$sql .= " ON lt.QUOTEHEADERID = ql.QUOTEHEADERID and lt.QLLINENO = ql.QLLINENO";
$sql .= " SET ql.QLMATCOST = lt.COSTTOTAL,ql.QLTOTAL = lt.PRICETOTAL,ql.QLPROFIT = lt.PROFITTOTAL";
$sql .= " WHERE ql.QUOTEHEADERID = " . $qid;
$sql .= " and ql.QUOTELINEID = " . $qlid;
$sql .= " and ql.QLLINENO = " . $qlno;
$sql .= " and ql.QLTYPE =1";
//Write_data(__FUNCTION__ . "-". __LINE__ . "||" . $sql);
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function Update_Store_Item($dlid,$itemid,$wcid,$itemhours) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLSTOREITEMS SET ";
$sql .= "WCID=" . $wcid .", ";
$sql .= "ITEMHOURS=" . $itemhours ."";
$sql .= " WHERE DLID= " . $dlid . " ";
$sql .= " and ITEMID= " . $itemid . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_ticket_item($ticketitemid, $tidescription, $wcid, $duedate, $completed, $completeddate, $sortorder, $worktime, $itemnotes, $titechid1, $titechtime1, $titechid2, $titechtime2, $titechid3, $titechtime3, $titechid4, $titechtime4, $invoice, $invoiceamount,$modifiedby,$completedby,$modifieddate) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
//remove apostrophes
$tidescription = str_replace(array('\'', '"'), "", $tidescription);
$itemnotes = str_replace(array('\'', '"'), "", $itemnotes);
$sql = "UPDATE TBLTICKETITEM SET ";
If ($tidescription != NULL) {
$sql .= "TIDESCRIPTION='" . $tidescription . "', ";
}
If ($wcid != NULL) {
$sql .= "WCID = '" . $wcid . "', ";
}
If ($duedate != NULL) {
$sql .= "DUEDATE = '" . $duedate . "', ";
}
If (!empty($completed)) {
$sql .= "COMPLETED = '" . $completed . "', ";
}
If (!empty($completeddate)) {
$sql .= "COMPLETEDDATE = '" . $completeddate . "', ";
}
If ($sortorder != NULL) {
$sql .= "SORTORDER='" . $sortorder . "', ";
}
If ($worktime != NULL) {
$sql .= "WORKTIME='" . $worktime . "', ";
}
If ($itemnotes != NULL) {
$sql .= "ITEMNOTES='" . $itemnotes . "', ";
}
If ($titechid1 != NULL) {
$sql .= "TITECHID1='" . $titechid1 . "', ";
}
If ($titechid2 != NULL) {
$sql .= "TITECHID2='" . $titechid2 . "', ";
}
If ($titechid3 != NULL) {
$sql .= "TITECHID3='" . $titechid3 . "', ";
}
If ($titechid4 != NULL) {
$sql .= "TITECHID4='" . $titechid4 . "', ";
}
If ($titechtime1 != NULL) {
$sql .= "TITECHtime1='" . $titechtime1 . "', ";
}
If ($titechtime2 != NULL) {
$sql .= "TITECHtime2='" . $titechtime2 . "', ";
}
If ($titechtime3 != NULL) {
$sql .= "TITECHtime3='" . $titechtime3 . "', ";
}
If ($titechtime4 != NULL) {
$sql .= "TITECHtime4='" . $titechtime4 . "', ";
}
If ($invoice != NULL) {
$sql .= "INVOICE='" . $invoice . "', ";
}
If ($invoiceamount != NULL) {
$sql .= "INVOICEAMOUNT='" . $invoiceamount . "', ";
}
If ($modifiedby != NULL) {
$sql .= "TIMODIFIEDBY='" . $modifiedby . "', ";
}
If ($completedby != NULL) {
$sql .= "TICOMPLETEDBY='" . $completedby . "', ";
}
$sql .= "TIMODIFIEDDATE='" . $modifieddate . "' ";
$sql .= " WHERE TICKETITEMID = " . $ticketitemid . "";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function Update_Uncomplete($headerid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLTICKETHEADER SET ";
$sql .= "COMPLETEDDATE='0000-00-00 00:00:00', ";
$sql .= " COMPLETEDBY='' ";
$sql .= " WHERE HEADERID = " . $headerid . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function Update_Uncomplete_Item($ticketitemid) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLTICKETITEM SET ";
$sql .= "COMPLETED='9999-12-31 23:59:59', ";
$sql .= "COMPLETEDDATE='9999-12-31', ";
$sql .= " TICOMPLETEDBY='' ";
$sql .= " WHERE TICKETITEMID = " . $ticketitemid . ";";
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
//***********************************************************************************
function update_role($roleid, $title, $active, $admin, $editheader, $edititem, $editstore, $owner, $editaddstoremember,$editstorerouting,$editwc, $defpage, $toseconds, $modidfieddate) {
//connect to db
include('connect.php');
$conn = mysqli_connect($hostname, $username, $password, $database);
//check connection
if (!$conn) {
die(__FUNCTION__ . ':Could not connect: ' . mysqli_error($conn));
}
$sql = "UPDATE TBLROLES SET";
if (isset($title)) {
$sql .= " TITLE='" . $title . "',";
}
$sql .= " ACTIVE=" . $active . ",";
$sql .= " ADMIN=" . $admin . ",";
$sql .= " EDITHEADER=" . $editheader . ",";
$sql .= " EDITITEM=" . $edititem . ",";
$sql .= " EDITSTORE=" . $editstore . ",";
$sql .= " EDITADDSTOREMEMBER=" . $editaddstoremember . ",";
$sql .= " EDITSTOREROUTING=" . $editstorerouting . ",";
$sql .= " EDITWC=" . $editwc . ",";
$sql .= " OWNER=" . $owner . ",";
$sql .= " DEFPAGE=" . $defpage . ",";
$sql .= " TOSECONDS=" . $toseconds;
$sql .= " WHERE ROLEID=" . $roleid;
if (mysqli_query($conn, $sql)) {
} else {
echo __FUNCTION__ . " Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
Reset Password