function formatSeconds(seconds) { var date = new Date(1970,0,1); date.setSeconds(seconds); return date.toTimeString().replace(/.*(\d{2}:\d{2}:\d{2}).*/, "$1"); }
不建议这样使用, 如果有很复杂的SQL也可以用Laravel的query封装起来,比如像下面的这样。
$users = \DB::table('users')->select(\DB::raw('users.id,if(cargo_owners.status is null, vehicle_owners.status, cargo_owners.status) as status, if(cargo_owners.name is null, vehicle_owners.name, cargo_owners.name) as name,users.`created_at`,cargo_owners.type sub_type, users.type')) ->leftJoin('cargo_owners', 'cargo_owners.id' , 'users.id') ->leftJoin('vehicle_owners', 'vehicle_owners.id' , 'users.id'); $users->paginate();
JoyK Better personal homepage reddit styleGitHub Flavored Markdown syntax Adaptive layout
不建议这样使用, 如果有很复杂的SQL也可以用Laravel的query封装起来,比如像下面的这样。