/admin/app/controllers/sitehelp_controller.php
PHP | 690 lines | 541 code | 106 blank | 43 comment | 55 complexity | d180ab9a88aa2067df4a1e0cbf232f90 MD5 | raw file
Possible License(s): LGPL-2.1, AGPL-1.0, GPL-2.0, MIT
- <?php
- class SitehelpController extends AppController
- {
- var $name='Sitehelp';
- var $components = array('Pagination','Upload');
- var $helpers = array('Pagination', 'error');
-
- function index()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if($_SESSION['Admin_role']==1)
- {
- $criteria= "1";
- ///list($order,$limit,$page) = $this->Pagination->init($criteria);
- $this->set('sitehelps', $this->Sitehelp->findAll());
- }
- else
- $this->redirect('/sitehelp/index');
- }
-
- function edit_head($id=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- /* For data related to categry */
- if($id)
- {
- $catsql = "Select * from sitehelps where id='".$id."'";
- $catsql_res = mysql_query($catsql);
- $catsql_arr = mysql_fetch_array($catsql_res);
- $this->set('sitehelpcategory', $catsql_arr);
- }
- else
- $this->redirect('/sitehelp/index');
- }
- function saveedithead()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- /* For data related to categry */
- if(isset($_REQUEST['helpcatid']) && $_REQUEST['helpcatid']>0)
- {
- $catedit = "UPDATE sitehelps SET cat_name = '".$this->data['sitehelp']['cat_name']."',cat_desc='".strip_html_tags($this->data['sitehelp']['cat_desc'])."' where id='".$_REQUEST['helpcatid']."'";
- mysql_query($catedit);
- }
- $this->redirect('/sitehelp/index');
- }
- function addhelpcategory()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- }
-
- function saveheadcategory()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- /* For data related to categry */
-
- $catsql = "Select * from sitehelps where cat_name = '".$this->data['sitehelp']['cat_name']."'";
- $catsql_res = mysql_query($catsql);
- if(mysql_num_rows($catsql_res)==0)
- {
- $catedit = "INSERT INTO sitehelps SET cat_name = '".$this->data['sitehelp']['cat_name']."',cat_desc='".strip_html_tags($this->data['sitehelp']['cat_desc'])."'";
- mysql_query($catedit);
- }
- $this->redirect('/sitehelp/index');
- }
-
- function delete_head($id=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if($id)
- {
- $catedit = "DELETE FROM sitehelps where id='".$id."'";
- mysql_query($catedit);
- }
- $this->redirect('/sitehelp/index');
- }
- function managecategoryhead()
- {
- if(isset($_REQUEST['box']))
- {
- $boxarray = $_REQUEST['box'] ;
- foreach($boxarray as $boxarrayind=>$boxarrayval)
- {
- $catedit = "DELETE FROM sitehelps where id='".$boxarrayval."'";
- mysql_query($catedit);
- }
-
- }
-
- $this->redirect('/sitehelp/index');
- }
-
- function view_group_head($id=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if($id)
- {
- $this->set('groupName', $this->Sitehelp->findById($id));
- /* Group sql */
- $groupsql = "
- SELECT sitehelp_group.id, sitehelp_group.group_name, COUNT(sitehelp_group_topic.id) as Numberoftopic , COUNT(sitehelp_group_topic_qa.id) as Numberofquestion
- from sitehelp_group
- LEFT JOIN sitehelp_group_topic ON sitehelp_group.id=sitehelp_group_topic.sitehelp_group_id
- LEFT JOIN sitehelp_group_topic_qa ON sitehelp_group_topic.id=sitehelp_group_topic_qa.sitehelp_group_topic_id
- WHERE sitehelp_group.sitehelp_id = '".$id."' Group by sitehelp_group.id ";
-
- $this->set('groupquery', $groupsql);
- }
- else
- $this->redirect('/sitehelp/index');
- }
- function addhelpgrouphead($id=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- $this->set('groupName', $this->Sitehelp->findById($id));
- }
- function savegroupheadcategory()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- /* For data related to categry */
- $catsql = "Select * from sitehelp_group where group_name = '".$this->data['sitehelpGroup']['group_name']."' and sitehelp_id='".$_REQUEST['helpgroupid']."'";
- $catsql_res = mysql_query($catsql);
- if(mysql_num_rows($catsql_res)==0)
- {
- $catedit = "INSERT INTO sitehelp_group SET group_name = '".$this->data['sitehelpGroup']['group_name']."',sitehelp_id='".$_REQUEST['helpgroupid']."'";
- mysql_query($catedit);
- }
- $this->redirect('/sitehelp/view_group_head/'.$_REQUEST['helpgroupid']);
- }
-
- function edit_group_head($id=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if($id)
- {
- $catsql = "Select * from sitehelp_group where id='".$id."'";
- $catsql_res = mysql_query($catsql);
- $catsql_arr = mysql_fetch_array($catsql_res);
- $this->set('sitehelpgroupcategory', $catsql_arr);
- }
- else
- $this->redirect('/sitehelp/index');
- }
- function saveeditgrouphead()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if(isset($_REQUEST['helpgroupheadid']) && $_REQUEST['helpgroupheadid']>0)
- {
- $catedit = "UPDATE sitehelp_group SET group_name = '".$this->data['sitehelpGroup']['group_name']."' where id='".$_REQUEST['helpgroupheadid']."'";
- mysql_query($catedit);
- $this->redirect('/sitehelp/view_group_head/'.$_REQUEST['helpgroupheadid']);
- }
- else
- $this->redirect('/sitehelp/index');
- }
-
- function delete_group_head($id=null)
- {
- if($id)
- {
- $catedit = "DELETE FROM sitehelp_group where id='".$id."'";
- mysql_query($catedit);
- $this->redirect($_SERVER['HTTP_REFERER']);
- }
- else
- $this->redirect('/sitehelp/index');
- }
-
- function view_group_topic($groupid=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if($groupid)
- {
- $groupsql = "
- SELECT sitehelps.cat_name as CatName , sitehelps.id as CatId , sitehelp_group.id as groupid, sitehelp_group.group_name, sitehelp_group_topic.topic , sitehelp_group_topic.id ,COUNT(sitehelp_group_topic_qa.id) as Numberofquestion
-
- from sitehelp_group_topic
-
- LEFT JOIN sitehelp_group ON sitehelp_group_topic.sitehelp_group_id=sitehelp_group.id
- LEFT JOIN sitehelps ON sitehelp_group.sitehelp_id=sitehelps.id
-
- LEFT JOIN sitehelp_group_topic_qa ON sitehelp_group_topic.id=sitehelp_group_topic_qa.sitehelp_group_topic_id
- WHERE sitehelp_group_topic.sitehelp_group_id = '".$groupid."' Group by sitehelp_group_topic.id ";
-
- $this->set('groupquery', $groupsql);
-
- /** GROUP NAME AND CATEGORY NAME */
- $groupcatsql = "Select sitehelps.cat_name,sitehelps.id as helpcatid , sitehelp_group.* from sitehelp_group
- LEFT JOIN sitehelps ON sitehelp_group.sitehelp_id = sitehelps.id
- where sitehelp_group.id='".$groupid."'";
-
- $groupcatsql_res = mysql_query($groupcatsql);
- $groupcatsql_arr = mysql_fetch_array($groupcatsql_res);
- $this->set('groupcatsql', $groupcatsql_arr);
- /***/
-
- }
- else
- $this->redirect('/sitehelp/index');
-
- }
-
- function addquestiontopic($groupid=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
-
-
- /** GROUP NAME AND CATEGORY NAME */
- $groupcatsql = "Select sitehelps.cat_name,sitehelps.id as helpcatid , sitehelp_group.* from sitehelp_group
- LEFT JOIN sitehelps ON sitehelp_group.sitehelp_id = sitehelps.id
- where sitehelp_group.id='".$groupid."'";
-
- $groupcatsql_res = mysql_query($groupcatsql);
- $groupcatsql_arr = mysql_fetch_array($groupcatsql_res);
- $this->set('groupcatsql', $groupcatsql_arr);
- /***/
- }
- function savequestiontopic()
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if(isset($_REQUEST['helpgroupid']) && $_REQUEST['helpgroupid']>0)
- {
- $inserttopic = "INSERT INTO sitehelp_group_topic SET sitehelp_id='".$_REQUEST['helpcatid']."' ,sitehelp_group_id='".$_REQUEST['helpgroupid']."' , topic='".$this->data['sitehelpGroupTopic']['topic']."' ";
- mysql_query($inserttopic);
- }
-
- $this->redirect('/sitehelp/view_group_topic/'.$_REQUEST['helpgroupid']);
- }
- function edit_group_topic($topicid=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
-
-
- /** GROUP NAME AND CATEGORY NAME */
- $topicsql = " SELECT sitehelps.cat_name,sitehelps.id as helpcatid , sitehelp_group.id as helpgroupid , sitehelp_group.group_name, sitehelp_group_topic.* from sitehelp_group_topic
- LEFT JOIN sitehelp_group ON sitehelp_group_topic.sitehelp_group_id =sitehelp_group.id
- LEFT JOIN sitehelps ON sitehelp_group_topic.sitehelp_id=sitehelps.id
- where sitehelp_group_topic.id='".$topicid."'" ;
-
- $groupcatsql_res = mysql_query($topicsql);
- $groupcatsql_arr = mysql_fetch_array($groupcatsql_res);
- $this->set('groupcatsql', $groupcatsql_arr);
- }
-
- function saveeditquestiontopic()
- {
- //pr($_REQUEST);
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if(isset($_REQUEST['helptopicid']) && $_REQUEST['helptopicid']>0)
- {
- $updatesql= "UPDATE sitehelp_group_topic SET topic='".$this->data['sitehelpGroupTopic']['topic']."' Where id = '".$_REQUEST['helptopicid']."'";
- mysql_query($updatesql);
-
- $topicsql = " SELECT sitehelp_group.id as helpgroupid from sitehelp_group_topic
- LEFT JOIN sitehelp_group ON sitehelp_group_topic.sitehelp_group_id =sitehelp_group.id
- LEFT JOIN sitehelps ON sitehelp_group_topic.sitehelp_id=sitehelps.id
- where sitehelp_group_topic.id='".$_REQUEST['helptopicid']."'" ;
-
- $groupcatsql_res = mysql_query($topicsql);
- $groupcatsql_arr = mysql_fetch_array($groupcatsql_res);
- $this->redirect('/sitehelp/view_group_topic/'.$groupcatsql_arr['helpgroupid']);
- }
- else
- $this->redirect('/sitehelp/index');
-
- }
- function delete_group_topic($topicid=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- if($topicid)
- {
-
- $topicsql = " SELECT sitehelp_group.id as helpgroupid from sitehelp_group_topic
- LEFT JOIN sitehelp_group ON sitehelp_group_topic.sitehelp_group_id =sitehelp_group.id
- LEFT JOIN sitehelps ON sitehelp_group_topic.sitehelp_id=sitehelps.id
- where sitehelp_group_topic.id='".$topicid."'" ;
-
- $groupcatsql_res = mysql_query($topicsql);
- $groupcatsql_arr = mysql_fetch_array($groupcatsql_res);
-
- $updatesql= "DELETE FROM sitehelp_group_topic Where id = '".$topicid."'";
- mysql_query($updatesql);
- $this->redirect('/sitehelp/view_group_topic/'.$groupcatsql_arr['helpgroupid']);
- }
- else
- $this->redirect('/sitehelp/index');
- }
-
- function view_group_topic_question($topicid=null)
- {
- if($topicid)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
-
- $grouptopicsql = "
- SELECT sitehelps.cat_name as CatName , sitehelps.id as CatId , sitehelp_group.id as groupid, sitehelp_group.group_name, sitehelp_group_topic.topic
- , sitehelp_group_topic.id ,sitehelp_group_topic_qa.*
-
- from sitehelp_group_topic_qa
- LEFT JOIN sitehelp_group_topic ON sitehelp_group_topic_qa.sitehelp_group_topic_id = sitehelp_group_topic.id
- LEFT JOIN sitehelp_group ON sitehelp_group_topic.sitehelp_group_id=sitehelp_group.id
- LEFT JOIN sitehelps ON sitehelp_group.sitehelp_id=sitehelps.id
- WHERE sitehelp_group_topic_qa.sitehelp_group_topic_id = '".$topicid."' ";
-
- $this->set('grouptopicquery', $grouptopicsql);
-
-
-
- /** GROUP NAME AND CATEGORY NAME */
- /*$groupcatsql = "Select sitehelps.cat_name,sitehelps.id as helpcatid , sitehelp_group.* from sitehelp_group
- LEFT JOIN sitehelps ON sitehelp_group.sitehelp_id = sitehelps.id
- where sitehelp_group.id='".$groupid."'";*/
- $groupcatsql = "
- SELECT sitehelps.cat_name as CatName , sitehelps.id as CatId , sitehelp_group.id as groupid, sitehelp_group.group_name, sitehelp_group_topic.topic
- , sitehelp_group_topic.id
-
- from sitehelp_group_topic
- LEFT JOIN sitehelp_group ON sitehelp_group_topic.sitehelp_group_id=sitehelp_group.id
- LEFT JOIN sitehelps ON sitehelp_group.sitehelp_id=sitehelps.id
-
- LEFT JOIN sitehelp_group_topic_qa ON sitehelp_group_topic.id=sitehelp_group_topic_qa.sitehelp_group_topic_id
- WHERE sitehelp_group_topic.id = '".$topicid."' ";
-
- $groupcatsql_res = mysql_query($groupcatsql);
- $groupcatsql_arr = mysql_fetch_array($groupcatsql_res);
- $this->set('groupcatsql', $groupcatsql_arr);
- /***/
- }
- else
- $this->redirect('/sitehelp/index');
- }
-
- function addquestion($categoryId=null , $groupId=null,$grouptopicId=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- $this->set('catgoryId',$categoryId);
- $this->set('groupId',$groupId);
- $this->set('grouptopicId',$grouptopicId);
-
- $categoryarr = array();
- /* Category array */
- $categorysql = "SELECT * from sitehelps where 1 ";
- if($categoryId)
- $categorysql .= " AND id='".$categoryId."'";
-
- $categorysql_res = mysql_query($categorysql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $categoryarr[$categorysql_arr['id']] = $categorysql_arr['cat_name'] ;
- }
- $this->set('categoryList',$categoryarr );
- /**/
- /*Group list*/
- $grouparr = array();
- $categorysql = "SELECT * from sitehelp_group where 1 ";
- if($categoryId)
- $categorysql .= " AND sitehelp_id='".$categoryId."'";
- if($groupId)
- $categorysql .= " AND id ='".$groupId."'";
- $categorysql_res = mysql_query($categorysql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $grouparr[$categorysql_arr['id']] = $categorysql_arr['group_name'] ;
- }
- $this->set('groupList',$grouparr );
- /**/
- /* TOPIC ARRAY */
- $topiicarr = array();
- $topicsql = "Select * from sitehelp_group_topic WHERE 1 ";
- if($categoryId)
- $topicsql .= " AND sitehelp_id='".$categoryId."'";
- if($groupId)
- $topicsql .= " AND sitehelp_group_id='".$groupId."'";
- if($grouptopicId)
- $topicsql .= " AND id='".$grouptopicId."'";
-
- $categorysql_res = mysql_query($topicsql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $topiicarr[$categorysql_arr['id']] = $categorysql_arr['topic'] ;
- }
- $this->set('topicList',$topiicarr );
- /**/
- }
- function edit_group_topic_question_answer($questionId=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- ########################################### QUESTION INFORMATION
- $questionsql = "SELECT * from sitehelp_group_topic_qa where id='".$questionId."'";
- $questionsql_res = mysql_query($questionsql);
- $questionsql_arr = mysql_fetch_array($questionsql_res);
- $categoryId = $questionsql_arr['sitehelp_id'];
- $groupId = $questionsql_arr['sitehelp_group_id'];
- $grouptopicId = $questionsql_arr['sitehelp_group_topic_id'];
- $groupquestion = $questionsql_arr['question'];
- $groupanswwer = $questionsql_arr['answer'];
- $screenshotImage = $questionsql_arr['screenshot'];
- $sitequestionId = $questionId;
-
- $this->set('catgoryId',$categoryId);
- $this->set('groupId',$groupId);
- $this->set('grouptopicId',$grouptopicId);
- $this->set('question',$groupquestion);
- $this->set('answer',$groupanswwer);
- $this->set('screenshotImage',$screenshotImage);
- $this->set('sitequestionId',$sitequestionId);
-
-
- $categoryarr = array();
- /* Category array */
- $categorysql = "SELECT * from sitehelps where 1 ";
- if($categoryId)
- $categorysql .= " AND id='".$categoryId."'";
-
- $categorysql_res = mysql_query($categorysql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $categoryarr[$categorysql_arr['id']] = $categorysql_arr['cat_name'] ;
- }
- $this->set('categoryList',$categoryarr );
- /**/
- /*Group list*/
- $grouparr = array();
- $categorysql = "SELECT * from sitehelp_group where 1 ";
- if($categoryId)
- $categorysql .= " AND sitehelp_id='".$categoryId."'";
- if($groupId)
- $categorysql .= " AND id ='".$groupId."'";
- $categorysql_res = mysql_query($categorysql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $grouparr[$categorysql_arr['id']] = $categorysql_arr['group_name'] ;
- }
- $this->set('groupList',$grouparr );
- /**/
- /* TOPIC ARRAY */
- $topiicarr = array();
- $topicsql = "Select * from sitehelp_group_topic WHERE 1 ";
- if($categoryId)
- $topicsql .= " AND sitehelp_id='".$categoryId."'";
- if($groupId)
- $topicsql .= " AND sitehelp_group_id='".$groupId."'";
- if($grouptopicId)
- $topicsql .= " AND id='".$grouptopicId."'";
-
- $categorysql_res = mysql_query($topicsql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $topiicarr[$categorysql_arr['id']] = $categorysql_arr['topic'] ;
- }
- $this->set('topicList',$topiicarr );
- /**/
- }
-
- function savequestion($questionid=null)
- {
-
- $destination = realpath('../../../app/webroot/sitehelpscreen/') . '/';
- $file = $this->data['sitehelpGroupTopicQa']['screenshot'];
- $Uploadfile = '';
- // upload the image using the upload component
- if($file!='')
- $result = $this->Upload->upload($file, $destination, null, array('type' => 'resizecrop', 'size' => array('400', '300'), 'output' => 'jpg'));
- if($result!='')
- $Uploadfile = basename($result);
-
- /* INSERTINO in the sitehelp_group_topic_qa Table */
- if($questionid)
- {
- $insertssql = "UPDATE sitehelp_group_topic_qa SET sitehelp_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_id']."' , sitehelp_group_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_group_id']."' ,
- sitehelp_group_topic_id='".$this->data['sitehelpGroupTopicQa']['sitehelp_group_topic_id']."' , question ='".addslashes($this->data['sitehelpGroupTopicQa']['question'])."' , answer = '".addslashes($this->data['sitehelpGroupTopicQa']['answer'])."' " ;
- if($Uploadfile!='')
- $insertssql .= " , screenshot ='".$Uploadfile."' " ;
-
- $insertssql .= " where id='".$questionid."' " ;
-
- }
- else
- {
- $insertssql = "INSERT INTO sitehelp_group_topic_qa SET sitehelp_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_id']."' , sitehelp_group_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_group_id']."' ,
- sitehelp_group_topic_id='".$this->data['sitehelpGroupTopicQa']['sitehelp_group_topic_id']."' , question ='".addslashes($this->data['sitehelpGroupTopicQa']['question'])."' , answer = '".addslashes($this->data['sitehelpGroupTopicQa']['answer'])."' , screenshot ='".$Uploadfile."' " ;
- }
- $insertssql_sql = mysql_query($insertssql);
- //echo $insertssql ;
-
- $this->redirect('/sitehelp/groupquestionlist/'.$this->data['sitehelpGroupTopicQa']['sitehelp_id'] .'/'. $this->data['sitehelpGroupTopicQa']['sitehelp_group_id'].'/'.$this->data['sitehelpGroupTopicQa']['sitehelp_group_topic_id']);
- }
- function groupquestionlist($sitehelpId=null,$groupId=null,$groupTopicId=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- $Questionlist = "
- Select sitehelps.cat_name As categoryName, sitehelp_group.group_name As groupName ,sitehelp_group_topic.topic As topicName , sitehelp_group_topic_qa.* from sitehelp_group_topic_qa
- LEFT JOIN sitehelps ON sitehelp_group_topic_qa.sitehelp_id = sitehelps.id
- LEFT JOIN sitehelp_group ON sitehelp_group_topic_qa.sitehelp_group_id = sitehelp_group.id
- LEFT JOIN sitehelp_group_topic ON sitehelp_group_topic_qa.sitehelp_group_topic_id = sitehelp_group_topic.id
-
- where 1 ";
- if($sitehelpId)
- {
- $Questionlist .= " AND sitehelp_group_topic_qa.sitehelp_id = '". $sitehelpId ."' " ;
- $this->set('groupCatId' ,$sitehelpId );
-
- }
- if($groupId)
- {
- $Questionlist .= " AND sitehelp_group_topic_qa.sitehelp_group_id = '". $groupId ."' " ;
- }
- if($groupTopicId)
- {
- $Questionlist .= " AND sitehelp_group_topic_qa.sitehelp_group_topic_id = '". $groupTopicId ."' " ;
- }
-
- $this->set('questionsql',$Questionlist);
- }
-
- function edit_question($questionid=null)
- {
- $this->checkSession();
- $this->layout = 'default_user_cat';
- $categoryarr = array();
- /* Category array */
- $categorysql = "SELECT * from sitehelps where 1 ";
-
- $categorysql_res = mysql_query($categorysql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $categoryarr[$categorysql_arr['id']] = $categorysql_arr['cat_name'] ;
- }
- $this->set('categoryList',$categoryarr );
- /**/
- /*Group list*/
- $grouparr = array();
- $categorysql = "SELECT * from sitehelp_group where 1 ";
- $categorysql_res = mysql_query($categorysql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $grouparr[$categorysql_arr['id']] = $categorysql_arr['group_name'] ;
- }
- $this->set('groupList',$grouparr );
- /**/
- /* TOPIC ARRAY */
- $topiicarr = array();
- $topicsql = "Select * from sitehelp_group_topic WHERE 1 ";
- $categorysql_res = mysql_query($topicsql);
- while($categorysql_arr = mysql_fetch_array($categorysql_res))
- {
- $topiicarr[$categorysql_arr['id']] = $categorysql_arr['topic'] ;
- }
- $this->set('topicList',$topiicarr );
-
- /* QUESTION LIST */
- if($questionid)
- {
- $Questionlist = "Select sitehelp_group_topic_qa.* from sitehelp_group_topic_qa
- where sitehelp_group_topic_qa.id='".$questionid."' ";
- $Questionlist_res = mysql_query($Questionlist);
- $Questionlist_arr = mysql_fetch_array($Questionlist_res);
-
- $this->set('helpcatId' , $Questionlist_arr['sitehelp_id']);
- $this->set('helpgroupId' , $Questionlist_arr['sitehelp_group_id']);
- $this->set('helpgrouptopicId' , $Questionlist_arr['sitehelp_group_topic_id']);
- $this->set('helpquestion' , $Questionlist_arr['question']);
- $this->set('helpanswer' , $Questionlist_arr['answer']);
- $this->set('helpscreen' , $Questionlist_arr['screenshot']);
- $this->set('helpId' , $Questionlist_arr['id']);
- $this->set('helpaction' , 'edit');
- }
- else
- $this->set('helpaction' , 'insert');
-
-
- /**/
- }
- function saveeditquestion()
- {
-
-
-
- $destination = realpath('../../../app/webroot/sitehelpscreen/') . '/';
- $file = $this->data['sitehelpGroupTopicQa']['screenshot'];
- $Uploadfile = '';
- // upload the image using the upload component
- $result = $this->Upload->upload($file, $destination, null, array('type' => 'resizecrop', 'size' => array('400', '300'), 'output' => 'jpg'));
- if($result!='')
- $Uploadfile = basename($result);
-
- /* INSERTINO in the sitehelp_group_topic_qa Table */
- if(isset($_REQUEST['questionaction']) && $_REQUEST['questionaction']=='insert')
- {
- $insertssql = "INSERT INTO sitehelp_group_topic_qa SET sitehelp_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_id']."' , sitehelp_group_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_group_id']."' ,
- sitehelp_group_topic_id='".$this->data['sitehelpGroupTopicQa']['sitehelp_group_topic_id']."' , question ='".$this->data['sitehelpGroupTopicQa']['question']."' , answer = '".addslashes($this->data['sitehelpGroupTopicQa']['answer'])."' , screenshot ='".$Uploadfile."' " ;
-
- $insertssql_sql = mysql_query($insertssql);
-
- }
- else
- {
- if(isset($_REQUEST['questionaction']) && $_REQUEST['questionaction']=='edit')
- {
- $updatequestion = "UPDATE sitehelp_group_topic_qa SET sitehelp_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_id']."' , sitehelp_group_id = '".$this->data['sitehelpGroupTopicQa']['sitehelp_group_id']."' ,
- sitehelp_group_topic_id='".$this->data['sitehelpGroupTopicQa']['sitehelp_group_topic_id']."' , question ='".$this->data['sitehelpGroupTopicQa']['question']."' , answer = '".addslashes($this->data['sitehelpGroupTopicQa']['answer'])."' ";
-
- if($Uploadfile!='')
- $updatequestion .= " , screenshot ='".$Uploadfile."' ";
-
- $updatequestion .= " where id='".$_REQUEST['questionid']."' ";
-
- $insertssql_sql = mysql_query($updatequestion);
-
- }
- }
-
-
- $this->redirect('/sitehelp/groupquestionlist/'.$this->data['sitehelpGroupTopicQa']['sitehelp_id'] .'/'. $this->data['sitehelpGroupTopicQa']['sitehelp_group_id'].'/'.$this->data['sitehelpGroupTopicQa']['sitehelp_group_topic_id']);
- }
-
- function view_question($questionid=null)
- {
-
- $this->checkSession();
- $this->layout = 'default_user_cat';
- /* QUESTION LIST */
- if($questionid)
- {
- $Questionlist = "
- Select sitehelps.cat_name As categoryName, sitehelp_group.group_name As groupName ,sitehelp_group_topic.topic As topicName , sitehelp_group_topic_qa.* from sitehelp_group_topic_qa
- LEFT JOIN sitehelps ON sitehelp_group_topic_qa.sitehelp_id = sitehelps.id
- LEFT JOIN sitehelp_group ON sitehelp_group_topic_qa.sitehelp_group_id = sitehelp_group.id
- LEFT JOIN sitehelp_group_topic ON sitehelp_group_topic_qa.sitehelp_group_topic_id = sitehelp_group_topic.id where sitehelp_group_topic_qa.id='".$questionid."' " ;
-
- $Questionlist_res = mysql_query($Questionlist);
- $Questionlist_arr = mysql_fetch_array($Questionlist_res);
-
- $this->set('helpcatName' , $Questionlist_arr['categoryName']);
- $this->set('helpgroupName' , $Questionlist_arr['groupName']);
- $this->set('helpgrouptopicName' , $Questionlist_arr['topicName']);
- $this->set('helpquestion' , $Questionlist_arr['question']);
- $this->set('helpanswer' , $Questionlist_arr['answer']);
- $this->set('helpscreen' , $Questionlist_arr['screenshot']);
- }
-
- }
-
- function delete_question($questionid=null)
- {
- $delsql = " DELETE from sitehelp_group_topic_qa where id='".$questionid."'" ;
- mysql_query($delsql);
- $this->redirect($_SERVER['HTTP_REFERER']);
- }
-
- }
- ?>