/**
* Ü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));
}
