public function actionSalesReport() { $str = Yii::app()->request->getParam('str'); $text = Yii::app()->request->getParam('text'); $begin_time = Yii::app()->request->getParam('begin_time', date('Y-m-d', time())); $end_time = Yii::app()->request->getParam('end_time', date('Y-m-d', time())); $criteria = new CDbCriteria(); // $criteria->select = 'year(t.update_at) as y_all,month(t.update_at) as m_all,day(t.update_at) as d_all,t.dpid,t.update_at,sum(t.reality_total) as all_reality,t.paytype,t.payment_method_id,t.order_status'; // $criteria->with = array('company','paymentMethod'); // $criteria->condition = 't.order_status in(3,4,8) and t.dpid='.$this->companyId ; // if($str){ // $criteria->condition = ' t.order_status in(3,4,8) and t.dpid in('.$str.')'; // } // $criteria->addCondition("t.update_at >='$begin_time 00:00:00'"); // $criteria->addCondition("t.update_at <='$end_time 23:59:59'"); // if($text==1){ // $criteria->group ='t.paytype,t.dpid,t.payment_method_id,year(t.update_at)'; // $criteria->order = 'year(t.update_at) asc,t.dpid asc'; // }elseif($text==2){ // $criteria->group ='t.paytype,t.dpid,t.payment_method_id,month(t.update_at)'; // $criteria->order = 'year(t.update_at) asc,month(t.update_at) asc,t.dpid asc'; // }else{ // $criteria->group ='t.paytype,t.dpid,t.payment_method_id,day(t.update_at)'; // $criteria->order = 'year(t.update_at) asc,month(t.update_at) asc,day(t.update_at) asc,t.dpid asc'; // } $criteria->select = 'year(t.update_at) as y_all,month(t.update_at) as m_all,day(t.update_at) as d_all,t.dpid,t.update_at,sum(t.pay_amount) as all_reality,t.paytype,t.payment_method_id'; $criteria->with = array('company', 'order8'); $criteria->condition = ' t.dpid=' . $this->companyId; if ($str) { $criteria->condition = ' t.dpid in(' . $str . ')'; } $criteria->addCondition("order8.update_at >='{$begin_time} 00:00:00'"); $criteria->addCondition("order8.update_at <='{$end_time} 23:59:59'"); if ($text == 1) { $criteria->group = 't.paytype,t.dpid,year(t.update_at)'; $criteria->order = 'year(t.update_at) asc,t.dpid asc'; } elseif ($text == 2) { $criteria->group = 't.paytype,t.dpid,month(t.update_at)'; $criteria->order = 'year(t.update_at) asc,month(t.update_at) asc,t.dpid asc'; } else { $criteria->group = 't.paytype,t.dpid,day(t.update_at)'; $criteria->order = 'year(t.update_at) asc,month(t.update_at) asc,day(t.update_at) asc,t.dpid asc'; } //$criteria->order = 't.update_at asc,t.dpid asc'; //$criteria->group = 't.paytype,t.payment_method_id'; $pages = new CPagination(OrderPay::model()->count($criteria)); // $pages->setPageSize(1); $pages->applyLimit($criteria); //var_dump($criteria);exit; $model = OrderPay::model()->findAll($criteria); $comName = $this->getComName(); $this->render('salesReport', array('models' => $model, 'pages' => $pages, 'begin_time' => $begin_time, 'end_time' => $end_time, 'text' => $text, 'str' => $str, 'comName' => $comName)); }
public function actionPaymentRecord() { $criteria = new CDbCriteria(); $begin_time = Yii::app()->request->getParam('begin_time', date('Y-m-d', time())); $end_time = Yii::app()->request->getParam('end_time', date('Y-m-d', time())); $Did = Yii::app()->request->getParam('Did', 0); //var_dump($begin_time);exit; $orderID = Yii::app()->request->getParam('orderID'); //var_dump($orderID);exit; $criteria->select = 't.*'; //代表了要查询的字段,默认select='*'; $criteria->addCondition("t.dpid= " . $this->companyId); // if ($Did > 0){ // $criteria->addCondition("t.order_id = '$Did'");} $criteria->addCondition("t.update_at >='{$begin_time} 00:00:00'"); $criteria->addCondition("t.update_at <='{$end_time} 23:59:59'"); if ($orderID) { $criteria->addCondition("t.order_id= " . $orderID); } //$criteria->select = 't1.should_total'; //var_dump($begin_time);exit; $criteria->with = array("company", "order"); //连接表 //$criteria->join = 'left join nb_order t1 on (t.dpid = t1.dpid and t.order_id = t1.lid )'; //连接表 //var_dump();exit; // $criteria->join = 'left join nb_company on t.dpid = nb_company.dpid '; //连接表 $criteria->order = 't.order_id ASC'; //排序条件 // var_dump($begin_time);exit; //$criteria->group = 'group 条件'; //$criteria->having = 'having 条件 '; $criteria->distinct = TRUE; //是否唯一查询 //$criteria = new CDbCriteria; //$sql = "select t1.company_name, t2.name, t.* from nb_order t left join nb_payment_method t2 on( t.payment_method_id = t2.lid and t.dpid = t2.dpid ) left join nb_company t1 on t.dpid = t1.dpid where t.order_status in(3,4,8) and t.update_at >= '$begin_time 00:00:00' and t.update_at <= '$end_time 23:59:59' and t.dpid= ".$this->companyId; //var_dump($sql);exit; //$connect = Yii::app()->db->createCommand($sql); //$model = $connect->queryAll(); $pages = new CPagination(OrderPay::model()->count($criteria)); //$pages->PageSize = 10; $pages->applyLimit($criteria); // 注意事项:pages语句 必须放在 model 语句前面才能有效的执行。。。 $model = OrderPay::model()->findAll($criteria); //var_dump($model);exit; //$categoryId = Yii::app()->request->getParam('cid',0); //exit; $this->render('paymentRecord', array('models' => $model, 'pages' => $pages, 'begin_time' => $begin_time, 'end_time' => $end_time, 'Did' => $Did, 'orderID' => $orderID)); }