<?php
// Copyright 2015 The Haohaoxiuche Team Authors. All right reserved.
// Use of this source that is governed by a Apache-style
// license that can be found in the LICENSE file.
//
// 技術版API編號098 綁定手機號 ##參考015和096
//
// @authors hjboss <*****@*****.**> 2015-12-18#
// @version 1.0.0
// @package hhxc
if (!defined('HHXC')) {
die('Permission denied');
}
if (CheckOpenID($params['openid'], $params['uid']) == FALSE) {
$result['msg'] = '电话号码已注册！';
} else {
$fields = array('username_d' => Assign($params[KEY_PHONE]), 'password' => Assign($params['pwd']));
$num = StorageEditByID('hh_techuser', $fields, $params['uid']);
if ($num <= 0) {
$result['msg'] = '绑定失败！';
} else {
$result = array('code' => '101', 'msg' => '绑定成功！');
}
}
<?php
// Copyright 2015 The Haohaoxiuche Team Authors. All right reserved.
// Use of this source that is governed by a Apache-style
// license that can be found in the LICENSE file.
//
// 技術版API編號075 提交案例評分
//
// @authors hjboss <*****@*****.**> 2015-12-18#
// @version 1.0.0
// @package hhxc
if (!defined('HHXC')) {
die('Permission denied');
}
if (CheckOpenID($params['openid'], $params['uid']) == FALSE) {
$result['msg'] = MESSAGE_WARNING;
} else {
$data = array('ofuser' => Assign($params['uid'], 0), 'createdat' => 'NOW()', 'ofanli' => Assign($params['cid'], 0), 'score' => Assign($params['score'], 0));
$id = StorageAdd('car_anli_score', $data);
if (empty($id) == TRUE) {
$result['msg'] = '重复保存！';
} else {
$avg = "(SELECT SUM(score)/COUNT(id) FROM car_anli_score WHERE ofanli='%d')";
$fields = array('score_avg' => sprintf($avg, $params['cid']));
StorageEditByID('search_result', $fields, $params['cid']);
## 更新用戶積分
Techuser_setScore(Assign($params['uid'], 0), 5);
$result = array('code' => '101', 'msg' => MESSAGE_SUCCESS);
}
}
function RefreshMsg($uid)
{
if (empty($uid)) {
return;
}
$messages = array('msg1' => "(SELECT COUNT(*) FROM hh_techforum WHERE pubuser='******' AND isnewmsg=1 AND type=1)", 'msg2' => "(SELECT COUNT(*) FROM hh_techforum WHERE pubuser='******' AND isnewmsg=1 AND type=2)", 'msg3' => "(SELECT COUNT(*) FROM hh_techqzhi WHERE pubuser='******' AND isnewmsg=1)", 'msg4' => "(SELECT COUNT(*) FROM hh_techforum_list WHERE at='{$uid}' AND isnewat=1 AND type=1)", 'msg5' => "(SELECT COUNT(*) FROM hh_techforum_list WHERE at='{$uid}' AND isnewat=1 AND type=2)", 'msg6' => "(SELECT COUNT(*) FROM hh_techqzhi_list WHERE at='{$uid}' AND isnewat=1)", 'msg7' => "(SELECT COUNT(*) FROM hh_zhaopin WHERE ofuser='******' AND isnewmsg=1)", 'msg8' => "(SELECT COUNT(*) FROM hh_zhaopin_list WHERE at='{$uid}' AND isnewat=1)", 'msg9_0' => RefreshMsgByDianzan($uid, 1, 0), 'msg9_1' => RefreshMsgByDianzan($uid, 1, 1), 'msg10_0' => RefreshMsgByDianzan($uid, 2, 0), 'msg10_1' => RefreshMsgByDianzan($uid, 2, 1), 'msg11_0' => RefreshMsgByDianzan($uid, 3, 0), 'msg11_1' => RefreshMsgByDianzan($uid, 3, 1), 'msg12_0' => RefreshMsgByDianzan($uid, 4, 0), 'msg12_1' => RefreshMsgByDianzan($uid, 4, 1), 'msg9' => "msg9_0+msg9_1", 'msg10' => "msg10_0+msg10_1", 'msg11' => "msg11_0+msg11_1", 'msg12' => "msg12_0+msg12_1");
foreach ($messages as $key => $sql) {
$fields = array($key => $sql);
StorageEditByID('hh_techuser', $fields, $uid);
}
}
if (is_array($buf) and empty($buf) == FALSE) {
foreach ($buf as $number => $row_img) {
$msg['mdata'][] = array('mid' => $row_img['id'], 'type' => 0, 'mname' => 'image' . ($number + 1), 'mpic' => $row_img['id'] . '_s.png', 'url' => '');
}
}
$buffer['messages'][] = $msg;
}
}
$result['data'][] = $buffer;
$schema = 'hh_techqzhi';
$filter0 = array('tid' => Assign($params['tid'], 0), 'pubuser' => Assign($params['uid'], 0));
$filter1 = array('tid' => Assign($params['tid'], 0), 'at' => Assign($params['uid'], 0));
$buffer_host = StorageFindID($schema, Assign($params['tid'], 0));
if (is_array($buffer_host) and empty($buffer_host) == FALSE) {
if ($params['uid'] == $buffer_host['pubuser']) {
StorageEditByID($schema, array('isnewmsg' => 0, 'isnewat' => 0), $params['tid']);
}
}
StorageEdit($schema . '_list', array('isnew' => 0, 'isnewat' => 0), $filter0);
StorageEdit($schema . '_list', array('isnew' => 0, 'isnewat' => 0), $filter1);
## 取消點贊狀態
RefreshMsgByCDZ($buffer_host['pubuser'], 3, 0);
RefreshMsgByCDZ($buffer_host['pubuser'], 3, 1);
RefreshMsg(Assign($buffer_host['pubuser'], 0));
}
## 清除點贊狀態
StorageEditByID('hh_techqzhi', array('isnewdz' => 0), Assign($params['tid'], 0));
RefreshMsgByCDZ($params['uid'], 3, 0);
RefreshMsgByCDZ($params['uid'], 3, 1);
RefreshMsg(Assign($params['uid'], 0));
}
$record = StorageFindID($schema, Assign($params['tid'], 0));
## 更新更貼統計數據
$fields = array();
$column = '';
switch ($params['tag']) {
case '3':
$column = 'pubuser';
$fields = array('maxno' => 'maxno+1', 'replycount' => "(SELECT COUNT(*) FROM {$schema}_list WHERE tid='{$params['tid']}')", 'isnewmsg' => $record[$column] == $params['uid'] ? 0 : 1, 'isnewat' => empty($params['touid']) ? 0 : 1);
break;
case '4':
$column = 'ofuser';
$fields = array('maxno' => 'maxno+1', 'replycount' => "(SELECT COUNT(*) FROM {$schema}_list WHERE tid='{$params['tid']}')", 'isnewmsg' => $record[$column] == $params['uid'] ? 0 : 1, 'isnewat' => empty($params['touid']) ? 0 : 1);
break;
default:
$column = 'pubuser';
$fields = array('maxno' => 'maxno+1', 'replycount' => "(SELECT COUNT(*) FROM {$schema}_list WHERE tid='{$params['tid']}')", 'isnewmsg' => $record[$column] == $params['uid'] ? 0 : 1, 'isnewat' => empty($params['touid']) ? 0 : 1);
}
StorageEditByID($schema, $fields, Assign($params['tid'], 0));
$result = array('code' => '101', 'data' => array());
## 獲取更貼人信息
$condition = array('schema' => "{$schema}_list", 'fields' => array('pubtime', 'no', 'id', "(SELECT {$column} FROM {$schema} WHERE id={$schema}_list.id) AS h_pubuser"), 'filter' => array('id' => $id));
$buf = StorageFindOne($condition);
if (is_array($buf) and empty($buf) == FALSE) {
$result['data'][] = array('posttime' => $buf['pubtime'], 'index' => $buf['no'], 'listid' => $buf['id']);
}
## 更新相關用戶消息
RefreshMsg(Assign($parmas['uid'], 0));
RefreshMsg(Assign($params['touid'], 0));
RefreshMsg(Assign($buf['h_pubuser'], 0));
}
}
$result = array('code' => '101', 'msg' => $message);
} else {
$data = array('uid' => Assign($params['uid'], 0), 'tid' => Assign($params['tid'], 0), 'tag' => Assign($params['tag'], 0), 'type' => Assign($params['type'], 0), 'deviceid' => Assign($params['deviceid']), 'touid' => 0);
$id = StorageAdd('hh_techuser_dianzan', $data);
if (empty($id) == FALSE) {
$message = empty($params['type']) ? '取消成功！' : '点赞成功！';
$result = array('code' => '101', 'msg' => $message);
}
}
## 更新點贊通知
$schemas = array('1' => 'hh_techforum', '2' => 'hh_techforum', '3' => 'hh_techqzhi', '4' => 'hh_zhaopin');
$info = StorageFindID($schemas[$params['tag']], Assign($params['tid'], 0));
$pubuser = $params['tag'] == '4' ? 'ofuser' : 'pubuser';
if (empty($schemas[$params['tag']]) == FALSE and $info[$pubuser] != $params['uid']) {
$isnewdz = array('isnewdz' => $params['type'] === '1' ? 1 : 0);
StorageEditByID($schemas[$params['tag']], $isnewdz, Assign($params['tid'], 0));
## 被點贊的樓主更新通知
RefreshMsg(Assign($info[$pubuser], 0));
}
## 推送消息
if ($params['type'] == '1') {
$schema = 'hh_techforum';
switch ($params['tag']) {
case '3':
$schema = 'hh_techqzhi';
break;
case '4':
$schema = 'hh_zhaopin';
break;
}
$params['touid'] = 0;
if (CheckOpenID($params['openid'], $params['uid']) == FALSE) {
$result['msg'] = MESSAGE_WARNING;
} else {
if ($params['reward'] == 1) {
$result['msg'] = '该回复已经被采纳！';
} else {
$info_tid = StorageFindID('hh_techforum_list', Assign($params['tolistid'], 0));
$user_uid = StorageFindID('hh_techuser', Assign($params['uid'], 0));
$user_touid = StorageFindID('hh_techuser', Assign($params['touid'], 0));
$info_tid = StorageFindID('hh_techforum', Assign($params['tid'], 0));
if ($info_tid['rewarded'] == 1) {
die(JsonEncode(array('code' => '100', 'msg' => '该回复已经被采纳！')));
}
## 設置回帖的採納狀態
$fields_tolist = array('adopt' => 1);
StorageEditByID('hh_techforum_list', $fields_tolist, Assign($params['tolistid'], 0));
## 添加會貼者之可兌換積分
$message = sprintf(RANKSCORE_ADOPTED, $info_tid['title'], SafeUsername($user_uid), Techuser_viewRankScore($params['reward']));
//Techuser_setRankscore(Assign($params['touid'], 0), $params['reward'], $message, TRUE);
Techuser_setRankByScore(Assign($params['touid'], 0), Techuser_viewRankScore($params['reward']), $message);
## 設置主題悬赏狀態
$fields_tid = array('rewarded' => 1);
StorageEditByID('hh_techforum', $fields_tid, Assign($params['tid'], 0));
## 記錄樓主採納日誌
$message = sprintf(RANKSCORE_ADOPT, SafeUsername($user_touid), Techuser_viewRankScore($params['reward']));
Techuser_setRankscore(Assign($params['uid'], 0), 0, $message);
## 添加回帖者經驗值
Techuser_setRank($params['touid'], 2);
$result = array('code' => '101', 'msg' => MESSAGE_SUCCESS);
}
}
$old_img = $record['headerimg'];
} else {
$img_path = get_threeimg($params['uid'], $params['iconurl']);
$data = array('thirduid' => Assign($params['uid'], 0), 'nick' => Assign($params['nick']), 'city' => Assign($params['city']), 'tag' => Assign($params['tag'], 0), 'headerimg' => $img_path);
$uid = StorageAdd('hh_techuser', $data);
}
if (empty($uid) == TRUE) {
$result['msg'] = '登陆不存在！';
} else {
$record = StorageFindOne($condition);
if (is_array($record) == FALSE or empty($record) == TRUE) {
$result['msg'] = '登陆失败！';
} else {
$fields = array('loginid' => md5($params['uid'] . $params['pwd'] . time()), 'deviceid' => Assign($params['deviceid']));
StorageEditByID('hh_techuser', $fields, $uid);
if (empty($old_img) == TRUE) {
$img_path = get_threeimg($params['uid'], $params['iconurl']);
StorageEditByID('hh_techuser', array('headerimg' => $img_path), $uid);
}
$result = array('code' => '101', 'data' => array());
$condition_user = array('schema' => 'hh_techuser', 'fields' => array('*', '(SELECT title FROM hh_score WHERE dengji=grade) AS h_grade'), 'filter' => array('id' => $uid));
$record_user = StorageFindOne($condition_user);
$icon_path = $record_user['headerimg'];
if (empty($icon_path) or strpos($icon_path, 'http') > -1) {
$icon_path = $img_path;
}
$rankinfo = StorageFindID('hh_rank', $record_user['rankname'] + 1);
$result['data'][] = array('uid' => Assign($record_user['id'], 0), 'phone' => Assign($record_user['username_d']), 'openid' => Assign($record_user['loginid']), 'image' => $icon_path, 'nick' => Assign($record_user['nick']), 'grade' => Assign($record_user['h_grade']), 'score' => Assign($record_user['score']), 'city' => Assign($record_user['city']), 'cars' => Assign($record_user['cars']), 'job' => Assign($record_user['job']), 'level' => Assign($record_user['level']), 'experience' => Assign($record_user['experience']), 'percent' => Assign($record_user['percent']), 'needscore' => Assign($record_user['needscore']), 'official' => Assign($record_user['type'], 0), 'identified' => Assign($record_user['identified'], 0), 'rank' => Assign($record_user['rank'], 0), 'rankname' => $rankinfo['title']);
Techuser_setScore($uid, 1);
}
}
<?php
// Copyright 2015 The Haohaoxiuche Team Authors. All right reserved.
// Use of this source that is governed by a Apache-style
// license that can be found in the LICENSE file.
//
// 技術版API編號015 發送用戶註冊請求 ##已取消 新接口096
//
// @authors hjboss <*****@*****.**> 2015-12-17#
// @version 1.0.0
// @package hhxc
if (!defined('HHXC')) {
die('Permission denied');
}
$data = array('username' => Assign($params['phone']), 'password' => Assign($params['pwd']), 'createdat' => 'NOW()', 'deviceid' => Assign($params['deviceid']), 'username_d' => Assign($params[KEY_PHONE]));
$id = StorageAdd('hh_techuser', $data);
if (empty($id) == TRUE) {
$result['msg'] = '电话号码已注册！';
} else {
$result = array('code' => '101', 'msg' => MESSAGE_SUCCESS);
$num = StorageEditByID('hh_techuser', array('withcode' => WithCode($username, $id)), $id);
if (empty($num) == TRUE) {
StorageEditByID('hh_techuser', array('withcode' => WithCode($username, $id, 9999999)), $id);
}
Techuser_setScore($id, 7);
}
//
// @authors hjboss <*****@*****.**> 2015-12-16#
// @version 1.0.0
// @package hhxc
if (!defined('HHXC')) {
die('Permission denied');
}
if (CheckOpenID($params['openid'], $params['uid']) == FALSE) {
$result['msg'] = MESSAGE_WARNING;
} else {
$num = 0;
switch ($params['type']) {
case '1':
$fields = array('lockby' => $params['uid'], 'locktime' => 'NOW()', 'zhuangtai' => 1);
$filter = array('id' => Assign($params['qid'], 0), 'lockby' => 0, 'zhuangtai' => 0);
$num = StorageEdit('hh_questions', $fields, $filter);
break;
case '2':
$data = array('ofq' => Assign($params['qid'], 0), 'ofuser' => Assign($params['uid'], 0), 'createdat' => 'NOW()');
$id = StorageAdd('hh_questions_diff', $data);
if (empty($id) == FALSE) {
$num = StorageEditByID('hh_questions', array('difficulty' => 'difficulty+1'), $params['qid']);
}
break;
}
if (empty($num) == FALSE) {
$result = array('code' => '101', 'msg' => MESSAGE_SUCCESS);
} else {
$result['msg'] = '问题已被其他人抢答！';
}
}
if (is_array($recordset_img) and empty($recordset_img) == FALSE) {
foreach ($recordset_img as $number_img => $row_img) {
$buf['mdata'][] = array('mid' => $row_img['id'], 'type' => 0, 'mname' => 'image' . ($number_img + 1), 'mpic' => $row_img['id'] . '_s.png', 'url' => '');
}
}
$buffer['messages'][] = $buf;
}
}
$result['data'][] = $buffer;
$schema = 'hh_zhaopin';
$filter0 = array('tid' => Assign($params['tid'], 0), 'pubuser' => Assign($params['uid'], 0));
$filter1 = array('tid' => Assign($params['tid'], 0), 'at' => Assign($params['uid'], 0));
$buffer_host = StorageFindID($schema, Assign($params['tid'], 0));
if (is_array($buffer_host) and empty($buffer_host) == FALSE) {
if ($params['uid'] == $buffer_host['ofuser']) {
StorageEditByID($schema, array('isnewmsg' => 0, 'isnewat' => 0), $params['tid']);
}
}
StorageEdit($schema . '_list', array('isnew' => 0, 'isnewat' => 0), $filter0);
StorageEdit($schema . '_list', array('isnew' => 0, 'isnewat' => 0), $filter1);
## 取消點贊狀態
RefreshMsgByCDZ($buffer_host['ofuser'], 4, 0);
RefreshMsgByCDZ($buffer_host['ofuser'], 4, 1);
RefreshMsg(Assign($buffer_host['ofuser'], 0));
}
## 清除點贊狀態
StorageEditByID('hh_zhaopin', array('isnewdz' => 0), Assign($params['tid'], 0));
RefreshMsgByCDZ($params['uid'], 4, 0);
RefreshMsgByCDZ($params['uid'], 4, 1);
RefreshMsg(Assign($params['uid'], 0));
}
// @package hhxc
if (!defined('HHXC')) {
die('Permission denied');
}
$condition = array('schema' => 'hh_techuser', 'filter' => array('username_d' => Assign($params[KEY_PHONE])));
$record = StorageFindOne($condition);
if (is_array($record) == FALSE or empty($record) == TRUE) {
$result['msg'] = "用户{$params[KEY_PHONE]}不存在！";
} else {
$condition['filter']['password'] = Assign($params['pwd']);
$record = StorageFindOne($condition);
if (is_array($record) == FALSE or empty($record) == TRUE) {
$result['msg'] = '密码不正确！';
} else {
$result = array('code' => '101', 'msg' => $params[KEY_PHONE], 'data' => array());
## 更新OPENID
$fields = array('loginid' => md5($record['uid'] . $params['password'] . time()), 'deviceid' => Assign($params['deviceid']));
StorageEditByID('hh_techuser', $fields, $record['id']);
## 獲取當前用戶信息
$condition_sub = array('schema' => 'hh_techuser', 'fields' => array('*', '(SELECT title FROM hh_score WHERE dengji=grade) AS h_grade', '(SELECT title FROM hh_rank WHERE dengji=rankname) AS h_rankname'), 'filter' => array('id' => $record['id']));
$buf = StorageFindOne($condition_sub);
if (is_array($buf) and empty($buf) == FALSE) {
$result['data'][] = array('uid' => $buf['id'], 'openid' => $buf['loginid'], 'image' => $buf['headerimg'], 'nick' => $buf['nick'], 'grade' => $buf['h_grade'], 'score' => $buf['score'], 'city' => $buf['city'], 'cars' => $buf['cars'], 'job' => $buf['job'], 'level' => $buf['level'], 'experience' => $buf['experience'], 'percent' => $buf['percent'], 'needscore' => $buf['needscore'], 'official' => Assign($buf['type'], 0), 'identified' => Assign($buf['identified'], 0), 'rank' => Assign($buf['rank'], 0), 'rankname' => Assign($buf['h_rankname']));
## 可兌換積分激活
Techuser_rankinit($record['id']);
## 更新登陸積分
Techuser_setScore($record['id'], 1);
RefreshMsg($record['id']);
}
}
}
