params["order_open"]){ echo "该模块尚未开放，敬请期待"; exit; } parent::init(); } public function xiaoshu($num){ if(is_numeric($num)){ $num= explode(".", $num); if(!isset($num[1])){ return $num[0].".00"; }else{ if(strlen($num[1])==1){ return $num[0].".".$num[1]."0"; }else{ return $num[0].".".$num[1]; } } } } public function actionIndex(){ $class_id = safe_replace(Yii::app()->request->getParam('class_id')); $student_id = safe_replace(Yii::app()->request->getParam('student_id')); $status_old=$status = safe_replace(Yii::app()->request->getParam('status')); $semester_id = safe_replace(Yii::app()->request->getParam('semester_id'))?safe_replace(Yii::app()->request->getParam('semester_id')):$this->semesterId; $nianji = safe_replace(Yii::app()->request->getParam('nianji'))?safe_replace(Yii::app()->request->getParam('nianji')):-1; $from = safe_replace(Yii::app()->request->getParam('from')); $classify=0; $type= Yii::app()->request->getParam("type")?Yii::app()->request->getParam("type"):"ordinary"; if($type!=="test"&&$type!=="all"&&$type!=="ordinary"){ Yii::app()->jump->error('参数不正确'); }else{ switch ($type){ case "test": $classify=array(2,20); break; case "all": $classify=1; break; default : $classify=0; break; } } $data = array(); $data['ordertype'] = $type; $order_ids = array(); $class_array = array(); if (Yii::app()->request->getParam('class_id')||Yii::app()->request->getParam('nianji') ||Yii::app()->request->getParam('semester_id') || (Yii::app()->request->getParam('class_id') && Yii::app()->request->getParam('student_id')) || safe_replace(Yii::app()->request->getParam('status'))|| safe_replace(Yii::app()->request->getParam('from'))) { if($semester_id!=="-1"&&($class_id=="-1"||$class_id=="0")){//选了年级并且没选班级 if($nianji=="-1"){ $classs= ClassModel::model()->getClassBySemester($semester_id); }else{ $classs= ClassModel::model()->getClassBySemesternianji($semester_id,$nianji); } if(!empty($classs)){ $class_id=array(); foreach($classs as $v){ $class_id[]=$v['class_id']; } }else{ $class_id=false; } } if($nianji!="-1"&&$class_id==="-1"){ $classarr= ClassModel::model()->findAll("grade=:grade",array(":grade"=>$nianji)); $class_id=array(); foreach($classarr as $v){ $class_id[]=$v['class_id']; } } if($class_id==="-1") { if($status==2) { $status ="0"; }if($status==3) { $status ="2"; } if($status==4) { $status ="3"; } if($classify==0){ $order_data = CMSOrder::model()->getPageByOrderIdList($this->schoolId,$classify,array(),$status,$from); }else{ $order_data = CMSOrder::model()->getPageByOrderIdList($this->schoolId,$classify,array(),$status,-1); } if($order_data){ foreach($order_data['result'] as $v) { $order_ids[$v['id']] = $v['id']; } } } else { // if(!is_array($class_id)&&$class_id){ // if($type!="test"){ // $order_student_data = CMSOrderStudent::model()->getOrderIDByClassId($class_id,$student_id); // }else{ // $order_student_data = CMSOrderClazz::model()->getOrderIDByClassId($class_id); // } // }else if($class_id){ if($class_id){ if(!is_array($class_id)){ $class_id=array($class_id); } if($type!="test"){ $order_student_data = CMSOrderStudent::model()->getOrderIDInClassId($class_id,$student_id); }else{ $class_ids=""; foreach($class_id as $v){ $class_ids.="'".$v."',"; } $class_ids=substr($class_ids,0,strlen($class_ids)-1); $sql="select os.order_id from order_clazz as os join `order` as o on o.id=os.order_id where o.classify in (2,20) and os.clazz_id in (". $class_ids.")"; $order_student_data_1=Yii::app()->db251->createCommand($sql)->queryAll(); $sql="select os.order_id from order_student as os join `order` as o on o.id=os.order_id where o.classify in (2,20) and os.clazz_id in (". $class_ids.")"; $order_student_data=Yii::app()->db251->createCommand($sql)->queryAll(); if($order_student_data_1){ $order_student_data= array_merge($order_student_data_1,$order_student_data); } } }else{ $order_student_data=false; } if($order_student_data) { foreach($order_student_data as $v) { $v=(object)$v; $order_ids[$v->order_id] = $v->order_id; } } if($status=="2") { $status ="0"; }if($status=="3") { $status ="2"; }if($status==4) { $status ="3"; } $student_data = StudentInfo::model()->getStudentInClassId($class_id); if($student_data) { $data['class_student'] = $student_data; } if($order_ids) { if($classify==0){ $order_data = CMSOrder::model()->getPageByOrderIdList($this->schoolId,$classify,$order_ids,$status,$from); }else{ $order_data = CMSOrder::model()->getPageByOrderIdList($this->schoolId,$classify,$order_ids,$status,-1); } }else { $order_data = array(); } } if($status==2){ $status=3; } $data['search'] = array( 'class_id' => Yii::app()->request->getParam('class_id'), 'student_id' => Yii::app()->request->getParam('student_id'), 'status' => $status_old, 'semester_id' => Yii::app()->request->getParam('semester_id'), 'nianji' => Yii::app()->request->getParam('nianji'), 'from' => Yii::app()->request->getParam('from'), ); $data['student_name'] = StudentInfo::model()->getRealname(Yii::app()->request->getParam('student_id')); }else { $order_data = CMSOrder::model()->getPageList($this->schoolId,$classify); if($order_data) { foreach($order_data['result'] as $v) { $order_ids[$v->id] = $v->id; } } $data['search'] = array(); } $work_flow_id=""; if(isset($order_data['result'])){ foreach($order_data['result'] as $v) { if($v->work_flow_id){ $work_flow_id.=$v->work_flow_id.","; } } $work_flow_id=substr($work_flow_id,0,strlen($work_flow_id)-1); } if($work_flow_id){ $sql="SELECT id FROM `order` WHERE work_flow_id IN ( SELECT work_flow_id FROM work_flow_detail WHERE id IN ( SELECT work_flow_detail_id FROM work_flow_user WHERE work_flow_detail_id IN ( SELECT id FROM work_flow_detail WHERE work_flow_id IN ($work_flow_id) ) ) )"; $isdel= Yii::app()->db251->createCommand($sql)->queryAll(); $data['isdel'] =$isdel; } $data['return'] = $order_data; $order_goods_data = CMSOrderGoods::model()->getGoodsByOrderId($order_ids); if($order_goods_data) { foreach($order_goods_data as $v) { $data['goods'][$v->order_id]['gname'] = $v->goods_name; $data['goods'][$v->order_id]['grade'] = $v->grade; } }else { $data['goods'] = ''; } if($type=="all"){ $orderpay= CMSPayment::model()->getOrderPay($order_ids); foreach($orderpay as $k=>$v){ $data['pay'][$v['order_id']][]=$v; } // var_dump($data['pay']);exit; $orderpay= CMSPayment::model()->getOrderPay($order_ids,-1); foreach($orderpay as $k=>$v){ $data['paystatus'][$v['order_id']][]=$v; } }elseif($type=="test"){ if($order_ids){ $arr= Yii::app()->db251->createCommand("select COUNT(DISTINCT clazz_id )as num,sum(students) as stunum,order_id from order_clazz where order_id in (".implode(",", $order_ids).") group by order_id")->queryAll(); $stunum=array(); $classnum=array(); if($arr){ foreach($arr as $k=>$v){ $classnum[$v['order_id']]=$v['num']; $stunum[$v['order_id']]=$v['stunum']; } } $sql="select count(DISTINCT clazz_id) as num,count(student_id) as stunum ,order_id from order_student where order_id in (".implode(",", $order_ids).") GROUP BY order_id"; $arr= Yii::app()->db251->createCommand($sql)->queryAll(); if($arr){ foreach($arr as $k=>$v){ $classnum[$v['order_id']]=$v['num']; $stunum[$v['order_id']]=$v['stunum']; } } $data['classnum']=$classnum; $data['stunum']=$stunum; } }else{ $orderpay= CMSOrderPay::model()->getOrderPay($order_ids); foreach($orderpay as $k=>$v){ $data['pay'][$v['order_id']]=$v; } } $data['semester']=array(); $semester= Semester::model()->findAll(); foreach($semester as $k=>$v){ $data['semester'][$v['semester_id']]=$v; } //获取班级 $class_data = ClassModel::model()->getClassBySemesternianji($semester_id,$nianji); $data['nowsemesterId']=$this->semesterId; if($class_data) { $data['classes'] = $class_data; foreach($class_data as $v) { $class_array[$v->class_id] = $v->class_name; } $data['class_name'] = $class_array; } if($type=='ordinary'){ $this->render("index",$data); }elseif($type=="test"){ $this->render("indextest",$data); }else{ $this->render("indexall",$data); } } public function actionDelete(){ $order_id = Yii::app()->request->getParam('order_id'); $orderinfo=CMSOrder::model()->find("id=:id",array(":id"=>$order_id)); if($orderinfo->type==0){ Yii::app()->jump->error('非学管订单不能取消'); } $sql="select wu.id from work_flow_user as wu LEFT JOIN work_flow_detail as wd on wu.work_flow_detail_id=wd.id LEFT JOIN `order` as o on o.work_flow_id=wd.work_flow_id where o.id=$order_id"; $arr=Yii::app()->db251->createCommand($sql)->queryRow(); if(empty($arr)){ if($orderinfo->classify!=1){ $num=CMSOrder::model()->updateAll(array("status"=>3),"id=:id",array(":id"=>$order_id)); }else{ $payarr= CMSPayment::model()->findAll("order_id=:id",array(":id"=>$order_id)); if(count($payarr)>1){ Yii::app()->jump->error('已有'.count($payarr)."期缴费，不能取消订单"); }else{ $payment_status="1_3"; $num=CMSOrder::model()->updateAll(array("status"=>3,"payment_status"=>$payment_status),"id=:id",array(":id"=>$order_id)); CMSPayment::model()->updateAll(array("status"=>3),"id=:id",array(":id"=>$payarr[0]->id)); } } if($num>0){ $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderlogid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderlogid=="-1"){ Yii::app()->jump->error('logid获取失败，添加失败！'); } $order_operate_log_odj = new CMSOrderOperateLog(); $order_operate_log_odj->id =$orderlogid; $order_operate_log_odj->role_name = '学管'; $order_operate_log_odj->user_name = Yii::app()->session['coachInfo']['real_name']; $order_operate_log_odj->info = '取消了订单'; $order_operate_log_odj->create_time = date('Y-m-d H:i:s',time()); $order_operate_log_odj->order_id = $order_id; $order_operate_log_odj->save(); $this->redirect(Yii::app()->request->urlReferrer); }else{ Yii::app()->jump->error('取消失败，系统错误'); } }else{ Yii::app()->jump->error('此订单已开始审核，不能取消'); } } public function actionGetstudent_test(){ $class_id = safe_replace(Yii::app()->request->getPost('class_id')); $goods_id = safe_replace(Yii::app()->request->getPost('goods_id')); $goods_data = CMSGoods::model()->find('id=:id',array(':id'=>$goods_id)); $good_type = $goods_data->type_id; if($class_id&&$good_type){ $sql="SELECT oc.clazz_id FROM order_clazz AS oc JOIN `order` AS o ON o.id = oc.order_id JOIN order_goods AS og ON o.id = og.order_id WHERE oc.clazz_id = {$class_id} and og.goods_type_id={$good_type} and o.classify=2 and o.status=1 GROUP BY oc.clazz_id"; $class=Yii::app()->db251->createCommand($sql)->queryAll(); }else{ echo json_encode(array('status'=>3));exit; } if(empty($class)){ $oldclass=array(); $sql="SELECT class_id FROM student_class_relation WHERE class_id != {$class_id} AND student_id IN ( SELECT student_id FROM student_class_relation WHERE class_id = {$class_id} AND STATUS = 0 ) GROUP BY class_id"; $oldclass=SStudentInfo::model()->findAllBySql($sql); //学生如果有转班的话获取转班前的班级 $class_ids=array(); foreach($oldclass as $v){ $class_ids[]=$v['class_id']; } $class_ids[]=$class_id; if(count($class_ids)>1){ $class_ids= implode(",", $class_ids); }else{ $class_ids=$class_ids[0]; } /** * 1、修改： * 背景 以前的试用订单的下单条件是每个学科每个商品每个学校的每个人只可以试用一次，由于2017～2018学年的销售策略变更，改为每个学期可以试用一次（每个学科每个商品每个学校每个人）。 * 需求描述 * 修改学管端下试用订单选择学生时的条件，如果本学期已经试用过则无法加入试用订单。 * 开发时间：20180228 * 作者：刘红伟 * 2、再修改： * * 根据订单开始时间 * 2018-03-06 * * 3、再修改： * 增加多个赛时。 *2018-03-06 */ //查当前班级所在学期 $class_data = ClassModel::model()->find('class_id=:class_id',array(':class_id'=>$class_id)); if(!$class_data) { echo json_encode(array('status'=>3));exit; } //获取学期 $semester_data = Semester::model()->find('semester_id=:semester_id',array(':semester_id'=>$class_data->semester_id)); if(!$semester_data) { echo json_encode(array('status'=>3));exit; } $start_time = date('Y-m-d H:i:s',$semester_data->start_time); $end_time = date('Y-m-d H:i:s',$semester_data->end_time); if(Yii::app()->crm_login_cache->getValue('zsy_season_time_key')){ $time = time(); $season_time = json_decode(Yii::app()->crm_login_cache->getValue('zsy_season_time_key'),1);//获取redis赛时时间 if($season_time) { foreach ($season_time as $v) { if($time>$v['startTime'] && $time<$v['endTime'])//比对赛时的时间 { $start_time = date('Y-m-d H:i:s',$v['startTime']); $end_time = date('Y-m-d H:i:s',$v['endTime']); } } } } //查试用订单：根据学期的开始时间与结束时间 $sql="SELECT os.clazz_id, os.student_id FROM order_student AS os left JOIN `order` AS o ON o.id = os.order_id left JOIN order_goods AS og ON o.id = og.order_id WHERE os.clazz_id in ({$class_ids}) and og.goods_type_id={$good_type} and o.classify=20 and o.status in (0,1) and o.trial_begin_time >= '".$start_time."' and o.trial_begin_time <= '".$end_time."' GROUP BY os.student_id";//去除转班来的学生....... $orderstu=Yii::app()->db251->createCommand($sql)->queryAll(); $orderstuids=array(); foreach($orderstu as $v){ $orderstuids[$v['student_id']]=$v['student_id']; } $sql="SELECT s.realname, s.student_id FROM student_info AS s JOIN student_class_relation AS scr ON s.student_id = scr.student_id WHERE scr.class_id = {$class_id} and scr.`status`=0"; $stu=SStudentInfo::model()->findAllBySql($sql); $student_ids=array(); foreach($stu as $v) { $student_ids[$v->student_id] = $v->student_id; } $BStudent_model=new BusinessStudent(); $student_ids=$BStudent_model->getStatus1ByStudentIds($student_ids,$this->schoolId); $stu=array(); if($student_ids){ $sql="SELECT s.realname, s.student_id FROM student_info AS s JOIN student_class_relation AS scr ON s.student_id = scr.student_id WHERE scr.class_id = {$class_id} and s.student_id in (". implode(",", $student_ids).") and scr.`status`=0"; $stu=SStudentInfo::model()->findAllBySql($sql); } $stuinfo=array(); $orderstu=array(); foreach($stu as $k=>$v){ $student_ids[]=$v['student_id']; } $BStudent_model=new BusinessStudent(); $student_ids=$BStudent_model->getStatus1ByStudentIds($student_ids,$this->schoolId); if($student_ids){ $sql="SELECT s.realname, s.student_id FROM student_info AS s JOIN student_class_relation AS scr ON s.student_id = scr.student_id WHERE scr.class_id = {$class_id} and scr.student_id in (". implode(",", $student_ids).") and scr.`status`=0"; $stuinfo=array(); $orderstu=array(); foreach($stu as $k=>$v){ if(!isset($orderstuids[$v->student_id])){ $stuinfo[$k]['student_id']=$v['student_id']; $stuinfo[$k]['realname']=$v['realname']; }else{ $orderstu[$k]['student_id']=$v['student_id']; $orderstu[$k]['realname']=$v['realname']; } } echo json_encode(array('status'=>0,'result'=>$stuinfo,"orderstu"=>array()));exit; }else{ echo json_encode(array('status'=>3));exit; } }else{ $stu= SStudentInfo::model()->findAll("class_id=:class_id ",array(":class_id"=>$class_id)); $student_ids=array(); foreach($stu as $k=>$v){ $student_ids[]=$v['student_id']; } $BStudent_model=new BusinessStudent(); $student_ids=$BStudent_model->getStatus1ByStudentIds($student_ids,$this->schoolId); $student_id=array(); foreach($student_ids as $v){ $student_id[$v]=$v; } $orderstu=array(); foreach($stu as $k=>$v){ if(isset($student_id[$v->student_id])){ $orderstu[$k]['student_id']=$v->student_id; $orderstu[$k]['realname']=$v->realname; } } echo json_encode(array('status'=>0,'result'=>array(),"orderstu"=>array()));exit; } } public function actionGetstudent() { $data = array(); $orderid = safe_replace(Yii::app()->request->getPost('orderid')); $class_id = safe_replace(Yii::app()->request->getPost('class_id')); $goods_id = safe_replace(Yii::app()->request->getPost('goods_id')); $student_ids = array(); $class_data = ClassModel::model()->find('class_id=:class_id',array(':class_id'=>$class_id)); $student_data = array(); $student_class_data = SStudentClassRelation::model()->findAll('class_id=:class_id and status=:status',array(':class_id'=>$class_id,':status'=>0)); if($student_class_data) { foreach($student_class_data as $v) { $student_ids[$v->student_id] = $v->student_id; } } $where=""; if($student_ids){ $where =" and os.student_id in (".implode(",", $student_ids).")"; $student_ids=array(); } $today=date("Y-m-d H:i:s"); $semester=new SSemester(); $nowsem=$semester->getCurrentSemester(); $sql="SELECT os.student_name, os.student_id FROM `order` AS o JOIN order_goods AS og ON o.id = og.order_id JOIN order_student AS os ON o.id = os.order_id left JOIN order_goods_semester AS ogs ON o.id = ogs.order_id WHERE og.goods_id={$goods_id} and o.status in (0,1) {$where} and os.chargeback=0 AND ( ( o.trial_end_time > '{$today}' OR ogs.`code` = '{$nowsem['refer_code']}' ) AND o.id NOT IN ( SELECT business_key FROM zsy_service WHERE STATUS = 1 ) )"; $order_stuid=Yii::app()->db251->createCommand($sql)->queryAll(); $order_stuids=array(); foreach($order_stuid as $v){ $order_stuids[]=$v['student_id']; } if(!empty($order_stuids)){ $student_class_data = SStudentClassRelation::model()->findAll(' student_id not in ('.implode(",",$order_stuids).') and class_id=:class_id and status=:status',array(':class_id'=>$class_id,':status'=>0)); }else{ $student_class_data = SStudentClassRelation::model()->findAll('class_id=:class_id and status=:status',array(':class_id'=>$class_id,':status'=>0)); } if($student_class_data) { foreach($student_class_data as $v) { $student_ids[$v->student_id] = $v->student_id; } $BStudent_model=new BusinessStudent(); $student_ids=$BStudent_model->getStatus1ByStudentIds($student_ids,$this->schoolId); $BStudent_model=new BusinessStudent(); $student_ids=$BStudent_model->getStatus1ByStudentIds($student_ids,$this->schoolId); $criteria = new CDbCriteria(); $criteria->addInCondition('student_id',$student_ids); $student_data = SStudentInfo::model()->findAll($criteria); unset($criteria); } $goods_data = CMSGoods::model()->find('id=:id',array(':id'=>$goods_id)); $orderstu=array(); if($orderid){ $orderstus= CMSOrderStudent::model()->findAll("order_id=:oid and clazz_id=:cid",array(":oid"=>$orderid,":cid"=>$class_id)); foreach($orderstus as $v) { $orderstu[] = $v->attributes; } } if($student_data && $class_data) { if($goods_data) { if($goods_data->apply_class==-1 || $goods_data->apply_class >= $class_data->grade) { foreach($student_data as $v) { $data[] = $v->attributes; } echo json_encode(array('status'=>1,'result'=>$data,"orderstu"=>$orderstu));exit; } // else // { // echo json_encode(array('status'=>2,'result'=>'',"orderstu"=>$orderstu));exit; // } }else { foreach($student_data as $v) { $data[] = $v->attributes; } echo json_encode(array('status'=>1,'result'=>$data,"orderstu"=>$orderstu));exit; } } echo json_encode(array('status'=>0,'result'=>'',"orderstu"=>$orderstu));exit; } public function actionGetstudents() { $data = array(); $class_id = safe_replace(Yii::app()->request->getPost('class_id')); $student_data = StudentInfo::model()->getStudentByClassId($class_id); if($student_data ) { foreach($student_data as $v) { $data[] = $v->attributes; } echo json_encode(array('status'=>1,'result'=>$data));exit; } echo json_encode(array('status'=>0,'result'=>''));exit; } public function actionGetclass() { $data = array(); $semester_id = safe_replace(Yii::app()->request->getPost('semester_id')); $nianji = safe_replace(Yii::app()->request->getPost('nianji')); if(!$nianji){ $clss_data = ClassModel::model()->getClassBySemester($semester_id); }else{ $clss_data = ClassModel::model()->getClassBySemesternianji($semester_id,$nianji); } if($clss_data ) { foreach($clss_data as $v) { $data[] = $v->attributes; } echo json_encode(array('status'=>1,'result'=>$data));exit; } echo json_encode(array('status'=>0,'result'=>''));exit; } public function actionEditOrderback(){ $data = array(); $order_id = Yii::app()->request->getParam('order_id'); $data['old_order_id']=$old_order_id = Yii::app()->request->getParam('old_order_id'); $data['type']= Yii::app()->request->getParam('type'); if(!$order_id){ Yii::app()->jump->error('参数不正确！'); } $sql="select o.*,ob.* from `order` as o left join order_back as ob on o.id=ob.order_id where o.id={$order_id}"; $orderinfo= Yii::app()->db251->createCommand($sql)->queryAll(); $orderinfo=$orderinfo[0]; if($orderinfo['status']!=2&&$orderinfo['status']!=3){ Yii::app()->jump->error('审核不通过订单才能编辑！'); }else{ $sql="select os.* from order_student as os join `order` as o on o.id=os.order_id where os.order_id={$old_order_id} and o.school_id={$this->schoolId} GROUP BY os.clazz_id"; $data['classes']=Yii::app()->db251->createCommand($sql)->queryAll(); $data['stu']= CMSOrderStudent::model()->findAll("order_id=:id order by clazz_id asc",array(":id"=>$order_id)); $data['action']="edit"; $data['orderid']=$order_id; $data['orderinfo']=$orderinfo; $this->render('back_add',$data); } } public function actionEditOrder(){ $order_id = Yii::app()->request->getParam('order_id'); if(!$order_id){ Yii::app()->jump->error('参数不正确！'); } $type= isset($_GET['type'])?$_GET['type']:"ordinary"; if($type!=="test"&&$type!=="all"&&$type!=="ordinary"){ Yii::app()->jump->error('参数不正确'); }else{ switch ($type){ case "test": $classify=2; break; case "all": $classify=1; break; default : $classify=0; break; } } $data['type']=$type; $criteria = new CDbCriteria(); $criteria->select="*"; $criteria->addCondition('id=:id'); $criteria->params[':id'] = $order_id; $orderinfo= CMSOrder::model()->find($criteria); if($orderinfo['status']!=2&&$orderinfo['status']!=3){ Yii::app()->jump->error('审核不通过订单才能编辑！'); } $data = array(); $type= isset($_GET['type'])?$_GET['type']:"ordinary"; if($type!=="test"&&$type!=="all"&&$type!=="ordinary"){ Yii::app()->jump->error('参数不正确'); } $data['type']=$type; //获取商品 $goods_type_data = CMSGoodsType::model()->findAll('is_delete=:is_delete',array('is_delete'=>0)); if($goods_type_data) { $data['goods_type'] = $goods_type_data; } if($type=="all"||$type=="test"){ $data['orderinfo']=Yii::app()->db251->createCommand('select g.effective_date,g.classify as g_classify,g.grade,g.goods_type_name,goods.apply_class,goods.price as gprice,gs.promotion_price as g_price1,gs.price as g_price,o.*,g.goods_id,s.subject_name,g.goods_type_id from' . ' `order` as o left join order_goods as g on o.id=g.order_id left join order_goods_subject as s on s.order_id=o.id left join goods_spec as gs on gs.goods_id=g.goods_id ' . 'left join goods on goods.id=g.goods_id where o.id='.$order_id)->queryRow(); $data['goods_sem']= CMSOrderGoodsSemester::model()->find("order_id=:id",array(":id"=>$order_id)); if($type=="all"){ $data['pay']= Yii::app()->db251->createCommand("select * from payment where order_id=$order_id order by id asc")->queryRow(); $data['payok']= Yii::app()->db251->createCommand("select sum(pay_money) as summoney from payment where order_id=$order_id and status=1")->queryRow(); $data['orderinfo']= array_merge($data['orderinfo'],$data['pay'],$data['payok']); } }elseif($type=="ordinary"){ $data['orderinfo']=Yii::app()->db251->createCommand('select g.effective_date,g.classify as g_classify,g.grade,g.goods_type_name,op.pay_cert,op.pay_account,op.pay_money,op.pay_time,goods.apply_class,goods.price as gprice,gs.promotion_price as g_price1,gs.price as g_price,o.*,g.goods_id,s.subject_name,g.goods_type_id from' . ' `order` as o left join order_goods as g on o.id=g.order_id left join order_goods_subject as s on s.order_id=o.id left join goods_spec as gs on gs.goods_id=g.goods_id ' . 'left join goods on goods.id=g.goods_id left join order_pay as op on op.order_id=o.id where o.id='.$order_id)->queryRow(); } $goods_data = CMSGoods::model()->findAll('type_id=:type_id and status=:status and is_delete=:is_delete',array(':type_id'=>$data['orderinfo']['goods_type_id'],':status'=>1,':is_delete'=>0)); if($goods_data) { $data['goods_data'] = $goods_data; } //班级 $class_data = ClassModel::model()->getClassBySemesternianji($this->semesterId,$data['orderinfo']['apply_class']); if($class_data) { $data['classes'] = $class_data; } $data['goods_spec_data'] = CMSGoodsSpec::model()->findAll('goods_id=:goods_id ',array(':goods_id'=>$data['orderinfo']['goods_id'])); if($type!="test"){ $data['stu']= CMSOrderStudent::model()->findAll("order_id=:id order by clazz_id asc",array(":id"=>$order_id)); }else{ $criteria = new CDbCriteria(); $criteria->select="*"; $criteria->addCondition('order_id=:orderid'); $criteria->params[':orderid'] = $order_id; $data['class']= CMSOrderClazz::model()->findAll($criteria); $classid=array(); foreach($data['class'] as $v){ $classid[]=$v['clazz_id']; } $criteria = new CDbCriteria(); $criteria->select="*"; $criteria->addNotInCondition('class_id', $classid);//去掉订单里的班级 if($data['orderinfo']['grade']!=-1){ $criteria->addCondition('grade=:grade'); $criteria->params[':grade'] = $data['orderinfo']['grade']; } $data['classes']= ClassModel::model()->findAll($criteria); } if($type!="ordinary"){ $data['sem']= Semester::model()->find(array( 'select' =>array('semester_name'), 'condition' => 'status=1', )); } $data['action']="edit"; $data['orderid']=$order_id; $this->render('add',$data); } public function actionAdd(){ $data = array(); $type= isset($_GET['type'])?$_GET['type']:"ordinary"; if($type!=="test"&&$type!=="all"&&$type!=="ordinary"){ Yii::app()->jump->error('参数不正确'); } $data['type']=$type; if($type!="all"){ $data['sem']= Semester::model()->find(array( 'select' =>array('semester_name'), 'condition' => 'status=1', )); } //获取商品 $goods_type_data = CMSGoodsType::model()->findAll('is_delete=:is_delete',array('is_delete'=>0)); if($goods_type_data) { $data['goods_type'] = $goods_type_data; } //班级 $class_data = ClassModel::model()->getClassBySemester($this->semesterId); if($class_data) { $data['classes'] = $class_data; } //商品规格 /** * 1、修改： *开发者：刘红伟 * 时间：2018-03-06 * 限定订单开始时间与结束时间 * * 修改学管端下试用订单选择学生时的条件，如果本赛季已经试用过则无法加入试用订单； * . 试用订单属于哪个赛季按照试用订单的开始时间计算； * 时间：2018-03-06 * 开发者：刘红伟 */ //获取学期 $semester_data = Semester::model()->find('semester_id=:semester_id',array(':semester_id'=>$this->semesterId)); if(!$semester_data) { echo json_encode(array('status'=>3));exit; } $start_time = date('Y-m-d',$semester_data->start_time); $end_time = date('Y-m-d',$semester_data->end_time); $time = time(); $season_time = json_decode(Yii::app()->crm_login_cache->getValue('zsy_season_time_key'),1);//获取redis赛时时间 if($season_time) { foreach ($season_time as $v) { if($time>$v['startTime'] && $time<$v['endTime'])//比对赛时的时间 { $start_time = date('Y-m-d',$v['startTime']); $end_time = date('Y-m-d',$v['endTime']); } } } //商品关联学科 $data['action']="add"; $data['start_time']=$start_time; $data['end_time']=$end_time; $this->render('add',$data); } public function actionBack_add(){ $data['orderid']=$order_id = Yii::app()->request->getParam('order_id'); $data['type']= Yii::app()->request->getParam('type'); if(!$order_id){ Yii::app()->jump->error('参数不正确！'); } $sql="select os.*,o.* from order_student as os join `order` as o on o.id=os.order_id where os.order_id={$order_id} and o.school_id={$this->schoolId} GROUP BY os.clazz_id"; $data['classes']=Yii::app()->db251->createCommand($sql)->queryAll(); $data['price']=0; if($data['classes']){ $data['price']=$data['classes'][0]['total_price']/$data['classes'][0]['quantity']; } $this->render('back_add',$data); } public function actionget_back_student(){ $class_id = Yii::app()->request->getPost('class_id'); $orderid = Yii::app()->request->getPost('orderid'); $old_order_id = Yii::app()->request->getPost('old_order_id'); if(!$old_order_id){ $sql="select os.* from order_student as os join `order` as o on o.id=os.order_id where os.order_id='{$orderid}' and o.school_id={$this->schoolId} and os.clazz_id='{$class_id}' and os.chargeback=0"; }else{ $sql="select os.* from order_student as os join `order` as o on o.id=os.order_id where os.order_id='{$old_order_id}' and o.school_id={$this->schoolId} and os.clazz_id='{$class_id}' and os.chargeback=0"; } $stus=Yii::app()->db251->createCommand($sql)->queryAll(); if($stus){ echo json_encode(array('status'=>1,'result'=>$stus));exit; }else{ echo json_encode(array('status'=>0,'result'=>''));exit; } } public function actionEdit() { $data = array(); //获取商品 $goods_type_data = CMSGoodsType::model()->findAll('is_delete=:is_delete',array('is_delete'=>0)); if($goods_type_data) { $data['goods_type'] = $goods_type_data; } //班级 $class_data = ClassModel::model()->getClassBySemester($this->semesterId); if($class_data) { $data['classes'] = $class_data; } //商品规格 //商品关联学科 $this->render('add',$data); } public function actionGetgoods() { $type_id = Yii::app()->request->getPost('type_id'); $sem= new SSemester(); $nowsem=$sem->getCurrentSemester(); $goods_array = array(); if($type_id){ $goods_data=Yii::app()->db251->createCommand('select g.* from goods as g LEFT JOIN goods_term as gt on g.id=gt.goods_id where g.type_id='.$type_id.' and g.status=1 and g.is_delete=0 and (gt.`code`='.$nowsem['refer_code'].' or g.classify=1)')->queryAll(); if($goods_data) { foreach($goods_data as $v) { $goods_array[] = $v; } echo json_encode(array('status'=>1,'result'=>$goods_array));exit; } } echo json_encode(array('status'=>0,'result'=>''));exit; } public function actionGetsubject() { $goods_id = Yii::app()->request->getPost('goods_id'); $type = Yii::app()->request->getPost('type'); $goods_array = array(); $goods_data = CMSGoods::model()->find('id=:id',array(':id'=>$goods_id)); if($goods_data) { $goods_spec_data = CMSGoodsSpec::model()->findAll('goods_id=:goods_id ',array(':goods_id'=>$goods_id)); $goods_tem=CMSGoodsTerm::model()->find('goods_id=:goods_id ',array(':goods_id'=>$goods_id)); $sem= Semester::model()->find('status=1 '); if($goods_spec_data) { foreach($goods_spec_data as $v) { $goods_array[] = $v->attributes; } // if($type!="test"){ // echo json_encode(array('status'=>1,'result'=>$goods_array,'apply_class'=>$goods_data->apply_class));exit; // }else{ $classarr=array(); // if($type=="test"){//找到该学校开过试用订单的班级 // $sql="select oc.clazz_id from `order` as o join order_clazz as oc on o.id=oc.order_id where o.school_id ={$this->schoolId} and o.classify=2"; // // $test_class_id=Yii::app()->db251->createCommand($sql)->queryAll(); // $test_class_ids=array(); // foreach($test_class_id as $v){ // $test_class_ids[]=$v['clazz_id']; // } // } if($goods_data->apply_class!=-1){ if($type=="test"){//去除试用过的班级 $class= ClassModel::model()->findAll("grade=".$goods_data->apply_class." and semester_id=".$sem['semester_id']); }else{ $class= ClassModel::model()->findAll("grade=".$goods_data->apply_class." and semester_id=".$sem['semester_id']); } }else{ if($type=="test"){//去除试用过的班级 $class= ClassModel::model()->findAll("semester_id=".$sem['semester_id']); }else{ $class= ClassModel::model()->findAll("semester_id=".$sem['semester_id']); } } if($class){ foreach($class as $v) { $classarr[] = $v->attributes; } } echo json_encode(array('status'=>1,'result'=>$goods_array,'apply_class'=>$goods_data->apply_class,'class'=>$classarr));exit; // } } } echo json_encode(array('status'=>0,'result'=>'','apply_class'=>''));exit; } public function actionGetsubject_one() { $goods_spec_id = Yii::app()->request->getPost('goods_spec_id'); $goods_spec_data = CMSGoodsSpec::model()->find('id=:id ',array(':id'=>$goods_spec_id))->attributes; if($goods_spec_data) { if($goods_spec_data['promotion_price']) { $goods_spec_data['price'] = $goods_spec_data['promotion_price']; } $goods= CMSGoods::model()->find("id=:id",array(":id"=>$goods_spec_data['goods_id'])); $sem= Semester::model()->find("status=1"); echo json_encode(array('status'=>1,'result'=>$goods_spec_data,"semname"=>$sem['semester_name'],"classify"=>$goods['classify'],"effective_date"=>$goods['effective_date']));exit; } echo json_encode(array('status'=>0,'result'=>''));exit; } public function checktime($paytime){ $time= strtotime($paytime); if(!$time){ $paytime= explode(" ", $paytime); if(count($paytime)!=2){ return false; } $date=$paytime[0]; $time=$paytime[1]; $time= explode(":", $time); if(count($time)!=3){ return false; } if($time[1]=="60"){ $time[1]="59"; }else{ return false; } return $date." ".$time[0].":".$time[1].":".$time[2]; } return $paytime; } public function actionInsert() { $type_id = Yii::app()->request->getPost('type_id'); $goods_id = Yii::app()->request->getPost('goods_id'); $goods_spec_id = Yii::app()->request->getPost('goods_spec_id'); $class_id = Yii::app()->request->getPost('class_id'); $pay_account = Yii::app()->request->getPost('pay_account'); $pay_money = Yii::app()->request->getPost('pay_money'); $pay_time = Yii::app()->request->getPost('pay_time'); if($pay_time){ if(!$pay_time=$this->checktime($pay_time)){ Yii::app()->jump->error('时间格式错误！',Yii::app()->createUrl('order/index')); } } $apply_class_hide = Yii::app()->request->getPost('apply_class_hide'); $select_grade = Yii::app()->request->getPost('select_grade'); $student_ids = Yii::app()->request->getPost('student_ids'); $class_name = Yii::app()->request->getPost('class_name'); $good_type_name = Yii::app()->request->getPost('good_type_name'); $next_pay_time = Yii::app()->request->getPost('next_pay_time'); $trial_begin_time = Yii::app()->request->getPost('trial_begin_time'); $trial_begin_time_test = Yii::app()->request->getPost('trial_begin_time_test'); $ordertype=Yii::app()->request->getPost('type'); if($apply_class_hide==-1){ $apply_class_hide=$select_grade; } if($ordertype=="ordinary"){ $classify=0; }elseif($ordertype=="all"){ $classify=1; }else{ $classify=20; } if(!$class_id) { Yii::app()->jump->error('请选择班级'); } $class_data = ClassModel::model()->find('class_id=:class_id',array(':class_id'=>$class_id)); if($class_data) { $apply_class_hide = $class_data->grade; $select_grade = $class_data->grade; } if($classify!=20){//不是试用订单的话 if(!$type_id || !$goods_id || !$goods_spec_id || !$class_id ||$trial_begin_time=="0000-00-00 00:00:00" ) { Yii::app()->jump->error('填写信息不完整，请填写完整！',Yii::app()->createUrl('order/add')); } //图片上传 if(Yii::app()->params["fdfs_open"]){ if($_FILES['pic']['name']!=""&&$_FILES['pic']['type']!=""){ //验证图片 $type = strtolower(substr($_FILES['pic']['name'],strrpos($_FILES['pic']['name'],'.')+1)); $allow_type = array('jpg','jpeg','gif','png'); //定义允许上传的类型 if(!in_array($type, $allow_type)) { Yii::app()->jump->error('上传图片类型不对，请重新上传！',Yii::app()->createUrl('order/add')); } $f_file_tmp = $_FILES['pic']['tmp_name']; $f_real_name = $_FILES['pic']['name']; $f_file_name = dirname($f_file_tmp)."/".$f_real_name; @copy($f_file_tmp, $f_file_name); @rename($f_file_tmp, $f_file_name); $fdfs_odj = FDFS::getInstance(Yii::app()->params['fastdfs']); $file_info = $fdfs_odj->upload_filename1($f_file_name,'',$type); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！',Yii::app()->createUrl('order/add')); } @unlink($f_file_name); $file_name = $file_info; }else{ $file_name=""; } }else{ $file_name='aa.jpg'; } }else{//试用订单 if(!$type_id || !$goods_id || !$goods_spec_id ||$trial_begin_time=="0000-00-00 00:00:00" ) { Yii::app()->jump->error('填写信息不完整，请填写完整！',Yii::app()->createUrl('order/add')); } } $student_array = array(); $student_id_array = array(); $spec_id = array(); $spec_array = array(); $student_num = 0; $order_no = $this->_getMillisecond().rand(1,9).rand(1,9).rand(1,9); //订单编号 if($class_id||$classify==20) { $stujson=json_decode($student_ids); $class_ids=array(); foreach($stujson as $k=>$v){ $class_ids[]=$v->classid; } $student_data = StudentInfo::model()->getStudentInClassId($class_ids); $_class_id = 0; if($student_data) { foreach($student_data as $v) { $student_array[$v->student_id] = $v->realname; $student_id_array[$v->student_id] = $v->student_id; $_class_id = $v->class_id; } } $_class_data = ClassModel::model()->find('class_id=:class_id',array(':class_id'=>$_class_id)); if($_class_data){ $apply_class_hide = $_class_data->grade; } if(!$student_ids) { Yii::app()->jump->error('请选择学生，重新上传！',Yii::app()->createUrl('order/add')); } $student_num=Yii::app()->request->getPost('stusum'); $student_id_array= json_decode($student_ids); if($goods_spec_id) { $goods_spec_data = CMSGoodsSpec::model()->find('id=:id ',array(':id'=>$goods_spec_id)); if($goods_spec_data) { if($goods_spec_data->promotion_price) { $goods_spec_data->price = $goods_spec_data->promotion_price; } $goods_data = CMSGoods::model()->find('id=:id',array(':id'=>$goods_spec_data->goods_id)); $goods_term_data = CMSGoodsTerm::model()->findAll('goods_id=:goods_id',array(':goods_id'=>$goods_spec_data->goods_id)); if($goods_data ) { //$term_data = CMSTerm::model()->find('id=:id',array(':id'=>$goods_data->term_id)); $goods_spec_realtion_data = CMSGoodsSpecRealtion::model()->findAll('goods_spec_id=:goods_spec_id',array(':goods_spec_id'=>$goods_spec_id)); if($goods_spec_realtion_data) { foreach($goods_spec_realtion_data as $v) { $spec_id[$v->subject_id] = $v->subject_id; } } if($spec_id) { $Criteria = new CDbCriteria(); $Criteria->addInCondition('id',$spec_id); $subject_data = CMSSubject::model()->findAll($Criteria); if($subject_data) { foreach($subject_data as $v) { $spec_array[$v->id] = $v->name; } Yii::app()->db251->active = false; //取出商品信息 // $transaction= Yii::app()->db251->beginTransaction();//建立事务 Yii::app()->db251->createCommand("START TRANSACTION")->execute(); try { $order_odj = new CMSOrder(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ throw new CException('接口错误'); } $orderid=$orders_id->errCode=="00"? $orders_id->data->id:"-1"; if($orderid=="-1"){ throw new CException('orderid获取失败，添加失败！'); } $order_odj->id = $orderid; $order_odj->order_no = $order_no; if($classify!=20){ $order_odj->total_price = $student_num*$goods_spec_data->price; }else{ $order_odj->total_price = 0; } // $order_odj->pay_money = $pay_money; $order_odj->openid = $this->coachId; $order_odj->create_time = date('Y-m-d H:i:s',time()); // $order_odj->pay_time = $pay_time; $order_odj->status = 0; // $order_odj->prepay_id = null; $order_odj->type = 1; $order_odj->classify = $classify; $order_odj->grade = $apply_class_hide; $order_odj->school_id = $this->schoolId; $order_odj->school_name = Yii::app()->session['session_school_name']; // $order_odj->pay_account = $pay_account; // $order_odj->pay_cert = $file_name; $order_odj->apply_time = null; if($classify==1){ $order_odj->payment_status ="1_0"; } $order_odj->create_user = Yii::app()->session['coachInfo']['real_name']; $order_odj->quantity = $student_num; if($classify==20){ $order_odj->trial_begin_time = $trial_begin_time_test; }else{ if($goods_data->classify!=0){//不是试用订单但是商品是以有效期结算 if(strtotime($trial_begin_time)== strtotime(date("Y-m-d"))){ $trial_begin_time=date("Y-m-d H:i:s"); $trial_end_time=date("Y-m-d H:i:s",(strtotime($trial_begin_time) + 3600*24*$goods_data->effective_date)); }else{ $trial_end_time=date("Y-m-d",(strtotime($trial_begin_time) + 3600*24*($goods_data->effective_date)-1))." 23:59:59"; } $order_odj->trial_begin_time = $trial_begin_time; $order_odj->trial_end_time = $trial_end_time; } } $order_odj->save(); $order_ids = $order_odj->getOldPrimaryKey(); if($classify!=20){//不是试用订单才有支付信息 $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ throw new CException('接口错误'); } $orderpayid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderpayid=="-1"){ throw new CException('orderpayid获取失败，添加失败！'); } if($ordertype!="all"){ $order_pay=new CMSOrderPay(); $order_pay->id=$orderpayid; $order_pay->order_id=$orderid; if($classify!=20){ $order_pay->pay_money=$pay_money; }else{ $order_pay->pay_money=0; } if($pay_time){ $order_pay->pay_time=$pay_time; } $order_pay->pay_account=$pay_account; $order_pay->pay_cert=$file_name; $order_pay->save(); }else{ $payment=new CMSPayment(); $payment->id=$orderpayid; $payment->order_id=$orderid; $payment->pay_money=$pay_money; if($pay_time){ $payment->pay_time=$pay_time; } $payment->pay_account=$pay_account; $payment->pay_cert=$file_name; $payment->status=0; if($next_pay_time){ $payment->next_pay_time=$next_pay_time; } $payment->save(); } } if($order_ids) { $order_goods_odj = new CMSOrderGoods(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ throw new CException('接口错误！'); } $ordergoodid=$orders_id->errCode=="00"? $orders_id->data->id:"-1"; if($ordergoodid=="-1"){ throw new CException('orderpayid获取失败，添加失败！'); } $order_goods_odj->id = $ordergoodid; $order_goods_odj->goods_name = $goods_data->goods_name; if($classify!=20){ $order_goods_odj->price = $goods_spec_data->price; }else{ $order_goods_odj->price=0; } $order_goods_odj->order_id = $orderid; $order_goods_odj->goods_id = $goods_data->id; $order_goods_odj->goods_type_id = $type_id; $order_goods_odj->goods_type_name = $good_type_name; $order_goods_odj->subject_names = $goods_spec_data->name; $order_goods_odj->grade = $goods_data->apply_class; $order_goods_odj->thumbnail = $goods_data->thumbnail; if($goods_data->classify!=0){ $order_goods_odj->classify = $goods_data->classify; $order_goods_odj->effective_date = $goods_data->effective_date; } $order_goods_odj->save(); if($goods_term_data){ $sql=''; $sqlArr=array(); $i=0; $orders_ids= json_decode($this->curlget(Yii::app()->params['batch_orders_id'].(count($goods_term_data)))); if(!$orders_ids||$orders_ids->errCode!="00"){ throw new CException('接口错误4！'); }else{ $orders_ids=$orders_ids->data; } foreach($goods_term_data as $v) { if ($i == 0) { $sql .= "INSERT INTO `order_goods_semester` (`id`,`order_id`,`goods_id`,`code`,`name`)VALUES "; } else { $sql .= ", "; } $ordergoodsemesterid= isset($orders_ids[0])?$orders_ids[0]:-1; array_splice($orders_ids,0,1); if(!$ordergoodsemesterid){ throw new CException('ordergoodsemesterid获取失败，添加失败！'); } $sql.='('.$ordergoodsemesterid.','.$order_ids['id'].','.$v->goods_id.',"'.$v->code.'","'.$v->name.'")'; $i++; if ($i == 200) { $i = 0; $sql.= ";"; $sqlArr[] = $sql; $sql = ""; } } if ($sql) { $sqlArr[] = $sql; } foreach ($sqlArr as $v) { Yii::app()->db251->createCommand($v)->execute(); } } $sql=''; $sqlArr=array(); $i=0; $orders_ids= json_decode($this->curlget(Yii::app()->params['batch_orders_id'].(count($goods_spec_realtion_data)>0?count($goods_spec_realtion_data):1))); if(!$orders_ids||$orders_ids->errCode!="00"){ throw new CException('接口错误5！'); }else{ $orders_ids=$orders_ids->data; } foreach($goods_spec_realtion_data as $v) { if ($i == 0) { $sql='INSERT INTO `order_goods_subject` (`id`,`subject_id` ,`subject_name` ,`order_id` ,`goods_id`) VALUES '; } else { $sql .= ", "; } $ordergoodsubjectid= isset($orders_ids[0])?$orders_ids[0]:-1; array_splice($orders_ids,0,1); if(!$ordergoodsubjectid){ throw new CException('ordergoodsubjectid获取失败，添加失败！'); } $sql.='('.$ordergoodsubjectid.','.$v->subject_id.',"'.$spec_array[$v->subject_id].'","'.$order_ids['id'].'","'.$goods_data->id.'")'; $i++; if ($i == 200) { $i = 0; $sql.= ";"; $sqlArr[] = $sql; $sql = ""; } } // $sql = substr($sql,0,-1); if ($sql) { $sqlArr[] = $sql; } foreach ($sqlArr as $v) { Yii::app()->db251->createCommand($v)->execute(); } $order_operate_log_odj = new CMSOrderOperateLog(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ throw new CException('接口错误！'); } $orderlogid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderlogid=="-1"){ throw new CException('ordergoodsubjectid获取失败，添加失败！'); } $order_operate_log_odj->id =$orderlogid; $order_operate_log_odj->role_name = '学管'; $order_operate_log_odj->user_name = Yii::app()->session['coachInfo']['real_name']; if($classify!=20){ $order_operate_log_odj->info = '创建了订单，付款'.$this->xiaoshu($pay_money).'（元）'; }else{ $order_operate_log_odj->info = '创建了试用订单并提交审核'; } $order_operate_log_odj->create_time = date('Y-m-d H:i:s',time()); $order_operate_log_odj->order_id = $order_ids['id']; $order_operate_log_odj->save(); $order_student_sql=''; $insertnum=0; $sqlArr=array(); $i=0; $stu_num=0; foreach($student_id_array as $k=>$v) { $stu_num+=count($v->stus); } $orders_ids= json_decode($this->curlget(Yii::app()->params['batch_orders_id'].($stu_num>0?$stu_num:1))); if(!$orders_ids||$orders_ids->errCode!="00"){ throw new CException('接口错误'); }else{ $orders_ids=$orders_ids->data; } $insert_stu=array(); foreach($student_id_array as $k=>$v) { $class_id=$v->classid; $class_name=$v->classname; foreach($v->stus as $s){ if(!isset($insert_stu[$s])){ $insert_stu[$s]=$s; if ($i == 0) { $order_student_sql='INSERT INTO `order_student` (`id`,`order_id` ,`clazz_id` ,`student_id` ,`student_name`,`clazz_name`) VALUES '; } else { $order_student_sql .= ", "; } $insertnum++; $ordergoodstudentid= isset($orders_ids[0])?$orders_ids[0]:-1; array_splice($orders_ids,0,1); if(!$ordergoodstudentid){ throw new CException('ordergoodstudentid获取失败，添加失败!'); } $order_student_sql.='('.$ordergoodstudentid.','.$order_ids['id'].',"'.$class_id.'","'.$s.'","'.(isset($student_array[$s])?$student_array[$s]:'').'","'.$class_name.'")'; $i++; if ($i == 200) { $i = 0; $order_student_sql.= ";"; $sqlArr[] = $order_student_sql; $order_student_sql = ""; } }else{ throw new CException('学生重复，请重新添加！'); } } } } CMSGoods::model()->updateAll(array('buyer_num'=>($goods_data->buyer_num+$student_num)),'id=:id',array(':id'=>$goods_id)); if($insertnum>0){ if ($order_student_sql) { $sqlArr[] = $order_student_sql; } foreach ($sqlArr as $v) { Yii::app()->db251->createCommand($v)->execute(); } } Yii::app()->db251->createCommand("COMMIT")->execute(); $check_order= json_decode($this->curlpost(Yii::app()->params['order_interface'].$orderid)); if($check_order){ if($check_order->errCode!="00"){ throw new CException('添加失败,'.$check_order->errMsg); } }else{ throw new CException('添加失败,接口错误'); } }catch(Exception $e) { Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error($e->getMessage(),Yii::app()->createUrl('order/add')); } $this->redirect($this->createUrl('order/index'."?type=".$ordertype)); } } } } } } Yii::app()->jump->error('添加失败，重新添加！',Yii::app()->createUrl('order/add')); } public function actionInsert_back() { $back_account = Yii::app()->request->getPost('back_account'); $back_money = Yii::app()->request->getPost('back_money'); $student_ids = Yii::app()->request->getPost('student_ids'); $old_order_id = Yii::app()->request->getPost('old_order_id'); $type = Yii::app()->request->getPost('type'); if(!$student_ids ) { Yii::app()->jump->error('填写信息不完整，请填写完整！',Yii::app()->createUrl('order/index')); } $student_array = array(); $student_id_array = array(); $spec_id = array(); $spec_array = array(); $student_num = 0; $order_no = $this->_getMillisecond().rand(1,9).rand(1,9).rand(1,9); //订单编号 $student_id_array= json_decode($student_ids,true); if(!$student_ids) { Yii::app()->jump->error('请选择学生，重新上传！',Yii::app()->createUrl('order/add')); } $class_ids=array(); $stu_num=0; foreach($student_id_array as $k=>$v) { $stu_num+=count($v['stus']); } $orders_ids= json_decode($this->curlget(Yii::app()->params['batch_orders_id']. ($stu_num))); if(!$orders_ids||$orders_ids->errCode!="00"){ Yii::app()->jump->error('接口错误'); }else{ $orders_ids=$orders_ids->data; } foreach($student_id_array as $k=>$v){ $class_ids[]=$v['classid']; } $student_data = StudentInfo::model()->getStudentInClassId($class_ids); if($student_data) { foreach($student_data as $v) { $student_array[$v->student_id] = $v->realname; } } $student_num=Yii::app()->request->getPost('stusum'); Yii::app()->db251->active = false; // 关闭连接 close(); Yii::app()->db251->createCommand("START TRANSACTION")->execute(); try { $order_odj = new CMSOrder(); $old_order_info=$order_odj->getOrderInfo($old_order_id); $back_parice=$old_order_info->total_price/$old_order_info->quantity*$student_num; $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderid=$orders_id->errCode=="00"? $orders_id->data->id:"-1"; if($orderid=="-1"){ Yii::app()->jump->error('orderid获取失败，添加失败！'); } $order_odj->id = $orderid; $order_odj->order_no = $order_no; $order_odj->total_price = $back_parice; $order_odj->openid = $this->coachId; $order_odj->create_time = date('Y-m-d H:i:s',time()); $order_odj->status = 0; $order_odj->type = 1; $order_odj->classify = 3; $order_odj->school_id = $this->schoolId; $order_odj->school_name = Yii::app()->session['session_school_name']; $order_odj->apply_time = null; $order_odj->create_user = Yii::app()->session['coachInfo']['real_name']; $order_odj->quantity = $student_num; $order_odj->original_order_id = $old_order_id; $order_odj->save(); $order_ids = $order_odj->getOldPrimaryKey(); if($order_ids) { $order_back_odj = new CMSOrder_back(); $order_back_odj->order_id=$order_ids['id']; $order_back_odj->account=$back_account; $order_back_odj->money=$back_money; $order_back_odj->save(); $order_student_sql='INSERT INTO `order_student` (`id`,`order_id` ,`clazz_id` ,`student_id` ,`student_name`,`clazz_name` )VALUES '; $insertnum=0; foreach($student_id_array as $k=>$v) { $class_id=$v['classid']; $class_name=$v['classname']; foreach($v['stus'] as $s){ $insertnum++; $ordergoodstudentid= isset($orders_ids[0])?$orders_ids[0]:-1; array_splice($orders_ids,0,1); if(!$ordergoodstudentid){ Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); } $order_student_sql.='('.$ordergoodstudentid.','.$order_ids['id'].',"'.$class_id.'","'.$s.'","'.(isset($student_array[$s])?$student_array[$s]:'').'","'.$class_name.'"),'; } } } if($insertnum>0){ $order_student_sql = substr($order_student_sql,0,-1); Yii::app()->db251->createCommand($order_student_sql)->execute(); } $order_operate_log_odj = new CMSOrderOperateLog(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderlogid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderlogid=="-1"){ Yii::app()->jump->error('ordergoodsubjectid获取失败，添加失败！'); } $order_operate_log_odj->id =$orderlogid; $order_operate_log_odj->role_name = '学管'; $order_operate_log_odj->user_name = Yii::app()->session['coachInfo']['real_name']; $order_operate_log_odj->info = '创建了退单并提交审核'; $order_operate_log_odj->create_time = date('Y-m-d H:i:s',time()); $order_operate_log_odj->order_id = $order_ids['id']; $order_operate_log_odj->save(); Yii::app()->db251->createCommand("COMMIT")->execute(); $check_order= json_decode($this->curlpost(Yii::app()->params['order_interface'].$orderid)); // $path=Yii::getPathOfAlias('webroot')."/assets/order_interface_log.txt"; // $myfile = fopen($path, "a"); // // $txt = "退单操作，请求".Yii::app()->params['order_interface'].$orderid."接口 orderid:".$orderid." 返回errCode：".$check_order->errCode." \n"; // fwrite($myfile, $txt); // fclose($myfile); if($check_order){ if($check_order->errCode!="00"){ $this->deletedata($orderid); Yii::app()->jump->error('添加失败,'.$check_order->errMsg,Yii::app()->createUrl('order/back_add'."?order_id=".$old_order_id)); } }else{ $this->deletedata($orderid); Yii::app()->jump->error('添加失败,接口错误',Yii::app()->createUrl('order/back_add'."?order_id=".$old_order_id)); } }catch(Exception $e) { Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败，重新添加！',Yii::app()->createUrl('order/back_add'."?order_id=".$old_order_id)); } $this->redirect($this->createUrl('order/info',array("order_id"=>$old_order_id,"type"=>$type))); Yii::app()->jump->error('添加失败，重新添加！',Yii::app()->createUrl('order/back_add'."?order_id=".$old_order_id)); } public function deletedata($orderid=null){ if($orderid!=NULL){ $orderclazz=new CMSOrderClazz(); $orderclazz->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $order_student=new CMSOrderStudent(); $order_student->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $ordergoodssubject=new CMSOrderGoodsSubject(); $ordergoodssubject->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $ordergoodssemester=new CMSOrderGoodsSemester(); $ordergoodssemester->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $order_operate_log_odj = new CMSOrderOperateLog(); $order_operate_log_odj->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $order_goods_odj = new CMSOrderGoods(); $order_goods_odj->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $payment=new CMSPayment(); $payment->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $order_pay=new CMSOrderPay(); $order_pay->deleteAll("order_id=:oid ",array(":oid"=>$orderid)); $order_odj = new CMSOrder(); $order_odj->deleteAll("id=:oid ",array(":oid"=>$orderid)); } } public function checkid($idarr){ $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id']."?_t=".rand(100000000,999999999))); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orders_id=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orders_id=="-1"){ Yii::app()->jump->error('ID接口错误，返回：'.$orders_id->errCode); } if(isset($idarr[$orders_id])){ $this->checkid($idarr); }else{ return $orders_id; } } public function actionUpdate_back() { $order_id = Yii::app()->request->getPost('orderid'); $type = Yii::app()->request->getPost('type'); $old_order_id = Yii::app()->request->getPost('old_order_id'); $pay_account = Yii::app()->request->getPost('back_account'); $pay_money = Yii::app()->request->getPost('back_money'); $student_ids = Yii::app()->request->getPost('student_ids'); $stusum=Yii::app()->request->getPost('stusum'); Yii::app()->db251->createCommand("START TRANSACTION")->execute(); try { $order_obj=new CMSOrder(); $orderinfo=$order_obj->getOrderInfo($order_id); $total_price=$orderinfo['total_price']/$orderinfo['quantity']*$stusum; $orderdata=array( "total_price"=>$total_price, "quantity"=>$stusum // "status"=>0 ); $order_obj->updateAll($orderdata,"id=:id",array(":id"=>$order_id)); $order_back_obj=new CMSOrder_back(); $orderdata=array(); $orderdata['account']=$pay_account; $orderdata['money']=$pay_money; $order_back_obj->updateAll($orderdata,"order_id=:id",array(":id"=>$order_id)); if($student_ids!=Yii::app()->request->getPost('old_stu_ids')){ $stujson=json_decode($student_ids); $class_ids=array(); $student_array=array(); $student_id_array=array(); foreach($stujson as $k=>$v){ $class_ids[]=$v->classid; } $student_data = StudentInfo::model()->getStudentInClassId($class_ids); if($student_data) { foreach($student_data as $v) { $student_array[$v->student_id] = $v->realname; $student_id_array[$v->student_id] = $v->student_id; } } $order_stu=new CMSOrderStudent(); $order_stu->deleteAll("order_id=:oid ",array(":oid"=>$order_id)); foreach($stujson as $k=>$v) { $class_id=$v->classid; $class_name=$v->classname; $idarr=array(); $newstunum=0; $order_student_sql='INSERT INTO `order_student` (`id`,`order_id` ,`clazz_id` ,`student_id` ,`student_name`,`clazz_name` )VALUES '; foreach($v->stus as $s){ $newstunum++; $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $ordergoodstudentid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($ordergoodstudentid=="-1"){ Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); } $order_student_sql.='('.$ordergoodstudentid.','.$order_id.',"'.$class_id.'","'.$s.'","'.(isset($student_array[$s])?$student_array[$s]:'').'","'.$class_name.'"),'; } $order_student_sql = substr($order_student_sql,0,-1); if($newstunum>0){ Yii::app()->db251->createCommand($order_student_sql)->execute(); } } } Yii::app()->db251->createCommand("COMMIT")->execute(); $check_order= json_decode($this->curlpost(Yii::app()->params['order_interface'].$order_id)); // $path=Yii::getPathOfAlias('webroot')."/assets/order_interface_log.txt"; // $myfile = fopen($path, "a"); // // $txt = "退单操作，请求".Yii::app()->params['order_interface'].$order_id."接口 orderid:".$order_id." 返回errCode：".$check_order->errCode." \n"; // fwrite($myfile, $txt); // fclose($myfile); if($check_order){ if($check_order->errCode!="00"){ // $this->deletedata($order_id); Yii::app()->jump->error('添加失败,'.$check_order->errMsg,Yii::app()->createUrl('order/back_add'."?order_id=".$old_order_id)); } }else{ // $this->deletedata($order_id); Yii::app()->jump->error('添加失败,接口错误',Yii::app()->createUrl('order/back_add'."?order_id=".$old_order_id)); } } catch(CException $e) { Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败，重新添加！',Yii::app()->createUrl('order/index')); } $this->redirect($this->createUrl('order/info',array("order_id"=>$old_order_id,"type"=>$type))); } public function actionUpdate() { $order_id = Yii::app()->request->getPost('orderid'); $type_id = Yii::app()->request->getPost('type_id'); $goods_id = Yii::app()->request->getPost('goods_id'); $goods_spec_id = Yii::app()->request->getPost('goods_spec_id'); $class_id = Yii::app()->request->getPost('class_id'); //$students = Yii::app()->request->getPost('students'); $apply_class_hide = Yii::app()->request->getPost('apply_class_hide'); $pay_account = Yii::app()->request->getPost('pay_account'); $pay_money = Yii::app()->request->getPost('pay_money'); $pay_time = Yii::app()->request->getPost('pay_time'); if($pay_time){ if(!$pay_time=$this->checktime($pay_time)){ Yii::app()->jump->error('时间格式错误！',Yii::app()->createUrl('order/index')); } } $student_ids = Yii::app()->request->getPost('student_ids'); $class_name = Yii::app()->request->getPost('class_name'); $good_type_name = Yii::app()->request->getPost('good_type_name'); $trial_begin_time=Yii::app()->request->getPost('trial_begin_time'); $trial_begin_time_test=Yii::app()->request->getPost('trial_begin_time_test'); $next_pay_time=Yii::app()->request->getPost('next_pay_time'); $ordertype=Yii::app()->request->getPost('type'); if($ordertype=="ordinary"){ $classify=0; }elseif($ordertype=="all"){ $classify=1; }else{ $classify=2; } if($classify!=2){//不是试用订单的话 if(!$type_id || !$goods_id || !$goods_spec_id || !$class_id ||$trial_begin_time=="0000-00-00 00:00:00") { Yii::app()->jump->error('填写信息不完整，请填写完整！',Yii::app()->createUrl('order/add')); } if(!empty($_FILES['pic']['name'])){ //验证图片 $type = strtolower(substr($_FILES['pic']['name'],strrpos($_FILES['pic']['name'],'.')+1)); $allow_type = array('jpg','jpeg','gif','png'); //定义允许上传的类型 if(!in_array($type, $allow_type)) { Yii::app()->jump->error('上传图片类型不对，请重新上传！',Yii::app()->createUrl('order/add')); } //图片上传 if(Yii::app()->params["fdfs_open"]){ $f_file_tmp = $_FILES['pic']['tmp_name']; $f_real_name = $_FILES['pic']['name']; $f_file_name = dirname($f_file_tmp)."/".$f_real_name; @copy($f_file_tmp, $f_file_name); @rename($f_file_tmp, $f_file_name); /////////////////////////////////////////////////////////////////////////////////////// $fdfs_odj = FDFS::getInstance(Yii::app()->params['fastdfs']); $file_info = $fdfs_odj->upload_filename1($f_file_name,'',$type); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！',Yii::app()->createUrl('order/add')); } @unlink($f_file_name); $file_name = $file_info; ///////////////////////////////////////////////////////////////////////////////////////// }else{ $file_name='aa.jpg'; } /*$fdfs_obj = new FDFS(Yii::app()->params['fastdfs']); $file_info = $fdfs_obj->fdfs_upload("pic"); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！'); } $file_name = '/'.$file_info['1'].'/'.$file_info['0'];*/ } }else{//试用订单 if(!$type_id || !$goods_id || !$goods_spec_id ||$trial_begin_time=="0000-00-00 00:00:00" ) { Yii::app()->jump->error('填写信息不完整，请填写完整！',Yii::app()->createUrl('order/add')); } } if(!$class_id) { Yii::app()->jump->error('请选择班级'); } $class_data = ClassModel::model()->find('class_id=:class_id',array(':class_id'=>$class_id)); if($class_data) { $apply_class_hide = $class_data->grade; $select_grade = $class_data->grade; } $student_array = array(); $student_id_array = array(); $spec_id = array(); $spec_array = array(); $student_num = 0; $order_no = $this->_getMillisecond().rand(1,9).rand(1,9).rand(1,9); //订单编号 if($class_id||$classify==2) { if($classify!=2){ // if($classify==0){ // $student_data = StudentInfo::model()->getStudentByClassId($class_id); // if($student_data) // { // foreach($student_data as $v) // { // $student_array[$v->student_id] = $v->realname; // $student_id_array[$v->student_id] = $v->student_id; // } // } // }else{ $stujson=json_decode($student_ids); $class_ids=array(); foreach($stujson as $k=>$v){ $class_ids[]=$v->classid; } $student_data = StudentInfo::model()->getStudentInClassId($class_ids); if($student_data) { foreach($student_data as $v) { $student_array[$v->student_id] = $v->realname; $student_id_array[$v->student_id] = $v->student_id; } } // } }else{ $classinfo = ClassModel::model()->findAll("class_id in ($student_ids)"); $classarr=array(); foreach($classinfo as $k=>$v){ $classarr[$v['class_id']]=$v['class_name']; } } if(!$student_ids) { Yii::app()->jump->error('请选择学生，重新上传！',Yii::app()->createUrl('order/add')); } //if($classify!=1){//普通和试用订单 if($classify==2){//试用订单 $student_id_array = explode(',',$student_ids); $student_num = count($student_id_array); }else{//统订和普通订单 $student_num=Yii::app()->request->getPost('stusum'); $student_id_array= json_decode($student_ids); } if($goods_spec_id) { $goods_spec_data = CMSGoodsSpec::model()->find('id=:id ',array(':id'=>$goods_spec_id)); if($goods_spec_data) { if($goods_spec_data->promotion_price) { $goods_spec_data->price = $goods_spec_data->promotion_price; } $goods_data = CMSGoods::model()->find('id=:id',array(':id'=>$goods_spec_data->goods_id)); $goods_term_data = CMSGoodsTerm::model()->findAll('goods_id=:goods_id',array(':goods_id'=>$goods_spec_data->goods_id)); if($goods_data) { //$term_data = CMSTerm::model()->find('id=:id',array(':id'=>$goods_data->term_id)); $goods_spec_realtion_data = CMSGoodsSpecRealtion::model()->findAll('goods_spec_id=:goods_spec_id',array(':goods_spec_id'=>$goods_spec_id)); if($goods_spec_realtion_data) { foreach($goods_spec_realtion_data as $v) { $spec_id[$v->subject_id] = $v->subject_id; } } if($spec_id) { $Criteria = new CDbCriteria(); $Criteria->addInCondition('id',$spec_id); $subject_data = CMSSubject::model()->findAll($Criteria); if($subject_data) { foreach($subject_data as $v) { $spec_array[$v->id] = $v->name; } //取出商品信息 // $transaction= Yii::app()->db251->beginTransaction();//建立事务 Yii::app()->db251->createCommand("START TRANSACTION")->execute(); try { $order_odj = new CMSOrder(); $orderdata['rder_no'] = $order_no; if($classify!=2){ $orderdata['total_price'] = $student_num*$goods_spec_data->price; }else{ $orderdata['total_price'] = 0; } // $order_odj->pay_money = $pay_money; $orderdata['openid'] = $this->coachId; $orderdata['create_time'] = date('Y-m-d H:i:s',time()); // $order_odj->pay_time = $pay_time; $orderdata['grade'] = $apply_class_hide; // $order_odj->prepay_id = null; $orderdata['type'] = 1; $orderdata['school_id'] = $this->schoolId; $orderdata['school_name'] = Yii::app()->session['session_school_name']; // $order_odj->pay_account = $pay_account; // $order_odj->pay_cert = $file_name; $orderdata['classify'] =$classify; $orderdata['apply_time'] = null; $orderdata['create_user'] = Yii::app()->session['coachInfo']['real_name']; $orderdata['quantity'] = $student_num; if($classify==1){ $orderdata['payment_status'] ="1_0"; } if($classify==2){ $orderdata['trial_begin_time'] = $trial_begin_time_test; }else{ if($goods_data->classify!=0){//商品是以有效期结算 if(strtotime($trial_begin_time)== strtotime(date("Y-m-d"))){ $trial_begin_time=date("Y-m-d H:i:s"); $trial_end_time=date("Y-m-d H:i:s",(strtotime($trial_begin_time) + 3600*24*$goods_data->effective_date)); }else{ $trial_end_time=date("Y-m-d",(strtotime($trial_begin_time) + 3600*24*($goods_data->effective_date)-1))." 23:59:59"; } $orderdata['trial_begin_time'] = $trial_begin_time; $orderdata['trial_end_time'] = $trial_end_time; } } $order_odj->updateAll($orderdata,"id=:id",array(":id"=>$order_id)); if($classify!=2){//不是试用订单才有支付信息 if($classify==0){ $order_pay=new CMSOrderPay(); $orderpaydata['order_id']=$order_id; $orderpaydata['pay_money']=$pay_money; if($pay_time){ $orderpaydata['pay_time']=$pay_time; } $orderpaydata['pay_account']=$pay_account; if(@$file_name){ $orderpaydata['pay_cert']=$file_name; } $order_pay->updateAll($orderpaydata,"order_id=:id",array(":id"=>$order_id)); }else{ $order_pay=new CMSPayment(); $orderpaydata['order_id']=$order_id; $orderpaydata['pay_money']=$pay_money; if($pay_time){ $orderpaydata['pay_time']=$pay_time; } $orderpaydata['pay_account']=$pay_account; if(@$file_name){ $orderpaydata['pay_cert']=$file_name; }if(@$next_pay_time){ $orderpaydata['next_pay_time']=$next_pay_time; } $order_pay->updateAll($orderpaydata,"order_id=:id",array(":id"=>$order_id)); // $paymentid=$order_pay->find("order_id=:id",array(":id"=>$order_id)); } } $order_goods_odj = new CMSOrderGoods(); $ordergoodsdata['goods_name'] = $goods_data->goods_name; if($classify!=2){ $ordergoodsdata['price'] = $goods_spec_data->price; }else{ $ordergoodsdata['price'] = 0; } $ordergoodsdata['order_id'] = $order_id; $ordergoodsdata['goods_id'] = $goods_data->id; $ordergoodsdata['goods_type_id'] = $type_id; $ordergoodsdata['goods_type_name'] = $good_type_name; $ordergoodsdata['subject_names'] = $goods_spec_data->name; $ordergoodsdata['grade'] = $goods_data->apply_class; $ordergoodsdata['thumbnail'] = $goods_data->thumbnail; if($goods_data->classify!=0){//商品是以有效期结算 $ordergoodsdata['classify'] = $goods_data->classify; $ordergoodsdata['effective_date'] = $goods_data->effective_date; } $order_goods_odj->updateAll($ordergoodsdata,"order_id=:id",array(":id"=>$order_id)); if($goods_term_data){ foreach($goods_term_data as $v) { $order_good_sem=new CMSOrderGoodsSemester(); $order_good_sem_data['goods_id']=$v->goods_id; $order_good_sem_data['code']=$v->code; $order_good_sem_data['name']=$v->name; $order_good_sem->updateAll($order_good_sem_data,"order_id=:id",array(":id"=>$order_id)); } } foreach($goods_spec_realtion_data as $v) { $order_good_sub=new CMSOrderGoodsSubject(); $order_good_sub_data['subject_id']=$v->subject_id; $order_good_sub_data['subject_name']=$spec_array[$v->subject_id]; $order_good_sub_data['goods_id']=$goods_data->id; $order_good_sub->updateAll($order_good_sub_data,"order_id=:id",array(":id"=>$order_id)); } $order_operate_log_odj = new CMSOrderOperateLog(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderlogid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderlogid=="-1"){ Yii::app()->jump->error('ordergoodsubjectid获取失败，添加失败！'); } $order_operate_log_odj->id =$orderlogid; $order_operate_log_odj->role_name = '学管'; $order_operate_log_odj->user_name = Yii::app()->session['coachInfo']['real_name']; $order_operate_log_odj->info = '修改了订单并重新提交审核'; $order_operate_log_odj->create_time = date('Y-m-d H:i:s',time()); $order_operate_log_odj->order_id = $order_id; $order_operate_log_odj->save(); $order_stu=new CMSOrderStudent(); $order_student_sql='INSERT INTO `order_student` (`id`,`order_id` ,`clazz_id` ,`student_id` ,`student_name`,`clazz_name` )VALUES '; if($classify!=2){ // if($classify==0){ // $newstunum=0; // if($student_ids!=Yii::app()->request->getPost('old_stu_ids')){ // $order_stu->deleteAll("order_id=:oid and not student_id in ($student_ids)",array(":oid"=>$order_id)); // // $old_stu_ids=Yii::app()->request->getPost('old_stu_ids'); // // $old_stu_id_arr= explode(",", $old_stu_ids); // // foreach($student_id_array as $v) // { // if(!in_array($v, $old_stu_id_arr)){ // $newstunum++; // $orders_id= json_decode(file_get_contents(Yii::app()->params['orders_id'])); // $ordergoodstudentid=$orders_id->errCode=="00"?sprintf("%1.0f", $orders_id->data->id):"-1"; // if($ordergoodstudentid=="-1"){ // Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); // } // $order_student_sql.='('.$ordergoodstudentid.','.$order_id.',"'.$class_id.'","'.$v.'","'.(isset($student_array[$v])?$student_array[$v]:'').'","'.$class_name.'"),'; // } // } // } // }else{ $newstunum=0; if($student_ids!=Yii::app()->request->getPost('old_stu_ids')){ $order_stu->deleteAll("order_id=:oid ",array(":oid"=>$order_id)); foreach($student_id_array as $k=>$v) { $class_id=$v->classid; $class_name=$v->classname; $idarr=array(); foreach($v->stus as $s){ $newstunum++; $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $ordergoodstudentid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($ordergoodstudentid=="-1"){ Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); } if(isset($idarr[$ordergoodstudentid])){ $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $ordergoodstudentid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($ordergoodstudentid=="-1"){ Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); } } $order_student_sql.='('.$ordergoodstudentid.','.$order_id.',"'.$class_id.'","'.$s.'","'.(isset($student_array[$s])?$student_array[$s]:'').'","'.$class_name.'"),'; $idarr[$ordergoodstudentid]=$ordergoodstudentid; } unset($idarr); } } // } CMSGoods::model()->updateAll(array('buyer_num'=>($goods_data->buyer_num+$student_num)),'id=:id',array(':id'=>$goods_id)); $order_student_sql = substr($order_student_sql,0,-1); if($newstunum>0){ Yii::app()->db251->createCommand($order_student_sql)->execute(); } }else{ $student_class_relation=new SStudentClassRelation(); $orderclazz=new CMSOrderClazz(); $orderclazz->deleteAll("order_id=:oid ",array(":oid"=>$order_id)); $idarr=array(); foreach($classarr as $k=>$v){ $orderclazz=new CMSOrderClazz(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderclazzid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderclazzid=="-1"){ Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); } if(isset($idarr[$orderclazzid])){ $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderclazzid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderclazzid=="-1"){ Yii::app()->jump->error('ordergoodstudentid获取失败，添加失败！'); } } $stunum=$student_class_relation->getRelationsByClassId_Status_0_count($k); $orderclazz->id=$orderclazzid; $orderclazz->order_id=$order_id; $orderclazz->clazz_id=$k; $orderclazz->clazz_name=$v; $orderclazz->students=$stunum; $orderclazz->save(); $idarr[$orderclazzid]=$orderclazzid; unset($orderclazz); } unset($idarr); } Yii::app()->db251->createCommand("COMMIT")->execute(); $check_order= json_decode($this->curlpost(Yii::app()->params['order_interface'].$order_id)); // $path=Yii::getPathOfAlias('webroot')."/assets/order_interface_log.txt"; // $myfile = fopen($path, "a"); // $txt = "编辑操作，请求".Yii::app()->params['order_interface'].$order_id."接口 orderid:".$order_id." 返回errCode：".$check_order->errCode." \n"; // fwrite($myfile, $txt); // fclose($myfile); if($check_order){ if($check_order->errCode!="00"){ Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败,'.$check_order->errMsg); } }else{ Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败,接口错误'); } } catch(CException $e) { Yii::app()->db251->createCommand("ROLLBACK")->execute(); // $transaction->rollBack(); Yii::app()->jump->error('添加失败，重新添加！',Yii::app()->createUrl('order/add')); } // Yii::app()->db251->createCommand("END")->execute(); $this->redirect($this->createUrl('order/index'."?type=".$ordertype)); } } } } } } Yii::app()->jump->error('添加失败，重新添加！',Yii::app()->createUrl('order/add')); } public function actionpay(){ $order_id = Yii::app()->request->getParam('order_id'); $order_classify= CMSOrder::model()->find("id=:id",array(":id"=>$order_id)); if($order_classify['classify']!=1){ Yii::app()->jump->error('不是统订订单不能续费',Yii::app()->createUrl('order/index')); } $paymoney= CMSPayment::model()->findAll("order_id=:id and status=1",array(":id"=>$order_id)); $paymoneys=0; foreach($paymoney as $k=>$v){ $paymoneys+=$v['pay_money']; } $this->render("pay",array("order_id"=>$order_id,"paymoneys"=>$paymoneys,"order_classify"=>$order_classify)); } public function actiondopay(){ $pay_account = Yii::app()->request->getPost('pay_account'); $pay_money = Yii::app()->request->getPost('pay_money'); $order_id = Yii::app()->request->getPost('order_id'); $pay_time = Yii::app()->request->getPost('pay_time'); if($pay_time){ if(!$pay_time=$this->checktime($pay_time)){ Yii::app()->jump->error('时间格式错误！',Yii::app()->createUrl('order/index')); } } $next_pay_time = Yii::app()->request->getPost('next_pay_time'); if($next_pay_time){ if(!$next_pay_time=$this->checktime($next_pay_time)){ Yii::app()->jump->error('时间格式错误！',Yii::app()->createUrl('order/index')); } } //验证图片 $type = strtolower(substr($_FILES['pic']['name'],strrpos($_FILES['pic']['name'],'.')+1)); $allow_type = array('jpg','jpeg','gif','png'); //定义允许上传的类型 if(!in_array($type, $allow_type)) { Yii::app()->jump->error('上传图片类型不对，请重新上传！',Yii::app()->createUrl('order/add')); } //图片上传 $f_file_tmp = $_FILES['pic']['tmp_name']; $f_real_name = $_FILES['pic']['name']; $f_file_name = dirname($f_file_tmp)."/".$f_real_name; @copy($f_file_tmp, $f_file_name); @rename($f_file_tmp, $f_file_name); if(Yii::app()->params["fdfs_open"]){ /////////////////////////////////////////////////////////////////////////////////////// $fdfs_odj = FDFS::getInstance(Yii::app()->params['fastdfs']); $file_info = $fdfs_odj->upload_filename1($f_file_name,'',$type); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！',Yii::app()->createUrl('order/add')); } @unlink($f_file_name); $file_name = $file_info; }else{ ///////////////////////////////////////////////////////////////////////////////////////// $file_name='aa.jpg'; } /*$fdfs_obj = new FDFS(Yii::app()->params['fastdfs']); $file_info = $fdfs_obj->fdfs_upload("pic"); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！'); } $file_name = '/'.$file_info['1'].'/'.$file_info['0'];*/ $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderpayid=$orders_id->errCode=="00"? $orders_id->data->id:"-1"; if($orderpayid=="-1"){ Yii::app()->jump->error('orderpayid获取失败，添加失败！'); } Yii::app()->db251->createCommand("START TRANSACTION")->execute(); $payment=new CMSPayment(); $payment->id=$orderpayid; $payment->order_id=$order_id; $payment->pay_money=$pay_money; if($pay_time){ $payment->pay_time=$pay_time; } $payment->pay_account=$pay_account; $payment->pay_cert=$file_name; $payment->status=0; if($next_pay_time){ $payment->next_pay_time=$next_pay_time; } $payment->save(); $payment_status= CMSOrder::model()->find("id=:id",array(":id"=>$order_id)); $paymentstatus= explode("_", $payment_status['payment_status']); // var_dump(array("payment_status"=>((int)$paymentstatus[0]+1)."_0"));exit; CMSOrder::model()->updateAll(array("payment_status"=>((int)$paymentstatus[0]+1)."_0"),'id='.$order_id); $order_operate_log_odj = new CMSOrderOperateLog(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderlogid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderlogid=="-1"){ Yii::app()->jump->error('ordergoodsubjectid获取失败，添加失败！'); } $order_operate_log_odj->id =$orderlogid; $order_operate_log_odj->role_name = '学管'; $order_operate_log_odj->user_name = Yii::app()->session['coachInfo']['real_name']; $order_operate_log_odj->info = '第'.((int)$paymentstatus[0]+1) ."期缴费申请提交申请"; $order_operate_log_odj->create_time = date('Y-m-d H:i:s',time()); $order_operate_log_odj->order_id = $order_id; $order_operate_log_odj->save(); Yii::app()->db251->createCommand("COMMIT")->execute(); $check_order= json_decode($this->curlpost(Yii::app()->params['payment_interface'].$orderpayid)); if($check_order){ if($check_order->errCode!="00"){ Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败！'); } }else{ Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败,接口错误'); } $this->redirect(Yii::app()->createUrl('order/index',array('type'=>"all"))); } public function actiondoeditpay(){ $pay_account = Yii::app()->request->getPost('pay_account'); $id = Yii::app()->request->getPost('id'); $pay_money = Yii::app()->request->getPost('pay_money'); $order_id = Yii::app()->request->getPost('orderid'); $pay_time = Yii::app()->request->getPost('pay_time'); if($pay_time){ if(!$pay_time=$this->checktime($pay_time)){ Yii::app()->jump->error('时间格式错误！',Yii::app()->createUrl('order/index')); } } $next_pay_time = Yii::app()->request->getPost('next_pay_time'); if($next_pay_time){ if(!$next_pay_time=$this->checktime($next_pay_time)){ Yii::app()->jump->error('时间格式错误！',Yii::app()->createUrl('order/index')); } } if($_FILES['pic']['name']!=""){ //验证图片 $type = strtolower(substr($_FILES['pic']['name'],strrpos($_FILES['pic']['name'],'.')+1)); $allow_type = array('jpg','jpeg','gif','png'); //定义允许上传的类型 if(!in_array($type, $allow_type)) { Yii::app()->jump->error('上传图片类型不对，请重新上传！',Yii::app()->createUrl('order/add')); } //图片上传 $f_file_tmp = $_FILES['pic']['tmp_name']; $f_real_name = $_FILES['pic']['name']; $f_file_name = dirname($f_file_tmp)."/".$f_real_name; @copy($f_file_tmp, $f_file_name); @rename($f_file_tmp, $f_file_name); if(Yii::app()->params["fdfs_open"]){ /////////////////////////////////////////////////////////////////////////////////////// $fdfs_odj = FDFS::getInstance(Yii::app()->params['fastdfs']); $file_info = $fdfs_odj->upload_filename1($f_file_name,'',$type); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！',Yii::app()->createUrl('order/add')); } @unlink($f_file_name); $file_name = $file_info; }else{ ///////////////////////////////////////////////////////////////////////////////////////// $file_name='aa.jpg'; } /*$fdfs_obj = new FDFS(Yii::app()->params['fastdfs']); $file_info = $fdfs_obj->fdfs_upload("pic"); if(!$file_info) { Yii::app()->jump->error('上传图片失败，请重新上传！'); } $file_name = '/'.$file_info['1'].'/'.$file_info['0'];*/ } Yii::app()->db251->createCommand("START TRANSACTION")->execute(); $payment=new CMSPayment(); $paymentdata['order_id']=$order_id; $paymentdata['pay_money']=$pay_money; if($pay_time){ $paymentdata['pay_time']=$pay_time; } $paymentdata['pay_account']=$pay_account; if(@$file_name){ $paymentdata['pay_cert']=$file_name; } $paymentdata['status']=0; if($next_pay_time){ $paymentdata['next_pay_time']=$next_pay_time; } // var_dump($paymentdata);echo $id;exit; $payment->updateAll($paymentdata,"id=:id",array(":id"=>$id)); $payment_status= CMSOrder::model()->find("id=:id",array(":id"=>$order_id)); $paymentstatus= explode("_", $payment_status['payment_status']); CMSOrder::model()->updateAll(array("payment_status"=>((int)$paymentstatus[0])."_0"),'id=:id',array(":id"=>$order_id)); $order_operate_log_odj = new CMSOrderOperateLog(); $orders_id= json_decode($this->curlget(Yii::app()->params['orders_id'])); if(!$orders_id){ Yii::app()->jump->error('接口错误'); } $orderlogid=$orders_id->errCode=="00"?$orders_id->data->id:"-1"; if($orderlogid=="-1"){ Yii::app()->jump->error('ordergoodsubjectid获取失败，添加失败！'); } $order_operate_log_odj->id =$orderlogid; $order_operate_log_odj->role_name = '学管'; $order_operate_log_odj->user_name = Yii::app()->session['coachInfo']['real_name']; $order_operate_log_odj->info = '第'.((int)$paymentstatus[0]) ."期缴费申请重新提交申请"; $order_operate_log_odj->create_time = date('Y-m-d H:i:s',time()); $order_operate_log_odj->order_id = $order_id; $order_operate_log_odj->save(); Yii::app()->db251->createCommand("COMMIT")->execute(); $check_order= json_decode($this->curlpost(Yii::app()->params['payment_interface'].$id)); if($check_order){ if($check_order->errCode!="00"){ Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('缴费失败！'); } }else{ Yii::app()->db251->createCommand("ROLLBACK")->execute(); Yii::app()->jump->error('添加失败,接口错误'); } $this->redirect(Yii::app()->createUrl('order/index',array('type'=>"all"))); } public function actionpayedit(){ $id=Yii::app()->request->getParam('id'); $data['pay']=CMSPayment::model()->find("id=:id",array(":id"=>$id)); $data['id']=$id; $order=$data['pay']['order_id']; $order_classify= CMSOrder::model()->find("id=:id",array(":id"=>$order)); if($order_classify['classify']!=1){ Yii::app()->jump->error('不是统订订单不能续费',Yii::app()->createUrl('order/index')); } $data['order_classify']=$order_classify; $paymoney= CMSPayment::model()->findAll("order_id=:id and status=1",array(":id"=>$order)); $paymoneys=0; foreach($paymoney as $k=>$v){ $paymoneys+=$v['pay_money']; } $data['paymoneys']=$paymoneys; $this->render("payedit",$data); } public function actionInfo() { $ordertype= Yii::app()->request->getParam("type")?Yii::app()->request->getParam("type"):"ordinary"; if($ordertype!=="test"&&$ordertype!=="all"&&$ordertype!=="ordinary"){ Yii::app()->jump->error('参数不正确'); } $data = array(); $typeclassfly=array("1"=>"ordinary","2"=>"test",'3'=>"all"); $order_id = Yii::app()->request->getParam('order_id'); $data['order_id']=$order_id; $order_data = CMSOrder::model()->find('id=:id',array(':id'=>$order_id)); if($order_data) { // $order_operate_log_data = CMSOrderOperateLog::model()->findAll('order_id=:order_id',array('order_id'=>$order_id)); $order_goods_data = CMSOrderGoods::model()->find('order_id=:order_id',array('order_id'=>$order_id)); $order_goods_se_data = CMSOrderGoodsSemester::model()->findAll('order_id=:order_id',array('order_id'=>$order_id)); $order_goods_subject_data = CMSOrderGoodsSubject::model()->find('order_id=:order_id',array('order_id'=>$order_id)); if($order_data->classify!=2){ if($ordertype=="ordinary"){ $data['orderpay'] = CMSOrderPay::model()->find('order_id=:id',array(':id'=>$order_id)); }else{ $data['orderpay'] = CMSPayment::model()->findAll('order_id=:id',array(':id'=>$order_id)); } $criteria = new CDbCriteria(); $criteria->select="clazz_id"; $criteria->addCondition('order_id=:order_id'); $criteria->params[':order_id'] = $order_id; $criteria->group="clazz_id"; $classids = CMSOrderStudent::model()->findAll($criteria); $classidarr=array(); foreach($classids as $v){ $classidarr[]=$v['clazz_id']; } $stu=Yii::app()->db251->createCommand("select clazz_id,count(id) as num from order_student where clazz_id in (". implode(",", $classidarr).") and order_id=$order_id GROUP BY clazz_id")->queryAll(); $criteria = new CDbCriteria(); $criteria->select="class_id,class_name"; $criteria->addInCondition("class_id", $classidarr); $classes= ClassModel::model()->findAll($criteria); $stutotal=0; $classinfo=array(); foreach($classes as $k=>$v){ $classinfo[$k]['class_id']=$v->class_id; $classinfo[$k]['class_name']=$v->class_name; foreach($stu as $sk=>$sv){ if((string)$v['class_id']===(string)$sv['clazz_id']){ $stutotal+=$sv['num']; $classinfo[$k]['stunum']=$sv['num']; } } } $data['stutotal']=$stutotal; $data['classes']=$classinfo; }else{ $classes= CMSOrderClazz::model()->findAll("order_id=:order_id",array(":order_id"=>$order_id)); if($classes){ foreach($classes as $k=>$v){ $data['classes'][$k]['class_id']=$v['clazz_id']; $data['classes'][$k]['class_name']=$v['clazz_name']; $data['classes'][$k]['stunum']=$v['students']; } }else{ Yii::app()->jump->error('订单信息不完整！',Yii::app()->createUrl('order/index',array("type"=>$typeclassfly[$order_data->classify]))); } } if(!$order_goods_data || !$order_goods_subject_data || !$order_operate_log_data ) { Yii::app()->jump->error('订单信息不完整！',Yii::app()->createUrl('order/index',array("type"=>$typeclassfly[$order_data->classify]))); } }else { Yii::app()->jump->error('无订单信息！',Yii::app()->createUrl('order/index',array("type"=>$typeclassfly[$order_data->classify]))); } $data['order'] = $order_data; $sql="SELECT o.id, count(os.id) AS stunum, os.clazz_name, os.clazz_id, o.total_price, o.`status`, ob.money, o.apply_time, o.original_order_id, o.create_time FROM `order` AS o LEFT JOIN order_student AS os ON o.id = os.order_id LEFT JOIN `order_back` AS ob ON o.id = ob.order_id WHERE o.original_order_id = {$order_id} AND o.school_id GROUP BY os.order_id, os.clazz_id ORDER BY o.create_time DESC"; $orderinfo = Yii::app()->db251->createCommand($sql)->queryAll(); // var_dump($orderinfo);exit; $data['back_order']=array(); foreach($orderinfo as $k=>$v){ if(!isset($data['back_order'][$v['id']])){ $data['back_order'][$v['id']]=$v; } $data['back_order'][$v['id']]['class'][$k]['clazz_name']=$v['clazz_name']; $data['back_order'][$v['id']]['class'][$k]['clazz_id']=$v['clazz_id']; $data['back_order'][$v['id']]['class'][$k]['stunum']=$v['stunum']; } $data['is_hava_back']=false; foreach($data['back_order'] as $v){ if($v['status']==0){ $data['is_hava_back']=true; } } if($data['order']['status']==2){ $work_flow_id=$order_data['work_flow_id']; $wid= CMSWorkflowuserDetail::model()->find(array( 'select' =>array('id'), 'condition' => 'work_flow_id='.$work_flow_id." and status=2", "order"=>"id desc", "limit"=>"1" )); $data['orderaudit']= CMSWorkflowuserAudit::model()->find(array( 'select' =>array('remark'), 'condition' => 'work_flow_detail_id='.$wid['id'], "order"=>"id desc", "limit"=>"1" )); } $sql="SELECT gt.`code`, og.classify, o.trial_end_time FROM `order` AS o LEFT JOIN `order_goods` AS og ON og.order_id = o.id LEFT JOIN `goods_term` AS gt ON gt.goods_id = og.goods_id WHERE o.id = {$order_id} AND o.school_id "; $good_code=Yii::app()->db251->createCommand($sql)->queryAll(); $semmodel=new SSemester(); $now_code= $semmodel->getSemester($this->semesterId); if($good_code[0]['classify']==0){ if(isset($good_code[0])){ if($now_code['refer_code']>$good_code[0]['code']) $data['is_time_over']=true; else $data['is_time_over']=false; }else{ $data['is_time_over']=false; } }else{ if(time()> strtotime($good_code[0]['trial_end_time'])){ $data['is_time_over']=true; }else{ $data['is_time_over']=false; } } $sql="select id from order_student where order_id={$order_id} and chargeback=0"; $ishava_stu=Yii::app()->db251->createCommand($sql)->queryAll(); if(empty($ishava_stu)) $data['ishava_stu']=false; else $data['ishava_stu']=true; if($order_data->chargeback==2){ $apply_time=CMSOrder::model()->find(array( 'select' =>array('apply_time'), 'condition' => 'original_order_id='.$order_id." and status=1", "order"=>"id desc", "limit"=>"1" )); $data['apply_time']=$apply_time['apply_time']; } $data['goods'] = $order_goods_data; $data['goods_se'] = $order_goods_se_data; $data['subject'] = $order_goods_subject_data; $data['log'] = $order_operate_log_data; $data['ordertype'] = $ordertype; $this->render('info',$data); } private function _getMillisecond() { list($t1, $t2) = explode(' ', microtime()); return (float)sprintf('%.0f', (floatval($t1) + floatval($t2)) * 1000); } public function actionMorestudent() { $data = array(); $order_id = Yii::app()->request->getPost('order_id'); $pages = Yii::app()->request->getPost('pages'); $criteria = new CDbCriteria(); $criteria->addCondition('order_id=:order_id'); $criteria->params[':order_id'] = $order_id; $criteria->limit = 2*$pages; $criteria->order = 'id DESC' ; $order_student_data = CMSOrderStudent::model()->findAll($criteria); if($order_student_data) { foreach($order_student_data as $v) { $data[] = $v->attributes; } echo json_encode(array('status'=>0,'result'=>$data));exit; } echo json_encode(array('status'=>0,'result'=>''));exit; } public function actionstudent(){ $page= Yii::app()->request->getParam("page")>0?Yii::app()->request->getParam("page"):1; $data['realname']=$realname= Yii::app()->request->getParam("realname"); $today=date("Y-m-d H:i:s"); $goodtype= CMSGoodsType::model()->findAll(); $data['goodtype']=$goodtype; $limit=20; $data['page']=$page; $start=($page-1)*$limit; $where=""; if($realname){ $where=" and os.student_name like '%{$realname}%'"; } $semester=new SSemester(); $nowsem=$semester->getCurrentSemester(); $sql="SELECT student_id, student_name, group_concat(trial_begin_time) AS trial_begin_time, group_concat(trial_end_time) AS trial_end_time, group_concat(type_id) AS type_id, group_concat(classify) AS classify, group_concat(`code`) AS `code` FROM ( SELECT o.id, IFNULL(o.trial_begin_time, '') AS trial_begin_time, IFNULL(o.trial_end_time,'') as trial_end_time, g.type_id, g.classify, IFNULL(gt.`code`,0) as `code`, os.student_name, os.student_id FROM `order` AS o JOIN order_goods AS og ON og.order_id = o.id JOIN goods AS g ON g.id = og.goods_id left JOIN goods_term AS gt ON g.id = gt.goods_id left JOIN order_goods_semester AS ogs ON o.id = ogs.order_id JOIN order_student AS os ON os.order_id = o.id WHERE (o.trial_end_time >= '{$today}' OR ogs.`code` ='{$nowsem['refer_code']}') and o.status=1 AND o.school_id ={$this->schoolId} {$where} AND os.chargeback = 0 ORDER BY g.type_id ) t GROUP BY student_name limit {$start},{$limit}"; $stu_order=Yii::app()->db251->createCommand($sql)->queryAll(); $termcodes=array(); foreach($stu_order as $v){ $classify= explode(",", $v['classify']); $code= explode(",", $v['code']); foreach($classify as $k=>$cv){ if($cv==0){ $termcodes[]=$code[$k]; } } } $sem=Semester::model()->findAll(array( 'select' => 'refer_code,end_time,start_time', 'condition' => 'refer_code in (:termcodes)', 'params' => array(':termcodes'=> implode(",", $termcodes)) )); $semtime=array(); foreach($sem as $v){ $semtime[$v['refer_code']]['end_time']=date("Y-m-d",$v['end_time']); $semtime[$v['refer_code']]['start_time']=date("Y-m-d",$v['start_time']); } $data['semtime']=$semtime; if($stu_order){ $stuids=array(); foreach($stu_order as $v){ $stuids[]=$v['student_id']; } $stuids= implode(",", $stuids); $sql="select student_id,student_card from student where student_id in ({$stuids})"; $student_card=Yii::app()->businessDb->createCommand($sql)->queryAll(); foreach($stu_order as $k=>$v){ foreach($student_card as $vv){ if((string)$vv['student_id']===(string)$v['student_id']){ $stu_order[$k]['student_card']=$vv['student_card']; } } } } $data['stu_order']=$stu_order; $sql="SELECT count(DISTINCT student_id) AS count FROM ( SELECT o.school_id, o.trial_end_time, g.type_id, os.student_name, os.student_id FROM `order` AS o JOIN order_goods AS og ON og.order_id = o.id JOIN goods AS g ON g.id = og.goods_id JOIN order_student AS os ON os.order_id = o.id left JOIN goods_term AS gt ON g.id = gt.goods_id left JOIN order_goods_semester AS ogs ON o.id = ogs.order_id WHERE (o.trial_end_time >= '{$today}' OR ogs.`code` ='{$nowsem['refer_code']}') and o.status=1 AND o.school_id = {$this->schoolId} {$where} AND os.chargeback = 0 ORDER BY g.type_id ) t"; $count=Yii::app()->db251->createCommand($sql)->queryRow(); $data['count']=$count['count']; $data['totalpage']= ceil($count['count']/$limit); $this->render("student",$data); } public function actiondelorder(){ $order_id = safe_replace(Yii::app()->request->getParam('order_id')); $type = safe_replace(Yii::app()->request->getParam('type')); CMSOrder_back::model()->deleteAll("order_id={$order_id}"); CMSOrder::model()->deleteAll("id={$order_id}"); CMSOrderClazz::model()->deleteAll("order_id={$order_id}"); CMSOrderGoods::model()->deleteAll("order_id={$order_id}"); CMSOrderGoodsSemester::model()->deleteAll("order_id={$order_id}"); CMSOrderGoodsSubject::model()->deleteAll("order_id={$order_id}"); CMSOrderStudent::model()->deleteAll("order_id={$order_id}"); CMSOrderPay::model()->deleteAll("order_id={$order_id}"); CMSOrderStudent::model()->deleteAll("order_id={$order_id}"); CMSOrderOperateLog::model()->deleteAll("order_id={$order_id}"); $this->redirect($this->createUrl("order/index",array('type'=>$type))); } } //