function mod()
{
$clang = Yii::app()->lang;
$action = isset($_POST['action']) ? $_POST['action'] : '';
$aData = array();
$aViewUrls = array();
if (Permission::model()->hasGlobalPermission('panellist', 'update')) {
$query_id = (int) Yii::app()->request->getPost("query_id");
if ($action == "editquery") {
if (isquerysent($query_id)) {
Yii::app()->setFlashMessage(Yii::app()->lang->gT("You can not update this query. This query has been sent."), 'error');
$this->getController()->redirect(array("admin/pquery/index"));
return 1;
}
// $query_id = (int) Yii::app()->request->getPost("query_id");
$title = flattenText($_POST['query_title'], false, true, 'UTF-8', true);
$project_id = (int) Yii::app()->request->getPost("project_id");
$qstring = addslashes($_POST['query_sql']);
$zip = trim($_POST['zipcode']);
$age = $_POST['toage'] . "," . $_POST['fromage'];
$country = (int) Yii::app()->request->getPost("country");
$total_panellists = (int) Yii::app()->request->getPost("total_panellists");
$user_id = Yii::app()->user->id;
$created_date = Date('y-m-d h:i:s');
$modified_date = Date('y-m-d h:i:s');
$sql_insert = "update {{query_master}} set\n name ='{$title}'\n ,qstring ='{$qstring}'\n ,project_id= {$project_id}\n ,zip='{$zip}'\n ,age ='{$age}'\n ,country={$country}\n ,total_panellists={$total_panellists}\n ,modified_date ='{$modified_date}'\n where id= {$query_id}";
$rString = Yii::app()->db->createCommand($sql_insert)->query();
$delquery = "Delete from {{query_detail}} where query_id = " . $query_id;
$dString = Yii::app()->db->createCommand($delquery)->query();
if (isset($_POST['query_detail'])) {
foreach ($_POST['query_detail'] as $question_id => $answer_id) {
if (is_array($answer_id)) {
foreach ($answer_id as $answer) {
$insertQuery = "insert into {{query_detail}} set\n query_id = '" . $query_id . "',\n question_id = '" . $question_id . "',\n answer_id = '" . $answer . "'";
$rString = Yii::app()->db->createCommand($insertQuery)->query();
}
} else {
$insertQuery = "insert into {{query_detail}} set\n query_id = '" . $query_id . "',\n question_id = '" . $question_id . "',\n answer_id = '" . $answer_id . "'";
$rString = Yii::app()->db->createCommand($insertQuery)->query();
}
}
}
Yii::app()->setFlashMessage($clang->gT("Query Updated successfully"));
if ($_POST['pid'] != '') {
$pid = $_POST['pid'];
$vid = $_POST['vid'];
//echo '<script>$.fancybox.close()</script>;';
$this->getController()->redirect(array("admin/project/sa/modifyproject/project_id/{$pid}/action/modifyvendor/vid/{$vid}"));
} else {
$this->getController()->redirect(array("admin/pquery/index"));
}
//$this->getController()->redirect(array("admin/pquery/index"));
} else {
if (isset($_POST['query_id'])) {
$aData['row'] = 0;
$aData['usr_arr'] = array();
$project_id = isset($_GET['prjid']) ? $_GET['prjid'] : '';
$aData['prjid'] = $project_id;
$vid = isset($_GET['vid']) ? $_GET['vid'] : '';
$aData['vid'] = $vid;
$query_id = (int) Yii::app()->request->getPost("query_id");
$action = Yii::app()->request->getPost("action");
$sresult = queryview($query_id);
$aData['query_id'] = $query_id;
$aData['mur'] = $sresult;
$this->_renderWrappedTemplate('panellist/query', 'editquery_view', $aData);
return;
}
}
}
Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error');
$this->getController()->redirect(array("admin/pquery/index"));
}
function modifyproject()
{
if (isset($_GET['project_id'])) {
App()->getClientScript()->registerCssFile(Yii::app()->getConfig('styleurl') . "jquery.dataTables.css");
App()->getClientScript()->registerScriptFile(Yii::app()->getConfig('adminscripts') . 'jquery.dataTables.min.js');
$aData = array();
$aData['row'] = 0;
$aData['imageurl'] = Yii::app()->getConfig("adminimageurl");
// Project detail
//$project_id = (int) Yii::app()->request->getPost("project_id");
$project_id = (int) $_GET['project_id'];
//$action = Yii::app()->request->getPost("action");
$action = $_GET['action'];
$sresult = projectview($project_id);
$aData['project_id'] = $project_id;
$aData['vendor_arr'] = project_vendor_view($project_id);
$aData['mur'] = $sresult;
if ($action == 'modifyvendor') {
$userlist = queryview(null, $project_id);
$aData['usr_arr'] = $userlist;
$vendor_project_id = (int) $_GET["vid"];
$aData['vendor_project_id'] = $vendor_project_id;
$aData['vendor_arr_single'] = project_vendor_view('', $vendor_project_id);
//echo "<pre>$vendor_project_id</pre>";
$this->_renderWrappedTemplate('projects', 'view_editvendor', $aData);
} elseif ($action == 'modifyproject') {
$this->_renderWrappedTemplate('projects', 'view_editproject', $aData);
}
return;
}
Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error');
$this->getController()->redirect(array("admin/index"));
}
