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;
}
}
