huahuibao/biz-ghs/stat/classes/StatCgClass.php

<?php

namespace bizGhs\stat\classes;

use bizGhs\order\classes\PurchaseOrderClass;
use bizGhs\order\classes\PurchaseOrderItemClass;
use bizGhs\product\classes\ProductClass;
use common\components\arrayUtil;
use common\components\dateUtil;
use common\components\util;
use Yii;
use bizGhs\base\classes\BaseClass;

class StatCgClass extends BaseClass
{

    public static function statCg($mainId)
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $mainId;
        $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'];
        $where['time'] = ['between', [$start, $end]];

        $currentStartDate = date('Y-m-d', strtotime($start));
        $currentEndDate = date('Y-m-d', strtotime($end));
        $currentStartTime = $currentStartDate . ' 00:00:00';
        $currentEndTime = $currentEndDate . ' 23:59:59';

        $sort = $get['sort'] ?? 'num';
        $rank = 'num';
        if ($sort == 'amount') {
            $rank = 'amount';
        }

        $productInfo = ProductClass::getAllByCondition(['mainId' => $mainId], null, 'id,name,py', 'id');

        $cgWhere = ['mainId' => $mainId, 'status' => 4];
        $cgWhere['entryTime'] = ['between', [$currentStartTime, $currentEndTime]];
        $cgList = PurchaseOrderClass::getAllByCondition($cgWhere, null, '*');
        $arr = [];
        $cgData = [];
        if (!empty($cgList)) {
            foreach ($cgList as $cgKey => $cgInfo) {
                $orderSn = $cgInfo['orderSn'] ?? '';
                $cgStaffId = $cgInfo['cgStaffId'] ?? 0;
                $cgStaffName = $cgInfo['cgStaffName'] ?? '';
                $itemList = PurchaseOrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*', null, true);
                if (!empty($itemList)) {
                    foreach ($itemList as $key => $val) {
                        $productId = $val->productId ?? 0;
                        $num = $val->itemNum ?? 0;
                        $refundNum = $val->refundNum ?? 0;
                        $remainNum = bcsub($num, $refundNum);
                        $unitPrice = $val->bigPrice ?? 0;
                        $name = $productInfo[$productId]['name'] ?? '';
                        $py = $productInfo[$productId]['py'] ?? '';
                        $totalPrice = bcmul($remainNum, $unitPrice, 2);
                        if (isset($arr[$productId])) {
                            $arr[$productId]['num'] = bcadd($arr[$productId]['num'], $remainNum);
                            $arr[$productId]['amount'] = bcadd($arr[$productId]['amount'], $totalPrice, 2);
                        } else {
                            $arr[$productId]['num'] = $remainNum;
                            $arr[$productId]['amount'] = $totalPrice;
                            $arr[$productId]['py'] = $py;
                            $arr[$productId]['name'] = $name;
                        }
                        if (isset($cgData[$cgStaffId])) {
                            $cgData[$cgStaffId]['amount'] = bcadd($cgData[$cgStaffId]['amount'], $totalPrice, 2);
                            $cgData[$cgStaffId]['itemNum'] = bcadd($cgData[$cgStaffId]['itemNum'], $remainNum);
                        } else {
                            $cgData[$cgStaffId]['cgStaffId'] = $cgStaffId;
                            $cgData[$cgStaffId]['cgStaffName'] = $cgStaffName;
                            $cgData[$cgStaffId]['amount'] = $totalPrice;
                            $cgData[$cgStaffId]['num'] = 0;
                            $cgData[$cgStaffId]['itemNum'] = $remainNum;
                        }
                    }
                    if (isset($cgData[$cgStaffId])) {
                        $cgData[$cgStaffId]['num'] = bcadd($cgData[$cgStaffId]['num'], 1);
                    } else {
                        $cgData[$cgStaffId]['num'] = 1;
                    }
                }
            }
        }
        if (!empty($arr)) {
            $arr = array_values($arr);
            $arr = arrayUtil::arraySort($arr, $rank);
        }
        if (!empty($cgData)) {
            $cgData = array_values($cgData);
        }

        $export = $get['export']??0;
        if($export == 1){
            self::exportCgItem($arr,$mainId);
        }

        return ['itemList' => $arr, 'staffCg' => $cgData];
    }

    public static function exportCgItem($list, $mainId)
    {
        $phpExcelFile = Yii::getAlias("@vendor/phpoffice/phpexcel/");
        require_once($phpExcelFile . 'Classes/PHPExcel.php');

        $objPHPExcel = new \PHPExcel();

        $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
            ->setLastModifiedBy("Maarten Balliauw")
            ->setTitle("Office 2007 XLSX Document")
            ->setSubject("Office 2007 XLSX Document")
            ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
            ->setKeywords("office 2007 openxml php")
            ->setCategory("file");

        $ghsTitle = '供货商';
        $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(date('n月j日') . " " . $ghsTitle);

        $objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.7);
        $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.1);
        $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.5);
        $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0);
        $objPHPExcel->getActiveSheet()->getPageMargins()->setHeader(0.1);
        $objPHPExcel->getActiveSheet()->getPageMargins()->setFooter(0);

        $objPHPExcel->getActiveSheet()->setCellValue('A1', '名称');
        $objPHPExcel->getActiveSheet()->setCellValue('B1', '数量');
        $objPHPExcel->getActiveSheet()->setCellValue('C1', '金额');

        //设置宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
        //加粗
        $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(9)->setBold(true);
        $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(9)->setBold(true);
        $objPHPExcel->getActiveSheet()->getStyle('C1')->getFont()->setSize(9)->setBold(true);

        $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
        $objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
        $objPHPExcel->getActiveSheet()->getStyle('C1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);

        $baseRow = 2;
        foreach ($list as $key => $custom) {
            $i = $baseRow + $key;
            $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $custom['name']);
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $custom['num']);
            $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $custom['amount']);
            //居左
            $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
            $objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
            $objPHPExcel->getActiveSheet()->getStyle('C' . $i)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
        }
        $fileName = '采购花材-' . date("m-d");
        $objPHPExcel->getActiveSheet()->setTitle($fileName);
        $objPHPExcel->setActiveSheetIndex(0);
        $dir = './priceTable/' . $mainId;
        if (file_exists($dir) == false) {
            mkdir($dir, 0777, true);
        }
        $date = $fileName;
        $file = $date . '.xls';
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        if (file_exists($dir . '/' . $file)) {
            unlink($dir . '/' . $file);
        }
        $objWriter->save($dir . '/' . $file);
        $fileUrl = Yii::$app->params['ghsHost'] . '/priceTable/' . $mainId . '/' . $file;
        util::success(['file' => $fileUrl, 'shortFile' => $file]);
    }

    //采购人业绩 ssh 20240412
    public static function statCgYj($mainId)
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $mainId;
        $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'];
        $where['time'] = ['between', [$start, $end]];

        $currentStartDate = date('Y-m-d', strtotime($start));
        $currentEndDate = date('Y-m-d', strtotime($end));
        $currentStartTime = $currentStartDate . ' 00:00:00';
        $currentEndTime = $currentEndDate . ' 23:59:59';

        $cgWhere = ['mainId' => $mainId, 'status' => 4];
        $cgWhere['entryTime'] = ['between', [$currentStartTime, $currentEndTime]];
        $cgList = PurchaseOrderClass::getAllByCondition($cgWhere, null, '*');

        $cgData = [];
        if (!empty($cgList)) {
            foreach ($cgList as $cgKey => $cgInfo) {
                $cgStaffId = $cgInfo['cgStaffId'] ?? 0;
                $cgStaffName = $cgInfo['cgStaffName'] ?? '';
                $actPrice = $cgInfo['actPrice'] ?? 0;
                if (isset($cgData[$cgStaffId])) {
                    $cgData[$cgStaffId]['amount'] = bcadd($cgData[$cgStaffId]['amount'], $actPrice, 2);
                    $cgData[$cgStaffId]['num'] = bcadd($cgData[$cgStaffId]['num'], 1);
                } else {
                    $cgData[$cgStaffId]['cgStaffId'] = $cgStaffId;
                    $cgData[$cgStaffId]['cgStaffName'] = $cgStaffName;
                    $cgData[$cgStaffId]['amount'] = $actPrice;
                    $cgData[$cgStaffId]['num'] = 1;
                }
            }
        }

        if (!empty($cgData)) {
            $cgData = array_values($cgData);
        }
        return ['staffCg' => $cgData];
    }

}