function update($data, Criteria $c) { parent::update($data, $c); $comment = $this->find($c); $siteId = $comment->siteId; $this->updateSiteCommentsCount($siteId); }
public function edit($postArr) { if (empty($postArr['Id'])) { return array('status' => -1, 'msg' => '请选择要更新的问卷', 'href' => 1); } if (empty($postArr['title'])) { return array('status' => -1, 'msg' => '请填写标题', 'href' => 1); } if (empty($postArr['description'])) { return array('status' => -1, 'msg' => '请填写描述', 'href' => 1); } if (empty($postArr['start_time'])) { return array('status' => -1, 'msg' => '请选择开始时间', 'href' => 1); } if (empty($postArr['end_time'])) { return array('status' => -1, 'msg' => '请选择结束时间', 'href' => 1); } $this->_utilRbac = $this->_getGlobalData('Util_Rbac', 'object'); $userClass = $this->_utilRbac->getUserClass(); $updateArr = array(); $updateArr['title'] = $postArr['title']; $updateArr['description'] = $postArr['description']; $updateArr['start_time'] = strtotime($postArr['start_time']); $updateArr['end_time'] = strtotime($postArr['end_time']); $updateArr['status'] = $postArr['status']; $updateArr['user_id'] = $userClass['_id']; if (parent::update($updateArr, "Id={$postArr['Id']}")) { return array('status' => 1, 'msg' => false, 'href' => 1); } else { return array('status' => -2, 'msg' => '编辑问卷失败', 'href' => 1); } }
/** * */ public function update($data, $cond = null, $bind_params = null) { $cond = 'WHERE id = :id'; $bind_params = array(':id' => $data[$this->table_name]['id']); $res = parent::update($data, $cond, $bind_params); return $res; }
/** * Save user data * * @param type $userInfo * @return int userId */ public function save($userInfo) { if (isset($userInfo["id"]) && (int) $userInfo["id"] > 0) { return parent::update($userInfo, array('id' => $userInfo["id"])); } else { return parent::create($userInfo); } }
public function setLoginDetails() { $where = array("user='******'user']}'"); $updateData['login_count'] = array('login_count+1'); $updateData['last_ip'] = Tool::getIP(); $updateData['last_time'] = Tool::getDate(); parent::update($where, $updateData); }
public function selected() { $where = array("id='{$this->R['id']}'"); if (!$this->check->checkOne($this, $where)) { $this->check->showError(); } parent::update(array("user='******'user']}'"), array('selected' => 0)); return parent::update($where, array('selected' => 1)); }
public function setFirst() { $where = array("id='{$this->R['id']}'"); if (!$this->check->checkOne($this, array("id='{$this->R['id']}'"))) { $this->check->showError(); } parent::update(array("first=1"), array('first' => 0)); return parent::update($where, array('first' => 1)); }
/** * @param $id * @param array $values * @param array $valuesUnescaped * @throws DbalException * @return bool|int|string */ public function updateById($id, $values = array(), $valuesUnescaped = array()) { if (!intval($id)) { throw new DbalException('Id required'); } $this->deleteNonExistingColumns($values); $this->deleteNonExistingColumns($valuesUnescaped); return $this->model->update($this->table, $this->idColum, intval($id), $values, $valuesUnescaped); }
/** * 更新用户信息 * * @param int $uid * @param array $setdata * @return bool */ public function updateUser($uid, $setdata) { $updata = array(); foreach ($setdata as $key => $val) { $updata[$key] = addslashes(trim($val)); } unset($setdata); $where = $this->getAdapter()->bind('uid = ?', $uid); return parent::update($updata, $where); }
public static function edit($fields, $id) { ///clean all fields so they are not harmful to the database $fields = Model::cleanData($fields); //construct sql query to update username $sql = 'UPDATE posts SET title = "' . $fields['title'] . '", text = "' . $fields['text'] . '" WHERE id = ' . $id; $results = Model::update($sql); //return results to controller return $results; }
function update() { // clear all null keys (use array_filter?) foreach ($this->rs as $k => $v) { if (is_null($v)) { unset($this->rs[$k]); } } $this->rs['updated'] = time('now'); return parent::update(); }
private function updateData() { $tempData = reset($this->modelInstance->getWithField2($this->secondaryKey, $this->modelData[$this->secondaryKey])); if ($tempData !== false) { if ($this->tertiaryKey != "") { $this->modelData[$this->primaryKey] = $tempData[$this->primaryKey]; $this->modelData[$this->tertiaryKey] = $tempData[$this->tertiaryKey]; } $validated = $this->modelInstance->setData($this->modelData, $this->primaryKey, $tempData[$this->primaryKey]); if ($validated === true) { $this->modelInstance->update($this->primaryKey, $tempData[$this->primaryKey]); $this->updated++; return 'Updated'; } else { return $validated; } } else { return $this->addData(); } }
public function update() { $where = array("id='{$this->R['id']}'"); if (!$this->check->checkOne($this, $where)) { $this->check->showError(); } if (!$this->check->checkUpdate($this)) { $this->check->showError(); } $updateData = $this->getRequest()->filter($this->fields); return parent::update($where, $updateData); }
public function update() { $_where = array("id='{$this->_R['id']}'"); if (!$this->_check->oneCheck($this, $_where)) { $this->_check->error(); } if (!$this->_check->updateCheck($this)) { $this->_check->error(); } $_updateData = $this->getRequest()->filter($this->_fields); return parent::update($_where, $_updateData); }
public function update() { $where = array("id='{$this->R['id']}'"); if (!$this->check->checkOne($this, $where)) { $this->check->showError(); } if (!$this->check->checkUpdate($this, array("id<>'{$this->R['id']}'", "name='{$this->R['name']}'"))) { $this->check->showError(); } $updateData = $this->getRequest()->filter($this->fields); $updateData['nav'] = implode(',', $updateData['nav']); return parent::update($where, $updateData); }
public function update($keyvalue, $conditions) { parent::update($keyvalue, $conditions); #------记录日志(生成msg)-------# $logArr = array(); array_push($logArr, '修改了一条FAQ分类'); array_push($logArr, "修改FAQ分类名称[{$keyvalue['name']}]"); array_push($logArr, "FAQ分类ID [{$conditions}]"); $msg = Tools::formatLog($logArr); Tools::addLog($msg, true); return true; #------记录日志(生成msg)-------# }
function website() { global $db; //判断是否登陆 !isset($_SESSION['user']) && exit('Please login!'); if (isset($_POST['edit'])) { $Model = new Model('website_info'); $rs = $Model->update(); $Model->msg($rs, '修改网站信息成功!', '修改网站信息失败!'); } $rs_website = $db->row_query_one("SELECT * FROM website_info"); tpl('website', 'rs_website', $rs_website); }
public function selected() { $_where = array("user='******'user']}'"); $_updateData['selected'] = 0; parent::update($_where, $_updateData); if (isset($_GET['id'])) { $_where = array("id='{$this->_R['id']}'"); } else { $_id = $this->select(array('id'), array('limit' => '1', 'order' => 'id DESC', 'where' => array("user='******'user']}'"))); $_where = array("user='******'user']}'", "id='{$_id[0]->id}'"); } $_updateData['selected'] = 1; return parent::update($_where, $_updateData); }
/** * Сохраняет данные * @return bool|int */ public function save() { //Если был прочитан из базы if (isset($this->_row->id) && count($this->_row_update) > 0) { $update = array(); //Собираем массив foreach ($this->_row_update as $column) { $update[$column] = $this->_row->{$column}; } //Обновляем $result = $this->_model_instance->update($update, "id = " . $this->_row->id); $this->_row_update = array(); return $result; } return false; }
/** * Save values in the *_field_values table * @param array $params Structured array with the values to save * @param boolean $show_query Whether to show the insert query (passed to the parent save() method) * @result mixed The result sent from the parent method * @assert (array()) === false */ public function save($params, $show_query = false) { $extra_field = $this->getExtraField(); // Setting value to insert. $value = $params['value']; $value_to_insert = null; if (is_array($value)) { $value_to_insert = implode(';', $value); } else { $value_to_insert = Database::escape_string($value); } $params['value'] = $value_to_insert; // If field id exists if (isset($params['field_id'])) { $extraFieldInfo = $extra_field->get($params['field_id']); } else { // Try the variable $extraFieldInfo = $extra_field->get_handler_field_info_by_field_variable($params['variable']); $params['field_id'] = $extraFieldInfo['id']; } if ($extraFieldInfo) { switch ($extraFieldInfo['field_type']) { case ExtraField::FIELD_TYPE_RADIO: case ExtraField::FIELD_TYPE_SELECT: break; case ExtraField::FIELD_TYPE_SELECT_MULTIPLE: //$field_options = $session_field_option->get_field_options_by_field($params['field_id']); //$params['field_value'] = split(';', $value_to_insert); /* if ($field_options) { $check = false; foreach ($field_options as $option) { if (in_array($option['option_value'], $values)) { $check = true; break; } } if (!$check) { return false; //option value not found } } else { return false; //enumerated type but no option found }*/ break; case ExtraField::FIELD_TYPE_TEXT: case ExtraField::FIELD_TYPE_TEXTAREA: break; case ExtraField::FIELD_TYPE_DOUBLE_SELECT: if (is_array($value)) { if (isset($value['extra_' . $extraFieldInfo['variable']]) && isset($value['extra_' . $extraFieldInfo['variable'] . '_second'])) { $value_to_insert = $value['extra_' . $extraFieldInfo['variable']] . '::' . $value['extra_' . $extraFieldInfo['variable'] . '_second']; } else { $value_to_insert = null; } } break; default: break; } if ($extraFieldInfo['field_type'] == ExtraField::FIELD_TYPE_TAG) { $field_values = self::getAllValuesByItemAndFieldAndValue($params['item_id'], $params['field_id'], $value); } else { $field_values = self::get_values_by_handler_and_field_id($params['item_id'], $params['field_id']); } $params['value'] = $value_to_insert; $params['author_id'] = api_get_user_id(); // Insert if (empty($field_values)) { /* Enable this when field_loggeable is introduced as a table field (2.0) if ($extraFieldInfo['field_loggeable'] == 1) { */ if (false) { global $app; switch ($this->type) { case 'question': $extraFieldValue = new ChamiloLMS\Entity\QuestionFieldValues(); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setQuestionId($params[$this->handler_id]); break; case 'course': $extraFieldValue = new ChamiloLMS\Entity\CourseFieldValues(); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setQuestionId($params[$this->handler_id]); break; case 'user': $extraFieldValue = new ChamiloLMS\Entity\UserFieldValues(); $extraFieldValue->setUserId($params[$this->handler_id]); $extraFieldValue->setAuthorId(api_get_user_id()); break; case 'session': $extraFieldValue = new ChamiloLMS\Entity\SessionFieldValues(); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setSessionId($params[$this->handler_id]); break; } if (isset($extraFieldValue)) { if (!empty($params['value'])) { $extraFieldValue->setComment($params['comment']); $extraFieldValue->setFieldValue($params['value']); $extraFieldValue->setFieldId($params['field_id']); $extraFieldValue->setTms(api_get_utc_datetime(null, false, true)); $app['orm.ems']['db_write']->persist($extraFieldValue); $app['orm.ems']['db_write']->flush(); } } } else { if ($extraFieldInfo['field_type'] == ExtraField::FIELD_TYPE_TAG) { $option = new ExtraFieldOption($this->type); $optionExists = $option->get($params['value']); if (empty($optionExists)) { $optionParams = array('field_id' => $params['field_id'], 'option_value' => $params['value']); $optionId = $option->saveOptions($optionParams); } else { $optionId = $optionExists['id']; } $params['value'] = $optionId; if ($optionId) { return parent::save($params, $show_query); } } else { return parent::save($params, $show_query); } } } else { // Update /* Enable this when field_loggeable is introduced as a table field (2.0) if ($extraFieldInfo['field_loggeable'] == 1) { */ if (false) { global $app; switch ($this->type) { case 'question': $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\\Entity\\QuestionFieldValues')->find($field_values['id']); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setQuestionId($params[$this->handler_id]); break; case 'course': $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\\Entity\\CourseFieldValues')->find($field_values['id']); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setCourseCode($params[$this->handler_id]); break; case 'user': $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\\Entity\\UserFieldValues')->find($field_values['id']); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setAuthorId(api_get_user_id()); break; case 'session': $extraFieldValue = $app['orm.ems']['db_write']->getRepository('ChamiloLMS\\Entity\\SessionFieldValues')->find($field_values['id']); $extraFieldValue->setUserId(api_get_user_id()); $extraFieldValue->setSessionId($params[$this->handler_id]); break; } if (isset($extraFieldValue)) { if (!empty($params['value'])) { /* * If the field value is similar to the previous value then the comment will be the same in order to no save in the log an empty record */ if ($extraFieldValue->getFieldValue() == $params['value']) { if (empty($params['comment'])) { $params['comment'] = $extraFieldValue->getComment(); } } $extraFieldValue->setComment($params['comment']); $extraFieldValue->setFieldValue($params['value']); $extraFieldValue->setFieldId($params['field_id']); $extraFieldValue->setTms(api_get_utc_datetime(null, false, true)); $app['orm.ems']['db_write']->persist($extraFieldValue); $app['orm.ems']['db_write']->flush(); } } } else { $params['id'] = $field_values['id']; return parent::update($params, $show_query); } } } }
/** * @inheritdoc */ public function update($values) { $values['updated_on'] = api_get_utc_datetime(); $values['group_type'] = isset($values['group_type']) ? self::SOCIAL_CLASS : self::NORMAL_CLASS; if (isset($values['id'])) { $picture = isset($_FILES['picture']) ? $_FILES['picture'] : null; if (!empty($picture)) { $picture = $this->manageFileUpload($values['id'], $picture); if ($picture) { $values['picture'] = $picture; } } if (isset($values['delete_picture'])) { $values['picture'] = null; } } parent::update($values); if (isset($values['delete_picture'])) { $this->delete_group_picture($values['id']); } return true; }
if (isset($_POST['submit'])) { for ($i = 1; $i <= $_POST['total_session']; $i++) { if ($_POST['trainer1_' . "{$i}"] == "Select Trainer 1" && $_POST['trainer2_' . "{$i}"] == "Select Trainer 2") { $tablename = 'session_entry'; $set_value = "trainer_1='', trainer_2=''"; $condition = "session_no='" . $_POST['session_no_' . "{$i}"] . "' and batch_id='" . $_POST['batch_id_' . "{$i}"] . "' and name_of_erp_course='" . $_POST['erp_course_' . "{$i}"] . "'"; $result = Model::update($tablename, $set_value, $condition); if ($result) { if ($_POST['user_type'] == 'tc/tp') { header('location:assign_trainer1.php'); } else { header('location:assign_trainer.php'); } } } else { $trainer_1 = explode('_', $_POST['trainer1_' . "{$i}"]); $trainer_2 = explode('_', $_POST['trainer2_' . "{$i}"]); $tablename = 'session_entry'; $set_value = "trainer_1='{$trainer_1['0']}', trainer_2='{$trainer_2['0']}', amount_term='" . $_POST['amount_term_' . "{$i}"] . "'"; $condition = "session_no='" . $_POST['session_no_' . "{$i}"] . "' and batch_id='" . $_POST['batch_id_' . "{$i}"] . "' and name_of_erp_course='" . $_POST['erp_course_' . "{$i}"] . "'"; $result = Model::update($tablename, $set_value, $condition); if ($result) { if ($_POST['user_type'] == 'tc/tp') { header('location:assign_trainer1.php'); } else { header('location:assign_trainer.php'); } } } } }
public function update($where, $data) { return parent::update($where, $data); }
public function update($params) { $params = self::clean_parameters($params); if (isset($params['id'])) { $field_option = new ExtraFieldOption($this->type); $params['field_id'] = $params['id']; $field_option->save($params); } parent::update($params); }
public function setLoginDetails($userid) { $where = array("user='******'user']}'"); if (isset($_POST['keep'])) { setcookie('user', $this->R['user'], time() + 604800); setcookie('userid', $userid, time() + 604800); } else { setcookie('user', $this->R['user']); setcookie('userid', $userid); } $updateData['last_ip'] = Tool::getIP(); $updateData['login_time'] = Tool::getDate(); parent::update($where, $updateData); }
/** * 更新等级信息 * * @param int $id * @param array $setdata * @return bool */ public function updateLevel($level, $exp) { $where = $this->getAdapter()->bind('level=?', $level); return parent::update(array('exp' => intval($exp)), $where); }
public function update() { $where = array("id='{$this->R['id']}'"); $updateData = $this->getRequest()->filter($this->fields); if ($this->R['is_record'] == 0 && $this->R['order_delivery'] == '已发货') { $this->tables = array(DB_FREFIX . 'record'); foreach ($_POST['goods_id'] as $key => $value) { $recordDate['goods_id'] = $value; $recordDate['user'] = $_POST['user']; $recordDate['name'] = $_POST['goods_name'][$value]; $recordDate['num'] = $_POST['goods_num'][$value]; $recordDate['attr'] = $_POST['goods_attr'][$value]; $recordDate['price'] = $_POST['goods_price_sale'][$value]; $recordDate['date'] = tool::getDate(); parent::add($recordDate); } } if ($this->R['order_state'] == '已取消' || $this->R['refund'] == 2) { $order_goods = parent::select(array('id', 'goods'), array('where' => $where)); $goods = unserialize(htmlspecialchars_decode($order_goods[0]->goods)); $this->tables = array(DB_FREFIX . 'goods'); foreach ($goods as $key => $value) { $value = unserialize($value); parent::update(array("id='{$key}'"), array('inventory' => array('inventory+' . $value[num]), 'sale_count' => array('sale_count-' . $value[num]))); } } $this->tables = array(DB_FREFIX . 'order'); $updateData['is_record'] = 1; return parent::update($where, $updateData); }
public static function update($params) { if (self::checkReverseComplement($params)) { throw new Exception('Food Complement already exists'); } return parent::update($params); }
function update($data, Criteria $c) { parent::update($data, $c); Cacher::getInstance()->clean("tag", array("user")); }
/** * Overrides update to remove PK checking when performing an update. */ public function update() { static::disable_primary_key_check(); $result = parent::update(); static::enable_primary_key_check(); return $result; }