protected function getTotalcontacts() { $criteria = new CDbCriteria(); $criteria->condition = '`group_id`=:group_id'; $criteria->params = array(":group_id" => $this->id); return ContactsList::model()->count($criteria); }
public function actionRemovefromgroups() { if (isset($_POST['contacts']) and count($_POST['contacts']) > 0 and isset($_POST['groups']) and count($_POST['groups']) > 0) { $contacts = $_POST['contacts']; $groups = $_POST['groups']; foreach ($groups as $group) { $criteria = new CDbCriteria(); $criteria->condition = '`group_id`=:group_id'; $criteria->params = array(':group_id' => $group); $criteria->addInCondition('`contact_id`', $contacts); ContactsList::model()->deleteAll($criteria); } } }
public function actionDeletegroups() { if (isset($_POST['groups']) and count($_POST['groups']) > 0) { $groups = $_POST['groups']; foreach ($groups as $group) { if ($this->loadModel($group)->delete()) { ContactsList::model()->deleteAllByAttributes(array('group_id' => $group)); } } } }
<?php $criteria = new CDbCriteria(); $criteria->condition = '`group_id`=' . $_GET['group']; $alllists = ContactsList::model()->findAll($criteria); $contact_ids = array(); foreach ($alllists as $list) { $contact_ids[] = $list->contact_id; } $criteria = new CDbCriteria(); $criteria->addNotInCondition('id', $contact_ids); $remaining = Contacts::model()->findAll($criteria); if (count($remaining) > 0) { ?> <div class="clear"></div> <h2>Move these also</h2> <div class="remaining_contacts"> <?php foreach ($remaining as $contact) { ?> <div class="remain-contact-bx" data-contact-id="<?php echo $contact->id; ?> "> <?php echo '<b>' . $contact->fullname . '</b> : ' . $contact->mobile; ?> </div> <?php } if (count($remaining) > 0) {