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;
}
