public function actionIndex() { $request = Yii::$app->request; if ($request->isAjax) { $obj = new Sdptm05com(); $condition = $request->post('condition'); $condition_1 = trim($request->post('condition_1'), ','); if ($condition_1) { $condition_1 = ',' . $condition_1 . ','; } $a_search = ['1' => '7,8', '2' => '1,2,3,4,5,6', '3' => '10', '4' => '24,25,26', '5' => '27', '6' => '21', '7' => '0']; $kind_com_search_in = ''; $kind_com_search_not_in = ''; foreach ($a_search as $key => $val) { if (substr_count($condition_1, ',' . $key . ',')) { $kind_com_search_in .= $val . ','; } else { $kind_com_search_not_in .= $val . ','; } } if (substr_count($condition_1, ',7,')) { if ($kind_com_search_not_in) { $data['filters']['not_in'] = explode(',', trim($kind_com_search_not_in, ',')); } } else { if ($kind_com_search_in) { $data['filters']['in'] = explode(',', trim($kind_com_search_in, ',')); } } $data['filters'][$condition] = $request->post('value'); $data['count'] = $obj->coutData($data['filters']); $data['pagination'] = new Pagination(['totalCount' => $data['count'], 'defaultPageSize' => 10, 'page' => $request->post('page')]); $data['filters']['offset'] = $data['pagination']->offset; $data['filters']['limit'] = $data['pagination']->limit; $data['product'] = $obj->getData($data['filters']); Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; return $data; } }
public function createDataExport() { $obj = new Sdptm05com(); $product = $obj->getData([], 'M05_COM_CD, M05_NST_CD, M05_KIND_COM_NO, M05_LARGE_COM_NO, M05_MIDDLE_COM_NO, M05_KIND_DM_NO, M05_COM_NAMEN, M05_LIST_PRICE, M05_ORDER, M05_MEMO'); return $product; }