public function pre_delete() { if (!$this->is_valid_id()) { return false; } $conn = Yii::app()->db; $query = "\n\t\t\tSELECT\t\tcid\n\t\t\tFROM\t\t{{contacts}}\n\t\t\tWHERE\t\tpositions LIKE :positions\n\t\t"; $command = $conn->createCommand($query); $command->bindValue(":positions", "%" . $this->posid . "%"); $result = $command->queryAll(); if (!$result or empty($result)) { return false; } foreach ($result as $row) { $contact = new ContactObj($row["cid"]); $contact->remove_position($this->posid); $contact->save(); } return true; }
public function action_remove_position_from_contact() { $posname = $_REQUEST["posname"]; $deptid = $_REQUEST["deptid"]; $cid = $_REQUEST["cid"]; $contact = new ContactObj($cid); $contact->remove_position($deptid, $posname); return print 1; }