request->get('categoryType', 1); $condition = ' AND STATUS=1 AND (FIND_IN_SET(2,GIFT_TYPE)>0'; $isStudio = User::getEnCodeInfo(\Yii::$app->user->id)['IS_STUDIO']; if($isStudio==1){ $condition.= " OR FIND_IN_SET(4,GIFT_TYPE)>0"; } $condition .= ") AND CATEGORY_TYPE = :CATEGORY_TYPE"; $params[':CATEGORY_TYPE'] = intval($categoryType); $data = ShopGoods::lists($condition, $params, [ 'orderBy' => 'SORT ASC,CREATED_AT DESC', 'from' => ShopGoods::tableName(), ]); foreach ($data['list'] as $key => $value) { if ($value['TYPE'] == 1 || $value['TYPE'] == 2) { $data['list'][$key]['DISCOUNT'] = ShopGoods::GOODS_TYPE[$value['TYPE']]['discount']; } else { $data['list'][$key]['DISCOUNT'] = $value['SELL_DISCOUNT']*100; } // $data['list'][$key]['DISCOUNT'] = ShopGoods::GOODS_TYPE[$value['TYPE']]['discount']; } return static::notice($data); } /** * 获取商品详情 * @return mixed * @throws \yii\web\HttpException */ public function actionGoodsDetail(){ $id = \Yii::$app->request->get('id'); $data = null; if($id){ $data = ShopGoods::findOneAsArray('ID=:ID AND STATUS=1', [':ID'=>$id]); } return static::notice($data); } /** * 购物车订单展示 * @throws \yii\web\HttpException */ public function actionShowCart(){ $userId = \Yii::$app->user->id; $payList = ShopGoods::payTypes(); $allAddress = ReceiveAddress::findAllAsArray('USER_ID=:USER_ID', [':USER_ID'=>$userId]); if($allAddress) { foreach ($allAddress as $key => $row) { $allAddress[$key]['PROVINCE_NAME'] = Region::getCnName($row['PROVINCE']); $allAddress[$key]['CITY_NAME'] = Region::getCnName($row['CITY']); $allAddress[$key]['COUNTY_NAME'] = Region::getCnName($row['COUNTY']); } } $userBalance = [ 'points' => 0, 'cash' => 0, 'exchange' => 0, 'travel_points' => 0, 'car_points' => 0, 'house_points' => 0, ]; if ($userBonusResult = UserBonus::findOneAsArray(['USER_ID' => $userId])) { $userBalance['points'] = $userBonusResult['RECONSUME_POINTS']; $userBalance['exchange'] = $userBonusResult['EXCHANGE_POINTS']; $userBalance['travel_points'] = $userBonusResult['TRAVEL_POINTS']; $userBalance['car_points'] = $userBonusResult['CAR_POINTS']; $userBalance['house_points'] = $userBonusResult['HOUSE_POINTS']; } if ($userCashResult = UserWallet::findOneAsArray(['USER_ID' => $userId])) { $userBalance['cash'] = $userCashResult['CASH']; } return static::notice( [ 'payList'=>$payList, 'allAddress'=>$allAddress, 'userBalance'=>$userBalance, 'sellType' => ShopGoods::CATEGORY_TYPE, ]); } /** * 确认订单 */ public function actionSureOrder(){ if (\Yii::$app->request->isPost) { $formModel = new OrderForm(); $formModel->scenario = 'userOrder'; $formModel->remark = '复销备注'; $post = \Yii::$app->request->post(); $post['type'] = DeclarationForm::TYPE_FX; if ($formModel->load($post, '') && $formModel->add()) { return static::notice('购物成功'); } else { return static::notice(Form::formatErrorsForApi($formModel->getErrors()),400); } } } /** * 订单支付成功 * @throws \yii\web\HttpException */ public function actionPaySuccess(){ $orderSn = \Yii::$app->request->get('orderSn'); $data = null; if($orderSn){ $data = Order::findOneAsArray('SN=:SN', [':SN'=>$orderSn]); } return static::notice($data); } /** * 我的报单 * @return mixed * @throws \yii\web\HttpException */ public function actionDecOrderList() { $condition = ' AND USER_ID=:USER_ID AND IS_DEL=0'; $params[':USER_ID'] = \Yii::$app->user->id; $data = DecOrder::lists($condition, $params, [ 'select' => 'DO.*,U.USER_NAME USER_NAME,U.REAL_NAME REAL_NAME,RU.USER_NAME REC_USER_NAME,RU.REAL_NAME REC_REAL_NAME,CU.USER_NAME CON_USER_NAME,CU.REAL_NAME CON_REAL_NAME,OG.*', 'orderBy' => 'DO.CREATED_AT DESC', 'from' => DecOrder::tableName() . ' AS DO', 'join' => [ ['LEFT JOIN', User::tableName() . ' AS U', 'DO.TO_USER_ID=U.ID'], ['LEFT JOIN', User::tableName() . ' AS RU', 'DO.REC_USER_ID=RU.ID'], ['LEFT JOIN', User::tableName() . ' AS CU', 'DO.CON_USER_ID=CU.ID'], ['LEFT JOIN', OrderGoods::tableName() . ' AS OG', 'OG.ORDER_SN=DO.ORDER_SN'], ], ]); return static::notice($data); } /** * 我的订单 * @return mixed * @throws \yii\web\HttpException */ public function actionOrderList() { $uname = Info::getUserNameByUserId(\Yii::$app->user->id); $condition = " AND ORDER_TYPE='FX' AND (USER_ID=:USER_ID OR CREATE_USER='$uname')"; $params[':USER_ID'] = \Yii::$app->user->id; $data = Order::lists($condition, $params, [ 'select' => 'O.*,U.REAL_NAME,OG.*,SG.CATEGORY_TYPE', 'orderBy' => 'O.CREATED_AT DESC', 'from' => Order::tableName() . ' AS O', 'join' => [ ['LEFT JOIN', User::tableName() . ' AS U', 'U.ID=O.USER_ID'], ['LEFT JOIN', OrderGoods::tableName() . ' AS OG', 'OG.ORDER_SN=O.SN'], ['LEFT JOIN', ShopGoods::tableName() . ' AS SG', 'SG.ID=OG.GOODS_ID'], ], ]); foreach ($data['list'] as $key => $value) { $data['list'][$key]['PAY_AT'] = Date::convert($value['PAY_AT'],'Y-m-d H:i:s'); $data['list'][$key]['CATEGORY_TYPE'] = intval($value['CATEGORY_TYPE']); $data['list'][$key]['CATEGORY'] = array_column(ShopGoods::CATEGORY_TYPE, NULL, 'id')[$value['CATEGORY_TYPE']]['name'] ?? '普通商品'; $data['list'][$key]['FULL_ADDRESS'] = ''; if($value['PROVINCE']){ $data['list'][$key]['FULL_ADDRESS'] .= Region::getCnName($value['PROVINCE']); } if($value['CITY']){ $data['list'][$key]['FULL_ADDRESS'] .= Region::getCnName($value['CITY']); } if($value['COUNTY']){ $data['list'][$key]['FULL_ADDRESS'] .= Region::getCnName($value['COUNTY']); } $data['list'][$key]['FULL_ADDRESS'] .= $value['ADDRESS']; } return static::notice($data); } /** * 会员复消 */ public function actionReconsume() { $condition = ' AND STATUS=1 AND (FIND_IN_SET(2,GIFT_TYPE)>0 OR FIND_IN_SET(4,GIFT_TYPE)>0)'; $data = ShopGoods::lists($condition, [], [ 'orderBy' => 'SORT ASC,CREATED_AT DESC', 'from' => ShopGoods::tableName(), ]); foreach ($data['list'] as $key => $value) { if ($value['TYPE'] == 1 || $value['TYPE'] == 2) { $data['list'][$key]['DISCOUNT'] = ShopGoods::GOODS_TYPE[$value['TYPE']]['discount']; } else { $data['list'][$key]['DISCOUNT'] = $value['SELL_DISCOUNT']*100; } //$data['list'][$key]['DISCOUNT'] = ShopGoods::GOODS_TYPE[$value['TYPE']]['discount']; } return static::notice($data); } /** * 帮会员复消购物车 * @throws \yii\web\HttpException */ public function actionReconsumeCart(){ $userId = \Yii::$app->user->id; $payList = ['cash'=>['name'=>'余额支付'],]; $userBalance = [ 'points' => 0, 'cash' => 0 ]; if ($userBonusResult = UserBonus::findOneAsArray(['USER_ID' => $userId])) { $userBalance['points'] = $userBonusResult['RECONSUME_POINTS']; } if ($userCashResult = UserWallet::findOneAsArray(['USER_ID' => $userId])) { $userBalance['cash'] = $userCashResult['CASH']; } return static::notice(['payList'=>$payList,'userBalance'=>$userBalance]); } /** * 帮会员复消确认订单 */ public function actionReconsumeSureOrder(){ if (\Yii::$app->request->isPost) { $formModel = new OrderForm(); $formModel->scenario = 'reconsumeOrder'; $formModel->remark = '帮会员复销'; $post = \Yii::$app->request->post(); $post['type'] = DeclarationForm::TYPE_FX; if ($formModel->load($post, '') && $formModel->reconsumeAdd()) { return static::notice('帮会员复消成功'); } else { return static::notice(Form::formatErrorsForApi($formModel->getErrors()),400); } } } /** * 商品列表tabs分类 * @return mixed * @throws \yii\web\HttpException */ public function actionGoodsActive() { $data = [ // [ // 'name' => 'bonus', // 'label' => '奖金商品', // ], [ 'name' => '1', 'label' => '普通商品列表', ], [ 'name' => '4', 'label' => '旅游积分商品', ], [ 'name' => '5', 'label' => '名车积分商品', ], [ 'name' => '6', 'label' => '豪宅积分商品', ], ]; return static::notice($data); } /** * 导出订单. * @return mixed * @throws \yii\web\HttpException * @throws \Mpdf\MpdfException */ public function actionOrderExport() { $uname = Info::getUserNameByUserId(\Yii::$app->user->id); $orderSn = \Yii::$app->request->get('orderSn'); $condition = " AND ORDER_TYPE='FX' AND (USER_ID=:USER_ID OR CREATE_USER='$uname') AND SN=:SN"; $params = [ ':USER_ID' => \Yii::$app->user->id, ':SN' => $orderSn, ]; $data = Order::lists($condition, $params, [ 'select' => 'O.*,U.REAL_NAME,OG.*,OG.CATEGORY_TYPE', 'orderBy' => 'O.CREATED_AT DESC', 'from' => Order::tableName() . ' AS O', 'join' => [ ['LEFT JOIN', User::tableName() . ' AS U', 'U.ID=O.USER_ID'], ['LEFT JOIN', OrderGoods::tableName() . ' AS OG', 'OG.ORDER_SN=O.SN'], ], ]); $userId = ''; $userName = ''; $address = ''; $mobile = ''; $orderAt = ''; $orderDetails = ''; $orderAmount = 0; // 合计总额 $orderNums = 0; // 合计总数 foreach ($data['list'] as $key => $value) { $provinceName = $value['PROVINCE'] ? Region::getCnName($value['PROVINCE']) : ''; $cityName = $value['CITY'] ? Region::getCnName($value['CITY']) : ''; $countyName = $value['COUNTY'] ? Region::getCnName($value['COUNTY']) : ''; $userId = $value['USER_NAME']; $userName = $value['REAL_NAME']; $address = $provinceName . $cityName . $countyName . $value['ADDRESS']; $mobile = $value['MOBILE']; $orderAt = Date::convert($value['PAY_AT'],'Y-m-d H:i:s'); // 总价 $totalAmount = $value['BUY_NUMS'] * $value['ORDER_AMOUNT']; $orderAmount += $totalAmount; $orderNums += $value['BUY_NUMS']; // 订单详情 $orderDetails .= << {$value['SKU_CODE']} {$value['GOODS_TITLE']} {$value['BUY_NUMS']} {$value['ORDER_AMOUNT']} {$totalAmount} EOT; } // 订单基本信息 $orderBase = << 会员编号 {$userId} 会员名字 {$userName} 会员地址 {$address} 会员电话 {$mobile} 订单编号 {$orderSn} 订单日期 {$orderAt} 订单明细 ORDER; $l['a_meta_charset'] = 'UTF-8'; $l['a_meta_dir'] = 'ltr'; $l['a_meta_language'] = 'zh'; $l['w_page'] = '页面'; $context = << 订单详情

订单详情

{$orderBase} {$orderDetails}
商品编号 商品名称 数量 单价 总价
合计 {$orderNums} {$orderAmount}
签名:
日期:
ORDER; require_once (\Yii::$app->vendorPath . '/tecnickcom/tcpdf/tcpdf.php'); $pdf = new \TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // 设置打印模式 $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('DaZe'); $pdf->SetTitle($orderSn); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // 是否显示页眉 $pdf->setPrintHeader(false); // 设置页眉字体 $pdf->setHeaderFont(Array('dejavusans', '', '12')); // 页眉距离顶部的距离 $pdf->SetHeaderMargin('5'); // 是否显示页脚 $pdf->setPrintFooter(false); // 设置默认等宽字体 $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); // 设置行高 $pdf->setCellHeightRatio(1); // 设置左、上、右的间距 $pdf->SetMargins('10', '10', '10'); // 设置是否自动分页 距离底部多少距离时分页 $pdf->SetAutoPageBreak(TRUE, '15'); // 设置图像比例因子 $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); if (@file_exists(\Yii::$app->vendorPath . 'tecnickcom/tcpdf/examples/lang/eng.php')) { require_once(\Yii::$app->vendorPath . '/tecnickcom/tcpdf/examples/lang/eng.php'); $pdf->setLanguageArray($l); } $pdf->setFontSubsetting(true); $pdf->AddPage(); // 设置字体 $pdf->SetFont('stsongstdlight', '', 10, '', true); $pdf->writeHTML($context); ob_clean(); $file_name = $orderSn . '.pdf'; $path = '/pdfs/' . $file_name; $pdf->Output(Yii::$app->basePath . '/web' . $path, 'F'); return static::notice(['fileUrl' => $path, 'targetName' => $file_name]); } /** * 导出订单. * @return mixed * @throws \yii\web\HttpException * @throws \Mpdf\MpdfException */ public function actionDecOrderExport() { $orderSn = \Yii::$app->request->get('orderSn'); $condition = ' AND DO.USER_ID=:USER_ID AND IS_DEL=0 AND DO.ORDER_SN=:ORDER_SN'; $params = [ ':USER_ID' => \Yii::$app->user->id, ':ORDER_SN' => $orderSn, ]; $data = DecOrder::lists($condition, $params, [ 'select' => 'DO.*,U.USER_NAME USER_NAME,U.REAL_NAME REAL_NAME,RU.USER_NAME REC_USER_NAME,RU.REAL_NAME REC_REAL_NAME,CU.USER_NAME CON_USER_NAME,CU.REAL_NAME CON_REAL_NAME,OG.*,OD.PROVINCE,OD.CITY,OD.COUNTY,OD.ADDRESS,OD.MOBILE,OD.PAY_AT,OD.ORDER_AMOUNT', 'orderBy' => 'DO.CREATED_AT DESC', 'from' => DecOrder::tableName() . ' AS DO', 'join' => [ ['LEFT JOIN', User::tableName() . ' AS U', 'DO.TO_USER_ID=U.ID'], ['LEFT JOIN', User::tableName() . ' AS RU', 'DO.REC_USER_ID=RU.ID'], ['LEFT JOIN', User::tableName() . ' AS CU', 'DO.CON_USER_ID=CU.ID'], ['LEFT JOIN', OrderGoods::tableName() . ' AS OG', 'OG.ORDER_SN=DO.ORDER_SN'], ['LEFT JOIN', Order::tableName() . ' AS OD', 'OD.SN=DO.ORDER_SN'], ], ]); $userId = ''; $userName = ''; $address = ''; $mobile = ''; $orderAt = ''; $orderDetails = ''; $orderAmount = 0; // 合计总额 $orderNums = 0; // 合计总数 foreach ($data['list'] as $key => $value) { $provinceName = $value['PROVINCE'] ? Region::getCnName($value['PROVINCE']) : ''; $cityName = $value['CITY'] ? Region::getCnName($value['CITY']) : ''; $countyName = $value['COUNTY'] ? Region::getCnName($value['COUNTY']) : ''; $userId = $value['USER_NAME']; $userName = $value['REAL_NAME']; $address = $provinceName . $cityName . $countyName . $value['ADDRESS']; $mobile = $value['MOBILE']; $orderAt = Date::convert($value['PAY_AT'],'Y-m-d H:i:s'); // 总价 $totalAmount = $value['BUY_NUMS'] * $value['REAL_PRICE']; $orderAmount += $totalAmount; $orderNums += $value['BUY_NUMS']; // 订单详情 $orderDetails .= << {$value['SKU_CODE']} {$value['GOODS_TITLE']} {$value['BUY_NUMS']} {$value['REAL_PRICE']} {$totalAmount} EOT; } // 订单基本信息 $orderBase = << 会员编号 {$userId} 会员名字 {$userName} 会员地址 {$address} 会员电话 {$mobile} 订单编号 {$orderSn} 订单日期 {$orderAt} 订单明细 ORDER; $l['a_meta_charset'] = 'UTF-8'; $l['a_meta_dir'] = 'ltr'; $l['a_meta_language'] = 'zh'; $l['w_page'] = '页面'; $context = << 订单详情

订单详情

{$orderBase} {$orderDetails}
商品编号 商品名称 数量 单价 总价
合计 {$orderNums} {$orderAmount}
签名:
日期:
ORDER; require_once (\Yii::$app->vendorPath . '/tecnickcom/tcpdf/tcpdf.php'); $pdf = new \TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // 设置打印模式 $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('DaZe'); $pdf->SetTitle($orderSn); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // 是否显示页眉 $pdf->setPrintHeader(false); // 设置页眉字体 $pdf->setHeaderFont(Array('dejavusans', '', '12')); // 页眉距离顶部的距离 $pdf->SetHeaderMargin('5'); // 是否显示页脚 $pdf->setPrintFooter(false); // 设置默认等宽字体 $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); // 设置行高 $pdf->setCellHeightRatio(1); // 设置左、上、右的间距 $pdf->SetMargins('10', '10', '10'); // 设置是否自动分页 距离底部多少距离时分页 $pdf->SetAutoPageBreak(TRUE, '15'); // 设置图像比例因子 $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); if (@file_exists(\Yii::$app->vendorPath . 'tecnickcom/tcpdf/examples/lang/eng.php')) { require_once(\Yii::$app->vendorPath . '/tecnickcom/tcpdf/examples/lang/eng.php'); $pdf->setLanguageArray($l); } $pdf->setFontSubsetting(true); $pdf->AddPage(); // 设置字体 $pdf->SetFont('stsongstdlight', '', 10, '', true); $pdf->writeHTML($context); ob_clean(); $file_name = $orderSn . '.pdf'; $path = '/pdfs/' . $file_name; $pdf->Output(Yii::$app->basePath . '/web' . $path, 'F'); return static::notice(['fileUrl' => $path, 'targetName' => $file_name]); } }