public function getSagyo($den_no) { $obj = new Sdptd04denpyosagyo(); $job_info = $obj->getData(['D04_DEN_NO' => $den_no]); $job = []; foreach ($job_info as $k => $v) { $job[$k]['D04_SAGYO_NO'] = $v['D04_SAGYO_NO']; } return $job; }
/** * get job of order * @param $order_id * @return array */ public static function getJob($order_id) { $result = []; $obj = new Sdptd04denpyosagyo(); $job = $obj->getData(['D04_DEN_NO' => $order_id]); if (!empty($job)) { foreach ($job as $k => $v) { $result[] = $v['D04_SAGYO_NO']; } } return $result; }
private function getWhereSearch($filters) { $query = new Query(); $query->select(["SDP_TD03_DENPYO.*, TO_CHAR(D03_UPD_DATE, 'YYYY/mm/DD') as CHAR_D03_UPD_DATE,\n SDP_TD01_CUSTOMER.D01_CUST_NAMEN, SDP_TD01_CUSTOMER.D01_CUST_NAMEK, SDP_TD01_CUSTOMER.D01_NOTE"])->from(static::tableName())->leftJoin('SDP_TD01_CUSTOMER', 'SDP_TD03_DENPYO.D03_CUST_NO = SDP_TD01_CUSTOMER.D01_CUST_NO')->orderBy('D03_DEN_NO'); if (isset($filters['status']) && $filters['status'] != '') { if ($filters['status'] == 1) { $query->andwhere('SDP_TD03_DENPYO.D03_STATUS=:status', [':status' => 0]); $query->andWhere(['>', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', date('Ymd')]); } if ($filters['status'] == 2) { $query->andwhere('SDP_TD03_DENPYO.D03_STATUS=:status', [':status' => 1]); } if ($filters['status'] == 0) { $query->andwhere('SDP_TD03_DENPYO.D03_STATUS=:status', [':status' => 0]); $query->andWhere(['<=', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', date('Ymd')]); } } if (isset($filters['car']) && $filters['car']) { $query->andwhere(['like', 'SDP_TD03_DENPYO.D03_CAR_NO', $filters['car']]); } if (isset($filters['job']) && $filters['job'] != '') { $denpyo_sagyo = new Sdptd04denpyosagyo(); $data = $denpyo_sagyo->getData(['D04_SAGYO_NO' => $filters['job']]); $arr_den_no = [-1]; foreach ($data as $k => $v) { $arr_den_no[] = $v['D04_DEN_NO']; } $query->andwhere(['in', 'SDP_TD03_DENPYO.D03_DEN_NO', $arr_den_no]); } if (isset($filters['start_time']) && $filters['start_time']) { $query->andwhere(['>=', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', $filters['start_time']]); } if (isset($filters['end_time']) && $filters['end_time']) { $query->andwhere(['<=', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', $filters['end_time']]); } if (isset($filters['detail_no'])) { $query->andwhere('SDP_TD03_DENPYO.D03_DEN_NO=:den_no', [':den_no' => $filters['detail_no']]); } if (isset($filters['m50_ss_cd'])) { $query->andwhere('SDP_TD03_DENPYO.D03_SS_CD =:m50_ss_cd', [':m50_ss_cd' => $filters['m50_ss_cd']]); } if (isset($filters['offset']) && $filters['offset']) { $query->offset($filters['offset']); } if (isset($filters['limit']) && $filters['limit']) { $query->limit($filters['limit']); } return $query; }