public function quick_update() { $this->begin('index.php?app=b2c&ctl=admin_stock&act=index'); $params = $_POST; if (!$params['stock_id']) { $this->end(false); } $stock_id = $params['stock_id']; unset($params['stock_id']); foreach ($params as $key => $value) { if (!in_array($key, array('stock_id', 'quantity', 'freez_quantity'))) { unset($params[$key]); } } $mdl_stock = app::get('b2c')->model('stock'); $update_sql = base_db_tools::getupdatesql($mdl_stock->table_name(1), $params, " stock_id={$stock_id}"); $this->end($mdl_stock->db->exec($update_sql, true)); }
public function quick_update() { $this->begin('index.php?app=b2c&ctl=admin_pages_content&act=index'); $params = $_POST; if (!$params['content_id']) { $this->end(false); } $content_id = $params['content_id']; unset($params['content_id']); foreach ($params as $key => $value) { if (!in_array($key, array('content_id', 'ordernum', 'status'))) { unset($params[$key]); } } $update_sql = base_db_tools::getupdatesql($this->mContent->table_name(1), $params, " content_id={$content_id}"); $this->end($this->mContent->db->exec($update_sql, true)); }
public function replace($data, $filter) { $where = base_db_tools::filter2sql($filter); $rs = $this->db->exec('select * from ' . $this->table_name(1) . ' where ' . $where); $sql = base_db_tools::getupdatesql($rs, $data, 1); return !$sql || $this->db->exec($sql); }
public function replace($data, $filter) { $exits_row = $this->count($filter); if ($exits_row) { $where = base_db_tools::filter2sql($filter); $sql = base_db_tools::getupdatesql($this->table_name(1), $data, $where); } else { return $this->insert($data); } return $this->db->exec($sql, $this->skipModifiedMark); }
public function quick_update() { $this->begin('index.php?app=b2c&ctl=admin_pages_position&act=index'); $params = $_POST; if (!$params['position_id']) { $this->end(false); } $position_id = $params['position_id']; unset($params['position_id']); foreach ($params as $key => $value) { if (!in_array($key, array('position_id', 'ordernum'))) { unset($params[$key]); } } $mPostion = app::get('b2c')->model('pages_position'); $update_sql = base_db_tools::getupdatesql($this->mPosition->table_name(1), $params, " position_id={$position_id}"); $this->end($this->mPosition->db->exec($update_sql, true)); }