huahuibao/app-ghs/controllers/StatBookController.php

<?php

namespace ghs\controllers;

use biz\shop\classes\ShopExtClass;
use biz\stat\classes\StatBookClass;
use bizGhs\product\classes\ProductClass;
use common\components\dateUtil;
use common\components\printUtil;
use Yii;
use common\components\util;

class StatBookController extends BaseController
{

    public function actionList()
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $this->mainId;
        $searchTime = $get['searchTime'] ?? 'today';
        if (!empty($searchTime)) {
            $startTime = $get['startTime'] ?? '';
            $endTime = $get['endTime'] ?? '';
            $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
            $where['time'] = ['between', [$period['startTime'], $period['endTime']]];
        }
        $itemList = ProductClass::getAllByCondition(['mainId' => $this->mainId], null, 'id,stock', 'id', true);
        $list = StatBookClass::getAllByCondition($where, 'time DESC', '*');
        if (!empty($list)) {
            foreach ($list as $key => $val) {
                $productId = $val['itemId'] ?? 0;
                $stock = 0;
                if (isset($itemList[$productId])) {
                    $product = $itemList[$productId];
                    $stock = $product->stock;
                }
                $list[$key]['stock'] = floatval($stock);
                $time = $val['time'];
                $shortTime = substr($time, 4, 4);
                $list[$key]['shortTime'] = $shortTime;
            }
        }
        util::success(['list' => $list]);
    }

    //花材销量 ssh 20211021
    public function actionProfile()
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $this->mainId;
        $searchTime = $get['searchTime'] ?? 'today';
        if (!empty($searchTime)) {
            $startTime = $get['startTime'] ?? '';
            $endTime = $get['endTime'] ?? '';
            $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
            $where['time'] = ['between', [$period['startTime'], $period['endTime']]];
        }
        $itemList = ProductClass::getAllByCondition(['mainId' => $this->mainId], null, 'id,stock', 'id', true);
        $list = StatBookClass::getAllByCondition($where, 'time DESC', '*');
        if (!empty($list)) {
            foreach ($list as $key => $val) {
                $productId = $val['itemId'] ?? 0;
                $stock = 0;
                if (isset($itemList[$productId])) {
                    $product = $itemList[$productId];
                    $stock = $product->stock;
                }
                $list[$key]['stock'] = floatval($stock);
                $time = $val['time'];
                $shortTime = substr($time, 4, 4);
                $list[$key]['shortTime'] = $shortTime;
            }
        }
        util::success(['list' => $list]);
    }

    public function actionPrintOrder()
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $this->mainId;
        $searchTime = $get['searchTime'] ?? 'today';
        if (!empty($searchTime)) {
            $startTime = $get['startTime'] ?? '';
            $endTime = $get['endTime'] ?? '';
            $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
            $where['time'] = ['between', [$period['startTime'], $period['endTime']]];
        }

        $list = StatBookClass::getAllByCondition($where, 'time DESC', '*');
        if (empty($list)) {
            util::fail('没有花材需要打印');
        }
        $shop = $this->shop;
        $num = count($list);
        $pageSize = 30;
        $ratio = ceil($num / $pageSize);
        if ($ratio > 1) {
            for ($i = 1; $i <= $ratio; $i++) {
                $offset = ($i - 1) * $pageSize;
                $current = array_slice($list, $offset, $pageSize);
                self::printOrder($current, $shop, $i);
            }
        } else {
            self::printOrder($list, $shop);
        }
        util::complete('打印成功');
    }

    public static function printOrder($list, $shop, $order = 0)
    {
        $content = "<CB>预订汇总</CB><BR><BR>";
        if ($order > 0) {
            $content .= "<CB>第{$order}页</CB><BR><BR>";
        }
        $content .= '日期 / 花材 / 数量<BR>';
        $content .= '--------------------------------<BR>';
        foreach ($list as $item) {
            $date1 = $item['time'];
            $date2 = substr($date1, 4, 4);
            $name = $item['name'] ?? '';
            $num = $item['num'] ?? 0;
            $content .= $date2 . ' ' . $name . ' ' . $num . '<BR>';
            $content .= '--------------------------------<BR>';
        }
        $content .= "<BR><BR><BR>";
        $shopId = $shop->id ?? 0;
        $ext = ShopExtClass::getByCondition(['shopId' => $shopId]);
        $printSn = $ext['printSn'] ?? '';
        if (empty($printSn)) {
            util::fail('没有找到打印机');
        }
        $p = new printUtil($printSn);
        $p->printMsg($content, $shop);
    }

}