function m_deleteTemp() { $comFunc = new c_commonFunctions(); $comFunc->obDb = $this->obDb; $this->obDb->query = "SELECT count(*) as cnt FROM " . TEMPCART . " WHERE vSessionId='" . $this->sessionId . "'"; $rowCount = $this->obDb->fetchQuery(); $this->obDb->query = "SELECT iTmpCartId_PK,iQty,iProdId_FK,iUseinventory,P.iBackorder,vDownloadablefile FROM " . TEMPCART . " AS T," . PRODUCTS . " AS P WHERE vSessionId='" . $this->sessionId . "' AND iProdId_FK=iProdId_PK"; #FLAG TO INDICATE SEPERATE BACKORDER AND NORMAL ORDER $_SESSION['backOrderSeperate'] = $this->libFunc->ifSet($_SESSION, 'backOrderSeperate', '0'); #FLAG TO INDICATE WHETHER PROCESSING BACKORDER OR NOT $_SESSION['backOrderProcess'] = $this->libFunc->ifSet($_SESSION, 'backOrderProcess', '0'); if ($_SESSION['backOrderSeperate'] == 1 && $_SESSION['backOrderProcess'] == 1) { $this->obDb->query .= " AND T.iBackOrder='1'"; } elseif ($_SESSION['backOrderSeperate'] == 1) { $this->obDb->query .= " AND T.iBackOrder<>'1'"; } $rowCart = $this->obDb->fetchQuery(); $rsCount = $this->obDb->record_count; if ($rsCount > 0) { for ($i = 0; $i < $rsCount; $i++) { #CHECK FOR DOWNLOADABLE FILE if (!empty($rowCart[$i]->vDownloadablefile)) { if ($this->libFunc->m_checkFileExist($rowCart[$i]->vDownloadablefile, "files")) { $downloadUrl = $this->libFunc->m_safeUrl(SITE_URL . "index.php?action=download&mode=" . $rowCart[$i]->vDownloadablefile); $this->fileLink .= "<a href='" . $downloadUrl . "'>" . $downloadUrl . "</a><br /><br />"; } } #UPDATING QUANTITY if (STOCK_CHECK == 1 && ($rowCart[$i]->iUseinventory == 1 && $rowCart[$i]->iBackorder != 1)) { $this->obDb->query = "UPDATE " . PRODUCTS . " SET iInventory=iInventory - " . $rowCart[$i]->iQty . " WHERE iProdId_PK\t='" . $rowCart[$i]->iProdId_FK . "'"; $this->obDb->updateQuery(); } #SEND STOCK EMAIL $comFunc->productId = $rowCart[$i]->iProdId_FK; $comFunc->m_sendStockMail(); $this->obDb->query = "SELECT vOptVal,iProdId_Fk FROM " . TEMPOPTIONS . " WHERE iTmpCartId_FK='" . $rowCart[$i]->iTmpCartId_PK . "'"; $rowOpt = $this->obDb->fetchQuery(); $rsOptCount = $this->obDb->record_count; if ($rsOptCount > 0) { for ($j = 0; $j < $rsOptCount; $j++) { //Neetika Patch: Product Package if ($rowOpt[$j]->vOptVal == "" && $rowOpt[$j]->iProdId_Fk != "") { $this->obDb->query = "UPDATE " . PRODUCTS . " SET iInventory=iInventory - " . $rowCart[$i]->iQty . " WHERE iProdId_PK\t='" . $rowOpt[$j]->iProdId_Fk . "'"; #TELL MOBI TO UPDATE INV if (MOBICARTEN == "enabled") { $this->obDb->query = "SELECT * FROM " . PRODUCTS . " WHERE iProdId_PK = '" . $rowOpt[$j]->iProdId_FK . "'"; $prodInfo = $this->obDb->fetchQuery(); mobi_upd_prod($prodInfo[0]->vTitle, $prodInfo[0]->vTitle, '', $prodInfo[0]->fprice, '', '', $prodInfo[0]->iInventory, $use_inventory); } } else { #UPDATING QUANTITY $this->obDb->query = "UPDATE " . OPTIONVALUES . " SET iInventory=iInventory - " . $rowCart[$i]->iQty . " WHERE iOptionValueid_PK='" . $rowOpt[$j]->vOptVal . "'"; } $this->obDb->updateQuery(); } } #DELETE TEMP OPTIONS ENTRIES FROM DATABASE $this->obDb->query = "DELETE FROM " . TEMPOPTIONS . " WHERE iTmpCartId_FK='" . $rowCart[$i]->iTmpCartId_PK . "'"; $this->obDb->updateQuery(); $this->obDb->query = "SELECT iTmpChoiceId_FK FROM " . TEMPCHOICES . " WHERE iTmpCartId_FK='" . $rowCart[$i]->iTmpCartId_PK . "'"; $rowChoice = $this->obDb->fetchQuery(); $rsChoiceCount = $this->obDb->record_count; if ($rsChoiceCount > 0) { for ($k = 0; $k < $rsChoiceCount; $k++) { #UPDATING QUANTITY $this->obDb->query = "UPDATE " . CHOICES . " SET iInventory=iInventory - " . $rowCart[$i]->iQty . " WHERE iChoiceid_PK='" . $rowChoice[$k]->iTmpChoiceId_FK . "'"; $this->obDb->updateQuery(); } } #DELETE TEMP CHOICES FROM DATABASE $this->obDb->query = "DELETE FROM " . TEMPCHOICES . " WHERE iTmpCartId_FK='" . $rowCart[$i]->iTmpCartId_PK . "'"; $this->obDb->updateQuery(); #DELEET TEMP CART $this->obDb->query = "DELETE FROM " . TEMPCART . " WHERE vSessionId='" . $this->sessionId . "'"; #FLAG TO INDICATE WHETHER PROCESSING BACKORDER OR NOT $_SESSION['backOrderProcess'] = $this->libFunc->ifSet($_SESSION, 'backOrderProcess', '0'); if ($_SESSION['backOrderSeperate'] == 1 && $_SESSION['backOrderProcess'] == 1) { $this->obDb->query .= " AND iBackOrder='1'"; } elseif ($_SESSION['backOrderSeperate'] == 1) { $this->obDb->query .= " AND iBackOrder<>'1'"; } $this->obDb->updateQuery(); } #end for } #end if if ($rowCount[0]->cnt == $rsCount || $rowCount[0]->cnt == "0") { #DELETE FROM SESSION foreach ($_SESSION as $sid => $svalue) { $notDestroyArrray = array('cssSelectedFile', 'userid', 'uid', 'username', 'uname', 'email'); if (!in_array($sid, $notDestroyArrray)) { unset($_SESSION[$sid]); } } } }