/** * Retrieves a list of models based on the current search/filter conditions. * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions. */ public function search() { // Warning: Please modify the following code to remove attributes that // should not be searched. $ugRows = Usergroup::model()->findAll('uid=:uid', array(':uid' => Yii::app()->user->getState("user_id"))); $grps = []; foreach ($ugRows as $ug) { $grps[] = $ug['gid']; } /*Get Blocked Item Ids*/ $getRows = Blockeditem::model()->findAllByAttributes(array('blocked_for' => Yii::app()->user->getState("user_id"), 'flag' => 'U', 'unblock_by' => NULL)); $biU = []; foreach ($getRows as $row) { $biU[] = $row['item_id']; } $getRows = Blockeditem::model()->findAllByAttributes(array('blocked_for' => $grps, 'flag' => 'G', 'unblock_by' => NULL)); $biG = []; foreach ($getRows as $row) { $biG[] = $row['item_id']; } ////////////Blocked For All $getRows = Blockeditem::model()->findAllByAttributes(array('flag' => 'A', 'unblock_by' => NULL)); $biA = []; foreach ($getRows as $row) { $biA[] = $row['item_id']; } $blockeditemtableIds = array_merge($biU, $biG); $blockeditemtableIds = array_unique(array_merge($blockeditemtableIds, $biA)); $criteria = new CDbCriteria(); $criteria->compare('category_id', $this->category_id, true); $criteria->compare('name', $this->name, true); $criteria->compare('location_id', $this->location_id); $criteria->compare('technical_incharge_id', $this->technical_incharge_id); $criteria->compare('status_id', $this->status_id); $criteria->compare('manufacturer_id', $this->manufacturer_id); $criteria->compare('cartridge_type_id', $this->cartridge_type_id); $criteria->compare('management_type_id', $this->management_type_id); $criteria->compare('threshold', $this->threshold); $criteria->compare('link_to', $this->link_to); $criteria->compare('image', $this->image, true); $criteria->compare('imageFileName', $this->imageFileName, true); $criteria->compare('imageFileType', $this->imageFileType, true); $criteria->compare('document', $this->document, true); $criteria->compare('documentFileName', $this->documentFileName, true); $criteria->compare('documentFileType', $this->documentFileType, true); $criteria->compare('is_deleted', $this->is_deleted); $criteria->addCondition("is_deleted = 0"); $criteria->addNotInCondition('id', $blockeditemtableIds); if (isset($_GET['printerId'])) { $printerId = $_GET['printerId']; $criteria->addCondition("link_to = {$printerId}"); } if (isset($_GET['category_id'])) { $a = $_GET['category_id']; $criteria->addCondition("category_id = '{$a}'"); } return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->user->getState('pageSize', 3)))); }
public static function UpdateStatusOfConsumables($userId) { /*Get the user's group*/ $ugRows = Usergroup::model()->findAll('uid=:uid', array(':uid' => $userId)); $grps = []; foreach ($ugRows as $ug) { $grps[] = $ug['gid']; } /*Get Blocked Item Table Ids*/ $getRows = BlockeditemUser::model()->findAllByAttributes(array('uid' => $userId)); $biU = []; foreach ($getRows as $row) { $biU[] = $row['blockitem_id']; } $getRows = BlockeditemGroup::model()->findAllByAttributes(array('gid' => $grps)); $biG = []; foreach ($getRows as $row) { $biG[] = $row['blockitem_id']; } ////////////Blocked For All $getRows = Blockeditem::model()->findAllByAttributes(array('flag' => 0)); $biA = []; foreach ($getRows as $row) { $biA[] = $row['id']; } $blockeditemtableIds = array_merge($biU, $biG); $blockeditemtableIds = array_unique(array_merge($blockeditemtableIds, $biA)); $consumableItemIds = Blockeditem::model()->findAllByAttributes(array('id' => $blockeditemtableIds)); $consIds = []; foreach ($consumableItemIds as $row) { $consIds[] = $row['item_id']; } $getConsumables = Consumable::model()->findAll(); foreach ($getConsumables as $cons) { $model = Consumable::model()->findByPk($cons['id']); if (in_array($cons['id'], $consIds)) { $model->isBlockedForMe = 1; } else { $model->isBlockedForMe = 0; } $model->update(); } }
public function search2() { // Warning: Please modify the following code to remove attributes that // should not be searched. $ugRows = Usergroup::model()->findAll('uid=:uid', array(':uid' => Yii::app()->user->getState("user_id"))); $grps = []; foreach ($ugRows as $ug) { $grps[] = $ug['gid']; } /*Get Blocked Item Ids*/ $getRows = Blockeditem::model()->findAllByAttributes(array('blocked_for' => Yii::app()->user->getState("user_id"), 'flag' => 'U', 'unblock_by' => NULL)); $biU = []; foreach ($getRows as $row) { $biU[] = $row['item_id']; } $getRows = Blockeditem::model()->findAllByAttributes(array('blocked_for' => $grps, 'flag' => 'G', 'unblock_by' => NULL)); $biG = []; foreach ($getRows as $row) { $biG[] = $row['item_id']; } ////////////Blocked For All $getRows = Blockeditem::model()->findAllByAttributes(array('flag' => 'A', 'unblock_by' => NULL)); $biA = []; foreach ($getRows as $row) { $biA[] = $row['item_id']; } $blockeditemtableIds = array_merge($biU, $biG); $blockeditemtableIds = array_unique(array_merge($blockeditemtableIds, $biA)); $criteria = new CDbCriteria(); $criteria->compare('id', $this->id); $criteria->compare('commodity_id', $this->commodity_id); $criteria->compare('category_id', $this->category_id, true); $criteria->compare('link_to', $this->link_to); $criteria->compare('name', $this->name, true); $criteria->compare('location_id', $this->location_id); $criteria->compare('technical_incharge_id', $this->technical_incharge_id); $criteria->compare('size', $this->size); $criteria->compare('status_id', $this->status_id); $criteria->compare('monitor_type_id', $this->monitor_type_id); $criteria->compare('manufacturer_id', $this->manufacturer_id); $criteria->compare('serial_number', $this->serial_number); $criteria->compare('management_type_id', $this->management_type_id); $criteria->compare('comments', $this->comments, true); $criteria->compare('document', $this->document, true); $criteria->compare('documentFileName', $this->documentFileName, true); $criteria->compare('documentFileType', $this->documentFileType, true); $criteria->compare('image', $this->image, true); $criteria->compare('imageFileName', $this->imageFileName, true); $criteria->compare('imageFileType', $this->imageFileType, true); $criteria->compare('enable_financial', $this->enable_financial, true); $criteria->compare('available_on_loan', $this->available_on_loan, true); $criteria->compare('has_microphone', $this->has_microphone, true); $criteria->compare('has_speaker', $this->has_speaker, true); $criteria->compare('has_subD', $this->has_subD, true); $criteria->compare('has_BNC', $this->has_BNC, true); $criteria->compare('has_DVI', $this->has_DVI, true); $criteria->compare('has_pivot', $this->has_pivot, true); $criteria->compare('has_HDMI', $this->has_HDMI, true); $criteria->compare('has_displayport', $this->has_displayport, true); $criteria->compare('is_deleted', $this->is_deleted); $criteria->addCondition("is_deleted = 0"); $criteria->addNotInCondition('id', $blockeditemtableIds); if (isset($_GET['category_id'])) { $a = $_GET['category_id']; $criteria->addCondition("category_id = '{$a}'"); } return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => false)); }
<?php echo $form->errorSummary($model); ?> <?php $groupName = $_GET['groupName']; ?> <h1> Manage Group <span style="color:#B40431"><?php echo "{$groupName}"; ?> </h1> <?php echo "<br/>"; ?> <?php $this->widget('ext.multiselects.XMultiSelects', array('id' => 'listbuilder', 'leftTitle' => 'Group Users', 'leftName' => 'Usergroup[groupusers][]', 'leftList' => Usergroup::model()->findUsersByGroup($_GET['groupId']), 'rightTitle' => 'Other Users', 'rightName' => 'Usergroup[otherusers][]', 'rightList' => Usergroup::model()->findUsersNotInGroup($_GET['groupId']), 'size' => 20, 'width' => '200px')); ?> <div style="text-align: center;"> <?php echo CHtml::submitButton('Update', array('submit' => array('usergroup/moveusers', 'groupId' => $_GET['groupId'])), array('color' => TbHtml::BUTTON_COLOR_SUCCESS, 'size' => TbHtml::BUTTON_SIZE_DEFAULT)); ?> </div <?php $this->endWidget(); ?> </div><!-- form -->
/* @var $model Usergroup */ /* @var $form TbActiveForm */ ?> <div class="form"> <?php $form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'usergroup-form', 'enableAjaxValidation' => false)); ?> <p class="help-block">Fields with <span class="required">*</span> are required.</p> <?php echo $form->errorSummary($model); ?> <?php $this->widget('ext.multiselects.XMultiSelects', array('leftTitle' => 'Group Users', 'leftName' => 'Usergroup[][1]', 'leftList' => Usergroup::model()->findUsersByGroup(1), 'rightTitle' => 'Other Users', 'rightName' => 'Usergroup[][1]', 'rightList' => Usergroup::model()->findUsersNotInGroup(1), 'size' => 20, 'width' => '200px')); ?> <div class="form-actions"> <?php echo TbHtml::submitButton($model->isNewRecord ? 'Create' : 'Save', array('color' => TbHtml::BUTTON_COLOR_PRIMARY, 'size' => TbHtml::BUTTON_SIZE_LARGE)); ?> </div> <?php $this->endWidget(); ?> </div><!-- form -->
?> </option> </select> </li> <!-- added by Gaurang 2014-04-14 --> <li> <?php $Project_Manager = getGlobalSetting('Project_Manager'); ?> <label for='Project_Manager'><?php $clang->eT("Select Project Manager User Group"); ?> </label> <?php //$project_manager = Contact_title::model()->findAll(); $project_manager = Usergroup::model()->findAll(); $project_manager_list = CHtml::listData($project_manager, 'ugid', 'name'); echo CHtml::dropDownList('Project_Manager', $Project_Manager, $project_manager_list, array('prompt' => 'Select Project Manager User Group')); ?> </li> <li> <?php $Own_Panel = getGlobalSetting('Own_Panel'); ?> <label for='Own_Panel'><?php $clang->eT("Select Internal Company"); ?> </label> <?php //$own_panel = getCompanyDetail(); $sql = "SELECT * FROM {{view_company}} WHERE company_type LIKE '%V%'";
</span> <?php echo CHtml::link('<i class="icon-pencil"></i>', array('update', 'id' => $model->id), array('class' => 'btn-warning btn buttonDesign', 'title' => 'Update')); echo CHtml::link('<i class="icon-trash"></i>', '#', array('class' => 'btn-warning btn buttonDesign', 'title' => 'Delete', 'submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?')); ?> </h1> <table> <tr><td> <?php $this->widget('ext.DetailView4Col', array('htmlOptions' => array('class' => 'table table-striped table-condensed table-hover'), 'data' => $model, 'attributes' => array('name', 'password', 'organisation_id', 'pw_md5', 'email', 'phone', 'phones', 'mobile', 'fn', 'ln', 'active', 'id_auth', 'auth_method', 'last_login', 'date_mod', 'designation'))); ?> </td> <td> <?php $grps = Usergroup::model()->findAllByAttributes(array('uid' => $model->id)); $depts = Userdept::model()->findAllByAttributes(array('uid' => $model->id)); echo "<table class='table table-bordered'>"; if (count($depts) == 0) { echo "<tr style='background:#F7819F;color:white'><td>{$model->name} doesn't belong to any department</td></tr>"; } else { echo "<tr style='background:#F5A9A9;'><th colspan='2'>Departments</th></tr>"; foreach ($depts as $d) { $department = Dept::model()->findByAttributes(array('id' => $d['dept_id'])); $deptName = $department['name']; echo "<tr><td colspan='2'>{$deptName}</td></tr>"; } } if (count($grps) == 0) { echo "<tr style='background:#F7819F;color:white'><td>{$model->name} doesn't belong to any group</td></tr>"; } else {
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = Usergroup::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** * @param int $id the id (primary key) of person * @param int $gid */ public function updateUserGroup($userId, $newGroupId, $flag) { if ($flag == 0) { // Remove $oldModel = Usergroup::model()->find(array('select' => 'id', 'condition' => 'uid =:uid AND gid =:gid', 'params' => array(':uid' => $userId, ':gid' => $newGroupId))); if (isset($oldModel['id'])) { Usergroup::model()->findByPk($oldModel['id'])->delete(); } } else { if ($flag == 1) { //Add $newmodel = new Usergroup(); $newmodel->gid = $newGroupId; $newmodel->uid = $userId; $newmodel->save(); } } }
/** * Move users between Australia and New Zealand. * This method is used by XMultiSelects widget. */ public function actionMoveUsers() { // 1. Delete the users which were already present but not present now // 2. Add new users // 3. Maintain the current user if (isset($_POST['Usergroup']['groupusers'])) { $presentGroupUsers = $_POST['Usergroup']['groupusers']; //contains uids foreach ($presentGroupUsers as $user) { //1. Check already a group member? $allreadyMember = Usergroup::model()->find('uid =:uid AND gid =:gid', array(':uid' => $user, ':gid' => $_GET['groupId'])); if (!isset($allreadyMember['id'])) { Usergroup::model()->updateUserGroup($user, $_GET['groupId'], 1); } //Add } //3. User Removed? $pgu = implode(',', $presentGroupUsers); $removedUsers = User::model()->findAll(array('select' => 'id', 'condition' => "id NOT IN({$pgu})")); if (count($removedUsers) == 0) { } else { foreach ($removedUsers as $user) { // remove $a = $user['id']; Usergroup::model()->updateUserGroup($a, $_GET['groupId'], 0); } } } //Yii::app()->user->setFlash('saved',Yii::t('ui','Data successfully saved!')); $this->redirect(array('usergroup/admin')); }
/** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function actionUpdate($id) { $model = $this->loadModel($id); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['User'])) { $model->attributes = $_POST['User']; $model->pw_md5 = md5($_POST['User']['password']); if ($model->save()) { /* REMOVE PAST GRPS*/ $pastGrps = Usergroup::model()->findAllByAttributes(array('uid' => $id)); foreach ($pastGrps as $ug) { $m = Usergroup::model()->findByPk($ug['id']); $m->delete(); } /* ADD NEW GRPS */ if (isset($_POST['User']['g_id'])) { $grps = $_POST['User']['g_id']; foreach ($grps as $grp) { $model1 = new Usergroup(); $model1->uid = $model->id; $model1->gid = $grp; $model1->save(); } } /* REMOVE PAST DEPTS*/ $pastDepts = Userdept::model()->findAllByAttributes(array('uid' => $id)); foreach ($pastDepts as $ud) { $m = Userdept::model()->findByPk($ud['id']); $m->delete(); } /* ADD NEW DEPTS */ if (isset($_POST['User']['dept_id'])) { $depts = $_POST['User']['dept_id']; foreach ($depts as $d) { $model1 = new Userdept(); $model1->uid = $model->id; $model1->dept_id = $d; $model1->save(); } } $this->redirect(array('view', 'id' => $model->id)); } } else { $grpsRow = Usergroup::model()->findAllByAttributes(array('uid' => $id)); $grps = []; foreach ($grpsRow as $row) { $grps[] = $row['gid']; } $model->g_id = $grps; $deptsRow = Userdept::model()->findAllByAttributes(array('uid' => $id)); $depts = []; foreach ($deptsRow as $row) { $depts[] = $row['dept_id']; } $model->dept_id = $depts; } $this->render('update', array('model' => $model)); }