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