Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. async getAddedActivities(vehicle_no,sv_activity_id){
  2. try {
  3. let config={
  4. 'Content-Type':'application/json'
  5. }
  6. const response = await axios.get('get-temp-sv-activities/'+vehicle_no+'/'+sv_activity_id,config);
  7.  
  8. if(response.data.alert=='success'){
  9. this.extra_details_sv = response.data.result
  10. console.log(response.data.result);
  11.  
  12. var dd = response.data.result;
  13. console.log(dd);
  14.  
  15. }else if(response.data.alert=='empty'){
  16. this.extra_details_sv = []
  17. }else{
  18. toastr.error(response.data.msg)
  19. }
  20.  
  21. } catch (error) {
  22. console.error(error);
  23. }
  24. }
  25.  
  26. public function getTempSvActivities(Request $request){
  27. try{
  28. $vehicle_no = $request->vehicle_no;
  29. $sv_activity_id = $request->sv_activity_id;
  30. $user_id = auth()->user()->id;
  31. $date = date("Y-m-d");
  32.  
  33. $query="SELECT c.CustomerCode, c.CustomerName, c.Address, JSON_OBJECTAGG(sf.Feild_name,IF(svd.Detail=3,dt.type,svd.Value)) AS Val
  34. FROM service_vehicle_planner_h2 svph2
  35. INNER JOIN customer c ON c.CustomerId = svph2.Customer_code
  36. INNER JOIN service_vehicle_details svd ON svd.IDservice_vehicle_planner_H2 = svph2.IDservice_vehicle_planner_H2
  37. INNER JOIN service_fields sf ON sf.IDService_fields = svd.Detail
  38. INNER JOIN dispenser_types dt ON dt.id = svd.Detail";
  39.  
  40. $res = DB::select($query);
  41.  
  42. Debugbar::info($res);
  43.  
  44. if(!count($res)==0){
  45. return response()->json(['alert'=>'success','result'=>$res]);
  46. }else{
  47. return response()->json(['alert'=>'empty']);
  48. }
  49.  
  50. }catch (Exception $e){
  51. return response()->json(['msg'=>$e->getMessage()]);
  52. }
  53.  
  54. }
  55.  
  56. array:1 [▼
  57. 0 => {#468 ▼
  58. +"CustomerCode": "PEO198"
  59. +"CustomerName": " PEOPLE CONNECT PVT LTD"
  60. +"Address": " PEOPLE CONNECT PVT LTD, 57 W.A. SILVA MAWATHA, COLOMBO 060112555590 0777881238 "
  61. +"Val": "{"Full Bottles": "2", "Empty Bottles": "2", "Dispenser Type": "Table Top", "Number of Dispensers": "2"}"
  62. }
  63. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement