public static function unpublish($id)
{
$id = Typo::int($id);
$ins = array('table' => 'posts', 'id' => $id, 'key' => array('status' => '0'));
$post = Db::update($ins);
return $post;
}
function reset_keywords($new_kws_str, $type = 'equal')
{
$ks = $this->keywords();
$old_kws = array();
foreach ($ks as $k) {
$old_kws[] = $k->keyword;
}
$ps = explode(',', $new_kws_str);
$kws = array();
foreach ($ps as $p) {
$p = trim($p);
if (strlen($p)) {
$kws[$p] = $p;
}
}
$to_del = array_diff($old_kws, $kws);
foreach ($to_del as $k) {
Db::escape($k);
$sql = "delete from wx_reply_keywords where item_id='{$this->id}' and keyword='{$k}'";
Db::query($sql);
}
$to_add = array_diff($kws, $old_kws);
foreach ($to_add as $k) {
WxReplyKeyword::save(array('type' => $type, 'keyword' => $k, 'item_id' => $this->id));
}
$sql = "update " . WxReplyKeyword::table() . " set type='{$type}' where item_id='{$this->id}'";
Db::update($sql);
}
public static function update()
{
$post = Input::post(array('sitename', 'description', 'theme', 'twitter', 'home_page', 'posts_page'));
$errors = array();
if (empty($post['sitename'])) {
$errors[] = 'You need a site sitename';
}
if (empty($post['description'])) {
$errors[] = 'You need a site description';
}
if (empty($post['theme'])) {
$errors[] = 'You need a theme';
}
if (count($errors)) {
Notifications::set('error', $errors);
return false;
}
$post['sitename'] = htmlentities($post['sitename']);
$post['description'] = htmlentities($post['description']);
foreach ($post as $key => $value) {
Db::update('meta', array('value' => $value), array('key' => $key));
}
Notifications::set('success', 'Your metadata has been updated');
return true;
}
/**
* @return integer
*/
public function put()
{
if (null === $this->identifier) {
throw new Exception('Identifier not found.');
}
$fields = array();
$update = $this->properties[$this->identifier]->has();
$return = 0;
foreach ($this->properties as $name => $instance) {
if (!is_subclass_of($instance, 'Property')) {
continue;
}
if ($instance instanceof PropertyIdentifier) {
continue;
}
$fields[$name] = $instance->get();
}
if ($update) {
$return = $affected = $this->db->update($this->table, $fields, array($this->identifier => $this->properties[$this->identifier]->get()));
} else {
$return = $inserted = $this->db->insert($this->table, $fields);
if ($inserted) {
$this->properties[$this->identifier]->set($inserted);
}
}
$this->hash = Model::hash($this->properties);
return $return;
}
/**
* 更新信息
*
* @param array $param 更新数据
* @return bool 布尔类型的返回结果
*/
public function updateSetting($param)
{
if (empty($param)) {
return false;
}
/**
* 因为是数值更新，所以需要循环数组
*/
if (is_array($param)) {
foreach ($param as $k => $v) {
$tmp = array();
$specialkeys_arr = array('statistics_code', 'qq_appcode', 'share_qqzone_appcode', 'share_sinaweibo_appcode');
$tmp['value'] = in_array($k, $specialkeys_arr) ? htmlentities($v, ENT_QUOTES) : $v;
$where = " name = '" . $k . "'";
$result = Db::update('setting', $tmp, $where);
if ($result !== true) {
return $result;
}
}
@unlink(BasePath . DS . 'cache' . DS . 'setting.php');
return true;
} else {
return false;
}
}
public static function update()
{
$post = Input::post(array('sitename', 'description', 'theme', 'twitter', 'home_page', 'posts_page', 'auto_published_comments', 'posts_per_page'));
$errors = array();
if (empty($post['sitename'])) {
$errors[] = 'You need a site sitename';
}
if (empty($post['description'])) {
$errors[] = 'You need a site description';
}
if (empty($post['theme'])) {
$errors[] = 'You need a theme';
}
// auto publish comments
$post['auto_published_comments'] = $post['auto_published_comments'] ? 1 : 0;
// format posts per page, must be a whole number above 1 defaults to 10 if a invalid number is entered
$post['posts_per_page'] = ($posts_per_page = intval($post['posts_per_page'])) > 0 ? $posts_per_page : 10;
if (count($errors)) {
Notifications::set('error', $errors);
return false;
}
foreach ($post as $key => $value) {
Db::update('meta', array('value' => $value), array('key' => $key));
}
Notifications::set('success', 'Your metadata has been updated');
return true;
}
/**
* 更新购物车
*
* @param array $param 商品信息
*/
public function updateCart($param, $condition)
{
$array = array();
//得到条件语句
$condition_str = $this->getCondition($condition);
$result = Db::update('cart', $param, $condition_str);
return $result;
}
public function update()
{
if (empty($this->id)) {
throw new Exception('Update error - Undefined photo id');
}
return Db::update('UPDATE photo SET quarter_id = :quarter_id, src = :src, info_id = :info_id, user_id = :user_id
WHERE id = :id', array('quarter_id' => $this->quarter_id, 'src' => $this->src, 'info_id' => $this->info_id, 'user_id' => $this->user_id, 'id' => (int) $this->id));
}
/**
* 更新统计表
*
* @param array $param 条件数组
*/
public function updatestat($param)
{
if (empty($param)) {
return false;
}
$result = Db::update($param['table'], array($param['field'] => array('sign' => 'increase', 'value' => $param['value'])), $param['where']);
return $result;
}
/**
* 更新动态记录
* @param array $param 修改信息数组
* @param array $condition 条件数组
*/
public function tracelogEdit($param,$condition){
if(empty($param)) {
return false;
}
//得到条件语句
$condition_str = $this->getCondition($condition);
$result = Db::update('sns_tracelog',$param,$condition_str);
return $result;
}
public function save()
{
$params = json_encode($this->settings);
$updateQuery = 'UPDATE jos_extensions SET params = ? WHERE `type`=\'component\' AND `element` = \'com_hubgraph\'';
$insertQuery = 'INSERT INTO jos_extensions(name, `type`, `element`, params) VALUES (\'HubGraph\', \'component\', \'com_hubgraph\', ?)';
if (!Db::update($updateQuery, array($params))) {
Db::execute($insertQuery, array($params));
}
}
/**
* 更新分享店铺信息
* @param $param 更新内容
* @param $condition 更新条件
*/
public function editSharestore($param,$condition) {
if(empty($param)) {
return false;
}
//得到条件语句
$condition_str = $this->getCondition($condition);
$result = Db::update('sns_sharestore',$param,$condition_str);
return $result;
}
/**
* 直通车申请信息修改
*
* @param array $param 修改信息数组
* @param int $ztc_id 团购商品id
*/
public function updateZtcOne($param, $condition)
{
if (empty($param)) {
return false;
}
//得到条件语句
$condition_str = $this->getCondition($condition);
$result = Db::update('ztc_goods', $param, $condition_str);
return $result;
}
public function update()
{
$values = $this->values;
if (!isset($values['id'])) {
return false;
}
$id = $values['id'];
unset($values['id']);
return Db::update($this->table, $values, array($this->index => $id));
}
/**
* 更新商品评分信息
*/
public function editGoodsEval($param, $condition)
{
if (empty($param)) {
return false;
}
//得到条件语句
$condition_str = $this->getGoodsEvalCondition($condition);
$result = Db::update('evaluate_goods', $param, $condition_str);
return $result;
}
/**
* 更新充值卡使用状态
*
*/
public function updateCard($param, $card_id)
{
if (empty($param)) {
return false;
}
$update = false;
//得到条件语句
$where = 'card_id=' . $card_id;
$update = Db::update('pd_gift_card', $param, $where);
return $update;
}
/**
* 商品信息更新
*
* @param array $param 列表条件
* @param int $goods_id 商品id
*/
public function updateDemand($param, $goods_id)
{
if (empty($param)) {
return false;
}
$update = false;
if (is_array($goods_id)) {
$goods_id = implode(',', $goods_id);
}
//得到条件语句
$condition_str = "WHERE demand_id in(" . $goods_id . ")";
$update = Db::update('demand', $param, $condition_str);
return $update;
}
public static function end()
{
// cookie details
$name = Config::get('session.name', 'anchorcms');
$expire = time() + Config::get('session.expire', 86400);
$path = Config::get('session.path', '/');
$domain = Config::get('session.domain', '');
// update db session
Db::update('sessions', array('date' => date(DATE_ISO8601), 'ip' => Input::ip_address(), 'ua' => Input::user_agent(), 'data' => serialize(static::$data)), array('id' => static::$id));
// create cookie with ID
if (!Cookie::write($name, static::$id, $expire, $path, $domain)) {
Log::error('Could not write session cookie: ' . static::$id);
}
}
public function changeName()
{
$Verify = new Verify();
$first = trim(strip_tags($_POST['first']));
$middle = trim(strip_tags($_POST['middle']));
$last = trim(strip_tags($_POST['last']));
if (!$Verify->length($first, 255)) {
$_SESSION['alert'] = 'Your first name is too long to store in the database.';
} elseif (!$Verify->length($middle, 255)) {
$_SESSION['alert'] = 'Your middle name is too long to store in the database.';
} elseif (!$Verify->length($last, 255)) {
$_SESSION['alert'] = 'Your last name is too long to store in the database.';
} else {
$Db = new Db();
$query = $Db->query('user_name', array(array('user_id', '=', $_SESSION['user'], '')));
$numrows = mysqli_num_rows($query);
if ($numrows != 1) {
$_SESSION['alert'] = 'Error, please try again.';
} else {
while ($row = mysqli_fetch_assoc($query)) {
if ($first == '') {
$first = $row['first'];
}
if ($middle == '') {
$middle = $row['middle'];
}
if ($last == '') {
$last = $row['last'];
}
}
$updateFirst = $Db->update('user_name', array('first', '=', $first), array(array('user_id', '=', $_SESSION['user'], '')));
if (!$updateFirst) {
$_SESSION['alert'] = 'Error, could not completely update name.';
} else {
$updateMiddle = $Db->update('user_name', array('middle', '=', $middle), array(array('user_id', '=', $_SESSION['user'], '')));
if (!$updateMiddle) {
$_SESSION['alert'] = 'Error, could not completely update name.';
} else {
$updateLast = $Db->update('user_name', array('last', '=', $last), array(array('user_id', '=', $_SESSION['user'], '')));
if (!$updateLast) {
$_SESSION['alert'] = 'Error, could not completely update name.';
} else {
$_SESSION['alert'] = 'Your name has been updated.';
}
}
}
}
}
}
/**
* 更新信息
*
* @param
* @return bool 布尔类型的返回结果
*/
public function update($condition, $param)
{
$map_id = $condition['map_id'];
if (intval($map_id) < 1) {
return false;
}
$condition_str = $this->getCondition($condition);
$where = $condition_str;
if (is_array($param)) {
$result = Db::update('map', $param, $where);
return result;
} else {
return false;
}
}
public function post()
{
$nombres = array('title', 'keywords', 'description');
$title = Request::getPost('title', $this->title);
$keywords = Request::getPost('keywords', $this->keywords);
$description = Request::getPost('description', $this->description);
foreach ($nombres as $nombre) {
if (null === $this->{$nombre}) {
Db::insert('configuracion', array('idioma' => $this->idioma, 'nombre' => $nombre, 'valor' => ${$nombre}));
} else {
Db::update('configuracion', array('idioma' => $this->idioma, 'valor' => ${$nombre}), array('nombre' => $nombre));
}
}
return "/admin/configuracion/{$this->idioma}?edited=1";
}
/**
* 更新水印
*
* @param array $param 更新数据
* @return bool 布尔类型的返回结果
*/
public function updateStoreWM($param){
if (empty($param)){
return false;
}
if (is_array($param)){
$tmp = array();
foreach ($param as $k => $v){
$tmp[$k] = $v;
}
$where = " wm_id = '". $param['wm_id'] ."'";
$result = Db::update('store_watermark',$tmp,$where);
return $result;
}else {
return false;
}
}
public function insertNews($url, $find_elm, $date)
{
$db = new Db();
$content = file_get_html($url);
foreach ($content->find($find_elm) as $news) {
if (!empty($news)) {
$db->insert('news', array('title' => $news->plaintext, 'date' => $date, 'last_update' => date('Y-m-d'), 'news_type' => static::$newsType));
}
}
$settings = $db->query('SELECT * FROM settings WHERE news_type="' . static::$newsType . '"');
if (!is_array($settings)) {
$db->insert('settings', array('news_type' => static::$newsType, 'last_update' => date('Y-m-d')));
} else {
$db->update('settings', array('last_update' => date('Y-m-d')), array('news_type' => static::$newsType));
}
}
/**
* 更新模板内容
*
* @param array $param 更新参数
* @return bool 布尔类型的返回结果
*/
public function update($param)
{
if (empty($param)) {
return false;
}
if (is_array($param)) {
$tmp = array();
foreach ($param as $k => $v) {
$tmp[$k] = $v;
}
$where = " code = '" . $param['code'] . "'";
$result = Db::update('mail_msg_temlates', $tmp, $where);
return $result;
} else {
return false;
}
}
/**
* 更新
*
* @param array $param 更新数据
* @return bool 布尔类型的返回结果
*/
public function edit($param)
{
if (empty($param)) {
return false;
}
if (is_array($param)) {
$tmp = array();
foreach ($param as $k => $v) {
$tmp[$k] = $v;
}
$where = " theme_name = '" . $param['theme_name'] . "' and module_name='" . $param['module_name'] . "' ";
$result = Db::update('store_theme', $tmp, $where);
return $result;
} else {
return false;
}
}
public function update($param)
{
if (empty($param)) {
return false;
}
if (is_array($param)) {
$tmp = array();
foreach ($param as $k => $v) {
$tmp[$k] = $v;
}
$where = " view_detail_id = '" . $param['view_detail_id'] . "'";
$result = Db::update('view_detail', $tmp, $where);
return $result;
} else {
return false;
}
}
/**
* 更新规格信息
* @param array $update 更新数据
* @param array $param 条件
* @param string $table 表名
* @return bool
*/
public function specUpdate($update, $param, $table)
{
$condition_str = $this->getCondition($param);
if (empty($update)) {
return false;
}
if (is_array($update)) {
$tmp = array();
foreach ($update as $k => $v) {
$tmp[$k] = $v;
}
$result = Db::update($table, $tmp, $condition_str);
return $result;
} else {
return false;
}
}
public function submit()
{
if (Request::hasPost('guardar')) {
list($this->validationFlag, $this->validation) = Validation::check(array('nombre' => 'required', 'apellido' => 'required'));
if ($this->validationFlag) {
$nombre = Request::getPost('nombre');
$apellido = Request::getPost('apellido');
$correo = Request::getPost('correo');
$cargo = Request::getPost('cargo');
$telOficina = Request::getPost('tel_oficina');
$telOficinaInt = Request::getPost('tel_oficina_int');
$telCelular = Request::getPost('tel_celular');
$telFax = Request::getPost('tel_fax');
$telCasa = Request::getPost('tel_casa');
Db::update('personas', array('nombre' => $nombre, 'apellido' => $apellido, 'correo' => $correo, 'cargo' => $cargo, 'tel_oficina' => $telOficina, 'tel_oficina_int' => $telOficinaInt, 'tel_celular' => $telCelular, 'tel_fax' => $telFax, 'tel_casa' => $telCasa, 'fecha_modificacion' => time()), "id_personas = '{$this->idPersonas}'");
Response::setRedirect("/personas/{$this->idPersonas}");
}
}
}
public function update($id, $properties)
{
foreach ($properties as $key => $value) {
if ($key == 'login') {
if (trim($value) == '') {
return false;
}
if ($this->loginExists($value, $id)) {
return false;
}
}
if ($key == 'password') {
if (trim($value) == '') {
return false;
}
$properties[$key] = Auth::getPasswordHash()->HashPassword(trim($value));
}
}
return Db::update("users", $properties, "`id` = :id", array(':id' => $id));
}
public function submit()
{
if (Request::hasPost('guardar')) {
list($this->validationFlag, $this->validation) = Validation::check(array('nombre' => 'required'));
if ($this->validationFlag) {
$nombre = Request::getPost('nombre');
$direccion1 = Request::getPost('direccion_1');
$direccion2 = Request::getPost('direccion_2');
$ciudad = Request::getPost('ciudad');
$estado = Request::getPost('estado');
$codPostal = Request::getPost('cod_postal');
$idPaises = Request::getPost('id_paises');
$web = Request::getPost('web');
$telOficina = Request::getPost('tel_oficina');
$telFax = Request::getPost('tel_fax');
Db::update('empresas', array('nombre' => $nombre, 'direccion_1' => $direccion1, 'direccion_2' => $direccion2, 'ciudad' => $ciudad, 'estado' => $estado, 'cod_postal' => $codPostal, 'id_paises' => $idPaises, 'web' => $web, 'tel_oficina' => $telOficina, 'tel_fax' => $telFax, 'fecha_modificacion' => time()), "id_empresas = '{$this->idEmpresas}'");
Response::setRedirect("/empresas/{$this->idEmpresas}");
}
}
}
