public function actionProductlist($search = null, $id = null) { $out = ['more' => false]; if (!is_null($search)) { $query = new Query(); $lowerchr = strtolower($search); $command = Yii::$app->db->createCommand("SELECT DISTINCT id, '[' || default_code || '] ' || name_template as text FROM product_product WHERE lower(name_template) LIKE '%" . $lowerchr . "%' OR lower(default_code) LIKE '%" . $lowerchr . "%' LIMIT 20"); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $ids = explode(',', $id); foreach ($ids as $value) { $data[] = ['id' => $value, 'text' => '[' . ProductProduct::find()->where(['id' => $value])->one()->default_code . '] ' . ProductProduct::find()->where(['id' => $value])->one()->name_template]; } $out['results'] = $data; } else { $out['results'] = ['id' => 0, 'text' => 'No matching records found']; } echo Json::encode($out); }
public function actionExportCsv($id) { $this->layout = 'export'; $product = ProductProduct::find()->where(['id' => $id])->one(); return $this->render('report/exportcsv', ['model' => $product]); }