/**
* @brief 发送信件
*/
function message_send()
{
$where = ' 1 ';
$tb_user_group = new IModel('user_group');
$tb_user = new IModel('user');
$data_group = $tb_user_group->query();
$data_group = is_array($data_group) ? $data_group : array();
$group = array();
foreach ($data_group as $value) {
$group[$value['id']] = $value['group_name'];
}
$and = ' and ';
$where = '`status`="1"' . $and;
$group_key = IFilter::act(IReq::get('group_key', 'post'), 'string');
$group_v = IFilter::act(IReq::get('group_value', 'post'), 'int');
if ($group_key && $group_v) {
if ($group_key == 'eq') {
$where .= "group_id='{$group_v}' {$and}";
} else {
$where .= "group_id!='{$group_v}' {$and} ";
}
}
$truename_key = IFilter::string(IReq::get('truename_key', 'post'));
$truename_v = IFilter::act(IReq::get('truename_value', 'post'), 'string');
if ($truename_key && $truename_v) {
if ($truename_key == 'eq') {
$where .= "true_name='{$truename_v}' {$and}";
} else {
$where .= 'true_name like "%' . $truename_v . '%"' . $and;
}
}
$mobile_key = IFilter::string(IReq::get('mobile_key', 'post'));
$mobile_v = IFilter::act(IReq::get('mobile_value', 'post'), 'string');
if ($mobile_key && $mobile_v) {
if ($mobile_key == 'eq') {
$where .= "mobile='{$mobile_v}' {$and} ";
} else {
$where .= 'mobile like "%' . $mobile_v . '%"' . $and;
}
}
$telephone_key = IFilter::string(IReq::get('telephone_key', 'post'));
$telephone_v = IFilter::act(IReq::get('telephone_value', 'post'), 'string');
if ($telephone_key && $telephone_v) {
if ($telephone_key == 'eq') {
$where .= "telephone='{$telephone_v}' {$and} ";
} else {
$where .= 'telephone like "%' . $telephone_v . '%"' . $and;
}
}
$username_key = IFilter::string(IReq::get('username_key', 'post'));
$username_v = IFilter::act(IReq::get('username_value', 'post'), 'string');
$user_ids = array();
if ($username_key && $username_v) {
if ($username_key == 'eq') {
$sql = "username='******' ";
} else {
$sql = 'username like "%' . $username_v . '%"';
}
$tmp = $tb_user->query($sql);
if ($tmp) {
foreach ($tmp as $value) {
$user_ids[] = $value['id'];
}
}
}
$email_key = IFilter::string(IReq::get('email_key', 'post'));
$email_v = IFilter::act(IReq::get('email_value', 'post'), 'string');
if ($email_key && $email_v) {
if ($email_key == 'eq') {
$sql = "email='{$email_v}' ";
} else {
$sql = 'email like "%' . $email_v . '%"';
}
$tmp = $tb_user->query($sql);
if ($tmp) {
foreach ($tmp as $value) {
$user_ids[] = $value['id'];
}
}
}
if ($user_ids) {
$where .= "user_id IN (" . implode(',', $user_ids) . ") {$and}";
}
$zip_key = IFilter::string(IReq::get('zip_key', 'post'));
$zip_v = IFilter::act(IReq::get('zip_value', 'post'), 'string');
if ($zip_key && $zip_v) {
if ($zip_key == 'eq') {
$where .= "zip='{$zip_v}' {$and} ";
} else {
$where .= 'zip like "%' . $zip_v . '%"' . $and;
}
}
$sex = intval(IReq::get('sex', 'post'));
if ($sex && $sex != '-1') {
$where .= 'sex=' . $sex . $and;
}
$point_key = IFilter::string(IReq::get('point_key', 'post'));
$point_v = intval(IReq::get('point_value', 'post'));
if ($point_key && $point_v) {
if ($point_key == 'eq') {
$where .= 'point= "' . $point_v . '"' . $and;
} elseif ($point_key == 'gt') {
$where .= 'point > "' . $point_v . '"' . $and;
} else {
$where .= 'point < "' . $point_v . '"' . $and;
}
}
$regtimeBegin = IFilter::string(IReq::get('regtimeBegin', 'post'));
if ($regtimeBegin) {
$where .= '`time` > "' . $regtimeBegin . '"' . $and;
}
$regtimeEnd = IFilter::string(IReq::get('regtimeEnd', 'post'));
if ($regtimeEnd) {
$where .= '`time` < "' . $regtimeEnd . '"' . $and;
}
$where .= ' 1 ';
$content = array();
$content['title'] = IReq::get('title');
$content['content'] = IReq::get('content');
Mess::sendToUser($where, $content);
$this->message_list();
Util::showMessage("站内消息群发成功");
}
/**
* @brief 发送信件
*/
function start_message()
{
$toUser = IFilter::act(IReq::get('toUser'));
$title = IFilter::act(IReq::get('title'));
$content = IFilter::act(IReq::get('content'));
if (!$title || !$content) {
die('<script type="text/javascript">parent.startMessageCallback(0);</script>');
}
Mess::sendToUser($toUser, array('title' => $title, 'content' => $content));
die('<script type="text/javascript">parent.startMessageCallback(1);</script>');
}
