public function getPosts() { $query = new \yii\db\Query(); $query->select('posts.*, user_name, category_name')->from('posts')->leftJoin('users', ' posts.post_author = users.id')->innerJoin('posts_category', ' posts.post_category = posts_category.id'); $command = $query->createCommand(); return $posts_category = $command->queryAll(); }
public static function findRecursive($children_ids, $direct = 'up', $only_leaf = false) { $placeholders = !empty($children_ids) ? str_repeat('?,', count($children_ids) - 1) . '?' : false; $first_param = $direct === 'up' ? 'id' : 'parent_id'; $second_param = $direct === 'up' ? 'parent_id' : 'id'; $sql = 'WITH RECURSIVE tree AS ( SELECT *, 0 AS level FROM rubric' . ($placeholders ? ' WHERE ' . $first_param . ' IN (' . $placeholders . ')' : '') . ' UNION SELECT parent.*, child.level + 1 AS level FROM rubric AS parent JOIN tree AS child ON child.' . $second_param . ' = parent.' . $first_param . ' ) SELECT DISTINCT t.id, t.title, t.parent_id ' . ' FROM tree as t' . ($only_leaf ? ' LEFT OUTER JOIN tree AS r ON t.id = r.parent_id WHERE r.parent_id IS NULL' : '') . ' ORDER BY id ASC;'; $query = new \yii\db\Query(); $command = $query->createCommand()->setSql($sql); if ($placeholders) { foreach ($children_ids as $i => $children) { $command->bindValue($i + 1, $children); } } $rubric = $command->queryAll(); // var_export($sql); die(); return $rubric; }
public function actionEmpinforeport() { $employee_data = $selected_list = array(); if (!empty(Yii::$app->request->post('e_info'))) { $selected_list = Yii::$app->request->post('e_info'); $employee_d = new \yii\db\Query(); $employee_d->select('*')->from('emp_master emp')->join('join', 'emp_info e_info', 'e_info.emp_info_id = emp.emp_master_emp_info_id')->join('join', 'emp_department emp_dep', 'emp_dep.emp_department_id = emp.emp_master_department_id ')->join('join', 'emp_designation emp_des', 'emp_des.emp_designation_id = emp.emp_master_designation_id ')->join('join', 'emp_category emp_cat', 'emp_cat.emp_category_id = emp. emp_master_category_id')->leftJoin('emp_address eadd', 'eadd.emp_address_id = emp.emp_master_emp_address_id')->where(['emp.is_status' => 0])->andFilterWhere(['emp.emp_master_department_id' => Yii::$app->request->post('department')])->andFilterWhere(['emp.emp_master_designation_id' => Yii::$app->request->post('designation')])->andFilterWhere(['emp.emp_master_emp_address_id' => Yii::$app->request->post('city')])->andFilterWhere(['emp.emp_master_category_id' => Yii::$app->request->post('category')])->andFilterWhere(['e_info.emp_gender' => Yii::$app->request->post('gender')]); $command = $employee_d->createCommand(); $employee_data = $command->queryAll(); Yii::$app->session->set('data["empData"]', $employee_data); Yii::$app->session->set('data["selection"]', $selected_list); if (empty($employee_data)) { \Yii::$app->getSession()->setFlash('emperror', "<i class='fa fa-exclamation-triangle'></i> <b>" . Yii::t('report', 'No Record Found For This Criteria.') . "</b>"); return $this->redirect(['empinforeport']); } return $this->render('emp_info_report', ['employee_data' => $employee_data, 'selected_list' => $selected_list]); } else { if (Yii::$app->request->get('exportExcel')) { $file = $this->renderPartial('emp_info_report_excel', array('employee_data' => Yii::$app->session->get('data["empData"]'), 'selected_list' => Yii::$app->session->get('data["selection"]'))); $fileName = "Employee_info_report" . date('YmdHis') . '.xls'; $options = ['mimeType' => 'application/vnd.ms-excel']; return Yii::$app->excel->exportExcel($file, $fileName, $options); } else { if (Yii::$app->request->get('exportPDF')) { $html = $this->renderPartial('emp_info_report_pdf', array('employee_data' => Yii::$app->session->get('data["empData"]'), 'selected_list' => Yii::$app->session->get('data["selection"]'))); ob_clean(); return Yii::$app->pdf->exportData('Employee Info Report', 'Employee_info_report', $html); } } } return $this->render('emp_report_view', ['selected_list' => $selected_list]); }
public function actionSortPosts($sort_id) { $query = new \yii\db\Query(); $query->select('posts.*, user_name, category_name')->from('posts')->leftJoin('users', ' posts.post_author = users.user_id')->innerJoin('posts_category', ' posts.post_category = posts_category.category_id')->WHERE("posts_category.category_id=" . $sort_id); $command = $query->createCommand(); $sort_posts = $command->queryAll(); return $this->render('index', ['posts' => $sort_posts, 'posts_category' => $this->getPostsCategory()]); }
/** * Displays a single ReportClassified model. * @param integer $id * @return mixed */ public function actionView($id) { $queryReport = new \yii\db\Query(); $queryReport->select(['report_classified.id', 'report_classified.message', 'report_classified.email_reporter', 'report_classified.create_at', 'report_classified.update_at', 'report_classified.checked', 'report_classified.type', 'report_classified.classified_id', 'subject_report.subject'])->from('report_classified')->join('JOIN', 'subject_report', 'subject_report.id = report_classified.subject_id')->where(['report_classified.id' => $id])->all(); $commandReport = $queryReport->createCommand(); $dataReport = $commandReport->queryAll(); return $this->render('view', ['dataReport' => $dataReport]); }
public function actionCustomers() { $query = new \yii\db\Query(); $query->select('*')->from('customers')->limit(10); $query->createCommand(); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false]); return $this->renderPartial('latest-customers', ['dataProvider' => $dataProvider]); }
/** * Displays a single Classified model. * @param integer $id * @return mixed */ public function actionView($id) { // $modelReport = new \common\models\ClassifiedReport(); $queryView = new \yii\db\Query(); $queryView->select(['classified.id', 'classified.title', 'classified.description', 'main_category.main_category', 'category.category', 'country.country', 'region.region', 'city.city', 'classified.price', 'classified.create_at', 'classified.update_at', 'classified.user_id', 'classified.is_status', 'classified.type'])->from('classified')->join('JOIN', 'main_category', 'main_category.id = classified.main_category_id')->join('JOIN', 'category', 'category.id = classified.category_id')->join('JOIN', 'country', 'country.id = classified.country_id')->join('JOIN', 'region', 'region.id = classified.region_id')->join('JOIN', 'city', 'city.id = classified.city_id')->where(['classified.id' => $id])->all(); $commandView = $queryView->createCommand(); $dataView = $commandView->queryAll(); return $this->render('view', ['dataView' => $dataView]); }
public function actionContact($id) { $modelCover = new Profile(); $modelCover = $this->findModel($id); //query model $query = new \yii\db\Query(); $query->select(['profile.name', 'profile.image_profile', 'profile.public_email', 'profile.phone_number', 'profile.gender', 'profile.facebook_url', 'profile.twitter_url', 'profile.instagram_url', 'city.city', 'region.region', 'country.country', 'user.created_at', 'user.id'])->from('profile')->join('JOIN', 'user', 'user.id = profile.user_id')->join('JOIN', 'city', 'city.id = profile.city_id')->join('JOIN', 'region', 'region.id = profile.region_id')->join('JOIN', 'country', 'country.id = profile.country_id')->where(['user_id' => $id])->all(); $command = $query->createCommand(); $data = $command->queryAll(); return $this->render('contact', ['modelCover' => $modelCover, 'data' => $data]); }
public function sum($type, $date_from, $date_to) { //$date_from = "01-01-$yaer 00:00:00"; //$date_to = "31-12-$yaer 23:59:59"; $query = new \yii\db\Query(); $query->select("sum(`leadsum`) AS lead,{{%transactions}}.type,{{%transactions}}.valuedate")->from('{{%transactions}}'); $query->join = [['LEFT JOIN', '{{%accounts}}', '{{%accounts}}.id=account_id']]; $query->groupBy = "{{%accounts}}.type"; $query->where("{{%accounts}}.type = :type"); $query->andWhere("valuedate>=:date_from"); $query->andWhere("valuedate<=:date_to"); $query->params([':date_from' => $date_from, ':date_to' => $date_to, ':type' => $type]); $command = $query->createCommand(); return $command->queryScalar(); }
public function actionStuinforeport() { $student_data = $selected_list = []; $model = new StuMaster(); $info = new StuInfo(); if ($model->load(Yii::$app->request->post()) && $info->load(Yii::$app->request->post())) { if (Yii::$app->request->isAjax) { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; return ActiveForm::validateMultiple([$model, $info]); } $selected_list = $_POST['s_info']; $query1 = new \yii\db\Query(); $query1->select('*')->from('stu_master stu')->join('join', 'stu_info s_info', 's_info.stu_info_id = stu.stu_master_stu_info_id')->join('join', 'stu_address add', 'add.stu_address_id = stu.stu_master_stu_address_id')->where(['stu.is_status' => 0])->andFilterWhere(['stu.stu_master_course_id' => $model->stu_master_course_id])->andFilterWhere(['stu.stu_master_batch_id' => $model->report_batch_id])->andFilterWhere(['stu.stu_master_section_id' => $model->report_section_id])->andFilterWhere(['add.stu_cadd_city' => $model->report_city])->andFilterWhere(['s_info.stu_gender' => $info->stu_gender]); $command = $query1->createCommand(); $student_data = $command->queryAll(); Yii::$app->session->set('data["stuData"]', $student_data); Yii::$app->session->set('data["selection"]', $selected_list); if (empty($student_data)) { \Yii::$app->getSession()->setFlash('studerror', "<i class='fa fa-exclamation-triangle'></i> <b> " . Yii::t('report', 'No Record Found For This Criteria.') . "</b>"); return $this->redirect(['stuinforeport']); } return $this->render('stu_info_report', ['student_data' => $student_data, 'selected_list' => $selected_list]); } else { if (Yii::$app->request->get('exportExcel')) { $file = $this->renderPartial('stu_info_report_excel', array('student_data' => Yii::$app->session->get('data["stuData"]'), 'selected_list' => Yii::$app->session->get('data["selection"]'))); $fileName = "Employee_info_report" . date('YmdHis') . '.xls'; $options = ['mimeType' => 'application/vnd.ms-excel']; return Yii::$app->excel->exportExcel($file, $fileName, $options); } else { if (Yii::$app->request->get('exportPDF')) { $html = $this->renderPartial('stu_info_report_pdf', array('student_data' => Yii::$app->session->get('data["stuData"]'), 'selected_list' => Yii::$app->session->get('data["selection"]'))); ob_clean(); return Yii::$app->pdf->exportData('Employee Info Report', 'Employee_info_report', $html); } } } return $this->render('stu_report_view', ['model' => $model, 'info' => $info, 'selected_list' => $selected_list]); }
public function _getStatusPerson() { $persons = \app\models\PersTasks::find()->where(['TASK_ID' => $this->ID, 'DEL_TRACT_ID' => 0])->all(); if ($persons) { $list = ''; foreach ($persons as $person) { $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PERS')->where('TN = \'' . $person->TN . '\''); $command = $query->createCommand(); $data = $command->queryOne(); //$list .= '<nobr><a href="'.Url::to(['user', 'id'=>$person->TN]).'">'.$data['FAM'].' '.mb_substr($data['IMJ'], 0, 1, 'UTF-8').'. '.mb_substr($data['OTCH'], 0, 1, 'UTF-8').'.</a></nobr><br>'; //get current state $pers_tasks = \app\models\PersTasks::find()->where(['TASK_ID' => $this->ID, 'TN' => $person->TN, 'DEL_TRACT_ID' => 0])->one(); $task_state = \app\models\TaskStates::find()->where(['IS_CURRENT' => 1, 'PERS_TASKS_ID' => $pers_tasks->ID, 'TASK_ID' => $this->ID])->one(); if ($task_state) { $state = $task_state->getState_name_state_colour_without_text(); $state_date = $task_state->getStateDate(); } else { $state = ''; $state_date = ''; } $list .= '<nobr>' . $state . ' <a href="' . Url::to(['user', 'id' => $person->TN]) . '">' . $data['FIO'] . '</a></nobr><br>'; } return $list; } else { $podr = \app\models\PodrTasks::find()->where(['TASK_ID' => $this->ID])->all(); if ($podr) { $list = ''; foreach ($podr as $task) { $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PODR')->where('KODZIFR = \'' . trim($task->KODZIFR) . '\''); $command = $query->createCommand(); $data = $command->queryOne(); if (isset($data['NAIMPODR'])) { $list .= $data['NAIMPODR'] . "<br>"; } } return $list; } } }
if ($data) { $task_confirms_list .= '{value: ' . $data['code'] . ', label: \'' . $data['name'] . '\'},'; $chk_task_confirms .= '$("#agreed-podr-check-list-update").find("#checkbox_' . $data['code'] . '").prop("checked", true);'; } } } else { $task_confirms_list = ''; $chk_task_confirms = ''; } if ($task_docs_recvrs) { $task_docs_recvrs_list = ''; $chk_task_docs_recvrs = ''; foreach ($task_docs_recvrs as $podr) { $query = new \yii\db\Query(); $query->select('NAIMPODR AS name, KODPODR AS id, KODRODIT as parent, KODZIFR as code')->from('STIGIT.V_F_PODR')->where('KODZIFR = \'' . trim($podr->KODZIFR) . '\''); $command = $query->createCommand(); $data = $command->queryOne(); if ($data) { $task_docs_recvrs_list .= '{value: ' . $data['code'] . ', label: \'' . $data['name'] . '\'},'; $chk_task_docs_recvrs .= '$("#transmitted-podr-check-list-update").find("#checkbox_' . $data['code'] . '").prop("checked", true);'; } } } else { $task_docs_recvrs_list = ''; $chk_task_docs_recvrs = ''; } echo $this->registerJs("\r\n\t\t\t\tfunction _selectPodrUpdate() {\r\n\t\t\t\t\tvar selected = [];\r\n\t\t\t\t\tvar selected_values = {};\r\n\t\t\t\t\t\$('#podr-check-list-update input:checked').each(function() {\r\n\t\t\t\t\t selected.push({value: \$(this).attr('value'), label:\$(this).attr('data-title')});\r\n\t\t\t\t\t selected_values[\$(this).attr('value')] = \$(this).attr('data-title');\r\n\t\t\t\t\t});\r\n\t\t\t\t\t\r\n\t\t\t\t\t\$('#tasks-podr_list').tokenfield('setTokens', selected);\r\n\t\t\t \$('#podr-select-modal-update').modal('hide');\r\n\r\n\t\t\t //create persons tree\r\n\t\t\t \$.ajax({\r\n\t\t\t \ttype: \"POST\",\r\n\t\t\t \tdataType: 'json',\r\n\t\t\t \turl: \"index.php?r=site/getpersons\",\r\n\t\t\t \tdata: \"selected_podr=\"+JSON.stringify(selected_values),\r\n\t\t\t \tsuccess: function(data,status){\r\n\t\t\t \t\t\$('#persons-check-list-update').html(data);\r\n\t\t\t \t\t\$('#persons-check-list-update').tree({checkbox: false});\r\n\t\t\t \t\t" . $chk_pers_list . "\r\n\t\t\t \t}\r\n\t\t\t });\r\n\t\t\t }\r\n\r\n\r\n\t\t\t\t\$('#issue-cancel-update-button, #close-label-issue-update').click(function () {\r\n\t\t\t\t \tbootbox.confirm({size: 'small', message: \"Вы уверены, что хотите закрыть форму редактирования задания?\", callback: function(result) {\r\n\t\t\t\t\t \tif(result == true) {\r\n\t\t\t\t\t \t\t\$('#issue-update-modal').modal('hide');\r\n\t\t\t\t\t \t}\t\r\n\t\t\t\t\t}}); \r\n\t\t\t\t});\r\n\r\n\t\t\t\t\$('#add-podr-button-update').click(function(){\r\n\t\t\t\t\t\$(\"#podr-select-modal-update\").modal();\r\n\t\t\t\t});\t\t\r\n\t\t\t\t\$('#podr-check-list-update').tree({checkbox: false});\r\n\r\n\t\t\t\t\$(\"#podr-check-list-update\").find(\".checkbox-podr-link\").click(function(){\r\n\t\t\t \tvar link_id = \$(this).attr('data-id');\r\n\t\t\t \t\$(\"#checkbox_\"+link_id).prop(\"checked\", true);\r\n\t\t\t \t_selectPodrUpdate();\r\n\t\t\t \treturn false;\r\n\t\t\t });\r\n\t\t\t\t\r\n\t\t\t\t\$('#tasks-podr_list').tokenfield();\r\n\t\t\t\t\$('#tasks-podr_list').tokenfield('setTokens', [" . substr_replace($podr_tasks_list, "", -1) . "]);\r\n\t\t\t\t//set checked in modal podr window\r\n\t\t\t\t" . $chk_podr_list . "\r\n\r\n\t\t \t\$('#tasks-podr_list').on('tokenfield:removetoken', function (e) {\r\n\t\t \t\t\$('#tasks-persons_list').val('');\r\n\t\t \t\t\$('#tasks-persons_list').tokenfield('setTokens', []);\r\n\t\t \t\t\$(\"#persons-check-list-update\").find('input[type=checkbox]').removeAttr('checked');\r\n\t\t \t\t\$(\"#persons-check-list-update\").html('<div class=\"alert alert-warning\" role=\"alert\">Пожалуйста, сначала укажите подразделения</div>');\r\n\t\t \t\r\n\t\t \t});\r\n\t\t\t\t\$('#tasks-podr_list').on('tokenfield:removedtoken', function (e) {\r\n\t\t\t\t\t\$(\"#podr-check-list-update\").find('#checkbox_'+e.attrs.value).removeAttr('checked');\r\n\t\t\t\t\t//_selectPodrUpdate();\r\n\t\t\t\t});\r\n\t\t\t\t\r\n\r\n\t\t\t\t\r\n\t\t\t\t\$(\"#add-persons-button-update\").click(function(){\r\n\t\t\t\t\t\$(\"#persons-select-modal-update\").modal();\r\n\t\t\t\t});\r\n\r\n\t\t\t\t\$('#tasks-persons_list').tokenfield();\r\n\t\t\t\t\$('#tasks-persons_list').tokenfield('setTokens', [" . substr_replace($pers_tasks_list, "", -1) . "]);\r\n\r\n\t\t\t\t\$('#tasks-persons_list').on('tokenfield:removedtoken', function (e) {\r\n\t\t\t\t\t\$(\"#persons-check-list-update\").find('#checkbox_'+e.attrs.value).removeAttr('checked');\r\n\t\t\t\t\t\r\n\t\t\t\t});\r\n\t\t\t\t\r\n\t\t\t\t\$('#podr-check-list-update').tree({checkbox: false});\r\n\t\t\t\tvar selected_values = {};\r\n\t\t\t\t\$('#podr-check-list-update input:checked').each(function() {\r\n\t\t\t\t selected_values[\$(this).attr('value')] = \$(this).attr('data-title');\r\n\t\t\t\t});\r\n\t\t\t\tvar csrfToken = \$('meta[name=\"csrf-token\"]').attr(\"content\");\r\n\t\t\t \$.ajax({\r\n\t\t \ttype: \"POST\",\r\n\t\t \tdataType: 'json',\r\n\t\t \turl: \"index.php?r=site/getpersons\",\r\n\t\t \tdata: \"selected_podr=\"+JSON.stringify(selected_values)+\"&_csrf=\"+csrfToken,\r\n\t\t \tsuccess: function(data,status){\r\n\t\t \t\t\$('#persons-check-list-update').html(data);\r\n\t\t \t\t\$('#persons-check-list-update').tree({checkbox: false});\r\n\t\t \t},\r\n\t\t \tcomplete: function() {\r\n\t\t \t\t" . $chk_pers_list . "\r\n\t\t \t}\r\n\t\t\t });\r\n\r\n\t\t\t\t\$('#select-persons-update-btn').click(function(){\r\n\t\t\t \tvar selected = [];\r\n\t\t\t \t\$('#persons-check-list-update input:checked').each(function() {\r\n\t\t\t\t\t selected.push({value: \$(this).attr('value'), label:\$(this).attr('data-title')});\r\n\t\t\t\t\t});\r\n\t\t\t\t\t\$('#tasks-persons_list').tokenfield('setTokens', selected);\r\n\t\t\t \$('#persons-select-modal-update').modal('hide');\r\n\t\t\t });\r\n\t\t\t\t\r\n\r\n\t\t\t\t//for agreed\r\n\t\t\t\tfunction _selectPodrUpdateAgreed() {\r\n\t\t\t\t\tvar selected = [];\r\n\t\t\t\t\tvar selected_values = {};\r\n\t\t\t\t\t\$('#agreed-podr-check-list-update input:checked').each(function() {\r\n\t\t\t\t\t selected.push({value: \$(this).attr('value'), label:\$(this).attr('data-title')});\r\n\t\t\t\t\t selected_values[\$(this).attr('value')] = \$(this).attr('data-title');\r\n\t\t\t\t\t});\r\n\t\t\t\t\t\r\n\t\t\t\t\t\$('#tasks-agreed_podr_list').tokenfield('setTokens', selected);\r\n\t\t\t \$('#agreed-podr-select-modal-update').modal('hide');\r\n\t\t\t }\r\n\r\n\t\t\t\t\$('#add-agreed-podr-button-update').click(function(){\r\n\t\t\t\t\t\$(\"#agreed-podr-select-modal-update\").modal();\r\n\t\t\t\t});\t\r\n\t\t\t\t\$('#agreed-podr-check-list-update').tree({checkbox: false});\r\n\r\n\t\t\t\t\$(\"#agreed-podr-check-list-update\").find(\".checkbox-podr-link-agreed\").click(function(){\r\n\t\t\t \tvar link_id = \$(this).attr('data-id');\r\n\t\t\t \t\r\n\t\t\t \t\$(\"#agreed-podr-check-list-update\").find(\"#checkbox_\"+link_id).prop(\"checked\", true);\r\n\t\t\t \t_selectPodrUpdateAgreed();\r\n\t\t\t \treturn false;\r\n\t\t\t });\r\n\t\t\t\t\$('#tasks-agreed_podr_list').tokenfield();\r\n\t\t\t\t\$('#tasks-agreed_podr_list').tokenfield('setTokens', [" . substr_replace($task_confirms_list, "", -1) . "]);\r\n\t\t\t\t//set checked in modal podr window\r\n\t\t\t\t" . $chk_task_confirms . "\r\n\r\n\t\t\t\t\$('#tasks-agreed_podr_list').on('tokenfield:removedtoken', function (e) {\r\n\t\t\t\t\t\$(\"#agreed-podr-check-list-update\").find('#checkbox_'+e.attrs.value).removeAttr('checked');\r\n\t\t\t\t\t_selectPodrUpdateAgreed();\r\n\t\t\t\t});\r\n\r\n\t\t\t\t//for transmitted\r\n\t\t\t\tfunction _selectPodrUpdateTransmitted() {\r\n\t\t\t\t\tvar selected = [];\r\n\t\t\t\t\tvar selected_values = {};\r\n\t\t\t\t\t\$('#transmitted-podr-check-list-update input:checked').each(function() {\r\n\t\t\t\t\t selected.push({value: \$(this).attr('value'), label:\$(this).attr('data-title')});\r\n\t\t\t\t\t selected_values[\$(this).attr('value')] = \$(this).attr('data-title');\r\n\t\t\t\t\t});\r\n\t\t\t\t\t\r\n\t\t\t\t\t\$('#tasks-transmitted_podr_list').tokenfield('setTokens', selected);\r\n\t\t\t \$('#transmitted-podr-select-modal-update').modal('hide');\r\n\t\t\t }\r\n\r\n\t\t\t\t\$('#add-transmitted-podr-button-update').click(function(){\r\n\t\t\t\t\t\$(\"#transmitted-podr-select-modal-update\").modal();\r\n\t\t\t\t});\t\r\n\t\t\t\t\$('#transmitted-podr-check-list-update').tree({checkbox: false});\r\n\r\n\t\t\t\t\$(\"#transmitted-podr-check-list-update\").find(\".checkbox-podr-link-transmitted\").click(function(){\r\n\t\t\t \tvar link_id = \$(this).attr('data-id');\r\n\t\t\t \t\r\n\t\t\t \t\$(\"#transmitted-podr-check-list-update\").find(\"#checkbox_\"+link_id).prop(\"checked\", true);\r\n\t\t\t \t_selectPodrUpdateTransmitted();\r\n\t\t\t \treturn false;\r\n\t\t\t });\r\n\t\t\t\t\$('#tasks-transmitted_podr_list').tokenfield();\r\n\t\t\t\t\$('#tasks-transmitted_podr_list').tokenfield('setTokens', [" . substr_replace($task_docs_recvrs_list, "", -1) . "]);\r\n\t\t\t\t//set checked in modal podr window\r\n\t\t\t\t" . $chk_task_docs_recvrs . "\r\n\r\n\t\t\t\t\$('#tasks-transmitted_podr_list').on('tokenfield:removedtoken', function (e) {\r\n\t\t\t\t\t\$(\"#transmitted-podr-check-list-update\").find('#checkbox_'+e.attrs.value).removeAttr('checked');\r\n\t\t\t\t\t_selectPodrUpdateTransmitted();\r\n\t\t\t\t});\r\n\r\n\t\t\t", View::POS_END, 'modal_js'); ?> <div class="modal fade" id="podr-select-modal-update" role="dialog" aria-labelledby="podr-select-modal-label"> <div class="modal-dialog" role="document">
public function search($params) { $query = Tasks::find(); //формируем провайдер $dataProvider = new ActiveDataProvider(['query' => $query]); //задание сортировки по умолчанию $dataProvider->sort->attributes = ['TASKS.ID' => ['asc' => ['TASKS.ID' => SORT_ASC], 'desc' => ['TASKS.ID' => SORT_DESC]]]; $dataProvider->sort->defaultOrder = ['TASKS.ID' => SORT_DESC]; //overdue issues filter if (isset($params['overdue']) && $params['overdue'] == 1) { $tasks = \app\models\Tasks::find()->all(); $list = []; foreach ($tasks as $task) { $id = $task->ID; $persons = \app\models\PersTasks::find()->where(['TASK_ID' => $id, 'DEL_TRACT_ID' => 0])->all(); if ($persons) { $states_array = []; foreach ($persons as $person) { $pers_tasks = \app\models\PersTasks::find()->where(['TASK_ID' => $id, 'TN' => $person->TN, 'DEL_TRACT_ID' => 0])->one(); $task_state = \app\models\TaskStates::find()->where(['IS_CURRENT' => 1, 'PERS_TASKS_ID' => $pers_tasks->ID, 'TASK_ID' => $id])->one(); if ($task_state) { $states_array[] = $task_state->STATE_ID; } else { $list[] = $id; } } if (!empty($states_array)) { $min_state = min($states_array); $state = \app\models\States::findOne($min_state); } } if (isset($state)) { if ($state->ID != 7 || $state->ID != 9) { $list[] = $id; } } } $list = array_unique($list); $query->andFilterWhere(['TASKS.ID' => $list]); $now = date("Y-m-d"); $query->andFilterWhere(['<', 'TASKS.DEADLINE', new \yii\db\Expression("to_date('" . $now . "','{$this->dateFormat}')")]); $query->joinWith('perstasks'); $query->andFilterWhere(['PERS_TASKS.TN' => \Yii::$app->user->id]); } //own issues filter if (isset($params['own_issues']) && $params['own_issues'] == 1) { $query->joinWith('perstasks'); $query->andFilterWhere(['PERS_TASKS.TN' => \Yii::$app->user->id]); } if (isset($params['for_person']) && $params['for_person'] != '') { $query->joinWith('perstasks'); $query->andFilterWhere(['PERS_TASKS.TN' => $params['for_person']]); } if (isset($params['for_podr']) && $params['for_podr'] != '') { $query->joinWith('podrtasks'); $query->andFilterWhere(['PODR_TASKS.KODZIFR' => $params['for_podr']]); } //podr issues filter if (isset($params['podr_issues']) && $params['podr_issues'] == 1) { //check permission $permissions_podr_tasks_my = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :id_dolg and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action)', ['subject_type_dolg' => 1, 'id_dolg' => \Yii::$app->session->get('user.user_iddolg'), 'action' => 21, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 0])->one(); if ($permissions_podr_tasks_my) { if ($permissions_podr_tasks_my->PERM_LEVEL == 1 || $permissions_podr_tasks_my->PERM_LEVEL == 2) { //get podr id of this user $query_dao = new \yii\db\Query(); $query_dao->select('*')->from('STIGIT.V_F_PERS')->where('TN = \'' . \Yii::$app->user->id . '\''); $command = $query_dao->createCommand(); $data = $command->queryOne(); //вот тут решить что означает выданные моему подразделению $query->joinWith('podrtasks'); $query->andFilterWhere(['PODR_TASKS.KODZIFR' => trim($data['KODZIFR'])]); } else { throw new \yii\web\ForbiddenHttpException('У Вас нет прав на "Выданные любым задания"'); } } else { throw new \yii\web\ForbiddenHttpException('У Вас нет прав на "Выданные любым задания"'); } } //tasks my filter if (isset($params['tasks_my']) && $params['tasks_my'] == 1) { //check permission $permissions_podr_tasks_my = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :id_dolg and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action)', ['subject_type_dolg' => 1, 'id_dolg' => \Yii::$app->session->get('user.user_iddolg'), 'action' => 23, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 0])->one(); if ($permissions_podr_tasks_my) { if ($permissions_podr_tasks_my->PERM_LEVEL == 1 || $permissions_podr_tasks_my->PERM_LEVEL == 2) { //get all current user transactions $transactions = \app\models\Transactions::find()->where(['TN' => \Yii::$app->user->id])->all(); if ($transactions) { $transactions_array = []; foreach ($transactions as $transaction) { $transactions_array[] = $transaction->ID; } $query->andFilterWhere(['TRACT_ID' => $transactions_array]); } } else { throw new \yii\web\ForbiddenHttpException('У Вас нет прав на "Выданные лично задания"'); } } else { throw new \yii\web\ForbiddenHttpException('У Вас нет прав на "Выданные лично задания"'); } } if (!($this->load($params) && $this->validate())) { return $dataProvider; } //проверяем существует ли фильтр и добавляем его в запрос провайдера для каждого из полей фильтра if (!empty($this->states)) { $query->joinWith('taskstates'); $query->andFilterWhere(['TASK_STATES.STATE_ID' => $this->states]); } if (!empty($this->podr_list)) { $podr_list = array_map('trim', explode(',', $this->podr_list)); $query->joinWith('podrtasks'); $query->andFilterWhere(['PODR_TASKS.KODZIFR' => $podr_list]); } if (!empty($this->agreed_podr_list)) { $agreed_podr_list = array_map('trim', explode(',', $this->agreed_podr_list)); $query->joinWith('taskconfirms'); $query->andFilterWhere(['TASK_CONFIRMS.KODZIFR' => $agreed_podr_list]); } if (!empty($this->persons_list)) { $persons_list = array_map('trim', explode(',', $this->persons_list)); $query->joinWith('perstasks'); $query->andFilterWhere(['PERS_TASKS.TN' => $persons_list]); } if (!empty($this->documentation)) { $query->joinWith('taskdocs'); $query->andFilterWhere(['TASK_DOCS.DOC_CODE' => $this->documentation]); } if ($this->deadline_from != '' && $this->deadline_to != '') { $deadline_from = explode('-', $this->deadline_from); $deadline_from_formatted = $deadline_from[2] . '-' . $deadline_from[1] . '-' . $deadline_from[0]; $deadline_to = explode('-', $this->deadline_to); $deadline_to_formatted = $deadline_to[2] . '-' . $deadline_to[1] . '-' . $deadline_to[0]; $query->andFilterWhere(['>=', 'DEADLINE', new \yii\db\Expression("to_date('" . $deadline_from_formatted . "','{$this->dateFormat}')")])->andFilterWhere(['<=', 'DEADLINE', new \yii\db\Expression("to_date('" . $deadline_to_formatted . "','{$this->dateFormat}')")]); } else { if ($this->deadline_from != '' && $this->deadline_to == '') { $deadline_from = explode('-', $this->deadline_from); $deadline_from_formatted = $deadline_from[2] . '-' . $deadline_from[1] . '-' . $deadline_from[0]; $query->andFilterWhere(['>=', 'DEADLINE', new \yii\db\Expression("to_date('" . $deadline_from_formatted . "','{$this->dateFormat}')")]); } else { if ($this->deadline_from == '' && $this->deadline_to != '') { $deadline_to = explode('-', $this->deadline_to); $deadline_to_formatted = $deadline_to[2] . '-' . $deadline_to[1] . '-' . $deadline_to[0]; $query->andFilterWhere(['<=', 'DEADLINE', new \yii\db\Expression("to_date('" . $deadline_to_formatted . "','{$this->dateFormat}')")]); } } } if ($this->task_type_date_3_from != '' && $this->task_type_date_3_to != '') { $query->joinWith('datetype3'); $task_type_date_3_from = explode('-', $this->task_type_date_3_from); $task_type_date_3_from_formatted = $task_type_date_3_from[2] . '-' . $task_type_date_3_from[1] . '-' . $task_type_date_3_from[0]; $task_type_date_3_to = explode('-', $this->task_type_date_3_to); $task_type_date_3_to_formatted = $task_type_date_3_to[2] . '-' . $task_type_date_3_to[1] . '-' . $task_type_date_3_to[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_3_from_formatted . "','{$this->dateFormat}')")])->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_3_to_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_3_from != '' && $this->task_type_date_3_to == '') { $query->joinWith('datetype3'); $task_type_date_3_from = explode('-', $this->task_type_date_3_from); $task_type_date_3_from_formatted = $task_type_date_3_from[2] . '-' . $task_type_date_3_from[1] . '-' . $task_type_date_3_from[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_3_from_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_3_from == '' && $this->task_type_date_3_to != '') { $query->joinWith('datetype3'); $task_type_date_3_to = explode('-', $this->task_type_date_3_to); $task_type_date_3_to_formatted = $task_type_date_3_to[2] . '-' . $task_type_date_3_to[1] . '-' . $task_type_date_3_to[0]; $query->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_3_to_formatted . "','{$this->dateFormat}')")]); } } } if ($this->task_type_date_1_from != '' && $this->task_type_date_1_to != '') { $query->joinWith('datetype1'); $task_type_date_1_from = explode('-', $this->task_type_date_1_from); $task_type_date_1_from_formatted = $task_type_date_1_from[2] . '-' . $task_type_date_1_from[1] . '-' . $task_type_date_1_from[0]; $task_type_date_1_to = explode('-', $this->task_type_date_1_to); $task_type_date_1_to_formatted = $task_type_date_1_to[2] . '-' . $task_type_date_1_to[1] . '-' . $task_type_date_1_to[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_1_from_formatted . "','{$this->dateFormat}')")])->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_1_to_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_1_from != '' && $this->task_type_date_1_to == '') { $query->joinWith('datetype1'); $task_type_date_1_from = explode('-', $this->task_type_date_1_from); $task_type_date_1_from_formatted = $task_type_date_1_from[2] . '-' . $task_type_date_1_from[1] . '-' . $task_type_date_1_from[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_1_from_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_1_from == '' && $this->task_type_date_1_to != '') { $query->joinWith('datetype1'); $task_type_date_1_to = explode('-', $this->task_type_date_1_to); $task_type_date_1_to_formatted = $task_type_date_1_to[2] . '-' . $task_type_date_1_to[1] . '-' . $task_type_date_1_to[0]; $query->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_1_to_formatted . "','{$this->dateFormat}')")]); } } } if ($this->task_type_date_4_from != '' && $this->task_type_date_4_to != '') { $query->joinWith('datetype4'); $task_type_date_4_from = explode('-', $this->task_type_date_4_from); $task_type_date_4_from_formatted = $task_type_date_4_from[2] . '-' . $task_type_date_4_from[1] . '-' . $task_type_date_4_from[0]; $task_type_date_4_to = explode('-', $this->task_type_date_4_to); $task_type_date_4_to_formatted = $task_type_date_4_to[2] . '-' . $task_type_date_4_to[1] . '-' . $task_type_date_4_to[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_4_from_formatted . "','{$this->dateFormat}')")])->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_4_to_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_4_from != '' && $this->task_type_date_4_to == '') { $query->joinWith('datetype4'); $task_type_date_4_from = explode('-', $this->task_type_date_4_from); $task_type_date_4_from_formatted = $task_type_date_4_from[2] . '-' . $task_type_date_4_from[1] . '-' . $task_type_date_4_from[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_4_from_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_4_from == '' && $this->task_type_date_4_to != '') { $query->joinWith('datetype4'); $task_type_date_4_to = explode('-', $this->task_type_date_4_to); $task_type_date_4_to_formatted = $task_type_date_4_to[2] . '-' . $task_type_date_4_to[1] . '-' . $task_type_date_4_to[0]; $query->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_4_to_formatted . "','{$this->dateFormat}')")]); } } } if ($this->task_type_date_2_from != '' && $this->task_type_date_2_to != '') { $query->joinWith('datetype2'); $task_type_date_2_from = explode('-', $this->task_type_date_2_from); $task_type_date_2_from_formatted = $task_type_date_2_from[2] . '-' . $task_type_date_2_from[1] . '-' . $task_type_date_2_from[0]; $task_type_date_2_to = explode('-', $this->task_type_date_2_to); $task_type_date_2_to_formatted = $task_type_date_2_to[2] . '-' . $task_type_date_2_to[1] . '-' . $task_type_date_2_to[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_2_from_formatted . "','{$this->dateFormat}')")])->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_2_to_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_2_from != '' && $this->task_type_date_2_to == '') { $query->joinWith('datetype2'); $task_type_date_2_from = explode('-', $this->task_type_date_2_from); $task_type_date_2_from_formatted = $task_type_date_2_from[2] . '-' . $task_type_date_2_from[1] . '-' . $task_type_date_2_from[0]; $query->andFilterWhere(['>=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_2_from_formatted . "','{$this->dateFormat}')")]); } else { if ($this->task_type_date_2_from == '' && $this->task_type_date_2_to != '') { $query->joinWith('datetype2'); $task_type_date_2_to = explode('-', $this->task_type_date_2_to); $task_type_date_2_to_formatted = $task_type_date_2_to[2] . '-' . $task_type_date_2_to[1] . '-' . $task_type_date_2_to[0]; $query->andFilterWhere(['<=', 'TASK_DATES.TASK_TYPE_DATE', new \yii\db\Expression("to_date('" . $task_type_date_2_to_formatted . "','{$this->dateFormat}')")]); } } } $query->andFilterWhere(['like', 'SOURCENUM', $this->SOURCENUM]); $query->andFilterWhere(['like', 'TASK_TEXT', $this->TASK_TEXT]); $query->andFilterWhere(['or like', 'PEOORDERNUM', $this->PEOORDERNUM]); $query->andFilterWhere(['or like', 'ORDERNUM', $this->ORDERNUM]); $query->andFilterWhere(['like', 'TASK_NUMBER', $this->TASK_NUMBER]); $query->andFilterWhere(['like', 'LOWER(DESIGNATION)', mb_strtolower($this->DESIGNATION, 'UTF-8')]); return $dataProvider; }
public function actionLogin() { $this->layout = 'empty'; if (!\Yii::$app->user->isGuest) { return $this->goHome(); } $model = new LoginForm(); if ($model->load(Yii::$app->request->post()) && $model->login()) { //записываем в таблицу TRANSACTIONS данные $transactions = new Transactions(); $transactions->TN = new \yii\db\Expression('TO_NUMBER(' . \Yii::$app->user->id . ')'); $transactions->TRACT_DATETIME = new \yii\db\Expression('SYSDATE'); $transactions->USER_IP = $_SERVER['REMOTE_ADDR']; $transactions->insert(); //заносим в сессию данные пользователя $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_DOLG_PODR')->innerJoin('STIGIT.V_F_SHRAS', 'STIGIT.V_DOLG_PODR.IDDOLG = STIGIT.V_F_SHRAS.IDDOLG ')->where('TN = \'' . \Yii::$app->user->id . '\''); $command = $query->createCommand(); $user_dolg_podr_data = $command->queryAll(); $user_dolg_podr_data_block = 'табельный номер: <b>' . \Yii::$app->user->id . '</b>'; if ($user_dolg_podr_data) { $iddolg_array = []; $idpodr_array = []; foreach ($user_dolg_podr_data as $data_dolg_podr) { if (!empty($data_dolg_podr['NAIMDOLG'])) { if (!in_array($data_dolg_podr['IDDOLG'], $iddolg_array)) { $user_dolg_podr_data_block .= ', должность <b>' . $data_dolg_podr['NAIMDOLG'] . '</b>'; $iddolg_array[] = $data_dolg_podr['IDDOLG']; \Yii::$app->session->set('user.user_iddolg', $data_dolg_podr['IDDOLG']); } } if (!empty($data_dolg_podr['KODPODR_M'])) { if (!in_array($data_dolg_podr['KODPODR_M'], $idpodr_array)) { //get podr $query_kodzifr = new \yii\db\Query(); $query_kodzifr->select('NAIMPODR AS naimpodr, KODZIFR as kodzifr')->from('STIGIT.V_F_PODR')->where('KODPODR = \'' . $data_dolg_podr['KODPODR_M'] . '\''); $command_kodzifr = $query_kodzifr->createCommand(); $naimpodr_data = $command_kodzifr->queryOne(); if ($naimpodr_data) { $user_dolg_podr_data_block .= '<br>руководимое подразделение: <b>' . $naimpodr_data['naimpodr'] . '</b>'; \Yii::$app->session->set('user.user_boss_of', $naimpodr_data['kodzifr']); } $idpodr_array[] = $data_dolg_podr['KODPODR_M']; } } } } \Yii::$app->session->set('user.user_dolg_podr_data_block', $user_dolg_podr_data_block); return $this->goBack(); } else { return $this->render('login', ['model' => $model]); } }
public function actionNikIbuList($q = null, $id = null) { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $out = ['results' => ['id' => '', 'text' => '']]; if (!is_null($q)) { $query = new \yii\db\Query(); $query->select('base.nik AS id, base.nik AS text')->from('base')->innerJoin('base_updatable', 'base.nik = base_updatable.nik')->andWhere(['base_updatable.status_keluarga' => 2, 'base.jenis_kelamin' => 2])->andWhere(['like', 'base.nik', $q])->limit(20); $command = $query->createCommand(); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $out['results'] = ['id' => $id, 'text' => BaseUpdatable::find($id)->nik]; } return $out; }
/** * Detail * Status : Oke * @return mixed */ public function actionDetailClassified($id) { $modelReport = new \common\models\ReportClassified(); $query = new \yii\db\Query(); $query->select(['classified.id', 'classified.title', 'classified.description', 'classified.price', 'classified.create_at', 'classified.user_id', 'classified.type', 'main_category.main_category', 'category.category', 'country.country', 'region.region', 'city.city'])->from('classified')->join('JOIN', 'category', 'category.id = classified.category_id')->join('JOIN', 'main_category', 'main_category.id = classified.main_category_id')->join('JOIN', 'country', 'country.id = classified.country_id')->join('JOIN', 'region', 'region.id = classified.region_id')->join('JOIN', 'city', 'city.id = classified.city_id')->where(['classified.id' => $id])->all(); $command = $query->createCommand(); $data = $command->queryAll(); return $this->render('detail-classified', ['data' => $data, 'modelReport' => $modelReport]); }
public function actionFind($q = null, $id = null) { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $out = ['results' => ['id' => '', 'nombre' => '']]; if (!is_null($q)) { $query = new \yii\db\Query(); $query->select('id, nombre')->from('persona')->where(['like', 'nombre', $q])->limit(10); $command = $query->createCommand(); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $out['results'] = ['id' => $id, 'nombre' => Persona::find($id)->nombre]; } return $out; }
public function actionAjaxSearchAddons() { Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $result = ['more' => false, 'results' => []]; $search = Yii::$app->request->get('search'); if (!empty($search['term'])) { $query = new \yii\db\Query(); $query->select('id, name as text, price, currency_id')->from(Addon::tableName())->andWhere(['like', 'name', $search['term']])->orderBy(['name' => SORT_ASC]); $command = $query->createCommand(); $data = $command->queryAll(); $data = array_map(function ($item) { $currency = Currency::findById($item['currency_id']); $price = $currency->format($item['price']); $item['text'] .= ' - ' . $price; return $item; }, $data); $result['results'] = array_values($data); } return $result; }
echo $dataUserFree['name']; ?> </a></li> <?php } } } elseif ($row['type'] == 1) { // Query user, cek {username} user $query = new yii\db\Query(); $query->select(['username', 'id'])->from('user')->where(['id' => $row['user_id']]); $command = $query->createCommand(); $dataUserLogin = $command->queryAll(); //query profile, cek {name} profile $queryProfile = new yii\db\Query(); $queryProfile->select(['profile.user_id', 'profile.name'])->from('profile')->where(['user_id' => $row['user_id']]); $commandProfile = $queryProfile->createCommand(); $dataProfile = $commandProfile->queryAll(); foreach ($dataProfile as $dataProfile) { if ($dataProfile['name'] == null) { foreach ($dataUserLogin as $dataUserLogin) { if ($row['user_id'] == $dataUserLogin['id']) { ?> <li><i class="fa fa-user"></i> Posted by : <a href="#"><?php echo $dataUserLogin['username']; ?> </a></li> <?php } } } else { if ($row['user_id'] == $dataProfile['user_id']) {
<?php echo $this->render('_cover', ['modelCover' => $modelCover]); ?> <div class="row"> <div class="col-lg-12"> <div class="panel"> <div class="panel-heading text-center"> <?php //query user $queryUser = new \yii\db\Query(); $queryUser->select(['user.username'])->from('user')->where(['id' => $modelCover->user_id])->all(); $commandUser = $queryUser->createCommand(); $dataUser = $commandUser->queryAll(); ?> <?php foreach ($data as $row) { ?> <?php if (empty($row['name'])) { ?> <h2>Hello, I am <strong><?php foreach ($dataUser as $dataUser) { echo $dataUser['username']; } ?> </strong></h2>
public function actionSearch($q = null, $id = null, $type = 0) { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; $out = ['results' => ['id' => '', 'text' => '']]; if (!is_null($q)) { $query = new \yii\db\Query(); $query->select('id, name AS text')->from('{{%accounts}}')->where('name LIKE "%' . $q . '%"')->andWhere(['type' => $type])->limit(20); $command = $query->createCommand(); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $out['results'] = ['id' => $id, 'text' => Accounts::find($id)->name]; } return $out; }
public function actionExcel() { /* Проверка на доступ пользователя к странице */ $permissions_report_task_search = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :dolg_id and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action)', ['subject_type_dolg' => 1, 'dolg_id' => \Yii::$app->session->get('user.user_iddolg'), 'action' => 82, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 0])->one(); if ($permissions_report_task_search) { /* Проверяем получены ли идентификаторы заданий для формирования отчета */ if (Yii::$app->request->get('ids')) { $issues_ids = Yii::$app->request->get('ids'); $issues_ids = explode(',', $issues_ids); /* Делаем выборку необходимых заданий */ $model = \app\models\Tasks::find()->where(['ID' => $issues_ids])->all(); if ($model) { // Создаем объект класса PHPExcel $xls = new \PHPExcel(); // Устанавливаем индекс активного листа $xls->setActiveSheetIndex(0); // Получаем активный лист $sheet = $xls->getActiveSheet(); // Подписываем лист $sheet->setTitle('Отчет по отобранным заданиям'); $sheet->getStyle('A1')->getFont()->setBold(true); // Вставляем текст в ячейку A1 $sheet->setCellValue("A1", 'Отчет по отобранным заданиям'); $sheet->getStyle('A1')->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('A1')->getFill()->getStartColor()->setRGB('EEEEEE'); // Объединяем ячейки $sheet->mergeCells('A1:I1'); // Выравнивание текста $sheet->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); // Формируем шапку $sheet->setCellValue("A2", 'Заказ ПЭО'); $sheet->setCellValue("B2", 'Номер заказа'); $sheet->setCellValue("C2", 'Проект/Тема'); $sheet->setCellValue("D2", 'Обозначение'); $sheet->setCellValue("E2", 'Наименование'); $sheet->setCellValue("F2", 'Срок выполнения'); $sheet->setCellValue("G2", 'Статус'); $sheet->setCellValue("H2", 'Ф.И.О. и Дата'); $sheet->setCellValue("I2", 'Форматов А4'); /* устанавливаем ширину колонок и стили*/ $sheet->getStyle('A2:I2')->getFont()->setBold(true); $sheet->getColumnDimension('A')->setAutoSize(true); $sheet->getColumnDimension('B')->setAutoSize(true); $sheet->getColumnDimension('C')->setAutoSize(true); $sheet->getColumnDimension('D')->setAutoSize(true); $sheet->getColumnDimension('E')->setAutoSize(true); $sheet->getColumnDimension('F')->setAutoSize(true); $sheet->getColumnDimension('G')->setWidth(20); $sheet->getColumnDimension('H')->setAutoSize(true); $sheet->getColumnDimension('I')->setAutoSize(true); $row_number = 3; foreach ($model as $task) { $sheet->setCellValue("A" . $row_number, $task->PEOORDERNUM); $sheet->setCellValue("B" . $row_number, $task->ORDERNUM); $sheet->setCellValue("C" . $row_number, ''); $sheet->setCellValue("D" . $row_number, $task->TASK_NUMBER); $sheet->setCellValue("E" . $row_number, 'Задание'); $sheet->setCellValue("F" . $row_number, \Yii::$app->formatter->asDate($task->DEADLINE, 'php:d-m-Y')); //вставляем информацию по статусам $task_states = \app\models\TaskStates::find()->where(['TASK_ID' => $task->ID])->orderBy('STATE_ID ASC')->all(); if ($task_states) { foreach ($task_states as $state) { $state_date = $state->getStateDate(); $logo = new \PHPExcel_Worksheet_Drawing(); $logo->setPath(Yii::getAlias('@webroot') . '/images/items_status/' . $state->getStateColour() . '.png'); $logo->setCoordinates("G" . $row_number); $logo->setOffsetX(5); $logo->setOffsetY(2); $logo->setResizeProportional(true); $logo->setWidth(16); $logo->setWorksheet($sheet); $sheet->setCellValue("G" . $row_number, ' ' . $state->getStateName()); $pers_tasks = \app\models\PersTasks::findOne($state->PERS_TASKS_ID); $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PERS')->where('TN = \'' . $pers_tasks->TN . '\''); $command = $query->createCommand(); $data = $command->queryOne(); $sheet->setCellValue("H" . $row_number, $data['FIO'] . ' ' . $state_date); $task_docs = \app\models\TaskDocs::find()->where(['PERS_TASKS_ID' => $state->PERS_TASKS_ID])->one(); if ($task_docs) { $quantity = $task_docs->FORMAT_QUANTITY; } else { $quantity = 0; } $sheet->setCellValue("I" . $row_number, $quantity); $row_number++; } } $row_number++; } //стили для рамки таблицы $styleArray = array('borders' => array('allborders' => array('style' => \PHPExcel_Style_Border::BORDER_THIN))); $total_rows = $row_number - 1; $sheet->getStyle('A1:I' . $total_rows)->applyFromArray($styleArray); //параметры страницы для печати - альбомная $xls->getActiveSheet()->getPageSetup()->setOrientation(\PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE); $xls->getActiveSheet()->getPageSetup()->setPaperSize(\PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); $xls->getActiveSheet()->getPageSetup()->setFitToPage(true); $xls->getActiveSheet()->getPageSetup()->setFitToWidth(1); $xls->getActiveSheet()->getPageSetup()->setFitToHeight(0); // Выводим HTTP-заголовки header("Expires: Mon, 1 Apr 1974 05:00:00 GMT"); header("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=report.xls"); //Выводим содержимое файла $objWriter = new \PHPExcel_Writer_Excel5($xls); $objWriter->save('php://output'); } else { /* Вызываем эксепшн в случае, если были переданы не верные параметры заданий */ throw new \yii\web\NotFoundHttpException('Что-то пошло не так. Пожалуйста, обратитесь к администратору системы.'); } } } else { /* Вызываем эксепшн в случае, если доступ к формированию отчета запрещен */ throw new \yii\web\ForbiddenHttpException('У Вас нет прав на редактирование "Формирование отчета"'); } }
public function actionSelectedStudentList() { if (!empty($_REQUEST['studentlistexport'])) { $query = $_SESSION['query']; $selected_list = $_SESSION['selected_list']; $query1 = new \yii\db\Query(); $query1->select('*')->from('stu_master stu')->join('join', 'stu_info s_info', 's_info.stu_info_id = stu.stu_master_stu_info_id')->join('join', 'stu_address add', 'add.stu_address_id = stu.stu_master_stu_address_id')->where($query . 'stu.is_status = 0'); $command = $query1->createCommand(); $student_data = $command->queryAll(); $html = $this->renderPartial('stu_info_report_pdf', array('student_data' => $student_data, 'selected_list' => $selected_list)); ob_clean(); return Yii::$app->pdf->exportData('Student Info Report', 'Student_info_report', $html); } else { if (!empty($_REQUEST['studentlistexcelexport'])) { $query = $_SESSION['query']; $selected_list = $_SESSION['selected_list']; $query1 = new \yii\db\Query(); $query1->select('*')->from('stu_master stu')->join('join', 'stu_info s_info', 's_info.stu_info_id = stu.stu_master_stu_info_id')->join('join', 'stu_address add', 'add.stu_address_id = stu.stu_master_stu_address_id')->where($query . 'stu.is_status = 0'); $command = $query1->createCommand(); $student_data = $command->queryAll(); $file = $this->renderPartial('stu_info_report_excel', array('student_data' => $student_data, 'selected_list' => $selected_list)); $fileName = "Student_info_report" . date('YmdHis') . '.xls'; $options = ['mimeType' => 'application/vnd.ms-excel']; return Yii::$app->excel->exportExcel($file, $fileName, $options); } else { $query = $_SESSION['query']; $selected_list = null; } } }
public function _checkPermissions($action, $task_id) { switch ($action) { case 'open_issue_modal': //проверка прав на просмотр задания (в модальном окне) $permissions_for_open_issue_modal = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and PERM_TYPE = :perm_type) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :dolg_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and PERM_TYPE = :perm_type)', ['subject_type_dolg' => 1, 'dolg_id' => \Yii::$app->session->get('user.user_iddolg'), 'perm_type' => 1, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 0, 'action' => 3])->one(); if ($permissions_for_open_issue_modal) { //в случае если есть доступ на просмотр данных о задании $user_in_persons_or_podr_list = false; //получаем массив подразделений задания $podr_tasks = \app\models\PodrTasks::find()->where(['TASK_ID' => $task_id, 'DEL_TRACT_ID' => 0])->all(); if ($podr_tasks) { // если существуют подразделения, то формируем их список $podr_list_kodzifr_array = []; foreach ($podr_tasks as $task) { //обходим список подразделений $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PODR')->where('KODZIFR = \'' . trim($task->KODZIFR) . '\''); $command = $query->createCommand(); $data = $command->queryOne(); if (isset($data['KODZIFR'])) { // проверяем на существование названия подразделения (на момент разработки не для всех были названия) $podr_list_kodzifr_array[] = $data['KODZIFR']; } } } //проверяем входит ли данный пользователь в список исполнителей задания //получаем список пользователей, кому назначено задание $pers_tasks = \app\models\PersTasks::find()->where(['TASK_ID' => $task_id, 'DEL_TRACT_ID' => 0])->all(); if ($pers_tasks) { // если существуют исполнители, то формируем их список $persons_array = []; foreach ($pers_tasks as $task) { $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PERS')->where('TN = \'' . $task->TN . '\''); $command = $query->createCommand(); $data = $command->queryOne(); $persons_array[] = $data['TN']; } //проверяем, входит ли пользователь в этот список if (in_array(\Yii::$app->user->id, $persons_array)) { //пользователь входит в список исполнителей $user_in_persons_or_podr_list = true; } } else { //в этом случае, задания назначено всем исполнителям из списка подразделений задания $persons_array = []; //обходим массив подразделений для проверки, входит ли в него текущий пользователь $ids = join(',', $podr_list_kodzifr_array); $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PERS')->where('TN = \'' . \Yii::$app->user->id . '\' and KODZIFR in (' . $ids . ')'); $command = $query->createCommand(); $data = $command->queryAll(); if (!empty($data)) { // проверяем вхождение пользователя в список исполнителей подразделений задания $user_in_persons_or_podr_list = true; // текущий пользователь входит в подразделения, указанные в задании } } //проверяем, является ли пользователь начальником подразделений, указанных в задании //получаем список подчиненных подразделений $user_boss_of = \Yii::$app->session->get('user.user_boss_of'); if (!empty($user_boss_of) && !$user_in_persons_or_podr_list) { //проверяем, является ли пользователь начальником подразделений, указанных в задании if (in_array($user_boss_of, $podr_list_kodzifr_array)) { //пользователь является руководителем, но не входит в спиок исполнителей или указанных подразделений //осуществляем проверку прав на 'podr_tasks_my_edit' $permissions_for_open_issue_modal_for_boss = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and PERM_TYPE = :perm_type) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :dolg_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and PERM_TYPE = :perm_type)', ['subject_type_dolg' => 1, 'dolg_id' => \Yii::$app->session->get('user.user_iddolg'), 'perm_type' => 1, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 0, 'action' => 101])->one(); if ($permissions_for_open_issue_modal_for_boss) { //пользователю разрешен просмотр и редактирование заданий своего подразделения $user_in_persons_or_podr_list = true; } } } if ($user_in_persons_or_podr_list) { //пользователь имеет доступ к заданию, так как входит в список исполнителей выбранного задания, либо находится в составе подразделей задания, //либо является руководителем подразделений, указанных в задании return true; } } else { return false; } break; case 'open_issue_modal_in_current_status': //проверка прав на просмотр задания (в модальном окне) в текущем статусе задания //получаем текущий статус задания для данного пользователя $current_status = self::_getCurrentTaskStatusForCurrentUser($task_id); if ($current_status != 'empty_status' && $current_status != 'user_not_in_persons_list') { //проверяем есть ли доступ у пользователя к заданию в текущем статусе $permissions_for_open_issue_modal_in_current_status = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action and PERM_TYPE = :perm_type) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :id_dolg and DEL_TRACT_ID = :del_tract and PERM_LEVEL != :perm_level and ACTION_ID = :action and PERM_TYPE = :perm_type)', ['subject_type_dolg' => 1, 'id_dolg' => \Yii::$app->session->get('user.user_iddolg'), 'perm_type' => 2, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 0, 'action' => $current_status])->one(); if ($permissions_for_open_issue_modal_in_current_status) { //досутп на просмотр в текущем статусе разрешен return 'true'; } else { $state = \app\models\States::findOne($current_status); return 'У Вас нет прав на "Форма свойств задания" в статусе "' . $state->STATE_NAME . '"'; } } elseif ($current_status == 'empty_status') { //устанавливаем статус "Принято при первом открытии задания" $pers_tasks = \app\models\PersTasks::find()->where(['TASK_ID' => $task_id, 'TN' => \Yii::$app->user->id, 'DEL_TRACT_ID' => 0])->one(); $transactions = \app\models\Transactions::find()->where(['TN' => \Yii::$app->user->id])->orderBy('ID DESC')->one(); //пишем первый статус в БД $task_states = new \app\models\TaskStates(); $task_states->TASK_ID = $task_id; $task_states->STATE_ID = 1; $task_states->TRACT_ID = $transactions->ID; $task_states->IS_CURRENT = 1; if ($pers_tasks->ID) { // устанавливаем pers_tasks id $task_states->PERS_TASKS_ID = $pers_tasks->ID; } $task_states->save(); //разрешаем пользователю смотреть информацию по заданию return 'true'; } elseif ($current_status == 'user_not_in_persons_list') { //пользователь не стоит в списке исполнителей задания //проверяем, если он руководитель показываем информацию по заданию (остальные пользователи сбда не попадут из-за проверки выше) return 'true_for_boss'; } break; case 'update_issue': //проверяем, есть ли доступ на редактирование задания для исполнителей $permissions_for_update_issue = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL = :perm_level and PERM_TYPE = :perm_type) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :dolg_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL = :perm_level and PERM_TYPE = :perm_type)', ['subject_type_dolg' => 1, 'dolg_id' => \Yii::$app->session->get('user.user_iddolg'), 'perm_type' => 1, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 2, 'action' => 3])->one(); //проверка доступа на редактирование для руководителей $permissions_for_update_issue_boss = \app\models\Permissions::find()->where('(SUBJECT_TYPE = :subject_type and SUBJECT_ID = :user_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL = :perm_level and PERM_TYPE = :perm_type) or (SUBJECT_TYPE = :subject_type_dolg and SUBJECT_ID = :dolg_id and ACTION_ID = :action and DEL_TRACT_ID = :del_tract and PERM_LEVEL = :perm_level and PERM_TYPE = :perm_type)', ['subject_type_dolg' => 1, 'dolg_id' => \Yii::$app->session->get('user.user_iddolg'), 'perm_type' => 1, 'subject_type' => 2, 'user_id' => \Yii::$app->user->id, 'del_tract' => 0, 'perm_level' => 2, 'action' => 101])->one(); //проверяем кто редактирует задание $pers_tasks = \app\models\PersTasks::find()->where(['TASK_ID' => $task_id, 'DEL_TRACT_ID' => 0])->all(); if ($pers_tasks) { // если существуют исполнители, то формируем их список $persons_array = []; foreach ($pers_tasks as $task) { $query = new \yii\db\Query(); $query->select('*')->from('STIGIT.V_F_PERS')->where('TN = \'' . $task->TN . '\''); $command = $query->createCommand(); $data = $command->queryOne(); $persons_array[] = $data['TN']; } //проверяем, входит ли пользователь в этот список if (in_array(\Yii::$app->user->id, $persons_array)) { //пользователь входит в список исполнителей $user_is_person = 1; } else { $user_is_person = 0; } } if ($permissions_for_update_issue && $user_is_person == 1) { return 'update_issue_for_person'; } elseif ($permissions_for_update_issue_boss && $user_is_person == 0) { return 'update_issue_for_boss'; } else { return false; } break; } }
public function actionMobilelistxxx() { $this->layout = 'wapy'; // $gh_id = U::getSessionParam('gh_id'); // $openid = U::getSessionParam('openid'); $gh_id = MGh::GH_XIANGYANGUNICOM; $openid = MGh::GH_XIANGYANGUNICOM_OPENID_KZENG; Yii::$app->wx->setGhId($gh_id); $models = MItem::find()->where(['kind' => MItem::ITEM_KIND_MOBILE])->orderBy(['price' => SORT_ASC])->all(); $query = new \yii\db\Query(); $query->select('*')->from(\app\models\MActivity::tableName())->where(['status' => 1])->orderBy(['id' => SORT_DESC])->all(); $rows = $query->createCommand()->queryAll(); foreach ($models as &$model) { foreach ($rows as &$row) { $ids = explode(",", $row['iids']); if (in_array($model['iid'], $ids)) { $model['price'] = $model['price'] * $row['discount'] / 10; $model['title_hint'] = "<span class='activity'>限时促销!</span> " . $model['title_hint']; } } } return $this->render('mobilelist', ['gh_id' => $gh_id, 'openid' => $openid, 'models' => $models]); }
<?php use yii\helpers\Html; $adminUser = array_keys(\Yii::$app->authManager->getRolesByUser(Yii::$app->user->getId())); $stu_guard = new \yii\db\Query(); $stu_guard->select('*')->from('stu_guardians sg')->where(['sg.guardia_stu_master_id' => $_REQUEST['id']]); $command = $stu_guard->createCommand(); $stu_data = $command->queryAll(); ?> <div class="row"> <div class="col-xs-12 col-md-12 col-lg-12"> <h2 class="page-header"> <i class="fa fa-info-circle"></i> <?php echo Html::encode(Yii::t('stu', 'Guardians Details')); ?> <div class="<?php echo Yii::$app->language == 'ar' ? 'pull-left' : 'pull-right'; ?> "> <?php if (Yii::$app->user->can('/student/stu-master/addguardian')) { ?> <?php echo Html::a('<i class="fa fa-user-plus"></i> ' . Yii::t('stu', 'Add Guardian'), ['addguardian', 'sid' => $model->stu_master_id], ['class' => 'btn-sm btn btn-primary text-warning', 'id' => 'update-guard-data']); ?> <?php } ?> </div> </h2>
</p> <?php } else { ?> <p><?php echo $row['name']; ?> </p> <?php } ?> <?php $queryJoined = new yii\db\Query(); $queryJoined->select(['created_at'])->from('user')->where(['id' => Yii::$app->user->identity->id])->all(); $commandJoined = $queryJoined->createCommand(); $dataJoined = $commandJoined->queryAll(); ?> <?php foreach ($dataJoined as $rowJoined) { ?> <p>Joined : <?php echo Yii::$app->formatter->format($rowJoined['created_at'], 'date'); ?> </p> <?php } ?>
echo $dataUser['id']; ?> " target="_blank" class="btn btn-sm bg-orange btn-flat no-margin pull-right">Go to my page <i class="fa fa-arrow-circle-o-right"></i></a> </div> <?php } ?> <?php } else { ?> <?php $queryUserFree = new yii\db\Query(); $queryUserFree->select(['name', 'email', 'phone'])->from('classified_guest')->where(['id' => $dataView['user_id']])->all(); $commandUserFree = $queryUserFree->createCommand(); $dataUserFree = $commandUserFree->queryAll(); ?> <?php foreach ($dataUserFree as $dataUserFree) { ?> <div style="margin-top: 0px; text-align: center"> <p><b><?php echo $dataUserFree['name']; ?> </b></p> </div> <div> Phone : <?php echo $dataUserFree['phone'];
/** * TODO: Only translate tags urls if tag is available for the specific language * @param integer $limit * @return array */ public function getAllTags($limit = 20) { if ($this->allTags == null) { $allTags = array(); $query = new \yii\db\Query(); $query->select('tags_list')->from('blog_post_lang')->innerJoin('blog_post', 'blog_post.id=blog_post_lang.blog_post_id')->where(['is_published' => true])->andWhere(['<>', 'blog_post_lang.slug', ''])->andWhere(['blog_post_lang.language' => Yii::$app->language]); $command = $query->createCommand(); $posts = $command->queryAll(); foreach ($posts as $post) { $tags_array = explode(",", $post['tags_list']); foreach ($tags_array as $tag) { $tag = trim($tag); if (!empty($tag)) { if (!isset($allTags[$tag])) { $allTags[$tag] = 1; } else { $allTags[$tag] = $allTags[$tag] + 1; } } } } arsort($allTags); $this->allTags = array_keys($allTags); $this->allTags = array_slice($this->allTags, 0, $limit); } return $this->allTags; }
public function actionSelectedEmployeeList() { if (!empty($_REQUEST['employeelistexport'])) { $query = null; $query = $_SESSION['query']; $selected_list = $_SESSION['selected_list']; $query1 = new \yii\db\Query(); $query1->select('*')->from('emp_master emp')->join('join', 'emp_info e_info', 'e_info.emp_info_id = emp.emp_master_emp_info_id')->join('join', 'emp_department emp_dep', 'emp_dep.emp_department_id = emp.emp_master_department_id ')->join('join', 'emp_designation emp_des', 'emp_des.emp_designation_id = emp.emp_master_designation_id ')->join('join', 'emp_category emp_cat', 'emp_cat.emp_category_id = emp. emp_master_category_id')->leftJoin('emp_address eadd', 'eadd.emp_address_id = emp.emp_master_emp_address_id')->where($query . 'emp.is_status = 0'); $command = $query1->createCommand(); $employee_data = $command->queryAll(); $html = $this->renderPartial('emp_info_report_pdf', array('employee_data' => $employee_data, 'selected_list' => $selected_list)); ob_clean(); return Yii::$app->pdf->exportData('Employee Info Report', 'Employee_info_report', $html); } else { if (!empty($_REQUEST['employeelistexcelexport'])) { $query = null; $query = $_SESSION['query']; $selected_list = $_SESSION['selected_list']; $query1 = new \yii\db\Query(); $query1->select('*')->from('emp_master emp')->join('join', 'emp_info e_info', 'e_info.emp_info_id = emp.emp_master_emp_info_id')->join('join', 'emp_department emp_dep', 'emp_dep.emp_department_id = emp.emp_master_department_id ')->join('join', 'emp_designation emp_des', 'emp_des.emp_designation_id = emp.emp_master_designation_id ')->join('join', 'emp_category emp_cat', 'emp_cat.emp_category_id = emp. emp_master_category_id')->leftJoin('emp_address eadd', 'eadd.emp_address_id = emp.emp_master_emp_address_id')->where($query . 'emp.is_status = 0'); $command = $query1->createCommand(); $employee_data = $command->queryAll(); $file = $this->renderPartial('emp_info_report_excel', array('employee_data' => $employee_data, 'selected_list' => $selected_list)); $fileName = "Employee_info_report" . date('YmdHis') . '.xls'; $options = ['mimeType' => 'application/vnd.ms-excel']; return Yii::$app->excel->exportExcel($file, $fileName, $options); } else { $query = $_SESSION['query']; $selected_list = null; } } }