/** * Übersicht der Dokumente welche zur Veröffentlichung anstehen * * @return \yii\web\View */ public function actionPublish() { error_reporting(E_ALL); Yii::$app->view->params['headline'] = 'Ausstehende Publizierungen'; $model = new ActiveDataProvider(['query' => Documents::find()->where(['regex', 'updated_by', '/./'])->orderBy("filename"), 'pagination' => ['pageSize' => 15]]); return $this->render('publish', ['model' => $model]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Documents::find(); $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, 'created' => $this->created]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'text', $this->text]); return $dataProvider; }
public function getkycinfo() { $email = $this->request->query['email']; $kycid = $this->request->query['kycid']; if ($email == "" || $kycid == "") { return $this->render(array('json' => array('success' => 0))); } $document = Documents::find('first', array('conditions' => array('email' => $email, 'kyc_id' => $kycid))); $encrypt = $document['hash']; // print_r($function->decrypt($encrypt,CONNECTION_DB_KYC)); if (count($document) == 1) { return $this->render(array('json' => array('success' => 1, 'id' => $encrypt))); } else { return $this->render(array('json' => array('success' => 0))); } }
public function save($id = null) { $user = Session::read('member'); if ($user == "") { return $this->redirect('/'); } // $id = md5($user['email']); if ($id != "") { $data = array("Saved" => "Yes"); $conditions = array('_id' => $id); Documents::update($data, $conditions); $this->redirect("ex::dashboard"); } $detail = Details::find('first', array('conditions' => array('user_id' => (string) $user['_id']))); $option = 'fileType'; $document = Documents::find('first', array('conditions' => array('details_doc_id' => (string) $detail['_id'], 'Saved' => null))); $rates = Rates::find('first', array('conditions' => array('Min' => array('$lte' => intval($document['document']['Pages'])), 'Max' => array('$gte' => intval($document['document']['Pages']))))); return compact('document', 'rates'); }
/** * Filtern und Sortieren der Documente * * @param type $params * @return ActiveDataProvider * @author KAS <*****@*****.**> */ public function search($params) { $query = Documents::find(); // $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 15]]); // Sortieren setzen ---------------------------------------------------- $dataProvider->setSort(['defaultOrder' => ['filename' => SORT_ASC], 'attributes' => ['metadata.TITEL' => ['asc' => ['metadata.TITEL' => SORT_ASC], 'desc' => ['metadata.TITEL' => SORT_DESC]], 'filename' => ['asc' => ['filename' => SORT_ASC], 'desc' => ['filename' => SORT_DESC]], 'onlineStatus' => ['asc' => ['onlineStatus' => SORT_ASC], 'desc' => ['onlineStatus' => SORT_DESC]]]]); // Setzen der Get Parameter -------------------------------------------- $this->setAttributes($params); // Filter für Status --------------------------------------------------- if ($this->onlineStatus !== "" and $this->onlineStatus !== NULL) { // Boolean aus string erzeugen (testen ob auch (bool)$this->onlineStatus gehen würde) $this->onlineStatus = $this->onlineStatus === "false" ? false : true; $query->filterWhere(['onlineStatus' => $this->onlineStatus]); } // Sonstige Filter ----------------------------------------------------- $query->andFilterWhere(['like', 'filename', $this->filename]); $query->andFilterWhere(['like', 'metadata.ZSTITEL', $this->zs]); $query->andFilterWhere(['like', 'metadata.TITEL', $this->titel]); $query->andFilterWhere(['like', 'groups', $this->group]); //---------------------------------------------------------------------- return $dataProvider; }
public static function getAllgroups() { $arr = Documents::find()->distinct('groups'); return array_combine(array_values($arr), array_values($arr)); }
public function checkCompanyemail() { $email = strtolower($this->request->query['email']); $uuid = new Uuid(); $emails = Documents::find('first', array('conditions' => array('email' => $email))); if (count($emails) === 0) { $kyc_id = $uuid->v4v(); $email_code = substr($kyc_id, 0, 4); $data = array('kyc_id' => $kyc_id, 'email_code' => $email_code, 'email' => $email, 'hash' => md5($email), 'IP' => $_SERVER['REMOTE_ADDR']); $Companies = Companies::create($data); $saved = $Companies->save(); } else { $emails = Companies::find('first', array('conditions' => array('email' => $email))); $kyc_id = $emails['kyc_id']; if ($emails['Verify']['Score'] >= 80) { return $this->render(array('json' => array('success' => 0, 'reason' => 'Aleredy KYC complete'))); } } /////////////////////////////////Email////////////////////////////////////////////////// $emaildata = array('kyc_id' => $kyc_id, 'email' => $email); $function = new Functions(); $compact = array('data' => $emaildata); $from = array(NOREPLY => "noreply@" . COMPANY_URL); $email = $email; $function->sendEmailTo($email, $compact, 'process', 'sendKYCCompany', "KYCGlobal - Email Code", $from, '', '', '', null); /////////////////////////////////Email////////////////////////////////////////////////// return $this->render(array('json' => array('success' => 1))); }
public function actionAddWishlist() { $request = Yii::$app->request; try { $doc_id = $request->post('doc_id', ''); $user_id = Yii::$app->session['user_id']; $check_doc = Documents::find()->where(['id' => $doc_id])->count(); if ($check_doc == 0) { return json_encode(Util::arrayError('Không tồn tại tài liệu này', '')); } if (empty($user_id)) { return json_encode(Util::arrayError('Bạn chưa đăng nhập', '')); } $result = Wishlist::add($doc_id, $user_id); return json_encode(Util::arraySuccess('Thành công', $result)); } catch (Exception $ex) { } }
public static function getDocumentsByWishlist($user) { $query = Documents::find()->join('JOIN', 'wishlist', '`wishlist`.`doc_id`=`documents`.`id`')->where(['wishlist.user_id' => $user])->orderBy('wishlist.created_at desc'); $countQuery = clone $query; $pages = new Pagination(['totalCount' => $countQuery->count()]); $pages->defaultPageSize = 27; $models = $query->offset($pages->offset)->limit($pages->limit)->all(); if (!Yii::$app->cache->exists('subjects')) { $subjects = Subjects::find()->orderBy('name', 'desc')->all(); Yii::$app->cache->add('subjects', $subjects, 3600); } else { $subjects = Yii::$app->cache->get('subjects'); } return ['models' => $models, 'pages' => $pages, 'subjects' => $subjects]; }
public function info($id = null) { $document = Documents::find('first', array('conditions' => array('kyc_id' => $id))); if (count($document) == 0) { return $this->render(array('json' => array("success" => 0))); } if ($document['Verify']['Percent'] > 60) { $success = 1; } else { $success = 0; } $data = array('success' => $success, 'kyc_id' => $document['kyc_id'], 'email' => $document['email'], 'details' => $document['details'], 'score' => $document['Verify']['Score'], 'percent' => $document['Verify']['Percent']); return $this->render(array('json' => $data)); }