微信小程序 飞鱼知识变现小程序2.5.3 前端 后端

<?php /** * Created by PhpStorm. * User: fei * Date: 2018/9/13 * Time: 下午7:11 */ class Ask_Mobile{ public function upimg(){ global $_W; $upimg=$_FILES['askimg']; $arr_ty=explode('/',$upimg['type']); $arr_date=explode('-',date('Y-m',time())); $img_dir='../addons/fy_knowledge/data/image/'.$_W['uniacid'].'/'.$arr_date[0].'/'.$arr_date[1].'/'; if(!is_dir($img_dir)){ mkdir($img_dir,0777,true); } $str_name=fy_rand(12); move_uploaded_file($upimg['tmp_name'],$img_dir.$str_name.'.'.$arr_ty[1]); $imginfo='/'.$_W['uniacid'].'/'.$arr_date[0].'/'.$arr_date[1].'/'.$str_name.'.'.$arr_ty[1]; showJson(0,'imginfo',array('imginfo'=>$imginfo)); } /** * 提问回答 **/ public function pay(){ global $_W,$_GPC; if($_GPC['formid']){ m('member')->addformid($_W['openid'],$_GPC['formid']); } $userinfo=m('member')->getmember($_W['openid']); $ty=$_GPC['ty']; /** * ty=1 直接提问 * ty=2 向专家提问 * ty=3 旁听 **/ $ask_set=pdo_get('fy_knowledge_answer_set',array('uniacid'=>$_W['uniacid']),array('min_price')); if($ty == 1) { if ($_GPC['award'] < $ask_set['min_price']) { $msg = '打赏金额不能低于' . $ask_set['min_price'] . '元'; showJson(1, $msg); } $askfee=$_GPC['award']; } if($ty == 2){ $proinfo=m('member')->getmember($_GPC['mid']); $askfee=$proinfo['ask_pay']; } $tid='ASK'.date('YmdHis',time()).$_W['uniacid'].$userinfo['mid'].fy_rand(10); $data=[]; $data['uniacid']=$_W['uniacid']; $data['openid']=$_W['openid']; $data['miaoshu']=$_GPC['miaoshu']; $data['ty']=$_GPC['ty']; if(!empty($_GPC['imginfo'])){ $data['imginfo']=$_GPC['imginfo']; } $data['isshare']=$_GPC['isshare']; if($ty == 2){ $data['proid']=$_GPC['mid']; } $data['fee']=$askfee; $data['tid']=$tid; pdo_insert('fy_knowledge_ask_order',$data); $fee=$askfee; $title='咨询'; $params=[ 'fee'=>$fee, 'tid'=>$tid, 'title'=>$title, 'user'=>$_W['openid'] ]; $res=m('pay')->pay($params); if($res['status'] == 1){ showJson(1,$res['return_msg']); } if($res['status'] == 0){ showJson(0,'success',array('info'=>$res)); } } public function toutingpay(){ global $_W,$_GPC; if($_GPC['id']){ $user=m('member')->getmember($_W['openid']); $ask_set=pdo_get('fy_knowledge_answer_set',array('uniacid'=>$_W['uniacid'])); $fee=$ask_set['tou_price']; $title='咨询服务'; $tid='TOU'.date('YmdHis',time()).$user['mid'].$_W['uniacid'].fy_rand(6); /** * 判断有没有购买记录 */ $res_order=pdo_get('fy_knowledge_ask_tou',array('askid'=>$_GPC['id'],'status'=>1)); if($res_order){ showJson(3,'已经购买'); } /** * 创建偷听订单 **/ $data=[]; $data['uniacid']=$_W['uniacid']; $data['openid']=$_W['openid']; $data['fee']=$fee; $data['tid']=$tid; $data['askid']=$_GPC['id']; if($ask_set['isvipfree'] == 1 && $user['isvip'] == 1){ $data['status']=1; } pdo_insert('fy_knowledge_ask_tou',$data); if($ask_set['isvipfree'] == 1 && $user['isvip'] == 1){ showJson(2,'会员旁听'); } $params=[ 'fee'=>floatval($fee), 'tid'=>$tid, 'title'=>$title, 'user'=>$_W['openid'] ]; $res=m('pay')->pay($params); if($res['status'] == 1){ showJson(1,$res['return_msg']); } if($res['status'] == 0){ showJson(0,'success',array('info'=>$res)); } } } public function getallquestion(){ global $_W,$_GPC; $member=m('member')->getmember($_W['openid']); $ask_set=pdo_get('fy_knowledge_answer_set',array('uniacid'=>$_W['uniacid'])); $index=1; if($_GPC['index']){ $index=$_GPC['index']; } $ty=$_GPC['ty']; if($ty == 'moren'){ $other=' order by id desc'; } if($ty == 'award'){ $other = ' order by fee desc'; } $pageinfo=getPaging($index,10,'fy_knowledge_ask_order',array('uniacid'=>$_W['uniacid'],'status'=>1,'ty'=>1),$other); if($pageinfo['pageinfo']){ foreach ($pageinfo['pageinfo'] as &$value){ /** * 获取该问题回答数 **/ $ask_num=(int)pdo_fetchcolumn('select COUNT(*) from '.tablename('fy_knowledge_answer').' where askid=:askid',array('askid'=>$value['id'])); $user=m('member')->getmember($value['openid']); $value['avatar']=$user['avatar']; $value['nickname']=$user['nickname']; $value['answer_num']=$ask_num; /** * 时间差 **/ $istime=time()-$value['createtime']; if($istime < 60){ $msg='刚刚'; }else{ $ismin=intval($istime/60); if($ismin < 60){ $msg=$ismin.'分钟前'; }else{ $ishour=intval($ismin/60); if($ishour <= 24){ $msg=$ishour.'小时前'; }else{ $isday=intval($ishour/24); $msg=$isday.'天前'; } } } $value['time_cha']=$msg; } unset($value); } showJson(0,'pageinfo',array('pageinfo'=>$pageinfo,'member'=>$member,'ask_set'=>$ask_set)); } public function getaskinfobyid(){ global $_W,$_GPC; if($_GPC['askid']){ $idinfo=pdo_get('fy_knowledge_ask_order',array('id'=>$_GPC['askid'])); $allanswer=pdo_fetchall('select * from '.tablename('fy_knowledge_answer').' where askid=:askid order by last_time desc',array(':askid'=>$_GPC['askid'])); if($allanswer){ foreach ($allanswer as &$value){ /** * 获取专家信息 **/ $proinfo=m('member')->getmember($value['mid']); $value['pro_name']=$proinfo['name']; $value['pro_avatar']=$proinfo['avatar']; $arr_info=explode(':',$value['info']); /** * 分离时间 */ $as=[]; $i=0; foreach ($arr_info as $kk){ $arr_time_info=explode('#',$kk); $istime=time()-$arr_time_info[1]; $isminutes=intval($istime/60); if($isminutes == 0){ $as[$i]['time_cha']='刚刚'; } if($isminutes > 0 && $isminutes < 60){ $as[$i]['time_cha']=$isminutes.'分钟前'; } if($isminutes > 60){ $ishour=intval($isminutes/60); if($ishour > 1