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);
}