|
|
|
ช่วยดู Error หน่อยคะ มันerror ->get(); // Error This Line หาไม่เจอ |
|
|
|
|
|
|
|
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 :
564 |
Reply :
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
->whereBetween('master.VisitDate',['04/02/2018','04/02/2018'])
|
|
|
|
|
Date :
2018-05-19 10:35:35 |
By :
mongkon.k |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ปิดวงเล็บที่บันทัด 07
|
|
|
|
|
Date :
2018-05-19 16:14:25 |
By :
Chaidhanan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 02
|