9169-php/Application/Bibidd/Controller/SearchController.class.php

<?php

namespace bibidd\Controller;

use Bibidd\Controller\CommonBaseController;
/**
 *   用户查询，v2.0
 */
class SearchController extends  CommonBaseController
{
    /**
     * 用户查询列表
     * @return void
     */
    public function user_search()
    {

        $this->addHeaders(); //添加头部请求
        $userInfo =  $this->checkUserIsExist($_POST['uid']); //检查用户


        //查詢數據
        $page = $_POST['page'];
        $uid=$userInfo['id'];

        $one_size = 30; //每頁30行記錄
        $page_one = ($page - 1) * $one_size;
        // 获取数据
        $search_by_user_list = M("search_info")->where("uid='$uid'")
            ->field(" id,uid,user_search,CONVERT_TZ(FROM_UNIXTIME(search_time), '+00:00', '+08:00') as search_time,admin_return,admin_tishi,(CASE admin_tishi_time WHEN 0 THEN NULL ELSE CONVERT_TZ(FROM_UNIXTIME(admin_tishi_time), '+00:00', '+08:00') END) AS admin_tishi_tim,`status`,tuikuan")
            ->LIMIT($page_one, $one_size)->order("search_time desc")->select();
        $returnData = array();

        //获取退款明细
        foreach ($search_by_user_list as $key=>$val)
        {
            $temp_uid = $val['uid'];
            $temp_infoId=$val['id'];
            $tk_list = M("search_info_tuikuan")->where("info_id='$temp_infoId' and uid='$temp_uid'")->select();
            $val['tuikuanDetail']="";
            if(!empty($tk_list))
            {
                $val['tuikuanDetail']=$tk_list;
            }
            $returnData[$key]=$val;
        }//end for

        $data['code'] = '200';
        $data['message'] = 'ok';
        $data['all_num'] = M("search_info")->where("uid='$uid'")->LIMIT($page_one, $one_size)->count();
        $data['data'] = $returnData;

        echo json_encode($data);

    }

    /**
     * 通过ID查询明细
     * @return void
     */
    public function find_search_detail_by_id()
    {
        $this->checkUserIsExist($_POST['uid']); //检查用户
        $this->addHeaders(); //添加头部请求

        $id=$_POST['id'];
        $search_by_id = M("search_info")
            ->field(" id,uid,user_search,CONVERT_TZ(FROM_UNIXTIME(search_time), '+00:00', '+08:00') as search_time,admin_return,admin_tishi,(CASE admin_tishi_time WHEN 0 THEN NULL ELSE CONVERT_TZ(FROM_UNIXTIME(admin_tishi_time), '+00:00', '+08:00') END) AS admin_tishi_tim,`status`,tuikuan")
            ->where("id='$id'")->find();
        $search_by_id['tuikuanDetail']="";

        if(!empty($search_by_id))
        {
            $temp_uid = $search_by_id['uid'];
            $temp_infoId=$search_by_id['id'];
            $tk_list = M("search_info_tuikuan")
                ->field("*")
                ->where("info_id='$temp_infoId' and uid='$temp_uid'")->select();
            if(!empty($tk_list))
            {
                $search_by_id['tuikuanDetail']=$tk_list;
            }
        }

        $data['code'] = '200';
        $data['message'] = 'ok';
        $data['data'] = $search_by_id;
        echo json_encode($data);
    }

    /**
     *
     * 添加用户查询
     * @return void
     */
    public function  add_search()
    {

        $this->addHeaders(); //添加头部请求
        $userInfo =  $this->checkUserIsExist($_POST['uid']); //检查用户

        if(empty($_POST['content']) || empty(trim($_POST['content'])))
        {
            $this->returnData();
            die();
        }

        $uid=$userInfo['id'];
        $addInfo['uid']=$uid;
        $addInfo['user_search']=$_POST['content'];
        $addInfo['search_time']= time();

        //扣除用户金币
        $jinbi = M("user_info")->where("id=$uid")->field("gold_coins_number")->find();

        if($jinbi["gold_coins_number"]<30)
        {
            //钱不够扣

            $this->returnDataAndSendMsg("您没有足够金币");
            die();
        }


        $amount = 30;
        //添加
        $result = M("search_info")->add($addInfo);
        if($result)
        {
            $data['code'] = '200';
            $data['message'] = 'ok';
            $r = M("user_info")->where("id=$uid")->setDec('gold_coins_number', $amount);//扣减
            echo json_encode($data);
            die();
        }


        $data['code'] = '200';
        $data['message'] = 'error';
        echo json_encode($data);

        //统计消费明细
        $this->xiaofei_detail($uid,"查询隐私",$addInfo['user_search'],$amount);
    }
}