  | 
		 		   | 
	  	    
          
            
			
	
			
			 
                Code (PHP) 
public function Detail()
{
//RAW QUERIES
	$Detail = DB::table('DBTEST.dbo.MASTER  as master')
				->select('master.VisitDate','sysconfig.LocalName',
					'Clinic,count(master.VN) as VN',
					'count(distinct prescrip.Doctor)as DC'
				->join('DBTEST.dbo.PRESCRIP  as prescrip','master.VN','=','prescrip.VisitDate')
				->join('DBTEST.dbo.CONFIG  as sysconfig','prescrip.Clinic','=','sysconfig.code')
				->where([['master.cxl','=','0'],['prescrip.Clinic','=','ER'],['sysconfig.CtrlCode','=','42203']])
				->whereBetween('master.VisitDate',[04/02/2018,04/02/2018])
				->whereIn('prescrip.Clinic', array('AC','ADIO','ADM','AJ','AN','BNC','CATH','CCU','CD','CHK','CN',
				'CONSULT','DEN','DON','ENT','ER','EYE','HC','HEMO','HOC','ICU','LAB','LR','LSK','MED','MED2','MGI',
					'MHC','MS','NEURO','NUR','NUT','OPG','OV','OTH','PED','PHR','PT','SKIN','SMO','SUG','WME','WPD',
					'WSG','XRAY'))
				->groupBy('master.VisitDate','sysconfig.LocalName','Clinic')
				->get();  // Error This Line
	dd($Detail);
	return view('Report/VisitToday',['Detail'=>$Detail]);
  }
    
    "Parse error: syntax error, unexpected ';', expecting ',' or ')'"
 
 
  Tag : PHP, Ms SQL Server 2016, Laravel  Framework               
                        | 
           
          
            
		
  ประวัติการแก้ไข 2018-05-19 10:05:58	
                             | 
           
          
            
              
                   | 
                   | 
                   | 
               
              
                   | 
                
                    
                      | Date :
                          2018-05-19 10:04:59 | 
                      By :
                          nottpoo | 
                      View :
                          641 | 
                      Reply :
                          2 | 
                     
                  | 
                   | 
               
              
                   | 
                   | 
                   | 
               
              | 
           
          
            | 
			 | 
           
         
	    
		             | 
		
			  |