/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$this->scenario = 'search';
$query = Document::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 100], 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]]]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'lft' => $this->lft, 'rgt' => $this->rgt, 'depth' => $this->depth, 'template_id' => $this->template_id, 'is_folder' => $this->is_folder, 'status' => $this->status]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'created_user_name', $this->created_user_name])->andFilterWhere(['like', 'updated_user_name', $this->updated_user_name])->andFilterWhere(['like', 'root_name', $this->root_name])->andFilterWhere(['like', 'parent_name', $this->parent_name])->andFilterWhere(['like', 'created_at', CFF::FormatData($this->created_at)])->andFilterWhere(['like', 'updated_at', CFF::FormatData($this->updated_at)])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'alias', $this->alias])->andFilterWhere(['like', 'annotation', $this->annotation])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'img', $this->img])->andFilterWhere(['like', 'meta_description', $this->meta_description])->andFilterWhere(['like', 'meta_keywords', $this->meta_keywords])->andFilterWhere(['>=', 'id', $this->id_from])->andFilterWhere(['<=', 'id', $this->id_till])->andFilterWhere(['<>', 'id', 1]);
for ($i = 1; $i <= Template::OPTIONS_COUNT; $i++) {
$option = 'option_' . $i;
$query->andFilterWhere(['like', $option, $this->{$option}]);
}
if ($this->created_at_from) {
$query->andFilterWhere(['>=', 'created_at', CFF::FormatData($this->created_at_from, false) . ' 00:00:00']);
}
if ($this->created_at_till) {
$query->andFilterWhere(['<=', 'created_at', CFF::FormatData($this->created_at_till, false) . ' 23:59:00']);
}
if ($this->updated_at_from) {
$query->andFilterWhere(['>=', 'updated_at', CFF::FormatData($this->updated_at_from, false) . ' 00:00:00']);
}
if ($this->updated_at_till) {
$query->andFilterWhere(['<=', 'updated_at', CFF::FormatData($this->updated_at_till, false) . ' 23:59:00']);
}
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Document::find();
$userlname = ArrayHelper::getValue(User::find()->where(['username' => Yii::$app->user->identity->username])->one(), 'userLName');
$userfname = ArrayHelper::getValue(User::find()->where(['username' => Yii::$app->user->identity->username])->one(), 'userFName');
$userfullname = $userlname . ', ' . $userfname;
$docname = ArrayHelper::getValue(Pendingdoc::find()->where(['pendingDocFName' => $userfullname])->one(), 'pendingDocName');
//$docname = Pendingdoc::find()->where(['pendingDocFName' => $userfullname])->one();
//$docname = 1;
$userid = ArrayHelper::getValue(User::find()->where(['username' => Yii::$app->user->identity->username])->one(), 'id');
//$query->where(['or', ['documentName'=>$docname], ['user_id'=>$userid]]);
//$query->where(['INNER JOIN', 'Pendingdoc', 'Pendingdoc.pendingDocName = documentName']);
$query->join('LEFT JOIN', 'pendingdoc', 'document.documentName = pendingdoc.pendingDocName')->where(['or', ['pendingdoc.pendingDocFName' => $userfullname], ['user_id' => $userid]]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$query->joinWith('priority');
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['documentTargetDate' => $this->documentTargetDate, 'category_id' => $this->category_id, 'type_id' => $this->type_id, 'user_id' => $this->user_id, 'companyAgency_id' => $this->companyAgency_id, 'section_id' => $this->section_id, 'documentCreate' => $this->documentCreate, 'documentUpdate' => $this->documentUpdate]);
$query->andFilterWhere(['like', 'document_tracking_number', $this->document_tracking_number])->andFilterWhere(['like', 'documentName', $this->documentName])->andFilterWhere(['like', 'documentDesc', $this->documentDesc])->andFilterWhere(['like', 'documentComment', $this->documentComment])->andFilterWhere(['like', 'documentImage', $this->documentImage])->andFilterWhere(['like', 'document.id', $this->id])->andFilterWhere(['like', 'priority.priorityName', $this->priority_id]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Document::find()->byResearch();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'research_id' => $this->research_id, 'document_type_id' => $this->document_type_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'filename', $this->filename])->andFilterWhere(['like', 'real_filename', $this->real_filename])->andFilterWhere(['like', 'status', $this->status]);
return $dataProvider;
}
/**
* @return array
* Вывод всех документов с ID массивом
*/
public static function getAll()
{
$documents = [];
$models = Document::find()->all();
if ($models) {
foreach ($models as $model) {
$documents[$model->id] = $model->name . " (" . $model->id . ")";
}
}
return $documents;
}
/**
* ดึงข้อมูลจาก model ที่ระบุด้วย $params
* @param array $params เงื่อนไขการดึงข้อมูล
* @return Document
*/
public function findByParams($params)
{
$query = Document::find();
$query->where(['type' => $params[self::ENCODE_ENTITY], 'refId' => $params[self::ENCODE_ID], 'itemNo' => $params[self::ENCODE_ITEMNO]]);
$model = $query->one();
return $model;
}
<?php
Modal::begin(['header' => '<h4>Documents</h4>', 'id' => 'modal']);
echo "<div id='modalContent'></div>";
Modal::end();
?>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'document_tracking_number', 'documentName', 'documentDesc', ['attribute' => 'priority_id', 'value' => 'priority.priorityName'], ['attribute' => 'Duration', 'format' => 'raw', 'value' => function ($model) {
$position = Yii::$app->user->identity->position_id;
//$today = date('Y-m-d H:i:s');
$today = null;
//$today = ArrayHelper::getValue(Docworkflow::find()->where(['document_id' => $model->id])->orderBy(['id'=>SORT_DESC])->one(), 'timeAccepted');
$today = ArrayHelper::getValue(Document::find()->where(['id' => $model->id])->one(), 'documentUpdate');
if ($today == null) {
$today = ArrayHelper::getValue(Document::find()->where(['id' => $model->id])->one(), 'documentCreate');
}
if ($position == 21 || $position == 22 || $position == 23 || $position == 24 || $position == 25 || $position == 26) {
if ($model->priority->priorityName == 'Urgent') {
$now = date('Y-m-d H:i:s', strtotime("{$today} + 8 hours"));
} else {
if ($model->priority->priorityName == 'High') {
$now = date('Y-m-d H:i:s', strtotime("{$today} + 3 days"));
} else {
if ($model->priority->priorityName == 'Medium') {
$now = date('Y-m-d H:i:s', strtotime("{$today} + 5 days"));
} else {
if ($model->priority->priorityName == 'Low') {
$now = date('Y-m-d H:i:s', strtotime("{$today} + 7 days"));
}
}
<?php
use common\models\Document;
$data = [];
$documents = Document::find()->orderBy('lft')->all();
if ($documents) {
foreach ($documents as $doc) {
$d = [];
$d['id'] = $doc->id;
$d['parent'] = $doc->parent_id ? $doc->parent_id : '#';
$d['text'] = $doc->name . ' <span class="node-id">(' . $doc->id . ')</span>';
if ($doc->is_folder) {
if ($doc->status) {
$d['icon'] = '/admin/css/image/icon-folder.png';
} else {
$d['icon'] = '/admin/css/image/icon-folder-disable.png';
}
} else {
if ($doc->status) {
$d['icon'] = '/admin/css/image/icon-file.png';
} else {
$d['icon'] = '/admin/css/image/icon-file-disable.png';
}
}
$d['status'] = $doc->status;
if (!$doc->depth) {
$d['state'] = ['opened' => true];
}
$data[] = $d;
}
}
public function actionRelease($id)
{
$model = $this->findModel($id);
$workflowid = ArrayHelper::getValue(Docworkflow::find()->where(['document_id' => $id])->orderBy(['id' => SORT_DESC])->one(), 'id');
//print_r($workflowid . ' level0 ' . $model->user_id);
if ($model->load(Yii::$app->request->post())) {
//$userid1 = ArrayHelper::getValue(User::find()->where(['username' => Yii::$app->user->identity->username])->one(), 'id');
$sectionid = ArrayHelper::getValue(Document::find()->where(['id' => $id])->one(), 'section_id');
$userFName = ArrayHelper::getValue(User::find()->where(['id' => $model->user_id])->one(), 'userFName');
$userLName = ArrayHelper::getValue(User::find()->where(['id' => $model->user_id])->one(), 'userLName');
$section = ArrayHelper::getValue(Section::find()->where(['id' => $sectionid])->one(), 'sectionName');
$documentname = ArrayHelper::getValue(Document::find()->where(['id' => $id])->one(), 'documentName');
$pendingdoc = new Pendingdoc();
$pendingdoc->pendingDocFName = $userLName . ', ' . $userFName;
$pendingdoc->pendingDocSection = $section;
$pendingdoc->pendingDocName = $documentname;
if ($workflowid == null) {
if ($pendingdoc->save()) {
print_r('level3');
return $this->redirect(['index']);
//return $this->redirect('index.php?r=pendingdoc');
}
} else {
$workflow1 = new Docworkflow();
$workflow1 = $this->findModelWorkflow($workflowid);
//$workflow1->id = $workflowid;
$workflow1->timeRelease = date('Y-m-d H:i:s');
//$workflow1->totalTimeSpent = date('Y-m-d H:i:s');
$workflow1->user_release = $model->user_id;
print_r('level1');
if ($workflow1->save()) {
print_r('level2');
if ($pendingdoc->save()) {
print_r('level3');
return $this->redirect(['index']);
//return $this->redirect('index.php?r=pendingdoc');
}
}
}
} else {
return $this->renderAjax('release', ['model' => $model]);
}
}
public function actionRelease($id)
{
//$model = $this->findModel($id);
$model = new Pendingdoc();
$userid = ArrayHelper::getValue(Document::find()->where(['id' => $id])->one(), 'user_id');
$userFName = ArrayHelper::getValue(User::find()->where(['id' => $userid])->one(), 'userFName');
$userLName = ArrayHelper::getValue(User::find()->where(['id' => $userid])->one(), 'userLName');
$section = ArrayHelper::getValue(Document::find()->where(['id' => $id])->one(), 'section_id');
$documentname = ArrayHelper::getValue(Document::find()->where(['id' => $id])->one(), 'documentName');
if ($model->load(Yii::$app->request->post())) {
$model->pendingDocFName = $userFName . $userLName;
$model->pendingDocSection = $section;
$model->pendingDocName = $documentname;
if ($model->save()) {
return $this->redirect(['document/index']);
}
} else {
return $this->renderAjax('release', ['model' => $model]);
}
}
protected function findDocuments($research_id)
{
if (count($model = Document::find()->byResearch($research_id)->all()) > 0) {
return $model;
} else {
$this->createDocument($research_id);
return $this->findDocuments($research_id);
}
}
private function doQuery()
{
$request = \Yii::$app->request;
$id = $request->post('id', $request->get('id', ''));
//เพิ่มการแสดงรูปสำหรับ type อื่น เช่น กิจกรรม
$type = Entity::TYPE_CONTENT;
if ($request->post('entity')) {
$request->post('entity');
}
$items = array();
$query = Document::find();
$query->andWhere('refId=:id AND type=:type', [':id' => $id, ':type' => $type]);
$items = Document::getItems($query, $options);
\Yii::$app->response->format = 'json';
echo json_encode($items);
}
