public function delete($delete)
{
$affected = 0;
$sql = "DELETE FROM orders WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
// удаление связей
$sql = "DELETE FROM files WHERE `table`='orders' AND rec_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "SELECT * FROM tz WHERE order_id='{$delete}'";
$res = sql::fetchAll($sql);
foreach ($res as $rs) {
// удаление
$delete = $rs["id"];
$sql = "DELETE FROM tz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
// удаление связей
$sql = "SELECT * FROM posintz WHERE tz_id='{$delete}'";
$res1 = sql::fetchAll($sql);
foreach ($res1 as $rs1) {
$delete = $rs1["id"];
$sql = "DELETE FROM posintz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
}
}
return $affected;
}
public function setRecord($data)
{
extract($data);
if ($action == "users") {
if (!empty($edit)) {
// редактирование
$sql = "UPDATE users\n SET nik='{$nik}',\n fullname='{$fullname}',\n position='{$position}',\n password='******'\n WHERE id='{$edit}'";
} else {
// добавление
$sql = "INSERT INTO users (nik,fullname,position,password)\n VALUES ('{$nik}','{$fullname}','{$position}','{$password1}')";
}
sql::query($sql);
} else {
$sql = "DELETE FROM rights WHERE u_id='{$userid}'";
sql::query($sql);
if (!empty($r)) {
foreach ($r as $key => $val) {
foreach ($val as $k => $V) {
$sql = "INSERT INTO rights (u_id,type_id,rtype_id,rights.right) VALUES ('{$userid}','{$key}','{$k}','1')";
sql::query($sql);
}
}
}
// почистить сессию для того чтоб вступили права пользователь должен перезайти
//$sql = "DELETE FROM session WHERE u_id='{$userid}'";
//sql::query($sql);
}
return sql::affected();
}
public function delete($delete)
{
$affected = 0;
$sql = "INSERT INTO {$this->db}sk_arc_{$this->sklad}_spr (nazv,edizm,krost)\n SELECT sk_{$this->sklad}_spr.nazv,sk_{$this->sklad}_spr.edizm,sk_{$this->sklad}_spr.krost\n FROM {$this->db}sk_{$this->sklad}_spr\n WHERE sk_{$this->sklad}_spr.id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$id = sql::lastId();
$sql = "DELETE FROM {$this->db}sk_{$this->sklad}_spr WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "INSERT INTO {$this->db}sk_arc_{$this->sklad}_ost (spr_id,ost)\n SELECT {$id},sk_{$this->sklad}_ost.ost\n FROM {$this->db}sk_{$this->sklad}_ost\n WHERE sk_{$this->sklad}_ost.spr_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "DELETE FROM {$this->db}sk_{$this->sklad}_ost WHERE spr_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "INSERT INTO {$this->db}sk_arc_{$this->sklad}_dvizh (type,numd,numdf,docyr,spr_id,quant,ddate,post_id,comment_id,price)\n SELECT sk_{$this->sklad}_dvizh.type,sk_{$this->sklad}_dvizh.numd,sk_{$this->sklad}_dvizh.numdf,sk_{$this->sklad}_dvizh.docyr,{$id},sk_{$this->sklad}_dvizh.quant,sk_{$this->sklad}_dvizh.ddate,sk_{$this->sklad}_dvizh.post_id,sk_{$this->sklad}_dvizh.comment_id,sk_{$this->sklad}_dvizh.price\n FROM {$this->db}sk_{$this->sklad}_dvizh\n WHERE sk_{$this->sklad}_dvizh.spr_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "DELETE FROM {$this->db}sk_{$this->sklad}_dvizh WHERE spr_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "INSERT INTO {$this->db}sk_arc_{$this->sklad}_dvizh (type,numd,numdf,docyr,spr_id,quant,ddate,post_id,comment_id,price)\n SELECT sk_{$this->sklad}_dvizh_arc.type,sk_{$this->sklad}_dvizh_arc.numd,sk_{$this->sklad}_dvizh_arc.numdf,sk_{$this->sklad}_dvizh_arc.docyr,{$id},sk_{$this->sklad}_dvizh_arc.quant,sk_{$this->sklad}_dvizh_arc.ddate,sk_{$this->sklad}_dvizh_arc.post_id,sk_{$this->sklad}_dvizh_arc.comment_id,sk_{$this->sklad}_dvizh_arc.price\n FROM {$this->db}sk_{$this->sklad}_dvizh_arc\n WHERE sk_{$this->sklad}_dvizh_arc.spr_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
$sql = "DELETE FROM {$this->db}sk_{$this->sklad}_dvizh_arc WHERE spr_id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
return $affected;
}
public function delete($delete)
{
$affected = 0;
$sql = "DELETE FROM posintz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
return $affected;
}
public function delete($delete)
{
$sql = "DELETE FROM blocks WHERE id='{$delete}'";
sql::query($sql);
$sql = "DELETE FROM blockpos WHERE block_id='{$delete}'";
sql::query($sql);
return sql::affected();
}
public function setRecord($data)
{
extract($data);
if (!empty($edit)) {
$sql = "UPDATE todo SET what='" . addslashes($what) . "', cts=NOW(), rts='0', u_id='" . Auth::getInstance()->getUser('userid') . "' WHERE id='{$edit}'";
} else {
$sql = "INSERT INTO todo (what,cts,rts,u_id) VALUES ('" . addslashes($what) . "',NOW(),'0'," . Auth::getInstance()->getUser('userid') . ")";
}
sql::query($sql);
return sql::affected();
}
public function setRecord($data)
{
extract($data);
if (!empty($edit)) {
$sql = "UPDATE rtypes SET type='{$type}' WHERE id='{$edit}'";
} else {
$sql = "INSERT INTO `rtypes` (`type`) VALUES ('{$type}')";
}
sql::query($sql);
return sql::affected();
}
public function setRecord($data)
{
extract($data);
if (!empty($edit)) {
$sql = "UPDATE conductors SET pib='{$pib}', side='{$side}', lays='{$lays}', user_id='" . Auth::getInstance()->getUser('userid') . "', ts=NOW() WHERE id='{$edit}'";
} else {
$sql = "INSERT INTO conductors (board_id,pib,side,lays,user_id,ts) VALUES('{$board_id}','{$pib}','{$side}','{$lays}','" . Auth::getInstance()->getUser('userid') . "',NOW())";
}
sql::query($sql);
return sql::affected();
}
public function delete($delete)
{
$affected = 0;
$sql = "SELECT * FROM {$this->db}sk_{$this->sklad}_dvizh\n WHERE id='{$delete}'";
$rs = sql::fetchOne($sql);
$sql = "UPDATE {$this->db}sk_{$this->sklad}_ost\n SET ost=ost" . ($rs["type"] ? "-" : "+") . abs($rs["quant"]) . " " . "WHERE spr_id='{$rs["spr_id"]}'";
sql::query($sql);
$affected += sql::affected();
$sql = "DELETE FROM {$this->db}sk_{$this->sklad}_dvizh \n WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
return $affected;
}
public function delete($delete)
{
$affected = 0;
$sql = "DELETE FROM tz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
// удаление связей
$sql = "SELECT * FROM posintz WHERE tz_id='{$delete}'";
$res = sql::fetchAll($sql);
foreach ($res as $rs) {
$delete = $rs["id"];
$sql = "DELETE FROM posintz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
}
return $affected;
}
public function delete($delete)
{
$affected = 0;
$sql = "DELETE FROM customers WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
// удаление связей
// TODO: Удаллить блоки и позиции в блоках, а также платы
// удалить вязанные заказы и тз
$sql = "SELECT * FROM orders WHERE customer_id='{$delete}'";
$res = sql::fetchAll($sql);
foreach ($res as $rs) {
// удаление
$delete = $rs["id"];
$sql = "DELETE FROM orders WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
// удаление связей
$sql = "SELECT * FROM tz WHERE order_id='{$delete}'";
$res1 = sql::fetchAll($sql);
foreach ($res1 as $rs1) {
// удаление
$delete = $rs1["id"];
$sql = "DELETE FROM tz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
// удаление связей
$sql = "SELECT * FROM posintz WHERE tz_id='{$delete}'";
$res2 = sql::fetchAll($sql);
foreach ($res2 as $rs2) {
$delete = $rs2["id"];
}
$sql = "DELETE FROM posintz WHERE id='{$delete}'";
sql::query($sql);
$affected += sql::affected();
}
}
return $affected;
}
public function delete($id)
{
$sql = "DELETE FROM users__settings_types WHERE id='{$id}'";
sql::query($sql);
return sql::affected();
}
public function delete($id)
{
$sql = "DELETE FROM " . $this->maintable . " WHERE id='{$id}'";
sql::query($sql);
return sql::affected();
}
/**
* Использует задел, снимает с задела
* @param int $rec массив из запроса getZadelByPosintzId
* @return int колличество обработаных записей
*/
public function usezadel($rec)
{
$res = 0;
$zds = explode(',', $rec["zds"]);
foreach ($zds as $value) {
list($id, $count) = explode('-', $value);
if ($rec["use"] < $count) {
$sql = "UPDATE zadel SET number=number-{$rec["use"]} WHERE id='{$id}'";
} else {
$sql = "DELETE FROM zadel WHERE id='{$id}'";
}
sql::query($sql);
$res += sql::affected();
$rec["use"] -= $count;
if ($rec["use"] <= 0) {
break;
}
}
return $res;
}
public function deleteComment($id)
{
$sql = "DELETE FROM comments WHERE id='{$id}'";
sql::query($sql);
return sql::affected();
}
public function delete($delete)
{
$sql = "DELETE FROM boards WHERE id='{$delete}'";
sql::query($sql);
return sql::affected();
}
public function delete($id)
{
$sql = "DELETE FROM masterplate WHERE id='{$id}'";
sql::query($sql);
return sql::affected();
}
public function delete($id)
{
$sql = "UPDATE {$this->maintable} SET lastoperation='-1', action_date=NOW() WHERE id='{$id}'";
sql::query($sql);
return sql::affected();
}
static function del($table, $where = NULL, $order = NULL, $limit = NULL, $stop = NULL)
{
sql::query('DELETE FROM `' . $table . '`' . self::__combine_where($where) . self::__combine_order($order) . self::__combine_limit($limit, $stop));
return sql::affected();
}
