/** * Makers list */ public function indexAction() { $request = $this->request; $persistent = $this->persistent; // Reset $reset = $this->request->getQuery('reset', 'int'); if (isset($reset)) { $persistent->makersParams = null; } // Persistent parameters if (!is_array($persistent->makersParams)) { $persistent->makersParams = ['qry' => ['conditions' => "id IS NOT NULL", 'order' => 'updated DESC'], 'sort' => ['page' => 1, 'perpage' => 50]]; } $parameters = $persistent->makersParams; $parameters['sort']['perpage'] = isset($parameters['sort']['perpage']) ? $parameters['sort']['perpage'] : 50; $parameters['sort']['page'] = isset($parameters['sort']['page']) ? $parameters['sort']['page'] : 1; if ($request->getQuery('page', 'int')) { $parameters['sort']['page'] = $request->getQuery('page', 'int'); } if ($request->getQuery('perpage', 'int')) { $parameters['sort']['perpage'] = $request->getQuery('perpage', 'int'); } // Search if ($request->isPost()) { $parameters['search_region'] = null; $parameters['search_approved'] = null; // Placer if (!empty($_POST['search_region'])) { $search_region_get = $request->getPost('search_region', 'int'); $parameters['search_region'] = $search_region_get; $search_region = " AND geo_id = {$search_region_get}"; } else { $search_region = null; } // Name or ID if (!empty($_POST['search_name'])) { $search_name_get = $request->getPost('search_name', 'string'); if (preg_match('/^[0-9,\\s]+$/', $request->getPost('search_name', 'string'))) { $search_split = preg_split('/[,\\s]/', $search_name_get, 0, PREG_SPLIT_NO_EMPTY); $search_name = implode(', ', $search_split); $search_name = " AND id IN ({$search_name})"; } else { $search_name = " AND name LIKE '%{$search_name_get}%'"; } } else { $search_name_get = null; $search_name = null; } // Email if (!empty($_POST['search_email'])) { $search_email_get = $request->getPost('search_email', 'string'); $search_email = " AND email LIKE '%{$search_email_get}%'"; } else { $search_email_get = null; $search_email = null; } // Phone if (!empty($_POST['search_phone'])) { $search_phone_get = $request->getPost('search_phone', 'string'); $search_phone = " AND phone LIKE '%{$search_phone_get}%' OR phone2 LIKE '%{$search_phone_get}%'"; } else { $search_phone_get = null; $search_phone = null; } // Approved status if (!empty($_POST['search_approved'])) { $search_approved_get = $request->getPost('search_approved', 'int'); $parameters['search_approved'] = $search_approved_get; $search_approved = " AND approved = {$search_approved_get}"; } else { $search_approved = null; } // Search parameters $parameters['qry'] = ['conditions' => "id IS NOT NULL\n {$search_region}\n {$search_name}\n {$search_email}\n {$search_phone}\n {$search_approved}"]; } // Other parameters $parameters['count'] = PMaker::count($parameters['qry']); $parameters['qry']['order'] = "updated DESC"; $parameters['qry']['limit'] = 10000; $persistent->makersParams = $parameters; // var_dump($parameters); $makers = PMaker::find($parameters['qry']); // Paginator $paginator = new Paginator(["data" => $makers, "limit" => $parameters['sort']['perpage'], "page" => $parameters['sort']['page']]); $this->view->page = $paginator->getPaginate(); // Set selected search values $this->view->selected_region = isset($parameters['search_region']) && !empty($parameters['search_region']) ? $parameters['search_region'] : null; $this->view->selected_approved = isset($parameters['search_approved']) && !empty($parameters['search_approved']) ? $parameters['search_approved'] : null; $this->view->makers_count = $parameters['count']; // All regions $this->view->regions_list = array_column(Geo::find(['order' => 'title ASC'])->toArray(), 'title', 'id'); // Currencies $currencies_array = array_column(PCrosscurrency::find()->toArray(), 'title', 'title'); $this->view->currencies_list = ['UAH' => $currencies_array['UAH']] + $currencies_array; // Countries $countries_array = array_column(Countries::find("active=1")->toArray(), 'title', 'id'); $ukraine = array_search('Украина', $countries_array); $this->view->countries_list = [$ukraine => $countries_array[$ukraine]] + $countries_array; $this->view->users_list = Accounts::getUsersByRole(['researcher', 'mobilegroup'], false, 'name ASC'); $this->view->can_edit = AccRoles::findFirst("user_id={$this->auth->id} AND (role_id=991 OR role_id=5)"); }
public function productsAction() { $request = $this->request; $persistent = $this->persistent; // Reset $reset = $this->request->getQuery('reset', 'int'); if (isset($reset)) { $persistent->productsParams = null; } // Persistent parameters if (!is_array($persistent->productsParams)) { $persistent->productsParams = ['qry' => ['conditions' => "id IS NOT NULL", 'order' => 'id ASC'], 'sort' => ['page' => 1, 'perpage' => 50]]; } $parameters = $persistent->productsParams; $parameters['sort']['perpage'] = 50; $parameters['sort']['page'] = 1; if ($request->getQuery('page', 'int')) { $parameters['sort']['page'] = $request->getQuery('page', 'int'); } if ($request->getQuery('perpage', 'int')) { $parameters['sort']['perpage'] = $request->getQuery('perpage', 'int'); } // ---------------------------------------- // Search if ($request->isPost()) { $parameters['search_cat'] = null; $parameters['search_virtcat'] = null; $parameters['search_maker'] = null; $parameters['search_material'] = null; $parameters['search_hold'] = null; $parameters['search_id'] = null; // Category if (!empty($_POST['search_cat'])) { $search_cat_get = $request->getPost('search_cat', 'int'); $parameters['search_cat'] = $search_cat_get; $search_cats = PCategory::getCatTree($search_cat_get); $search_cat = " AND category_id IN ({$search_cats})"; } else { $search_cat = null; } // Virtual category if (!empty($_POST['search_virtcat'])) { $search_virtcat_get = $request->getPost('search_virtcat', 'int'); $parameters['search_virtcat'] = $search_virtcat_get; $search_virtcat = " AND tmaterial_id = {$search_virtcat_get}"; } else { $search_virtcat = null; } // Maker if (!empty($_POST['search_maker'])) { $search_maker_get = $request->getPost('search_maker', 'int'); $parameters['search_maker'] = $search_maker_get; $search_maker = " AND maker_id = {$search_maker_get}"; } else { $search_maker = null; } // Material if (!empty($_POST['search_material'])) { $search_material_get = $request->getPost('search_material', 'int'); $parameters['search_material'] = $search_material_get; $search_material = " AND cmaterial_id = {$search_material_get}"; } else { $search_material = null; } // Hold if (!empty($_POST['search_hold'])) { $search_hold_get = $request->getPost('search_hold', 'int'); $parameters['search_hold'] = $search_hold_get; $search_hold = $search_hold_get == 1 ? " AND hold = 1" : " AND hold = 0"; } else { $search_hold = null; } // ID if (!empty($_POST['search_id'])) { $parameters['search_id'] = $request->getPost('search_id', 'string'); $search_id_get = preg_split('/[,\\s]/', $request->getPost('search_id', 'string'), null, PREG_SPLIT_NO_EMPTY); $search_id = join(', ', $search_id_get); $search_id = " AND id IN ({$search_id})"; } else { $search_id = null; } // Search parameters $parameters['qry'] = ['conditions' => "id IS NOT NULL\n {$search_cat}\n {$search_virtcat}\n {$search_maker}\n {$search_material}\n {$search_hold}\n {$search_id}"]; } // Other parameters $parameters['query_count'] = PProductMain::count($parameters['qry']); $parameters['qry']['order'] = "id ASC"; $parameters['qry']['limit'] = 10000; $persistent->productsParams = $parameters; // var_dump($parameters); // Find all placements that correspond to set parameters $products = PProductMain::find($parameters['qry']); // Paginator $paginator = new Paginator(["data" => $products, "limit" => $parameters['sort']['perpage'], "page" => $parameters['sort']['page']]); $this->view->page = $paginator->getPaginate(); // Set selected search values $this->view->selected_cat = isset($parameters['search_cat']) && !empty($parameters['search_cat']) ? $parameters['search_cat'] : null; $this->view->selected_virtcat = isset($parameters['search_virtcat']) && !empty($parameters['search_virtcat']) ? $parameters['search_virtcat'] : null; $this->view->selected_maker = isset($parameters['search_maker']) && !empty($parameters['search_maker']) ? $parameters['search_maker'] : null; $this->view->selected_material = isset($parameters['search_material']) && !empty($parameters['search_material']) ? $parameters['search_material'] : null; $this->view->selected_hold = isset($parameters['search_hold']) && !empty($parameters['search_hold']) ? $parameters['search_hold'] : null; $this->view->selected_id = isset($parameters['search_id']) && !empty($parameters['search_id']) ? $parameters['search_id'] : null; // Products count (overall or filtered) $this->view->products_count = $parameters['query_count']; // All categories $this->view->cats_list = PCategory::getCatList(); // All virtual categories $virtcats = PCategoryGroup::find(['order' => 'title ASC']); foreach ($virtcats as $virtcat) { $virtcats_array[$virtcat->id] = $virtcat->title; } $this->view->virtcats_list = $virtcats_array; // All makers // $makers = PMaker::find(["name IS NOT NULL AND isseller=1 AND approved=1 AND banned=0", 'order' => 'name ASC']); $makers = PMaker::find(["name IS NOT NULL AND isseller=1", 'order' => 'name ASC']); foreach ($makers as $maker) { $makers_array[$maker->id] = $maker->name; } $this->view->makers_list = $makers_array; // All materials $materials = PProdMaterial::find(['order' => 'title ASC']); foreach ($materials as $material) { $materials_array[$material->id] = $material->title; } $this->view->materials_list = $materials_array; // Langs stat $langs = PProdInfo::count(["coder_status = 5", 'group' => 'lang', 'order' => 'id']); foreach ($langs as $lang) { $langs_stat[$lang->lang] = $lang->rowcount; } $this->view->langs_stat = $langs_stat; // Check if user can put products on hold $this->view->can_hold = AccRoles::findFirst("user_id={$this->auth->id} AND (role_id=5 OR role_id=1000)"); }