minongyun/application/admin/controller/Feeding.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use think\Cache;
use think\Db;
use think\exception\PDOException;
use think\exception\ValidateException;
use think\Session;

/**
 * 生产投料
 *
 * @icon fa fa-circle-o
 */
class Feeding extends Backend
{
    protected $searchFields = 'material,bach';
    /**
     * Feeding模型对象
     * @var \app\admin\model\Feeding
     */
    protected $model = null;

    protected $noNeedRight = ['get_formula','get_task','get_material'];

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\Feeding;

    }



    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */
    /**
     * 添加
     *
     * @return string
     * @throws \think\Exception
     */
    public function add()
    {
        if (false === $this->request->isPost()) {
            //车间=>操作人员
            $cjcz = Db::name('personnel')->where('bid',"=",5)->where('position','=',"cjcz")->order('name desc')->select();
            //车间=>检验人员
            $cjjy = Db::name('personnel')->where('bid',"=",5)->where('position','=',"cjjy")->order('name desc')->select();
            $this->assign('cjcz',$cjcz);
            $this->assign('cjjy',$cjjy);
            //通过账号自动获取 操作人员 检验人员 固定机台名称
            $user_info = Session::get('admin');
            $jinayan = [];
            if($user_info['username'] === '111'){
                $jinayan = '丙类一号机';
            }else if($user_info['username'] === '222'){
                $jinayan = '丙类二号机';
            }else if($user_info['username'] === '333'){
                $jinayan = '甲类一号机';
            }else if($user_info['username'] === '444'){
                $jinayan = '甲类二号机';
            }else{
                $jinayan = '甲类三号机';
            }
            $this->assign('jinayan',$jinayan);

            return $this->view->fetch();
        }
        $tid = Db::name('task')->where('bach',$_POST['bach'])->order('id desc')->find();

//        $year = date('Y'); // 获取当前年份
//
//        $tid = Db::name('task')
//            ->where('bach', $_POST['bach']) // 根据批次过滤
//            ->where('create', 'like', "$year%") // 使用 LIKE 模糊查询，匹配当前年份
//            ->order('id desc') // 按照创建时间降序排序
//            ->find(); // 只取最新的一条记录




        if(empty($_POST['weight'])){
            $this->error('投料数据不能为空');
        }
        $feeding_no = Db::name('feeding')->where('bach',$_POST['bach'])->order('id desc')->find();

        if (isset($feeding_no['no'])) {
            // 确保 $feeding_no 是一个数组且 $feeding_no['no'] 已设置
            $param['no'] = $feeding_no['no'] + 1;
        } else {
            // $feeding_no 不存在，或者 $feeding_no['no'] 未设置
            $param['no'] = 1;
        }
//        $param['no'] = $fno['no'] +1;//操作顺序
        $param['tid'] = $tid['id'];//关联批次idx
        $param['fid'] = $_POST['fid'];//关联批次idx
        $param['bach'] = $_POST['bach'];//批次号
        $param['date'] = $_POST['date'];//日期
        $param['operator'] = $_POST['operator'];//操作人员
        $param['inspector'] = $_POST['inspector'];//检验人员
        $param['material'] = $_POST['material'];//原材料
        $param['nweight'] = $_POST['nweight'];//应投重量
        $param['gy_num'] = $_POST['gy_num'];//工艺序号
        $param['weight'] = $_POST['weight'];//投料重量
        $param['material_bach'] = $_POST['material_bach'];//原材料批次号
        $param['remark'] = $_POST['gy_name'];//操作记录
        $param['create'] = date('Y-m-d H:i:s');//创建时间

        $feeding = Db::name('feeding')->insert($param);
        if($feeding){return "添加成功";}else{return "添加失败";}
//        $params = $this->request->post('row/a');
//        $params = $this->preExcludeFields($params);
//        $tid = Db::name('task')->where('bach',$params['bach'])->order('id desc')->find();
//        $arr = [];
//        if(empty($params['weight'])){
//            $this->error('投料数据不能为空');
//        }
//        foreach($params['weight'] as $k=>$v){
//            if($v){
//                $param['bach'] = $params['bach'];
//                $param['date'] = $params['date'];
//                $param['operator'] = $params['operator'];
//                $param['inspector'] = $params['inspector'];
//                $param['weight'] = $params['weight'][$k];
//                $param['nweight'] = $params['nweight'][$k];
//                $param['material'] = $params['material'][$k];
//                $param['gy_num'] = $params['gy_num'][$k];
//                $param['tid'] = $tid['id'];
//                $param['create'] = date('Y-m-d H:i:s');
//                $arr[] = $param;
//            }
//        }
//        //去掉已经存入数据库的工艺数据
//        $list = array();
//        foreach ($arr as $key=>$value){
//            $map=[];
//            $map['bach'] = $value['bach'];
//            $map['material'] = $value['material'];
//            $map['gy_num'] = $value['gy_num'];
//            $is_feeding_gy = Db::name('feeding')->where($map)->order('id desc')->find();
//            if (!$is_feeding_gy){
//                $list[$key] = $value;
//            }
//        }
//        $result = false;
//        Db::startTrans();
//        try {
//            //是否采用模型验证
//            if ($this->modelValidate) {
//                $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
//                $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.add' : $name) : $this->modelValidate;
//                $this->model->validateFailException()->validate($validate);
//            }
//
//            $result = $this->model->allowField(true)->saveAll($list);
//            Db::commit();
//        } catch (ValidateException|PDOException|Exception $e) {
//            Db::rollback();
//            $this->error($e->getMessage());
//        }
//        if ($result === false) {
//            $this->error(__('No rows were inserted'));
//        }
//        $this->success();
    }

    //投料添加页面=>修改应投重量
//    public function submits(){
//        $param = $this->request->post();
//        $where = [];
//        $where['bach'] = $param['bach'];
//        $id = Db::name('feeding')->where($where)->select();
//        echo "<pre>";
//        print_r($id);
//        echo "</pre>";die;
//        $arr['weight'] = $param['weight'];
//        $feeding = Db::name('feeding')->where('id',$id['id'])->select();
//        echo "<pre>";
//        print_r($feeding);
//        echo "</pre>";die;
//        if(!$feeding){
//            return '修改失败';
//        }else{
//            return '修改成功';
//        }
//    }
    public function edit($ids = null){
        $row = $this->model->get($ids);
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        $adminIds = $this->getDataLimitAdminIds();
        if (is_array($adminIds) && !in_array($row[$this->dataLimitField], $adminIds)) {
            $this->error(__('You have no permission'));
        }
        if (false === $this->request->isPost()) {
            $row = Db::name('feeding')->where('id',$ids)->find();
            $this->assign('row',$row);
            return $this->view->fetch();
        }
        $params = $this->request->post('row/a');
//        echo "<pre>";
//        print_r($params);
//        echo "</pre>";
//        die;
        if (empty($params)) {
            $this->error(__('Parameter %s can not be empty', ''));
        }
        $params = $this->preExcludeFields($params);
        $result = false;
        Db::startTrans();
        try {
            //第三步
            $result = Db::name('feeding')->where('id',$ids)->update($params);
            Db::commit();
        } catch (ValidateException|PDOException|Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
        if (false === $result) {
            $this->error(__('No rows were updated'));
        }
        $this->success();
    }

    //获取作业票信息
    public function get_task(){
        $bach = $this->request->post('bach');
        $year = date('Y'); // 获取当前年份
        $row = Db::name('feeding')->where('bach',$bach)->select();

//        $res = Db::name('task')->where('bach',$bach)->order('create','desc')->select();

        $year = date('Y'); // 获取当前年份
        $res = Db::name('task')
            ->where('bach', $bach) // 批次号
            // 使用 LIKE 模糊查询，匹配当前年份
            ->where('create', 'like', "$year%")
            ->order('create desc')
            ->select();


        //已有过工序
        if($row){
            $result['inspector'] = $row[0]['inspector'];
            $result['operator'] = $row[0]['operator'];
        }else{
            $result['inspector'] = '';
            $result['operator'] = '';
        }
        $result['data'] = $res;

        return json($result);
    }

    //获取配方信息 原始代码
    public function get_formulas(){
        $bach = $this->request->post('bach');//批次号
        $num = $this->request->post('num');//生产量
        $process = Db::name('feeding')->where('bach',$bach)->select();

        if($num){//如果有,批次号重复,需精确查找
            $res = Db::name('task')->alias('t')
                ->join('formula_detail f','f.pid=t.fid','left')
                ->field('f.id as fid,f.material,f.percentage,f.gy_name,f.gy_num,t.number,t.id,t.kuodan')
                ->where('t.bach',$bach)->where('t.number',$num)->select();
        }else{//如果没有,,批次号未重复,直接差出数据
            $res = Db::name('task')->alias('t')
                ->join('formula_detail f','t.fid = f.pid','left')
                ->field('f.id as fid,f.material,f.percentage,f.gy_name,f.gy_num,t.number,t.id,t.kuodan')
                ->where('t.bach',$bach)->select();
        }

        $pro = 0;
        //按照百分比计算出应投重量
        foreach($res as &$v){
            $v['weight']=0;
            $v['material_bach'] = '';
            if($process){ //已有工序,接上一次工序
                foreach ($process as $val){
                    if($val['fid']==$v['fid'] && $val['tid']==$v['id'] && $val['gy_num'] == $v['gy_num']){
                        $v['weight']=$val['weight'];
                        $v['material'] = $val['material'];
                        $v['material_bach']=$val['material_bach'];
                        $pro = $val['gy_num'];
                    }
                }
            }
            if($v['gy_name'] == null){
                $v['gy_name'] = '';
            }
            if($v['gy_num'] == null){
                $v['gy_num'] = '';
            }
            if($v['material'] == null){
                $v['material'] = '';
            }
            if($v['material_bach'] == null){
                $v['material_bach'] = '';
            }
            $total = array_column($res,'percentage');
            foreach ($total as $key=>$value){
                $total[$key] = decode($value);
            }
            $num = array_sum($total);
            if($v['kuodan']){
                $kd_sum = $v['number']+$v['kuodan'];
                if($v['percentage']){
                    $number = ceil(decode($v['percentage']) / $num * $kd_sum *1000);
                    $v['nweight'] = number_format($number/1000,3);
                }else{
                    $v['nweight']='';
                }
            }else{
                if($v['percentage']){
                    $number = ceil(decode($v['percentage']) / $num * $v['number'] *1000);
                    $v['nweight'] = number_format($number/1000,3);
                }else{
                    $v['nweight']='';
                }
            }
        }
        $row['total']=$num;
        $row['data'] = $res;
        $row['process'] = $pro+1;
        return json($row);
    }

    //获取配方信息
    public function get_formula(){
        //按照工序显示，第一个工序做完，才能显示下一个工序
        $bach = $this->request->post('bach');//批次号
        $num = $this->request->post('num');//生产量
        $year = date('Y'); // 获取当前年份
        $process = Db::name('feeding')->where('bach',$bach)->where('create', 'like', "$year%")->select();
        if($num){//如果有,批次号重复,需精确查找
            $res = Db::name('task')->alias('t')
                ->join('formula_detail f','f.pid=t.fid','left')
                ->field('f.id as fid, f.material,f.percentage,f.gy_name,f.gy_num,t.number,t.id,t.kuodan')
                ->where('t.bach',$bach)
                ->where('t.create', 'like', "$year%")
                ->where('t.bach',$bach)->where('t.number',$num)->select();
        }else{//如果没有,,批次号未重复,直接差出数据
            $res = Db::name('task')->alias('t')
                ->join('formula_detail f','t.fid = f.pid','left')
                ->field('f.id as fid, f.material,f.percentage,f.gy_name,f.gy_num,t.number,t.id,t.kuodan')
                ->where('t.bach',$bach)
                ->where('t.create', 'like', "$year%")
                ->where('t.bach',$bach)->select();
        }

        $pro = 0;
        //按照百分比计算出应投重量
        foreach($res as &$v){
            $v['weight']=0;
            $v['material_bach'] = '';
            if($process){ //已有工序,接上一次工序
                foreach ($process as $val){
                    if( $val['fid'] == $v['fid'] && $val['tid'] == $v['id'] && $val['gy_num'] == $v['gy_num']){
                        $v['weight']=  $val['weight'];
//                        $v['material'] = $val['material'];
                        $v['material_bach']=$val['material_bach'];
                        $pro = $val['gy_num'];
                    }
                }
            }
            if($v['gy_name'] == null){
                $v['gy_name'] = '';
            }
            if($v['gy_num'] == null){
                $v['gy_num'] = '';
            }
            if($v['material'] == null){
                $v['material'] = '';
            }
            if($v['material_bach'] == null){
                $v['material_bach'] = '';
            }
            $total = array_column($res,'percentage');
            foreach ($total as $key=>$value){
                $total[$key] = decode($value);
            }
            $num = array_sum($total);
            if($v['kuodan']){
                $kd_sum = $v['number']+$v['kuodan'];
                if($v['percentage']){
                    $number = ceil(decode($v['percentage']) / $num * $kd_sum *1000);
                    $v['nweight'] = number_format($number/1000,3);
                }else{
                    $v['nweight']='';
                }
            }else{
                if($v['percentage']){
                    $number = ceil(decode($v['percentage']) / $num * $v['number'] *1000);
                    $v['nweight'] = number_format($number/1000,3);
                }else{
                    $v['nweight']='';
                }
            }
        }

        // 计算每个 gy_num 的 material 数量
        $gy_num_counts = [];
        $originalRes = $res;
        foreach ($res as $item) {
            if (!empty(trim($item['material'])) && (strpos($item['material'], '*') === false)) {
                $gy_num = $item['gy_num'];
                if (!isset($gy_num_counts[$gy_num])) {
                    $gy_num_counts[$gy_num] = 0;
                }
                $gy_num_counts[$gy_num]++;
            }
        }
        if (empty($process)) {
            // 如果 feeding 表为空，则显示当前工序 gy_num = 1
            $current_gy_num = 1;
        } else {
            // 初始化一个数组来存储各个工序的完成情况
            $gy_num_status = [];
            // 遍历已经做的数据
            foreach ($process as $item) {
                $gy_num = $item['gy_num'];
                if (!isset($gy_num_status[$gy_num])) {
                    $gy_num_status[$gy_num] = 0;
                }
                $gy_num_status[$gy_num]++;
            }

            // 遍历原始数据，检查每个工序是否完成
            $current_gy_num = 1;
            $all_completed = true;

            foreach ($gy_num_counts as $gy_num => $count) {

                if (isset($gy_num_status[$gy_num]) && $gy_num_status[$gy_num] === $count) {
                    $current_gy_num++;
                } else {
                    break;
                }
            }
            // 如果所有工序都完成，则显示下一工序
//            if ($all_completed) {
//
//            }
        }
        // 筛选出当前工序的 $res 数据
        $filtered_res = array_filter($res, function ($item) use ($current_gy_num) {
            return $item['gy_num'] == $current_gy_num;
        });
        $filtered_res = array_values($filtered_res); // 重置数组索引

//        echo "当前工序: " . $current_gy_num;
//        echo "<pre>";print_r($filtered_res);echo "</pre>";

        if (!empty($filtered_res)) {
            $row['total']=$num;
            $row['data'] = $filtered_res;
            $row['process'] = $pro+1;
            return json($row);
        } else {
            $bach = $this->request->post('bach');//批次号
            $num = $this->request->post('num');//生产量
            $process = Db::name('feeding')->where('bach',$bach)->select();
            if($num){//如果有,批次号重复,需精确查找
                $res = Db::name('task')->alias('t')
                    ->join('formula_detail f','f.pid=t.fid','left')
                    ->field('f.material,f.percentage,f.gy_name,f.gy_num,t.number,t.id,t.kuodan')
                    ->where('t.create', 'like', "$year%")
                    ->where('t.bach',$bach)->where('t.number',$num)->select();
            }else{//如果没有,,批次号未重复,直接差出数据
                $res = Db::name('task')->alias('t')
                    ->join('formula_detail f','t.fid = f.pid','left')
                    ->where('t.create', 'like', "$year%")
                    ->field('f.material,f.percentage,f.gy_name,f.gy_num,t.number,t.id,t.kuodan')
                    ->where('t.bach',$bach)->select();
            }
            $pro = 0;
            //按照百分比计算出应投重量
            foreach($res as &$v){
                $v['weight']=0;
                $v['material_bach'] = '';
                if($process){ //已有工序,接上一次工序
                    foreach ($process as $val){
                        if(($val['material']==$v['material'] || in_array($val['material'],explode('/',$v['material']))) && $val['tid']==$v['id'] && $val['gy_num'] == $v['gy_num']){
                            $v['weight']=$val['weight'];
                            $v['material_bach']=$val['material_bach'];
                            $pro = $val['gy_num'];
                        }
                    }
                }
                if($v['gy_name'] == null){
                    $v['gy_name'] = '';
                }
                if($v['gy_num'] == null){
                    $v['gy_num'] = '';
                }
                if($v['material'] == null){
                    $v['material'] = '';
                }
                if($v['material_bach'] == null){
                    $v['material_bach'] = '';
                }
                $total = array_column($res,'percentage');
                foreach ($total as $key=>$value){
                    $total[$key] = decode($value);
                }
                $num = array_sum($total);
                if($v['kuodan']){
                    $kd_sum = $v['number']+$v['kuodan'];
                    if($v['percentage']){
                        $number = ceil(decode($v['percentage']) / $num * $kd_sum *1000);
                        $v['nweight'] = number_format($number/1000,3);
                    }else{
                        $v['nweight']='';
                    }
                }else{
                    if($v['percentage']){
                        $number = ceil(decode($v['percentage']) / $num * $v['number'] *1000);
                        $v['nweight'] = number_format($number/1000,3);
                    }else{
                        $v['nweight']='';
                    }
                }
            }
            $row['total']=$num;
            $row['data'] = $res;
            $row['process'] = $pro+1;
            return json($row);
        }



    }

    public function get_material(){
        $bach = $this->request->post('bach');//批次号
        $material = $this->request->post('material');//原材料
        if (!$bach || !$material){
            $this->error('扫码数据不能为空');
        }
        $task = Db::name('task')->where('bach',$bach)->find();
        $map = [];
        $map['f_name'] = $task['name'];
        $map['name'] = $material;
        $data = Db::name('formula_material')->where($map)->select();

        $result['data'] = '';
        if ($data){
            $result['data'] = $data;
            if (count($data)>1){
                $str = [];
                foreach ($data as $key=>$value){
                    $str[$key] = $value['m_name'];
                }
                $result['string'] = implode('或 ',$str);
            }else{
                $result['string'] = $data[0]['m_name'];
            }
            $result['total'] = count($data);
        }else{
            $result['total'] = 0;
        }
        return json($result);
    }

    //查找替代料
    /*public function replace(){
        $bach = $this->request->post('bach');
        $wuliao = $this->request->post('wuliao');
        $res = Db::name('task')->alias('t')
            ->join('formula f','f.id = t.fid','left')
            ->join('formula_detail fd','fd.pid = f.id','left')
            ->join('formula_replace fr','fr.fid = fd.id','left')
            ->where('t.bach',$bach)->where('is_replace=1')->where('fr.material',$wuliao)
            ->field('fd.material,fd.id')->find();
        $res['yuan'] = explode('/',$res['material']);
        $key = array_search($wuliao, $res['yuan']);
        if ($key !== false) array_splice($res['yuan'], $key, 1);
        return json($res);
    }*/

    public function cheng(){
        $user_info = Session::get('');
        return json($user_info);
    }


    //获取机台
//    public function matchCode() {
//        $code = $this->request->post('code');
//        preg_match('/^(M-\d{2,3})/', $code, $matches);
//        $res = Db::name('formula_detail')->where('material', 'like', $matches[0].'%')->select();
//        halt($res);
//        return json(Db::name('formula_detail')->where('material', 'like', $matches[0].'%')->select());
//    }


    public function matchCode() {
        $code = $this->request->post('code');
        preg_match('/^(M-\d{2,3})/', $code, $matches);
        $res = Db::name('formula_detail')->field('distinct material')->where('material', 'like', $matches[0].'%')->select();
        // 初始化结果数组
        $formattedMaterials = [];

        // 遍历查询结果
        foreach ($res as $item) {
            $material = $item['material'];
            // 去除括号和括号内内容
            $material = preg_replace('/\s*$.*?$\s*/', '', $material);

            // 分割材料字符串
            $parts = explode('/', $material);
            foreach ($parts as $part) {
                // 清除空格
                $part = trim($part);
                if (preg_match('/^(M-\d{2,3})$/', $part)) {
                    // 纯基本代码，无需添加
                    $formattedMaterials[] = $part;
                } elseif (preg_match('/^(M-\d{2,3})([A-Z]+)$/', $part, $partMatches)) {
                    // 代码与后缀的组合
                    $formattedMaterials[] = $part;
                } elseif (preg_match('/^[A-Z]+$/i', $part)) {
                    // 只有后缀，需要与基本代码拼接
                    $suffixes = str_split($part);
                    foreach ($suffixes as $suffix) {
                        $formattedMaterials[] = $matches[0] . $suffix;
                    }
                }
            }
        }

        // 去除重复项并重新排序
        $formattedMaterials = array_unique($formattedMaterials);

        if (array_search($code, $formattedMaterials) === false) {
            // todo.. 写入一个临时物料数据  materials name
            array_push($formattedMaterials, $code);
        }
        sort($formattedMaterials);

        // 返回JSON格式的数据
        return json($formattedMaterials);
    }



}