request->get(); $begin = $get['begin'] ?? 1; $hour = $get['hour'] ?? 0; if ($hour > 24 || $hour < 0) { util::fail('必须0到24点'); } if ($begin == 0) { $date = date('Y-m-d', strtotime('-1 day')); } else { $date = date('Y-m-d'); } $beginGroup = $date . " {$hour}:00:00"; $newTime = strtotime($beginGroup); $beginTime = date('Y-m-d H:i:s', $newTime); $endTime = date("Y-m-d H:i:s"); $shop = $this->shop; OrderClass::printMyWlList($shop, $beginTime, $endTime); util::complete('打印成功'); } //复核 ssh 20241001 public function actionModifyReCheck() { $get = Yii::$app->request->get(); $id = $get['id'] ?? ''; $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单'); } if ($order->reCheck == 1) { util::fail('不需要重复操作'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $order->reCheck = 1; $order->save(); $transaction->commit(); util::complete(); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("操作失败原因:" . $e->getMessage()); util::fail('操作失败'); } } //修改平账标识状态 ssh 20240405 public function actionModifyClearSign() { $get = Yii::$app->request->get(); $id = $get['id'] ?? ''; $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单'); } if (!in_array($order->status, [3, 4])) { util::fail('订单没有发货'); } if ($order->clearSign == 1) { util::fail('不需要重复操作'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $order->clearSign = 1; $order->save(); $cgId = $order->purchaseId; $cg = PurchaseClass::getById($cgId, true); if (empty($cg)) { util::fail('没有找到采购信息'); } $cg->clearSign = 1; $cg->save(); $transaction->commit(); util::complete(); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("操作失败原因:" . $e->getMessage()); util::fail('操作失败'); } } //下载图片版订单 ssh 20240321 public function actionDown() { $get = Yii::$app->request->get(); $id = $get['id'] ?? ''; $all = $get['all'] ?? 0; $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单'); } $customName = $order->customName ?? ''; $date = date("Ymd", strtotime($order->addTime)); $orderSn = $order->orderSn ?? ''; $name = $customName . '_' . $date . '_' . $orderSn; $shop = $this->shop; $staff = $this->shopAdmin; $respond = OrderClass::createImgOrder($order, $shop, $staff, $all); $imgUrl = $respond['imgFile'] ?? ''; $file = fopen($imgUrl, "rb"); Header("Content-type: application/octet-stream "); Header("Accept-Ranges: bytes "); Header("Content-Disposition: attachment;filename={$name}.png"); $contents = ""; while (!feof($file)) { $contents .= fread($file, 8192); } echo $contents; fclose($file); } //确认送达 public function actionConfirmReach() { $get = Yii::$app->request->get(); $id = $get['id'] ?? ''; $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单'); } if ($order->status == 1) { util::fail('订单待付款'); } if ($order->status == 4) { util::fail('订单已完成'); } if ($order->status == 5) { util::fail('订单已取消'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $staff = $this->shopAdmin; $staffId = $staff->id ?? 0; $staffName = $staff->name ?? ''; $params = ['staffId' => $staffId, 'staffName' => $staffName]; OrderClass::confirmReach($order, $params); $transaction->commit(); util::complete('操作成功'); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("操作失败原因:" . $e->getMessage()); util::fail('确认失败'); } } public function actionAllFh() { $post = Yii::$app->request->post(); $ids = $post['ids'] ?? ''; if (empty($ids)) { util::fail('请选择要合并发货的订单'); } $arr = explode(',', $ids); if (empty($arr)) { util::fail('请选择要合并发货的订单哦'); } $fhWl = $post['fhWl'] ?? ''; $fhWlNo = $post['fhWlNo'] ?? ''; $fhType = 0; $params = [ 'fhType' => $fhType, 'fhWl' => $fhWl, 'fhWlNo' => $fhWlNo, ]; $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $all = OrderClass::getAllByCondition(['id' => ['in', $arr]], null, '*', null, true); foreach ($all as $order) { if ($order->book == 1) { util::fail('有预订单,不能一起发货'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单哦'); } OrderClass::orderSend($order, $params, true); } $transaction->commit(); util::complete(); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("操作失败原因:" . $e->getMessage()); util::fail('操作失败'); } } //发货 ssh 20230613 public function actionFh() { $post = Yii::$app->request->post(); $id = $post['id'] ?? ''; $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); $staff = $this->shopAdmin; $staffId = $staff->id ?? 0; $staffName = $staff->name ?? ''; $fhWl = $post['fhWl'] ?? ''; $fhWlNo = $post['fhWlNo'] ?? ''; $fhType = $post['fhType'] ?? ''; $params = [ 'fhType' => $fhType, 'fhWl' => $fhWl, 'fhWlNo' => $fhWlNo, 'staffId' => $staffId, 'staffName' => $staffName, ]; if ($order->book == 1) { util::fail('预订单不支持这个发货方式'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { OrderClass::orderSend($order, $params); $transaction->commit(); util::complete(); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("操作失败原因:" . $e->getMessage()); util::fail('操作失败'); } } //合并打印 ssh 20230929 public function actionMergePrint() { $post = Yii::$app->request->post(); $ids = $post['ids'] ?? ''; if (empty($ids)) { util::fail('请选择要合并打印的订单'); } $arr = explode(',', $ids); if (empty($arr)) { util::fail('请选择要合并打印的订单哦'); } if (getenv('YII_ENV') == 'production') { if ($this->mainId != 10536 && $this->mainId != 50) { //util::fail('功能开发中'); } } else { if ($this->mainId != 11) { //util::fail('功能开发中'); } } OrderClass::mergePrintOrder($arr, $this->mainId); util::complete('打印成功'); } //修改分工 ssh 20221129 public function actionChangeWorker() { $post = Yii::$app->request->post(); $id = $post['id'] ?? 0; $shopAdminId = $post['shopAdminId'] ?? 0; $shopAdminName = $post['shopAdminName'] ?? ''; $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); $preShopAdminId = $order->shopAdminId ?? 0; if (!empty($preShopAdminId)) { $shopAdmin = $this->shopAdmin; if (isset($shopAdmin->super) == false || $shopAdmin->super != 1) { util::fail('管理员才能操作'); } } $order->shopAdminId = $shopAdminId; $order->shopAdminName = $shopAdminName; $order->save(); util::complete(); } //预订单到货 ssh 20220321 public function actionArrival() { //避免重复提交 $adminId = $this->adminId; util::checkRepeatCommit($adminId, 6); $post = Yii::$app->request->post(); $id = $post['id'] ?? 0; $todayBill = $post['todayBill'] ?? 1; $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); $post['shopAdminId'] = $this->shopAdminId; $post['shopAdminName'] = $this->shopAdmin ? $this->shopAdmin->name : ''; $shop = $this->shop; $bookSn = $shop->bookSn ?? 0; if (!empty($bookSn)) { if ($order->bookSn == $bookSn) { util::fail('预订结束了才能确认'); } } OrderService::arrival($order, $post); if ($todayBill == 0) { $lastTime = time() - 86400; $payTime = date("Y-m-d H:i:s", $lastTime); $order->payTime = $payTime; $order->save(); $purchaseId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($purchaseId, true); if (!empty($cg)) { $cg->payTime = $payTime; $cg->save(); } } $transaction->commit(); util::success($order); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("操作失败原因:" . $e->getMessage()); util::fail('操作失败'); } } //到货获取订单详情 ssh 20220323 public function actionArrivalDetail() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $info = OrderClass::getById($id); OrderClass::valid($info, $this->shopId); $showItemData = OrderClass::getOriginalShowItem(true, $info); $itemList = $showItemData['list'] ?? []; $info['product'] = $itemList; $kiloFee = $this->shop->kiloFee ?? 0; $miniKilo = $this->shop->miniKilo ?? 0; $info['kiloFee'] = $kiloFee; $info['miniKilo'] = $miniKilo; util::success($info); } //支付宝扫码支付 ssh 20210103 public function actionScanPayCheck() { $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $order = OrderClass::getById($id, true); if ($order->status != OrderClass::ORDER_STATUS_UN_PAY && $order->status != OrderClass::ORDER_STATUS_CANCEL) { util::success(['returnStatus' => 'SUCCESS']); } $deadline = $order->deadline ?? ''; $deadTime = strtotime($deadline); $current = time(); $diff = bcsub($deadTime, $current); if ($diff <= 60) { util::success(['returnStatus' => 'EXPIRE']); } util::success(['returnStatus' => 'FAILURE']); } //微信和支付宝扫码支付 ssh 20210103 public function actionScanPay() { ini_set('date.timezone', 'Asia/Shanghai'); header("Content-type: text/html; charset=utf-8"); $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $order = OrderClass::getById($id, true); if (isset($order->status) == false || $order->status != 1) { util::success(['returnStatus' => 'FAILURE'], '不是待付款订单'); } OrderClass::valid($order, $this->shopId); $cgId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($cgId, true); $orderSn = $cg->orderSn ?? ''; if (empty($orderSn)) { util::success(['returnStatus' => 'FAILURE'], '没有找到采购单'); } $deadline = $cg->deadline; $current = date("Y-m-d H:i:s"); if ((strtotime($deadline) + 20) < strtotime($current)) { util::success(['returnStatus' => 'FAILURE'], '订单已经失效'); } $totalFee = $cg->actPrice ?? 0; $subject = '购买鲜花'; $totalAmount = $totalFee; $body = "到店订单"; //标记为扫码支付 和 自取订单 $order->codePay = 2; $order->sendType = OrderClass::SEND_TYPE_NO; $order->save(); $cg->getType = PurchaseClass::GET_TYPE_SELF_GET; $cg->codePay = 2; $cg->save(); $shop = $this->shop; $currentCapitalType = dict::getDict('capitalType', 'xhPurchase', 'id'); $wxPayWay = dict::getDict('payWay', 'wxPay'); $aliPayWay = dict::getDict('payWay', 'alipay'); $payWay = Yii::$app->request->get('payWay', $wxPayWay); if ($payWay == $wxPayWay) { if (isset($order->wxPayUrl) && !empty($order->wxPayUrl)) { $url = $order->wxPayUrl; } else { util::fail('暂不支持'); $merchantExtend = WxOpenClass::getWxInfo(); $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem'; $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer'; $params = [ 'appid' => 'OP00002119', 'serial_no' => '018b08cfddbd', 'merchant_no' => $shop->lklSjNo, 'term_no' => $shop->lklScanTermNo, 'merchantPrivateKeyPath' => $merchantPrivateKeyPath, 'lklCertificatePath' => $lklCertificatePath, ]; $laResource = new Lakala($params); $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback"; $wxParams = [ 'orderSn' => $orderSn, 'amount' => $totalFee, 'capitalType' => $currentCapitalType, 'notifyUrl' => $notifyUrl, 'subject' => $subject, 'couponId' => 0, 'wxAppId' => $merchantExtend['miniAppId'], ]; $response = $laResource->driveNativeWxPay($wxParams); if (isset($response['code']) == false || $response['code'] != 'BBS00000') { $msg = $response['msg'] ?? ''; noticeUtil::push($msg, '15280215347'); util::fail('二维码生成失败'); } $url = isset($response['resp_data']['acc_resp_fields']['code']) ? $response['resp_data']['acc_resp_fields']['code'] : ''; if (empty($url)) { util::fail('二维码生成失败..'); } $order->wxPayUrl = $url; $order->save(); } $suffixUrl = qrCodeUtil::generateShortTimeGatheringQrCode($url, $this->sjId, $this->shopId, $payWay); $payUrl = Yii::$app->params['ghsImgHost'] . $suffixUrl; util::success(['url' => $payUrl, 'returnStatus' => 'SUCCESS']); } if ($payWay == $aliPayWay) { if (isset($order->aliPayUrl) && !empty($order->aliPayUrl)) { $url = $order->aliPayUrl; } else { $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem'; $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer'; $params = [ 'appid' => 'OP00002119', 'serial_no' => '018b08cfddbd', 'merchant_no' => $shop->lklSjNo, 'term_no' => $shop->lklScanTermNo, 'merchantPrivateKeyPath' => $merchantPrivateKeyPath, 'lklCertificatePath' => $lklCertificatePath, ]; $laResource = new Lakala($params); $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback"; $aliParams = [ 'orderSn' => $orderSn, 'amount' => $totalFee, 'capitalType' => $currentCapitalType, 'notifyUrl' => $notifyUrl, 'subject' => $subject, ]; $response = $laResource->driveAliPay($aliParams); if (isset($response['code']) == false || $response['code'] != 'BBS00000') { util::fail('二维码生成失败'); } $url = isset($response['resp_data']['acc_resp_fields']['code']) ? $response['resp_data']['acc_resp_fields']['code'] : ''; if (empty($url)) { util::fail('二维码生成失败..'); } $order->aliPayUrl = $url; $order->save(); } $suffixUrl = qrCodeUtil::generateShortTimeGatheringQrCode($url, $this->sjId, $this->shopId, $payWay); $payUrl = Yii::$app->params['ghsImgHost'] . $suffixUrl; util::success(['url' => $payUrl, 'returnStatus' => 'SUCCESS']); } util::success(['returnStatus' => 'FAILURE'], '不支持的收款方式'); } //微信和支付宝付款码支付复查 ssh 20211231 public function actionCodePayCheck() { ini_set('date.timezone', 'Asia/Shanghai'); header("Content-type: text/html; charset=utf-8"); $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $order = OrderClass::getById($id, true); if (empty($order)) { util::success(['returnStatus' => 'SUCCESS']); } if ($order->status == OrderClass::ORDER_STATUS_COMPLETE) { util::complete('订单已付款'); } if ($order->status == OrderClass::ORDER_STATUS_CANCEL) { util::complete('订单已取消'); } if ($order->status != OrderClass::ORDER_STATUS_UN_PAY) { util::complete('订单不是待付款状态'); } OrderClass::valid($order, $this->shopId); $cgId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($cgId, true); $orderSn = $cg->orderSn ?? ''; $totalFee = $cg->actPrice ?? 0; if (empty($orderSn)) { util::complete('没有找到采购单'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $capitalType = dict::getDict('capitalType', 'xhPurchase', 'id'); $shop = $this->shop; $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem'; $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer'; $params = [ 'appid' => 'OP00002119', 'serial_no' => '018b08cfddbd', 'merchant_no' => $shop->lklSjNo, 'term_no' => $shop->lklScanTermNo, 'merchantPrivateKeyPath' => $merchantPrivateKeyPath, 'lklCertificatePath' => $lklCertificatePath, ]; $laResource = new Lakala($params); $scanParams = ['orderSn' => $orderSn,]; $response = $laResource->query($scanParams); if (isset($response['code']) && $response['code'] == 'BBS00000') { if (isset($response['resp_data']['trade_state']) && $response['resp_data']['trade_state'] == 'SUCCESS') { //支付成功 $transactionId = $response['resp_data']['trade_no'] ?? ''; $openId = ''; $aliUserId = ''; $cg->onlinePay = dict::getDict('onlinePay', 'yes'); $cg->codePay = 1; $cg->payOpenId = $openId; $cg->aliUserId = $aliUserId; //自取订单 $cg->getType = PurchaseClass::GET_TYPE_SELF_GET; $cg->save(); $order->onlinePay = dict::getDict('onlinePay', 'yes'); $order->codePay = 1; //自取订单 $order->sendType = OrderClass::SEND_TYPE_NO; $order->save(); $payWayType = dict::getDict('payWay', 'wxPay'); $account_type = $response['resp_data']['account_type'] ?? ''; if ($account_type == 'WECHAT') { $payWayType = dict::getDict('payWay', 'wxPay'); } if ($account_type == 'ALIPAY') { $payWayType = dict::getDict('payWay', 'alipay'); } $order->payWay = $payWayType; $order->save(); $cg->payWay = $payWayType; $cg->save(); $attach = ''; payUtil::thirdPay($payWayType, $capitalType, $orderSn, $totalFee, $attach, $transactionId); $transaction->commit(); $saleId = $order->id ?? 0; $order = OrderClass::getById($saleId, true); if (!empty($order)) { //解决扫码付重复打印问题 $cacheKey = 'scan_pay_print_order_' . $orderSn; $has = Yii::$app->redis->executeCommand('GET', [$cacheKey]); if (!empty($has)) { return false; } Yii::$app->redis->executeCommand('SETEX', [$cacheKey, 1, 'has']); //订单生成时唤起在线打印 if (isset($order->needPrint) && $order->needPrint == dict::getDict('needPrint', 'need')) { if ($order->status != 1 && $order->status != 5) { OrderClass::onlinePrint($order); $ext = $this->shopExt; if (isset($ext->printSn) && !empty($ext->printSn)) { $order->printNum += 1; $order->save(); } } } ShopExtClass::ghsGatheringReport($order); } util::success(['returnStatus' => 'SUCCESS']); } else { util::complete('未知状态..'); } } else { util::complete('未知状态....'); } } catch (\Exception $e) { $transaction->rollBack(); noticeUtil::push('查询订单状态失败:' . $e->getMessage(), '15280215347'); util::fail('支付失败'); } } //微信和支付宝付款码支付 ssh 2021.4.11 public function actionCodePay() { ini_set('date.timezone', 'Asia/Shanghai'); header("Content-type: text/html; charset=utf-8"); $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $order = OrderClass::getById($id, true); if (empty($order)) { $msg = '没有找到订单'; util::success(['returnStatus' => 'FAILURE'], $msg); } if ($order->status == 5) { $msg = '订单已取消'; util::success(['returnStatus' => 'FAILURE'], $msg); } if ($order->status != 1) { $msg = '不是待付款订单'; util::success(['returnStatus' => 'FAILURE'], $msg); } OrderClass::valid($order, $this->shopId); $cgId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($cgId, true); $orderSn = $cg->orderSn ?? ''; if (empty($orderSn)) { $msg = '没有找到采购单'; util::success(['returnStatus' => 'FAILURE'], $msg); } $codePayErrorKey = 'code_pay_error_' . $id; $hasFailPay = Yii::$app->redis->executeCommand('GET', [$codePayErrorKey]); //前面有付失败过,要重新生成单号 if (!empty($hasFailPay)) { $oldOrderSn = $orderSn; $orderSn = orderSn::getPurchaseSn(); $cg->orderSn = $orderSn; $cg->save(); //noticeUtil::push("重新扫码,成功更换单号 {$oldOrderSn} {$orderSn}", '15280215347'); PurchaseItemClass::updateByCondition(['orderSn' => $oldOrderSn], ['orderSn' => $orderSn]); } $shop = $this->shop; $sj = $shop->merchantName; $shopName = $shop->shopName; $name = $shopName == '首店' ? $sj : $sj . '-' . $shopName; //付款码 $authCode = (string)$get['authCode'] ?? ''; $authCode = trim($authCode); if (empty($authCode)) { $msg = '没有扫到付款码'; $remind = $msg . "(付款码:{$authCode})" . '(' . $name . ')'; noticeUtil::push($remind . ' 编号001', '15280215347'); util::success(['returnStatus' => 'FAILURE'], $msg); } //微信文档说明 https://pay.weixin.qq.com/doc/v2/merchant/4011936234 $wxPattern = '/^(10|11|12|13|14|15)\d{16}$/'; //支付宝文档说明 https://opendocs.alipay.com/open/194/106039/ $aliPattern = '/^(25|26|27|28|29|30)\d{14,22}$/'; if (!preg_match($wxPattern, $authCode) && !preg_match($aliPattern, $authCode)) { $msg = '付款码错误,请使用微信或支付宝付款码'; $remind = $msg . "(付款码:{$authCode})" . '(' . $name . ')'; //noticeUtil::push($remind . ' 编号002', '15280215347'); util::success(['returnStatus' => 'FAILURE'], $msg); } $deadline = $cg->deadline; $current = date("Y-m-d H:i:s"); if ((strtotime($deadline) + 20) < strtotime($current)) { $msg = '订单已经失效'; util::success(['returnStatus' => 'FAILURE'], $msg); } $totalFee = $cg->actPrice ?? 0; $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $subject = '购买花材 ' . $orderSn; $capitalType = dict::getDict('capitalType', 'xhPurchase', 'id'); $merchantPrivateKeyPath = Yii::getAlias("@vendor/lakala") . '/production/api_private_key.pem'; $lklCertificatePath = Yii::getAlias("@vendor/lakala") . '/production/lkl-apigw-v1.cer'; $params = [ 'appid' => 'OP00002119', 'serial_no' => '018b08cfddbd', 'merchant_no' => $shop->lklSjNo, 'term_no' => $shop->lklScanTermNo, 'merchantPrivateKeyPath' => $merchantPrivateKeyPath, 'lklCertificatePath' => $lklCertificatePath, ]; $laResource = new Lakala($params); $notifyUrl = Yii::$app->params['hdHost'] . "/notice/pay-callback"; $scanParams = [ 'orderSn' => $orderSn, 'amount' => $totalFee, 'capitalType' => $capitalType, 'notifyUrl' => $notifyUrl, 'subject' => $subject, 'authCode' => $authCode, ]; $response = $laResource->scanPay($scanParams); if (isset($response['code']) && $response['code'] == 'BBS00000') { $account_type = $response['resp_data']['account_type'] ?? ''; $payWayType = dict::getDict('payWay', 'wxPay'); if ($account_type == 'WECHAT') { $payWayType = dict::getDict('payWay', 'wxPay'); } if ($account_type == 'ALIPAY') { $payWayType = dict::getDict('payWay', 'alipay'); } $order->payWay = $payWayType; $order->save(); $cg->payWay = $payWayType; $cg->save(); $transactionId = $response['resp_data']['trade_no'] ?? ''; $openId = ''; $aliUserId = ''; $cg->onlinePay = dict::getDict('onlinePay', 'yes'); $cg->codePay = 1; $cg->payOpenId = $openId; $cg->aliUserId = $aliUserId; $cg->save(); $order->onlinePay = dict::getDict('onlinePay', 'yes'); $order->codePay = 1; $order->save(); $attach = ''; payUtil::thirdPay($payWayType, $capitalType, $orderSn, $totalFee, $attach, $transactionId); $transaction->commit(); $saleId = $order->id ?? 0; $order = OrderClass::getById($saleId, true); if (!empty($order)) { //解决扫码付重复打印问题 $cacheKey = 'scan_pay_print_order_' . $orderSn; $has = Yii::$app->redis->executeCommand('GET', [$cacheKey]); if (!empty($has)) { return false; } Yii::$app->redis->executeCommand('SETEX', [$cacheKey, 1, 'has']); //订单生成时唤起在线打印 if (isset($order->needPrint) && $order->needPrint == dict::getDict('needPrint', 'need')) { if ($order->status != 1 && $order->status != 5) { OrderClass::onlinePrint($order); $ext = $this->shopExt; if (isset($ext->printSn) && !empty($ext->printSn)) { $order->printNum += 1; $order->save(); } } } ShopExtClass::ghsGatheringReport($order); } util::success(['returnStatus' => 'SUCCESS']); } else { //标记有没付成功的次数,原因有可能是余额不足等 Yii::$app->redis->executeCommand('SETEX', [$codePayErrorKey, 1200, 'hasFail']); $msg = $response['msg'] ?? ''; $retCode = $response['code'] ?? ''; if ($retCode == 'BBS10000' || $retCode == 'BBS11105') { $shopId = $order->shopId; ShopExtClass::remindInputPassword($shopId); } $fullMsg = $msg . "(付款码:{$authCode})" . '(' . $name . ')'; //noticeUtil::push($fullMsg . ' ' . $retCode . ' 编号007', '15280215347'); util::success(['returnStatus' => 'FAILURE', 'returnCode' => $retCode], $msg); } } catch (\Exception $e) { $transaction->rollBack(); Yii::error("支付失败原因:" . $e->getMessage()); util::fail('支付失败'); } } //订单列表 ssh 2021.1.20 public function actionList() { $get = Yii::$app->request->get(); $export = $get['export'] ?? 0; $onlySend = $get['onlySend'] ?? 0; ini_set('memory_limit', '5045M'); set_time_limit(0); $staff = $this->shopAdmin; if (isset($staff->identity) && $staff->identity == 2) { //如果用于确认发货时要显出订单 if ($onlySend == 0) { util::success(['list' => []]); } } $where['mainId'] = $this->mainId; $status = $get['status'] ?? 0; if (!empty($status)) { $where['status'] = $status; } $clearSign = $get['clearSign'] ?? -1; if ($clearSign > -1) { $where['clearSign'] = $clearSign; } $book = $get['book'] ?? -1; if ($book > -1) { $where['book'] = $book; } $searchTime = $get['searchTime'] ?? ''; if (!empty($searchTime)) { $startTime = $get['startTime'] ?? ''; $endTime = $get['endTime'] ?? ''; $period = dateUtil::formatTime($searchTime, $startTime, $endTime); $where['payTime'] = ['between', [$period['startTime'], $period['endTime']]]; } if ($export == 1) { ini_set('memory_limit', '2045M'); set_time_limit(0); if (isset($where['payTime']) == false) { util::fail('请选时间段'); } $start = $where['payTime'][1][0]; $end = $where['payTime'][1][1]; $monthTime = bcmul(31, 86400); $startArea = strtotime($start); $endArea = strtotime($end); $diff = bcsub($endArea, $startArea); if ($diff > $monthTime) { util::fail('最长可导出一个月'); } } $name = $get['name'] ?? ''; if (!empty($name)) { $searchType = $get['searchType'] ?? 0; if (empty($searchType)) { //订单编号 if (strpos($name, 'XSD') === 0) { $where['orderSn'] = $name; } elseif (preg_match("/^[a-zA-Z\s]+$/", $name)) { $where['customNamePy'] = ['like', $name]; } else { $where['customName'] = ['like', $name]; } } elseif ($searchType == 1) { $where['sendNum'] = $name; } else { } } if (isset($get['customId']) && !empty($get['customId'])) { $where['customId'] = $get['customId']; } if (isset($get['ids']) && !empty($get['ids'])) { $stringIds = $get['ids']; $newIds = explode(',', $stringIds); $where['id'] = ['in', $newIds]; } //选择开单人 $shopAdminId = $get['shopAdminId'] ?? 0; if (!empty($shopAdminId)) { $where['shopAdminId'] = $shopAdminId; } $respond = OrderClass::getOrderList($where); if ($export == 1) { OrderClass::exportOrderData($respond, $this->mainId); } $respond['shop'] = $this->shop; $respond['shopExt'] = $this->shopExt; util::success($respond); } // 新订单列表详情 -- 可能与 actionList 很相似,但为不影响 actionList,重新创建个方法 shizhongqi 2022.06.23 public function actionNewOrderList() { $get = Yii::$app->request->get(); $where['shopId'] = $this->shopId; /*$status = $get['status'] ?? 0; if (!empty($status)) { $where['status'] = $status; }*/ // 按类别生成查询条件:1.今日实收 2.今日欠款 3.总欠款(所有历史欠款) if (isset($get['type'])) { $type = $get['type']; if ($type == 1) { // 今日实收 $get['searchTime'] = 'today'; $where['debt'] = 0; $where['debtPrice'] = '0.00'; $where['status'] = ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]]; } elseif ($type == 2) { // 今日欠款 $get['searchTime'] = 'today'; $where['debt'] = 1; } elseif ($type == 3) { // 总欠款 $where['debt'] = 1; } else { util::fail('查询的订单类别不存在'); } } $searchTime = $get['searchTime'] ?? ''; if (!empty($searchTime)) { $startTime = ''; $endTime = ''; $period = dateUtil::formatTime($searchTime, $startTime, $endTime); $where['addTime'] = ['between', [$period['startTime'], $period['endTime']]]; } $name = $get['name'] ?? ''; if (!empty($name)) { $searchType = $get['searchType'] ?? 0; if (empty($searchType)) { //订单编号 if (strpos($name, 'XSD') === 0) { $where['orderSn'] = $name; } elseif (preg_match("/^[a-zA-Z\s]+$/", $name)) { $where['customNamePy'] = ['like', $name]; } else { $where['customName'] = ['like', $name]; } } elseif ($searchType == 1) { $where['sendNum'] = $name; } else { util::fail('搜索的订单类别不存在'); } } $respond = OrderClass::getOrderList($where); $respond['shop'] = $this->shop; $respond['shopExt'] = $this->shopExt; $respond['type'] = $type; //把查询类别返回 util::success($respond); } //商城下单操作 ssh 2021.1.14 public function actionCreateOrder() { $post = Yii::$app->request->post(); $shopId = $this->shopId; $customId = $post['customId'] ?? 0; $post['customId'] = $customId; //开单必须选客户 if (empty($customId)) { util::fail('请选择客户'); } $modifyPrice = $post['modifyPrice'] ?? 0; $pattern = '/^\d+(\.\d{1,2})?$/'; if ($modifyPrice > 0) { if (preg_match($pattern, $modifyPrice) == false) { //容错前端 util::fail('金额不能超2位小数'); } } $custom = CustomClass::getCustom($customId); if (empty($custom)) { util::fail('请选客户哦'); } $shopAdmin = $this->shopAdmin; $shopAdminId = $this->shopAdminId; $shopAdminName = $shopAdmin->name ?? ''; //n秒内不允许重复提交,有多个地方要同步修改,关键词ghs_custom_create_order_redis $createOrderCacheKey = 'ghs_custom_create_order_' . $customId . '_' . $shopAdminId; $has = Yii::$app->redis->executeCommand('GET', [$createOrderCacheKey]); if (!empty($has)) { util::fail('已提交过,5秒后再试'); } Yii::$app->redis->executeCommand('SETEX', [$createOrderCacheKey, 5, 'has']); CustomClass::valid($custom, $this->shopId); if (!empty($custom['mainId']) && $custom['mainId'] == $custom['ownMainId']) { util::fail('不能给自己开单'); } $post['ghsId'] = $custom['ghsId'] ?? 0; $post['customMobile'] = $custom['mobile'] ?? ''; $customName = $custom['name'] ?? ''; $post['customName'] = $customName; $post['customNamePy'] = $custom['py'] ?? ''; $post['customAvatar'] = $custom['shortSmallAvatar'] ?? ''; $post['province'] = $custom['province'] ?? ''; $post['city'] = $custom['city'] ?? ''; $post['dist'] = $custom['dist'] ?? ''; $post['address'] = $custom['address'] ?? ''; $post['floor'] = $custom['floor'] ?? ''; $post['fullAddress'] = $custom['fullAddress'] ?? ''; $post['showAddress'] = $custom['showAddress'] ?? ''; $post['long'] = $custom['long'] ?? ''; $post['lat'] = $custom['lat'] ?? ''; if (!empty($post['getStaffId'])) { if (getenv('YII_ENV') == 'production') { $tbMainId = 44171; } else { $tbMainId = 0; } if ($this->mainId == $tbMainId) { //平潭花天下,就算选了收款人,也不要给改变开单人,临时解决方案 ssh 2250314 if (!empty($post['shopAdminId'])) { $getStaffName = $post['shopAdminName'] ?? ''; $shopAdminId = $post['shopAdminId']; $shopAdminName = $getStaffName; } } else { $getStaffName = $post['getStaffName'] ?? ''; $shopAdminId = $post['getStaffId']; $shopAdminName = $getStaffName; } } else { if (getenv('YII_ENV') == 'production') { //鹏诚需要选择开单人 if (in_array($this->mainId, [19606])) { util::fail('请选择开单人'); } } else { if (in_array($this->mainId, [])) { util::fail('请选择开单人'); } } } if (getenv('YII_ENV') == 'production') { //小向花卉开单售后控制 if ($this->mainId == 23390) { if (!in_array($this->adminId, [24043, 24585, 24586, 24654, 24115, 23960, 28456, 31105, 28456, 31105, 52528, 25011, 61449])) { util::fail('你不能开单哦'); } } } //开单人和收款人必定是同个人 $post['shopAdminId'] = $shopAdminId; $post['shopAdminName'] = $shopAdminName; $post['getStaffId'] = $shopAdminId; $post['getStaffName'] = $shopAdminName; $post['sjId'] = $this->sjId; $post['shopId'] = $shopId; $post['mainId'] = $this->mainId; $post['fromType'] = 1; $post['expressId'] = $post['expressId'] ?? 0; $book = $post['book'] ?? 0; $post['book'] = $book; $sendType = $post['sendType'] ?? 0; $transType = $post['transType'] ?? 0; $shop = $this->shop; //到期超过5天不支持开单 $deadline = $shop->deadline; $deadTime = strtotime($deadline); $myCurrentTime = time() + 432000; if ($myCurrentTime > $deadTime) { util::fail('系统已到期,请续费'); } if (isset($shop->pfLevel) && $shop->pfLevel == 1) { //昆明发往全国 $sendCost = isset($post['sendCost']) && $post['sendCost'] > 0 ? $post['sendCost'] : 0; $post['sendCost'] = $sendCost; $packCost = isset($post['packCost']) && $post['packCost'] > 0 ? $post['packCost'] : 0; $post['packCost'] = $packCost; $post['transType'] = $transType; $post['localOrder'] = 1; } else { //同步配送 $sendCost = isset($post['sendCost']) && $post['sendCost'] > 0 ? $post['sendCost'] : 0; if ($sendType != dict::getDict('sendType', 'thirdSend') && $sendCost > 0) { util::fail('填了运费,请选择代叫跑腿'); } $post['sendCost'] = $sendCost; $post['packCost'] = isset($post['packCost']) && $post['packCost'] > 0 ? $post['packCost'] : 0; } if ($book == 1) { $bookSn = $shop->bookSn ?? 0; if (empty($bookSn)) { util::fail('请开启预订'); } $post['bookSn'] = $bookSn; } $hasPay = $post['hasPay'] ?? dict::getDict('hasPay', 'unPay'); $post['debt'] = OrderClass::DEBT_NO; if ($hasPay == dict::getDict('hasPay', 'debt')) { $post['debt'] = OrderClass::DEBT_YES; } if (isset($shopAdmin->super) == false || $shopAdmin->super != 1) { if ($hasPay == dict::getDict('hasPay', 'payed')) { //util::fail('没有权限'); } } if (getenv('YII_ENV') == 'production') { if ($this->mainId == 1082) { //泉城鲜花批发的出车,只能开收现金方式,多处要修改,关键词qc_cash if ($hasPay != 0) { util::fail('只能使用扫码付款,编号193'); } } } else { if ($this->mainId == 644) { if ($hasPay != 0) { //util::fail('只能使用扫码付款,编号190'); } } } //多颜色数据整理 $colorItem = $post['xj'] ?? []; $newXj = []; if (!empty($colorItem)) { $colorData = json_decode($colorItem, true); if (!empty($colorData) && is_array($colorData)) { foreach ($colorData as $colorInfo) { $ptItemId = $colorInfo['ptItemId'] ?? 0; $colorList = $colorInfo['list'] ?? []; if (!empty($colorList)) { foreach ($colorList as $colorItemKey => $colorItem) { $newXj[$ptItemId][] = $colorItem; } } } } } $post['xj'] = $newXj; $productJson = $post['product'] ?? ''; if (empty($productJson)) { util::fail('请选择花材'); } $productList = json_decode($productJson, true); if (empty($productList)) { util::fail('请选择花材'); } $dealPrice = $post['dealPrice'] ?? 0; $ids = array_unique(array_filter(array_column($productList, 'productId'))); $itemInfo = ProductClass::getByIds($ids, null, 'id'); if (empty($itemInfo)) { util::fail('请选择花材哦'); } //判断花材有效性 foreach ($itemInfo as $itemData) { if (isset($itemData['mainId']) == false || $itemData['mainId'] != $this->mainId) { util::fail('只能选择同一家的商品哈'); } } //解决开单提交订单时,别人修改价格,造成提交价格不是真实卖价问题!! if ($dealPrice == 0) { $diff = []; $priceMap = CustomClass::$levelPriceKeyMap; $addPriceMap = CustomClass::$levelAddPriceKeyMap; $level = $custom['level'] ?? 1; foreach ($productList as $currentKey => $currentProduct) { $currentPrice = $currentProduct['price'] ?? 0; $currentId = $currentProduct['productId'] ?? 0; $systemInfo = $itemInfo[$currentId] ?? []; $name = $systemInfo['name'] ?? ''; $systemPrice = ProductClass::getFinalPrice($systemInfo, $level, $priceMap, $addPriceMap); if (floatval($currentPrice) != floatval($systemPrice)) { $diff[] = [ 'name' => $name, 'price' => $systemPrice, 'kdPrice' => $currentPrice, ]; } } if (!empty($diff)) { //n秒内不允许重复提交,有多个地方要同步修改,关键词ghs_custom_create_order_redis Yii::$app->redis->executeCommand('DEL', [$createOrderCacheKey]); util::success(['diff' => $diff, 'respondType' => 'priceError']); } } if ($book == 1) { $post['hasPay'] = 2; $post['payWay'] = 0; } $historyDate = $post['historyDate'] ?? ''; if (!empty($historyDate)) { if ($book == 1) { util::fail('预订单不能选订单日期'); } if ($hasPay == 0) { util::fail('扫码付不能选订单日期'); } if (strtotime($historyDate) > strtotime(date("Y-m-d"))) { util::fail('订单日期只能选历史时间'); } } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $post['product'] = $productList; //商家开单到时间会自动标记为欠款,所以360天内不过期,以保证足够时间标记欠款,具体参数查看dict local_gys_kd_auto_set_debt_time $time = time(); $hasTime = dict::getDict('order_pay_has_time'); $totalTime = bcadd($time, $hasTime); $post['deadline'] = date("Y-m-d H:i:s", $totalTime); //多处有用到此方法,需要同步修改,搜索关键词create_new_order $return = OrderService::createNewOrder($post, $custom, $hasPay); $transaction->commit(); $saleId = $return->id ?? 0; $order = OrderClass::getById($saleId, true); if (!empty($order)) { $shopId = $order->shopId ?? 0; $customId = $order->customId ?? 0; $ghsId = $order->ghsId ?? 0; $custom = CustomClass::getById($customId, true); $date = date("Y-m-d H:i:s"); if (!empty($custom)) { $custom->recentExpend = $date; $custom->save(); } $ghs = GhsClass::getById($ghsId, true); if (!empty($ghs)) { $ghs->recentExpend = $date; $ghs->save(); } $shop = ShopClass::getById($shopId, true); if (isset($order->payStatus) && $order->payStatus == 1) { if (!empty($shop)) { //通知员工 $noticeText = json_encode(['orderId' => $saleId]); $noticeKey = "hdCgNoticeGhs"; Yii::$app->redis->executeCommand('LPUSH', [$noticeKey, $noticeText]); //通知花店 // $noticeText = json_encode(['id' => $order->purchaseId]); // $noticeKey = "ghsKdNoticeHd"; // Yii::$app->redis->executeCommand('LPUSH', [$noticeKey, $noticeText]); } } //订单生成时唤起在线打印 if (isset($order->needPrint) && $order->needPrint == dict::getDict('needPrint', 'need')) { //预订单开单不打小票,小向花卉不需要打小票 $mainId = $order->mainId ?? 0; if ($order->book == 0 && !in_array($mainId, [23390])) { if ($order->status != 1 && $order->status != 5) { OrderClass::onlinePrint($order); $ext = $this->shopExt; if (isset($ext->printSn) && !empty($ext->printSn)) { $order->printNum += 1; $order->save(); } //xxx自己开单要打二次,有多处要修改搜索关键词 tow_print if (in_array($mainId, [0])) { OrderClass::onlinePrint($order); $ext = $this->shopExt; if (isset($ext->printSn) && !empty($ext->printSn)) { $order->printNum += 1; $order->save(); } } } } } //前台提醒出示付款码 if (isset($order->status) && $order->status == 1) { if (isset($post['isCashier']) && $post['isCashier'] == 1) { ShopExtClass::ghsPleasePayReport($order); } } } util::success($return); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("下单失败原因:" . $e->getMessage()); noticeUtil::push("批发线下开单失败,原因:" . $e->getMessage(), '15280215347'); util::fail('下单失败'); } } //修改订单 ssh 20210810 public function actionUpdateOrder() { $post = Yii::$app->request->post(); util::fail('订单不可修改'); //PC端开单 if (isset($post['clearType'])) { $clearType = $post['clearType']; if ($clearType == OrderClass::CLEAR_DEBT) { $post['debt'] = OrderClass::DEBT_YES; $post['payWay'] = dict::getDict('payWay', 'debtPay'); } else { $post['debt'] = OrderClass::DEBT_NO; } } //员工不能开已收款订单 $debt = $post['debt'] ?? OrderClass::DEBT_YES; if ($debt == OrderClass::DEBT_NO) { $shopAdmin = $this->shopAdmin; if (isset($shopAdmin->super) == false || $shopAdmin->super != 1) { util::fail('不能开已收款订单'); } } //PC端开单 if (isset($post['getType'])) { util::fail('暂不支持PC端修改订单'); $getType = $post['getType']; //自取 if ($getType == 1) { $post['sendType'] = OrderClass::SEND_TYPE_NO; } else { //选择配送时,在发货时让商家自己再确认一下用什么方式 $post['sendType'] = OrderClass::SEND_TYPE_UNKNOWN; } } //商家开非自取订单,默认订单是待收款的,debt字段为非欠款 if (isset($post['sendType']) && $post['sendType'] != OrderClass::SEND_TYPE_NO) { $post['debt'] = OrderClass::DEBT_NO; } $id = $post['id'] ?? 0; $order = OrderClass::getLockById($id); if (empty($order)) { util::fail('没有找到订单'); } OrderClass::valid($order, $this->shopId); unset($post['id']); $shopAdmin = $this->shopAdmin; $post['shopAdminId'] = $this->shopAdminId; $post['shopAdminName'] = $shopAdmin->name ?? ''; $post['fromType'] = 1; $post['sendCost'] = $post['sendCost'] ?? '0.00'; $productJson = $post['product'] ?? ''; if (empty($productJson)) { util::fail('请选择花材'); } $productList = json_decode($productJson, true); if (empty($productList)) { util::fail('请选择花材'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { //判断花材有效性 ProductClass::valid($productList, $this->mainId); $post['product'] = $productList; //商家开单订单有效期,到期记欠款 $validTime = dict::getDict('order_pay_has_time'); $current = time() + $validTime; $post['deadline'] = date("Y-m-d H:i:s", $current); $upData = [ 'payWay' => $post['payWay'], 'sendType' => $post['sendType'], 'debt' => $post['debt'], 'needPrint' => $post['needPrint'], 'modifyPrice' => $post['modifyPrice'], 'shopAdminId' => $post['shopAdminId'], 'shopAdminName' => $post['shopAdminName'], 'fromType' => 1, 'sendCost' => $post['sendCost'], 'product' => $post['product'], 'deadline' => $post['deadline'], 'debt' => $post['debt'], ]; $return = OrderService::updateOrder($order, $upData); $transaction->commit(); util::success($return); } catch (\Exception $e) { $transaction->rollBack(); Yii::error("下单失败原因:" . $e->getMessage()); util::fail('下单失败'); } } //取消预订单 ssh 20240503 public function actionCancelBookOrder() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; if (empty($id)) { util::fail('请选择订单'); } $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } OrderClass::valid($order, $this->shopId); if ($order->book == 0) { util::fail('不是预订单'); } if ($order->status != 2) { util::fail('当前订单状态不能取消'); } $purchaseId = $order->purchaseId ?? 0; $purchase = PurchaseClass::getById($purchaseId, true); if (empty($purchase)) { util::fail('没有找到采购单'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $order->status = 5; $order->save(); $purchase->status = 5; $purchase->save(); $transaction->commit(); util::complete('取消成功'); } catch (\Exception $e) { $transaction->rollBack(); $msg = $e->getMessage(); $orderSn = $order->orderSn ?? ''; noticeUtil::push("预订单{$orderSn}取消失败:{$msg}", '15280215347'); } } //取消订单 shizhongqi 20220619 public function actionCancelOrder() { $post = Yii::$app->request->post(); $id = $post['orderId'] ?? 0; if (empty($id)) { util::fail('请选择订单'); } $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('请选择订单...'); } OrderClass::valid($order, $this->shopId); if (isset($order->status) == false || $order->status != 1) { util::fail('不是待付款状态,无法取消'); } $purchaseId = $order->purchaseId ?? 0; $purchase = PurchaseClass::getById($purchaseId); if (empty($purchase)) { util::fail('没有找到采购单'); } $deadLineTime = strtotime($purchase['deadline']); $diff = $deadLineTime - time(); if ($diff <= 60) { util::fail('1分钟后订单将自动取消'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); $orderSn = $purchase['orderSn']; try { $current = PurchaseClass::getById($purchaseId, true); PurchaseService::expire($current); $transaction->commit(); //noticeUtil::push("采购单过期未付款,库存已回滚,单号:{$orderSn}"); } catch (\Exception $e) { $transaction->rollBack(); $msg = $e->getMessage(); noticeUtil::push("采购单过期处理报错了!订单号:{$orderSn},错误信息:{$msg}", '15280215347'); } util::complete(); } //延期支付 ssh 2021.1.19 public function actionDebt() { $id = Yii::$app->request->get('id'); //4秒内不允许重复提交 $cacheKey = 'ghs_set_order_debt_' . $id; $has = Yii::$app->redis->executeCommand('GET', [$cacheKey]); if (!empty($has)) { util::fail('请稍等'); } Yii::$app->redis->executeCommand('SETEX', [$cacheKey, 4, 'has']); if (getenv('YII_ENV') == 'production') { if ($this->mainId == 1082) { //泉城鲜花批发的出车,只能开收现金方式,多处要修改,关键词qc_cash util::fail('只能使用扫码付款,编号293'); } } else { } $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); $payWay = dict::getDict('payWay', 'debtPay'); $cgId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($cgId, true); if (empty($cg)) { util::fail('没有找到采购单'); } if ($order->book == 1) { util::fail('预订单不能记欠款'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { PurchaseService::payAfter($cg, $payWay); OrderService::payAfter($order, $payWay); $transaction->commit(); } catch (\Exception $exception) { $transaction->rollBack(); Yii::info("延期支付报错:" . $exception->getMessage()); util::fail('操作失败'); } $order = OrderClass::getById($id, true); if (!empty($order)) { $shopId = $order->shopId ?? 0; $shop = ShopClass::getById($shopId, true); if (!empty($shop)) { //花店采购供货商端微信收到通知 //WxMessageClass::ghsHasNewOrderInform($shop, $order); $noticeText = json_encode(['orderId' => $id]); $noticeKey = "hdCgNoticeGhs"; Yii::$app->redis->executeCommand('LPUSH', [$noticeKey, $noticeText]); } //订单生成时唤起在线打印 if (isset($order->needPrint) && $order->needPrint == dict::getDict('needPrint', 'need')) { if ($order->status != 1 && $order->status != 5) { OrderClass::onlinePrint($order); $ext = $this->shopExt; if (isset($ext->printSn) && !empty($ext->printSn)) { $order->printNum += 1; $order->save(); } } } if ($order->status != 1 && $order->status != 5) { //花店采购供货商端APP收到通知 //NoticeClass::ghsNewOrderNotice($order); } } util::complete(); } //获取商城下单要用的微信支付和小程序支付参数 ssh 2019.21.3 public function actionWxPay() { ini_set('date.timezone', 'Asia/Shanghai'); $post = Yii::$app->request->post(); $couponId = $post['couponId'] ?? 0; $orderSn = isset($post['orderSn']) ? $post['orderSn'] : 0; $order = OrderClass::getByOrderSn($orderSn); if (empty($order)) { util::fail('订单号无效'); } $id = $order['id']; //支付前验证订单有效性 if (isset($order['adminId']) == false || $order['adminId'] != $this->adminId) { util::fail('无法操作'); } $name = $order['orderName'] ?? '购买商品'; $totalFee = $order['actPrice']; //强制使用小程序的miniOpenId $openId = isset($this->admin) && !empty($this->admin) ? $this->admin->miniOpenId : ''; if (empty($openId)) { util::fail('没有找到openId'); } $capitalType = dict::getDict('capitalType', 'xhGhsOrder', 'id'); //流水类型、优惠卷、微信支付(h5还是小程序支付)类型 带到回调 $wxPayType = 0; if (httpUtil::isMiniProgram()) { $wxPayType = 1; } $attach = "couponId=" . $couponId . "&capitalType=" . $capitalType . '&wxPayType=' . $wxPayType; //订单30分钟后过期 $now = time(); $expireTime = $now + 1800; $wx = Yii::getAlias("@vendor/weixin"); require_once($wx . '/lib/WxPay.Api.php'); require_once($wx . '/example/WxPay.JsApiPay.php'); $input = new \WxPayUnifiedOrder(); $input->SetBody($name); $input->SetOut_trade_no($orderSn); $input->SetTotal_fee($totalFee * 100); $input->SetTime_start(date("YmdHis", $now)); $input->SetAttach($attach);//将流水类型、代金劵等传给微信再回传 $input->SetTime_expire(date("YmdHis", $expireTime)); $input->SetNotify_url(Yii::$app->params['ghsHost'] . '/notice/wx-callback/'); $input->SetTrade_type("JSAPI"); //花卉宝代为申请的微信支付 //$sjExtend = $this->sjExtend->attributes; $sjExtend = WxOpenClass::getGhsWxInfo(); if (isset($sjExtend['wxPayApply']) && $sjExtend['wxPayApply'] == 1) { $input->SetSub_openid($openId); } else { $input->SetOpenid($openId); } //强制使用小程序的miniAppId $sjExtend['wxAppId'] = $sjExtend['miniAppId']; $wxOrder = \WxPayApi::unifiedOrder($input, 6, $sjExtend); $tools = new \JsApiPay(); $jsApiParameters = $tools->GetJsApiParameters($wxOrder, $sjExtend); $newParams = json_decode($jsApiParameters, true); //微信不能修改价格 $current = date("Y-m-d H:i:s"); $updateData = ['deadline' => $current, 'modPrice' => 0]; OrderClass::updateById($id, $updateData); util::success($newParams); } //获取订单详情 ssh 2021.1.21 public function actionDetail() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $info = OrderService::getOrderInfo($id, true, true, true, false); OrderClass::valid($info, $this->shopId); //A4打印需要用到的数据 $customId = $info['customId'] ?? 0; $remark = $info['remark'] ?? ''; $sendCost = $info['sendCost'] ?? 0; $sendNum = $info['sendNum'] ?? ''; $packCost = $info['packCost'] ?? 0; $staffName = $info['shopAdminName'] ?? ''; $ysName = ''; if (isset($info['localOrder']) && $info['localOrder'] == 1) { if ($info['transType'] == 0) { $ysName = '德邦空运'; } if ($info['transType'] == 1) { $ysName = '顺丰空运'; } if ($info['transType'] == 2) { $ysName = '冷链物流'; } if ($info['transType'] == 3) { $ysName = '航空物流'; } if ($info['transType'] == 4) { $ysName = '同城配送'; } if ($info['transType'] == 5) { $ysName = '到店自取'; } } else { $sendType = $info['sendType'] ?? 0; $ysName = '送货上门'; if ($sendType == 1) { $ysName = '到店自取'; } if ($sendType == 2) { $ysName = '发跑腿'; } if ($sendType == 3) { $wlName = $info['wlName'] ?? ''; $ysName = '发物流'; if (!empty($wlName)) { $ysName = $ysName . '-' . $wlName; } } } $fullAddress = ''; if (getenv('YII_ENV') == 'production') { //老油的要显示地址 if ($this->mainId == 20528) { $fullAddress = $info['fullAddress'] ?? ''; } } else { if ($this->mainId == 644) { $fullAddress = $info['fullAddress'] ?? ''; } } $custom = CustomClass::getById($customId, true); if (empty($custom)) { util::fail('没有找到客户'); } $customName = $custom->name ?? ''; $customMobile = $custom->customMobile ?? ''; if (empty($customMobile)) { $customShopId = $custom->shopId ?? 0; $customShop = ShopClass::getById($customShopId, true); if (!empty($customShop)) { $customMobile = $customShop->mobile ?? ''; } } if (!empty($customMobile)) { $customMobile = substr_replace($customMobile, '****', 3, 4); } $fullCustom = $customName . ' ' . $customMobile; if ($this->mainId == 8164) { //花大苪不显示客户名称 $fullCustom = ''; } $seatSn = isset($custom->seatSn) && !empty($custom->seatSn) ? $custom->seatSn : '无'; $sendTimeWant = $info['sendTimeWant'] ?? ''; $shortSendTimeWant = !empty($sendTimeWant) ? substr($sendTimeWant, 5, 5) : ''; $totalItemNum = 0; $totalSmallItemNum = 0; $table = []; if (isset($info['product']) && !empty($info['product'])) { foreach ($info['product'] as $key => $val) { $currentName = $val['name'] ?? ''; $num = $val['xhNum'] ?? 0; $refundNum = $val['refundNum'] ?? 0; $num = bcsub($num, $refundNum); $totalItemNum = bcadd($totalItemNum, $num); $ratio = $val['ratio'] ?? 0; $currentSmallNum = bcmul($num, $ratio); $totalSmallItemNum = bcadd($totalSmallItemNum, $currentSmallNum); $itemRemark = $val['remark'] ?? ''; $unitPrice = $val['xhUnitPrice'] ?? 0; $unitPrice = floatval($unitPrice); $price = bcmul($unitPrice, $num, 2); $price = floatval($price); $table[] = [ 'name' => $currentName, 'num' => $num, 'confirmNum' => '', 'remark' => $itemRemark, 'wxNumber' => 'shish3508', 'unitPrice' => $unitPrice, 'price' => $price, ]; } } $shop = $this->shop; $sjName = $shop->merchantName ?? ''; $shopName = $shop->shopName ?? ''; $sjShopName = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName; $a4Print = [ 'customName' => $fullCustom, 'staffName' => $staffName, 'seatSn' => $seatSn, 'shortSendTimeWant' => $shortSendTimeWant, 'table' => $table, 'remark' => $remark, 'fullAddress' => $fullAddress, 'sendNum' => $sendNum, 'sendCost' => $sendCost, 'ysName' => $ysName, 'packCost' => $packCost, 'totalItemNum' => $totalItemNum, 'totalSmallItemNum' => $totalSmallItemNum, 'shopName' => $sjShopName . ' 销售单', ]; $info['printData'] = $a4Print; //常规模板 //有用的历史备份 $template = '{"panels":[{"index":0,"name":1,"height":297,"width":210,"paperHeader":49.5,"paperFooter":780,"printElements":[{"options":{"left":30,"top":53,"height":52,"width":538,"field":"table","coordinateSync":false,"widthHeightSync":false,"tableBorder":"border","tableHeaderBorder":"border","tableHeaderCellBorder":"border","tableHeaderFontWeight":"bold","right":567.25,"bottom":110.24609375,"vCenter":298.25,"hCenter":82.24609375,"textAlign":"center","columns":[[{"width":134.33608169277167,"title":"名称","field":"name","checked":true,"columnId":"name","fixed":false,"rowspan":1,"colspan":1,"align":"center","halign":"center","vAlign":"middle","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":74.77209598393634,"title":"预订数","field":"num","checked":true,"columnId":"num","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":73.30462681205907,"title":"确认数","field":"confirmNum","checked":true,"columnId":"confirmNum","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":71.10877448138285,"title":"单价","field":"unitPrice","checked":true,"columnId":"unitPrice","fixed":false,"rowspan":1,"colspan":1},{"width":84.32601880877743,"title":"金额","field":"price","checked":true,"columnId":"price","fixed":false,"rowspan":1,"colspan":1},{"width":100.15240222107263,"title":"备注","field":"remark","checked":true,"columnId":"remark","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""}]]},"printElementType":{"title":"空白表格","type":"table","editable":true,"columnDisplayEditable":true,"columnDisplayIndexEditable":true,"columnTitleEditable":true,"columnResizable":true,"columnAlignEditable":true,"isEnableEditField":true,"isEnableContextMenu":true,"isEnableInsertRow":true,"isEnableDeleteRow":true,"isEnableInsertColumn":true,"isEnableDeleteColumn":true,"isEnableMergeCell":true}},{"options":{"left":12,"top":786,"height":49,"width":49},"printElementType":{"title":"html","type":"html"}},{"options":{"left":382.5,"top":785,"height":13,"width":136,"title":"销花宝提供技术支持","textAlign":"center","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":518.74609375,"bottom":801.49609375,"vCenter":450.74609375,"hCenter":794.99609375},"printElementType":{"title":"自定义文本","type":"text"}},{"options":{"left":332.5,"top":35,"height":19,"width":233,"title":"货号","field":"seatSn","testData":"60","coordinateSync":false,"widthHeightSync":false,"fontSize":12,"fontWeight":"bold","textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":567.9921875,"bottom":51.2421875,"vCenter":451.4921875,"hCenter":29.2421875},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":32.5,"height":19,"width":128,"title":"12-16","right":147.75,"bottom":49.49609375,"vCenter":87.75,"hCenter":28.99609375,"field":"shortSendTimeWant","testData":"12-16","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":12,"fontWeight":"bold","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":32.5,"height":19,"width":411,"title":"文本","right":469,"bottom":52.49609375,"vCenter":282.5,"hCenter":34.99609375,"field":"customName","testData":"纯彩 15280215347","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":11,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":150,"height":45,"width":535,"title":"备注","right":565.75,"bottom":195,"vCenter":298.25,"hCenter":172.5,"field":"remark","testData":"箱子上要写上姓名和电话,到货时要拆箱,检查里面的花材","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"fontWeight":"bold","lineHeight":30,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":107.5,"height":25,"width":536,"title":"地址","field":"fullAddress","testData":"福建省厦门市集美区前山路147号中华人民共和国福建省厦门市集美区前山路147号中华人民共和国","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":561.2421875,"bottom":616.75,"vCenter":293.2421875,"hCenter":581.75,"lineHeight":32.25,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":135,"height":15,"width":52,"title":"编号","field":"sendNum","testData":"39","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":241.99609375,"bottom":182.49609375,"vCenter":215.99609375,"hCenter":174.99609375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":90,"top":135,"height":15,"width":79,"title":"德邦物流","right":173.9921875,"bottom":150,"vCenter":134.4921875,"hCenter":142.5,"field":"ysName","testData":"德邦物流","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"qrCodeLevel":0,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":174,"top":135,"height":15,"width":120,"title":"开单人","field":"staffName","testData":"石头","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":298.9921875,"bottom":154.74609375,"vCenter":238.9921875,"hCenter":149.87109375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":297.5,"top":135,"height":15,"width":120,"title":"打包人","field":"packName","testData":"小林","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":417.4921875,"bottom":147.24609375,"vCenter":357.4921875,"hCenter":142.37109375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":7.5,"height":25,"width":411,"title":"文本","right":509.74609375,"bottom":35.99609375,"vCenter":309.74609375,"hCenter":24.49609375,"field":"shopName","testData":"小向花卉 销售单","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":16,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}}],"paperNumberLeft":552.5,"paperNumberTop":785,"paperNumberContinue":true,"fontFamily":"Microsoft YaHei","watermarkOptions":{"content":"","rotate":25,"timestamp":false,"format":"YYYY-MM-DD HH:mm","fillStyle":"rgba(184, 184, 184, 0.3)","fontSize":"14px","width":200,"height":200},"panelLayoutOptions":{"layoutType":"column","layoutRowGap":0,"layoutColumnGap":0}}]}'; //$template = '{"panels":[{"index":0,"name":1,"height":297,"width":210,"paperHeader":49.5,"paperFooter":780,"printElements":[{"options":{"left":30,"top":53,"height":52,"width":538,"field":"table","coordinateSync":false,"widthHeightSync":false,"tableBorder":"border","tableHeaderBorder":"border","tableHeaderCellBorder":"border","tableHeaderFontWeight":"bold","right":567.25,"bottom":110.24609375,"vCenter":298.25,"hCenter":82.24609375,"textAlign":"center","columns":[[{"width":134.33608169277167,"title":"名称","field":"name","checked":true,"columnId":"name","fixed":false,"rowspan":1,"colspan":1,"align":"center","halign":"center","vAlign":"middle","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":74.77209598393634,"title":"预订数","field":"num","checked":true,"columnId":"num","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":73.30462681205907,"title":"确认数","field":"confirmNum","checked":true,"columnId":"confirmNum","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":71.10877448138285,"title":"单价","field":"unitPrice","checked":true,"columnId":"unitPrice","fixed":false,"rowspan":1,"colspan":1},{"width":84.32601880877743,"title":"金额","field":"price","checked":true,"columnId":"price","fixed":false,"rowspan":1,"colspan":1},{"width":100.15240222107263,"title":"备注","field":"remark","checked":true,"columnId":"remark","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""}]]},"printElementType":{"title":"空白表格","type":"table","editable":true,"columnDisplayEditable":true,"columnDisplayIndexEditable":true,"columnTitleEditable":true,"columnResizable":true,"columnAlignEditable":true,"isEnableEditField":true,"isEnableContextMenu":true,"isEnableInsertRow":true,"isEnableDeleteRow":true,"isEnableInsertColumn":true,"isEnableDeleteColumn":true,"isEnableMergeCell":true}},{"options":{"left":12,"top":786,"height":49,"width":49},"printElementType":{"title":"html","type":"html"}},{"options":{"left":382.5,"top":785,"height":13,"width":136,"title":"销花宝提供技术支持","textAlign":"center","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":518.74609375,"bottom":801.49609375,"vCenter":450.74609375,"hCenter":794.99609375},"printElementType":{"title":"自定义文本","type":"text"}},{"options":{"left":332.5,"top":35,"height":19,"width":233,"title":"货号","field":"seatSn","testData":"60","coordinateSync":false,"widthHeightSync":false,"fontSize":12,"fontWeight":"bold","textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":567.9921875,"bottom":51.2421875,"vCenter":451.4921875,"hCenter":29.2421875},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":32.5,"height":19,"width":128,"title":"12-16","right":147.75,"bottom":49.49609375,"vCenter":87.75,"hCenter":28.99609375,"field":"shortSendTimeWant","testData":"12-16","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":12,"fontWeight":"bold","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":32.5,"height":19,"width":411,"title":"文本","right":469,"bottom":52.49609375,"vCenter":282.5,"hCenter":34.99609375,"field":"customName","testData":"纯彩 15280215347","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":11,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":145,"height":45,"width":535,"title":"备注","right":559.24609375,"bottom":207.99609375,"vCenter":291.74609375,"hCenter":185.49609375,"field":"remark","testData":"箱子上要写上姓名和电话,到货时要拆箱,检查里面的花材","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"fontWeight":"bold","lineHeight":30,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":107.5,"height":30,"width":536,"title":"地址","field":"fullAddress","testData":"福建省厦门市集美区前山路147号中华人民共和国福建省厦门市集美区前山路147号中华人民共和国","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":561.2421875,"bottom":616.75,"vCenter":293.2421875,"hCenter":581.75,"lineHeight":32.25},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":135,"height":15,"width":52,"title":"编号","field":"sendNum","testData":"39","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":241.99609375,"bottom":182.49609375,"vCenter":215.99609375,"hCenter":174.99609375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":95,"top":135,"height":15,"width":79,"title":"德邦物流","right":174.25,"bottom":159.24609375,"vCenter":134.75,"hCenter":151.74609375,"field":"ysName","testData":"德邦物流","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":177.5,"top":137.5,"height":9.75,"width":120,"title":"开单人","field":"staffName","testData":"石头","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":298.9921875,"bottom":154.74609375,"vCenter":238.9921875,"hCenter":149.87109375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":297.5,"top":137.5,"height":9.75,"width":120,"title":"打包人","field":"packName","testData":"小林","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":417.4921875,"bottom":147.24609375,"vCenter":357.4921875,"hCenter":142.37109375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":7.5,"height":25,"width":411,"title":"文本","right":509.74609375,"bottom":35.99609375,"vCenter":309.74609375,"hCenter":24.49609375,"field":"shopName","testData":"小向花卉 销售单","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":16,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}}],"paperNumberLeft":552.5,"paperNumberTop":785,"paperNumberContinue":true,"fontFamily":"Microsoft YaHei","watermarkOptions":{"content":"","rotate":25,"timestamp":false,"format":"YYYY-MM-DD HH:mm","fillStyle":"rgba(184, 184, 184, 0.3)","fontSize":"14px","width":200,"height":200},"panelLayoutOptions":{"layoutType":"column","layoutRowGap":0,"layoutColumnGap":0}}]}'; if (getenv('YII_ENV') == 'production') { //花大苪模板 if (in_array($this->mainId, [8164])) { $template = '{"panels":[{"index":0,"name":1,"height":297,"width":210,"paperHeader":49.5,"paperFooter":780,"printElements":[{"options":{"left":30,"top":53,"height":52,"width":538,"field":"table","coordinateSync":false,"widthHeightSync":false,"fontSize":16,"lineHeight":30,"tableBorder":"border","tableHeaderBorder":"border","tableHeaderCellBorder":"border","tableHeaderFontWeight":"bold","right":567.25,"bottom":110.24609375,"vCenter":298.25,"hCenter":82.24609375,"textAlign":"center","columns":[[{"width":188.91632245461145,"title":"名称","field":"name","checked":true,"columnId":"name","fixed":false,"rowspan":1,"colspan":1,"align":"center","halign":"center","vAlign":"middle","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":105.15171514242958,"title":"预订数","field":"num","checked":true,"columnId":"num","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":103.08801880877742,"title":"确认数","field":"confirmNum","checked":true,"columnId":"confirmNum","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":140.84394359418155,"title":"备注","field":"remark","checked":true,"columnId":"remark","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":93.32065807548679,"title":"日期","field":"shortTime","checked":false,"columnId":"shortTime","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":74.09275968851016,"title":"库存","field":"stock","checked":false,"columnId":"stock","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":276,"title":"金额\n","field":"amount","checked":false,"columnId":"amount","fixed":false,"rowspan":1,"colspan":1,"tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":100,"title":"","field":"","checked":false,"columnId":"","fixed":false,"rowspan":1,"colspan":1},{"width":100,"title":"","field":"","checked":false,"columnId":"","fixed":false,"rowspan":1,"colspan":1}]]},"printElementType":{"title":"空白表格","type":"table","editable":true,"columnDisplayEditable":true,"columnDisplayIndexEditable":true,"columnTitleEditable":true,"columnResizable":true,"columnAlignEditable":true,"isEnableEditField":true,"isEnableContextMenu":true,"isEnableInsertRow":true,"isEnableDeleteRow":true,"isEnableInsertColumn":true,"isEnableDeleteColumn":true,"isEnableMergeCell":true}},{"options":{"left":12,"top":786,"height":49,"width":49},"printElementType":{"title":"html","type":"html"}},{"options":{"left":392.5,"top":785,"height":13,"width":199,"title":"销花宝提供技术支持","textAlign":"center","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":590.74609375,"bottom":801.25,"vCenter":491.24609375,"hCenter":794.75},"printElementType":{"title":"自定义文本","type":"text"}},{"options":{"left":335,"top":12.5,"height":44,"width":233,"title":"货号","field":"seatSn","testData":"60","coordinateSync":false,"widthHeightSync":false,"fontSize":20,"fontWeight":"bold","textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":567.9921875,"bottom":51.2421875,"vCenter":451.4921875,"hCenter":29.2421875},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":12.5,"height":46,"width":128,"title":"12-16","right":147.75,"bottom":49.49609375,"vCenter":87.75,"hCenter":28.99609375,"field":"shortSendTimeWant","testData":"12-16","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":20,"fontWeight":"bold","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":95,"top":17.5,"height":35,"width":373,"title":"文本","right":469,"bottom":52.49609375,"vCenter":282.5,"hCenter":34.99609375,"field":"customName","testData":"纯彩 15280215347","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":14,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":32.5,"top":377.5,"height":200,"width":535,"title":"备注","right":571.4921875,"bottom":550.25,"vCenter":303.9921875,"hCenter":450.25,"field":"remark","testData":"箱子上要写上姓名和电话,到货时要拆箱,检查里面的花材","coordinateSync":false,"widthHeightSync":false,"fontSize":20,"fontWeight":"bold","lineHeight":30,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":32.5,"top":302.5,"height":70,"width":536,"title":"地址","field":"fullAddress","testData":"福建省厦门市集美区前山路147号中华人民共和国福建省厦门市集美区前山路147号中华人民共和国","coordinateSync":false,"widthHeightSync":false,"fontSize":18,"fontWeight":"bold","qrCodeLevel":0,"right":561.2421875,"bottom":616.75,"vCenter":293.2421875,"hCenter":581.75,"lineHeight":32.25},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":200,"height":50,"width":400,"title":"编号","field":"sendNum","testData":"39","coordinateSync":false,"widthHeightSync":false,"fontSize":20,"lineHeight":36,"qrCodeLevel":0,"right":430,"bottom":284.99609375,"vCenter":230,"hCenter":259.99609375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":32.5,"top":257.5,"height":39,"width":240,"title":"运费","field":"sendCost","testData":"0","coordinateSync":false,"widthHeightSync":false,"fontSize":20,"lineHeight":28.5,"qrCodeLevel":0,"right":526.7421875,"bottom":415.74609375,"vCenter":276.7421875,"hCenter":400.74609375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":295,"top":202.5,"height":43,"width":270,"title":"德邦物流","right":565.74609375,"bottom":280.99609375,"vCenter":430.74609375,"hCenter":259.49609375,"field":"ysName","testData":"德邦物流","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":20,"lineHeight":36,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":297.5,"top":260,"height":41,"width":260,"title":"打包费","field":"packCost","testData":"30","coordinateSync":false,"widthHeightSync":false,"fontSize":20,"lineHeight":24,"qrCodeLevel":0,"right":555.74609375,"bottom":332.99609375,"vCenter":425.74609375,"hCenter":312.49609375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":160,"height":36,"width":189,"title":"花材数量","field":"totalItemNum","testData":"20","coordinateSync":false,"widthHeightSync":false,"fontFamily":"cursive","fontSize":24,"fontWeight":"bold","lineHeight":32.25,"qrCodeLevel":0,"right":219,"bottom":158.49609375,"vCenter":124.5,"hCenter":140.49609375},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":295,"top":160,"height":36,"width":189,"title":"支数","field":"totalSmallItemNum","testData":"600","coordinateSync":false,"widthHeightSync":false,"fontFamily":"cursive","fontSize":24,"fontWeight":"bold","lineHeight":32.25,"qrCodeLevel":0,"right":482.25,"bottom":195.24609375,"vCenter":387.75,"hCenter":177.24609375},"printElementType":{"title":"文本","type":"text"}}],"paperNumberLeft":565.5,"paperNumberTop":819,"paperNumberContinue":true,"watermarkOptions":{"content":"vue-plugin-hiprint","rotate":25,"timestamp":true,"format":"YYYY-MM-DD HH:mm"},"panelLayoutOptions":{}}]}'; } if (in_array($this->mainId, [44282])) { //$template = '{"panels":[{"index":0,"name":1,"height":297,"width":210,"paperHeader":73.5,"paperFooter":780,"printElements":[{"options":{"left":30,"top":77,"height":52,"width":538,"field":"table","coordinateSync":false,"widthHeightSync":false,"tableBorder":"border","tableHeaderBorder":"border","tableHeaderCellBorder":"border","tableHeaderFontWeight":"bold","right":567.25,"bottom":110.24609375,"vCenter":298.25,"hCenter":82.24609375,"textAlign":"center","columns":[[{"width":134.33608169277167,"title":"名称","field":"name","checked":true,"columnId":"name","fixed":false,"rowspan":1,"colspan":1,"align":"center","halign":"center","vAlign":"middle","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":74.77209598393634,"title":"预订数","field":"num","checked":true,"columnId":"num","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":73.30462681205907,"title":"确认数","field":"confirmNum","checked":true,"columnId":"confirmNum","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":71.10877448138285,"title":"单价","field":"unitPrice","checked":true,"columnId":"unitPrice","fixed":false,"rowspan":1,"colspan":1},{"width":84.32601880877743,"title":"金额","field":"price","checked":true,"columnId":"price","fixed":false,"rowspan":1,"colspan":1},{"width":100.15240222107263,"title":"备注","field":"remark","checked":true,"columnId":"remark","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""}]]},"printElementType":{"title":"空白表格","type":"table","editable":true,"columnDisplayEditable":true,"columnDisplayIndexEditable":true,"columnTitleEditable":true,"columnResizable":true,"columnAlignEditable":true,"isEnableEditField":true,"isEnableContextMenu":true,"isEnableInsertRow":true,"isEnableDeleteRow":true,"isEnableInsertColumn":true,"isEnableDeleteColumn":true,"isEnableMergeCell":true}},{"options":{"left":12,"top":786,"height":49,"width":49},"printElementType":{"title":"html","type":"html"}},{"options":{"left":382.5,"top":785,"height":13,"width":136,"title":"销花宝提供技术支持","textAlign":"center","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":518.74609375,"bottom":801.49609375,"vCenter":450.74609375,"hCenter":794.99609375},"printElementType":{"title":"自定义文本","type":"text"}},{"options":{"left":332.5,"top":53,"height":19,"width":233,"title":"货号","field":"seatSn","testData":"60","coordinateSync":false,"widthHeightSync":false,"fontSize":12,"fontWeight":"bold","textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":567.9921875,"bottom":51.2421875,"vCenter":451.4921875,"hCenter":29.2421875},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":50.5,"height":19,"width":128,"title":"12-16","right":147.75,"bottom":49.49609375,"vCenter":87.75,"hCenter":28.99609375,"field":"shortSendTimeWant","testData":"12-16","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":12,"fontWeight":"bold","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":50.5,"height":19,"width":411,"title":"文本","right":469,"bottom":52.49609375,"vCenter":282.5,"hCenter":34.99609375,"field":"customName","testData":"纯彩 15280215347","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":11,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":181.5,"height":45,"width":535,"title":"备注","right":565.75,"bottom":195,"vCenter":298.25,"hCenter":172.5,"field":"remark","testData":"箱子上要写上姓名和电话,到货时要拆箱,检查里面的花材","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"fontWeight":"bold","lineHeight":30,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":137.5,"height":25,"width":536,"title":"地址","field":"fullAddress","testData":"福建省厦门市集美区前山路147号中华人民共和国福建省厦门市集美区前山路147号中华人民共和国","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":561.2421875,"bottom":616.75,"vCenter":293.2421875,"hCenter":581.75,"lineHeight":32.25,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":165,"height":15,"width":52,"title":"编号","field":"sendNum","testData":"39","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":241.99609375,"bottom":182.49609375,"vCenter":215.99609375,"hCenter":174.99609375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":90,"top":165,"height":15,"width":79,"title":"德邦物流","right":173.9921875,"bottom":150,"vCenter":134.4921875,"hCenter":142.5,"field":"ysName","testData":"德邦物流","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"qrCodeLevel":0,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":174,"top":165,"height":15,"width":120,"title":"开单人","field":"staffName","testData":"石头","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":298.9921875,"bottom":154.74609375,"vCenter":238.9921875,"hCenter":149.87109375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":297.5,"top":165,"height":15,"width":120,"title":"打包人","field":"packName","testData":"小林","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":417.4921875,"bottom":147.24609375,"vCenter":357.4921875,"hCenter":142.37109375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":25.5,"height":25,"width":411,"title":"文本","right":509.74609375,"bottom":35.99609375,"vCenter":309.74609375,"hCenter":24.49609375,"field":"shopName","testData":"小向花卉 销售单","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":16,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}}],"paperNumberLeft":552.5,"paperNumberTop":785,"paperNumberContinue":true,"fontFamily":"Microsoft YaHei","watermarkOptions":{"content":"","rotate":25,"timestamp":false,"format":"YYYY-MM-DD HH:mm","fillStyle":"rgba(184, 184, 184, 0.3)","fontSize":"14px","width":200,"height":200},"panelLayoutOptions":{"layoutType":"column","layoutRowGap":0,"layoutColumnGap":0}}]}'; $template = '{"panels":[{"index":0,"name":1,"height":297,"width":210,"paperHeader":73.5,"paperFooter":780,"printElements":[{"options":{"left":30,"top":77,"height":52,"width":538,"field":"table","coordinateSync":false,"widthHeightSync":false,"tableBorder":"border","tableHeaderBorder":"border","tableHeaderCellBorder":"border","tableHeaderFontWeight":"bold","right":567.25,"bottom":110.24609375,"vCenter":298.25,"hCenter":82.24609375,"textAlign":"center","fontSize":11.25,"columns":[[{"width":134.33608169277167,"title":"名称","field":"name","checked":true,"columnId":"name","fixed":false,"rowspan":1,"colspan":1,"align":"center","halign":"center","vAlign":"middle","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":74.77209598393634,"title":"预订数","field":"num","checked":true,"columnId":"num","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":73.30462681205907,"title":"确认数","field":"confirmNum","checked":true,"columnId":"confirmNum","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""},{"width":71.10877448138285,"title":"单价","field":"unitPrice","checked":true,"columnId":"unitPrice","fixed":false,"rowspan":1,"colspan":1},{"width":84.32601880877743,"title":"金额","field":"price","checked":true,"columnId":"price","fixed":false,"rowspan":1,"colspan":1},{"width":100.15240222107263,"title":"备注","field":"remark","checked":true,"columnId":"remark","fixed":false,"rowspan":1,"colspan":1,"align":"center","tableQRCodeLevel":0,"tableSummaryTitle":true,"tableSummary":""}]]},"printElementType":{"title":"空白表格","type":"table","editable":true,"columnDisplayEditable":true,"columnDisplayIndexEditable":true,"columnTitleEditable":true,"columnResizable":true,"columnAlignEditable":true,"isEnableEditField":true,"isEnableContextMenu":true,"isEnableInsertRow":true,"isEnableDeleteRow":true,"isEnableInsertColumn":true,"isEnableDeleteColumn":true,"isEnableMergeCell":true}},{"options":{"left":12,"top":786,"height":49,"width":49},"printElementType":{"title":"html","type":"html"}},{"options":{"left":382.5,"top":785,"height":13,"width":136,"title":"销花宝提供技术支持","textAlign":"center","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":518.74609375,"bottom":801.49609375,"vCenter":450.74609375,"hCenter":794.99609375},"printElementType":{"title":"自定义文本","type":"text"}},{"options":{"left":332.5,"top":53,"height":19,"width":233,"title":"货号","field":"seatSn","testData":"60","coordinateSync":false,"widthHeightSync":false,"fontSize":12,"fontWeight":"bold","textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":567.9921875,"bottom":51.2421875,"vCenter":451.4921875,"hCenter":29.2421875},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":50.5,"height":19,"width":128,"title":"12-16","right":147.75,"bottom":49.49609375,"vCenter":87.75,"hCenter":28.99609375,"field":"shortSendTimeWant","testData":"12-16","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":12,"fontWeight":"bold","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":93,"top":51,"height":19,"width":411,"title":"文本","right":503.49609375,"bottom":69.49609375,"vCenter":297.99609375,"hCenter":59.99609375,"field":"customName","testData":"纯彩 15280215347","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":11,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":181.5,"height":45,"width":535,"title":"备注","right":565.75,"bottom":195,"vCenter":298.25,"hCenter":172.5,"field":"remark","testData":"箱子上要写上姓名和电话,到货时要拆箱,检查里面的花材","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"fontWeight":"bold","lineHeight":30,"qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":137.5,"height":25,"width":536,"title":"地址","field":"fullAddress","testData":"福建省厦门市集美区前山路147号中华人民共和国福建省厦门市集美区前山路147号中华人民共和国","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":561.2421875,"bottom":616.75,"vCenter":293.2421875,"hCenter":581.75,"lineHeight":32.25,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":165,"height":15,"width":52,"title":"编号","field":"sendNum","testData":"39","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":241.99609375,"bottom":182.49609375,"vCenter":215.99609375,"hCenter":174.99609375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":90,"top":165,"height":15,"width":79,"title":"德邦物流","right":173.9921875,"bottom":150,"vCenter":134.4921875,"hCenter":142.5,"field":"ysName","testData":"德邦物流","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"qrCodeLevel":0,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":174,"top":165,"height":15,"width":120,"title":"开单人","field":"staffName","testData":"石头","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":298.9921875,"bottom":154.74609375,"vCenter":238.9921875,"hCenter":149.87109375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":297.5,"top":165,"height":15,"width":120,"title":"打包人","field":"packName","testData":"小林","coordinateSync":false,"widthHeightSync":false,"qrCodeLevel":0,"right":417.4921875,"bottom":147.24609375,"vCenter":357.4921875,"hCenter":142.37109375,"textContentVerticalAlign":"middle"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":92.5,"top":25.5,"height":25,"width":411,"title":"文本","right":509.74609375,"bottom":35.99609375,"vCenter":309.74609375,"hCenter":24.49609375,"field":"shopName","testData":"小向花卉 销售单","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":16,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0},"printElementType":{"title":"文本","type":"text"}}],"paperNumberLeft":552.5,"paperNumberTop":785,"paperNumberContinue":true,"fontFamily":"Microsoft YaHei","watermarkOptions":{"content":"","rotate":25,"timestamp":false,"format":"YYYY-MM-DD HH:mm","fillStyle":"rgba(184, 184, 184, 0.3)","fontSize":"14px","width":200,"height":200},"panelLayoutOptions":{"layoutType":"column","layoutRowGap":0,"layoutColumnGap":0}}]}'; } } $info['template'] = $template; $printType = $get['printType'] ?? 0; if ($printType == 1) { //打多联的模板 $table = []; if (isset($info['product']) && !empty($info['product'])) { foreach ($info['product'] as $key => $val) { $currentName = $val['name'] ?? ''; $num = $val['xhNum'] ?? 0; $refundNum = $val['refundNum'] ?? 0; $num = bcsub($num, $refundNum); $totalItemNum = bcadd($totalItemNum, $num); $ratio = $val['ratio'] ?? 0; $currentSmallNum = bcmul($num, $ratio); $totalSmallItemNum = bcadd($totalSmallItemNum, $currentSmallNum); $itemRemark = $val['remark'] ?? ''; $unitPrice = $val['xhUnitPrice'] ?? 0; $unitPrice = floatval($unitPrice); $price = bcmul($unitPrice, $num, 2); $price = floatval($price); $table[] = [ 'name' => $currentName, 'num' => $num, 'orderNum' => '', 'remark' => $itemRemark, 'wxNumber' => 'shish3508', 'unitPrice' => '¥' . $unitPrice, 'price' => '¥' . $price, 'refundNum' => $refundNum == 0 ? '' : 0, ]; } } $orderSn = $info['orderSn'] ?? ''; $kind = $info['productStat'] && $info['productStat']['kind'] ?? 0; $totalItemNum = $info['productStat'] && $info['productStat']['bigNum'] ?? 0; $addTime = $info['addTime'] ?? ''; $actPrice = $info['actPrice'] ?? 0; $tkPrice = $info['tkPrice'] ?? 0; $prePrice = $info['prePrice'] ?? 0; $customMobile = $info['customMobile'] ?? ''; $address = ''; if (isset($info['address']) && !empty($info['address'])) { $address .= $info['fullAddress']; if (isset($info['showAddress']) && !empty($info['showAddress']) && $info['showAddress'] != $info['fullAddress']) { $address .= '(' . $info['showAddress'] . ')
'; } } $printData = [ 'table' => $table, 'addTime' => '', 'entryTime' => $addTime, 'ghsName' => $customName, 'clearCode' => '', 'staffName' => '', 'telephone' => $customMobile, 'kind' => $kind, 'orderSn' => $orderSn, 'sjShopName' => $sjShopName . ' 销售单', 'prePrice' => '¥' . $prePrice, 'tkPrice' => '¥' . $tkPrice, 'realPrice' => '¥' . $actPrice, 'totalItemNum' => $totalItemNum, 'numKind' => "共" . $kind . "种,数量:" . $totalItemNum, 'address' => $address, ]; $info['printData'] = $printData; $template = '{"panels":[{"index":0,"name":1,"height":140,"width":210,"paperHeader":49.5,"paperFooter":383.4343434343434,"printElements":[{"options":{"left":115,"top":20,"height":25,"width":374,"title":"文本","right":488.99609375,"bottom":44.9921875,"vCenter":301.99609375,"hCenter":32.4921875,"field":"sjShopName","testData":"小向花卉 采购单","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":14,"fontWeight":"bold","textAlign":"center","textContentVerticalAlign":"middle","qrCodeLevel":0,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":27.5,"top":22.5,"height":21,"width":145,"title":"单号","field":"orderSn","testData":"PC563961","coordinateSync":false,"widthHeightSync":false,"fontSize":12,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":148.9921875,"bottom":43.9921875,"vCenter":85.9921875,"hCenter":33.4921875,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":445,"top":25,"height":22,"width":122,"title":"核销码","field":"clearCode","testData":"3961","coordinateSync":false,"widthHeightSync":false,"fontSize":12,"textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":571.25,"bottom":46.75,"vCenter":510.25,"hCenter":35.75,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":22.5,"top":55,"height":36,"width":550,"field":"table","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textAlign":"center","tableHeaderFontWeight":"bold","right":572.5,"bottom":90.99609375,"vCenter":297.5,"hCenter":72.99609375,"fontFamily":"SimSun","columns":[[{"width":54.223705213537556,"title":"序号","field":"orderNum","checked":true,"columnId":"orderNum","fixed":false,"rowspan":1,"colspan":1},{"width":175.72632876030514,"title":"花材名称","field":"name","checked":true,"columnId":"name","fixed":false,"rowspan":1,"colspan":1},{"width":69.07232544378695,"title":"单价","field":"unitPrice","checked":true,"columnId":"unitPrice","fixed":false,"rowspan":1,"colspan":1},{"width":72.10486265361865,"title":"数量","field":"num","checked":true,"columnId":"num","fixed":false,"rowspan":1,"colspan":1},{"width":67.11113461538461,"title":"金额","field":"price","checked":true,"columnId":"price","fixed":false,"rowspan":1,"colspan":1},{"width":57.08931639029012,"title":"已退","field":"refundNum","checked":true,"columnId":"refundNum","fixed":false,"rowspan":1,"colspan":1},{"width":54.67232692307692,"title":"备注","field":"remark","checked":true,"columnId":"remark","fixed":false,"rowspan":1,"colspan":1},{"width":100,"title":"","field":"","checked":false,"columnId":"","fixed":false,"rowspan":1,"colspan":1},{"width":100,"title":"","field":"","checked":false,"columnId":"","fixed":false,"rowspan":1,"colspan":1}]]},"printElementType":{"title":"空白表格","type":"table","editable":true,"columnDisplayEditable":true,"columnDisplayIndexEditable":true,"columnTitleEditable":true,"columnResizable":true,"columnAlignEditable":true,"isEnableEditField":true,"isEnableContextMenu":true,"isEnableInsertRow":true,"isEnableDeleteRow":true,"isEnableInsertColumn":true,"isEnableDeleteColumn":true,"isEnableMergeCell":true}},{"options":{"left":200,"top":120,"height":16,"width":178,"title":"账单日期","field":"addTime","testData":"2024-12-28 11:00","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":359.49609375,"bottom":146.9921875,"vCenter":276.99609375,"hCenter":138.9921875,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":372,"top":120,"height":16,"width":178,"title":"客户","field":"ghsName","testData":"石头花艺","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":573.49609375,"bottom":145.99609375,"vCenter":484.49609375,"hCenter":137.99609375,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":27.5,"top":120,"height":16,"width":175,"title":"创建时间","right":141.75,"bottom":139.5,"vCenter":81.75,"hCenter":134.625,"field":"entryTime","testData":"2024-12-29 12:10","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":132.5,"top":145,"height":16,"width":90,"title":"售后","right":262.74609375,"bottom":161.2421875,"vCenter":202.74609375,"hCenter":153.2421875,"field":"tkPrice","testData":"63","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":222.5,"top":145,"height":16,"width":114,"title":"实际金额","field":"realPrice","testData":"23","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":358.9921875,"bottom":160.99609375,"vCenter":301.9921875,"hCenter":152.99609375,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":347.5,"top":145,"height":16,"width":120,"title":"电话","field":"telephone","testData":"15280215347","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":467.7421875,"bottom":161.2421875,"vCenter":407.7421875,"hCenter":153.2421875,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":425,"top":145,"height":16,"width":148,"title":"录单人","field":"staffName","testData":"小石","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textAlign":"right","textContentVerticalAlign":"middle","qrCodeLevel":0,"right":574.4921875,"bottom":161.2421875,"vCenter":500.4921875,"hCenter":153.2421875,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":27.5,"top":145,"height":16,"width":105,"title":"合计","field":"prePrice","testData":"693","coordinateSync":false,"widthHeightSync":false,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":144,"bottom":160.24609375,"vCenter":85.5,"hCenter":152.24609375,"fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":30,"top":169.5,"height":16,"width":120,"field":"numKind","testData":"共3种,数量:9","coordinateSync":false,"widthHeightSync":false,"hideTitle":true,"fontSize":11,"textContentVerticalAlign":"middle","qrCodeLevel":0,"title":"文本","fontFamily":"SimSun"},"printElementType":{"title":"文本","type":"text"}},{"options":{"left":169.5,"top":169.5,"height":16,"width":400,"title":"地址","field":"address","testData":"厦门前山路147号","coordinateSync":false,"widthHeightSync":false,"fontSize":10.5,"textContentVerticalAlign":"middle","qrCodeLevel":0,"right":569.5,"bottom":185.5,"vCenter":369.5,"hCenter":177.5},"printElementType":{"title":"文本","type":"text"}}],"paperNumberLeft":565.5,"paperNumberTop":389,"paperNumberDisabled":true,"paperNumberContinue":true,"orient":1,"watermarkOptions":{"content":"","rotate":25,"timestamp":false,"format":"YYYY-MM-DD HH:mm","fillStyle":"rgba(184, 184, 184, 0.3)","fontSize":"14px","width":200,"height":200},"panelLayoutOptions":{"layoutType":"column","layoutRowGap":0,"layoutColumnGap":0}}]}'; $info['template'] = $template; } //是否有云打印判断 $hasCloudPrint = 0; $shopExt = $this->shopExt; if (isset($shopExt->printSn) && !empty($shopExt->printSn) && isset($shopExt->printKey) && !empty($shopExt->printKey)) { $hasCloudPrint = 1; } $info['hasCloudPrint'] = $hasCloudPrint; $purchaseId = $info['purchaseId'] ?? 0; $cg = PurchaseClass::getById($purchaseId); $info['cgInfo'] = $cg; //店长信息 $mainId = $cg['mainId'] ?? 0; $superInfo = ShopAdminClass::getManager($mainId); $info['customSuper'] = $superInfo; util::success($info); } //获取订单信息 ssh 20240102 public function actionGetInfoByOrderSn() { $get = Yii::$app->request->get(); $orderSn = $get['orderSn'] ?? ''; $info = OrderService::getByCondition(['orderSn' => $orderSn], true); if (empty($info)) { util::fail('没有找到订单'); } if ($info->mainId != $this->mainId) { util::fail('不是你的订单哦'); } util::success(['info' => $info]); } //获取订单详情,不需要登录可以访问,后面要删除此方法 ssh 20220819 public function actionInfo() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $info = OrderService::getOrderInfo($id, true, true, true, false); if (empty($info)) { util::fail('没有找到订单'); } //是否有云打印判断 $hasCloudPrint = 0; $shopExt = $this->shopExt; if (isset($shopExt->printSn) && !empty($shopExt->printSn) && isset($shopExt->printKey) && !empty($shopExt->printKey)) { $hasCloudPrint = 1; } $info['hasCloudPrint'] = $hasCloudPrint; $purchaseId = $info['purchaseId'] ?? 0; $cg = PurchaseClass::getById($purchaseId); $info['cgInfo'] = $cg; //店长信息 $mainId = $cg['mainId'] ?? 0; $superInfo = ShopAdminClass::getManager($mainId); $info['customSuper'] = $superInfo; util::success($info); } //自取免发货流程处理 ssh 2021.1.22 public function actionWithoutSend() { util::complete(); } //本店送 ssh 2021.1.24 public function actionSelfSend() { $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $info = OrderClass::getById($id, true); OrderClass::valid($info->attributes, $this->shopId); $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { OrderClass::selfSend($info); $transaction->commit(); } catch (\Exception $exception) { $transaction->rollBack(); Yii::info("本店送操作报错:" . $exception->getMessage()); util::fail('操作失败'); } util::complete(); } //运费计算 ssh 2021.1.24 public function actionFreight() { //2021.3.28 接入达达 $get = Yii::$app->request->get(); $post = Yii::$app->request->post(); if (empty($get)) { $get = $post; } $orderId = $get['id'] ?? 0; //订单ID $customId = $get['customId'] ?? 0; if (empty($orderId)) { //自定义运费 //freight::getCost(); if (empty($customId)) { util::fail("请选择客户"); } $customInfo = CustomClass::getById($customId); if (empty($customInfo)) { util::fail('没有找到客户'); } $shop = $this->shop; //花材信息 $productJson = $get['product'] ?? ''; // $productJson = '[{"productId":31993,"bigNum":1,"smallNum":0}]'; if (empty($productJson)) { util::fail('请选择花材'); } $productList = json_decode($productJson, true); if (empty($productList)) { util::fail('请选择花材'); } $productList = ProductClass::mergeItemInfo($productList); $weight = 0; $price = 0; $productData = ProductClass::getProductMapData($productList); $bigNum = 0; foreach ($productList as $key => $val) { $productId = $val['productId']; $w = ProductClass::getWeight($val['productId'], $val['bigNum'], $val['smallNum']); $bigNum += $val['bigNum']; $weight = bcadd($w, $weight, 2); $ratio = $productData[$productId]['ratio'] ?? 0; //大小数量合并多少扎 $itemNum = ProductClass::mergeItemNum($val['bigNum'], $val['smallNum'], $ratio); //售卖价格 $itemPrice = $productData[$productId]['price'] ?? 0; //合计价格 $price = bcadd($price, bcmul($itemNum, $itemPrice, 2), 2); } //没有经纬度的客户运费直接返回空 ssh 20210612 if (empty($customInfo['lat']) || empty($customInfo['long'])) { util::success(['sedCost' => '']); } $cost = freight::getCost($shop->lat, $shop->long, $customInfo['lat'], $customInfo['long'], $weight); util::success(['sedCost' => $cost]); } $province = $get['province'] ?? ''; $city = $get['city'] ?? ''; $address = $get['address'] ?? ''; $floor = $get['floor'] ?? ''; $customName = $get['customName'] ?? ''; $customMobile = $get['customMobile'] ?? ''; $fullAddress = $province . $city . $address . $floor; $sendTime = $get['sendTime'] ?? ''; $lat = $get['lat'] ?? ''; $lng = $get['long'] ?? ''; if (empty($lat) || empty($lng) || empty($fullAddress)) { util::fail('请填写客户地址'); } ini_set('date.timezone', 'Asia/Shanghai'); if (!empty($sendTime)) { //配送时间不为空 // 预约发单时间(预约时间unix时间戳(10位),精确到分;整分钟为间隔,并且需要至少提前5分钟预约 $sendTimeInt = strtotime($sendTime); $now = time(); $diff = $sendTimeInt - $now; //因服务器写入时间,改为至少提前6分钟 if ($diff <= 360) { util::fail('配送时间至少提前6分钟'); } } else { //默认立即发送 $sendTime = 0; } //更新订单表 $info = OrderService::getOrderInfo($orderId); OrderClass::valid($info, $this->shopId); if ($sendTime) { $sendTime = date('Y-m-d H:i', strtotime($sendTime)); } else { $sendTime = '0000-00-00 00:00:00'; } $expressAddInfo = [ 'customName' => $customName, 'customMobile' => $customMobile, 'province' => $province, 'city' => $city, 'address' => $address, 'floor' => $floor, 'lat' => $lat, 'long' => $lng, 'sendTime' => $sendTime, ]; OrderClass::updateCustomExpressInfo($orderId, $expressAddInfo); //计算运费 $info['province'] = $province; $info['city'] = $city; $info['address'] = $address; $info['floor'] = $floor; $info['fullAddress'] = $fullAddress; $info['lat'] = $lat; $info['long'] = $lng; $info['sendTime'] = $expressAddInfo['sendTime']; $res = DadaExpressServices::queryDeliverFee($info); util::success(['sedCost' => $res['fee']]); } //发快递和第三方配送 ssh 2021.1.24 public function actionThirdSend() { $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $info = OrderService::getById($id, true); OrderClass::valid($info->attributes, $this->shopId); if (empty($info->lat) || empty($info->long) || empty($info->fullAddress)) { util::fail('请填写客户地址'); } $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $respond = OrderClass::thirdSend($info, $get); $transaction->commit(); util::success($respond); } catch (\Exception $exception) { $transaction->rollBack(); Yii::info("发快递操作报错:" . $exception->getMessage()); util::fail('操作失败' . $exception->getMessage()); } } //确认送达 ssh 2021.1.24 public function actionReach() { $get = Yii::$app->request->get(); $id = isset($get['id']) ? $get['id'] : 0; $info = OrderClass::getById($id, true); OrderClass::valid($info->attributes, $this->shopId); $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { OrderService::reach($info); $transaction->commit(); } catch (\Exception $exception) { $transaction->rollBack(); Yii::info("送达操作报错:" . $exception->getMessage()); util::fail('操作失败'); } util::complete(); } //下单要用到的相关信息 ssh 2019.12.6 public function actionOrderRelate() { $regionTree = RegionService::tree(); $shop = $this->shop->attributes; $freight = ['first' => 5, 'add' => 2]; $mapKey = 'OFWBZ-2NTHP-EHNDD-LKWQY-GANM7-PXBJH'; $out = ['freight' => $freight, 'shop' => $shop, 'region' => $regionTree, 'thirdMapKey' => $mapKey, 'merchant' => $shop]; util::success($out); } //客户欠款的订单 ssh 2021.2.4 public function actionDebtList() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $info = CustomClass::getCustom($id); CustomClass::valid($info, $this->shopId); $mainId = $this->mainId; $where = ['mainId' => $mainId, 'customId' => $id, 'debt' => 1]; $searchTime = $get['searchTime'] ?? ''; if (!empty($searchTime)) { $startTime = $get['startTime'] ?? ''; $endTime = $get['endTime'] ?? ''; $period = dateUtil::formatTime($searchTime, $startTime, $endTime); $where['payTime'] = ['between', [$period['startTime'], $period['endTime']]]; } else { if ($mainId == 33447 && $id == 51031) { util::fail('请选时间'); } } $list = OrderClass::getAllByCondition($where, 'addTime DESC', ['id', 'orderSn', 'actPrice', 'addTime', 'remainDebtPrice', 'payTime']); $result = ['customInfo' => $info, 'list' => $list]; util::success($result); } //更新打印次数 public function actionAddPrintNum() { $id = Yii::$app->request->get('id', 0); $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); $order->printNum += 1; $order->save(); util::complete(); } //打印订单 ssh 20210714 public function actionCloudPrintOrder() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $showPrice = $get['showPrice'] ?? 1; $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); if ($order->status == OrderClass::ORDER_STATUS_UN_PAY) { util::fail('订单还没有付款'); } if ($order->status == OrderClass::ORDER_STATUS_CANCEL) { util::fail('订单已取消'); } $ext = $this->shopExt; if (isset($ext->printSn) == false || isset($ext->printKey) == false || empty($ext->printSn) || empty($ext->printKey)) { util::success(['hasNoPrint' => 1]); } OrderClass::onlinePrint($order, $showPrice); $order->printNum += 1; $order->save(); util::complete(); } //订单确认完成 ssh 20210809 public function actionConfirmFinish() { $payWay = Yii::$app->request->get('payWay', -1); $id = Yii::$app->request->get('id', 0); $clearType = Yii::$app->request->get('clearType', 0); $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $order = OrderClass::getById($id, true); OrderClass::valid($order, $this->shopId); $purchaseId = $order->purchaseId ?? 0; $purchase = PurchaseClass::getById($purchaseId, true); if (empty($purchase)) { util::fail('没有采购信息'); } if ($clearType == 1) { //欠款 $payWay = dict::getDict('payWay', 'debtPay'); } elseif ($clearType == 2) { //已收款 if ($payWay == -1) { util::fail('请选择收款方式'); } $shopAdmin = $this->shopAdmin; if (isset($shopAdmin->super) == false || $shopAdmin->super != 1) { util::fail('超管才能发起已收款'); } } else { util::fail('请选择结算方式'); } //不需要打印 $order->needPrint = dict::getDict('needPrint', 'noNeed'); $order->save(); //支付 PurchaseService::payAfter($purchase, $payWay); OrderService::payAfter($order, $payWay); //自己送 $info = OrderClass::getById($id, true); OrderClass::selfSend($info); //确认送达,并且不需要微信通知 Yii::$app->params['noNeedWxNotice'] = 1; $info = OrderClass::getById($id, true); OrderService::reach($info); $transaction->commit(); util::complete('操作成功'); } catch (\Exception $exception) { $transaction->rollBack(); Yii::info("确认完成订单报错:" . $exception->getMessage()); util::fail('操作失败'); } } //取消订单 ssh 20220110 public function actionCancel() { $shopAdmin = $this->shopAdmin; if (isset($shopAdmin->super) == false || $shopAdmin->super != 1) { util::fail('超管才能取消订单'); } $id = Yii::$app->request->get('id'); $order = OrderClass::getById($id, true); if ($order->orderType == 2) { util::fail('客户下单,不能主动取消'); } OrderClass::valid($order, $this->shopId); OrderService::expire($order, true); util::complete('已取消'); } //获取收款语音播报地址 ssh 20211231 public function actionGetPayVoice() { $id = Yii::$app->request->get('id'); $order = OrderClass::getById($id, true); $payWay = $order->payWay ?? 0; $money = floatval($order->actPrice); $payment = $payWay == dict::getDict('payWay', 'alipay') ? '支付宝' : '微信'; $msg = $payment . '收款' . $money . '元'; $audio = baiduAip::transfer($msg, 4, 0); //上传到oss $file = time() . rand(10000, 999999) . '.mp3'; $filePath = 'tmp/arrival/money/' . $file; oss::uploadTmpAudio($filePath, $audio); $url = Yii::$app->params['ghsImgHost'] . $filePath; util::success(['url' => $url]); } //修改备注 public function actionModifyRemark() { $post = Yii::$app->request->post(); $id = $post['id'] ?? 0; $remark = $post['remark'] ?? ''; $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单'); } $cgId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($cgId, true); if (empty($cg)) { util::fail('采购单没有找到'); } $order->remark = $remark; $order->save(); $cg->remark = $remark; $cg->save(); util::complete('修改成功'); } //修改订单的确认时间 ssh 20240511 public function actionModifyOrderConfirmTime() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $date = $get['date'] ?? ''; if (empty($date)) { util::fail('请选择日期'); } $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的订单'); } if ($order->payStatus == 0) { util::fail('没有确认的订单'); } $mainId = $this->mainId; //超管或者约定的人可以修改日期 if (getenv('YII_ENV') == 'production') { if (in_array($mainId, [23390])) { if (!in_array($this->adminId, [24586, 23960, 24043])) { util::fail('你不能修改哦'); } } } else { if (in_array($mainId, [644])) { if (!in_array($this->adminId, [919])) { } } } $payTime = $order->payTime; $time = strtotime($payTime); $after = date("H:i:s", $time); $new = $date . ' ' . $after; $cgId = $order->purchaseId ?? 0; $cg = PurchaseClass::getById($cgId, true); if (empty($cg)) { util::fail('没有找到订单信息'); } if (strtotime($new) > time()) { util::fail('不能修改成未来时间'); } $order->payTime = $new; $order->save(); $cg->payTime = $new; $cg->save(); //有修改账单日期需要更新到欠款变动明细,财务好对账,多个地方要同步修改,关键词to_change_custom_debt_pay_time CustomDebtChangeClass::updateByCondition(['capitalType' => 10, 'relateId' => $id], ['payTime' => $new]); util::complete('修改成功'); } //应收款统计 ssh 20240528 public function actionAccountList() { $get = Yii::$app->request->get(); $mainId = $this->mainId; $export = $get['export'] ?? 0; $debt = isset($get['debt']) && is_numeric($get['debt']) ? $get['debt'] : -1; $searchTime = isset($get['searchTime']) && !empty($get['searchTime']) ? $get['searchTime'] : 'today'; $startTime = $get['startTime'] ?? ''; $endTime = $get['endTime'] ?? ''; $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true); $start = $period['startTime']; $end = $period['endTime']; $customList = CustomClass::getAllByCondition(['ownMainId' => $this->mainId], null, 'id,name', 'id'); $currentStartDate = date('Y-m-d', strtotime($start)); $currentEndDate = date('Y-m-d', strtotime($end)); $currentStartTime = $currentStartDate . ' 00:00:00'; $currentEndTime = $currentEndDate . ' 23:59:59'; $where = ['mainId' => $mainId]; if ($debt > -1) { $where['debt'] = $debt; } $where['payTime'] = ['between', [$currentStartTime, $currentEndTime]]; $orderList = OrderClass::getAllByCondition($where, null, '*'); $list = []; $totalAmount = 0; if (!empty($orderList)) { foreach ($orderList as $orderInfo) { $actPrice = $orderInfo['actPrice'] ?? 0; $customId = $orderInfo['customId'] ?? 0; $status = $orderInfo['status'] ?? 0; $book = $orderInfo['book'] ?? 0; if ($status == 1 || $status == 5) { continue; } if ($book == 1 && $status == 2) { continue; } if (isset($list[$customId])) { $list[$customId]['amount'] = bcadd($list[$customId]['amount'], $actPrice, 2); $list[$customId]['num'] = bcadd($list[$customId]['num'], 1); } else { $name = $customList[$customId] && $customList[$customId]['name'] ? $customList[$customId]['name'] : '未命名'; $list[$customId] = ['id' => $customId, 'name' => $name, 'amount' => $actPrice, 'num' => 1]; } $totalAmount = bcadd($totalAmount, $actPrice, 2); } $list = array_values($list); } if ($export == 1) { if (empty($list)) { util::fail('没有数据需要导出'); } ini_set('memory_limit', '2045M'); set_time_limit(0); OrderClass::exportAccountList($list, $mainId); util::stop(); } util::success(['list' => $list, 'totalAmount' => $totalAmount]); } //应收款统计 ssh 20240528 public function actionPastList() { $get = Yii::$app->request->get(); $export = $get['export'] ?? 0; $searchTime = isset($get['searchTime']) && !empty($get['searchTime']) ? $get['searchTime'] : 'today'; $startTime = $get['startTime'] ?? ''; $endTime = $get['endTime'] ?? ''; $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true); $end = $period['endTime']; $customList = CustomClass::getAllByCondition(['ownMainId' => $this->mainId], null, 'id,name,mobile', 'id'); $currentDate = date('Y-m-d 00:00:00', bcadd(strtotime($end), 86400)); $totalAmount = 0; if (!empty($customList)) { foreach ($customList as $key => $custom) { $customId = $custom['id'] ?? 0; $change = CustomDebtChangeClass::getByCondition(['customId' => $customId, 'addTime<' => $currentDate], true, 'addTime DESC'); $amount = $change->balance ?? 0; $totalAmount = bcadd($totalAmount, $amount, 2); $customList[$key]['currentDebAmount'] = $amount; } $customList = array_values($customList); } if ($export == 1) { $mainId = $this->mainId; if (empty($customList)) { util::fail('没有数据需要导出'); } ini_set('memory_limit', '2045M'); set_time_limit(0); OrderClass::exportPastList($customList, $mainId); util::stop(); } util::success(['list' => $customList, 'totalAmount' => $totalAmount]); } //客户业绩,有多个地方,需要同步,搜索关键词 customYj ssh 20240628 public function actionYj() { $get = Yii::$app->request->get(); $mainId = $this->mainId; $export = $get['export'] ?? 0; $debt = isset($get['debt']) && is_numeric($get['debt']) ? $get['debt'] : -1; $searchTime = isset($get['searchTime']) && !empty($get['searchTime']) ? $get['searchTime'] : 'today'; $startTime = $get['startTime'] ?? ''; $endTime = $get['endTime'] ?? ''; $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true); $start = $period['startTime']; $end = $period['endTime']; $customList = CustomClass::getAllByCondition(['ownMainId' => $mainId], null, '*', 'id'); $currentStartDate = date('Y-m-d', strtotime($start)); $currentEndDate = date('Y-m-d', strtotime($end)); $currentStartTime = $currentStartDate . ' 00:00:00'; $currentEndTime = $currentEndDate . ' 23:59:59'; $where = ['mainId' => $mainId]; if ($debt > -1) { $where['debt'] = $debt; } $where['payTime'] = ['between', [$currentStartTime, $currentEndTime]]; $orderList = OrderClass::getAllByCondition($where, null, '*'); $list = []; $totalActPrice = 0; $totalOrderPrice = 0; $totalCarton = 0; $totalCartonNum = 0; $totalPack = 0; $totalFreight = 0; $totalTkPrice = 0; //增加项 $totalOnlyTkPrice = 0; $totalNum = 0; if (!empty($orderList)) { foreach ($orderList as $orderInfo) { $actPrice = $orderInfo['actPrice'] ?? 0; $orderPrice = $orderInfo['orderPrice'] ?? 0; $customId = $orderInfo['customId'] ?? 0; $status = $orderInfo['status'] ?? 0; $book = $orderInfo['book'] ?? 0; $orderSn = $orderInfo['orderSn'] ?? ''; $tkPrice = $orderInfo['tkPrice'] ?? 0; if ($status == 1 || $status == 5) { continue; } if ($book == 1 && $status == 2) { continue; } $carton = 0; $cartonNum = 0; $pack = 0; $freight = 0; $orderItemList = OrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*'); if ($actPrice > 0) { if (!empty($orderItemList)) { foreach ($orderItemList as $orderItem) { $num = $orderItem['xhNum'] ?? 0; $unitPrice = $orderItem['xhUnitPrice'] ?? 0; $refundNum = $orderItem['refundNum'] ?? 0; $classId = $orderItem['classId'] ?? 0; if (getenv('YII_ENV') == 'production') { //小向算打包纸箱费用 if ($mainId == 23390) { $remainNum = bcsub($num, $refundNum); $amount = bcmul($remainNum, $unitPrice, 2); if ($classId == 72106) { $carton = bcadd($carton, $amount, 2); $cartonNum = bcadd($cartonNum, $remainNum); } if ($classId == 72108) { $pack = bcadd($pack, $amount, 2); } if ($classId == 73118) { $freight = bcadd($freight, $amount, 2); } } //花大苪 if ($mainId == 8164) { $remainNum = bcsub($num, $refundNum); $amount = bcmul($remainNum, $unitPrice, 2); if ($classId == 90497) { $carton = bcadd($carton, $amount, 2); $cartonNum = bcadd($cartonNum, $remainNum); } if ($classId == 90501) { $freight = bcadd($freight, $amount, 2); } } //石头花艺 if ($mainId == 50) { $remainNum = bcsub($num, $refundNum); $amount = bcmul($remainNum, $unitPrice, 2); if ($classId == 71495) { $carton = bcadd($carton, $amount, 2); $cartonNum = bcadd($cartonNum, $remainNum); } if ($classId == 91009) { $freight = bcadd($freight, $amount, 2); } } } } } } //增加项 if ($tkPrice > 0) { $refundList = RefundOrderClass::getAllByCondition(['relateOrderSn' => $orderSn], null, '*', null, true); if (!empty($refundList)) { foreach ($refundList as $refundInfo) { if ($refundInfo->status == 1) { if ($refundInfo->refundType == 2) { $refundPrice = $refundInfo->refundPrice ?? 0; $totalOnlyTkPrice = bcadd($totalOnlyTkPrice, $refundPrice, 2); } } } } } $totalCarton = bcadd($totalCarton, $carton, 2); $totalCartonNum = bcadd($totalCartonNum, $cartonNum); $totalPack = bcadd($totalPack, $pack, 2); $totalFreight = bcadd($totalFreight, $freight, 2); $totalTkPrice = bcadd($totalTkPrice, $tkPrice, 2); $totalActPrice = bcadd($totalActPrice, $actPrice, 2); $totalOrderPrice = bcadd($totalOrderPrice, $orderPrice, 2); $totalNum++; if (isset($list[$customId])) { $list[$customId]['actPrice'] = bcadd($list[$customId]['actPrice'], $actPrice, 2); $list[$customId]['orderPrice'] = bcadd($list[$customId]['orderPrice'], $orderPrice, 2); $list[$customId]['num'] = bcadd($list[$customId]['num'], 1); $list[$customId]['carton'] = bcadd($list[$customId]['carton'], $carton, 2); $list[$customId]['cartonNum'] = bcadd($list[$customId]['cartonNum'], $cartonNum); $list[$customId]['pack'] = bcadd($list[$customId]['pack'], $pack, 2); $list[$customId]['freight'] = bcadd($list[$customId]['freight'], $freight, 2); $list[$customId]['tkPrice'] = bcadd($list[$customId]['tkPrice'], $tkPrice, 2); } else { $name = $customList[$customId] && $customList[$customId]['name'] ? $customList[$customId]['name'] : '未命名'; $mobile = $customList[$customId] && $customList[$customId]['mobile'] ? $customList[$customId]['mobile'] : '0'; $list[$customId] = [ 'id' => $customId, 'name' => $name, 'mobile' => $mobile, 'orderPrice' => $orderPrice, 'actPrice' => $actPrice, 'num' => 1, 'carton' => $carton, 'cartonNum' => $cartonNum, 'pack' => $pack, 'freight' => $freight, 'tkPrice' => $tkPrice, ]; } } foreach ($customList as $key => $custom) { $customId = $custom['id'] ?? 0; if (isset($list[$customId]) == false) { $list[$customId] = [ 'id' => $customId, 'name' => $custom['name'], 'mobile' => $custom['mobile'], 'actPrice' => 0, 'num' => 0, 'carton' => 0, 'pack' => 0, 'freight' => 0, 'tkPrice' => 0, 'orderPrice' => 0, ]; } } $list = array_values($list); } if ($export == 1) { if (empty($list)) { util::fail('没有数据需要导出'); } ini_set('memory_limit', '2045M'); set_time_limit(0); OrderClass::exportYj($list, $mainId); util::stop(); } util::success([ 'list' => $list, 'totalActPrice' => $totalActPrice, 'totalOrderPrice' => $totalOrderPrice, 'totalCarton' => $totalCarton, 'totalCartonNum' => $totalCartonNum, 'totalNum' => $totalNum, 'totalPack' => $totalPack, 'totalFreight' => $totalFreight, 'totalTkPrice' => $totalTkPrice, //增加项 'totalOnlyTkPrice' => $totalOnlyTkPrice, ]); } //修改配送人 ssh 20240824 public function actionChangeSendStaff() { $staff = $this->shopAdmin; if (isset($staff->finance) == false || $staff->finance == 0) { util::fail('请有财务权限的人修改'); } $get = Yii::$app->request->get(); $staffId = $get['staffId'] ?? 0; $orderId = $get['orderId'] ?? 0; $order = OrderClass::getById($orderId, true); if (empty($order)) { util::fail('没有找到订单'); } if ($order->mainId != $this->mainId) { util::fail('不是你的'); } $staff = ShopAdminClass::getById($staffId, true); if (empty($staff)) { util::fail('没有找到员工'); } if ($staff->mainId != $this->mainId) { util::fail('不是你的员工'); } $staffName = $staff->name ?? ''; $order->sendStaffId = $staffId; $order->sendStaffName = $staffName; $order->save(); util::complete('修改成功'); } //导入开单 ssh 20241126 public function actionImportCreate() { ini_set('memory_limit', '2045M'); set_time_limit(0); $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); try { $get = Yii::$app->request->get(); $customId = $get['id'] ?? ''; $customRes = CustomClass::getById($customId, true); if (empty($customRes)) { util::fail('没有找到客户'); } if ($customRes->ownMainId != $this->mainId) { util::fail('不是你的客户'); } if (isset($customRes->mainId) && !empty($customRes->mainId) && $customRes->mainId == $customRes->ownMainId) { util::fail('不能给自己开单'); } $file = $_FILES['file']; if (!is_uploaded_file($file['tmp_name'])) { util::fail('please upload img'); } $mainId = $this->mainId; $sjId = $this->sjId; $shopId = $this->shopId; $month = date("Ym"); $date = date("d"); $path = dirUtil::getImgUploadDir() . "/{$mainId}/kd/{$shopId}/{$month}/{$date}/"; if (!file_exists($path)) { //检查是否有该文件夹,如果没有就创建,并给予最高权限 mkdir($path, 0700, true); } $preFileName = stringUtil::uniqueFileName(); $newFile = $preFileName . ".xls"; $fullPathFile = $path . $newFile; if (move_uploaded_file($file['tmp_name'], $fullPathFile)) { $arr = []; $phpExcelFile = Yii::getAlias("@vendor/phpoffice/phpexcel/"); require_once($phpExcelFile . 'Classes/PHPExcel/IOFactory.php'); $spreadsheet = \PHPExcel_IOFactory::load($fullPathFile); // 获取活动工作表 $worksheet = $spreadsheet->getActiveSheet(); // 遍历每一行 foreach ($worksheet->getRowIterator() as $key => $row) { $cellIterator = $row->getCellIterator(); // 这里设置为迭代所有单元格,包括空单元格 $cellIterator->setIterateOnlyExistingCells(FALSE); // 遍历每列 $rowData = []; foreach ($cellIterator as $cell) { $option = $cell->getValue(); $rowData[] = trim($option); } $arr[] = $rowData; } array_shift($arr); $productIds = []; foreach ($arr as $k => $v) { $productId = $v[0] ?? 0; $productId = trim($productId); if (is_numeric($productId) && $productId > 0) { $productIds[] = $productId; } } if (empty($productIds)) { util::fail('没有识别出花材'); } $productInfo = ProductClass::getByIds($productIds, null, 'id'); if (empty($productInfo)) { util::fail('没有找到有效花材'); } $mat = []; foreach ($arr as $k => $v) { $productId = $v[0] ?? 0; $productId = trim($productId); $num = $v[2] ?? 0; $num = trim($num); $unitPrice = $v[3] ?? 0; $unitPrice = trim($unitPrice); $remark = $v['5'] ?? ''; $remark = trim($remark); if (is_numeric($productId) && $productId > 0 && $num > 0 && $unitPrice > 0) { $product = $productInfo[$productId] ?? []; $ptItemId = $product['itemId'] ?? 0; $mat[] = [ 'productId' => $productId, 'bigNum' => $num, 'itemId' => $ptItemId, 'smallNum' => 0, 'price' => $unitPrice, 'remark' => $remark, ]; } } $modifyPrice = 0; foreach ($mat as $ma) { $cNum = $ma['bigNum'] ?? 0; $cPrice = $ma['price'] ?? 0; $cTotal = bcmul($cNum, $cPrice, 2); $modifyPrice = bcadd($modifyPrice, $cTotal, 2); } $customName = $customRes->name ?? ''; $customMobile = $customRes->mobile ?? ''; $customPy = $customRes->py ?? ''; $ghsId = $customRes->ghsId ?? 0; $hasPay = 2; $custom = CustomClass::getCustom($customId); $post = []; $post['modifyPrice'] = $modifyPrice; $post['shopId'] = $shopId; $post['sendType'] = 0; $post['transType'] = 0; $post['sendSide'] = 0; $post['sendCost'] = 0; $post['packCost'] = 0; $post['customId'] = $customId; $post['customName'] = $customName; $post['payWay'] = 0; $post['needPrint'] = 2; $post['hasPay'] = 2; $post['product'] = $mat; $post['deadline'] = date("Y-m-d H:i:s", time() + 86400); $post['debt'] = 1; $post['mainId'] = $mainId; $post['fromType'] = 1; $post['expressId'] = 0; $post['sjId'] = $sjId; $staff = $this->shopAdmin; $staffId = $staff->id ?? 0; $staffName = $staff->name ?? ''; $post['shopAdminId'] = $staffId; $post['shopAdminName'] = $staffName; $post['getStaffId'] = $staffId; $post['getStaffName'] = $staffName; $post['customMobile'] = $customMobile; $post['customNamePy'] = $customPy; $post['customAvatar'] = ''; $post['newVersion'] = 1; $post['book'] = 1; $post['wlName'] = ''; $post['dealPrice'] = 1; $post['ghsId'] = $ghsId; $shop = $this->shop; $bookSn = $shop->bookSn ?? 0; $post['bookSn'] = $bookSn; //多处有用到此方法,需要同步修改,搜索关键词create_new_order OrderService::createNewOrder($post, $custom, $hasPay); $transaction->commit(); util::complete('提交成功'); } else { util::fail('上传失败了,出错了哦'); } } catch (\Exception $e) { $transaction->rollBack(); Yii::info("导入失败了," . $e->getMessage()); noticeUtil::push('导入失败,失败原因:' . $e->getMessage(), '15280215347'); $msg = $e->getMessage(); util::fail('导入失败:' . $msg); } } //打印发物流用和标签 ssh 20250312 public function actionPrintWlLabel() { $get = Yii::$app->request->get(); $id = $get['id'] ?? 0; $order = OrderClass::getById($id, true); if (empty($order)) { util::fail('没有找到订单'); } $ext = $this->shopExt; $shop = $this->shop; OrderClass::printLogisticsLabel($order, $shop, $ext); util::complete('打印成功'); } }