public function delete($ids) { if ($ids) { $sql = "SELECT logo_id FROM " . DB_PREFIX . "res_sort WHERE id IN(" . $ids . ")"; $q = $this->db->query($sql); $mid = $space = ''; while ($row = $this->db->fetch_array($q)) { $mid .= $space . $row['logo_id']; $space = ','; } $sql = "DELETE FROM " . DB_PREFIX . "res_sort WHERE id IN(" . $ids . ")"; $this->db->query($sql); $sql = "DELETE FROM " . DB_PREFIX . "res WHERE sort_id IN(" . $ids . ")"; //删除res对应子项目 $this->db->query($sql); if ($mid) { include_once ROOT_PATH . 'lib/class/material.class.php'; $mater = new material(); $mater->delMaterialById($mid); } return array('id' => $ids); } }
public function delete() { if (empty($this->input['id'])) { $this->errorOutput("ID不能为空"); } $ids = urldecode($this->input['id']); include_once ROOT_PATH . 'lib/class/material.class.php'; $material = new material(); //删除圈子log $sql = "SELECT log FROM " . DB_PREFIX . "group WHERE id IN(" . $ids . ")"; $q = $this->db->query($sql); while ($row = $this->db->fetch_array($q)) { $row['log'] = json_decode($row['log'], 1); if ($row['log']) { $material->delMaterialById($row['log'][0]['id'], 2); } } $sql = "DELETE FROM " . DB_PREFIX . "group WHERE id IN(" . $ids . ")"; $this->db->query($sql); $this->addLogs('删除路况分类', '', '', '删除路况分类+' . $ids); $this->addItem($ids); $this->output(); }
/** * 删除图片 */ public function dropImg() { $id = intval($this->input['id']); if ($id <= 0) { $this->errorOutput(PARAM_WRONG); } $info = $this->company->detail('material', array('id' => $id)); if (!$info) { $this->errorOutput(PARAM_WRONG); } include_once ROOT_PATH . 'lib/class/material.class.php'; $material = new material(); $material->delMaterialById($info['m_id']); $result = $this->company->delete('material', array('id' => $id)); $this->addItem($result); $this->output(); }
public function delete($ids) { if ($ids) { $sql = "SELECT material_id,sort_id,bill_id FROM " . DB_PREFIX . "bill_record WHERE id IN(" . $ids . ")"; $q = $this->db->query($sql); $mid = $space = ''; $bill_id = 0; $sort = array(); while ($row = $this->db->fetch_array($q)) { $mid .= $space . $row['material_id']; $space = ','; if ($row['sort_id']) { $sort[] = $row['sort_id']; } $bill_id = $row['bill_id']; //目前删除,批量删除,只能删除某个订单下的 } if ($bill_id) { include_once CUR_CONF_PATH . 'lib/bill.class.php'; $this->bill = new bill(); $checkbool = $this->bill->checkLocked($bill_id); if ($checkbool) { return array('error' => THIS_IS_LOCKED); } } $sql = "DELETE FROM " . DB_PREFIX . "bill_record WHERE id IN(" . $ids . ")"; $this->db->query($sql); /****删除成功成功执行以下操作*****/ if ($mid) { include_once ROOT_PATH . 'lib/class/material.class.php'; $mater = new material(); $mater->delMaterialById($mid); } if ($sort) { foreach ($sort as $key => $value) { $this->updateSortCount($value, -1); } } /*****end******/ return array('id' => $ids, 'bill_id' => $bill_id); } }
/** * 删除上传图片 * @param $id int 图片ID */ private function delete_image($id) { if (!$id) { return false; } $sql = "SELECT mid FROM " . DB_PREFIX . "material WHERE id in (" . $id . ")"; $q = $this->db->query($sql); while ($r = $this->db->fetch_array($q)) { $mid[] = $r['mid']; } $mid = implode(',', $mid); $sql = "DELETE FROM " . DB_PREFIX . "material WHERE id in (" . $id . ")"; $data = $this->db->query_first($sql); if ($mid) { include_once ROOT_PATH . 'lib/class/material.class.php'; $material_pic = new material(); $material_pic->delMaterialById($mid); } return $id; }
/** * 删除图片素材信息 */ public function dropMaterial() { $pid = isset($this->input['p_id']) ? intval($this->input['p_id']) : ''; if (empty($pid)) { $this->errorOutput(PARAM_WRONG); } $info = $this->status->getMaterial($pid, $this->user['user_id']); if (!$info) { $this->errorOutput(OBJECT_NULL); } //删除本地图片信息 $result = $this->status->delete('material', array('id' => $pid)); //删除图片服务器上的信息 include_once ROOT_PATH . 'lib/class/material.class.php'; $material = new material(); $material->delMaterialById($info['material_id'], 2); $this->addItem($result); $this->output(); }
public function delete() { if (empty($this->input['id'])) { $this->errorOutput("ID不能为空"); } $ids = urldecode($this->input['id']); include_once ROOT_PATH . 'lib/class/material.class.php'; $material = new material(); //删除圈子log $sql = "SELECT log FROM " . DB_PREFIX . "circle WHERE id IN(" . $ids . ")"; $q = $this->db->query($sql); while ($row = $this->db->fetch_array($q)) { $row['log'] = json_decode($row['log'], 1); if ($row['log']) { $material->delMaterialById($row['log'][0]['id'], 2); } } $sql = "DELETE FROM " . DB_PREFIX . "circle WHERE id IN(" . $ids . ")"; $this->db->query($sql); $sql = "DELETE FROM " . DB_PREFIX . "weibo_circle WHERE circle_id IN(" . $ids . ")"; $this->db->query($sql); //修改用户表中的溶于数据 $sql = "SELECT user_id FROM " . DB_PREFIX . "user_circle WHERE circle_id IN(" . $ids . ")"; $ret = $this->db->query($sql); $user_id = array(); while ($row = $this->db->fetch_array($ret)) { $user_id[] = $row['user_id']; } $user_id = $user_id && is_array($user_id) ? implode(',', $user_id) : $user_id; $this->update_user($user_id, $ids); $sql = "DELETE FROM " . DB_PREFIX . "user_circle WHERE circle_id IN(" . $ids . ")"; $this->db->query($sql); $this->addLogs('删除微博圈', '', '', '删除微博圈+' . $ids); $this->addItem($ids); $this->output(); }