public function actionDelete()
{
$data = $_POST;
$project = Projects::model()->findByPk($data['project_id']);
if (Yii::app()->user->name != $project['created_by']) {
echo CJSON::encode(array('type' => 'error', 'data' => 'Only those who created the project can delete it'));
return;
}
// SQL query for project data
// $query = "\n"."INSERT INTO `projects` ";
// $keys = "(";
// $values = " VALUES\n(";
// $col_num = count(Projects::model()->attributes);
// foreach($project as $key => $value) {
// $keys .= "`".$key."`";
// $values .= ($value === null)? "NULL" : "'".$value."'";
// $col_num--;
// if ($col_num > 0) {
// $keys .= ', ';
// $values .= ', ';
// }
// }
// $keys .= ")";
// $values .= ")";
// $query .= $keys.$values.";\n";
// //SQL query for contact person data
// $contact_persons = ProjectContactPersons::model()->findAll('project_id=:project_id', array(':project_id'=>$data['project_id']));
// if (count($contact_persons) > 0) {
// $query .= "\n"."INSERT INTO `project_contact_persons` ";
// $con_attr = ProjectContactPersons::model()->attributes;
// // collect attributes
// $keys = "(";
// $col_num = count($con_attr);
// foreach ($con_attr as $key => $values) {
// $keys .= "`".$key."`";
// $col_num--;
// if ($col_num > 0) {
// $keys .= ', ';
// }
// }
// $keys .= ")";
// // collect rows
// $values = " VALUES";
// $con_count = count($contact_persons);
// foreach($contact_persons as $contact) {
// $values .= "\n(";
// $col_num = count($con_attr);
// foreach($contact as $key => $value) {
// $values .= ($value === null)? "NULL" : "'".$value."'";
// $col_num--;
// if ($col_num > 0) {
// $values .= ', ';
// }
// }
// $values .= ")";
// $con_count--;
// if ($con_count > 0) {
// $values .= ", ";
// }
// }
// $query .= $keys.$values.";\n";
// }
// //SQL query for point person data
// $point_persons = ProjectPointPersons::model()->findAll('project_id=:project_id', array(':project_id'=>$data['project_id']));
// if (count($point_persons) > 0) {
// $query .= "\n"."INSERT INTO `project_point_persons` ";
// $pnt_attr = ProjectPointPersons::model()->attributes;
// // collect attributes
// $keys = "(";
// $col_num = count($pnt_attr);
// foreach ($pnt_attr as $key => $values) {
// $keys .= "`".$key."`";
// $col_num--;
// if ($col_num > 0) {
// $keys .= ', ';
// }
// }
// $keys .= ")";
// // collect rows
// $values = " VALUES";
// $pnt_count = count($point_persons);
// foreach($point_persons as $point) {
// $values .= "\n(";
// $col_num = count($pnt_attr);
// foreach($point as $key => $value) {
// $values .= ($value === null)? "NULL" : "'".$value."'";
// $col_num--;
// if ($col_num > 0) {
// $values .= ', ';
// }
// }
// $values .= ")";
// $pnt_count--;
// if ($pnt_count > 0) {
// $values .= ", ";
// }
// }
// $query .= $keys.$values.";\n";
// }
// if (file_put_contents('db_files/deleted_projects.sql', $query, FILE_APPEND) === false) {
// echo CJSON::encode(array(
// 'type' => 'error',
// 'data' => '',
// ));
// } else {
// delete record here
Projects::model()->deleteByPk($data['project_id']);
ProjectContactPersons::model()->deleteAll('project_id=:project_id', array(':project_id' => $data['project_id']));
ProjectPointPersons::model()->deleteAll('project_id=:project_id', array(':project_id' => $data['project_id']));
echo CJSON::encode(array('type' => 'success', 'data' => ''));
// }
}
public function actionDelete()
{
$data = $_POST;
if (!empty($data)) {
ProjectContactPersons::model()->deleteByPk(array('project_id' => (int) $data['project_id'], 'email' => (string) $data['email']));
echo CJSON::encode(array('type' => 'success', 'data' => ''));
} else {
echo CJSON::encode(array('type' => 'error', 'data' => 'CSRF_ERROR: CSRF Token did not match'));
}
}