qc.ifish7.com/Application/Admin/Controller/MyImportController.class.php

<?php
namespace Admin\Controller;
use Think\Controller;
class MyImportController extends AdminController{
    public function __construct(){
       parent::__construct();
       $this->table=D("task_sub_record");
    }

    public function index(){
        //搜索
        $where=array();
        //产品名称
        $task_start = I('task_start');
        $task_end = I('task_end');
        if($task_start){
            $task_start = strtotime($task_start) ;
        }
        else{
            $task_start = 0;
        }
        if($task_end){
            $task_end = strtotime($task_end) + 86400;
        }
        else{
            $task_end = time();
        }

        $where['subtask_time_add'] = array('between',array($task_start,$task_end));

       $data  = D('task_sub')->where($where)->relation(true)->select();

       foreach ($data as $k=>$v){
           foreach ($v as $k1=>$v1){
               if(!$v[$k1]){
                   $data[$k][$k1] = 0;
               }
           }
           $data[$k]['time'] = date('Y-m-d', $v['subtask_time_add']);
           $data[$k]['time'] = date('Y-m-d', $v['subtask_time_add']);
           $data[$k]['task_pici'] = $v['task_flow']['task_pici'];
           $data[$k]['task_name'] = $v['task_flow']['task_name'];
           $data[$k]['product_name'] = $v['task_flow']['product_name'];
           $data[$k]['task_beizhu'] = D('task')->find($v['task_id'])['task_beizhu'];
           $data[$k]['procuct_type'] = D('product')->find($v['task_flow']['product_id'])['procuct_type'];

       }

       $res = array();

        foreach ($data as $k=>$v) {
            if($v['qc_name']){
                $res[] = $v;
            }
        }


//       var_dump($data); exit;

        $this->data=json_encode($res);

        $this->display();
    }

    public function index1(){
        $res = '';
        $data = array();
        $title = array();
        $where=array();
        //产品名称
        $task_start = I('task_start');
        $task_end = I('task_end');
        if($task_start){
            $task_start = strtotime($task_start) ;
        }
        else{
            $task_start = 0;
        }
        if($task_end){
            $task_end = strtotime($task_end) + 86400;
        }
        else{
            $task_end = time();
        }
        $where['task_time_add'] = array('between',array($task_start,$task_end));
        $product_name = I('product_name');
        if($product_name){
            $product_data = D('product')->where(array('product_name'=>$product_name))->find();
            if($product_data){
                $res = $product_data['product_name'];
                $where['product_id'] = $product_data['product_id'];
                $data = D('task')->where($where)->select();
                $title[] = ['field'=>'name', 'title'=> '任务号'];
                $title[] = ['field'=>'sub_name', 'title'=> '子任务号'];
                $title[] = ['field'=>'time', 'title'=> '下单日期'];
                $title[] = ['field'=>'product_name', 'title'=> '型号'];
                $title[] = ['field'=>'task_pici', 'title'=> '批号'];
                $title[] = ['field'=>'task_product_num', 'title'=> '毛坯投料'];
                foreach ($data as $k=>$v){
                    $title_data = D('task_flow')->where(array('task_id'=>$v['task_id']))->order('task_flow_id')->select();
                    $data[$k]['sub_name'] = '';
                    $data[$k]['name'] = $v['task_name'];
                    if($v['is_sub']==1){
                        $data[$k]['sub_name'] = $v['task_name'];
                        $data[$k]['name'] = D('task')->find($v['task_id_pro'])['task_name'];
                    }
                    foreach ($title_data as $k1=>$v1){
                        if($k1==0){
                            $data[$k][$v1['craft_name'].'(收)'] = $v['task_product_num'];
                        }
                        else{
                            $data[$k][$v1['craft_name'].'(收)'] =  $data[$k1-1]['pass_num'];
                        }
                        if($k1!=sizeof($title_data)-1){
                            $data[$k][$v1['craft_name'].'(发)'] = $v1['pass_num'];
                        }
                        else{
                            $data[$k][$v1['craft_name'].'(发)'] = 0;
                        }
                        $data[$k][$v1['craft_name'].'(余)'] =  $data[$k][$v1['craft_name'].'(发)'] - $data[$k][$v1['craft_name'].'(收)'];

                    }
                    $data[$k]['time'] = date('Y-m-d', $v['task_time_add']);
                    $data[$k]['product_name'] = $res;

                    if($k == 0){
                        foreach ($title_data as $k1=>$v1){
//                            $title[] = ['field'=>$v1['craft_name'].'(收)', 'title'=> $v1['craft_name'].'(收)'];
//                            $title[] = ['field'=>$v1['craft_name'].'(发)', 'title'=> $v1['craft_name'].'(发)'];
                            $title[] = ['field'=>$v1['craft_name'].'(余)', 'title'=> $v1['craft_name'].'(余)'];
                        }
                    }


                }
                $arr_set = array();
                foreach ($data as $k=>$v){
                    $is_show = D('task_sub')->where(array('task_id'=>$v['task_id'],'subtask_tonext_num'=>array('gt',0)))->find();
                    if($is_show){
                       $arr_set[] = $k;
                    }
                }
                $data1 = array();
                foreach ($arr_set as $k=>$v){
                    $data1[] = $data[$v];
                }
                $title[] = ['field'=>'task_pass_num', 'title'=> '成品'];
            }
        }
        $this->data = json_encode($data1);
        $this->title = json_encode($title);
        $this->res = $res;
        $this->display();
    }


}