public function getSearchCount($where = array()) { $white_list = array('productCatId', 'productCatId2'); $where = DBHelp::getWhiteItem($where, $white_list); $condition = DBHelp::buildWhere($where); $sql = "select count(0) from {tbname} where {$condition} "; return $this->mScoreDetail->getSingle($sql, $where); }
/** * 审核文件 * @param 参数 * @return bool */ public function auditSave($params) { $white_list = array('id', 'isAudit', 'reason'); $binds = DBHelp::getWhiteItem($params, $white_list, false); $time = time(); $sql = "update {tbname} set isAudit=:isAudit,auditTime='{$time}',reason=:reason where id=:id "; return $this->mPushFile->update($sql, $binds); }
public function getSearchCount($push_id, $where) { $white_list = array(); $where = DBHelp::getWhiteItem($where, $white_list); $condition = DBHelp::buildWhere($where); $sql = "select count(0) from {tbname} where pushId='{$push_id}' and {$condition} "; return $this->mPushDetail->getSingle($sql, $where); }
public function EditSave($member_id, $params) { $white_list = array('truename', 'qq', 'weixin', 'mobile', 'email', 'companyName', 'productCatId', 'productCatId2', 'status', 'reason', 'defineCatName', 'totalScore'); $params = DBHelp::getWhiteItem($params, $white_list); return $this->mMembers->update("update {$this->mMembers->tbname} set" . DBHelpbuildUpData($params) . " where id='{$member_id}'", $params); }