示例#1
0
 /**
  * list order
  * @return string
  */
 public function actionIndex()
 {
     $all = new utilities();
     $branch = $all->getAllBranch();
     $data['all_ss'] = $branch['all_ss'];
     $obj = new Sdptd03denpyo();
     $obj_job = new Sdptm01sagyo();
     $filters = Yii::$app->request->get();
     $query_string = empty($filters) ? '' : '?' . http_build_query($filters);
     Yii::$app->session->set('url_list_workslip', BaseUrl::base() . '/list-workslip' . $query_string);
     if (empty($filters)) {
         $filters['start_time'] = date('Ymd');
         $filters['end_time'] = date('Ymd');
     }
     $data['filters'] = $filters;
     /*
      * Get login info
      * */
     $login_info = Yii::$app->session->get('login_info');
     if (isset($login_info['M50_SS_CD']) && $login_info['M50_SS_CD'] != '') {
         $data['filters']['m50_ss_cd'] = $login_info['M50_SS_CD'];
     }
     $count = $obj->countDataSearch($data['filters']);
     $data['pagination'] = new Pagination(['totalCount' => $count, 'defaultPageSize' => Yii::$app->params['defaultPageSize']]);
     $data['page'] = $filters = Yii::$app->request->get('page');
     $data['filters']['limit'] = $data['pagination']->limit;
     $data['filters']['offset'] = $data['pagination']->offset;
     $data['list'] = $obj->getDataSearch($data['filters']);
     if (empty($data['list'])) {
         Yii::$app->session->setFlash('empty', '入力条件に該当する作業伝票が存在しません');
     }
     $data['job'] = [];
     $all_job = $obj_job->getData();
     foreach ($all_job as $k => $v) {
         $data['job'][''] = '';
         $data['job'][$v['M01_SAGYO_NO']] = $v['M01_SAGYO_NAMEN'];
     }
     $data['status'] = Yii::$app->params['status'];
     Yii::$app->params['titlePage'] = '作業伝票一覧';
     Yii::$app->view->title = '情報検索';
     return $this->render('index', $data);
 }
示例#2
0
 /**
  * get list array file
  * @return string
  * @author: Dang Bui
  */
 public function getListFile($start_date = '', $end_date = '', $url_source = '')
 {
     if (!isset($start_date) || !isset($end_date)) {
         return false;
     }
     //Check folder exits
     if (!is_dir($url_source)) {
         return false;
     }
     $list_files = scandir($url_source);
     $list_files = array_diff($list_files, ['.', '..']);
     //Check file exits in folder
     if (empty($list_files)) {
         return false;
     }
     $arr_id = [];
     foreach ($list_files as $k => $v) {
         $filename = explode('.', $v);
         $extension = $filename[1];
         $create_time_file = date("Ymd", filectime($url_source . $v));
         if ($this->equal3Time($create_time_file, $start_date, $end_date)) {
             $arr_id[] = $filename[0];
         }
     }
     $file = [];
     $sdpt03denpyo = new Sdptd03denpyo();
     foreach ($arr_id as $k => $v) {
         $listDenpyoNo = $sdpt03denpyo->getData(['D03_STATUS' => 1, 'D03_DEN_NO' => $v], 'D03_DEN_NO');
         if (!empty($listDenpyoNo)) {
             $file[] = $url_source . $listDenpyoNo[0]['D03_DEN_NO'] . '.' . $extension;
         }
     }
     return $file;
 }
示例#3
0
 public function actionPreview()
 {
     $branch = utilities::getAllBranch();
     $ss = $branch['all_ss'];
     $address = $branch['ss_address'];
     $tel = $branch['ss_tel'];
     $api = new api();
     $data = [];
     $filter['detail_no'] = Yii::$app->request->get('den_no');
     $cus = new Sdptd01customer();
     $obj = new Sdptd03denpyo();
     $obj_job = new Sdptm01sagyo();
     $car = new Sdptd02car();
     $job[''] = '';
     $all_job = $obj_job->getData();
     foreach ($all_job as $k => $v) {
         $job[$v['M01_SAGYO_NO']] = $v['M01_SAGYO_NAMEN'];
     }
     $detail = $obj->getDataSearch($filter);
     if (empty($detail)) {
         $this->redirect(BaseUrl::base(true) . '/list-workslip');
     }
     $data['detail'] = $detail[0];
     $data['detail']['D02_SYAKEN_CYCLE'] = $this->getCar(['D02_CUST_NO' => $data['detail']['D03_CUST_NO'], 'D02_CAR_NO' => $data['detail']['D03_CAR_NO']]);
     //getCustomer_API
     $cus_info = $cus->findOne($data['detail']['D03_CUST_NO']);
     $data['detail']['D01_UKE_TAN_NAMEN'] = $cus_info['D01_UKE_TAN_NAMEN'];
     if (isset($cus_info['D01_KAIIN_CD'])) {
         $info = $api->getMemberInfo($cus_info['D01_KAIIN_CD']);
         $data['detail']['D01_CUST_NAMEN'] = $info['member_kaiinName'];
         $data['detail']['D01_CUST_NAMEK'] = $info['member_kaiinKana'];
     }
     //getCar_API
     if ($cus_info['D01_KAIIN_CD'] != '') {
         $car_api = $api->getInfoListCar($cus_info['D01_KAIIN_CD']);
         foreach ($car_api['car_carSeq'] as $k => $v) {
             if ($v == $data['detail']['D03_CAR_SEQ']) {
                 $data['detail']['D02_SYAKEN_CYCLE'] = $car_api['car_syakenCycle'][$k];
             }
         }
     }
     $data['ss'] = isset($ss[$data['detail']['D03_SS_CD']]) ? $ss[$data['detail']['D03_SS_CD']] : '';
     $data['address'] = isset($address[$data['detail']['D03_SS_CD']]) ? $address[$data['detail']['D03_SS_CD']] : '';
     $data['tel'] = isset($tel[$data['detail']['D03_SS_CD']]) ? $tel[$data['detail']['D03_SS_CD']] : '';
     $data['detail']['sagyo'] = $this->getSagyo($data['detail']['D03_DEN_NO']);
     $data['detail']['product'] = $this->getProduct($data['detail']['D03_DEN_NO']);
     $data['job'] = $job;
     $data['status'] = Yii::$app->params['status'];
     $data['csv'] = csv::readcsv(['D03_DEN_NO' => $filter['detail_no']]);
     $data['confirm'] = confirm::readconfirm(['D03_DEN_NO' => $filter['detail_no']]);
     $this->layout = '@app/views/layouts/print';
     Yii::$app->view->title = '作業確認書';
     Yii::$app->params['titlePage'] = '作業確認書';
     return $this->render('preview', $data);
 }
示例#4
0
 public function saveDataDenpyo($denpyoNo, &$denpyoDataPost)
 {
     $login_info = Yii::$app->session->get('login_info');
     $uDenpyo = new Udenpyo();
     $denpyo = new Sdptd03denpyo();
     $denpyoSagyo = new \app\models\Sdptd04denpyosagyo();
     $denpyoCom = new \app\models\Sdptd05denpyocom();
     $dataTemp = Yii::$app->request->post();
     foreach ($dataTemp as $key => $val) {
         if (substr($key, 0, 3) == 'D03') {
             $dataDenpyo[$key] = $val;
         }
     }
     $dataDenpyo['D03_SS_CD'] = $dataTemp['D01_SS_CD'];
     if ($dataTemp['D03_TANTO_MEI_D03_TANTO_SEI'] != '') {
         $temTantoMeiSei = explode('[]', $dataTemp['D03_TANTO_MEI_D03_TANTO_SEI']);
         $dataDenpyo['D03_TANTO_SEI'] = $temTantoMeiSei['0'];
         $dataDenpyo['D03_TANTO_MEI'] = $temTantoMeiSei['1'];
     } else {
         $dataDenpyo['D03_TANTO_MEI'] = '';
         $dataDenpyo['D03_TANTO_SEI'] = '';
     }
     if ($dataTemp['D03_KAKUNIN_MEI_D03_KAKUNIN_SEI'] != '') {
         $temKakuninMeiSei = explode('[]', $dataTemp['D03_KAKUNIN_MEI_D03_KAKUNIN_SEI']);
         $dataDenpyo['D03_KAKUNIN_SEI'] = $temKakuninMeiSei['0'];
         $dataDenpyo['D03_KAKUNIN_MEI'] = $temKakuninMeiSei['1'];
     } else {
         $dataDenpyo['D03_KAKUNIN_MEI'] = '';
         $dataDenpyo['D03_KAKUNIN_SEI'] = '';
     }
     unset($dataDenpyo['D03_TANTO_MEI_D03_TANTO_SEI']);
     unset($dataDenpyo['D03_KAKUNIN_MEI_D03_KAKUNIN_SEI']);
     $dataDenpyo['D03_CUST_NO'] = isset($dataTemp['D01_CUST_NO']) ? $dataTemp['D01_CUST_NO'] : 0;
     if ($denpyoNo) {
         $dataDenpyo['D03_CUST_NO'] = $dataTemp['D03_CUST_NO'];
     } else {
         $dataDenpyo['D03_DEN_NO'] = $denpyo->getSeq();
     }
     $dataDenpyo['D03_KAKUNIN'] = (int) Yii::$app->request->post('D03_KAKUNIN');
     $seqCar = Yii::$app->request->post('D02_CAR_SEQ_SELECT');
     if ($seqCar) {
         $dataDenpyo['D03_CAR_SEQ'] = $seqCar;
         $dataDenpyo['D03_CAR_NO'] = $dataTemp['D02_CAR_NO_' . $seqCar];
         $dataDenpyo['D03_CAR_ID'] = $dataTemp['D02_CAR_ID_' . $seqCar];
         $dataDenpyo['D03_METER_KM'] = $dataTemp['D02_METER_KM_' . $seqCar];
         $dataDenpyo['D03_CAR_NAMEN'] = $dataTemp['D02_CAR_NAMEN_' . $seqCar];
         $dataDenpyo['D03_HIRA'] = $dataTemp['D02_HIRA_' . $seqCar];
         $dataDenpyo['D03_RIKUUN_NAMEN'] = $dataTemp['D02_RIKUUN_NAMEN_' . $seqCar];
         $dataDenpyo['D03_JIKAI_SHAKEN_YM'] = $dataTemp['D02_JIKAI_SHAKEN_YM_' . $seqCar];
     }
     $dataDenpyoCom = [];
     $k = 1;
     for ($i = 1; $i < 11; ++$i) {
         if (isset($dataTemp['code_search' . $i]) && $dataTemp['code_search' . $i] != '') {
             $dataDenpyoCom[$k]['D05_DEN_NO'] = $dataDenpyo['D03_DEN_NO'];
             //$dataDenpyoCom[$k]['D05_COM_CD'] = $dataTemp['D05_COM_CD' . $i];
             //$dataDenpyoCom[$k]['D05_NST_CD'] = $dataTemp['D05_NST_CD' . $i];
             $dataDenpyoCom[$k]['D05_COM_CD'] = str_pad(substr($dataTemp['code_search' . $i], 0, 6), 6, '0', STR_PAD_LEFT);
             $dataDenpyoCom[$k]['D05_NST_CD'] = str_pad(substr($dataTemp['code_search' . $i], 6, 3), 3, '0', STR_PAD_LEFT);
             $dataDenpyoCom[$k]['D05_COM_SEQ'] = $k;
             $dataDenpyoCom[$k]['D05_SURYO'] = $dataTemp['D05_SURYO' . $i];
             $dataDenpyoCom[$k]['D05_TANKA'] = $dataTemp['D05_TANKA' . $i];
             $dataDenpyoCom[$k]['D05_KINGAKU'] = $dataTemp['D05_KINGAKU' . $i];
             $dataDenpyoCom[$k]['D05_INP_DATE'] = new Expression("CURRENT_DATE");
             $dataDenpyoCom[$k]['D05_INP_USER_ID'] = $login_info['M50_USER_ID'];
             $dataDenpyoCom[$k]['D05_UPD_DATE'] = new Expression("CURRENT_DATE");
             $dataDenpyoCom[$k]['D05_UPD_USER_ID'] = $login_info['M50_USER_ID'];
             ++$k;
         }
     }
     $m01SagyoNo = Yii::$app->request->post('M01_SAGYO_NO');
     $dataDenpySagyo = [];
     if (count($m01SagyoNo)) {
         for ($i = 0; $i < count($m01SagyoNo); ++$i) {
             $dataDenpySagyo[] = ['D04_DEN_NO' => $dataDenpyo['D03_DEN_NO'], 'D04_SAGYO_NO' => $m01SagyoNo[$i], 'D04_UPD_DATE' => new Expression("CURRENT_DATE"), 'D04_UPD_USER_ID' => $login_info['M50_USER_ID'], 'D04_INP_DATE' => new Expression("CURRENT_DATE"), 'D04_INP_USER_ID' => $login_info['M50_USER_ID']];
         }
         if ($denpyoNo) {
             $listDenpyoSagyo = $denpyoSagyo->getData(['D04_DEN_NO' => $denpyoNo]);
             /* Get input date,input user id of denpyosagyo */
             if (count($listDenpyoSagyo)) {
                 foreach ($dataDenpySagyo as $index => $temp) {
                     foreach ($listDenpyoSagyo as $index1 => $temp1) {
                         if ($temp['D04_SAGYO_NO'] == $temp1['D04_SAGYO_NO']) {
                             $dataDenpySagyo[$index]['D04_INP_DATE'] = $temp1['D04_INP_DATE'];
                             $dataDenpySagyo[$index]['D04_INP_USER_ID'] = $temp1['D04_INP_USER_ID'];
                         }
                     }
                 }
             }
             /* Get input date, input user id of denpyo com */
             $listDenpyoCom = $denpyoCom->getData(['D05_DEN_NO' => $denpyoNo]);
             if (count($listDenpyoCom) && count($dataDenpyoCom)) {
                 foreach ($dataDenpyoCom as $index => $temp) {
                     foreach ($listDenpyoCom as $index1 => $temp1) {
                         if ($temp['D05_COM_CD'] == $temp1['D05_COM_CD'] && $temp['D05_NST_CD'] == $temp1['D05_NST_CD'] && $temp['D05_COM_SEQ'] == $temp1['D05_COM_SEQ']) {
                             $dataDenpyoCom[$index]['D05_INP_DATE'] = $temp1['D05_INP_DATE'];
                             $dataDenpyoCom[$index]['D05_INP_USER_ID'] = $temp1['D05_INP_USER_ID'];
                         }
                     }
                 }
             }
         }
     }
     if ($seqCar == 0 || $dataDenpyo['D03_CUST_NO'] == 0) {
         \Yii::info('Error: ' . $seqCar . $dataDenpyo['D03_CUST_NO']);
         return 0;
     }
     $dataCus['D01_SS_CD'] = $dataTemp['D01_SS_CD'];
     $dataCus['D01_UKE_JYUG_CD'] = $dataTemp['M08_NAME_MEI_M08_NAME_SEI'];
     $tm08Sagyosya = current($uDenpyo->getTm08Sagyosya(['M08_JYUG_CD' => $dataTemp['M08_NAME_MEI_M08_NAME_SEI']]));
     $dataCus['D01_UKE_TAN_NAMEN'] = $tm08Sagyosya['M08_NAME_SEI'] . $tm08Sagyosya['M08_NAME_MEI'];
     $dataCus['D01_CUST_NO'] = $dataDenpyo['D03_CUST_NO'];
     $res = $uDenpyo->saveDenpyo($dataDenpyo, $dataDenpySagyo, $dataCus, $dataDenpyoCom, $denpyoNo);
     if ($res) {
         $denpyoDataPost = array_merge($dataTemp, $dataDenpyo);
         return $dataDenpyo['D03_DEN_NO'];
     }
     return false;
 }