The method requires a $condition parameter, and optionally a $params parameter
specifying the values to be bound to the query.
The $condition parameter should be either a string (e.g. 'id=1') or an array.
/**
* Lists all Job models.
* @return mixed
*/
public function actionIndex()
{
$model = new Job();
// This is used to search/filter organizations
$dataProvider = null;
if (isset($_GET['user_id'])) {
$user_id = $_GET['user_id'];
if ($user_id !== null) {
$query = new Query();
$query->from(Job::tableName());
$query->where(['user_id' => $user_id]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 5]]);
}
} else {
$dataProvider = new ActiveDataProvider(['query' => Job::find(), 'pagination' => ['pageSize' => 5]]);
}
if ($model->load(Yii::$app->request->post())) {
$query = new Query();
$query->from(Job::tableName());
if (!is_null($model->employment_type) && is_array($model->employment_type)) {
$query->where(['employment_type' => array_map('intval', $model->employment_type)]);
}
if (!is_null($model->job_type) && is_array($model->job_type)) {
$query->where(['job_type' => array_map('intval', $model->job_type)]);
}
if (!is_null($model->work_domain) && is_array($model->work_domain)) {
$query->andWhere(['work_domain' => array_map('intval', $model->work_domain)]);
}
if (isset($_GET['user_id'])) {
$query->andWhere(['user_id' => $_GET['user_id']]);
}
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 5]]);
}
return $this->render('index', ['model' => $model, 'dataProvider' => $dataProvider]);
}
/**
* Prepare the DB query
*
* @return $this
*/
public function prepare()
{
// Throw a exception if a required parameter is not defined
$this->verifyRequiredParameters();
// Build the query
$this->query = new Query();
$this->query->select('*');
$this->query->from($this->getTableName());
$this->query->where('app_id=:appId', [':appId' => $this->appId]);
return $this;
}
public function retrieve($className, $primaryKey)
{
$tableName = call_user_func([$className, "tableName"]);
$current = $className::find()->where(['id' => $primaryKey])->asArray()->one();
$query = new Query();
$query->select(['field_name', 'old_value', 'event', 'action_uuid', 'created_at']);
$query->from($this->tableName);
$query->where(['field_id' => $primaryKey, 'table_name' => $tableName]);
$query->orderBy(['created_at' => SORT_ASC]);
$changes = [];
foreach ($query->all() as $element) {
$uuid = $element['action_uuid'];
if (!isset($changes[$uuid])) {
$changes[$uuid] = $current;
}
$changes[$uuid][$element['field_name']] = $element['old_value'];
$current = $changes[$uuid];
}
$models = array_map(function ($element) use($className) {
$model = $className::instantiate($element);
$className::populateRecord($model, $element);
return $model;
}, $changes);
return new ArrayDataProvider(['allModels' => array_values($models)]);
}
public function actionIndex($date = null)
{
// $apteki=LogReestr::find()->where(['resstr' => 'apteki'])->all();
if (!$date) {
$date = date('Y-m');
}
$db = new Query();
$db->from(LogReestr::tableName());
$db->select(['log_reestr.created_at', 'log_reestr.address', 'log_reestr.resstr', 'log_reestr.id_resstr', 'log_reestr.action', 'log_reestr.name', 'log_reestr.ur_l_id', 'log_reestr.id_resstr', 'log_reestr.change', 'users.username', 'log_reestr.id_resstr']);
$db->where(['=', 'resstr', 'apteki']);
$db->leftJoin('users', "users.id = log_reestr.user");
$db->orderBy('log_reestr.created_at DESC');
$date_search = $date . '%';
$db->andWhere(['like', 'log_reestr.created_at', $date_search, false]);
$apteki = $db->all();
// $apteki_count = $db->count();
$db = new Query();
$db->from(LogReestr::tableName());
$db->select(['log_reestr.created_at', 'log_reestr.address', 'log_reestr.resstr', 'log_reestr.id_resstr', 'log_reestr.name', 'log_reestr.action', 'log_reestr.change', 'users.username', 'log_reestr.id_resstr']);
$db->where(['=', 'resstr', 'ur_l']);
$db->leftJoin('users', "users.id = log_reestr.user");
$db->andWhere(['like', 'log_reestr.created_at', $date_search, false]);
$db->orderBy('log_reestr.created_at DESC');
$ur_l = $db->all();
// $ur_l_count = $db->count();
$statm = \Yii::$app->db->createCommand("SELECT users.username , COUNT(*) as count FROM log_reestr INNER JOIN users ON users.id=log_reestr.user\n where log_reestr.created_at like '" . $date . "%'\n GROUP BY USER order by count DESC");
$stat = $statm->queryAll();
$statAllm = \Yii::$app->db->createCommand("SELECT COUNT(*) as count FROM log_reestr\n where log_reestr.created_at like '" . $date . "%' ");
$statAll = $statAllm->queryOne();
return $this->render('index', ['apteki' => $apteki, 'ur_l' => $ur_l, 'date' => $date, 'stat' => $stat, 'statAll' => $statAll]);
}
/**
*
*/
public function getAll($where = null, $params = null)
{
$query = new Query();
$query->select('*')->from('forum_post');
if ($where != null) {
if (is_string($where)) {
$query->where($where);
} else {
throw new Exception('Erreur : la clause Where doit être une chaîne de caractères');
}
}
if ($params != null) {
foreach ($params as $k => $v) {
if ($k == 'orderBy') {
$query->orderBy = $v;
}
if ($k == 'limit') {
$query->limit = intval($v);
}
if ($k == 'offset') {
$query->offset = intval($v);
}
}
}
//var_dump($query);
$items = $query->all();
return $items;
}
public function GetItem($id = 0)
{
$query = new Query();
$query->from($this->table);
$query->where(["id" => $id]);
$result = $query->one();
return $result;
}
public static function getApteki($id)
{
$db = new Query();
//$db->select('id','name');
$db->where(['=', 'ur_l_id', $id]);
$db->from('apteki');
return $db->all();
}
public function getQuiz($id)
{
$query = new Query();
$query->select('quiz_questions.id as qid,quiz_questions.*,questions_answers.*')->from('quiz_questions');
$query->join('join', 'questions_answers', 'quiz_questions.id=question_id');
$query->where('quiz_questions.quiz_id=' . $id);
return $this->_group_by($query->all(), 'qid');
}
public function actionIndex()
{
$request = Yii::$app->request;
$menuId = 31;
$theadArray = QueryField::find()->where(['menuId' => $menuId])->asArray()->with('queryTable')->all();
$tables = QueryTable::find()->where(['menuId' => $menuId])->asArray()->all();
$masterTable = $this->getMasterTable($tables);
if (!$masterTable) {
$NullPages = new Pagination(['pageParam' => 'pageCurrent', 'pageSizeParam' => 'pageSize', 'totalCount' => 0, 'defaultPageSize' => 20]);
return $this->render('index', ['models' => [], 'pages' => $NullPages, 'theadArray' => []]);
}
$query = new Query();
$query->from($masterTable['tabName']);
$query->select($masterTable['tabName'] . '.' . 'id');
foreach ($tables as $table) {
if ($table['isMain'] != '1') {
$query->leftJoin($table['tabName'], $table['condition']);
}
}
//排序字段
$attributes = [];
//查询条件
$where = [];
foreach ($theadArray as $thead) {
if ($thead['queryTable']['reName']) {
$addSelect = $thead['queryTable']['reName'];
} else {
$addSelect = $thead['queryTable']['tabName'];
}
$addSelect = $addSelect . '.' . $thead['fieldName'];
if ($thead['makeTbName'] != 1) {
$addSelect = $thead['fieldName'];
}
if ($thead['reName']) {
//组装排序字段
array_push($attributes, $thead['reName']);
//查询字段
$addSelect = $addSelect . ' ' . 'as' . ' ' . $thead['reName'];
} else {
array_push($attributes, $thead['fieldName']);
}
$query->addSelect($addSelect);
//组装查询条件
if ($thead['isQuery'] == '1' && $thead['reName']) {
$where[$thead['reName']] = $request->get($thead['reName']);
} elseif ($thead['isQuery'] == '1') {
$where[$thead['fieldName']] = $request->get($thead['fieldName']);
}
}
$query->where($where);
$pages = new Pagination(['pageParam' => 'pageCurrent', 'pageSizeParam' => 'pageSize', 'defaultPageSize' => 20]);
$sort = new WetSort(['attributes' => $attributes]);
$provider = new ActiveDataProvider(['query' => $query, 'pagination' => $pages, 'sort' => $sort]);
$models = $provider->getModels();
return $this->render('index', ['models' => $models, 'pages' => $pages, 'theadArray' => $theadArray]);
}
public function getPermissionsByRole($role)
{
$query = new Query();
$query->select(['p.id', 'p.category', 'p.name', 'p.description', 'p.form', 'p.default_value', 'p.rule', 'p.sort_num', 'r.role', 'r.value']);
$query->from(['p' => $this->permissionTable, 'r' => $this->relationTable]);
$query->where('r.permission=p.id');
$query->andWhere(['r.role' => $role]);
$rows = $query->all();
return $this->convertPermissionValue($rows);
}
/**
* Возвращает кол-во элементов
* @param array $where
* @return int
*/
public function GetCountItems($where = [])
{
$query = new Query();
$query->select("id");
$query->from($this->table);
if ($where) {
$query->where($where);
}
$result = $query->all();
return count($result);
}
/**
* @param array $filters
* @param string $select
* @return Query
*/
private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
if (isset($filters['M08_HAN_CD']) && $filters['M08_HAN_CD']) {
$query->where('M08_HAN_CD=:han_cd', [':han_cd' => $filters['M08_HAN_CD']]);
}
if (isset($filters['M08_SS_CD']) && $filters['M08_SS_CD']) {
$query->where('M08_SS_CD=:ss_cd', [':ss_cd' => $filters['M08_SS_CD']]);
}
if (isset($filters['M08_JYUG_CD']) && $filters['M08_JYUG_CD']) {
$query->where('M08_JYUG_CD=:jy_cd', [':jy_cd' => $filters['M08_JYUG_CD']]);
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
public function actionEdit($id)
{
if (Yii::$app->request->post()) {
Ot::Update($id);
}
$apteka = Ur::find()->where(['id' => $id])->one();
$regionId = Ur::getRegionId($id);
$db = new Query();
$db->from('preparats');
$db->where(['is_active' => 1, 'region_id' => $regionId]);
$preparats = $db->all();
return $this->render('edit', ['preparats' => $preparats, 'id_apteka' => $id, 'apteka' => $apteka]);
}
public function testWhere()
{
$query = new Query();
$query->where('id = :id', [':id' => 1]);
$this->assertEquals('id = :id', $query->where);
$this->assertEquals([':id' => 1], $query->params);
$query->andWhere('name = :name', [':name' => 'something']);
$this->assertEquals(['and', 'id = :id', 'name = :name'], $query->where);
$this->assertEquals([':id' => 1, ':name' => 'something'], $query->params);
$query->orWhere('age = :age', [':age' => '30']);
$this->assertEquals(['or', ['and', 'id = :id', 'name = :name'], 'age = :age'], $query->where);
$this->assertEquals([':id' => 1, ':name' => 'something', ':age' => '30'], $query->params);
}
public static function getRegionId($id)
{
$db = new Query();
$db->from('ur_l');
$db->select('region.id');
$db->InnerJoin('region_ur_l', 'region_ur_l.id_ur = ur_l.id');
$db->InnerJoin('region', 'region_ur_l.id_reg = region.id');
$db->where(['=', 'ur_l.id', $id]);
$data = $db->all();
foreach ($data as $rid) {
$data2[] = $rid[id];
}
return $data2;
}
public static function getSalesData($duration)
{
$dates = [];
$transactions = [];
$transactionskv = [];
$amount = [];
$statusPaid = [Order::STATUS_PAID, Order::STATUS_DELIVERED];
$statusPaid = join(",", $statusPaid);
$orderTable = CartTables::TABLE_ORDER;
$txnTable = CartTables::TABLE_ORDER_TRANSACTION;
$query = new Query();
$query->select(["date(`{$txnTable}`.`createdAt`) as date", 'sum( amount ) as amount']);
$query->from($txnTable);
$query->join('LEFT JOIN', $orderTable, "orderId = `{$orderTable}`.`id`");
$query->where(" {$orderTable}.status in ( {$statusPaid} )");
switch ($duration) {
case 0:
// Current Week - Starting with Sun
$dates = DateUtil::getCurrentWeekDates();
$transactions = $query->andWhere("YEARWEEK( `{$txnTable}`.`createdAt` ) = YEARWEEK( CURRENT_DATE ) ")->groupBy(['date'])->all();
break;
case 1:
// Last Week - Starting with Sun
$dates = DateUtil::getLastWeekDates();
$transactions = $query->andWhere("YEARWEEK( `{$txnTable}`.`createdAt` ) = YEARWEEK( CURRENT_DATE - INTERVAL 7 DAY ) ")->groupBy(['date'])->all();
break;
case 2:
// This Month
$dates = DateUtil::getCurrentMonthDates();
$transactions = $query->andWhere("MONTH( `{$txnTable}`.`createdAt` ) = ( MONTH( NOW() ) ) AND YEAR( `{$txnTable}`.`createdAt` ) = YEAR( NOW() ) ")->groupBy(['date'])->all();
break;
case 3:
// Last Month
$dates = DateUtil::getLastMonthDates();
$transactions = $query->andWhere("MONTH( `{$txnTable}`.`createdAt` ) = ( MONTH( NOW() ) - 1 ) AND YEAR( `{$txnTable}`.`createdAt` ) = YEAR( NOW() ) ")->groupBy(['date'])->all();
break;
}
foreach ($transactions as $transaction) {
$transactionskv[$transaction['date']] = $transaction['amount'];
}
foreach ($dates as $date) {
if (isset($transactionskv[$date])) {
$amount[] = $transactionskv[$date];
} else {
$amount[] = 0;
}
}
return $amount;
}
public function actionPosts()
{
$query = new Query();
$query->select('e.id, title, content, e.created_at, u.username, u.avatar')->from('{{%home_post}} as e')->join('LEFT JOIN', '{{%user}} as u', 'u.id=e.user_id')->where('e.explore_status=1')->orderBy('e.id DESC');
//按标签查询出文章
if (Yii::$app->request->isGet) {
$tag = Yii::$app->request->get('tag');
$query->where('tags LIKE :tag', [':tag' => '%' . $tag . '%'])->andWhere('explore_status=1');
}
$posts = Yii::$app->tools->Pagination($query, 10);
//标签列表
$query = new TaggingQuery();
$tags = $query->select('tags')->from('{{%home_post}}')->where('explore_status=1')->limit(10)->displaySort(['freq' => SORT_DESC])->getTags();
return $this->render('posts', ['posts' => $posts, 'tags' => $tags]);
}
/**
* @param int $limit
*
* @param null $version
*
* @return array
*/
protected function getMigrationHistory($limit, $version = null)
{
if ($this->db->schema->getTableSchema($this->migrationTable, true) === null) {
$this->createMigrationHistoryTable();
}
$query = new Query();
$query->select(['version', 'apply_time'])->from($this->migrationTable)->orderBy('version DESC')->limit($limit);
if ($version) {
$query->where(['app_version' => $version]);
}
$rows = $query->createCommand($this->db)->queryAll();
$history = ArrayHelper::map($rows, 'version', 'apply_time');
unset($history[self::BASE_MIGRATION]);
return $history;
}
/**
* Récupère toutes les category
* @param Array $params : orderBY, limit etc.
*/
public function getAll($where = null, $params = null)
{
$query = new Query();
$query->select('*')->from('forum_category');
//var_dump($where);
if ($where != null) {
if (is_string($where)) {
$query->where($where);
} else {
throw new Exception('Erreur : la clause Where doit être une chaîne de caractères');
}
}
$items = $query->all();
return $items;
}
/**
* Lists all Order models.
* @return mixed
*/
public function actionIndex()
{
$productIdes = [];
$sum = 0;
/* @var Order $orders */
$orders = Order::find()->where(['user_id' => Yii::$app->user->id, 'status' => Order::STATUS_START])->one();
if (!empty($orders)) {
$productIdes = unserialize($orders->orders_details);
$sum = $orders->sum;
}
$products = new Query();
$products->select('id ,name')->from('product');
$products->where(['id' => $productIdes]);
$dataProvider = new ActiveDataProvider(['query' => $products]);
return $this->render('index', ['dataProvider' => $dataProvider, 'sum' => $sum]);
}
public function actionProfile($id)
{
$model = $this->findModel($id);
if ($model === null) {
throw new NotFoundHttpException('The requested page does not exist.');
} else {
if (Yii::$app->user->id === $model->id) {
$profileModel = UserProfile::findOne(['user_id' => Yii::$app->user->id]);
if (is_null($profileModel)) {
$profileModel = new UserProfile();
}
$workModel = new UserWorkExperience();
$query = new Query();
$query->from(UserWorkExperience::tableName());
$query->where(['user_id' => $id]);
$userWorkDataProvider = new ActiveDataProvider(['query' => $query]);
$educationModel = new UserEducation();
$query = new Query();
$query->from(UserEducation::tableName());
$query->where(['user_id' => $id]);
$educationDataProvider = new ActiveDataProvider(['query' => $query]);
$addressModel = new UserAddress();
$query = new Query();
$query->from(UserAddress::tableName());
$query->where(['user_id' => $id]);
$addressDataProvider = new ActiveDataProvider(['query' => $query]);
if ($profileModel->load(Yii::$app->request->post()) && $profileModel->beforeSave(true) && $profileModel->save()) {
}
if ($workModel->load(Yii::$app->request->post()) && ($workModel->user_id = $model->id) && $workModel->beforeSave(true) && $workModel->save()) {
$workModel = new UserWorkExperience();
}
if ($educationModel->load(Yii::$app->request->post()) && ($educationModel->user_id = $model->id) && $educationModel->beforeSave(true) && $educationModel->save()) {
$educationModel = new UserEducation();
}
if ($addressModel->load(Yii::$app->request->post()) && ($addressModel->user_id = $model->id) && $addressModel->beforeSave(true) && $addressModel->save()) {
$addressModel = new UserAddress();
}
return $this->render('profile', ['model' => $model, 'profileModel' => $profileModel, 'workModel' => $workModel, 'workDataProvider' => $userWorkDataProvider, 'educationModel' => $educationModel, 'educationDataProvider' => $educationDataProvider, 'addressModel' => $addressModel, 'addressDataProvider' => $addressDataProvider]);
} else {
throw new NotFoundHttpException('Access Denied. You need to be owner to perform this operation.');
}
}
}
/**
* Универсальный поиск по любому полю
* @param string $search
* @param string $value
* @param string $colAlias
* @return Json
* */
public function actionSelect2List($search = '', $value = '', $colAlias = 'title')
{
/** @var Role $model * */
$model = Role::className();
/** @var Role $modelObject * */
$table = 'auth_item';
$alias = $colAlias;
$out = ['more' => false];
if (!is_null($search)) {
$query = new Query();
$query->select('DISTINCT(' . $alias . ') AS id, ' . $alias . ' AS text')->from($table);
$query->where($alias . ' LIKE "%' . $search . '%"')->andWhere(['type' => 1])->limit(20);
$command = $query->createCommand();
$data = $command->queryAll();
$out['results'] = array_values($data);
} elseif ($value > 0) {
$out['results'] = ['id' => $value, 'text' => $model::find($value)->{$colAlias}];
}
return Json::encode($out);
}
/**
* 获得一个按组分类的数据
*/
public static function findGroupString($date, $topType, $params, $groupstring, $tableselect)
{
if (empty($date)) {
$date = date("Y-m-d 00:00:00");
}
$start_date = date('Y-m-d 00:00:00', strtotime($date));
$end_date = date('Y-m-d 00:00:00', strtotime('+1 day', strtotime($start_date)));
$query = new Query();
$query->where("CheckTime>=:sT AND CheckTime<=:eT", [':sT' => $start_date, ':eT' => $end_date]);
switch ($tableselect) {
case self::AccessStatistic17:
$query = $query->from('AccessStatistic17');
break;
case self::AccessStatistic21:
$query = $query->from('AccessStatistic21');
break;
default:
$query = $query->from('AccessStatistic17');
}
return $query->select("{$groupstring},sum(Amount) totalNum")->andwhere($topType, $params)->groupBy($groupstring)->all(\Yii::$app->db1);
}
private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
//$query->where('status=:status', [':status' => $status]);
if (isset($filters['D01_KAIIN_CD']) && $filters['D01_KAIIN_CD']) {
$query->andwhere('D01_KAIIN_CD = ' . $filters['D01_KAIIN_CD']);
}
if (isset($filters['D01_CUST_NO']) && $filters['D01_CUST_NO']) {
$query->andwhere('D01_CUST_NO = ' . $filters['D01_CUST_NO']);
}
if (isset($filters['D01_KAKE_CARD_NO']) && $filters['D01_KAKE_CARD_NO']) {
$query->where(['D01_KAKE_CARD_NO' => $filters['D01_KAKE_CARD_NO']]);
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
public function findAllBooks($selectedAuthors = '', $date_create_book = '', $date_create = '', $nameBook = '')
{
$query = new Query();
$query->select(['b.id', 'b.name', 'b.date_create', 'b.date_create_book', 'b.preview', "CONCAT(a.firstname,' ',a.lastname) as authors"])->from(['b' => 'books'])->innerJoin('authors AS a', 'b.author_id = a.id');
/*$query =Yii::$app->db->createCommand("SELECT
b.id,
b.name,
b.date_create,
b.date_create_book,
b.preview,
CONCAT(a.firstname,' ',a.lastname) as authors
FROM books b INNER JOIN authors a
ON b.author_id = a.id
WHERE b.name = '".$nameBook."'
AND b.date_create = '".$beforeDateBook."'
AND b.date_create_book = '".$fromDateBook."'
AND a.id = '".$selectedAuthors."'
");*/
if (!empty($selectedAuthors) || !empty($fromDateBook) || !empty($nameBook) || !empty($beforeDateBook)) {
$query->where(['search' => 1]);
}
if (!empty($selectedAuthors)) {
$query->andWhere(['a.id' => $selectedAuthors]);
}
if (!empty($nameBook)) {
$query->andWhere(['like', 'b.name', $nameBook]);
}
if (!empty($date_create)) {
$query->andWhere('b.date_create>=' . $date_create);
}
if (!empty($date_create_book)) {
$query->andWhere(['b.date_create_book' => $date_create_book]);
}
$rows = $query->all();
return $rows;
}
public static function getList($page = 1, $rows = 10, $condition = '', $conditionParams = [])
{
$return = [];
$query = new Query();
$query->select('COUNT(1)');
$query->from(self::tableName() . ' t0');
$query->where($condition, $conditionParams);
$result['total'] = $query->scalar();
$query->select(['t0.id', 't0.username', 't0.email', 't1.firstname', 't1.lastname']);
$query->join('LEFT JOIN', 'user_profile t1', 't0.id = t1.user_id');
$query->offset($page * $rows - $rows);
$query->limit($rows);
$result['rows'] = $query->All();
foreach ($result['rows'] as $k => $v) {
$myRoles = Yii::$app->authManager->getRolesByUser($v['id']);
if (count($myRoles)) {
foreach ($myRoles as $kk => $vv) {
$result['rows'][$k]['role'] = $kk;
break;
}
}
}
return $result;
}
public function canExecute($user, $permission, $validate = null)
{
$query = new Query();
$query->select(['r.permission', 'r.value', 'p.form']);
$query->from([$this->relationTable . ' as r', $this->permissionTable . ' as p', $this->assignmentTable . ' as a']);
$query->where('r.permission=p.key and r.role=a.role');
$query->andWhere(['a.user' => $user, 'r.permission' => $permission]);
$rows = $query->all();
if ($rows === null) {
return false;
}
if ($validate === null) {
$validate = function ($p, $v) {
if (is_bool($v)) {
return $v;
}
};
}
$ret = true;
foreach ($rows as $row) {
$form = intval($row['form']);
$v = $row['value'];
if ($form === Permission::Form_Boolean) {
if ($v === '1' || $v === 'true') {
$v = true;
} else {
$v = false;
}
} else {
if ($form === Permission::Form_CheckboxList) {
$v = explode(',', $v);
}
}
$ret = $ret && call_user_func($validate, $row['permission'], $v);
//$ret[$row['permission']]=$v;
}
return $ret;
}
/**
* start de dialog om een contract aan te bieden
**/
public function actionDialogContr()
{
$id = ArrayHelper::getValue($_POST, 'id');
$calenderevent = CalendarEvents::findOne(['id' => $id]);
$start = substr($calenderevent->start, 0, 10);
//Zie of er op die dag all contracten die zijn geaccepteerd.
//
$query = new Query();
$query->from('calendar_events');
$query->where(['start' => substr($calenderevent->start, 0, 10), 'user_id' => $calenderevent->user_id]);
$query->andWhere(['like', 'code_title', 'Accep']);
if ($query->count() > 0) {
return $this->renderAjax('_dialogContrbezet', ['calenderevent' => $calenderevent]);
}
$usercv = UserCv::findOne(['user_id' => $calenderevent->user_id]);
$user = User::findOne(['id' => $calenderevent->user_id]);
$contractdeal = new ContractDeals();
$company = Company::findOne(['id' => $user->company_id]);
$usercontactperson = Gebruikers::findOne(['id' => $calenderevent->user_id]);
return $this->renderAjax('_dialogContr', ['calenderevent' => $calenderevent, 'company' => $company, 'usercv' => $usercv, 'contractdeal' => $contractdeal, 'user' => $user]);
}
public function setLangBegin()
{
if (!$this->langBegin) {
$key = static::className() . 'langBegin';
$this->langBegin = $this->cache->get($key);
if ($this->langBegin === false) {
$query = new Query();
$query->select(['c' => $this->codeField])->from($this->table);
if ($this->condition) {
$query->where($this->condition);
}
if ($this->orderBy) {
$query->orderBy($this->orderBy);
}
$this->langBegin = ArrayHelper::getColumn($query->all($this->getDb()), 'c');
}
if ($this->enableCaching) {
if ($this->durationCaching !== null) {
$this->cache->set($key, $this->langBegin, $this->durationCaching);
} else {
$query = new Query();
$sql = $query->select('COUNT(*),MAX(' . $this->updatedAtField . ')')->from($this->table)->createCommand($this->getDb())->getRawSql();
$this->cache->set($key, $this->langBegin, $this->durationCaching, new \yii\caching\DbDependency(['sql' => $sql]));
}
}
}
}
public static function generateTablePdf($id)
{
$mains = ValidationMain::find()->orderBy('npp')->all();
$html1 = "";
$html1 .= "\n<style>\nbody{\n\n \n font-size: 16px;\n font-family: 'open', sans-serif;\n\n\n \n\n}\n\nspan{\nfont-size: 17px;\nfont-family: 'roboto', sans-serif;\n}\n\ntd{\nbackground-color:#fff;\nfont-size: 14px;\nfont-family: 'open', sans-serif;\n\n}\n.main td{\nbackground-color:#64b5f6;\nfont-size: 15px;\nfont-family: 'roboto', sans-serif;\n}\n.main2 td{\nbackground-color:#87cefa;\n}\n.header{\nline-height:30px;\n}\nh1,h2,h3,h4{\nfont-family: 'roboto', sans-serif;\n color: #c62828;\n\n\n}\n\n</style>\n\n<body>\n<div id=\"background\">\n<div align='center'><img src=\"http://sojuzpharma.ru/images/logo_04.jpg\"></div><br>";
$table = "";
$priceAll = 0;
// $table.= "<pagebreak />";
foreach ($mains as $main) {
$params = ValidationParams::find()->where(['validation_main_id' => $main['id']])->all();
$table2 = '';
foreach ($params as $param) {
$err = null;
//$violations = Validationviolation::find()->where(['validation_params_id' => $param['id']])->all();
$query = new Query();
$query->select('validation_violation.name,validation_violation.price');
$query->InnerJoin('validation_report_violation', 'validation_report_violation.`violation_id`=validation_violation.id');
$query->where(['report_id' => $id]);
$query->andWhere(['validation_params_id' => $param['id']]);
$query->from('validation_violation');
$val = $query->all();
if (count($val) > 0) {
$table2 .= "";
$table2 .= "<tr>";
$table2 .= "<td rowspan='" . count($val) . "' width=10.5%>" . $param['name'] . "</td>";
$table2 .= "<td width='15%'>" . $val[0]['name'] . "</td>";
if ($val[0]['price'] == "") {
$table2 .= "<td rowspan='" . count($val) . "' align='center'><b>" . $param['price'] . "</b></td>";
$priceAll = $priceAll + $param['price'];
} else {
$table2 .= "<td align='center'><b>" . $val[0]['price'] . "<b></td>";
$priceAll = $priceAll + $val[0]['price'];
}
$table2 .= "<td rowspan='" . count($val) . "' valign=top>" . $param['nd'] . "</td>";
$table2 .= "<td rowspan='" . count($val) . "' valign=top width=45%>" . $param['sankcii'] . "</td>";
$table2 .= "</tr>\n";
$n = 0;
foreach ($val as $violation) {
if ($n != 0) {
$table2 .= "<tr nobr=\"false\">";
$table2 .= "<td>" . $violation['name'] . "</td>";
if ($violation['price'] != "") {
$table2 .= "<td align='center'><b>" . $violation['price'] . "</b></td>";
$priceAll = $priceAll + $violation['price'];
}
$table2 .= "</tr>\n";
}
$n++;
}
$err = 1;
}
}
if ($table2) {
$table .= "";
$table .= "<h4 align='center'>" . $main['name'] . "</h4>";
$table .= "<table border='1' cellpadding='3' cellspacing='0' width='100%'>";
$table .= "<thead><tr align='center' class='main'>";
$table .= "<td align='center'>Проверяемый параметр</td>";
$table .= "<td align='center'>Выявленные нарушения</td>";
$table .= "<td align='center'>Риск применения санкций для юр.лица (max)</td>";
$table .= "<td align='center'>п. НД, регламентирующий указанное в колонке 2 требование</td>";
$table .= "<td align='center'>Риск применения санкций возможный контролирующий орган, ст. КоАП и др…</td>";
$table .= "</tr></thead>\n\n";
$table .= "<tr align='center' class='main2'>";
//$table .= "<td colspan='5'>" . $main['name'] . "</td>";
$table .= "</tr>";
$table .= $table2;
$table .= "</table>";
}
}
$table .= "</div></body>";
$query = new Query();
$query->select('validation_report.`created_at`,ur_l.`name`,apteki.`address`,users.`username`');
$query->InnerJoin('apteki', 'apteki.id = validation_report.`apteka_id` ');
$query->InnerJoin('ur_l', 'apteki.ur_l_id = ur_l.id');
$query->LeftJoin('users', 'users.id = validation_report.user_id');
$query->where(['validation_report.id' => $id]);
$query->from('validation_report');
$val = $query->one();
$dat = new \DateTime($val['created_at']);
$dat2 = $dat->format('d.m.Y');
$html2 = "";
$html2 .= "<h1 align='CENTER'>АКТ ОБСЛЕДОВАНИЯ АПТЕЧНОГО УЧРЕЖДЕНИЯ </h1>";
$html2 .= "<h4 align='CENTER'>В РАМКАХ ПРОЕКТА ФАРМОПЕКА (конфиденциально, только для внутреннего пользования) </h4>";
$html2 .= "<br><br><div class='header'>";
$html2 .= "<span>Дата проверки: </span>" . $dat2;
$html2 .= "<br><br>";
$html2 .= "<span>Юридическое лицо: </span>" . $val['name'];
$html2 .= "<br>";
$html2 .= "<span>Адрес объекта:</span> " . $val['address'];
$html2 .= "<br>";
$html2 .= "<span>ФИО инспектирующего лица: </span>" . $val['username'];
$html2 .= "<br>";
$html2 .= "<br><br><br><br>";
$html2 .= "<span>Выявлены несоответствия (графа 2) в соблюдение лицензионных условий и фармацевтического порядка на сумму <b>" . \number_format($priceAll, 0) . "</b> руб.</span>";
$html2 .= "</div>";
$html = $html1 . $html2 . $table;
return $html;
}
