public function getOrderslist()
{
DB::connection()->enableQueryLog();
$Orders = DB::table('Orders');
$Orders->leftJoin('order_shipping', 'Orders.id', '=', 'order_shipping.order_id');
$Orders->select('Orders.id', 'Orders.buy_tel', 'Orders.order_created', 'Orders.voucher_name', 'Orders.pay_total', 'order_shipping.shipping_code', 'Orders.buy_name', 'Orders.taopix_order_id', 'Orders.item_count', 'Orders.status');
$orderid = Input::get('orderid');
if ($orderid) {
$Orders->where('taopix_order_id', $orderid);
}
$buytel = Input::get('buy_tel');
if ($buytel) {
$Orders->where('buy_tel', $buytel);
}
$buyname = Input::get('buy_name');
if ($buyname) {
$Orders->where('buy_name', $buyname);
}
$createdStart = Input::get('order_created_start');
$createdEnd = Input::get('order_created_end');
if ($createdStart && $createdEnd) {
//$where .= ' AND order_created between ' . $createdStart."'"." AND ' ".$createdEnd ."'";
$Orders->whereBetween('order_created', [$createdStart, $createdEnd]);
}
//var_dump($createdStart.$createdEnd);exit;
$orders['search']['orderid'] = $orderid;
$orders['search']['buytel'] = $buytel;
$orders['search']['buyname'] = $buyname;
$orders['search']['createdStart'] = $createdStart;
$orders['search']['createdEnd'] = $createdEnd;
$rs = $Orders->orderBy('Orders.id', 'desc')->groupBy('taopix_order_id')->paginate(10);
$queries = DB::getQueryLog();
if ($rs) {
for ($i = 0; $i < count($rs); $i++) {
// $rs[$i]['shipping_code'] = OrderShipping::getShippingCode($rs[$i]['id']);
//var_dump($rs[$i]->id);exit;
$OrderShipping = new OrderShipping();
$shippingCode = $OrderShipping->getShippingCode($rs[$i]->id);
if ($shippingCode) {
$rs[$i]->shipping_code = $shippingCode;
} else {
$rs[$i]->shipping_code = 0;
}
//var_dump($rs[$i]);
}
} else {
return false;
}
// exit;
$orders['data'] = $rs;
return $orders;
}
public function exportExcel()
{
$Orders = DB::table('Orders');
$Orders->leftJoin('order_shipping', 'Orders.id', '=', 'order_shipping.order_id');
/*
$Orders->select('Orders.id','Orders.buy_tel','Orders.order_created','Orders.voucher_name','Orders.pay_total',
'order_shipping.shipping_code', 'Orders.buy_name as 收货人姓名','Orders.taopix_order_id as taopix订单id','Orders.item_count as 商品总数',
'Orders.status as 状态','Orders.voucher_name as 优惠名称','Orders.voucher_code as 优惠码','Orders.voucher_price as 优惠价格');*/
$orderid = Input::get('orderid');
if ($orderid) {
$Orders->where('taopix_order_id', $orderid);
}
$buytel = Input::get('buy_tel');
if ($buytel) {
$Orders->where('buy_tel', $buytel);
}
$buyname = Input::get('buy_name');
if ($buyname) {
$Orders->where('buy_name', $buyname);
}
$createdStart = Input::get('order_created_start');
$createdEnd = Input::get('order_created_end');
if ($createdStart && $createdEnd) {
//$where .= ' AND order_created between ' . $createdStart."'"." AND ' ".$createdEnd ."'";
$Orders->whereBetween('order_created', [$createdStart, $createdEnd]);
}
$data = $Orders->orderBy('Orders.id', 'desc')->get();
if ($data) {
for ($i = 0; $i < count($data); $i++) {
$OrderShipping = new OrderShipping();
$shippingCode = $OrderShipping->getShippingCode($data[$i]->id);
if ($shippingCode) {
$code = '';
foreach ($shippingCode as $value) {
$code .= $value->shipping_code . '|' . $value->created_at . '&';
}
$data[$i]->shipping_code = $code;
} else {
$data[$i]->shipping_code = 0;
}
//var_dump($rs[$i]);
}
} else {
return false;
}
$data = $this->object_array($data);
Excel::create('order' . date("YmdHis") . rand(10, 100), function ($excel) use($data) {
$excel->sheet('Sheetname', function ($sheet) use($data) {
$sheet->fromArray($data);
$sheet->row(1, array('ID', 'taopix订单id', '订单提交时间', '优惠活动', '实际支付金额', '物流单号', '收货人姓名', '收货人电话', '收货地址', '收货人省份', '收货人城市', '收货人区县', '收货人邮箱', '收货人邮编', '优惠名称', '优惠码', '优惠价格', '物流费', '物流单号', '物流名称', '购买商品总数量', '商品总价格', '订单总金额', '订单实际支付金额', '支付方式名称', '支付方式代码', '支付时间', '支付商户订单号', '支付状态', '订单生产时间', '数据插入时间', '数据更新时间', '订单id', '商品id', '物流单号'));
});
})->download('xls');
}
