public static function deleteCar($carID = 0) { try { if ($carID <= 0) { throw new Exception\ArgumentNullException('carID'); } } catch (Exception\ArgumentNullException $e) { $e->showException(); return false; } $query = new Query("delete"); $query->setDeleteParams($carID, null, MyCarTable::getTableName(), MyCarTable::getMapArray(), MyCarTable::getTableLinks()); $res = $query->exec(); if ($ar_res = $res->fetch()) { return $ar_res; } else { return false; } }
private function sqlMassDelete($query = null) { try { if (is_null($query)) { throw new Exception\ArgumentNullException('query'); } } catch (Exception\ArgumentNullException $e) { $e->showException(); return false; } $helper = new Lib\SqlHelper(); $arMap = $query->getTableMap(); $primaryId = $query->getDeletePrimary(); $arTableLinks = $query->getTableLinks(); $tableName = $query->getTableName(); foreach ($arTableLinks as $field => $arLinked) { foreach ($arLinked as $linkTable => $linkField) { if (is_array($linkField)) { foreach ($linkField as $linkF) { $arRes = Lib\Tools::runTableClassFunction($linkTable, 'getListFunc', array(array('select' => array('ID'), 'filter' => array($linkF => $primaryId)))); if ($arRes) { foreach ($arRes as $delID) { $deleteQuery = new Query('delete'); $deleteQuery->setDeleteParams($delID, true, null, Lib\Tools::runTableClassFunction($linkTable, 'getTableMap'), Lib\Tools::runTableClassFunction($linkTable, 'getTableLinks')); $deleteQuery->exec(); } } } } else { $arRes = Lib\Tools::runTableClassFunction($linkTable, 'getListFunc', array(array('select' => array('ID'), 'filter' => array($linkField => $primaryId)))); if ($arRes) { foreach ($arRes as $delID) { $deleteQuery = new Query('delete'); $deleteQuery->setDeleteParams($delID, true, Lib\Tools::runTableClassFunction($linkTable, 'getTableName'), Lib\Tools::runTableClassFunction($linkTable, 'getTableMap'), Lib\Tools::runTableClassFunction($linkTable, 'getTableLinks')); $deleteQuery->exec(); } } } } } foreach ($arMap as $field => $objData) { if ($objData->isPrimary()) { $primaryField = $objData->getColumnName(); $primaryObj = $objData; break; } } $sql = "DELETE FROM " . $helper->wrapQuotes($tableName); $sql .= " WHERE " . $helper->wrapQuotes($tableName) . "."; $sql .= $helper->wrapQuotes($primaryField) . " = "; if ($primaryObj instanceof IntegerField || $primaryObj instanceof FloatField) { $sql .= $primaryId; } else { $sql .= "'" . $primaryId . "'"; } $sql .= " LIMIT 1"; $delQuery = new Query('delete'); $delQuery->setQueryBuildParts($sql); $res = $delQuery->exec(); }
public static function deleteTs($tsID = null) { try { if (is_null($tsID)) { throw new Exception\ArgumentNullException('tsID'); } } catch (Exception\ArgumentNullException $e) { $e->showException(); return false; } $query = new Query('delete'); $query->setDeleteParams($tsID, null, Tables\TsTable::getTableName(), Tables\TsTable::getMapArray(), Tables\TsTable::getTableLinks()); $res = $query->exec(); if ($res->getResult()) { return true; } else { return false; } }
protected static function deleteAccount($primary, $confirm = null) { $query = new Entity\Query('delete'); $query->setDeleteParams($primary, $confirm, Tables\AccountsTable::getTableName(), Tables\AccountsTable::getMapArray(), Tables\AccountsTable::getTableLinks()); $res = $query->exec(); }
public static function deleteFuel($fuelID = null) { try { if (is_null($fuelID)) { throw new Exception\ArgumentNullException('fuelID'); } if (intval($fuelID) <= 0) { throw new Exception\ArgumentOutOfRangeException('fuelID', 1); } } catch (Exception\ArgumentNullException $e) { die($e->showException()); } $query = new Query('delete'); $query->setDeleteParams($fuelID, true, Tables\FuelTable::getTableName(), Tables\FuelTable::getMapArray(), Tables\FuelTable::getTableLinks()); $res = $query->exec(); if ($res->getResult()) { //static::recalculateExpence(); return true; } else { return false; } }