public function actionStatistics()
{
$churchcnt = Church::model()->count();
$rschcnt = ChurchSupplies::model()->count();
$usercnt = AppUsers::model()->count();
$this->render('statistics', array('churchcnt' => $churchcnt, 'rsccnt' => $rschcnt, 'usercnt' => $usercnt));
}
public function loadModel($id)
{
$model = AppUsers::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
//array que ir� receber os sados selecionados
$selected_category = array();
//para cada plataforma
foreach ($model->appUsers as $cat) {
array_push($selected_category, $cat->id);
}
?>
<div class="group-div">
<div>
<?php
echo TbHtml::label($model->getAttributeLabel('appUsers'), 'AppUsers');
?>
<p>
<div class="portlet-content">
<?php
echo TbHtml::CheckBoxList('AppUsers', $selected_category, CHtml::listData(AppUsers::model()->findAll(), 'id', 'name'), array('template' => '{input} {label}'));
?>
<?php
echo $form->error($model, 'appUsers');
?>
</div>
</p>
</div>
<?php
echo CHtml::link(CHtml::encode('Remove'), array('appUsers/delete', 'id' => $model->id), array('submit' => array('appUsers/delete', 'id' => $model->id), 'class' => 'delete btn btn-danger', 'confirm' => 'This will remove the image. Are you sure?'));
?>
</div>
</div></div>*/
</div></div></div></div>
/**
* Retrieves a list of models based on the current search/filter conditions.
*
* Typical usecase:
* - Initialize the model fields with values from filter form.
* - Execute this method to get CActiveDataProvider instance which will filter
* models according to data in model fields.
* - Pass data provider to CGridView, CListView or any similar widget.
*
* @return CActiveDataProvider the data provider that can return the models
* based on the search/filter conditions.
*/
public function search()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$userId = Yii::app()->user->id;
//$userLevel = Users::model()->level;
// $sql = AppUsers::model ()->findBySql ( 'SELECT id_users from app_users WHERE id_users ='.$userId );
// $sql = 'SELECT level from users WHERE id ='.$userId ;
/* $connection=Yii::app()->db;
$sql = 'SELECT id_users FROM app_users WHERE id_users ='.$userId;
$command=$connection->createCommand($sql);
$tenta=$command->query();*/
// $modelApp = AppUsers::model()->findB(array('id_users'=>$userId));
// var_dump($modelApp);
// $criteria->compare('app_users.id_users', $this->id_users, true);
// $posts= AppUsers::model()->findAllBySql("select id_app from app_users where id_users = ".$userId);
// $criteria->addCondition(array("condtion"=>"id_users = $userId"));
// $criteria->addInCondition('id',$value);
$results = AppUsers::model()->findAll('id_users=:v', array(':v' => $userId));
$values = array();
foreach ($results as $r) {
$values[] = $r->id_app;
}
$criteria->addInCondition('id', $values);
// $criteria->addCondition(array("condtion"=>"$userId = id_users"), 'OR');
$criteria->compare('id', $this->id);
$criteria->compare('name', $this->name, true);
$criteria->compare('description', $this->description, true);
$criteria->compare('developer', $this->developer, true);
//$criteria->compare('id_users',$this->id_users);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}