huahuibao/app-ghs/controllers/ItemController.php

<?php

namespace ghs\controllers;

use biz\item\classes\PtItemClass;
use biz\product\models\Product;
use bizGhs\custom\classes\CustomClass;
use bizGhs\item\classes\ItemClass;
use common\components\dict;
use common\components\imgUtil;
use common\components\miniUtil;
use common\components\noticeUtil;
use common\components\stringUtil;
use common\components\util;
use bizGhs\product\classes\ProductClass;
use bizHd\wx\classes\WxOpenClass;
use Yii;

class ItemController extends BaseController
{

    //列出所有花材 ssh 20240222
    public function actionGetItemList()
    {
        $get = Yii::$app->request->get();
        $search = $get['search'] ?? '';
        $requestType = $get['requestType'] ?? 'kd';
        $classId = $get['classId'] ?? 0;

        $where['mainId'] = $this->mainId;
        if ($requestType == 'kd') {
            $where['delStatus'] = 0;
            $where['status'] = 1;
        } elseif ($requestType == 'itemList') {
            $where['delStatus'] = 0;
            unset($where['status']);
        } elseif ($requestType == 'changePrice') {
            $where['delStatus'] = 0;
            $where['stock>'] = 0;
        } elseif ($requestType == 'hasStockList') {
            $where['delStatus'] = 0;
            $where['stock>'] = 0;
        } elseif ($requestType == 'book') {
            $where['delStatus'] = 0;
            unset($where['status']);
        } elseif ($requestType == 'outList') {
            $where['delStatus'] = 0;
            $where['status'] = 2;
            $where['removeStatus'] = 0;
        } elseif ($requestType == 'stopList') {
            $where['delStatus'] = 1;
            unset($where['status']);
            $where['removeStatus'] = 0;
        } elseif ($requestType == 'removeList') {
            $where['delStatus'] = 1;
            unset($where['status']);
            $where['removeStatus'] = 1;
        } elseif ($requestType == 'cg') {
            $where['delStatus'] = 0;
            unset($where['status']);
        } elseif ($requestType == 'changeStock') {
            $where['delStatus'] = 0;
            unset($where['status']);
        } elseif ($requestType == 'check') {
            $where['delStatus'] = 0;
            unset($where['status']);
        } elseif ($requestType == 'stockOut') {
            $where['delStatus'] = 0;
            $where['status'] = 1;
        } elseif ($requestType == 'break') {
            $where['delStatus'] = 0;
            $where['status'] = 1;
        } else {
            util::fail('没有定义的请求方式');
        }
        if (!empty($search)) {
            if (stringUtil::isLetter($search)) {
                $search = strtolower($search);
                $where['py'] = ['like', $search];
            } else {
                $where['name'] = ['like', $search];
            }
        } else {
            if (!empty($classId)) {
                if ($classId == -1) {
                    $where['discountPrice>'] = 0;
                } elseif ($classId == -2) {
                    $where['reachNum>'] = 0;
                } elseif ($classId == -3) {
                    $where['presell'] = 1;
                } else {
                    $where['classId'] = $classId;
                }
            }
        }
        $customId = $get['customId'] ?? 0;
        $custom = CustomClass::getById($customId, true);
        if (!empty($custom)) {
            if ($custom->ownMainId != $this->mainId) {
                util::fail('不是你的客户');
            }
        }
        $level = $custom->level ?? 1;
        $field = '*';
        $result = ProductClass::getList($field, $where, ['inTurn' => SORT_DESC, 'actualSold' => SORT_DESC]);
        $list = $result['list'] ?? [];
        if ($requestType == 'hasStockList') {
            util::fail('无效方式');
        } elseif ($requestType == 'changePrice') {
            $list = ProductClass::changePriceGroup($list, $level);
        } elseif ($requestType == 'changeStock') {
            $list = ProductClass::changeStockGroup($list, $level);
        } elseif ($requestType == 'kd') {
            $list = ProductClass::kdItemGroup($list, $level);
        } elseif ($requestType == 'book') {
            $list = ProductClass::bookItemGroup($list, $level);
        } elseif ($requestType == 'itemList') {
            $list = ProductClass::itemListGroup($list, $level);
        } elseif ($requestType == 'outList') {
            $list = ProductClass::simpleGroup($list, $level);
        } elseif ($requestType == 'stopList') {
            $list = ProductClass::simpleGroup($list, $level);
        } elseif ($requestType == 'removeList') {
            $list = ProductClass::simpleGroup($list, $level);
        } elseif ($requestType == 'check') {
            $list = ProductClass::checkItemGroup($list, $level);
        } elseif ($requestType == 'break') {
            $list = ProductClass::breakItemGroup($list, $level);
        } elseif ($requestType == 'part') {
            $list = ProductClass::partItemGroup($list, $level);
        } elseif ($requestType == 'stockOut') {
            $list = ProductClass::stockOutGroup($list, $level);
        } elseif ($requestType == 'cg') {
            $list = ProductClass::cgItemGroup($list, $level);
        } elseif ($requestType == 'warning') {
            util::fail('无效方式');
//            $itemInfoData = Product::find()->where("mainId={$this->mainId}")
//                ->andWhere('`stock`+`onStock`<`stockWarning`')
//                ->andWhere("delStatus=0")
//                ->select($field)->asArray()->all();
//            $itemInfoData = ProductClass::warningGroup($itemInfoData, $level);
        } else {
            util::fail('没有数据');
        }
        $result['list'] = $list;
        util::success($result);
    }

    //花材申请平台认证 ssh 20231125
    public function actionApplyAuth()
    {
        $get = Yii::$app->request->get();
        $id = $get['id'] ?? 0;
        $info = ItemClass::getById($id, true);
        if (empty($info)) {
            util::fail('没有找到花材');
        }
        if ($info->mainId != $this->mainId) {
            util::fail('不是你的花材哦');
        }
        $shop = $this->shop;
        $sjName = $shop->merchantName ?? '';
        $shopName = $shop->shopName ?? '';
        $name = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
        $ptItemId = $info->itemId ?? 0;
        $ptItem = PtItemClass::getById($ptItemId, true);
        if (empty($ptItem)) {
            util::fail('没有找到平台花材');
        }
        $ptItemName = $ptItem->name ?? '';
        noticeUtil::push($name . " 申请将【{$ptItemName}/{$ptItemId}】进行认证", '15280215347');
        util::complete();
    }

    //简单花材的列表
    public function actionSimpleList()
    {
        $get = Yii::$app->request->get();
        $name = $get['name'] ?? '';
        $where = ['mainId' => $this->mainId, 'delStatus' => 0];
        if (!empty($name)) {
            if (stringUtil::isLetter($name)) {
                $where['py'] = ['like', $name];
            } else {
                $where['name'] = ['like', $name];
            }
        }
        $respond = ItemClass::getSimpleList($where);
        util::success($respond);
    }

    public function actionChangeFrontHide()
    {
        $get = Yii::$app->request->get();
        $id = $get['id'] ?? 0;
        $status = $get['status'] ?? '';
        if (is_numeric($status) == false) {
            util::fail('请选择方式');
        }
        $info = ItemClass::getById($id, true);
        if (empty($info)) {
            util::fail('没有找到花材');
        }
        if ($info->mainId != $this->mainId) {
            util::fail('无法操作');
        }
        $info->frontHide = $status;
        $info->save();
        util::complete();
    }

    //检测是否要刷新
    public function actionCheckRefresh()
    {
        $mainId = $this->mainId;
        $staffId = $this->shopAdminId;
        $respond = Yii::$app->redis->executeCommand('GET', ['ghs_cashier_' . $mainId . '_' . $staffId . '_may_refresh']);
        if ($respond == 'yes') {
            util::success(['remind' => 1]);
        }
        util::complete();
    }

    //批量恢复花材 ssh 20230206
    public function actionBatchRecover()
    {
        $post = Yii::$app->request->post();
        $string = $post['ids'] ?? '';
        $ids = json_decode($string, true);
        $ids = array_unique(array_filter($ids));
        if (empty($ids)) {
            util::fail('请选择花材');
        }
        $infoList = ItemClass::getAllByCondition(['id' => ['in', $ids]], null, 'id,name,mainId,status,delStatus,removeStatus', null, true);
        if (empty($infoList)) {
            util::fail('请选择花材哦');
        }
        foreach ($infoList as $info) {
            if ($info->mainId != $this->mainId) {
                util::fail('请选择自己的花材');
            }
            $info->removeStatus = 0;
            $info->save();
        }
        util::complete('操作成功');
    }

    //批量删除花材 ssh 202302026
    public function actionBatchRemove()
    {
        $post = Yii::$app->request->post();
        $string = $post['ids'] ?? '';
        $ids = json_decode($string, true);
        $ids = array_unique(array_filter($ids));
        if (empty($ids)) {
            util::fail('请选择花材');
        }
        $infoList = ItemClass::getAllByCondition(['id' => ['in', $ids]], null, 'id,name,mainId,status,delStatus,removeStatus', null, true);
        if (empty($infoList)) {
            util::fail('请选择花材哦');
        }
        foreach ($infoList as $info) {
            if ($info->mainId != $this->mainId) {
                util::fail('请选择自己的花材');
            }
            $name = $info->name ?? '';
            if ($info->delStatus != 1) {
                util::fail($name . ' 停用了才能删除');
            }
            $info->removeStatus = 1;
            $info->save();
        }
        util::complete('操作成功');
    }

    //批量启用花材 ssh 20230206
    public function actionBatchEnable()
    {
        $post = Yii::$app->request->post();
        $string = $post['ids'] ?? '';
        $ids = json_decode($string, true);
        $ids = array_unique(array_filter($ids));
        if (empty($ids)) {
            util::fail('请选择花材');
        }
        $infoList = ItemClass::getAllByCondition(['id' => ['in', $ids]], null, 'id,name,mainId,status,delStatus,removeStatus', null, true);
        if (empty($infoList)) {
            util::fail('请选择花材哦');
        }
        foreach ($infoList as $info) {
            if ($info->mainId != $this->mainId) {
                util::fail('请选择自己的花材');
            }
            $info->delStatus = 0;
            $info->save();
        }
        util::complete('操作成功');
    }

    //批量停用花材 20230206
    public function actionBatchStop()
    {
        $post = Yii::$app->request->post();
        $string = $post['ids'] ?? '';
        $ids = json_decode($string, true);
        $ids = array_unique(array_filter($ids));
        if (empty($ids)) {
            util::fail('请选择花材');
        }
        $infoList = ItemClass::getAllByCondition(['id' => ['in', $ids]], null, 'id,name,mainId,status,delStatus,removeStatus', null, true);
        if (empty($infoList)) {
            util::fail('请选择花材哦');
        }
        foreach ($infoList as $info) {
            if ($info->mainId != $this->mainId) {
                util::fail('请选择自己的花材');
            }
            $name = $info->name ?? '';
            if ($info->status != 2) {
                util::fail($name . ' 下载了才能停用');
            }
            $info->delStatus = 1;
            $info->save();
        }
        util::complete('操作成功');
    }

    //获取给散客下单的花材海报 ssh 20220111
    public function actionGetSkPoster()
    {
        $get = Yii::$app->request->get();
        $id = $get['id'] ?? 0;
        $item = ItemClass::getById($id, true);
        if (empty($item) || $item->mainId != $this->mainId) {
            util::fail('获取失败');
        }
        $cover = $item->cover ?? '';
        if (empty($cover)) {
            util::fail('获取失败');
        }

        $merchant = WxOpenClass::getMallWxInfo();
        $page = 'pages/item/detail';
        $ptStyle = dict::getDict('ptStyle', 'mall');
        $shop = $this->shop;
        $lsShopId = $shop->lsShopId ?? 0;
        //scene不能超过32个字条
        $scene = "id=" . $id . '&a=' . $lsShopId;
        $miniCode = miniUtil::generateUnlimitedMiniCode($merchant, $page, $scene, $ptStyle);
        $miniCode = $miniCode . '?x-oss-process=image/resize,m_fill,h_200,w_200';
        $miniCodeBase64 = stringUtil::ossBase64($miniCode);

        Yii::$app->params['ptStyle'] = dict::getDict('ptStyle', 'hd');

        $prefix = imgUtil::getPrefix();

        $price = $item->skPrice ?? 0;
        if ($item->discountPrice > 0) {
            $skMore = $item->skMore ?? 0;
            $price = bcadd($item->discountPrice, $skMore, 2);
        }
        $newPrice = '¥' . floatval($price);
        $priceBase64 = stringUtil::ossBase64($newPrice);

        $name = $item->name ?? '';
        $nameBase64 = stringUtil::ossBase64($name);

        $staff = $this->shopAdmin;
        $staffName = $staff->name ?? '';
        $newStaffName = $staffName . ' 为您推荐';
        $staffNameBase64 = stringUtil::ossBase64($newStaffName);

        //花材主图
        $itemCover = $cover . '?x-oss-process=image/resize,m_fill,h_750,w_750';
        $itemCoverBase64 = stringUtil::ossBase64($itemCover);

        $logoBase64 = '';
        if (in_array($this->mainId, [52, 1459, 13495])) {
            $logo = 'poster/hyxh_ncd_logo.png?x-oss-process=image/resize,m_fill,h_90,w_90';
            if ($this->mainId == 1459) {
                $logo = 'poster/hyxh_gcd_logo.png?x-oss-process=image/resize,m_fill,h_90,w_90';
            }
            if ($this->mainId == 13495) {
                $logo = 'poster/hyxh_hzd_logo.png?x-oss-process=image/resize,m_fill,h_90,w_90';
            }
            $logoBase64 = stringUtil::ossBase64($logo);
        }

        $url = $prefix . 'poster/1234.jpg?x-oss-process=image';
        //花材主图
        $url .= '/watermark,image_' . $itemCoverBase64 . ',g_nw,x_0,y_0';
        //小程序码
        $url .= '/watermark,image_' . $miniCodeBase64 . ',g_se';
        if (!empty($logoBase64)) {
            //logo
            $url .= '/watermark,image_' . $logoBase64 . ',g_se,x_65,y_65';
        }
        //为你推荐
        $url .= '/watermark,text_' . $staffNameBase64 . ',g_sw,x_18,y_235,color_8B8989,type_d3F5LW1pY3JvaGVp,size_30';
        //标题
        $url .= '/watermark,text_' . $nameBase64 . ',g_sw,x_18,y_145';
        //价格
        $url .= '/watermark,text_' . $priceBase64 . ',g_sw,x_18,y_50,color_EE2C2C,type_d3F5LW1pY3JvaGVp,size_50';

        $respond = ['imgUrl' => $url];
        util::success($respond);
    }

    //获取给花店下单的花材海报 ssh 20220111
    public function actionGetHdPoster()
    {
        $get = Yii::$app->request->get();
        $id = $get['id'] ?? 0;
        $item = ItemClass::getById($id, true);
        if (empty($item) || $item->mainId != $this->mainId) {
            util::fail('获取失败');
        }
        $cover = $item->cover ?? '';
        if (empty($cover)) {
            util::fail('获取失败');
        }
        $merchant = WxOpenClass::getWxInfo();
        $page = 'admin/ghsProduct/detail';
        $ptStyle = dict::getDict('ptStyle', 'hd');

        //小程序码，scene不能超过32个字条
        $scene = "id=" . $id . '&sId=' . $this->shopId;
        $miniCode = miniUtil::generateUnlimitedMiniCode($merchant, $page, $scene, $ptStyle);
        $miniCode = $miniCode . '?x-oss-process=image/resize,m_fill,h_200,w_200';
        $miniCodeBase64 = stringUtil::ossBase64($miniCode);

        Yii::$app->params['ptStyle'] = dict::getDict('ptStyle', 'ghs');

        $prefix = imgUtil::getPrefix();

        $price = $item->price ?? 0;
        if ($item->discountPrice > 0) {
            $price = $item->discountPrice;
        }
        $newPrice = '¥' . floatval($price);
        $priceBase64 = stringUtil::ossBase64($newPrice);

        $name = $item->name ?? '';
        $nameBase64 = stringUtil::ossBase64($name);

        $staff = $this->shopAdmin;
        $staffName = $staff->name ?? '';
        $newStaffName = $staffName . ' 为您推荐';
        $staffNameBase64 = stringUtil::ossBase64($newStaffName);

        //花材主图
        $itemCover = $cover . '?x-oss-process=image/resize,m_fill,h_750,w_750';
        $itemCoverBase64 = stringUtil::ossBase64($itemCover);

        $logoBase64 = '';
        if (in_array($this->mainId, [52, 1459, 13495])) {
            $logo = 'poster/hyxh_ncd_logo.png?x-oss-process=image/resize,m_fill,h_90,w_90';
            if ($this->mainId == 1459) {
                $logo = 'poster/hyxh_gcd_logo.png?x-oss-process=image/resize,m_fill,h_90,w_90';
            }
            if ($this->mainId == 13495) {
                $logo = 'poster/hyxh_hzd_logo.png?x-oss-process=image/resize,m_fill,h_90,w_90';
            }
            $logoBase64 = stringUtil::ossBase64($logo);
        }

        $url = $prefix . 'poster/1234.jpg?x-oss-process=image';
        //花材主图
        $url .= '/watermark,image_' . $itemCoverBase64 . ',g_nw,x_0,y_0';
        //小程序码
        $url .= '/watermark,image_' . $miniCodeBase64 . ',g_se';
        if (!empty($logoBase64)) {
            //logo
            $url .= '/watermark,image_' . $logoBase64 . ',g_se,x_65,y_65';
        }
        //为你推荐
        $url .= '/watermark,text_' . $staffNameBase64 . ',g_sw,x_18,y_235,color_8B8989,type_d3F5LW1pY3JvaGVp,size_30';
        //标题
        $url .= '/watermark,text_' . $nameBase64 . ',g_sw,x_18,y_145';
        //价格
        $url .= '/watermark,text_' . $priceBase64 . ',g_sw,x_18,y_50,color_EE2C2C,type_d3F5LW1pY3JvaGVp,size_50';

        $respond = ['imgUrl' => $url];
        util::success($respond);
    }

    //是否有C级价格大于B级的 ssh 20221204
    public function actionGetErrorPrice()
    {
        $shop = $this->shop;
        $list = ItemClass::errorPrice($shop);
        util::success(['list' => $list]);
    }

    //列出所有花材，包括特价花材列表 ssh 20220315
    public function actionShowList()
    {
        $get = Yii::$app->request->get();
        $customId = $get['customId'] ?? 0;
        $custom = CustomClass::getById($customId, true);
        $where['mainId'] = $this->mainId;
        $where['delStatus'] = 0;
        $where['status'] = 1;
        $list = ItemClass::getShowList($where, $custom);

        $mainId = $this->mainId;
        $get = Yii::$app->request->get();
        $isCashier = $get['isCashier'] ?? 0;
        if ($isCashier == 1) {
            //去掉收银台提示价格更新
            $staffId = $this->shopAdminId;
            Yii::$app->redis->executeCommand('DEL', ['ghs_cashier_' . $mainId . '_' . $staffId . '_may_refresh']);
        }

        util::success(['list' => $list]);
    }

    public function actionAdd()
    {
        util::fail('开发中');
    }

    //批量添加花材
    public function actionBatchAdd()
    {
        $shopAdmin = $this->shopAdmin;
        if (isset($shopAdmin->super) == false || $shopAdmin->super != 1) {
            util::fail('超管才能操作');
        }
        $post = Yii::$app->request->post();
        //[{"itemId":"1175","classId":"3548","price":"5","skPrice":"8","cost":"1","name":"卡娜百合"}]
        $data = $post['data'];
        if (empty($data)) {
            util::fail("请选花材");
        }
        $data = json_decode($data, true);
        if (is_array($data) == false || empty($data)) {
            util::fail("请选花材");
        }
        $shop = $this->shop;
        $shopId = $this->shopId;
        $mainId = $this->mainId;
        $sjId = $this->sjId;
        $adminId = $this->adminId;
        $ids = array_column($data, 'itemId');
        $ids = array_unique(array_filter($ids));
        $has = ProductClass::getByCondition(['mainId' => $mainId, 'itemId' => ['in', $ids]]);
        if (!empty($has)) {
            $hasName = $has->name ?? '';
            util::fail($hasName . " 已经添加过了");
        }
        $ptItemInfo = PtItemClass::getAllByCondition(['id' => ['in', $ids]], null, '*', 'id');
        $connection = Yii::$app->db;
        $transaction = $connection->beginTransaction();
        try {
            foreach ($data as $v) {
                $ptItemId = $v['itemId'] ?? 0;
                $ratio = $ptItemInfo[$ptItemId]['ratio'] ?? 20;
                $shelfLife = $ptItemInfo[$ptItemId]['shelfLife'] ?? 7;
                $ratioType = $ptItemInfo[$ptItemId]['ratioType'] ?? 0;
                $variety = $ptItemInfo[$ptItemId]['variety'] ?? 0;
                $stockWarning = $ptItemInfo[$ptItemId]['stockWarning'] ?? 5;
                $weight = $ptItemInfo[$ptItemId]['weight'] ?? 1;
                $bigUnit = $ptItemInfo[$ptItemId]['bigUnit'] ?? '扎';
                $smallUnit = $ptItemInfo[$ptItemId]['smallUnit'] ?? '支';
                $bigUnitId = $ptItemInfo[$ptItemId]['bigUnitId'] ?? 1;
                $smallUnitId = $ptItemInfo[$ptItemId]['smallUnitId'] ?? 2;
                $cover = $ptItemInfo[$ptItemId]['cover'] ?? 'default-img.png';

                $v['ratio'] = $ratio;
                $v['cover'] = $cover;
                $v['shelfLife'] = $shelfLife;
                $v['ratioType'] = $ratioType;
                $v['variety'] = $variety;
                $v['stockWarning'] = $stockWarning;
                $v['weight'] = $weight;
                $v['bigUnit'] = $bigUnit;
                $v['smallUnit'] = $smallUnit;
                $v['bigUnitId'] = $bigUnitId;
                $v['smallUnitId'] = $smallUnitId;

                $v['adminId'] = $adminId;
                $v['sjId'] = $sjId;
                $v['shopId'] = $shopId;
                $v['mainId'] = $mainId;
                $v['staffName'] = $shopAdmin->name ?? '';

                $name = $v['name'] ?? '';
                $price = is_numeric($v['price']) ? $v['price'] : 0;
                $skPrice = is_numeric($v['skPrice']) ? $v['skPrice'] : 0;
                $cost = is_numeric($v['cost']) ? $v['cost'] : 0;
                if ($price <= 0) {
                    util::fail("请填写{$name}的批发价");
                }
                if ($skPrice <= 0) {
                    util::fail("请填写{$name}的零售价");
                }
                if ($cost <= 0) {
                    util::fail("请填写{$name}的成本价");
                }
                if ($price > $skPrice) {
                    util::fail("{$name}的批发价比零售价还高");
                }
                if ($cost > $price) {
                    util::fail("{$name}的成本价比批发价还高");
                }
                $skMore = bcsub($skPrice, $price, 2);
                $addPrice = bcsub($price, $cost, 2);
                $v['skMore'] = $skMore;
                $v['addPrice'] = $addPrice;
                $v['hjAddPrice'] = $addPrice;
                $v['hjPrice'] = $price;
                ProductClass::addProduct($v, $shop);
            }
            $transaction->commit();
            util::complete('添加成功');
        } catch (Exception $e) {
            $transaction->rollBack();
            util::fail();
        }
    }

    public function actionDelete()
    {
        util::fail('不能删除哦！');
    }

    //获取平台里的花材信息
    public function actionPlatformItem()
    {
        $py = Yii::$app->request->get('py', '');
        $where = [];
        if ($py) {
            $where = ['py' => $py];
        }
        $list = PtItemClass::getItemList($where);
        util::success($list);
    }

    //列出需要进行颜色管理的花材 ssh 20220820
    public function actionColorList()
    {
        $mainId = $this->mainId ?? 0;
        $list = ItemClass::getAllByCondition(['mainId' => $mainId, 'variety' => 1], null, '*');
        util::success(['list' => $list]);
    }

    //多颜色管理启用与停用 ssh 20221229
    public function actionChangeVariety()
    {
        $get = Yii::$app->request->get();
        $id = $get['id'] ?? 0;
        $variety = $get['variety'] ?? 0;
        $info = ItemClass::getById($id, true);
        if (empty($info) || $info->mainId != $this->mainId) {
            util::fail('操作失败');
        }
        $info->variety = $variety;
        $info->save();
        util::complete('操作成功');
    }

    //拆散花材 ssh 20221229
    public function actionBreakItem()
    {
        util::fail('开发中');
        util::complete();
    }

}