API tools faq
paste
Advertisement
Guest User

Controller

a guest
Nov 21st, 2014
215
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.76 KB | None | 0 0
raw download clone embed print report
  1.     public function listPrsdk()
  2.     {
  3.         $StaffID = Session::get('UserID'); 
  4.         $user = DB::table('staff')->where('StaffID', $StaffID)->first();       
  5.         $pid = ('12,13,10');
  6.         $sqls="select perm.permission_id, sum(perm.status) as status from
  7.     (
  8.     select concat('p',pm.permission_id) as permission_id, case when rp.permission_id is not null then true else false end as status from permission_master as pm left outer join role_permission as rp on pm.permission_id = rp.permission_id and rp.roleId = ".$user->RoleID." where pm.permission_id in (".$pid.")
  9.  
  10.     union all
  11.  
  12.     select concat('p',pm.permission_id) as permission_id, case when sp.permission_id is not null then true else false end as status from permission_master as pm left outer join staff_permission as sp on pm.permission_id = sp.permission_id and sp.staffid = ".$StaffID." where pm.permission_id in (".$pid.")
  13.     ) as perm group by perm.permission_id ";
  14.             $result = DB::select($sqls);
  15.             $permission = array();
  16.                     foreach($result as $val)
  17.                         {
  18.                             $permission[$val->permission_id] = $val->status;
  19.                         }
  20.             $userId= Session::get('UserID');
  21.         $roleId= Session::get('RoleID');
  22.            
  23.         $page = Input::get('page');    
  24.  
  25.         //Filters
  26.         $PrsNo    = Input::get('prsno');
  27.         $PrsRequestedBy    = Input::get('prsreqby');
  28.         $PrsDepartment    = Input::get('prsdepar');    
  29.         $PrsTheme    = Input::get('prstheme');             
  30.         $PrsMerchandiserName  = Input::get('prsmername');
  31.         $SentDate  = Input::get('prssentdate');
  32.         $PrsStatus  = Input::get('pstatus');   
  33.  
  34.         $Search      = Input::get('searchtype');       
  35.         $rp   = Input::get('rp');
  36.         $sortname = Input::get('sortname');
  37.         $sortorder = Input::get('sortorder');
  38.        
  39.         $def_val = "WHERE prs.Status!='0' and prs.ReqBy = ".$userId;
  40.        
  41.         if (!$sortname) $sortname = 'prs.PrsNumber';
  42.        
  43.         if (!$sortorder) $sortorder = 'desc';
  44.        
  45.         if($Search != "1")
  46.         {
  47.             if(Input::get('query')!=''){
  48.                 $where = "$def_val and ".Input::get('qtype')." LIKE '%".Input::get('query')."%' ";
  49.             } else {
  50.                 $where =" where prs.Status!='0' and prs.ReqBy = ".$userId." ";
  51.             }
  52.             if(Input::get('letter_pressed')!=''){
  53.                 $where = "$def_val and ".Input::get('qtype')." LIKE '%".Input::get('letter_pressed')."%' ";
  54.             }
  55.             if(Input::get('letter_pressed')=='#'){
  56.                 $where = "$def_val and ".Input::get('qtype')." REGEXP '[[:digit:]]' "; 
  57.             }
  58.         }
  59.         else if($Search == "1")
  60.         {
  61.             $where = $def_val;
  62.                 //Filters
  63.        
  64.             if($PrsNo  != "")
  65.             {
  66.                 $where .= " and prs.PrsNumber like '%".$PrsNo."%' ";
  67.             }
  68.             if($PrsRequestedBy != "")
  69.             {
  70.               $where .= " and prs.ReqBy LIKE '%".$PrsRequestedBy."%' ";
  71.             }
  72.             if($PrsDepartment!= "")
  73.             {
  74.               $where .= "and dep.DeptName LIKE '%".$PrsDepartment."%' ";
  75.             }
  76.             if($PrsTheme != "")
  77.             {
  78.                 $where .= "and prs.PrsTheme = '".$PrsTheme."' ";
  79.             }  
  80.  
  81.             if($PrsMerchandiserName!=  "0")
  82.             {
  83.                 $where .= " and st.StaffID= '".$PrsMerchandiserName."' ";
  84. //            $where .= "and st.StaffID LIKE '%".$PrsMerchandiserName."%' ";
  85.             }
  86.             if($SentDate != "")
  87.             {
  88.                 $where .= "and prs.created_at = '".$SentDate."' ";
  89.             }
  90.        
  91.             if($PrsStatus != "0")
  92.             {
  93.                 $where .= " and ac.ActionID  = '".$PrsStatus."' ";
  94.             }
  95.         }
  96.        
  97.        
  98.         $sort = "ORDER BY $sortname $sortorder";
  99.        
  100.         if (!$page) $page = 1;
  101.         if (!$rp) $rp = 10;
  102.        
  103.         $start = (($page-1) * $rp);
  104.        
  105.         $limit = "LIMIT $start, $rp";
  106.  
  107.  
  108.         /*old one $result = DB::select("select st.RoleID,prs.ReqBy as ReqBy,prs.PrsNumber, dep.DeptName, st.StaffName,prs.PrsTheme, date_format(prs.created_at,'%d-%m-%Y') as created_at,ac.ActionName,prs.Status,prs.PrsdkID,prs.PrsTheme as ThemeName from prsdk prs left join department dep on dep.DeptID= prs.DeptID left join staff st on st.StaffID = prs.ReqBy left join action ac on ac.ActionID = prs.Action  $where $sort $limit");*/
  109.        
  110.         /*  $result = DB::select("select 'login user' as ReqBy,prs.PrsNumber, dep.DeptName,  group_concat( concat(st.StaffName, ' ') SEPARATOR '<br>') as StaffName,prs.PrsTheme, date_format(prs.created_at,'%d-%m-%Y') as created_at,ac.ActionName,prs.Status,prs.PrsdkID,prs.PrsTheme as ThemeName from prsdk prs left join department dep on dep.DeptID= prs.DeptID left join staff st on st.StaffID in (select pdk.PrimaryMerchandiser from prsdk pdk left join staff f on f.staffID=pdk.PrimaryMerchandiser ) left join action ac on ac.ActionID = prs.Action $where group by prs.PrsdkID $sort $limit");*/
  111.    
  112.         //$result=DB::select("select prs.PrsdkID,group_concat( concat(st.StaffName, ' ') SEPARATOR '<br>') as StaffName,st.RoleID,prs.ReqBy as ReqBy,prs.PrsNumber, dep.DeptName,prs.PrsTheme, date_format(prs.created_at,'%d-%m-%Y') as created_at,ac.ActionID,ac.ActionName,ac.ActionID,prs.Status,prs.PrsdkID,prs.PrsTheme as ThemeName from prsdk prs left join prsdk_primerchandiser pm on pm.PrsdkID=prs.PrsdkID and pm.Status!='0' left join staff st on st.StaffID =pm.PrimaryMerchandiser left join department dep on dep.DeptID= prs.DeptID left join action ac on ac.ActionID = prs.Action $where group by prs.PrsdkID $sort $limit");
  113.    
  114.     //  $result=DB::select("select prs.PrsdkID,group_concat( concat(st.StaffName, ' ') SEPARATOR '<br>') as StaffName,st.RoleID,prs.ReqBy as ReqBy,prs.SendTo,prs.GotResponse,prs.PrsNumber, dep.DeptName,prs.PrsTheme, date_format(prs.created_at,'%d-%m-%Y') as created_at,ac.ActionID,ac.ActionName,prs.Status,prs.PrsdkID,prs.PrsTheme as ThemeName from prsprimary prs left join prsdk_primerchandiser pm on pm.PrsdkID=prs.PrsdkID  and pm.PrimaryMerchandiser= prs.PriMerOID and pm.Status!='0' left join staff st on st.StaffID =pm.PrimaryMerchandiser left join department dep on dep.DeptID= prs.DeptID left join action ac on ac.ActionID = pm.Action $where group by prs.PrsdkID $sort $limit");
  115.     // the above query is replaced - just removed staff name
  116.         $result=DB::select("select prs.PrsdkID,group_concat( concat(st.StaffName, ' ') SEPARATOR '<br>') as StaffName,st.RoleID,prs.ReqBy as ReqBy,prs.SendTo,prs.GotResponse,prs.PrsNumber, dep.DeptName,prs.PrsTheme, date_format(prs.created_at,'%d-%m-%Y') as created_at,ac.ActionID,ac.ActionName,prs.Status,prs.PrsdkID,prs.PrsTheme as ThemeName from prsprimary prs left join prsdk_primerchandiser pm on pm.PrsdkID=prs.PrsdkID  and pm.PrimaryMerchandiser= prs.PriMerOID and pm.Status!='0' left join staff st on st.StaffID =pm.PrimaryMerchandiser left join department dep on dep.DeptID= prs.DeptID left join action ac on ac.ActionID = pm.Action $where group by prs.PrsdkID $sort $limit");
  117.    
  118.         //return $result;
  119.         $total = $this->countRec('PrsdkID','prsdk',$where);
  120.         header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
  121.         header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
  122.         header("Cache-Control: no-cache, must-revalidate" );
  123.         header("Pragma: no-cache" );
  124.         header("Content-type: text/x-json");
  125.         $json = "";
  126.         $json .= "{\n";
  127.         $json .= "page: $page,\n";
  128.         $json .= "total: $total,\n";
  129.         $json .= "rows: [";
  130.         $rc = false;
  131.         $i=1;
  132.         //while ($row = mysql_fetch_array($result)) {
  133.         foreach($result as $row) {
  134.             if(addslashes(trim($row->Status))=="1"){ $status = "Enable"; }else{ $status = "Disable";}
  135.         if ($rc) $json .= ",";
  136.         $json .= "\n{";
  137.         $json .= "PrsdkID:'".trim($row->PrsdkID)."',";
  138.         $json .= "cell:['<input id=\"demo_box_".$i."\" class=\"css-checkbox csscheck\" type=\"checkbox\" value=\"".trim($row->PrsdkID)."\"  /><label for=\"demo_box_".$i."\" name=\"demo_lbl_".$i."\" class=\"css-label\"></label>'";
  139.     //  $json .= ",'".addslashes(trim($row->PrsNumber))."'";
  140.    
  141.  
  142.     $json .= ",'<a class=\"edit\" onClick=\"TINY.box.show({url:\'supresponse/".trim($row->PrsdkID)."\',animate:true,openjs:opennewjs()})\">$row->PrsNumber</a>'";  
  143.  
  144.         //$json .= ",'".addslashes(trim($row->ReqBy))."'";
  145.         $json .= ",'".addslashes(trim($row->DeptName))."'";
  146.         $json .= ",'".addslashes(trim($row->ThemeName))."'";
  147.         $json .= ",'".addslashes(trim($row->StaffName))."'";
  148.         $json .= ",'".addslashes(trim($row->created_at))."'";
  149.         $actionid=$row->ActionID;
  150.         if ($actionid==3)//pri reveiwed
  151.         {
  152.             $json .= ",'<font color=\"#003399\">".addslashes(trim($row->ActionName))."</font>'";
  153.         }
  154.         elseif ($actionid==1)//approved
  155.         {
  156.             $json .= ",'<font color=\"#00CC33\">".addslashes(trim($row->ActionName))."</font>'";
  157.         }
  158.         elseif ($actionid==2)//yettoreview
  159.         {
  160.             $json .= ",'<font color=\"#FF0000\">".addslashes(trim($row->ActionName))."</font>'";
  161.         }
  162.         elseif ($actionid==4)//Response
  163.         {
  164.             $json .= ",'<font color=\"#FF00FF\">".addslashes(trim($row->ActionName))."</font>'";
  165.         }
  166.         elseif ($actionid==5)//Sec Reviewed
  167.         {
  168.             $json .= ",'<font color=\"#0066FF\">".addslashes(trim($row->ActionName))."</font>'";
  169.         }
  170.         //$json .= ",'".addslashes(trim($row->ActionName))."'";    
  171.         $actionid=$row->ActionID;
  172.          
  173.         /*if ($actionid==2)//yet to review only edit /delete option
  174.         {*/
  175.        
  176.         $json .= ",'";
  177.         $pipe = "|";
  178.         $data = array();
  179.         if ($permission["p12"] >= 1)  $data[] = "<a class=\"edit\" onClick=\"TINY.box.show({url:\'prsdkupdate/".trim($row->PrsdkID)."\',animate:true,openjs:opennewjs1()})\">Update</a>&nbsp;&nbsp;";
  180.         if ($permission["p13"] >= 1)  $data[] = "&nbsp;&nbsp;<a class=\"delete\" onClick=\"TINY.box.show({url:\'prsdkdelete\',width:366,height:120,animate:true,openjs:function(){delete_prsdk(\'2\', \'".trim($row->PrsdkID)."\')}, closejs:function(){}})\">Delete</a>";
  181.         $json .= implode($pipe, $data);
  182.         $json .= "']";     
  183. //      $json .= ",'<a class=\"edit\" onClick=\"TINY.box.show({url:\'prsdkupdate/".trim($row->PrsdkID)."\',animate:true,openjs:opennewjs1()})\">Update</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a class=\"delete\" onClick=\"TINY.box.show({url:\'prsdkdelete\',width:366,height:120,animate:true,openjs:function(){delete_prsdk(\'2\', \'".trim($row->PrsdkID)."\')}, closejs:function(){}})\">Delete</a>']";
  184.         $json .= "}";
  185.         $rc = true;
  186.         $i++;
  187.         }
  188.         $json .= "]\n";
  189.         $json .= "}";
  190.         return $json;
  191.       // return $json;
  192.     //  $tbl = DB::table('portofload')->get();
  193.         //return View::make('settings/portofload/portofloadlist');
  194.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!