12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703 |
- <?php
- namespace app\api\controller;
- use AlibabaCloud\SDK\Vod\V20170321\Models\GetAIMediaAuditJobResponseBody\mediaAuditJob\data;
- use app\common\model\ActivityApply;
- use app\common\model\ActivityApplyItem;
- use app\common\model\ActivityPrice;
- use app\common\model\ActivitySchedule;
- use app\common\model\ActivitySponsor;
- use app\common\model\ActivityTemplate;
- use app\common\model\ActivityTemplateItem;
- use app\common\model\ArticleItem;
- use app\common\model\BillApply;
- use app\common\model\BillHeader;
- use app\common\model\DatumUrl;
- use app\common\model\DeliveryAddress;
- use app\common\model\GoodsOrderRefund;
- use app\common\model\PlatformLike;
- use app\common\model\StoreOrderRefund;
- use app\common\model\TopSearch;
- use app\common\model\User;
- use app\common\model\UserCollect;
- use app\common\model\UserMessage;
- use app\common\model\UserSearch;
- use app\common\model\UserTrack;
- use app\common\model\VideoUrl;
- use app\common\service\CheckPower;
- use app\common\service\OrderCallback;
- use app\common\service\UserSynth;
- use think\Db;
- /**
- * @title 活动
- * @controller Activity
- * @group base
- */
- class Activity extends Base
- {
- // 需要登录的
- protected $need_login = [
- 'activityTags',
- 'activityCollect',
- //'activityApply',
- //'payApplyOrder',
- 'getApplyInfo',
- 'cancelApplyOrder',
- 'getMyActivityList',
- 'getCollectActivity',
- 'getActivityTrack',
- 'getTagsActivity',
- 'getApplyList',
- 'getTicketInfo',
- 'hxOrder',
- 'applyRefund',
- 'deliveryDetails',
- 'getBillInfo',
- 'getApplyOrderList',
- 'delApplyOrder',
- 'delTicket',
- 'unreadChange',
- 'getMessageList',
- 'batchesDel',
- 'applyBill',
- ];
- public function initialize()
- {
- parent::initialize();
- parent::setUid();
- }
- /**
- * @title 活动推荐
- * @desc 活动推荐
- * @author qc
- * @method GET
- * @url /api/Activity/getRecommendList
- * @header name:Authorization require:1 desc:Token
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @param name:rand_user type:string default:-- desc:随机id(非登录状态必传,page=1时生成(a123),其他页数(a123),一直查询到没有数据)
- * @return name:id type:string default:-- desc:资料item_id
- * @return name:id type:int default:-- desc:id
- * @return name:address type:string default:-- desc:地址
- * @return name:cover type:string default:-- desc:封面
- * @return name:label_name type:array default:-- desc:标签
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时候
- * @return name:status type:int default:-- desc:活动状态1正常2取消
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:is_apply type:int default:-- desc:是否报名(0否1是)
- * @return name:release_time type:string default:-- desc:上架时间
- */
- public function getRecommendList()
- {
- $user_id = $this->user_id ? $this->user_id : input('rand_user');
- if(!$user_id) $this->error('参数错误');
- $list = UserSynth::getRecommendList($user_id,'activity',$this->page,$this->page_num);
- if($list['code'] != 200) $this->error($list['msg']);
- $this->success('ok',$list);
- $search_log = UserSearch::getSearchTitle($this->user_id,11);
- $search_arr = [];
- $where_str = 'b.id > 0';
- foreach ($search_log as $t){
- $search_arr[] = " b.title like '".'%'.$t."%'" .' ';
- $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
- }
- if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
- $field = 'a.id,cover,a.user_id,a.province,a.city,a.county,a.address,title,a.status,address,a.read_num,label,start_time,end_time,IFNULL(is_recommend,0) is_recommend ';
- $table = 'dd_activity';
- $order_by_two = 'a.read_num';
- $sql = "SELECT $field FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id WHERE a.is_deleted = 0 AND a.status = 1 ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}";
- $sql2 = "SELECT count(a.id) num FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id WHERE a.is_deleted = 0 AND a.status = 1 ";
- $list = Db::query($sql);
- $list = dispose_recommend($list);
- array_walk($list,function (&$v,$k){
- $v['read_num'] = numTransform( $v['read_num']);
- $v['cover_arr'] = $v['cover'] ? explode('|',$v['cover']) : null;
- $v['cover'] = $v['cover_arr'] ? $v['cover_arr'][0]:null;
- $v['is_apply'] = ActivityApply::checkApply($this->user_id,$v['id']);
- $v['label_name'] = $v['label'] ? explode(',',trim($v['label'],',')): null;
- });
- $total = Db::query($sql2);
- $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
- }
- /**
- * @title 活动列表
- * @desc 活动列表
- * @author qc
- * @method GET
- * @url /api/Activity/getActivityList
- * @header name:Authorization require:1 desc:Token
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @param name:sel_type type:int default:0 desc:活动状态【0全部,1已结束2待开始3进行中】
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:海报
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- */
- public function getActivityList(){
- $sort_type = input('get.sort_type',1);
- $sel_type = input('get.sel_type',0);
- switch ($sort_type) {
- case 1:
- $order = ['read_num'=>'desc','id'=>'asc'];
- break;
- case 2:
- $order = ['id'=>'asc','sort'=>'desc'];
- break;
- case 3:
- $order = ['id'=>'desc','sort'=>'desc'];
- break;
- }
- $where = [];
- $where[] = ['is_deleted','=',0];
- $where[] = ['status','=',1];
- $where[] = ['release_time','< time',date('Y-m-d H:i:s')];
- switch ($sel_type) {
- case 1:
- $where[] = ['end_time','< time',date('Y-m-d H:i:s')];
- break;
- case 2:
- $where[] = ['start_time','> time',date('Y-m-d H:i:s')];
- break;
- case 3:
- $where[] = ['start_time','< time',date('Y-m-d H:i:s')];
- $where[] = ['end_time','> time',date('Y-m-d H:i:s')];
- break;
- }
- $list = \app\common\model\Activity::field('id,title,cover,start_time,end_time,province,city,county,address')
- ->where($where)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
- $total_num = \app\common\model\Activity::where($where)->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 获取活动详情
- * @desc 获取活动详情
- * @author qc
- * @method GET
- * @url /api/Activity/getActivityDetail
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:-- desc:活动id
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:图片
- * @return name:content type:string default:-- desc:详情
- * @return name:create_at type:string default:-- desc:时间
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:longitude type:string default:-- desc:经度
- * @return name:latitude type:string default:-- desc:纬度
- * @return name:label type:string default:-- desc:标签[多个','隔开]
- * @return name:label_name type:array default:-- desc:标签[数组]
- * @return name:is_apply type:int default:0 desc:是否报名【0否1是】
- * @return name:praise_num type:int default:-- desc:点赞量
- * @return name:is_praise type:int default:-- desc:是否点赞【0否1是】
- * @return name:is_collect type:int default:-- desc:是否收藏【0否1是】
- * @return name:collect_num type:int default:-- desc:收藏量
- * @return name:transmit_num type:int default:-- desc:转发量
- * @return name:pay_offline type:int default:-- desc:是否支持下线支付【0否1是】
- * @return name:app_name type:string default:-- desc:发布方名称
- * @return name:app_logo type:string default:-- desc:发布方头像
- * @return name:read_num type:string default:-- desc:阅读量
- * @return name:release_time type:string default:-- desc:发布时间
- * @return name:offline_user type:string default:-- desc:线下支付户名
- * @return name:offline_bank type:string default:-- desc:线下支付开户行
- * @return name:offline_card type:string default:-- desc:线下支付账号
- * @return name:video_id type:int default:-- desc:视频系列id
- * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
- * @return name:video_jump type:int default:-- desc:关联视频是否能跳转【0不能跳转,1能跳转,验证是否vip】
- *
- * @return name:article_id type:int default:-- desc:图文系列id
- * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
- * @return name:article_jump type:int default:-- desc:关联图文是否能跳转【0不能跳转,1能跳转,验证是否vip】
- * @return name:datum_id type:int default:-- desc:资料id--ppt【系列id】
- * @return name:datum_item type:int default:-- desc:资料id--ppt【系列下的其中一个】
- * @return name:datum_jump type:int default:-- desc:关联资料是否能跳转【0不能跳转,1能跳转,验证是否vip】
- * @return name:datum_url type:int default:-- desc:关联资料链接
- *
- * @return name:price_list type:array default:-- desc:价格设置
- * @return name:price_list.id type:int default:-- desc:价格阶梯记录id
- * @return name:price_list.ladder_title type:string default:-- desc:标题
- * @return name:price_list.ladder_remark type:string default:-- desc:备注
- * @return name:price_list.ladder_price type:float default:-- desc:价格
- * @return name:price_list.ladder_status type:float default:-- desc:当前门票是否下架【0下架,1正常】
- * @return name:price_list.ladder_num type:float default:-- desc:活动票发行量
- * @return name:price_list.stock type:int default:-- desc:剩余票量
- * @return name:price_list.fill_num type:int default:-- desc:满减张数
- * @return name:price_list.sub_money type:float default:-- desc:每张优惠
- * @return name:price_list.is_sh type:int default:-- desc:是否需要审核【1是,0否】
- * @return name:sponsor type:array default:-- desc:主办方信息
- * @return name:sponsor.id type:int default:-- desc:主办方记录id
- * @return name:sponsor.qr_code type:string default:-- desc:二维码
- * @return name:sponsor.cover type:string default:-- desc:主办方logo
- * @return name:sponsor.official_web type:string default:-- desc:主办方官网
- * @return name:sponsor.title type:string default:-- desc:主办方名称
- * @return name:sponsor.address type:string default:-- desc:地址
- * @return name:sponsor.email type:string default:-- desc:email
- * @return name:sponsor.phone type:string default:-- desc:phone
- * @return name:template_list type:array default:-- desc:报名模板信息
- * @return name:template_list.id type:int default:-- desc:报名模板详情id
- * @return name:template_list.title type:string default:-- desc:标题
- * @return name:template_list.type type:string default:-- desc:类型【1input,2文本,3多选】
- * @return name:template_list.value type:string default:-- desc:报名提交填写的内容【1input,2文本】
- * @return name:template_list.required type:int default:-- desc:是否必填【1是,0否】
- * @return name:template_list.extend type:array default:-- desc:多选选项【type=3】
- * @return name:template_list.extend.item_title type:string default:-- desc:选项【type=3】
- *
- * @return name:schedule type:array default:-- desc:活动日程
- * @return name:schedule.title type:string default:-- desc:标题
- * @return name:schedule.date_time type:string default:-- desc:时间
- * @return name:schedule.schedule_list type:array default:-- desc:日程详情
- * @return name:schedule.schedule_list.theme type:string default:-- desc:主题
- * @return name:schedule.schedule_list.theme_time type:string default:-- desc:主题时间
- * @return name:schedule.children type:array default:-- desc:二级日程【数据同上】
- *
- */
- public function getActivityDetail()
- {
- $sel_where[] = ['id','=',input('get.id')];
- $detail = \app\common\model\Activity::where($sel_where)
- ->with(['sponsor','priceList'])
- ->find()->toArray();
- if($detail['is_deleted'] != 0 || $detail['status'] !=1) $this->error('该活动已取消');
- $detail['cover_arr'] = $detail['cover'] ? explode('|',$detail['cover']) : null;
- $detail['label_name'] = $detail['label'] ? explode(',',trim($detail['label'],',')): null;
- $detail['is_apply'] = ActivityApply::checkApply($this->user_id,$detail['id']);
- $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],4);
- $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],4);
- $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,7,$detail['id']);
- $detail['collect_num'] = UserCollect::getCollectNum(7,$detail['id']);
- $detail['transmit_num'] = numTransform($detail['transmit_num']);
- $detail['read_num'] = numTransform($detail['read_num']);
- $detail['article_jump'] = ArticleItem::checkVip($detail['article_item'],$this->user_id);
- $detail['video_jump'] = VideoUrl::checkVip($detail['video_item'],$this->user_id);
- $detail['datum_jump'] = DatumUrl::checkVip($detail['datum_item'],$this->user_id);
- $auth_info = \app\common\model\Activity::getAuth($detail['user_id'],APPNAME,APPLOGO);
- $detail['app_name'] = $auth_info['app_name'];
- $detail['app_logo'] = $auth_info['app_logo'];
- $template_list = ActivityTemplateItem::getList($detail['template_id']);
- array_walk($template_list,function (&$v){
- if($v['type'] == 3 && $v['extend'] )$v['extend'] = json_decode($v['extend']);
- });
- $detail['template_list'] =$template_list;
- $detail['schedule'] = ActivitySchedule::getActivitySchedule($detail['id']);
- \app\common\model\Activity::where('id',$detail['id'])->setInc('read_num');
- UserTrack::crateTrack($this->user_id,7,input('get.id'),0);
- TopSearch::seIncHotNum($detail['id'],$this->request->controller());
- $this->success('ok',['detail'=>$detail]);
- }
- /**
- * @title 活动详情--返回字段少[活动报名]
- * @desc 活动详情
- * @author qc
- * @method GET
- * @url /api/Activity/getActivityDetailSimplify
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:-- desc:活动id
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:图片
- * @return name:create_at type:string default:-- desc:时间
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:pay_offline type:int default:-- desc:是否支持下线支付【0否1是】
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:release_time type:string default:-- desc:发布时间
- * @return name:offline_user type:string default:-- desc:线下支付户名
- * @return name:offline_bank type:string default:-- desc:线下支付开户行
- * @return name:offline_card type:string default:-- desc:线下支付账号
- * @return name:price_list type:array default:-- desc:价格设置
- * @return name:price_list.id type:int default:-- desc:价格阶梯记录id
- * @return name:price_list.ladder_title type:string default:-- desc:标题
- * @return name:price_list.ladder_remark type:string default:-- desc:备注
- * @return name:price_list.ladder_price type:float default:-- desc:价格
- * @return name:price_list.ladder_num type:float default:-- desc:活动票发行量
- * @return name:price_list.stock type:float default:-- desc:剩余票量
- * @return name:price_list.is_sh type:float default:-- desc:是否需要审核【1是,0否】
- * @return name:price_list.fill_num type:int default:-- desc:满减张数
- * @return name:price_list.sub_money type:float default:-- desc:每张优惠
- * @return name:sponsor type:array default:-- desc:主办方信息
- * @return name:sponsor.id type:int default:-- desc:主办方记录id
- * @return name:sponsor.qr_code type:string default:-- desc:二维码
- * @return name:sponsor.cover type:string default:-- desc:主办方logo
- * @return name:sponsor.official_web type:string default:-- desc:主办方官网
- * @return name:sponsor.title type:string default:-- desc:主办方名称
- * @return name:sponsor.address type:string default:-- desc:地址
- * @return name:sponsor.email type:string default:-- desc:email
- * @return name:sponsor.phone type:string default:-- desc:phone
- * @return name:template_list type:array default:-- desc:报名模板信息
- * @return name:template_list.id type:int default:-- desc:报名模板详情id
- * @return name:template_list.title type:string default:-- desc:标题
- * @return name:template_list.type type:string default:-- desc:类型【1input,2文本,3多选】
- * @return name:template_list.value type:string default:-- desc:报名提交填写的内容【1input,2文本】
- * @return name:template_list.required type:int default:-- desc:是否必填【1是,0否】
- * @return name:template_list.extend type:array default:-- desc:多选选项【type=3】
- * @return name:template_list.extend.item_title type:string default:-- desc:选项【type=3】
- */
- public function getActivityDetailSimplify()
- {
- $sel_where[] = ['id','=',input('get.id')];
- $detail = \app\common\model\Activity::where($sel_where)
- ->field('id,sponsor_id,title,cover,create_at,start_time,end_time,province,city,county,address,template_id,pay_offline,offline_user,offline_bank,offline_card')
- ->with(['sponsor','priceList'])
- ->find()->toArray();
- $template_list = ActivityTemplateItem::getList($detail['template_id']);
- array_walk($template_list,function (&$v){
- if($v['type'] == 3 && $v['extend'] )$v['extend'] = json_decode($v['extend']);
- });
- $detail['template_list'] =$template_list;
- $this->success('ok',['detail'=>$detail]);
- }
- /**
- * @title 点赞||取消点赞
- * @desc 点赞||取消点赞
- * @author qc
- * @method POST
- * @url /api/Activity/activityTags
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:1 desc:活动id
- * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
- */
- public function activityTags()
- {
- $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),4);
- $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
- }
- /**
- * @title 收藏||取消收藏
- * @desc 用户收藏
- * @author qc
- * @method POST
- * @url /api/Activity/activityCollect
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int require:1 default:-- desc:活动id
- * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
- */
- public function activityCollect(){
- $coll_status = UserCollect::plateCollect($this->user_id,7,input('post.id',0));
- $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
- }
- /**
- * @title 活动转发(转发数量统计)
- * @desc 转发成功后调用
- * @author qc
- * @method POST
- * @url /api/Activity/activityTransmit
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:-- desc:活动id
- */
- public function activityTransmit()
- {
- $activity_id = input('post.id',0);
- \app\common\model\Activity::where('id',$activity_id)->setInc('transmit_num');
- $this->success('ok');
- }
- /**
- * @title 获取报名实例
- * @desc 获取报名实例
- * @author qc
- * @method GET
- * @url /api/Activity/getApplyData
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:-- desc:活动id
- */
- public function getApplyData()
- {
- $sel_where[] = ['id','=',input('get.id')];
- $detail = \app\common\model\Activity::where($sel_where)
- ->field('id,sponsor_id,title,cover,create_at,start_time,end_time,province,city,county,address,template_id')
- ->with(['sponsor','priceList'])
- ->find()->toArray();
- $template_list = ActivityTemplateItem::getList($detail['template_id']);
- $user_info = $this->userInfo();
- $apply_data = [];
- array_walk($template_list,function (&$v)use ($user_info){
- if(in_array($v['type'],[1,2])) $v['value'] = '填写'.$v['title'];
- if($v['type'] == 3 && $v['extend'] ) {
- $extend = json_decode($v['extend'],true);
- foreach ($extend as &$ev) {
- $ev['value'] = 1;
- }
- $v['extend'] =$extend;
- }
- });
- $apply_data[] = [
- 'price_id' => $detail['price_list'][0]['id'],
- 'name' => $user_info['name'],
- 'phone_pre' => $user_info['phone_pre'],
- 'phone' => $user_info['phone'],
- 'email' => '123456@qq.com',
- 'num' => 1,
- 'code' => 1,
- 'phone_code' => 123456,
- 'template_list' => $template_list,
- ];
- $apply_data[] = [
- 'price_id' => $detail['price_list'][0]['id'],
- 'name' => $user_info['name'],
- 'phone_pre' => $user_info['phone_pre'],
- 'phone' => $user_info['phone'],
- 'email' => '123456@qq.com',
- 'num' => 1,
- 'code' => 1,
- 'phone_code' => 123456,
- 'template_list' => $template_list,
- ];
- $bill_info = BillHeader::where('id',1)->field('type,header,identify_number,bank,card_no,phone,email,address,remark')->find()->toArray();
- $this->success('ok',[
- 'apply_json'=>json_encode($apply_data,JSON_UNESCAPED_UNICODE),
- 'apply_array'=>$apply_data,
- 'template_json'=>json_encode($template_list,JSON_UNESCAPED_UNICODE),
- 'bill_info'=>json_encode($bill_info,JSON_UNESCAPED_UNICODE),
- ]);
- }
- /**
- * @title 活动报名【生成订单】
- * @desc 活动报名[生成订单(报名记录),返回支付信息]
- * @author qc
- * @method POST
- * @url /api/Activity/activityApply
- * @header name:Authorization require:1 desc:Token
- * @param name:act_id type:int default:-- desc:活动id
- * @param name:tg type:string default:-- desc:推广参数
- * @param name:phone type:int default:-- desc:下单人手机号【未登录必填】
- * @param name:phone_pre type:string default:-- desc:下单人手机号前缀【未登录必填】
- * @param name:phone_code type:string default:-- desc:下单人手机号验证码【未登录必填】
- * @param name:pay_type type:int require:1 default:0 desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付,6微信pc,7pc支付宝,9线下支付)
- * @param name:apply_data type:string default:-- desc:报名信息
- * @param name:apply_data.price_id type:int default:-- desc:价格id
- * @param name:apply_data.name type:string default:-- desc:联系人
- * @param name:apply_data.phone_pre type:string default:-- desc:手机号前缀
- * @param name:apply_data.phone type:string default:-- desc:联系人电话
- * @param name:apply_data.email type:string default:-- desc:email
- * @param name:apply_data.num type:int default:-- desc:数量
- * @param name:apply_data.code type:int default:-- desc:第几张票
- * @param name:apply_data.phone_code type:int default:-- desc:短信验证码
- * @param name:apply_data.template_list type:string default:-- desc:报名模板信息【活动模板填完值之后的json】
- * @param name:bill_info type:string default:-- desc:发票信息--json【不开票可以不传】
- * @param name:bill_info.type type:int default:-- desc:类型id
- * @param name:bill_info.header type:string default:-- desc:抬头名称[公司名称||个人名称]
- * @param name:bill_info.identify_number type:string default:-- desc:纳税人识别号
- * @param name:bill_info.email type:string default:-- desc:邮箱
- * @param name:bill_info.remark type:string default:-- desc:备注
- *
- * @param name:address_info type:string default:-- desc:收货信息--json【非物流不传】
- * @param name:address_info.type type:int require:1 default:-- desc:领取方式【1现场2快递】
- * @param name:address_info.send_type type:int require:1 default:-- desc:申请类型【1点子发票2纸质发票】
- * @param name:address_info.pro_name type:string require:1 default:-- desc:省名【快递必传】
- * @param name:address_info.city_name type:string require:1 default:-- desc:市名【快递必传】
- * @param name:address_info.county_name type:string require:1 default:-- desc:县区名【快递必传】
- * @param name:address_info.detail type:string require:0 default:-- desc:详细地址【快递必传】
- * @param name:address_info.phone type:string require:1 default:-- desc:联系电话【快递必传】
- * @param name:address_info.name type:string require:1 default:-- desc:联系人【快递必传】
- *
- * @return name:pay_status type:int default:0 desc:该值为1:订单金额是0不需要支付!!!
- * @return name:config type:array default:0 desc:支付配置
- * @return name:config.appId type:string default:-- desc:公众账号ID
- * @return name:config.signType type:string default:-- desc:签名类型
- *
- * @return name:config.appId type:string default:-- desc:appID【h5】
- * @return name:config.paySign type:string default:-- desc:签名【h5】
- * @return name:config.nonceStr type:string default:-- desc:随机字符串【h5】
- * @return name:config.timeStamp type:string default:-- desc:时间戳【h5】
- * @return name:config.appid type:string default:-- desc:appid【微信APP】
- * @return name:config.sign type:string default:-- desc:签名【微信APP】
- * @return name:config.noncestr type:string default:-- desc:随机字符串【微信APP】
- * @return name:config.timestamp type:string default:-- desc:时间戳【微信APP】
- *
- * @return name:config.partnerid type:string default:-- desc:商户号
- * @return name:config.prepayid type:string default:-- desc:唯一支付号
- *
- * @return name:config.package type:string default:-- desc:package
- * @return name:config.mch_id type:string default:-- desc:商户号(H5)
- * @return name:config.pay_no type:string default:-- desc:订单支付号(H5)
- * @return name:config.notify_url type:string default:-- desc:回调地址(H5)
- * @return name:config.total_fee type:int default:-- desc:支付金额(分!!!)
- * @return name:code_url type:string default:-- desc:付款码url
- * @return name:openid type:string default:-- desc:openid
- *
- */
- public function activityApply()
- {
- $act_id = input('post.act_id');
- $tg = input('post.tg','');
- $pay_type = input('post.pay_type',1);
- $act_info = \app\common\model\Activity::where('id',$act_id)->where('is_deleted',0)->find();
- if(!$act_info) $this->error('活动不存在');
- if(strtotime($act_info->end_time) < time() ) $this->error('活动已经结束');
- if(strtotime($act_info->start_time) < time() ) $this->error('活动已经开始');
- if($act_info->status == 2) $this->error('活动已经取消');
- if($act_info->status == 0) $this->error('活动已经下架');
- if($act_info->pay_offline == 0 && $pay_type == 9) $this->error('活动不支持线下支付');
- if(!$this->user_id) {
- $phone = input('post.phone');
- $phone_pre = input('post.phone_pre','86');
- $phone_code = input('post.phone_code');
- if(empty($phone)) $this->error('请填写支付人手机号'.$phone);
- if(empty($phone_code)) $this->error('请填写支付人手机号验证码:'.$phone_code);
- $check_code = $this->checkPhoneCode($phone,$phone_code,$phone_pre);
- if(!$check_code) $this->error('验证码错误');
- $this->updatePhoneCode($check_code);
- $user_info = User::getUserInfo($phone,$phone_pre);
- $this->user_id = $user_info['id'];
- if(empty($user_info)) $this->error('该手机号被禁用');
- }else{
- $user_info = $this->userInfo();
- }
- // 订单详情
- $apply_info = [
- 'user_id' => $this->user_id,
- 'order_no' => get_order_sn(),
- 'pay_no' => get_order_sn(),
- 'name' => $user_info['name'],
- 'phone' => $user_info['phone'],
- 'phone_pre' => $user_info['phone_pre'],
- 'pay_type' => $pay_type,
- 'act_id' => $act_id,
- 'tg_id' => $tg ? Db::name('activity_qrcode')->where('tg_param',$tg)->max('id'): 0,
- ];
- $apply_item = [];
- $post_apply = input('post.apply_data');
- $post_bill = input('post.bill_info');
- $post_address = input('post.address_info');
- $apply_data = json_decode(stripslashes($post_apply),true);
- $bill_info = json_decode(stripslashes($post_bill),true);
- $address_info = json_decode(stripslashes($post_address),true);
- if(empty($apply_data)) $this->error('请填写报名信息');
- $ret_data = ['pay_status'=>0,'config'=>null,'code_url'=>'','openid'=>$user_info['openid'],'order_id'=>0];
- Db::startTrans();
- try {
- $cl_apply = [];
- array_walk($apply_data,function (&$cv)use (&$cl_apply){
- if(isset($cl_apply[$cv['price_id']])){
- $cl_apply[$cv['price_id']]++;
- } else{
- $cl_apply[$cv['price_id']] = 1;
- }
- });
- array_walk($apply_data,function (&$v)use (&$apply_item,$act_id,$cl_apply){
- $v['buy_total'] = $cl_apply[$v['price_id']];
- // 验证码验证
- //$check_code = $this->checkPhoneCode($v['phone'],$v['phone_code'],$v['phone_pre']);
- // if(!$check_code) $this->exception($v['phone'].'验证码错误');
- //$this->updatePhoneCode($check_code);
- // 会员验证
- $user_item = User::getUserInfo($v['phone'],$v['phone_pre'] ? $v['phone_pre'] : 86);
- if(empty($user_item)) $this->exception($v['phone'].'被禁用');
- // 售票验证
- // var_dump($v['price_id']);
- $price_info = ActivityPrice::where('id',$v['price_id'])->find()->toArray();
- if($price_info['ladder_status'] != 1) $this->exception($price_info['ladder_title'].'已下架');
- if($price_info['stock'] <= 0) $this->exception($price_info['ladder_title'].'已售罄');
- // 扣减库存
- ActivityPrice::where('id',$price_info['id'])->setDec('stock',$v['num']);
- // var_dump($v['template_list']);
- // 报名模板验证
- foreach ($v['template_list'] as &$tv) {
- if($tv['required'] && in_array($tv['type'],[1,2]) && !$tv['value'] ) $this->exception($tv['title'].'必填');
- if($tv['required'] && in_array($tv['type'],[3])) {
- $extend = is_array($tv['extend']) ? $tv['extend'] : json_decode($tv['extend']);
- $sel_extend = array_sum(array_column($extend,'value'));
- if(!$sel_extend) $this->exception($tv['title'].'必选');
- }
- }
- // 票详情
- $apply_item[] = [
- 'user_id' => $user_item['id'],
- 'act_id' => $act_id,
- 'price_id' => $v['price_id'],
- 'num' => $v['num'],
- 'name' => $v['name'],
- 'phone' => $v['phone'],
- 'code' => isset($v['code']) ? $v['code'] : 1,
- 'email' => $v['email'],
- 'sh_status' => $price_info['is_sh'] ? 0 : 1 ,
- 'price_sh' => $price_info['is_sh'] ,
- 'money' => $price_info['fill_num'] > 0 && $v['buy_total'] >= $price_info['fill_num'] ? bcmul($price_info['ladder_price']- $price_info['sub_money'],$v['num'],2) : bcmul($price_info['ladder_price'],$v['num'],2),
- 'total_money' => bcmul($price_info['ladder_price'],$v['num'],2),
- 'extend' => json_encode($v['template_list'],JSON_UNESCAPED_UNICODE),
- ];
- });
- $apply_info['money'] = array_sum(array_column($apply_item,'money'));
- $apply_info['total_money'] = array_sum(array_column($apply_item,'total_money'));
- $apply_info['num'] = array_sum(array_column($apply_item,'num'));
- if($apply_info['money'] < 0) $this->exception('金额错误');
- // 主订单写入
- $order_info = ActivityApply::create($apply_info)->toArray();
- array_walk($apply_item,function (&$v)use ($order_info){
- $v['apply_id'] = $order_info['id'];
- });
- (new ActivityApplyItem())->saveAll($apply_item);
- if($order_info['money'] == 0) {
- $back_res = OrderCallback::activityOrderCallBack($order_info);// 支付完成后回调
- if(!$back_res['ret_val']) $this->exception($back_res['msg']);
- $ret_data['pay_status'] = 1;
- }else{
- $ret_data['order_id'] = $order_info['id'];
- switch ($pay_type){
- case 1:
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,'MWEB');
- if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
- $pay_config['config']['mch_id'] = config('app.wx_pay')['mch_id'];
- $pay_config['config']['pay_no'] = $order_info['pay_no'];
- $pay_config['config']['notify_url'] = $notify_url;
- $pay_config['config']['mweb_url'] = $pay_config['mweb_url'];
- $pay_config['config']['total_fee'] = $order_info['money'] * 100;
- $ret_data['config'] = $pay_config['config'];
- break;
- case 2:
- $notify_url = $this->request->root(true) . '/api/Alipay/applyOrderNotify';
- $return_url ='https://'.$_SERVER['HTTP_HOST']."/dist/#/my";
- $config = Alipay::ali_pay_h5('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,$return_url);
- $ret_data['config']['ali_url'] = $config;
- $ret_data['ali_url'] = $config;
- break;
- case 3:
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,'APP');
- if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
- $ret_data['config'] = $pay_config['config'];
- break;
- case 4:
- $notify_url = $this->request->root(true) . '/api/Alipay/applyOrderNotify';
- $config = Alipay::ali_pay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url);
- $ret_data['config']['ali_url'] = $config;
- $ret_data['ali_url'] = $config;
- $ret_data['money'] = $order_info['money'];
- break;
- case 5 :
- if(!$user_info['openid']) $this->exception('请绑定openid');
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,'JSAPI',$user_info['openid']);
- if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
- $ret_data['config'] = $pay_config['config'];
- break;
- case 6:
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'] ,$notify_url,'NATIVE');
- $ret_data['config'] = $pay_config['config'];
- $ret_data['code_url'] = $pay_config['pc_pay_url'];
- break;
- case 7:
- $notify_url = $this->request->root(true) . '/api/Alipay/applyOrderNotify';
- $return_url ='https://'.$_SERVER['HTTP_HOST']."/pc";
- $config = Alipay::ali_pay_pc('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,$return_url);
- $ret_data['config']['ali_url'] = $config;
- $ret_data['ali_url'] = $config;
- break;
- }
- }
- //订单需要开票
- if($order_info['money'] > 0 && !empty($bill_info)) {
- // 是否是选择的已有的抬头
- /* if(isset($bill_info['header_id']) && $bill_info['header_id']) {
- $bill_info = BillHeader::where('id',$bill_info['header_id'])->find()->toArray();
- }else{
- $bill_info = BillHeader::saveHeader(array_merge($bill_info,['user_id'=>$user_info['id'],'is_deleted'=>1]));
- }*/
- // 是否有物流地址
- $address_id = 0;
- if(!empty($address_info) && isset($address_info['send_type']) && $address_info['send_type'] == 2 && isset($address_info['type']) && $address_info['type']){
- $address_info = DeliveryAddress::saveAddress(array_merge($address_info,['user_id'=>$user_info['id'],'is_deleted'=>1]));
- $address_id = $address_info['id'];
- }
- $ret_val = UserSynth::buildBillApply($user_info['id'], $order_info['id'], 3,$bill_info,$address_id,1,$bill_info['remark'],0);
- if($ret_val['code'] != 200) $this->exception($ret_val['msg']);
- }
- Db::commit();
- }catch (\Exception $e) {
- Db::rollback();
- $this->error($e->getMessage());
- }
- $this->success('报名成功',$ret_data);
- }
- /**
- * @title 活动报名订单支付
- * @desc 活动报名订单支付
- * @author qc
- * @method POST
- * @url /api/Activity/payApplyOrder
- * @header name:Authorization require:1 desc:Token
- * @param name:order_id type:int default:-- desc:订单id【报名记录id】
- * @param name:pay_type type:int default:-- desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付,9线下支付)
- *
- * @return name:config type:array default:0 desc:支付配置
- * @return name:config.appId type:string default:-- desc:公众账号ID
- * @return name:config.signType type:string default:-- desc:签名类型
- * @return name:config.paySign type:string default:-- desc:签名
- * @return name:config.nonceStr type:string default:-- desc:随机字符串
- * @return name:config.timestamp type:string default:-- desc:时间戳
- * @return name:config.partnerid type:string default:-- desc:商户号
- * @return name:config.prepayid type:string default:-- desc:唯一支付号
- * @return name:config.package type:string default:-- desc:package
- * @return name:config.mch_id type:string default:-- desc:商户号(H5)
- * @return name:config.pay_no type:string default:-- desc:订单支付号(H5)
- * @return name:config.notify_url type:string default:-- desc:回调地址(H5)
- * @return name:config.total_fee type:int default:-- desc:支付金额(分!!!)
- * @return name:code_url type:string default:-- desc:付款码url
- * @return name:openid type:string default:-- desc:openid
- */
- public function payApplyOrder()
- {
- $order_id = input('post.order_id');
- $order_info = ActivityApply::where('id',$order_id)->find()->toArray();
- if($order_info['status'] != 0) $this->error('订单状态错误');
- if($order_info['cancel_state'] != 0 || $order_info['is_deleted'] != 0) $this->error('订单异常');
- if($order_info['money'] <= 0) $this->error('订单金额错误');
- $pay_type = input('post.pay_type',0) ;//$order_info['pay_type'];
- $user_info = User::where('id',$order_info['user_id'])->find();
- $ret_data = ['pay_status'=>0,'config'=>[],'code_url'=>'','openid'=>$user_info['openid'],'order_id'=>0];
- if($pay_type == 9) $this->error('订单为线下支付,请联系管理员');
- Db::startTrans();
- try {
- ActivityApply::where('id',$order_id)->update(['pay_type'=>$pay_type]);
- switch ($pay_type){
- case 1:
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,'MWEB');
- if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
- $pay_config['config']['mch_id'] = config('app.wx_pay')['mch_id'];
- $pay_config['config']['pay_no'] = $order_info['pay_no'];
- $pay_config['config']['notify_url'] = $notify_url;
- $pay_config['config']['mweb_url'] = $pay_config['mweb_url'];
- $pay_config['config']['total_fee'] = $order_info['money'] * 100;
- $ret_data['config'] = $pay_config['config'];
- break;
- case 2:
- $notify_url = $this->request->root(true) . '/api/Alipay/applyOrderNotify';
- $return_url ='https://'.$_SERVER['HTTP_HOST']."/dist/#/my";
- $config = Alipay::ali_pay_h5('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,$return_url);
- $ret_data['config']['ali_url'] = $config;
- $ret_data['ali_url'] = $config;
- break;
- case 3:
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,'APP');
- if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
- $ret_data['config'] = $pay_config['config'];
- break;
- case 4:
- $notify_url = $this->request->root(true) . '/api/Alipay/LevelOrderNotify';
- $config = Alipay::ali_pay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url);
- $ret_data['config']['ali_url'] = $config;
- $ret_data['ali_url'] = $config;
- $ret_data['money'] = $order_info['money'];
- break;
- case 5 :
- if(!$user_info['openid']) $this->exception('请绑定openid');
- $notify_url = $this->request->root(true) . '/api/we_chat_pay/applyOrderNotify';
- $pay_config = WeChatPay::wxPay('订单支付',$order_info['pay_no'],$order_info['money'],$notify_url,'JSAPI',$user_info['openid']);
- if($pay_config['code'] != 200) $this->exception($pay_config['msg']);
- $ret_data['config'] = $pay_config['config'];
- break;
- }
- Db::commit();
- }catch (\Exception $e){
- Db::rollback();
- $this->error($e->getMessage());
- }
- $this->success('ok',$ret_data);
- }
- /**
- * @title 报名详情【订单详情】
- * @desc 报名详情
- * @author qc
- * @method GET
- * @url /api/Activity/getApplyInfo
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:-- desc:订单id
- * @param name:order_no type:string default:-- desc:订单号
- * @param name:pay_no type:string default:-- desc:订单支付号
- * @param name:create_at type:string default:-- desc:创建时间
- * @param name:pay_at type:string default:-- desc:支付时间
- * @param name:status type:int default:-- desc:订单状态【0未支付1已支付2已取消】
- * @param name:money type:float default:-- desc:订单金额
- * @param name:pay_type type:int default:-- desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付,9线下支付)
- * @param name:pay_state type:int default:-- desc:是否支付【0未支付1已支付】
- * @param name:cancel_state type:int default:-- desc:是否取消【0未取消1已取消】
- * @param name:refund_state type:int default:-- desc:退款状态(0未申请1审核中2同意3拒绝4退款成功5退款异常)
- * @param name:phone_pre type:string default:-- desc:phone前缀
- * @param name:phone type:string default:-- desc:phone
- * @param name:cancel_timestamp type:string default:-- desc:支付倒计时(单位秒)【已支付忽略】
- * @return name:sh_num type:int default:-- desc:已核销票数量
- *
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:图片
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:pay_offline type:int default:-- desc:线下支付是否开启【0关闭1开启】
- * @return name:offline_user type:string default:-- desc:线下支付户名
- * @return name:offline_bank type:string default:-- desc:线下支付开户行
- * @return name:offline_card type:string default:-- desc:线下支付账号
- *
- * @return name:item_list type:array default:-- desc:票详情
- * @return name:item_list.id type:array default:-- desc:票详情id
- * @return name:item_list.ladder_title type:string default:-- desc:票标题
- * @return name:item_list.name type:string default:-- desc:名称
- * @return name:item_list.phone type:string default:-- desc:phone
- * @return name:item_list.phone_pre type:string default:-- desc:phone前缀
- * @return name:item_list.email type:string default:-- desc:email
- * @return name:item_list.sh_status type:int default:-- desc:是否需要审核【0待审核,1审核通过,2审核拒绝】
- * @return name:item_list.extend type:array default:-- desc:报名模板信息
- * @return name:sponsor type:array default:-- desc:主办方信息
- * @return name:sponsor.id type:int default:-- desc:主办方记录id
- * @return name:sponsor.qr_code type:string default:-- desc:二维码
- * @return name:sponsor.cover type:string default:-- desc:主办方logo
- * @return name:sponsor.official_web type:string default:-- desc:主办方官网
- * @return name:sponsor.title type:string default:-- desc:主办方名称
- * @return name:sponsor.address type:string default:-- desc:地址
- * @return name:sponsor.email type:string default:-- desc:email
- * @return name:sponsor.phone type:string default:-- desc:phone
- *
- * @return name:bill_info type:array default:-- desc:发票申请信息
- * @return name:bill_info.header type:string default:0 desc:抬头
- * @return name:bill_info.type type:int default:0 desc:发票类型
- * @return name:bill_info.email type:string default:0 desc:邮箱
- * @return name:bill_info.phone type:string default:0 desc:电话
- * @return name:bill_info.bank type:string default:0 desc:开户行
- * @return name:bill_info.card_no type:string default:0 desc:银行账号
- * @return name:bill_info.identify_number type:string default:0 desc:纳税人识别号
- * @return name:bill_info.bill_img type:string default:0 desc:点子发票url
- * @return name:bill_info.send_type type:string default:1 desc:1点子发票2纸质发票
- * @return name:bill_info.remark type:string default:0 desc:备注
- * @return name:express_state type:int default:0 desc:物流状态0未发货1已发货【send_type=1时忽略】
- * @return name:express_company_title type:int default:0 desc:物流公司【send_type=1时忽略】
- * @return name:express_send_no type:int default:0 desc:物流编号【send_type=1时忽略】
- * @return name:express_send_at type:int default:0 desc:发货时间【send_type=1时忽略】
- * @return name:address_info type:array default:0 desc:售货地址详情【send_type=1时忽略】
- * @return name:address_info.pro_name type:string default:-- desc:省名
- * @return name:address_info.city_name type:string default:-- desc:市名
- * @return name:address_info.county_name type:string default:-- desc:县区名
- * @return name:address_info.detail type:string default:-- desc:详细地址
- * @return name:address_info.phone type:string default:-- desc:联系电话
- * @return name:address_info.name type:string default:-- desc:联系人
- */
- public function getApplyInfo()
- {
- $detail = ActivityApply::where(['y.user_id'=>$this->user_id,'y.id'=>input('get.id')])
- ->alias('y')
- ->field('y.*,a.title,a.cover,a.start_time,a.end_time,a.province,y.pay_at,a.city,a.county,a.address,a.sponsor_id,a.pay_offline,a.offline_user,a.offline_bank,a.offline_card')
- ->leftJoin('Activity a','y.act_id = a.id')
- ->with(['itemList'])
- ->find()->toArray();
- $detail['cancel_timestamp'] = $detail['pay_state'] == 0 && $detail['cancel_state'] == 0 && strtotime($detail['create_at']) + 300 - time() > 0 ? strtotime($detail['create_at']) + 300 - time() : 0;
- array_walk($detail['item_list'],function (&$v){
- $v['extend'] = $v['extend'] ? json_decode($v['extend'],true) : null;
- });
- $detail['sh_num'] = ActivityApplyItem::where('apply_id',$detail['id'])->where('is_hx',1)->count();
- $detail['sponsor'] = $detail['sponsor_id'] ? ActivitySponsor::where('id',$detail['sponsor_id'])->find()->toArray() : null;
- $bill_info = BillApply::where(['order_type'=>3,'order_id'=>$detail['id']])->find();
- if($bill_info) {
- $bill_info = $bill_info->toArray();
- if($bill_info['address_info']) $bill_info['address_info'] = json_decode($bill_info['address_info'],true);
- }
- $detail['bill_info'] = !empty($bill_info) ? $bill_info : null;
- $this->success('ok',['detail'=>$detail]);
- }
- /**
- * @title 取消订单
- * @desc 取消订单
- * @author qc
- * @method POST
- * @url /api/Activity/cancelApplyOrder
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:int default:-- desc:活动订单id
- */
- public function cancelApplyOrder()
- {
- $detail = ActivityApply::with(['itemList'])
- ->where([['user_id','=',$this->user_id],['pay_state','=',0],['cancel_state','=',0],['id','=',input('post.id')]])
- ->find();
- if(empty($detail)) $this->error('订单异常');
- $detail= $detail->toArray();
- // if($detail['pay_state'] == 1 && $detail['money'] > 0) $this->error('订单已支付');
- Db::startTrans();
- try {
- ActivityApply::where('id',$detail['id'])->update(['cancel_state'=>1,'status'=>2]);
- foreach ($detail['item_list'] as $it) {
- ActivityPrice::where('id',$it['price_id'])->setInc('stock',$it['num']);
- }
- Db::commit();
- }catch (\Exception $e) {
- Db::rollback();
- $this->error($e->getMessage());
- }
- $this->success('取消成功');
- }
- /**
- * @title 获取角标数量【未读数量统计】
- * @desc 未读数量统计
- * @author qc
- * @method GET
- * @url /api/Activity/getMarkNum
- * @header name:Authorization require:1 desc:Token
- * @return name:order_num type:int default:-- desc:订单数量
- * @return name:apply_num type:int default:-- desc:报名数量
- * @return name:message_num type:int default:-- desc:消息数量
- */
- public function getMarkNum()
- {
- $order_num = 0;
- $apply_num = 0;
- $message_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'is_read'=>0])->where('m.module','in','activity,apply')->alias('m')->count();
- $total_num = $message_num;
- $this->success('ok',compact(['order_num','apply_num','message_num','total_num']));
- }
- /**
- * @title 我的发布列表
- * @desc 我的发布列表
- * @author qc
- * @method GET
- * @url /api/Activity/getMyActivityList
- * @header name:Authorization require:1 desc:Token
- * @param name:title type:string default:-- desc:搜索关键字
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:海报
- * @return name:release_time type:string default:-- desc:发布时间
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:status type:int default:-- desc:活动状态【0已下架,1正常】
- * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
- */
- public function getMyActivityList(){
- $title = input('get.title');
- $list = \app\common\model\Activity::where(['is_deleted'=>0,'user_id'=>$this->user_id])
- ->field('id,title,cover,start_time,end_time,province,city,county,address,status,release_time')
- ->when($title,function ($query)use($title){
- if($title) $query->where('title|label','like','%'.$title.'%');
- })->order( ['id'=>'desc'])->limit($this->off_set,$this->page_num)->select()->toArray();
- foreach ($list as &$v) {
- $v['is_normal'] = CheckPower::checkModulesPower($v['id'],0,$this->request->controller());
- }
- $total_num = \app\common\model\Activity::where(['is_deleted'=>0,'user_id'=>$this->user_id])->when($title,function ($query)use($title){
- if($title) $query->where('title|label','like','%'.$title.'%');
- })->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 我的收藏【活动】
- * @desc 我的收藏
- * @author qc
- * @method GET
- * @url /api/Activity/getCollectActivity
- * @header name:Authorization require:1 desc:Token
- * @param name:title type:string default:-- desc:标题
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @return name:activity_id type:string default:-- desc:活动id
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:海报
- * @return name:release_time type:string default:-- desc:发布时间
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:status type:int default:-- desc:活动状态【0已下架,1正常】
- */
- public function getCollectActivity()
- {
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.coll_type','=',7];
- $list = UserCollect::where($sel_where)
- ->alias('t')
- ->field('t.id,t.create_at,t.coll_id activity_id,i.title,i.cover,i.start_time,i.end_time,i.address,i.province,i.city,i.county,i.status,i.release_time')
- ->leftJoin('Activity i','t.coll_id = i.id')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['is_normal'] = CheckPower::checkModulesPower($v['activity_id'],0,$this->request->controller());
- }
- $total_num = UserCollect::where($sel_where)->alias('t')->leftJoin('Activity i','t.coll_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 浏览记录【活动】
- * @desc 浏览记录
- * @author qc
- * @method GET
- * @url /api/Activity/getActivityTrack
- * @header name:Authorization require:1 desc:Token
- * @param name:title type:string default:-- desc:标题
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @return name:title type:string default:-- desc:标题
- * @return name:activity_id type:string default:-- desc:活动id
- * @return name:title type:string default:-- desc:标题
- * @return name:cover type:string default:-- desc:海报
- * @return name:release_time type:string default:-- desc:发布时间
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:time type:string default:-- desc:浏览时间
- * @return name:status type:int default:-- desc:活动状态【0已下架,1正常】
- * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
- */
- public function getActivityTrack()
- {
- $sel_where = [];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.type','=',7];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $list = UserTrack::where($sel_where)
- ->alias('t')
- ->field('t.id,t.update_int,t.first_id activity_id,i.title,i.cover,i.start_time,i.end_time,i.address,i.province,i.city,i.county,i.status,i.release_time')
- ->leftJoin('Activity i','t.first_id = i.id')
- ->order('update_int desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
- $v['is_normal'] = CheckPower::checkModulesPower($v['activity_id'],0,$this->request->controller());
- }
- $total_num = UserTrack::where($sel_where)->alias('t') ->leftJoin('Activity i','t.first_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 我的点赞【活动】
- * @desc 我的点赞
- * @author qc
- * @method GET
- * @url /api/Activity/getTagsActivity
- * @header name:Authorization require:1 desc:Token
- * @param name:title type:string default:-- desc:标题
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @return name:title type:string default:-- desc:标题
- * @return name:activity_id type:string default:-- desc:活动id
- * @return name:cover type:string default:-- desc:图片多张|隔开
- * @return name:cover_arr type:array default:-- desc:图片多张[数组]
- * @return name:content type:string default:-- desc:详情
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:address type:string default:-- desc:地址
- * @return name:price type:float default:-- desc:价格
- * @return name:label type:string default:-- desc:标签[多个','隔开]
- * @return name:label_name type:array default:-- desc:标签[数组]
- * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
- */
- public function getTagsActivity()
- {
- $sel_where = [];
- $title = input('get.title');
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['t.type','=',4];
- $list = PlatformLike::where($sel_where)
- ->alias('t')
- ->field('t.id,t.create_at,t.like_id activity_id,i.title,i.cover,i.label,i.content,i.start_time,i.end_time,i.address,i.price')
- ->leftJoin('Activity i','t.like_id = i.id')
- ->order('id desc')
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['cover_arr'] = $v['cover'] ? explode('|',$v['cover']) : null;
- $v['label_name'] = $v['label'] ? explode(',',trim($v['label'],',')): null;
- $v['is_normal'] = CheckPower::checkModulesPower($v['activity_id'],0,$this->request->controller());
- }
- $total_num = PlatformLike::where($sel_where)->alias('t')->leftJoin('Activity i','t.like_id = i.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 我的报名【门票列表】
- * @desc 我的报名
- * @author qc
- * @method GET
- * @url /api/Activity/getApplyList
- * @header name:Authorization require:1 desc:Token
- * @param name:sel_type type:int default:-- desc:查询类型(1报名成功2审核中,3报名失败)
- * @param name:title type:string default:-- desc:标题
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @return name:title type:string default:-- desc:标题
- * @return name:activity_id type:string default:-- desc:活动id
- * @return name:status type:int default:-- desc:活动状态1正常2取消
- * @return name:cover type:string default:-- desc:图片
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:sh_status type:int default:-- desc:审核【0待审核,1审核通过,2审核拒绝】
- * @return name:is_hx type:int default:-- desc:是否核销(签到)【0未核销,1已核销】
- * @return name:qr_code type:string default:-- desc:核销二维码
- * @return name:qr_content type:string default:-- desc:核销码
- * @return name:activity_title type:string default:-- desc:活动标题
- * @return name:sponsor_title type:string default:-- desc:举办方
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:video_id type:int default:-- desc:视频系列id
- * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
- * @return name:video_jump type:int default:-- desc:关联视频是否能跳转【0不能跳转,1能跳转,验证是否vip】
- *
- * @return name:article_id type:int default:-- desc:图文系列id
- * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
- * @return name:article_jump type:int default:-- desc:关联图文是否能跳转【0不能跳转,1能跳转,验证是否vip】
- * @return name:datum_id type:int default:-- desc:资料id--ppt【系列id】
- * @return name:datum_item type:int default:-- desc:资料id--ppt【系列下的其中一个】
- * @return name:datum_jump type:int default:-- desc:关联资料是否能跳转【0不能跳转,1能跳转,验证是否vip】
- * @return name:datum_url type:int default:-- desc:关联资料链接
- * @return name:label type:string default:-- desc:标签[多个','隔开]
- * @return name:label_name type:array default:-- desc:标签[数组]
- * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
- */
- public function getApplyList()
- {
- $sel_where = [];
- $title = input('get.title');
- $sel_type = input('get.sel_type',1);
- if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
- $sel_where[] = ['t.user_id','=',$this->user_id];
- $sel_where[] = ['a.cancel_state','=',0];
- $sel_where[] = ['a.pay_state','=',1];
- $sel_where[] = ['t.is_deleted','=',0];
- switch ($sel_type) {
- case 1:
- $sel_where[] = ['t.sh_status','=',1];
- break;
- case 2:
- $sel_where[] = ['t.sh_status','=',0];
- break;
- case 3:
- $sel_where[] = ['t.sh_status','=',2];
- break;
- }
- $list = ActivityApplyItem::where($sel_where)
- ->field('t.id,a.order_no,t.act_id activity_id,t.sh_status,a.cancel_state,t.status,t.is_hx,i.title,i.status,i.cover,i.label,i.start_time,i.end_time,i.address,i.price,i.video_id,i.video_item,i.article_id,i.article_item,i.datum_id,i.datum_item,i.province,i.city,i.county,i.address')
- ->alias('t')
- ->leftJoin('Activity i','t.act_id = i.id')
- ->leftJoin('ActivityApply a','a.id = t.apply_id')
- ->order(['t.id'=>'desc'])
- ->limit($this->off_set,$this->page_num)
- ->select()->toArray();
- foreach ($list as &$v) {
- $v['article_jump'] = ArticleItem::checkVip($v['article_item'],$this->user_id);
- $v['video_jump'] = VideoUrl::checkVip($v['video_item'],$this->user_id);
- $v['datum_jump'] = DatumUrl::checkVip($v['datum_item'],$this->user_id);
- $v['label_name'] = $v['label'] ? explode(',',trim($v['label'],',')): null;
- $v['is_normal'] = CheckPower::checkModulesPower($v['activity_id'],0,$this->request->controller());
- }
- $total_num = ActivityApplyItem::where($sel_where)
- ->alias('t')
- ->leftJoin('Activity i','t.act_id = i.id')
- ->leftJoin('ActivityApply a','a.id = t.apply_id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 获取门票详情
- * @desc 获取门票详情
- * @author qc
- * @url /api/Activity/getTicketInfo
- * @method GET
- * @param name:id type:int require default:-- desc:门票id
- * @return name:id type:array default:-- desc:票详情id
- * @return name:ladder_title type:string default:-- desc:票标题
- * @return name:status type:string default:-- desc:票状态【0未支付1已支付2已取消3退款处理中4已退款】
- * @return name:phone type:string default:-- desc:phone
- * @return name:phone_pre type:string default:-- desc:phone前缀
- * @return name:email type:string default:-- desc:email
- * @return name:sh_status type:int default:-- desc:审核【0待审核,1审核通过,2审核拒绝】
- * @return name:is_hx type:int default:-- desc:是否核销(签到)【0未核销,1已核销】
- * @return name:hx_time type:string default:-- desc:核销时间
- * @return name:qr_code type:string default:-- desc:核销二维码
- * @return name:qr_content type:string default:-- desc:核销码
- * @return name:activity_title type:string default:-- desc:活动标题
- * @return name:sponsor_title type:string default:-- desc:举办方
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:refund_info type:array default:-- desc:退款信息【无退款信息是null】
- * @return name:refund_info.status type:int default:-- desc:0待审核1同意退款2审核拒绝3通过且退款4退款异常5取消申请
- */
- public function getTicketInfo()
- {
- $item_id = input('get.id');
- $info = ActivityApplyItem::where('i.id',$item_id) ->where('i.user_id',$this->user_id)
- ->field('i.id,i.status,i.is_deleted,i.name,i.act_id,i.phone,sh_status,i.email,i.qr_code,i.code,i.is_hx,i.hx_time,qr_content,i.phone_pre,a.pay_state,c.title activity_title,c.start_time,c.end_time,s.title sponsor_title,c.province,c.city,c.county,c.address')
- ->alias('i')
- ->leftJoin('ActivityApply a','a.id = i.apply_id')
- ->leftJoin('Activity c','c.id = i.act_id')
- ->leftJoin('ActivitySponsor s','s.id = c.sponsor_id')
- ->find()->toArray();
- if($info['is_deleted'] == 1) $this->error('门票详情有误');
- $info['refund_info'] = GoodsOrderRefund::getActivityRefund($item_id);
- // if(!$info['pay_state']) $this->error('订单未支付');
- $this->success('ok',['detail'=>$info]);
- }
- /**
- * @title 门票核销
- * @desc 门票核销
- * @author qc
- * @url /api/Activity/hxOrder
- * @method POST
- * @param name:qr_content type:int require default:-- desc:核销码内容
- */
- public function hxOrder(){
- $qr_content = input('post.qr_content');
- if(!$qr_content) $this->error('没有核销内容');
- if(!$this->user_info['is_hx'])$this->error('没有核销权限');
- $item_info = ActivityApplyItem::where(['i.qr_content'=>$qr_content,'is_hx'=>0])
- ->alias('i')->field('i.id,i.is_hx,i.status,i.apply_id,i.is_deleted,a.status,a.cancel_state,a.pay_state,a.refund_state')
- ->leftJoin("ActivityApply a",'a.id = i.apply_id')->find();
- if(!$item_info) $this->error('没有找到核销记录');
- if($item_info->cancel_state)$this->error('订单已取消');
- $refund_info = StoreOrderRefund::getRefundInfo($item_info['apply_id'],$item_info['id'],1);
- if(!empty($refund_info && in_array($refund_info['status'],[0,1,3,5])))$this->error('已申请退款');
- if(!in_array($item_info->refund_state,[0,3]))$this->error('订单已申请退款');
- if(!in_array($item_info->status,[1]))$this->error('票状态异常');
- ActivityApplyItem::where('id',$item_info['id'])->update(['is_hx'=>1,'ticket_status'=>1,'hx_user'=>$this->user_id,'hx_time'=>date("Y-m-d H:i:s")]);
- $this->success('核销成功');
- }
- /**
- * @title 申请退款
- * @desc 申请退款
- * @author qc
- * @url /api/Activity/applyRefund
- * @method POST
- * @param name:order_id type:int require default:-- desc:订单id
- */
- public function applyRefund()
- {
- $order_id = input('order_id');
- $res = \app\common\service\Activity::orderRefundApply($order_id);
- $res['code'] == 200 ? $this->success($res['msg']) : $this->error($res['msg']);
- }
- /**
- * @title 取消申请退款
- * @desc 取消申请退款
- * @author qc
- * @url /api/Activity/applyRefund
- * @method POST
- * @param name:order_id type:int require default:-- desc:订单id
- */
- public function cancelRefund()
- {
- $order_id = input('order_id');
- $order_info = ActivityApply::where('id',$order_id)->where('user_id',$this->user_id)->find();
- if(empty($order_info)) $this->error('订单不存在');
- if(in_array($order_info['refund_state'],[5]))$this->error('订单已退款');
- StoreOrderRefund::where(['order_id'=>$order_id,'source'=>1,'type'=>1])->update(['status'=>5]);
- ActivityApply::where('id',$order_id)->update(['status'=>6]);
- $this->success('取消成功');
- }
- /**
- * @title 获取发票详情
- * @desc 获取发票详情
- * @author qc
- * @url /api/Activity/getBillInfo
- * @method GET
- * @param name:id type:int require default:-- desc:订单id
- * @return name:id type:array default:-- desc:票详情id
- * @return name:header type:string default:0 desc:抬头
- * @return name:type_title type_title:int default:0 desc:发票类型
- * @return name:email type:string default:0 desc:邮箱
- * @return name:create_at type:string default:0 desc:申请时间
- * @return name:phone type:string default:0 desc:电话
- * @return name:bank type:string default:0 desc:开户行
- * @return name:status type:int default:0 desc:状态(0申请中1已开票2已完成【现场领取或是确认收货】)
- * @return name:card_no type:string default:0 desc:银行账号
- * @return name:identify_number type:string default:0 desc:纳税人识别号
- * @return name:send_type type:string default:1 desc:1点子发票2纸质发票
- * @return name:remark type:string default:0 desc:备注
- * @return name:bill_img type:string default:0 desc:点子发票【图片】
- * @return name:bill_time type:string default:0 desc:开票时间
- * @return name:address type:string default:0 desc:公司地址
- * @return name:order_pay type:string default:0 desc:订单是否已支付【0未支付1已支付】
- * @return name:express_state type:int default:0 desc:物流状态0未发货1已发货【send_type=1时忽略】
- * @return name:express_company_title type:int default:0 desc:物流公司【send_type=1时忽略】
- * @return name:express_send_no type:int default:0 desc:物流编号【send_type=1时忽略】
- * @return name:express_send_at type:int default:0 desc:发货时间【send_type=1时忽略】
- * @return name:address_info type:array default:0 desc:售货地址详情【send_type=1时忽略】
- * @return name:address_info.pro_name type:string default:-- desc:省名
- * @return name:address_info.city_name type:string default:-- desc:市名
- * @return name:address_info.county_name type:string default:-- desc:县区名
- * @return name:address_info.detail type:string default:-- desc:详细地址
- * @return name:address_info.phone type:string default:-- desc:联系电话
- * @return name:address_info.name type:string default:-- desc:联系人
- *
- */
- public function getBillInfo()
- {
- //'order_type'=>3,
- $info = BillApply::where(['b.id'=>input('get.id')])
- ->alias('b')->field('b.*,t.title type_title,a.money')
- ->leftJoin('BillType t','t.id = b.type')
- ->leftJoin('ActivityApply a','a.id = b.order_id')
- ->find();
- if(empty($info)) $this->error('该订单未申请发票');
- $info = $info->toArray();
- if($info['address_info']) $info['address_info'] = json_decode($info['address_info'],true);
- $this->success('ok',['detail'=>$info]);
- }
- /**
- * @title 获取纸质发票物流详情
- * @desc 获取纸质发票物流详情
- * @author qc
- * @url /api/Activity/deliveryDetails
- * @method GET
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:string require:1 default:-- desc:发票申请详情记录
- * @return name:number type:string default:-- desc:单号
- * @return name:type type:string default:-- desc:快递类型
- * @return name:list type:array default:-- desc:数据列表
- * @return name:list.time type:string default:-- desc:时间
- * @return name:list.status type:string default:-- desc:内容
- * @return name:deliverystatus type:int default:-- desc:0:快递收件(揽件)1.在途中2.正在派件3.已签收4.派送失败5.疑难件6.退件签收
- * @return name:issign type:int default:-- desc:是否签收(1.是否签收)
- * @return name:expName type:string default:-- desc:快递公司名称
- * @return name:expSite type:string default:-- desc:快递公司官网
- * @return name:expPhone type:string default:-- desc:快递公司电话
- * @return name:courier type:string default:-- desc:快递员 或 快递站(没有则为空)
- * @return name:courierPhone type:string default:-- desc:快递员电话 (没有则为空)
- * @return name:updateTime type:string default:-- desc:快递轨迹信息最新时间
- * @return name:takeTime type:string default:-- desc:发货到收货消耗时长 (截止最新轨迹)
- * @return name:logo type:string default:-- desc:快递公司LOGO
- */
- public function deliveryDetails(){
- $this->success('ok', get_delivery());
- $send_no = BillApply::where('id',input('get.id'))->value('express_send_no');
- if(!$send_no) $this->error('订单没有发货');
- $data = get_delivery($send_no);
- $this->success('ok',$data);
- }
- /**
- * @title 订单列表【报名订单列表】
- * @desc 订单列表
- * @author qc
- * @url /api/Activity/getApplyOrderList
- * @method GET
- * @header name:Authorization require:1 desc:Token
- * @param name:sel_type type:int require:1 default:0 desc:0全部1线上订单2转账订单3免费订单
- * @param name:sel_status type:int require:1 default:-1 desc:查询状态-1全部0待支付1已支付3退款中4已取消
- * @return name:id type:string default:-- desc:订单id
- * @return name:title type:string default:-- desc:活动标题
- * @return name:cover type:string default:-- desc:活动海报
- * @return name:start_time type:string default:-- desc:开始时间
- * @return name:end_time type:string default:-- desc:结束时间
- * @return name:province type:string default:-- desc:省
- * @return name:city type:string default:-- desc:市
- * @return name:county type:string default:-- desc:县区
- * @return name:address type:string default:-- desc:地址
- * @return name:money type:float default:-- desc:订单金额
- * @return name:pay_type type:int default:-- desc:支付方式(1.h5微信,2.h5支付宝,3.app微信,4.app支付宝,5.h5微信内支付,9线下支付)
- * @return name:pay_offline type:int default:-- desc:线下支付是否开启【0关闭1开启】
- * @return name:offline_user type:string default:-- desc:线下支付户名
- * @return name:offline_bank type:string default:-- desc:线下支付开户行
- * @return name:offline_card type:string default:-- desc:线下支付账号
- * @return name:pay_state type:int default:-- desc:是否支付【0否1是】
- * @return name:sh_num type:int default:-- desc:已核销票数量
- * @return name:refund_state type:int default:-- desc:退款状态【0未申请1审核中2同意3拒绝4退款异常5退款成功6取消申请】
- * @return name:bill_info type:array default:-- desc:发票申请详情
- * @return name:bill_info.id type:int default:-- desc:发票申请详情id
- */
- public function getApplyOrderList()
- {
- $sel_type = input('get.sel_type',0);
- $sel_status = input('get.sel_status',-1);
- $where = [];
- $where[] = ['o.user_id','=',$this->user_id];
- $where[] = ['o.is_deleted','=',0];
- switch ($sel_type) {
- case 1:
- $where[] = ['o.money','>',0];
- $where[] = ['o.pay_type','in','1,2,3,4,5,6'];
- break;
- case 2:
- $where[] = ['o.money','>',0];
- $where[] = ['o.pay_type','=',9];
- break;
- case 3:
- $where[] = ['o.money','=',0];
- break;
- }
- switch ($sel_status) {
- case 0:
- $where[] = ['o.pay_state','=',0];
- $where[] = ['o.cancel_state','=',0];
- break;
- case 1:
- $where[] = ['o.pay_state','=',1];
- $where[] = ['o.refund_state','=',0];
- break;
- case 3:
- $where[] = ['o.refund_state','in',[1,2,3,4,5]];
- break;
- case 4:
- $where[] = ['o.cancel_state','=',1];
- break;
- }
- //var_dump($where);
- $list = ActivityApply::where($where)
- ->field('o.id,o.money,o.total_money,pay_type,o.pay_state,o.cancel_state,o.refund_state,a.title,a.start_time,a.end_time,a.cover,a.pay_offline,offline_user,offline_bank,offline_card,province,city,county,address')
- ->alias('o')
- ->order('o.id desc')
- ->leftJoin('Activity a','o.act_id = a.id')
- ->select()->toArray();
- array_walk($list,function (&$v){
- $bill_info = BillApply::where(['order_type'=>3,'order_id'=>$v['id']])->find();
- if($bill_info) {
- $bill_info = $bill_info->toArray();
- if($bill_info['address_info']) $bill_info['address_info'] = json_decode($bill_info['address_info'],true);
- }
- $v['bill_info'] = $bill_info;
- $v['sh_num'] = ActivityApplyItem::where('apply_id',$v['id'])->where('is_hx',1)->count();
- });
- $total_num = ActivityApply::where($where) ->alias('o') ->leftJoin('Activity a','o.act_id = a.id')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 删除订单
- * @desc 删除订单
- * @author qc
- * @url /api/Activity/delApplyOrder
- * @method POST
- * @param name:order_id type:int require default:-- desc:订单id
- */
- public function delApplyOrder()
- {
- $order_id = input('order_id');
- ActivityApply::where('id',$order_id)->where('user_id',$this->user_id)->update(['is_deleted'=>1]);
- $this->success('删除成功');
- }
- /**
- * @title 删除门票
- * @desc 删除门票
- * @author qc
- * @url /api/Activity/delTicket
- * @method POST
- * @param name:id type:int require default:-- desc:门票id
- */
- public function delTicket()
- {
- ActivityApplyItem::where('id',input('post.id'))->where('user_id',$this->user_id)->update(['is_deleted'=>1]);
- $this->success('删除成功');
- }
- /**
- * @title 活动消息
- * @desc 活动消息
- * @author qc
- * @url /api/Activity/getMessageList
- * @method GET
- * @param name:page type:int default:0 desc:页数
- * @param name:page_num type:int default:20 desc:每页数
- * @param name:id type:int default:-- desc:消息记录id
- * @return name:content type:string default:-- desc:内容
- * @return name:create_at type:string default:-- desc:时间
- * @return name:relation_id type:int default:-- desc:活动id
- * @return name:type_id type:int default:-- desc:类型标识:1活动报名,2活动变更,3活动提醒,4活动订单
- * @return name:children_id type:int default:-- desc:相关详情id【type_id等于1或3是票的id,type_id等于2是活动id,type_id=4是订单id,type_id=5是申请发票记录id】
- * @return name:is_read type:int default:-- desc:是否已读【0否1是】
- * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
- */
- public function getMessageList()
- {
- $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0])->where('m.module','in','activity,apply')->alias('m')
- ->limit($this->off_set,$this->page_num)->order(['m.id'=>'desc'])
- ->select()->toArray();
- array_walk($list,function (&$v){
- $v['is_normal'] = CheckPower::checkModulesPower($v['relation_id'],0,$v['module']);
- });
- $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0])->where('m.module','in','activity,apply')->alias('m')->count();
- $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
- }
- /**
- * @title 消息已读&&未读变更
- * @desc 支持批量选择
- * @author qc
- * @method POST
- * @url /api/Activity/unreadChange
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:string default:-- desc:记录id(多个逗号隔开,不传修改全部])
- * @param name:is_read type:int default:1 desc:变更类型【0消息变更为未读,1变更为已读】
- */
- public function unreadChange()
- {
- $id = input('post.id');
- $where[] = ['user_id','=',$this->user_id];
- $where[] = ['module','in','activity,apply'];
- if($id) $where[] = ['id','in',$id];
- UserMessage::where($where)->update(['is_read'=>input('post.is_read')]);
- $this->success('消息变更成功');
- }
- /**
- * @title 批量删除||批量取消
- * @desc 删除||取消
- * @author qc
- * @method POST
- * @url /api/Activity/batchesDel
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:string default:1 desc:记录id【多个用逗号隔开=>'1,2'】
- * @param name:type type:string default:1 desc:消息类型【1消息记录删除】
- */
- public function batchesDel()
- {
- $type = input('post.type',1);
- $del_where = [];
- $del_where[] = ['id','in',input('post.id')];
- if(in_array($type,[1])) UserMessage::where($del_where)->update(['is_deleted'=>1,'is_read'=>1]);
- $this->success('操作成功');
- }
- /**
- * @title 申请开票
- * @desc 申请开票
- * @author qc
- * @method POST
- * @url /api/Activity/applyBill
- * @header name:Authorization require:1 desc:Token
- * @param name:id type:string default:1 desc:订单id
- * @param name:bill_info type:string default:-- desc:发票信息
- * @param name:bill_info.type type:int default:-- desc:类型id
- * @param name:bill_info.header type:string default:-- desc:抬头名称[公司名称||个人名称]
- * @param name:bill_info.identify_number type:string default:-- desc:纳税人识别号
- * @param name:bill_info.email type:string default:-- desc:邮箱
- * @param name:bill_info.remark type:string default:-- desc:备注
- *
- * @param name:address_info type:string default:-- desc:收货信息--json【非物流不传】
- * @param name:address_info.type type:int require:1 default:-- desc:领取方式【1现场2快递】
- * @param name:address_info.send_type type:int require:1 default:-- desc:申请类型【1点子发票2纸质发票】
- * @param name:address_info.pro_name type:string require:1 default:-- desc:省名【快递必传】
- * @param name:address_info.city_name type:string require:1 default:-- desc:市名【快递必传】
- * @param name:address_info.county_name type:string require:1 default:-- desc:县区名【快递必传】
- * @param name:address_info.detail type:string require:0 default:-- desc:详细地址【快递必传】
- * @param name:address_info.phone type:string require:1 default:-- desc:联系电话【快递必传】
- * @param name:address_info.name type:string require:1 default:-- desc:联系人【快递必传】
- */
- public function applyBill()
- {
- $order_id = input('post.id');
- $post_bill = input('post.bill_info');
- $post_address = input('post.address_info');
- $bill_info = json_decode(stripslashes($post_bill),true);
- $address_info = json_decode(stripslashes($post_address),true);
- $order_info = ActivityApply::where('id',$order_id)->where('user_id',$this->user_id)->find()->toArray();
- if($order_info['money'] <= 0 ) $this->error('免费订单无法申请开票');
- if(!$order_info['pay_state'])$this->error('订单未支付');
- if(in_array($order_info['refund_state'],[1,2,4,5]))$this->error('订单已申请退款');
- $refund_money = StoreOrderRefund::getRefundMoney($order_id);
- if($refund_money >= $order_info['money'])$this->error('订单已全额退款');
- if(BillApply::checkBillApply($order_id,3)) $this->error('已申请开票');
- $user_info = $this->userInfo();
- // 是否是选择的已有的抬头
- /* if(isset($bill_info['header_id']) && $bill_info['header_id']) {
- $bill_info = BillHeader::where('id',$bill_info['header_id'])->find()->toArray();
- }else{
- $bill_info = BillHeader::saveHeader(array_merge($bill_info,['user_id'=>$user_info['id'],'is_deleted'=>1]));
- }*/
- // 是否有物流地址
- if(!empty($address_info) && isset($address_info['type']) && $address_info['type'] == 2)$address_info = DeliveryAddress::saveAddress(array_merge($address_info,['user_id'=>$user_info['id'],'is_deleted'=>1]));
- $ret_val = UserSynth::buildBillApply($user_info['id'], $order_info['id'], 3,$bill_info,!empty($address_info)&& isset($address_info['type']) && $address_info['type'] == 2 ? $address_info['id']:0,1,$bill_info['remark'],0);
- if($ret_val['code'] != 200) $this->error($ret_val['msg']);
- $this->success('申请成功');
- }
- }
|