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));
}
