function actionDeliveryDetail()
{
//过滤语句
$using = new class_using();
$request = $using->safeUsing('get', 'controller:string,action:string');
//设置查询语句
$dbo =& FLEA::getDBO();
$this->sql = 'select * from v_delivery';
//查询条件-按日期查询
$cond = new class_conditions();
$formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
$todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
$cond->between($formdate, $todate, 'fdate', 'D', 2);
//排序
$order = new class_order($request);
//获取SQL查询的全部记录
$alldata = $dbo->getAll($this->sql . $cond->getWhere() . $order->getOrder());
$xls = new class_excel();
$xls->addArray($this->gethead($alldata));
$xls->addArray($this->getdata($alldata));
$xls->addArray($this->getfoot($alldata));
$xls->generateXML("DeliveryDetail");
}
function actionDeliveryDetail()
{
//过滤语句
$using = new class_using();
$request = $using->safeUsing('get', 'controller:string,action:string');
//设置查询语句
$dbo =& FLEA::getDBO();
$this->sql = 'select FCustomerType,sum(FSaleAmountIncludeTax) as FSaleAmountIncludeTax ,sum(FSaleAmount) as FSaleAmount,sum(FAmount) as FAmount,sum(FProfit) as FProfit,case when sum(FSaleAmount) = 0 then 0 else sum(FProfit)/sum(FSaleAmount) end FProfitRate from v_salesdetail';
//查询条件-按日期查询
$cond = new class_conditions();
$formdate = isset($request['formdate']) ? $request['formdate'] : date("Y-m-d");
$todate = isset($request['todate']) ? $request['todate'] : date("Y-m-d");
$FCustomerType = isset($request['FCustomerType']) ? trim(rawurldecode($request['FCustomerType'])) : null;
$cond->between($formdate, $todate, 'fdate', 'D', 2);
$cond->equal($FCustomerType, 'FCustomerType', 'S', ' and ');
//排序
$order = new class_order($request);
//获取SQL查询的全部记录
$alldata = $dbo->getAll($this->sql . $cond->getWhere() . ' group by FCustomerType ' . $order->getOrder());
$xls = new class_excel();
$xls->addArray($this->gethead($alldata));
$xls->addArray($this->getdata($alldata));
$xls->addArray($this->getfoot($alldata));
$xls->generateXML("DeliveryDetail");
}
