API tools faq
paste
Advertisement
vitareinforce

generator harian v2

vitareinforce
Dec 23rd, 2021
28
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.95 KB | None | 0 0
raw download clone embed print report
  1. if($karyawan[$i]->jadwal_id != null && $karyawan[$i]->jadwal_group_id == null) {
  2. // $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin')->where(function ($query) use ($day) {
  3. // switch($day) {
  4. // case 'Monday':
  5. // $query->where('checkbox_harikerja_senin', 1);
  6. // break;
  7. // case 'Tuesday':
  8. // $query->where('checkbox_harikerja_selasa', 1);
  9. // break;
  10. // case 'Wednesday':
  11. // $query->where('checkbox_harikerja_rabu', 1);
  12. // break;
  13. // case 'Thursday':
  14. // $query->where('checkbox_harikerja_kamis', 1);
  15. // break;
  16. // case 'Friday':
  17. // $query->where('checkbox_harikerja_jumat', 1);
  18. // break;
  19. // case 'Saturday':
  20. // $query->where('checkbox_harikerja_sabtu', 1);
  21. // break;
  22. // case 'Sunday':
  23. // $query->where('checkbox_harikerja_minggu', 1);
  24. // break;
  25. // default:
  26. // break;
  27. // }
  28. // })->first();
  29. // if($jadwal_rutin == null) {
  30. // $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin')->where(function ($query) use ($day) {
  31. // switch($day) {
  32. // case 'Monday':
  33. // $query->where('checkbox_harikerja_senin_baru', 1);
  34. // break;
  35. // case 'Tuesday':
  36. // $query->where('checkbox_harikerja_selasa_baru', 1);
  37. // break;
  38. // case 'Wednesday':
  39. // $query->where('checkbox_harikerja_rabu_baru', 1);
  40. // break;
  41. // case 'Thursday':
  42. // $query->where('checkbox_harikerja_kamis_baru', 1);
  43. // break;
  44. // case 'Friday':
  45. // $query->where('checkbox_harikerja_jumat_baru', 1);
  46. // break;
  47. // case 'Saturday':
  48. // $query->where('checkbox_harikerja_sabtu_baru', 1);
  49. // break;
  50. // case 'Sunday':
  51. // $query->where('checkbox_harikerja_minggu', 1);
  52. // break;
  53. // default:
  54. // break;
  55. // }
  56. // })->first();
  57. // }
  58.  
  59. if(Carbon::parse($date)->lte(Carbon::parse($karyawan[$i]->tanggal_jadwal_rutin_diedit))) {
  60. $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin')->where(function ($query) use ($day) {
  61. switch($day) {
  62. case 'Monday':
  63. $query->where('checkbox_harikerja_senin', 1);
  64. break;
  65. case 'Tuesday':
  66. $query->where('checkbox_harikerja_selasa', 1);
  67. break;
  68. case 'Wednesday':
  69. $query->where('checkbox_harikerja_rabu', 1);
  70. break;
  71. case 'Thursday':
  72. $query->where('checkbox_harikerja_kamis', 1);
  73. break;
  74. case 'Friday':
  75. $query->where('checkbox_harikerja_jumat', 1);
  76. break;
  77. case 'Saturday':
  78. $query->where('checkbox_harikerja_sabtu', 1);
  79. break;
  80. case 'Sunday':
  81. $query->where('checkbox_harikerja_minggu', 1);
  82. break;
  83. default:
  84. break;
  85. }
  86. })->first();
  87. } else if(Carbon::parse($date)->gt(Carbon::parse($karyawan[$i]->tanggal_jadwal_rutin_diedit))) {
  88. $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin')->where(function ($query) use ($day) {
  89. switch($day) {
  90. case 'Monday':
  91. $query->where('checkbox_harikerja_senin_baru', 1);
  92. break;
  93. case 'Tuesday':
  94. $query->where('checkbox_harikerja_selasa_baru', 1);
  95. break;
  96. case 'Wednesday':
  97. $query->where('checkbox_harikerja_rabu_baru', 1);
  98. break;
  99. case 'Thursday':
  100. $query->where('checkbox_harikerja_kamis_baru', 1);
  101. break;
  102. case 'Friday':
  103. $query->where('checkbox_harikerja_jumat_baru', 1);
  104. break;
  105. case 'Saturday':
  106. $query->where('checkbox_harikerja_sabtu_baru', 1);
  107. break;
  108. case 'Sunday':
  109. $query->where('checkbox_harikerja_minggu', 1);
  110. break;
  111. default:
  112. break;
  113. }
  114. })->first();
  115. }
  116. } else if($karyawan[$i]->jadwal_id == null && $karyawan[$i]->jadwal_group_id != null) {
  117. // $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin-group')->where(function ($query) use ($day) {
  118. // switch($day) {
  119. // case 'Monday':
  120. // $query->where('checkbox_harikerja_senin', 1);
  121. // break;
  122. // case 'Tuesday':
  123. // $query->where('checkbox_harikerja_selasa', 1);
  124. // break;
  125. // case 'Wednesday':
  126. // $query->where('checkbox_harikerja_rabu', 1);
  127. // break;
  128. // case 'Thursday':
  129. // $query->where('checkbox_harikerja_kamis', 1);
  130. // break;
  131. // case 'Friday':
  132. // $query->where('checkbox_harikerja_jumat', 1);
  133. // break;
  134. // case 'Saturday':
  135. // $query->where('checkbox_harikerja_sabtu', 1);
  136. // break;
  137. // case 'Sunday':
  138. // $query->where('checkbox_harikerja_minggu', 1);
  139. // break;
  140. // default:
  141. // break;
  142. // }
  143. // })->first();
  144. // if($jadwal_rutin == null) {
  145. // $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin-group')->where(function ($query) use ($day) {
  146. // switch($day) {
  147. // case 'Monday':
  148. // $query->where('checkbox_harikerja_senin_baru', 1);
  149. // break;
  150. // case 'Tuesday':
  151. // $query->where('checkbox_harikerja_selasa_baru', 1);
  152. // break;
  153. // case 'Wednesday':
  154. // $query->where('checkbox_harikerja_rabu_baru', 1);
  155. // break;
  156. // case 'Thursday':
  157. // $query->where('checkbox_harikerja_kamis_baru', 1);
  158. // break;
  159. // case 'Friday':
  160. // $query->where('checkbox_harikerja_jumat_baru', 1);
  161. // break;
  162. // case 'Saturday':
  163. // $query->where('checkbox_harikerja_sabtu_baru', 1);
  164. // break;
  165. // case 'Sunday':
  166. // $query->where('checkbox_harikerja_minggu_baru', 1);
  167. // break;
  168. // default:
  169. // break;
  170. // }
  171. // })->first();
  172. // }
  173.  
  174. if(Carbon::parse($date)->lte(Carbon::parse($karyawan[$i]->tanggal_jadwal_rutin_diedit))) {
  175. $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin-group')->where(function ($query) use ($day) {
  176. switch($day) {
  177. case 'Monday':
  178. $query->where('checkbox_harikerja_senin', 1);
  179. break;
  180. case 'Tuesday':
  181. $query->where('checkbox_harikerja_selasa', 1);
  182. break;
  183. case 'Wednesday':
  184. $query->where('checkbox_harikerja_rabu', 1);
  185. break;
  186. case 'Thursday':
  187. $query->where('checkbox_harikerja_kamis', 1);
  188. break;
  189. case 'Friday':
  190. $query->where('checkbox_harikerja_jumat', 1);
  191. break;
  192. case 'Saturday':
  193. $query->where('checkbox_harikerja_sabtu', 1);
  194. break;
  195. case 'Sunday':
  196. $query->where('checkbox_harikerja_minggu', 1);
  197. break;
  198. default:
  199. break;
  200. }
  201. })->first();
  202. } else if(Carbon::parse($date)->gt(Carbon::parse($karyawan[$i]->tanggal_jadwal_rutin_diedit))) {
  203. $jadwal_rutin = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin-group')->where(function ($query) use ($day) {
  204. switch($day) {
  205. case 'Monday':
  206. $query->where('checkbox_harikerja_senin_baru', 1);
  207. break;
  208. case 'Tuesday':
  209. $query->where('checkbox_harikerja_selasa_baru', 1);
  210. break;
  211. case 'Wednesday':
  212. $query->where('checkbox_harikerja_rabu_baru', 1);
  213. break;
  214. case 'Thursday':
  215. $query->where('checkbox_harikerja_kamis_baru', 1);
  216. break;
  217. case 'Friday':
  218. $query->where('checkbox_harikerja_jumat_baru', 1);
  219. break;
  220. case 'Saturday':
  221. $query->where('checkbox_harikerja_sabtu_baru', 1);
  222. break;
  223. case 'Sunday':
  224. $query->where('checkbox_harikerja_minggu_baru', 1);
  225. break;
  226. default:
  227. break;
  228. }
  229. })->first();
  230. }
  231. } else if($karyawan[$i]->jadwal_id != null && $karyawan[$i]->jadwal_group_id != null) {
  232.  
  233. $jadwal_perorangan = null;
  234. $jadwal_group = null;
  235.  
  236. if(Carbon::parse($date)->lte(Carbon::parse($karyawan[$i]->tanggal_jadwal_rutin_diedit))) {
  237. $jadwal_perorangan = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin')->where(function ($query) use ($day) {
  238. switch($day) {
  239. case 'Monday':
  240. $query->where('checkbox_harikerja_senin', 1);
  241. break;
  242. case 'Tuesday':
  243. $query->where('checkbox_harikerja_selasa', 1);
  244. break;
  245. case 'Wednesday':
  246. $query->where('checkbox_harikerja_rabu', 1);
  247. break;
  248. case 'Thursday':
  249. $query->where('checkbox_harikerja_kamis', 1);
  250. break;
  251. case 'Friday':
  252. $query->where('checkbox_harikerja_jumat', 1);
  253. break;
  254. case 'Saturday':
  255. $query->where('checkbox_harikerja_sabtu', 1);
  256. break;
  257. case 'Sunday':
  258. $query->where('checkbox_harikerja_minggu', 1);
  259. break;
  260. default:
  261. break;
  262. }
  263. })->first();
  264. $jadwal_group = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin-group')->where(function ($query) use ($day) {
  265. switch($day) {
  266. case 'Monday':
  267. $query->where('checkbox_harikerja_senin', 1);
  268. break;
  269. case 'Tuesday':
  270. $query->where('checkbox_harikerja_selasa', 1);
  271. break;
  272. case 'Wednesday':
  273. $query->where('checkbox_harikerja_rabu', 1);
  274. break;
  275. case 'Thursday':
  276. $query->where('checkbox_harikerja_kamis', 1);
  277. break;
  278. case 'Friday':
  279. $query->where('checkbox_harikerja_jumat', 1);
  280. break;
  281. case 'Saturday':
  282. $query->where('checkbox_harikerja_sabtu', 1);
  283. break;
  284. case 'Sunday':
  285. $query->where('checkbox_harikerja_minggu', 1);
  286. break;
  287. default:
  288. break;
  289. }
  290. })->first();
  291. } else if(Carbon::parse($date)->gt(Carbon::parse($karyawan[$i]->tanggal_jadwal_rutin_diedit))) {
  292. $jadwal_perorangan = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin')->where(function ($query) use ($day) {
  293. switch($day) {
  294. case 'Monday':
  295. $query->where('checkbox_harikerja_senin_baru', 1);
  296. break;
  297. case 'Tuesday':
  298. $query->where('checkbox_harikerja_selasa_baru', 1);
  299. break;
  300. case 'Wednesday':
  301. $query->where('checkbox_harikerja_rabu_baru', 1);
  302. break;
  303. case 'Thursday':
  304. $query->where('checkbox_harikerja_kamis_baru', 1);
  305. break;
  306. case 'Friday':
  307. $query->where('checkbox_harikerja_jumat_baru', 1);
  308. break;
  309. case 'Saturday':
  310. $query->where('checkbox_harikerja_sabtu_baru', 1);
  311. break;
  312. case 'Sunday':
  313. $query->where('checkbox_harikerja_minggu_baru', 1);
  314. break;
  315. default:
  316. break;
  317. }
  318. })->first();
  319. $jadwal_group = JadwalHariKerja::where('karyawan_id', $karyawan[$i]->id)->where('status', 'rutin-group')->where(function ($query) use ($day) {
  320. switch($day) {
  321. case 'Monday':
  322. $query->where('checkbox_harikerja_senin_baru', 1);
  323. break;
  324. case 'Tuesday':
  325. $query->where('checkbox_harikerja_selasa_baru', 1);
  326. break;
  327. case 'Wednesday':
  328. $query->where('checkbox_harikerja_rabu_baru', 1);
  329. break;
  330. case 'Thursday':
  331. $query->where('checkbox_harikerja_kamis_baru', 1);
  332. break;
  333. case 'Friday':
  334. $query->where('checkbox_harikerja_jumat_baru', 1);
  335. break;
  336. case 'Saturday':
  337. $query->where('checkbox_harikerja_sabtu_baru', 1);
  338. break;
  339. case 'Sunday':
  340. $query->where('checkbox_harikerja_minggu_baru', 1);
  341. break;
  342. default:
  343. break;
  344. }
  345. })->first();
  346. }
  347.  
  348. // if($karyawan[$i]->id == 10101) {
  349. // dd($jadwal_perorangan);
  350. // }
  351.  
  352. if($jadwal_perorangan != null && $jadwal_group == null) {
  353. $jadwal_rutin = $jadwal_perorangan;
  354. } else if($jadwal_perorangan == null && $jadwal_group != null) {
  355. $jadwal_rutin = $jadwal_group;
  356. } else if($jadwal_perorangan != null && $jadwal_group != null) {
  357. $jadwal_rutin = $jadwal_perorangan;
  358. }
  359. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!