/**
* 更新关注数
* @param $id
* @return bool
*/
public static function updateFollows($id)
{
$sql = 'UPDATE question_answer SET answer_follows = (SELECT COUNT(*) FROM question_answer_follow WHERE answer_id=question_answer.answer_id) WHERE answer_id = :aid';
$model = new self();
return $model->getWriteConnection()->execute($sql, ['aid' => $id]);
}
/**
* 更新回答数
* @param $id
* @return bool
*/
public static function updateAnswerNum($id)
{
$sql = 'UPDATE question SET answer_num = (SELECT COUNT(*) FROM question_answer WHERE question_id=question.question_id AND answer_state > 0) WHERE question_id = :qid';
$model = new self();
return $model->getWriteConnection()->execute($sql, ['qid' => $id]);
}
public static function updateAssist($id)
{
$sql = 'UPDATE beauty_canon SET assist = (SELECT COUNT(*) FROM cos_beauty_canon_assist WHERE beauty_canon_id=beauty_canon.id) WHERE id = :bc_id';
$model = new self();
return $model->getWriteConnection()->execute($sql, ['bc_id' => $id]);
}
/**
* 设置订单状态
* @param $userId
* @param $orderId
* @param $state
* @return bool
*/
public static function SetOrderState($userId, $orderId, $state)
{
$sql = 'UPDATE user_order SET order_state = :state WHERE order_id = :id AND user_id = :uid';
$model = new self();
return $model->getWriteConnection()->execute($sql, ['state' => $state, 'id' => $orderId, 'uid' => $userId]);
}
/**
* 设置密码
* @param $mobile
* @param $password
* @return bool
*/
public static function SetPassword($mobile, $password)
{
$sql = 'UPDATE user_base SET user_password = :pwd WHERE user_account = :mobile';
$model = new self();
return $model->getWriteConnection()->execute($sql, ['pwd' => $password, 'mobile' => $mobile]);
}
/**
* 设置返回值
* @param $id
* @param $response
*/
public static function setResponse($id, $response)
{
$model = new self();
$sql = 'UPDATE ' . $model->getSource() . ' SET resp_content = :resp, resp_time = NOW() WHERE id = :id';
$model->getWriteConnection()->execute($sql, ['id' => $id, 'resp' => $response]);
}
