public function __construct()
{
parent::__construct();
$this->check_token();
$cart = query_sql('', "select * from cart where member_id=" . $this->uid);
$cart = $cart[0];
if ($cart) {
$this->cart_id = $cart['id'];
$this->cart = json_decode(urldecode($cart['json_content']), true);
} else {
$this->cart = null;
}
}
function get_joke($type, $joke_id, $cat_id, $limit)
{
if ($joke_id) {
$sql = "select `id`, `cat`, `cat_id`, `title`, `content` from `joke` where `id` = {$joke_id}";
} elseif ($cat_id == -1) {
$sql = "select `id`, `cat`, `cat_id`, `title`, `content` from `joke` order by rand() limit {$limit}";
} else {
$sql = "select `id`, `cat`, `cat_id`, `title`, `content` from `joke` where `cat_id` = {$cat_id} order by rand() limit {$limit}";
}
$jokes = query_sql($sql);
if ($type == 'text') {
$result = "";
foreach ($jokes as $joke) {
$result .= $joke['title'] . "\n" . $joke['content'] . "\n\n";
}
write_ok_text($result);
} elseif ($type == 'json') {
write_ok($jokes);
} else {
write_error($GLOBALS['ERR_PARAMS_TYPE']);
}
}
public function yes_contract_put()
{
$this->check_token();
$body = $this->get_request_data('contract');
if ($this->check_body_fields($body, array('id'))) {
$contract_id = $body['id'];
$bid_id = M('contract')->where(array('id' => $contract_id))->getField('bid_id');
if (empty($bid_id)) {
$this->error('5009');
}
$info = M('member')->find($this->uid);
//用户信息
$_POST = array('id' => $bid_id, 'status' => 4);
if (update_data('bid')) {
$res = get_info('contract', array('bid_id' => $bid_id, 'status' => 1));
message_log(0, $res['member_id'], '学生已同意协议。' . $res['title'], 'contract', $res['id'], 2);
$m = query_sql('', "select member.nickname,bid.demand_member_id from bid left join member on member.id=bid.service_member_id where bid.id=" . $bid_id);
M('message')->addAll(array(array("from_member_id" => 0, "to_member_id" => $res['member_id'], 'content' => '学生已同意协议"' . $res['title'] . '"。', 'table' => 'contract', 'table_id' => $res['id'], 'add_time' => date('Y-m-d H:i:s'), 'role' => 2), array("from_member_id" => 0, "to_member_id" => $info['id'], 'content' => '你已同意' . $m[0]['nickname'] . '的协议"' . $res['title'] . '"。', 'table' => 'contract', 'table_id' => $res['id'], 'add_time' => date('Y-m-d H:i:s'), 'role' => 1)));
$this->success();
} else {
// 5010 修改数据失败
$this->error(5010);
}
} else {
$this->error(1001);
}
}
function register_new_member(Member $member)
{
if (!is_member($member->email)) {
$connection = connect();
$member->password = md5($member->password);
$sql = "INSERT INTO team_members (member_id, first_name, last_name, email, password, dob, official_dob, reset_code) VALUES (NULL, '" . $member->first_name . "', '" . $member->last_name . "', '" . $member->email . "' , '" . $member->password . "', '3000-01-01', '" . $member->official_dob . "','" . get_uuid() . "')";
$result = $connection->query($sql);
disconnect($connection);
if ($result == true) {
$member_id_result = query_sql("SELECT `member_id` FROM `team_members` WHERE `email` = '" . $member->email . "'");
$member_id = get_query_result($member_id_result, 'member_id');
$result = array("registered" => true, "status_code" => 200, "member_id" => $member_id);
} else {
$result = array("registered" => false, "status_code" => 401, "error" => "Registration failed due to internal error");
}
} else {
$result = array("registered" => false, "status_code" => 409, "error" => "Member already Registered");
}
return $result;
}
/**
*
* 登陆之后
* @param unknown_type $info
*/
function after_login()
{
$info = GetLogin();
$dlist = query_sql('', "select order_id,max(refund.status) as m_status from refund left join orders on orders.id=refund.order_id where orders.status=5 and (orders.from_member_id=" . $info['id'] . " or orders.to_member_id=" . $info['id'] . ") and UNIX_TIMESTAMP(apply_time)<" . (time() - 3 * 24 * 3600) . " group by order_id having m_status<2");
// $criteria = new CDbCriteria ();
// $criteria->alias = 'refund';
// $criteria->with = array (
// 'orders'
// );
//
// $criteria->compare ( 'orders.' . 'status', 5/*已申请退款*/ );
// $dlist = Refund::model ()->findAll ();
if ($dlist) {
$ids = '';
foreach ($dlist as $v) {
$ids .= $v['order_id'] . ',';
order_record($v['order_id'], 7, $info['nickname'] . '->不同意申请退款');
}
execute_sql('', "update orders set status=7 where status=5 and id in (" . trim($ids, ',') . ")");
}
//老师发货后十五天之内学生没有确认收获
$hlist = query_sql('', "select orders.* from orders where status=2 and (to_member_id =" . $info['id'] . " or from_member_id=" . $info['id'] . ") and UNIX_TIMESTAMP(send_time)<" . (time() - 15 * 24 * 3600));
$ids = '';
foreach ($hlist as $k => $v) {
$ids .= $v['id'] . ',';
$receiptname = get_info('member', array('id' => $v['to_member_id']));
$re['info'] = $v;
$this->extend($v['id'], $re, $receiptname);
}
if ($hlist) {
execute_sql('', "update orders set status=3 where id in (" . trim($ids, ',') . ")");
}
//老师同意退款发货后3天之内学生没有发货,默认确认收获
$slist = query_sql('', "select orders.* from orders where status=6 and (to_member_id =" . $info['id'] . " or from_member_id=" . $info['id'] . ") and id in ( select order_id from refund where refund_status=3 and UNIX_TIMESTAMP(agree_time)<" . (time() - 3 * 24 * 3600) . ")");
$ids = '';
foreach ($slist as $k => $v) {
$ids .= $v['id'] . ',';
$receiptname = get_info('member', array('id' => $v['to_member_id']));
$re['info'] = $v;
$this->extend($v['id'], $re, $receiptname, '老师同意退款3天之内学生没有发货学生默认确认收获');
}
if ($slist) {
execute_sql('', "update orders set status=3 where id in (" . trim($ids, ',') . ")");
}
//学生退款发货后7天之内老师没有确认退款货收货,默认确认收货-7*24*3600
$rlist = query_sql('', "select orders.* from orders where status=8 and (to_member_id =" . $info['id'] . " or from_member_id=" . $info['id'] . ") and UNIX_TIMESTAMP(send_time)<" . (time() - 7 * 24 * 3600));
$ids = '';
foreach ($rlist as $k => $v) {
$ids .= $v['id'] . ',';
$receiptname = get_info('member', array('id' => $v['to_member_id']));
$re['info'] = $v;
$this->extend_c($v['id'], $re, $receiptname);
}
if ($rlist) {
execute_sql('', "update orders set status=9 where id in (" . trim($ids, ',') . ")");
}
//检测学生在7天内不予以答疑时，系统能否自动付款给老师，并默认进入到下一个阶段-7*24*3600
$learning_periods = query_sql('', "select learning_periods.id,learning_periods.bid_id,learning_periods.member_id,learning_periods.price,learning_periods.title,bid.demand_member_id,bid.service_member_id,bid.service_demand_id from learning_periods left join bid on bid.id=learning_periods.bid_id where learning_periods.status=1 and UNIX_TIMESTAMP(release_time)<" . (time() - 7 * 24 * 3600) . " and (bid.service_member_id=" . $info['id'] . " or bid.demand_member_id=" . $info['id'] . " )");
foreach ($learning_periods as $k => $v) {
$learning_period = get_info('learning_periods', array('bid_id' => $v['bid_id'], 'id' => array('gt', $v['id']), 'status' => 0));
$re = $info;
if ($info['id'] == $v['sevice_member_id']) {
$re = get_info('member', array('id' => $v['demand_member_id']));
}
if ($learning_period) {
$v['status'] = 2;
$this->extend_record_c($v['bid_id'], $re, $v);
M('learning_periods')->where('id=' . $v['id'])->save(array('status' => 2));
} else {
M('learning_periods')->where('id=' . $v['id'])->save(array('status' => 5));
M('bid')->where('id=' . $v['bid_id'])->save(array('status' => 8));
$v['status'] = 5;
$this->extend_record($v['bid_id'], $re, $v);
}
}
return;
$cart = get_info('cart', array('member_id' => $info['id']), 'json_content');
if ($cart) {
$list = json_decode(urldecode($cart['json_content']), true);
$this->cart->clear();
if ($list) {
foreach ($list as $k => $v) {
foreach ($v as $kk => $vv) {
$this->cart->addItem($k, $kk, $vv['name'], $vv['price'], $vv['brand'], $vv['cover'], $vv['num'], $vv['shipping']);
}
}
} else {
//$this->cart->clear ();
}
} else {
//$this->cart->clear ();
}
}
public function release_post()
{
$this->check_token();
$data = $this->get_request_data();
$m = M("member");
$info = $m->getById($this->uid);
$content_demand = $data['content'];
$description = trim($data['description']);
if (!is_numeric($data['cost']) && $data['cost'] < 0) {
$this->error(6002);
}
$profes_type = $data['profes_type'];
//专业类型 1.非统考 2.统考 3.公共课
$profes_data = $data['profes_data'];
!is_array($profes_data) && $this->error(6006);
if ($profes_type == 1) {
if (!isset($profes_data['city']) || 0 == $profes_data['city']) {
$this->error(6007);
}
empty($profes_data['university']) && $this->error(6008);
$college = $profes_data['college'];
$university = $profes_data['university'];
} else {
if ($profes_type == 2) {
empty($profes_data['major_subject']) && $this->error(6009);
empty($profes_data['major_classify']) && $this->error(6010);
$profes_data['major'] = $profes_data['major_subject'];
$code = get_info('unified_classify', array('id' => $profes_data['major_classify']));
$profes_data['major_code'] = $code['code'];
$profes_data['college'] = $profes_data['major_classify'];
} else {
if ($profes_type == 3) {
$profes_data['major'] = $profes_data['major_subject'];
}
}
}
empty($description) && $this->error(6004);
mb_strlen($description, "utf-8") > 20 && $this->error(6005);
if ($data['demand_type'] < 4) {
empty($content_demand) && $this->error(6011);
} else {
empty($data['content_course']) && $this->error(6012);
empty($data['content_reference']) && $this->error(6013);
empty($data['yy_number']) && $this->error(6014);
}
if ($data['role_type'] == 2) {
if (empty($data['image_sha1']) || !count($data['image_sha1'])) {
$this->error(6015);
}
}
$demand = M("demand");
$demand_ins_data = array("demand_type" => $data['demand_type'], "profes_type" => $data['profes_type'], "city" => $profes_data['city'], "university" => $profes_data['university'], "college" => $profes_data['college'], "major" => $profes_data['major'], "major_code" => $profes_data['major_code'], "description" => $data['description'], "cost_type" => $data['cost'] > 0 ? 2 : 1, "cost" => $data['cost'], "qq" => $data['qq'], "mobile" => $data['phone'], "content_demand" => $data['content'], "member_id" => $this->uid, "member_name" => $info["nickname"], "role_type" => $data['role_type'], "require_identity" => $data['require_identity'], "require_authenticate" => $data['require_authenticate'], "require_security" => $data['require_security']);
if ($data['demand_type'] == 4) {
$demand_ins_data['content_course'] = $data["content_course"];
$demand_ins_data['content_reference'] = $data["content_reference"];
$demand_ins_data['remarks'] = $data["remarks"];
$demand_ins_data['set_time'] = max(0, intval($data['set_time']));
}
if (!$demand->add($demand_ins_data)) {
$this->error(9001);
}
$res = $demand->getLastInsID();
$qq = $data['qq'];
if (empty($info['qq'])) {
$m->where("id=" . $this->uid)->save(array("qq" => $qq));
}
if (1 == $data["role_type"]) {
$title = '您的需求"' . $description . '"已发布成功';
} else {
$title = '你的辅导项目"' . $description . '"已发布成功';
if ($data['demand_type'] == 4) {
$title = $description . '已发布成功！我们将在24小时内进行审核！审核成功后将发布在首页。审核成功后我们会给您安排YY频道的YY频道3503895的一间直播教室。';
}
}
//发送系统消息
M('message')->add(array("from_member_id" => 0, "to_member_id" => $info['id'], 'content' => $title, 'table' => $this->table, 'role' => $dsts['role_type'], 'table_id' => $res, 'add_time' => date('Y-m-d H:i:s')));
$image = $data['image_sha1'];
//将图片写入数据库
if (!empty($image)) {
$att = M("attachments");
$att_data = array("member_id" => $info["id"], "table" => "demand", "table_id" => $res, "sha1" => $image, "add_time" => date("Y-m-d H:i:s"));
$att->add($att_data);
}
// 更新发布数
if ($info['wap_role'] == 1) {
$this->upNumber('member', array('id' => $this->uid), 'demand_num');
//更新最后发布服务的时间
M('member')->where(array('id' => $this->uid))->save(array('last_serve_time' => time()));
// 根据条件保存修改的数据
} else {
$this->upNumber('member', array('id' => $this->uid), 'serve_num');
}
//用户发了需求/服务之后,要把用户放到所在的圈子里,假如没在的情况下
if ($data['profes_type'] == 1) {
if ($college) {
$community = get_info('community', array('member_id' => $info['id'], 'table_type' => 'school', 'table_id' => $college, 'critype' => 2, 'status' => 1), 'id');
if (!$community) {
M('community')->add(array('member_id' => $info['id'], 'table_type' => 'school', 'table_id' => $college, 'critype' => 2, 'add_time' => date('Y-m-d H:i:s')));
}
} else {
$community = get_info('community', array('member_id' => $info['id'], 'table_type' => 'school', 'table_id' => $university, 'critype' => 1, 'status' => 1), 'id');
if (!$community) {
M('community')->add(array('member_id' => $info['id'], 'table_type' => 'school', 'table_id' => $university, 'critype' => 1, 'add_time' => date('Y-m-d H:i:s')));
}
}
}
//发布成功送积分
$param = array('uid' => $info['id'], 'tablename' => 'demand', 'tableid' => $res, 'uname' => $info['nickname'], 'action' => MODULE_NAME . '/' . CONTROLLER_NAME . '/' . ACTION_NAME, 'ruleId' => 36, 'field' => 'score', 'isLimit' => false);
tag('setScore', $param);
if ($info['pid'] != 0 && strtotime($info['reg_time']) + 365 * 24 * 3600 > time()) {
if ($info['role'] == 1) {
$reward_setting = 'set_stu_publish';
$reward_msg = "推广用户发布需求获取金币";
$t_res = query_sql("", "select * from extend_reward where set_name='set_stu_publish' and from_member_id=" . $info['id'] . " and status=1");
} else {
$reward_msg = "推广用户发布服务获取金币";
$reward_setting = 'set_tea_publish';
$t_res = query_sql("", "select * from extend_reward where set_name='set_tea_publish' and from_member_id=" . $info['id'] . " and status=1");
}
if (!$t_res) {
$extend_reward = M('extend_reward')->add(array('from_member_id' => $info['id'], 'to_member_id' => $info['pid'], 'set_name' => $reward_setting, 'add_time' => date('Y-m-d H:i:s'), 'role' => $info['role'], 'table_name' => 'demand', 'table_id' => $res));
$data['coin'] = array('exp', 'coin+' . C($reward_setting));
//M('member')->
$pname = get_info('member', array('id' => $info['pid']), 'nickname');
D('score_log')->add(array('uid' => $info['pid'], 'table_name' => 'extend_reward', 'table_id' => $extend_reward, 'uname' => $pname['nickname'], 'action' => MODULE_NAME . '/' . CONTROLLER_NAME . '/' . ACTION_NAME, 'type' => 'coin', 'score' => C($reward_setting), 'rule_id' => 34, 'msg' => $reward_msg, 'create_time' => time()));
//更新最后发布时间
M('member')->where('id=' . $info['id'])->save(array('last_serve_time' => time()));
}
}
$this->success(array("id" => $res));
}
