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;
}
