API tools faq
paste
lukmanulhakim

1. new controller

lukmanulhakim
Feb 17th, 2020
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 47.65 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. namespace App\Http\Controllers;
  4.  
  5. use App\MachineSettingsA;
  6. use App\MachineSettingsB;
  7. use App\Machine;
  8. use App\injectdailymcl_A;
  9. use App\injectdailymcl_B;
  10. use App\RevisiHistory;
  11. use App\HotRunnerSystem;
  12. use Illuminate\Http\Request;
  13. use Auth;
  14. use Illuminate\Support\Facades\DB;
  15. use QRCode;
  16. use Excel;
  17. use App\Exports\MclExport;
  18. use App\StandarSettingsA;
  19. use App\StandarSettingsB;
  20. use Illuminate\Validation\Rule;
  21. class NewmachineController extends Controller
  22. {
  23.  
  24.  
  25. public function __construct()
  26. {
  27. $this->middleware('auth');
  28. }
  29.  
  30.  
  31.  
  32. public function index(request $request)
  33. {
  34.  
  35.  
  36. // $data_machine = \App\Machine::all();
  37.  
  38.  
  39. //$revisi = \App\RevisiHistory::all();
  40.  
  41.  
  42.  
  43.  
  44.  
  45. // $data_machine = DB::select("SELECT * from revisi_history, machine LEFT JOIN ( SELECT DISTINCT gambar1 FROM revisi_history ORDER BY created_at ASC LIMIT 1) revisi_history ON machine.id = revisi_history.machine_id where machine.id = 139 group by machine.id");
  46. // $data_machine = DB::select("SELECT a.*, b.id from machine b left join revisi_history a on a.machine_id = b.id where b.id = 139 group by a.created_at DESC limit 1");
  47. // $data_machine = DB::select("SELECT * from machine left join (SELECT * from revisi_history c where c.id = (SELECT MAX(id) from revisi_history where machine_id = machine.id ))revisi_history on revisi_history.machine_id = machine.id where machine.id = 139");
  48. $data_machine = DB::select("SELECT machine.*, revisi_history.gambar1 from machine left join revisi_history on revisi_history.machine_id = machine.id and revisi_history.id = (SELECT MAX(id) from revisi_history where machine_id = machine.id)");
  49.  
  50. // dd($data_machine);
  51. /*$data_machineA = DB::select('machine')->leftJoin( SELECT DISTINCT ON('machine_id') 'gambar1' FROM 'revisi_history' orderBy created_at 'desc','revisi_history.machine_id','=','machine.id')->select('machine.*','revisi_history.gambar1')->groupBy('machine.id')->get();
  52. //dd($data_machine);
  53. */
  54. // $machine = DB::table('mcl_daily_a')->where('machine_id',42)->selectRaw("mold_temp_controller as y, DATE_FORMAT('created_at', '%Y') as date")->get();
  55. $machine = DB::table('mcl_daily_a')->join('mcl_daily_b', 'mcl_daily_a.id','mcl_daily_b.type')
  56. ->where('mcl_daily_a.machine_id',48)->selectRaw("mcl_daily_b.date as x, mold_temp_controller as y")->get();
  57.  
  58. // return response()->json($machine);
  59.  
  60.  
  61. return view('newmachine.index',['data_machine' => $data_machine,'machine' => $machine]);
  62. }
  63.  
  64. public function profile($id)
  65. {
  66. // $machine= \App\Machine::find($id);
  67.  
  68. //$machine = DB::select(" SELECT machine.*, hot_runner.pict1 from machine left join hot_runner on hot_runner.machine_id = machine.id and hot_runner.id = (SELECT MAX(id) from hot_runner where and where machine.id = $id machine_id = machine.id)");
  69.  
  70. $machine = DB::table('machine')->leftJoin('hot_runner','machine.id','hot_runner.machine_id')->where('machine.id',$id)->first();
  71.  
  72.  
  73.  
  74. //$allhotrunner = \App\HotRunnerSystem::where('machine_id',$id)->first();
  75. $machine_settingA = \App\MachineSettingsA::where('machine_id',$id)->first();
  76. $machine_settingB = \App\MachineSettingsB::where('machine_id', $id)->first();
  77. $all_setting = DB::table('standar_setting')->join('standar_settingb','standar_setting.id','standar_settingb.type')->where('standar_setting.machine_id',$id)->first();
  78. // $machine_inputA = injectdailymcl_A::where('machine_id',$id)->get();
  79. // $machine_inputB = injectdailymcl_B::where('machine_id', $id)->get();
  80. // dd($all_setting);
  81.  
  82. $all_hotrunner = DB::table('hot_runner')->where('hot_runner.machine_id',$id)->orderBy('hot_runner.date','desc')->select('hot_runner.*','hot_runner.id as machine_id')->get();
  83.  
  84. $all_machine = DB::table('mcl_daily_a')->join('mcl_daily_b', 'mcl_daily_a.id','mcl_daily_b.type')
  85. ->where('mcl_daily_a.machine_id',$id)->orderBy('mcl_daily_b.date','desc')->select('mcl_daily_a.*','mcl_daily_b.*','mcl_daily_a.id as daily_id')->get();
  86.  
  87. $all_revisi = DB::table('revisi_history')->where('revisi_history.machine_id',$id)->orderBy('revisi_history.date','desc')->select('revisi_history.*','revisi_history.id as revisi_id')->get();
  88.  
  89.  
  90. // array_push($machine_inputA, $machine_inputB);
  91. // return $machine_inputA;
  92. return view('newmachine.profile',['machine'=> $machine, 'machine_settingA' => $machine_settingA, 'machine_settingB' => $machine_settingB, 'machine_inputA' => $all_machine,'settings' => $all_setting , 'all_revisi' => $all_revisi, 'allhotrunner'=> $all_hotrunner]);
  93. }
  94.  
  95. public function inputdaily($id)
  96. {
  97. $machine= \App\Machine::find($id);
  98. $machine_settingA = \App\MachineSettingsA::where('machine_id',$id)->first();
  99. $machine_settingB = \App\MachineSettingsB::where('machine_id', $id)->first();
  100. $all_setting = DB::table('standar_setting')->join('standar_settingb','standar_setting.id','standar_settingb.type')->where('standar_setting.machine_id',$id)->first();
  101. return view('newmachine.inputdaily',['machine'=> $machine,'machine_settingA' => $machine_settingA,'machine_settingB' => $machine_settingB,'settings' => $all_setting, 'id' => $id]);
  102. }
  103.  
  104. public function revisi($id)
  105. {
  106. $machine= \App\Machine::find($id);
  107. $machine_settingA = \App\MachineSettingsA::where('machine_id',$id)->first();
  108. $machine_settingB = \App\MachineSettingsB::where('machine_id', $id)->first();
  109. $all_setting = DB::table('standar_setting')->join('standar_settingb','standar_setting.id','standar_settingb.type')->where('standar_setting.machine_id',$id)->first();
  110. return view('newmachine.revisi',['machine'=> $machine,'machine_settingA' => $machine_settingA,'machine_settingB' => $machine_settingB,'settings' => $all_setting, 'id' => $id]);
  111. }
  112.  
  113.  
  114.  
  115. public function create_machine(Request $request)
  116. {
  117.  
  118. $line_number = $request->line;
  119. $machine_name = $request->machine_name;
  120. $model = $request->model;
  121. $part_name = $request->part_name;
  122. $part_code= $request->part_code;
  123. $mold_no = $request->mold_no;
  124. $cavity_no = $request->cavity_no;
  125. $mold_temp = $request->mold_temp;
  126. $cycle_time = $request->cycle_time;
  127. $fill_time = $request->fill_time;
  128. $fill_peak = $request->fill_peak;
  129. $scr_most_mm = $request->scr_most_mm;
  130. $scr_most_mpa = $request->scr_most_mpa;
  131. $mtg_ready = $request->mtg_ready;
  132. $plast_tm = $request->plast_tm;
  133. $inj_end_position = $request->inj_end_position;
  134. $sm = $request->sm;
  135. $pp1 = $request->pp1;
  136. $pp2 = $request->pp2;
  137. $pp3 = $request->pp3;
  138. $vp_change = $request->vp_change;
  139. $pv1 = $request->pv1;
  140. $p1 = $request->p1;
  141. $s5 = $request->s5;
  142. $p2 = $request->p2;
  143. $p3 = $request->p3;
  144. $distinction = $request->distinction;
  145. $f1 = $request->f1;
  146. $f2 = $request->f2;
  147. $h1 = $request->h1;
  148. $h2 = $request->h2;
  149. $h3 = $request->h3;
  150. $h4 = $request->h4;
  151. $h5 = $request->h5;
  152. $h6 = $request->h6;
  153. $h7 = $request->h7;
  154. $h8 = $request->h8;
  155. $h9 = $request->h9;
  156. $h10 = $request->h10;
  157. $h11 = $request->h11;
  158. $h12 = $request->h12;
  159. $h13 = $request->h13;
  160. $h14 = $request->h14;
  161. $h15 = $request->h15;
  162. $h16 = $request->h16;
  163. $diff = $request->diff;
  164. $gate_open_delay = $request->gate_open_delay;
  165. $gate_open_time = $request->gate_open_time;
  166. $cool_tm = $request->cool_tm;
  167. $a1t = $request->a1t;
  168. $a1b = $request->a1b;
  169. $b1t = $request->b1t;
  170. $b1b = $request->b1b;
  171. $a2t = $request->a2t;
  172. $a2b = $request->a2b;
  173. $b2t = $request->b2t;
  174. $b2b = $request->b2b;
  175. $chiller_temp = $request->chiller_temp;
  176. $screw_speed = $request->screw_speed;
  177. $melt_temp = $request->melt_temp;
  178. $motor_current = $request->motor_current;
  179. $weight = $request->weight;
  180. $span = $request->span;
  181. $temp_setting_l1 = $request->temp_setting_l1;
  182. $temp_setting_l2 = $request->temp_setting_l2;
  183. $temp_setting_l3 = $request->temp_setting_l3;
  184. $temp_setting_l4 = $request->temp_setting_l4;
  185. $pre_below_time_l = $request->pre_below_time_l;
  186. $pre_below_time_r = $request->pre_below_time_r;
  187. $calibrator_down_l = $request->calibrator_down_l;
  188. $calibrator_down_r = $request->calibrator_down_r;
  189. $left_1 = $request->left_1;
  190. $left_2 = $request->left_2;
  191. $left_3 = $request->left_3;
  192. $left_4 = $request->left_4;
  193. $right_1 = $request->right_1;
  194. $right_2 = $request->right_2;
  195. $right_3 = $request->right_3;
  196. $right_4 = $request->right_4;
  197.  
  198.  
  199. $qrname = $machine_name.'_'.$model.'.png';
  200. $insert_machine = new Machine;
  201. $insert_machine->line_number = $line_number;
  202. $insert_machine->machine_name = $machine_name;
  203. $insert_machine->model = $model;
  204. $insert_machine->part_name = $part_name;
  205. $insert_machine->part_code = $part_code;
  206. $insert_machine->mold_no = $mold_no;
  207. $insert_machine->cavity_no = $cavity_no;
  208. $insert_machine->barcode = $qrname;
  209. $insert_machine->save();
  210.  
  211.  
  212. $insert_A = new MachineSettingsA;
  213. $insert_A->machine_id = $insert_machine->id;
  214. $insert_A->mold_temp_controller = $mold_temp;
  215. $insert_A->cycle_time = $cycle_time;
  216. $insert_A->fill_time = $fill_time;
  217. $insert_A->fill_peak = $fill_peak;
  218. $insert_A->scr_most_mm = $scr_most_mm;
  219. $insert_A->scr_most_mpa = $scr_most_mpa;
  220. $insert_A->mtg_ready = $mtg_ready;
  221. $insert_A->plast_tm = $plast_tm;
  222. $insert_A->inj_end_position = $inj_end_position;
  223. $insert_A->sm = $sm;
  224. $insert_A->pp1 = $pp1;
  225. $insert_A->pp2 = $pp2;
  226. $insert_A->pp3 = $pp3;
  227. $insert_A->vp_change = $vp_change;
  228. $insert_A->pv1 = $pv1;
  229. $insert_A->p1 = $p1;
  230. $insert_A->s5 = $s5;
  231. $insert_A->p2 = $p2;
  232. $insert_A->p3 = $p3;
  233. $insert_A->distinction = $distinction;
  234. $insert_A->distinction_f1 = $f1;
  235. $insert_A->distinction_f2 = $f2;
  236. $insert_A->valve_1 = $h1;
  237. $insert_A->valve_2 = $h2;
  238. $insert_A->valve_3 = $h3;
  239. $insert_A->valve_4 = $h4;
  240. $insert_A->valve_5 = $h5;
  241. $insert_A->valve_6 = $h6;
  242. $insert_A->valve_7 = $h7;
  243. $insert_A->valve_8 = $h8;
  244. $insert_A->valve_9 = $h9;
  245. $insert_A->valve_10 = $h10;
  246. $insert_A->valve_11 = $h11;
  247. $insert_A->valve_12 = $h12;
  248. $insert_A->valve_13 = $h13;
  249. $insert_A->valve_14 = $h14;
  250. $insert_A->valve_15 = $h15;
  251. $insert_A->valve_16 = $h16;
  252. $insert_A->diff = $diff;
  253. $insert_A->gate_delay_time = $gate_open_delay;
  254. $insert_A->gate_open_time = $gate_open_time;
  255. $insert_A->cool_tm = $cool_tm;
  256. $insert_A->a1_top = $a1t;
  257. $insert_A->a1_bottom = $a1b;
  258. $insert_A->b1_top = $b1t;
  259. $insert_A->b1_bottom = $b1b;
  260. $insert_A->a2_top = $a2t;
  261. $insert_A->a2_bottom = $a2b;
  262. $insert_A->b2_top = $b2t;
  263. $insert_A->b2_bottom = $b2b;
  264. $insert_A->save();
  265.  
  266. $insert_B = new MachineSettingsB;
  267. $insert_B->machine_id = $insert_machine->id;
  268. $insert_B->chiller_temp = $chiller_temp;
  269. $insert_B->screw_speed = $screw_speed;
  270. $insert_B->melt_temp = $melt_temp;
  271. $insert_B->motor_current = $motor_current;
  272. $insert_B->weight = $weight;
  273. $insert_B->span = $span;
  274. $insert_B->temp_setting_l1 = $temp_setting_l1;
  275. $insert_B->temp_setting_l2 = $temp_setting_l2;
  276. $insert_B->temp_setting_l3 = $temp_setting_l3;
  277. $insert_B->temp_setting_l4 = $temp_setting_l4;
  278. $insert_B->pre_below_time_l = $pre_below_time_l;
  279. $insert_B->pre_below_time_r = $pre_below_time_r;
  280. $insert_B->calibrator_down_l = $calibrator_down_l;
  281. $insert_B->calibrator_down_r = $calibrator_down_r;
  282. $insert_B->left_1 = $left_1;
  283. $insert_B->left_2 = $left_2;
  284. $insert_B->left_3 = $left_3;
  285. $insert_B->left_4 = $left_4;
  286. $insert_B->right_1 = $right_1;
  287. $insert_B->right_2 = $right_2;
  288. $insert_B->right_3 = $right_3;
  289. $insert_B->right_4 = $right_4;
  290. $insert_B->save();
  291.  
  292.  
  293. $inject_A = new StandarSettingsA;
  294. $inject_A->machine_id = $insert_machine->id;
  295. $inject_A->save();
  296.  
  297. $time = date('H:i:s');
  298.  
  299. $inject_B = new StandarSettingsB;
  300. $inject_B->machine_id = $insert_machine->id;
  301. $inject_B->type = $inject_A->id;
  302. $inject_B->save();
  303.  
  304.  
  305. $qrname = $machine_name.'_'.$model.'.png';
  306. $url = 'http://172.16.112.27:8080/newmachine/'.$insert_machine->id.'/profile/inputdaily';
  307. $path = public_path().'/assets/qrcode/'.$qrname;
  308. QRCode::url($url)->setOutFile($path)->setSize(12)
  309. ->setMargin(2)->png();
  310.  
  311. return redirect('/newmachine');
  312. }
  313.  
  314. public function revisiadd(Request $request)
  315. {
  316. $id = $request->id;
  317.  
  318. $insert_revisi = new RevisiHistory;
  319.  
  320. $input=$request->all();
  321. $gambar1 = "";
  322. if($files=$request->file('gambar1')){
  323. foreach($files as $file){
  324.  
  325. $name=$file->getClientOriginalName();
  326. $file->move('../public/images/mcl/',$name);
  327. $gambar1 .=$name.',';
  328.  
  329. }
  330. $insert_revisi->gambar1 = $gambar1;
  331. }
  332.  
  333. $insert_revisi->machine_id = $request->has('id') ? $request->id : '';
  334. $insert_revisi->rev = $request->has('rev') ? $request->rev : '';
  335. $insert_revisi->change_item = $request->has('change_item') ? $request->change_item : '';
  336. $insert_revisi->reason = $request->has('reason') ? $request->reason : '';
  337. $insert_revisi->checked = $request->has('checked') ? $request->checked : '';
  338. $insert_revisi->change = $request->has('change') ? $request->change : '';
  339. $insert_revisi->date = $request->date;
  340. // $insert_revisi->gambar1= $request->has('gambar1') ? $request->gambar1 : '';
  341. $insert_revisi->save();
  342.  
  343. return redirect('/newmachine/'.$request->id.'/profile');
  344. }
  345.  
  346. public function hrsaddnew(Request $request)
  347. {
  348. $id = $request->id;
  349.  
  350. $inject_newhrs = new HotRunnerSystem;
  351.  
  352. $input=$request->all();
  353. $pict1 = "";
  354. if($files=$request->file('pict1')){
  355. foreach($files as $file){
  356.  
  357. $name=$file->getClientOriginalName();
  358. $file->move('../public/images/hrs/',$name);
  359. $pict1 .=$name;
  360.  
  361. }
  362. $inject_newhrs->pict1 = $pict1;
  363.  
  364. }
  365.  
  366. $inject_newhrs->machine_id = $request->has('id') ? $request->id : '';
  367. //$inject_newhrs->pict1 = $request->has('pict1') ? $request->pict1 : '';
  368. $inject_newhrs->reason = $request->has('reason') ? $request->reason : '';
  369. $inject_newhrs->date = $request->date;
  370. $inject_newhrs->stock1 = 1;
  371.  
  372. $inject_newhrs->save();
  373. return redirect('/newmachine/'.$request->id.'/profile');
  374. }
  375.  
  376.  
  377.  
  378. public function inputdailyadd(Request $request)
  379. {
  380.  
  381. // return response()->json($request->all());
  382. $id = $request->id;
  383. $this->validate($request, [
  384. 'date' => ['required',Rule::unique('mcl_daily_b')->where(function($query) use ($id){
  385. $query->where('machine_id',$id);
  386. })
  387. ]
  388. ]);
  389. $inject_A = new injectdailymcl_A;
  390.  
  391.  
  392. $inject_A->machine_id = $request->has('id') ? $request->id : '';
  393. $inject_A->mold_temp_controller = $request->has('mold_temp') ? $request->mold_temp : null; //ketika filed kosong maka tidak eror
  394. $inject_A->cycle_time = $request->has('cycle_time') ? $request->cycle_time : null ;
  395. $inject_A->fill_time = $request->has('fill_time') ? $request->fill_time : null ;
  396. $inject_A->fill_peak = $request->has('fill_peak') ? $request->fill_peak : null ;
  397. $inject_A->scr_most_mm = $request->has('scr_most_mm') ? $request->scr_most_mm : null ;
  398. $inject_A->scr_most_mpa = $request->has('scr_most_mpa') ? $request->scr_most_mpa :null ;
  399. $inject_A->mtg_ready = $request->has('mtg_ready') ? $request->mtg_ready : null ;
  400. $inject_A->plast_tm = $request->has('plast_tm') ? $request->plast_tm : null ;
  401. $inject_A->inj_end_position = $request->has('inj_end_position') ? $request->inj_end_position :null;
  402. $inject_A->sm = $request->has('sm') ? $request->sm : null;
  403. $inject_A->pp1 = $request->has('pp1') ? $request->pp1 :null ;
  404. $inject_A->pp2 = $request->has('pp2') ? $request->pp2 :null ;
  405. $inject_A->pp3 = $request->has('pp3') ? $request->pp3 :null ;
  406. $inject_A->vp_change = $request->has('vp_change') ? $request->vp_change :null ;
  407. $inject_A->pv1 = $request->has('pv1') ? $request->pv1 :null ;
  408. $inject_A->p1 = $request->has('p1') ? $request->p1 :null ;
  409. $inject_A->s5 = $request->has('s5') ? $request->s5 :null ;
  410. $inject_A->p2 = $request->has('p2') ? $request->p2 :null ;
  411. $inject_A->p3 = $request->has('p3') ? $request->p3 :null ;
  412. $inject_A->distinction = $request->has('distinction') ? $request->distinction : 'OFF';
  413. $inject_A->distinction_f1 = $request->has('distinction_f1') ? $request->distinction_f1 : 'OFF';
  414. $inject_A->distinction_f2 = $request->has('distinction_f2') ? $request->distinction_f2 : 'OFF';
  415. $inject_A->valve_1 = $request->has('valve_1') ? $request->valve_1 : '';
  416. $inject_A->valve_2 = $request->has('valve_2') ? $request->valve_2 : '';
  417. $inject_A->valve_3 = $request->has('valve_3') ? $request->valve_3 : '';
  418. $inject_A->valve_4 = $request->has('valve_4') ? $request->valve_4 : '';
  419. $inject_A->valve_5 = $request->has('valve_5') ? $request->valve_5 : '';
  420. $inject_A->valve_6 = $request->has('valve_6') ? $request->valve_6 : '';
  421. $inject_A->valve_7 = $request->has('valve_7') ? $request->valve_7 : '';
  422. $inject_A->valve_8 = $request->has('valve_8') ? $request->valve_8 : '';
  423. $inject_A->valve_9 = $request->has('valve_9') ? $request->valve_9 : '';
  424. $inject_A->valve_10 = $request->has('valve_10') ? $request->valve_10 : '';
  425. $inject_A->valve_11 = $request->has('valve_11') ? $request->valve_11 : '';
  426. $inject_A->valve_12 = $request->has('valve_12') ? $request->valve_12 : '';
  427. $inject_A->valve_13 = $request->has('valve_13') ? $request->valve_13 : '';
  428. $inject_A->valve_14 = $request->has('valve_14') ? $request->valve_14 : '';
  429. $inject_A->valve_15 = $request->has('valve_15') ? $request->valve_15 : '';
  430. $inject_A->valve_16 = $request->has('valve_16') ? $request->valve_16 : '';
  431. $inject_A->diff = $request->has('diff') ? $request->diff : '';
  432. $inject_A->gate_delay_time = $request->has('gate_delay_time') ? $request->gate_delay_time :null ;
  433. $inject_A->gate_open_time = $request->has('gate_open_time') ? $request->gate_open_time : null;
  434. $inject_A->cool_tm = $request->has('cool_tm') ? $request->cool_tm : null;
  435. $inject_A->a1_top = $request->has('a1_top') ? $request->a1_top : '';
  436. $inject_A->a1_bottom = $request->has('a1_bottom') ? $request->a1_bottom : '';
  437. $inject_A->b1_top = $request->has('b1_top') ? $request->b1_top : '';
  438. $inject_A->b1_bottom = $request->has('b1_bottom') ? $request->b1_bottom : '';
  439. $inject_A->a2_top = $request->has('a2_top') ? $request->a2_top : '';
  440. $inject_A->a2_bottom = $request->has('a2_bottom') ? $request->a2_bottom : '';
  441. $inject_A->b2_top = $request->has('b2_top') ? $request->b2_top : '';
  442. $inject_A->b2_bottom = $request->has('b2_bottom') ? $request->b2_bottom : '';
  443. $inject_A->save();
  444.  
  445. $time = date('H:i:s');
  446. $time_now = date('h:i:s');
  447. $downtime = $request->downtime;
  448.  
  449. $downtime_now = strtotime($time_now) - strtotime($downtime);
  450. $downtime_now = gmdate("H:i:s",$downtime_now);
  451. $inject_B = new injectdailymcl_B;
  452. $inject_B->type = $inject_A->id;
  453. $inject_B->machine_id = $request->has('id') ? $request->id : '';
  454. $inject_B->chiller_temp = $request->has('chiller_temp') ? $request->chiller_temp : null;
  455. $inject_B->screw_speed = $request->has('screw_speed') ? $request->screw_speed : null;
  456. $inject_B->melt_temp = $request->has('melt_temp') ? $request->melt_temp : null;
  457. $inject_B->motor_current = $request->has('motor_current') ? $request->motor_current : null;
  458. $inject_B->weight = $request->has('weight') ? $request->weight : null;
  459. $inject_B->span = $request->has('span') ? $request->span : null;
  460. $inject_B->temp_setting_l1 = $request->has('temp_setting_l1') ? $request->temp_setting_l1 : null;
  461. $inject_B->temp_setting_l2 = $request->has('temp_setting_l2') ? $request->temp_setting_l2 : null;
  462. $inject_B->temp_setting_l3 = $request->has('temp_setting_l3') ? $request->temp_setting_l3 : null;
  463. $inject_B->temp_setting_l4 = $request->has('temp_setting_l4') ? $request->temp_setting_l4 : null;
  464. $inject_B->pre_below_time_l = $request->has('pre_below_time_l') ? $request->pre_below_time_l : null;
  465. $inject_B->pre_below_time_r = $request->has('pre_below_time_r') ? $request->pre_below_time_r :null;
  466. $inject_B->calibrator_down_l = $request->has('calibrator_down_l') ? $request->calibrator_down_l : null;
  467. $inject_B->calibrator_down_r = $request->has('calibrator_down_r') ? $request->calibrator_down_r : null;
  468. $inject_B->left_1 = $request->has('left_1') ? $request->left_1 : null;
  469. $inject_B->left_2 = $request->has('left_2') ? $request->left_2 : null;
  470. $inject_B->left_3 = $request->has('left_3') ? $request->left_3 : null;
  471. $inject_B->left_4 = $request->has('left_4') ? $request->left_4 : null;
  472. $inject_B->right_1 = $request->has('right_1') ? $request->right_1 : null;
  473. $inject_B->right_2 = $request->has('right_2') ? $request->right_2 : null;
  474. $inject_B->right_3 = $request->has('right_3') ? $request->right_3 : null;
  475. $inject_B->right_4 = $request->has('right_4') ? $request->right_4 : null;
  476. $inject_B->remark = $request->has('remark') ? $request->remark : null;
  477. $inject_B->date = $request->date;
  478. $inject_B->actual_time = $time;
  479. $inject_B->downtime = $downtime_now;
  480. $inject_B->checked = Auth::user()->name;
  481. $inject_B->save();
  482.  
  483. // $injectA =
  484.  
  485. // return response()->json($request->all());
  486. return redirect('/newmachine/'.$request->id.'/profile');
  487. }
  488.  
  489. public function getLine(Request $request)
  490. {
  491. if($request->line != "")
  492. {
  493. $line = Machine::where('line_number','like',$request->line.'%')->get();
  494. }else{
  495. $line = Machine::orderBy('line_number','asc')->get();
  496. }
  497. $all_data= array();
  498. if(!empty($line)){
  499. foreach($line as $all_line){
  500. $all_data[] = '<tr>
  501. <td><a href="/newmachine/'.$all_line->id.'/profile">'.$all_line->line_number.'</td>
  502. <td><a href="/newmachine/'.$all_line->id.'/profile">'.$all_line->machine_name.'</td>
  503. <td>'.$all_line->model.'></td>
  504. <td>'.$all_line->part_name.'></td>
  505. <td>'.$all_line->part_code.'></td>
  506. <td>'.$all_line->mold_no.'></td>
  507. <td>'.$all_line->cavity_no.'></td>
  508. <td><a class="btn btn-warning btn-sm edit_machine" data-id="'.$all_line->id.'"> Edit </a>
  509. <a class="btn btn-danger btn-sm" onclick="return confirm ("Are you sure to delete?")"> Delete </a>
  510. <a class="btn btn-primary btn-sm" data-toggle="modal" data-target="#printmcl"> Print </a>
  511. </td>
  512. </tr>';
  513. }
  514. }
  515. return response()->json($all_data);
  516. }
  517.  
  518. public function editmachine(Request $request)
  519. {
  520. // $machine = Machine::where('id',$request->id)->first();
  521. // $machine_settingA = MachineSettingsA::where('machine_id',$machine->id)->first();
  522. // $machine_settingB = MachineSettingsB::where('machine_id',$machine->id)->first();
  523. // return response()->json(['machine' => $machine,'machine_a' => $machine_settingA,'machine_b' => $machine_settingB]);
  524.  
  525. $machine = Machine::where('id',$request->id)->first();
  526. $machine->line_number = $request->line;
  527. $machine->machine_name = $request->machine_name;
  528. $machine->model = $request->model;
  529. $machine->part_name = $request->part_name;
  530. $machine->part_code = $request->part_code;
  531. $machine->mold_no = $request->mold_no;
  532. $machine->cavity_no = $request->cavity_no;
  533. $machine->save();
  534.  
  535. return redirect('/newmachine');
  536. }
  537.  
  538. public function printmcl(Request $request)
  539. {
  540. $machine_id = $request->mclid;
  541. $machine = DB::table('machine')->where('id',$machine_id)->first();
  542. $month = $request->month;
  543. $month_num =12;
  544.  
  545. // Use mktime() and date() function to
  546. // convert number to month name
  547. $month_name = date("F", mktime(0, 0, 0, $month, 10));
  548.  
  549.  
  550. $year = $request->year;
  551. return Excel::download(new MclExport($machine_id,$month,$year), $machine->line_number.' '.$machine->mold_no.' '.$month_name.' '.$year.'.xlsx');
  552. }
  553.  
  554. public function saveSetting(Request $request)
  555. {
  556. $inject_A = StandarSettingsA::where('machine_id',$request->id)->first();
  557.  
  558. $inject_A->mold_temp_controller = $request->has('mold_temp') ? json_encode($request->mold_temp) : null; //ketika filed kosong maka tidak eror
  559. $inject_A->cycle_time = $request->has('cycle_time') ? json_encode($request->cycle_time) : '';
  560. $inject_A->fill_time = $request->has('fill_time') ? json_encode($request->fill_time) : '';
  561. $inject_A->fill_peak = $request->has('fill_peak') ? json_encode($request->fill_peak) : '';
  562. $inject_A->scr_most_mm = $request->has('scr_most_mm') ? json_encode($request->scr_most_mm) : '';
  563. $inject_A->scr_most_mpa = $request->has('scr_most_mpa') ? json_encode($request->scr_most_mpa) : '';
  564. $inject_A->mtg_ready = $request->has('mtg_ready') ? json_encode($request->mtg_ready) : '';
  565. $inject_A->plast_tm = $request->has('plast_tm') ? json_encode($request->plast_tm) : '';
  566. $inject_A->inj_end_position = $request->has('inj_end_position') ? json_encode($request->inj_end_position) : '';
  567. $inject_A->sm = $request->has('sm') ? json_encode($request->sm) : '';
  568. $inject_A->pp1 = $request->has('pp1') ? json_encode($request->pp1) : '';
  569. $inject_A->pp2 = $request->has('pp2') ? json_encode($request->pp2) : '';
  570. $inject_A->pp3 = $request->has('pp3') ? json_encode($request->pp3) : '';
  571. $inject_A->vp_change = $request->has('vp_change') ? json_encode($request->vp_change) : '';
  572. $inject_A->pv1 = $request->has('pv1') ? json_encode($request->pv1) : '';
  573. $inject_A->p1 = $request->has('p1') ? json_encode($request->p1) : '';
  574. $inject_A->s5 = $request->has('s5') ? json_encode($request->s5) : '';
  575. $inject_A->p2 = $request->has('p2') ? json_encode($request->p2) : '';
  576. $inject_A->p3 = $request->has('p3') ? json_encode($request->p3) : '';
  577. $inject_A->distinction = $request->has('distinction') ? json_encode($request->distinction) : '';
  578. $inject_A->distinction_f1 = $request->has('distinction_f1') ? json_encode($request->f1) : '';
  579. $inject_A->distinction_f2 = $request->has('distinction_f2') ? json_encode($request->f2) : '';
  580. $inject_A->valve_1 = $request->has('valve_1') ? json_encode($request->valve_1) : '';
  581. $inject_A->valve_2 = $request->has('valve_2') ? json_encode($request->valve_2) : '';
  582. $inject_A->valve_3 = $request->has('valve_3') ? json_encode($request->valve_3) : '';
  583. $inject_A->valve_4 = $request->has('valve_4') ? json_encode($request->valve_4) : '';
  584. $inject_A->valve_5 = $request->has('valve_5') ? json_encode($request->valve_5) : '';
  585. $inject_A->valve_6 = $request->has('valve_6') ? json_encode($request->valve_6) : '';
  586. $inject_A->valve_7 = $request->has('valve_7') ? json_encode($request->valve_7) : '';
  587. $inject_A->valve_8 = $request->has('valve_8') ? json_encode($request->valve_8) : '';
  588. $inject_A->valve_9 = $request->has('valve_9') ? json_encode($request->valve_9) : '';
  589. $inject_A->valve_10 = $request->has('valve_10') ? json_encode($request->valve_10) : '';
  590. $inject_A->valve_11 = $request->has('valve_11') ? json_encode($request->valve_11) : '';
  591. $inject_A->valve_12 = $request->has('valve_12') ? json_encode($request->valve_12) : '';
  592. $inject_A->valve_13 = $request->has('valve_13') ? json_encode($request->valve_13) : '';
  593. $inject_A->valve_14 = $request->has('valve_14') ? json_encode($request->valve_14) : '';
  594. $inject_A->valve_15 = $request->has('valve_15') ? json_encode($request->valve_15) : '';
  595. $inject_A->valve_16 = $request->has('valve_16') ? json_encode($request->valve_16) : '';
  596. $inject_A->diff = $request->has('diff') ? json_encode($request->diff) : '';
  597. $inject_A->gate_delay_time = $request->has('gate_delay_time') ? json_encode($request->gate_delay_time) : '';
  598. $inject_A->gate_open_time = $request->has('gate_open_time') ? json_encode($request->gate_open_time) : '';
  599. $inject_A->cool_tm = $request->has('cool_tm') ? json_encode($request->cool_tm) : '';
  600. $inject_A->a1_top = $request->has('a1_top') ? json_encode($request->a1_top) : '';
  601. $inject_A->a1_bottom = $request->has('a1_bottom') ? json_encode($request->a1_bottom) : '';
  602. $inject_A->b1_top = $request->has('b1_top') ? json_encode($request->b1_top) : '';
  603. $inject_A->b1_bottom = $request->has('b1_bottom') ? json_encode($request->b1_bottom) : '';
  604. $inject_A->a2_top = $request->has('a2_top') ? json_encode($request->a2_top) : '';
  605. $inject_A->a2_bottom = $request->has('a2_bottom') ? json_encode($request->a2_bottom) : '';
  606. $inject_A->b2_top = $request->has('b2_top') ? json_encode($request->b2_top) : '';
  607. $inject_A->b2_bottom = $request->has('b2_bottom') ? json_encode($request->b2_bottom) : '';
  608. $inject_A->save();
  609.  
  610. $time = date('h:i:s');
  611.  
  612. $inject_B = StandarSettingsB::where('machine_id',$request->id)->first();
  613. $inject_B->machine_id = $request->has('id') ? $request->id : '';
  614. $inject_B->chiller_temp = $request->has('chiller_temp') ? json_encode($request->chiller_temp) : '';
  615. $inject_B->screw_speed = $request->has('screw_speed') ? json_encode($request->screw_speed) : '';
  616. $inject_B->melt_temp = $request->has('melt_temp') ? json_encode($request->melt_temp) : '';
  617. $inject_B->motor_current = $request->has('motor_current') ? json_encode($request->motor_current) : '';
  618. $inject_B->weight = $request->has('weight') ? json_encode($request->weight) : '';
  619. $inject_B->span = $request->has('span') ? json_encode($request->span) : '';
  620. $inject_B->temp_setting_l1 = $request->has('temp_setting_l1') ? json_encode($request->temp_setting_l1) : '';
  621. $inject_B->temp_setting_l2 = $request->has('temp_setting_l2') ? json_encode($request->temp_setting_l2) : '';
  622. $inject_B->temp_setting_l3 = $request->has('temp_setting_l3') ? json_encode($request->temp_setting_l3) : '';
  623. $inject_B->temp_setting_l4 = $request->has('temp_setting_l4') ? json_encode($request->temp_setting_l4) : '';
  624. $inject_B->pre_below_time_l = $request->has('pre_below_time_l') ? json_encode($request->pre_below_time_l) : '';
  625. $inject_B->pre_below_time_r = $request->has('pre_below_time_r') ? json_encode($request->pre_below_time_r) : '';
  626. $inject_B->calibrator_down_l = $request->has('calibrator_down_l') ? json_encode($request->calibrator_down_l) : '';
  627. $inject_B->calibrator_down_r = $request->has('calibrator_down_r') ? json_encode($request->calibrator_down_r) : '';
  628. $inject_B->left_1 = $request->has('left_1') ? json_encode($request->left_1) : '';
  629. $inject_B->left_2 = $request->has('left_2') ? json_encode($request->left_2) : '';
  630. $inject_B->left_3 = $request->has('left_3') ? json_encode($request->left_3) : '';
  631. $inject_B->left_4 = $request->has('left_4') ? json_encode($request->left_4) : '';
  632. $inject_B->right_1 = $request->has('right_1') ? json_encode($request->right_1) : '';
  633. $inject_B->right_2 = $request->has('right_2') ? json_encode($request->right_2) : '';
  634. $inject_B->right_3 = $request->has('right_3') ? json_encode($request->right_3) : '';
  635. $inject_B->right_4 = $request->has('right_4') ? json_encode($request->right_4) : '';
  636. $inject_B->save();
  637.  
  638. return redirect('/newmachine/'.$request->id.'/profile');
  639. }
  640.  
  641. public function getChart(Request $request)
  642. {
  643. // $mcl_daily_a = DB::table('mcl_daily_a')
  644. $month = $request->month;
  645. $year = $request->year;
  646.  
  647.  
  648. $setting = DB::table('standar_setting')->join('standar_settingb', 'standar_setting.id','standar_settingb.type')
  649. ->where('standar_setting.machine_id',$request->machine)->select("$request->field as field")->first();
  650.  
  651. // $data = explode(',', $setting);
  652.  
  653.  
  654. $mcl_daily_a = DB::table('mcl_daily_a')->join('mcl_daily_b', 'mcl_daily_a.id','mcl_daily_b.type')
  655. ->where('mcl_daily_a.machine_id',$request->machine)->whereRaw("MONTH(mcl_daily_b.date) = $month")->whereRaw("YEAR(mcl_daily_b.date) = $year")->orderBy('mcl_daily_b.date','asc')->selectRaw("mcl_daily_b.date as x,$request->field as y,mcl_daily_b.actual_time")->get();
  656.  
  657. return response()->json(['all_data' => $mcl_daily_a,'setting' => $setting]);
  658. }
  659.  
  660. public function deleteMachine(Request $request)
  661. {
  662. if(Auth::user()->level == 1){
  663. $machine = Machine::where('id',$request->id)->first();
  664. if($machine->delete()){
  665. DB::table('mcl_daily_a')->where('machine_id',$request->id)->delete();
  666. DB::table('mcl_daily_b')->where('machine_id',$request->id)->delete();
  667. DB::table('standar_setting')->where('machine_id',$request->id)->delete();
  668. DB::table('standar_settingb')->where('machine_id',$request->id)->delete();
  669. DB::table('machine_setting')->where('machine_id',$request->id)->delete();
  670. DB::table('machine_settingb')->where('machine_id',$request->id)->delete();
  671. DB::table('defectfinding')->where('defect_id',$request->id)->delete();
  672. return response()->json(['status' => 1]);
  673. }
  674. }
  675. return response()->json(['status' => 0]);
  676. }
  677.  
  678. public function deleteDailyMachine(Request $request)
  679. {
  680. $id = $request->id;
  681.  
  682. DB::table('mcl_daily_a')->where('id', $id)->delete();
  683. DB::table('mcl_daily_b')->where('type',$id)->delete();
  684.  
  685. return response()->json(['status' => 1]);
  686.  
  687. }
  688.  
  689. public function deleteRevisiHistory(Request $request)
  690. {
  691. $id = $request->id;
  692.  
  693. DB::table('revisi_history')->where('id', $id)->delete();
  694.  
  695. return response()->json(['status' => 1]);
  696.  
  697. }
  698.  
  699. public function editinput($id)
  700. {
  701.  
  702. $machine = DB::table('mcl_daily_a')->where('id',$id)->first();
  703. $all_machine = DB::table('mcl_daily_a')->join('mcl_daily_b', 'mcl_daily_a.id','mcl_daily_b.type')->where('mcl_daily_a.id',$id)->where('mcl_daily_a.machine_id',$machine->machine_id)->select('mcl_daily_a.*','mcl_daily_b.*','mcl_daily_a.id as id_a','mcl_daily_b.id as id_b')->first();
  704. $machine_settingA = \App\MachineSettingsA::where('machine_id',$machine->machine_id)->first();
  705. $machine_settingB = \App\MachineSettingsB::where('machine_id', $machine->machine_id)->first();
  706. // dd($all_machine);
  707.  
  708. return view('newmachine.edit',['machine' => $all_machine,'machine_settingA' => $machine_settingA,'machine_settingB' => $machine_settingB]);
  709. }
  710.  
  711. public function editrevisi($id)
  712. {
  713.  
  714. $revisi = DB::table('revisi_history')->where('id',$id)->first();
  715. $all_revisi = DB::table('revisi_history')->where('revisi_history.id',$id)->where('revisi_history.machine_id',$revisi->machine_id)->select('revisi_history.*','revisi_history.id as id_a')->first();
  716. return view('newmachine.editrevisi',['revisi' => $all_revisi]);
  717. }
  718.  
  719. public function saveEdit(Request $request, $id)
  720. {
  721. $machine = DB::table('mcl_daily_a')->where('id',$id)->first();
  722.  
  723. $inject_A = injectdailymcl_A::where('id',$id)->first();
  724.  
  725.  
  726. // $inject_A->machine_id = $request->has('id') ? $request->id : '';
  727. $inject_A->mold_temp_controller = $request->has('mold_temp') ? $request->mold_temp : null; //ketika filed kosong maka tidak eror
  728. $inject_A->cycle_time = $request->has('cycle_time') ? $request->cycle_time : null;
  729. $inject_A->fill_time = $request->has('fill_time') ? $request->fill_time : null;
  730. $inject_A->fill_peak = $request->has('fill_peak') ? $request->fill_peak : null;
  731. $inject_A->scr_most_mm = $request->has('scr_most_mm') ? $request->scr_most_mm : null;
  732. $inject_A->scr_most_mpa = $request->has('scr_most_mpa') ? $request->scr_most_mpa : null;
  733. $inject_A->mtg_ready = $request->has('mtg_ready') ? $request->mtg_ready : null;
  734. $inject_A->plast_tm = $request->has('plast_tm') ? $request->plast_tm : null;
  735. $inject_A->inj_end_position = $request->has('inj_end_position') ? $request->inj_end_position : null;
  736. $inject_A->sm = $request->has('sm') ? $request->sm : null;
  737. $inject_A->pp1 = $request->has('pp1') ? $request->pp1 : null;
  738. $inject_A->pp2 = $request->has('pp2') ? $request->pp2 : null;
  739. $inject_A->pp3 = $request->has('pp3') ? $request->pp3 : null;
  740. $inject_A->vp_change = $request->has('vp_change') ? $request->vp_change : null;
  741. $inject_A->pv1 = $request->has('pv1') ? $request->pv1 : null;
  742. $inject_A->p1 = $request->has('p1') ? $request->p1 : null;
  743. $inject_A->s5 = $request->has('s5') ? $request->s5 : null;
  744. $inject_A->p2 = $request->has('p2') ? $request->p2 : null;
  745. $inject_A->p3 = $request->has('p3') ? $request->p3 : null;
  746. $inject_A->distinction = $request->has('distinction') ? $request->distinction : 'OFF';
  747. $inject_A->distinction_f1 = $request->has('distinction_f1') ? $request->distinction_f1 : 'OFF';
  748. $inject_A->distinction_f2 = $request->has('distinction_f2') ? $request->distinction_f2 : 'OFF';
  749. $inject_A->valve_1 = $request->has('valve_1') ? $request->valve_1 : '';
  750. $inject_A->valve_2 = $request->has('valve_2') ? $request->valve_2 : '';
  751. $inject_A->valve_3 = $request->has('valve_3') ? $request->valve_3 : '';
  752. $inject_A->valve_4 = $request->has('valve_4') ? $request->valve_4 : '';
  753. $inject_A->valve_5 = $request->has('valve_5') ? $request->valve_5 : '';
  754. $inject_A->valve_6 = $request->has('valve_6') ? $request->valve_6 : '';
  755. $inject_A->valve_7 = $request->has('valve_7') ? $request->valve_7 : '';
  756. $inject_A->valve_8 = $request->has('valve_8') ? $request->valve_8 : '';
  757. $inject_A->valve_9 = $request->has('valve_9') ? $request->valve_9 : '';
  758. $inject_A->valve_10 = $request->has('valve_10') ? $request->valve_10 : '';
  759. $inject_A->valve_11 = $request->has('valve_11') ? $request->valve_11 : '';
  760. $inject_A->valve_12 = $request->has('valve_12') ? $request->valve_12 : '';
  761. $inject_A->valve_13 = $request->has('valve_13') ? $request->valve_13 : '';
  762. $inject_A->valve_14 = $request->has('valve_14') ? $request->valve_14 : '';
  763. $inject_A->valve_15 = $request->has('valve_15') ? $request->valve_15 : '';
  764. $inject_A->valve_16 = $request->has('valve_16') ? $request->valve_16 : '';
  765. $inject_A->diff = $request->has('diff') ? $request->diff : '';
  766. $inject_A->gate_delay_time = $request->has('gate_delay_time') ? $request->gate_delay_time : null;
  767. $inject_A->gate_open_time = $request->has('gate_open_time') ? $request->gate_open_time : null;
  768. $inject_A->cool_tm = $request->has('cool_tm') ? $request->cool_tm : null;
  769. $inject_A->a1_top = $request->has('a1_top') ? $request->a1_top : '';
  770. $inject_A->a1_bottom = $request->has('a1_bottom') ? $request->a1_bottom : '';
  771. $inject_A->b1_top = $request->has('b1_top') ? $request->b1_top : '';
  772. $inject_A->b1_bottom = $request->has('b1_bottom') ? $request->b1_bottom : '';
  773. $inject_A->a2_top = $request->has('a2_top') ? $request->a2_top : '';
  774. $inject_A->a2_bottom = $request->has('a2_bottom') ? $request->a2_bottom : '';
  775. $inject_A->b2_top = $request->has('b2_top') ? $request->b2_top : '';
  776. $inject_A->b2_bottom = $request->has('b2_bottom') ? $request->b2_bottom : '';
  777. $inject_A->save();
  778.  
  779. // $time = date('h:i:s');
  780.  
  781. $inject_B = injectdailymcl_B::where('type',$id)->first();
  782. // $inject_B->type = $inject_A->id;
  783. // $inject_B->machine_id = $request->has('id') ? $request->id : '';
  784. $inject_B->chiller_temp = $request->has('chiller_temp') ? $request->chiller_temp : null;
  785. $inject_B->screw_speed = $request->has('screw_speed') ? $request->screw_speed : null;
  786. $inject_B->melt_temp = $request->has('melt_temp') ? $request->melt_temp : null;
  787. $inject_B->motor_current = $request->has('motor_current') ? $request->motor_current : null;
  788. $inject_B->weight = $request->has('weight') ? $request->weight : null;
  789. $inject_B->span = $request->has('span') ? $request->span : null;
  790. $inject_B->temp_setting_l1 = $request->has('temp_setting_l1') ? $request->temp_setting_l1 : null;
  791. $inject_B->temp_setting_l2 = $request->has('temp_setting_l2') ? $request->temp_setting_l2 : null;
  792. $inject_B->temp_setting_l3 = $request->has('temp_setting_l3') ? $request->temp_setting_l3 : null;
  793. $inject_B->temp_setting_l4 = $request->has('temp_setting_l4') ? $request->temp_setting_l4 : null;
  794. $inject_B->pre_below_time_l = $request->has('pre_below_time_l') ? $request->pre_below_time_l : null;
  795. $inject_B->pre_below_time_r = $request->has('pre_below_time_r') ? $request->pre_below_time_r : null;
  796. $inject_B->calibrator_down_l = $request->has('calibrator_down_l') ? $request->calibrator_down_l : null;
  797. $inject_B->calibrator_down_r = $request->has('calibrator_down_r') ? $request->calibrator_down_r : null;
  798. $inject_B->left_1 = $request->has('left_1') ? $request->left_1 : null;
  799. $inject_B->left_2 = $request->has('left_2') ? $request->left_2 : null;
  800. $inject_B->left_3 = $request->has('left_3') ? $request->left_3 : null;
  801. $inject_B->left_4 = $request->has('left_4') ? $request->left_4 : null;
  802. $inject_B->right_1 = $request->has('right_1') ? $request->right_1 : null;
  803. $inject_B->right_2 = $request->has('right_2') ? $request->right_2 : null;
  804. $inject_B->right_3 = $request->has('right_3') ? $request->right_3 : null;
  805. $inject_B->right_4 = $request->has('right_4') ? $request->right_4 : null;
  806. $inject_B->remark = $request->has('remark') ? $request->remark : null;
  807. // $inject_B->actual_time = $time;
  808. // $inject_B->checked = Auth::user()->name;
  809. $inject_B->save();
  810.  
  811. return redirect("/newmachine/$machine->machine_id/profile");
  812. }
  813.  
  814.  
  815. public function saveEditRevisi(Request $request, $id)
  816. {
  817.  
  818. $revisi = DB::table('revisi_history')->where('id',$id)->first();
  819.  
  820. $insert_revisi = RevisiHistory::where('id',$id)->first();
  821.  
  822. $input=$request->all();
  823. $gambar1 = "";
  824. if($files=$request->file('gambar1')){
  825. foreach($files as $file){
  826.  
  827. $name=$file->getClientOriginalName();
  828. $file->move('../public/images/mcl/',$name);
  829. $gambar1 .=$name.',';
  830.  
  831. }
  832. $insert_revisi->gambar1 = $gambar1;
  833. }
  834.  
  835.  
  836. $insert_revisi->rev = $request->has('rev') ? $request->rev : '';
  837. $insert_revisi->change_item = $request->has('change_item') ? $request->change_item : '';
  838. $insert_revisi->reason = $request->has('reason') ? $request->reason : '';
  839. $insert_revisi->checked = $request->has('checked') ? $request->checked : '';
  840. $insert_revisi->change = $request->has('change') ? $request->change : '';
  841. $insert_revisi->date = $request->date;
  842. // $insert_revisi->gambar1= $request->has('gambar1') ? $request->gambar1 : '';
  843. $insert_revisi->save();
  844. return redirect("/newmachine/$revisi->machine_id/profile");
  845. }
  846.  
  847.  
  848.  
  849. public function saveApprove(Request $request)
  850. {
  851. foreach ($request->data as $input) {
  852. $inject_B = injectdailymcl_B::where('type',$input)->first();
  853. $inject_B->status = 1;
  854. $inject_B->superior=Auth::user()->name;
  855. $inject_B->save();
  856. }
  857.  
  858. return response()->json(['status' => 1]);
  859. }
  860.  
  861. public function saveNG(Request $request)
  862. {
  863. foreach ($request->data as $input) {
  864. $inject_B = injectdailymcl_B::where('type',$input)->first();
  865. $inject_B->status = 2;
  866. $inject_B->note = $request->comment;
  867. $inject_B->superior=Auth::user()->name;
  868. $inject_B->save();
  869. }
  870.  
  871. return response()->json(['status' => 2]);
  872. }
  873.  
  874.  
  875. public function savecommentspv(Request $request)
  876. {
  877. foreach ($request->data as $input) {
  878. $inject_B = injectdailymcl_B::where('type',$input)->first();
  879. $inject_B->note = $request->comment;
  880. $inject_B->superior=Auth::user()->name;
  881. $inject_B->save();
  882. }
  883.  
  884. return response()->json();
  885.  
  886.  
  887. }
  888.  
  889. public function saveApprovemanager(Request $request)
  890. {
  891. foreach ($request->data as $input) {
  892. $inject_B = injectdailymcl_B::where('type',$input)->first();
  893. $inject_B->statusmanager = 1;
  894. $inject_B->manager=Auth::user()->name;
  895. $inject_B->save();
  896. }
  897.  
  898. return response()->json(['status' => 1]);
  899. }
  900.  
  901. public function saveNGmanager(Request $request)
  902. {
  903. foreach ($request->data as $input) {
  904. $inject_B = injectdailymcl_B::where('type',$input)->first();
  905. $inject_B->statusmanager = 2;
  906. $inject_B->notemanager = $request->commentmanager;
  907. $inject_B->manager=Auth::user()->name;
  908. $inject_B->save();
  909. }
  910.  
  911. return response()->json(['status' => 2]);
  912. }
  913.  
  914.  
  915.  
  916.  
  917. public function downloadBarcode($id)
  918. {
  919.  
  920. $machine = Machine::where('id',$id)->first();
  921. $url = 'http://172.16.112.27:8080/newmachine/'.$id.'/profile/inputdaily';
  922. // $path = public_path().'/assets/qrcode/'.$qrname;
  923. header('Content-type: image/png');
  924. header('Content-Disposition: attachment; filename="'.$machine->line_number.'.png"');
  925. $img = QRCode::url($url)->setSize(12)
  926. ->setMargin(2)->png();
  927. // return response($img)->header('Content-type','image/png')->header('filename','avatar.jpg');
  928.  
  929. }
  930.  
  931. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!