API tools faq
paste
outattacker

Untitled

outattacker
Sep 24th, 2018
134
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.12 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. namespace App\Http\Controllers;
  4.  
  5. use Illuminate\Http\Request;
  6. use App\Http\Controllers\Controller;
  7. use Illuminate\Support\Facades\Auth;
  8. use Validator;
  9. use File;
  10. use Hash;
  11. use DB;
  12. use App\User;
  13. use App\TaskType;
  14. use App\Task;
  15. use App\Document;
  16. use App\ClientAdditions;
  17. use App\WorkerAdditions;
  18.  
  19. class ApiController extends Controller
  20. {
  21. //
  22.  
  23. public function doLogin(Request $request) {
  24. $validator = Validator::make($request->all(), [
  25. 'email' => 'required|email',
  26. 'password' => 'required'
  27. ]);
  28.  
  29. if ($validator->fails()) {
  30. # code...
  31. return response(['status' => false, 'message' => 'Email atau Password Salah'], 401);
  32. } else {
  33. $ifEmailisExists = User::where('email', $request->email)->get();
  34. if (count($ifEmailisExists) <= 0) {
  35. # code...
  36. return response(['status' => false, 'message' => 'Email Tidak Terdaftar'], 401);
  37. } else {
  38. if ( !Auth::attempt(['email' => $request->email, 'password' => $request->password]) ) {
  39. # code...
  40. return response(['status' => false, 'message' => 'Email atau Password Salah'], 401);
  41. } else {
  42. $user = Auth::user();
  43. $token = $user->createToken('RO TOKEN')->accessToken;
  44. return response(['status' => true, 'message' => 'Login Berhasil', 'data' => $token], 200);
  45. }
  46. }
  47. }
  48. }
  49.  
  50. public function getUserData() {
  51. $user = Auth::user();
  52. return response(['status' => true, 'message' => 'User Ditemukan', 'data' => $user], 200);
  53. }
  54.  
  55. public function doChangePassword(Request $request) {
  56. $valid = Validator::make($request->all(), [
  57. 'old_password' => 'required',
  58. 'new_password' => 'required',
  59. 'confirm_password' => 'required_with:new_password|same:new_password'
  60. ]);
  61.  
  62. if ($valid->fails()) {
  63. # code...
  64. return response(['status' => false, 'message' => 'Form Tidak Lengkap'], 401);
  65. } else {
  66. if (Hash::check($request->old_password, Auth::user()->password)) {
  67. # code...
  68. $update = User::where('id', Auth::user()->id)->update([
  69. 'password' => bcrypt($request->confirm_password)
  70. ]);
  71.  
  72. if ($update) {
  73. # code...
  74. return response(['status' => true, 'message' => 'Password Berhasil Diubah'], 200);
  75. } else {
  76. return response(['status' => false, 'message' => 'Gagal Ubah Password'], 401);
  77. }
  78. } else {
  79. return response(['status' => false, 'message' => 'Password Lama Salah'], 401);
  80. }
  81. }
  82. }
  83.  
  84. public function doUpdateProfile(Request $request) {
  85. $valid = Validator::make($request->all(), [
  86. 'name' => 'required',
  87. 'nik' => 'required',
  88. 'email' => 'required',
  89. 'birthdate' => 'required',
  90. 'phone' => 'required',
  91. 'image' => 'image:mimes:jpg,jpeg,png'
  92. ]);
  93.  
  94. if ($valid->fails()) {
  95. # code...
  96. return response(['status' => false, 'message' => 'Form Tidak Lengkap'], 401);
  97. } else {
  98. if ($request->hasFile('image')) {
  99. # code...
  100. $user = User::where('id', Auth::user()->id)->update([
  101. 'name' => $request->name,
  102. 'nik' => $request->nik,
  103. 'email' => $request->email,
  104. 'birthdate' => $request->birthdate,
  105. 'phone' => $request->phone,
  106. 'image' => $this->savePhoto($request->file('image'))
  107. ]);
  108.  
  109. if ($user) {
  110. # code...
  111. return response(['status' => true, 'message' => 'Profile Berhasil Diupdate'], 200);
  112. } else {
  113. return response(['status' => false, 'message' => 'Gagal Update Profile'], 401);
  114. }
  115. } else {
  116. $cek = User::where('id', Auth::user()->id)->first();
  117. $user = User::where('id', Auth::user()->id)->update([
  118. 'name' => $request->name,
  119. 'nik' => $request->nik,
  120. 'email' => $request->email,
  121. 'birthdate' => $request->birthdate,
  122. 'phone' => $request->phone,
  123. 'image' => $cek['image']
  124. ]);
  125.  
  126. if ($user) {
  127. # code...
  128. return response(['status' => true, 'message' => 'Profile Berhasil Diupdate'], 200);
  129. } else {
  130. return response(['status' => false, 'message' => 'Gagal Update Profile'], 401);
  131. }
  132. }
  133. }
  134. }
  135.  
  136. public function getTaskList() {
  137. $task = Task::select('task_ro.*', 'b.title', 'c.name', 'c.address1', 'c.state', 'c.postal_code', 'c.work_phone', 'c.website')
  138. ->join('task_types as b', 'b.id', 'task_ro.task_type_id')
  139. ->join('clients as c', 'c.id', 'task_ro.client_id')
  140. ->join('invoices as d', 'd.id', 'task_ro.invoice_id')
  141. ->where('task_ro.task_type_id', 3)
  142. ->where('task_ro.is_deleted', 'N')
  143. ->where('task_ro.user_id', Auth::user()->id)->get();
  144.  
  145. if (count($task) <= 0) {
  146. # code...
  147. return response(['status' => false, 'message' => 'Task Kosong', 'data' => []], 401);
  148. } else {
  149. return response(['status' => true, 'message' => 'Task Ditemukan', 'data' => $task], 200);
  150. }
  151. }
  152.  
  153. public function getTaskListExceptMonitoring() {
  154. $task = Task::select('task_ro.*', 'b.title', 'c.uker_name', 'c.uker_address', 'c.uker_phone')
  155. ->join('task_types as b', 'b.id', 'task_ro.task_type_id')
  156. ->join('uker as c', 'c.id', 'task_ro.client_id')
  157. ->where('task_ro.task_type_id', '!=' ,3)
  158. ->where('task_ro.is_deleted', 'N')
  159. ->where('task_ro.user_id', Auth::user()->id)->get();
  160.  
  161. if (count($task) <= 0) {
  162. # code...
  163. return response(['status' => false, 'message' => 'Task Kosong', 'data' => []], 401);
  164. } else {
  165. return response(['status' => true, 'message' => 'Task Ditemukan', 'data' => $task], 200);
  166. }
  167. }
  168.  
  169. public function getFilterTaskByDate(Request $request) {
  170. $valid = Validator::make($request->all(), [
  171. 'date' => 'required'
  172. ]);
  173.  
  174. if ($valid->fails()) {
  175. # code...
  176. return response(['status' => false, 'message' => 'Tanggal Masih Kosong'], 401);
  177. } else {
  178. $task = Task::where('user_id', Auth::user()->id)->whereDate('for_date', $request->date)->groupBy('for_date')->get();
  179. if (count($task) <= 0) {
  180. # code...
  181. return response(['status' => false, 'message' => 'Task Kosong', 'data' => []], 401);
  182. } else {
  183. return response(['status' => true, 'message' => 'Task Ditemukan', 'data' => $task], 200);
  184. }
  185. }
  186. }
  187.  
  188. public function getTaskDetail(Request $request) {
  189. $valid = Validator::make($request->all(), [
  190. 'id' => 'required'
  191. ]);
  192.  
  193. if ($valid->fails()) {
  194. # code...
  195. return response(['status' => false, 'message' => 'Task Belum Dipilih'], 401);
  196. } else {
  197. $task = Task::where('id', $request->id)->first();
  198. if (!$task) {
  199. # code...
  200. return response(['status' => false, 'message' => 'Task Kosong', 'data' => []], 401);
  201. } else {
  202. return response(['status' => true, 'message' => 'Task Ditemukan', 'data' => $task], 200);
  203. }
  204. }
  205. }
  206.  
  207. public function acceptTask(Request $request) {
  208. $valid = Validator::make($request->all(), [
  209. 'task_id' => 'required',
  210. 'notes' => 'required',
  211. 'penerima' => 'required',
  212. 'jabatan' => 'required',
  213. 'signature' => 'image|mimes:jpg,jpeg,png',
  214. 'document' => 'image|mimes:jpg,jpeg,png',
  215. 'geo_lat' => 'required',
  216. 'geo_long' => 'required'
  217. ]);
  218.  
  219. if ($valid->fails()) {
  220. # code...
  221. return response(['status' => false, 'message' => 'Data Tidak Lengkap'], 401);
  222. } else {
  223. if ($request->hasFile('signature')) {
  224. # code...
  225. $cek = Task::where('id', $request->task_id)->first();
  226. $create = Task::where('id', $request->task_id)->update([
  227. 'catatan' => $request->notes,
  228. 'penerima' => $request->penerima,
  229. 'jabatan' => $request->jabatan,
  230. 'signature' => $this->saveSignature($request->file('signature')),
  231. 'status' => 'Y',
  232. 'geo_lat' => $request->geo_lat,
  233. 'geo_long' => $request->geo_long
  234. ]);
  235.  
  236. if ($cek->task_type_id == 3) {
  237. DB::table('clients')->where('id', $cek->client_id)->limit(1)->update([
  238. 'geo_lat' => $request->geo_lat,
  239. 'geo_long' => $request->geo_long
  240. ]);
  241. } else {
  242. DB::table('uker')->where('id', $cek->client_id)->limit(1)->update([
  243. 'geo_lat' => $request->geo_lat,
  244. 'geo_long' => $request->geo_long
  245. ]);
  246. }
  247.  
  248. for ($i=1; $i <= $request->total_img; $i++) {
  249. # code...
  250. $fileId = 'document'.$i;
  251. Document::create([
  252. 'task_ro_id' => $request->task_id,
  253. 'name' => $this->saveDocument($request->file($fileId))
  254. ]);
  255. }
  256.  
  257. if ($create) {
  258. # code...
  259. return response(['status' => true, 'message' => 'Acc Tugas Berhasil'], 200);
  260. } else {
  261. return response(['status' => false, 'message' => 'Gagal Acc Tugas'], 401);
  262. }
  263. } else {
  264. return response(['status' => false, 'message' => 'Tanda Tangan Kosong'], 401);
  265. }
  266. }
  267. }
  268.  
  269. public function doAddTask(Request $request) {
  270. $valid = Validator::make($request->all(), [
  271. 'task_type_id' => 'required',
  272. 'penerima' => 'required',
  273. 'notes' => 'required',
  274. 'jabatan' => 'required',
  275. 'signature' => 'image|mimes:jpg,jpeg,png',
  276. 'document' => 'image|mimes:jpg,jpeg,png'
  277. ]);
  278.  
  279. if ($valid->fails()) {
  280. # code...
  281. return response(['status' => false, 'message' => 'Data Tidak Valid'], 401);
  282. } else {
  283. if ($request->hasFile('signature')) {
  284. # code...
  285. if (isset($request->invoice)) {
  286. $inv = DB::table('invoices')->select('invoice_number')->where('id', $request->invoice)->first();
  287. $create = Task::create([
  288. 'task_type_id' => $request->task_type_id,
  289. 'user_id' => Auth::user()->id,
  290. 'client_id' => ($request->task_type_id == 3) ? $request->client : $request->uker,
  291. 'catatan' => $request->notes,
  292. 'signature' => Self::saveSignature($request->file('signature')),
  293. 'penerima' => $request->penerima,
  294. 'jabatan' => $request->jabatan,
  295. 'invoice_id' => ($request->task_type_id == 3) ? $inv->invoice_number : null,
  296. 'status' => 'Y',
  297. 'for_date' => date('Y-m-d'),
  298. 'geo_lat' => $request->geo_lat,
  299. 'geo_long' => $request->geo_long
  300. ]);
  301.  
  302. if ($create->task_type_id == 3) {
  303. DB::table('clients')->where('id', $create->client_id)->limit(1)->update([
  304. 'geo_lat' => $request->geo_lat,
  305. 'geo_long' => $request->geo_long
  306. ]);
  307. } else {
  308. DB::table('uker')->where('id', $create->client_id)->limit(1)->update([
  309. 'geo_lat' => $request->geo_lat,
  310. 'geo_long' => $request->geo_long
  311. ]);
  312. }
  313.  
  314. for ($i=1; $i <= $request->total_img; $i++) {
  315. # code...
  316. $fileId = 'document'.$i;
  317. Document::create([
  318. 'task_ro_id' => $create->id,
  319. 'name' => $this->saveDocument($request->file($fileId))
  320. ]);
  321. }
  322.  
  323. if ($create) {
  324. # code...
  325. return response(['status' => true, 'message' => 'Tugas Berhasil Ditambahkan'], 200);
  326. } else {
  327. return response(['status' => false, 'message' => 'Gagal Menambahkan Tugas'], 401);
  328. }
  329. } else {
  330. $create = Task::create([
  331. 'task_type_id' => $request->task_type_id,
  332. 'user_id' => Auth::user()->id,
  333. 'client_id' => $request->client,
  334. 'catatan' => $request->notes,
  335. 'signature' => Self::saveSignature($request->file('signature')),
  336. 'penerima' => $request->penerima,
  337. 'jabatan' => $request->jabatan,
  338. 'invoice_id' => null,
  339. 'status' => 'Y',
  340. 'for_date' => date('Y-m-d'),
  341. 'geo_lat' => $request->geo_lat,
  342. 'geo_long' => $request->geo_long
  343. ]);
  344.  
  345. if ($create->task_type_id == 3) {
  346. DB::table('clients')->where('id', $create->client_id)->limit(1)->update([
  347. 'geo_lat' => $request->geo_lat,
  348. 'geo_long' => $request->geo_long
  349. ]);
  350. } else {
  351. DB::table('uker')->where('id', $create->client_id)->limit(1)->update([
  352. 'geo_lat' => $request->geo_lat,
  353. 'geo_long' => $request->geo_long
  354. ]);
  355. }
  356.  
  357. for ($i=1; $i <= $request->total_img; $i++) {
  358. # code...
  359. $fileId = 'document'.$i;
  360. Document::create([
  361. 'task_ro_id' => $create->id,
  362. 'name' => $this->saveDocument($request->file($fileId))
  363. ]);
  364. }
  365.  
  366. if ($create) {
  367. # code...
  368. return response(['status' => true, 'message' => 'Tugas Berhasil Ditambahkan'], 200);
  369. } else {
  370. return response(['status' => false, 'message' => 'Gagal Menambahkan Tugas'], 401);
  371. }
  372. }
  373. } else {
  374. return response(['status' => false, 'message' => 'Anda Belum Tanda Tangan'], 401);
  375. }
  376. }
  377. }
  378.  
  379. public function getListPgsAvail()
  380. {
  381. $data = DB::table('pgs')->where('status', 'Y')->get();
  382. $avail = DB::table('pgs')->where('status', 'Y')->count();
  383. $unavail = DB::table('pgs')->where('status', 'N')->count();
  384. if (count($data) <= 0) {
  385. # code...
  386. return response(['status' => false, 'message' => 'Data Tidak Ada', 'avail' => $avail, 'unavail' => $unavail, 'data' => []], 401);
  387. } else {
  388. return response(['status' => true, 'message' => 'Data Ditemukan', 'avail' => $avail, 'unavail' => $unavail, 'data' => $data], 200);
  389. }
  390. }
  391.  
  392. public function getListKanca(Request $request)
  393. {
  394. $data = DB::table('clients')->where('custom_value1', $request->id)->get();
  395. if (count($data) <= 0) {
  396. # code...
  397. return response(['status' => false, 'message' => 'Tidak Ada Data', 'data' => []], 401);
  398. } else {
  399. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $data], 200);
  400. }
  401. }
  402.  
  403. public function getListTask()
  404. {
  405. $data = DB::table('task_types')->where('is_deleted', 'N')->get();
  406.  
  407. if (count($data) <= 0) {
  408. # code...
  409. return response(['status' => false, 'message' => 'Tidak Ada Data', 'data' => []], 401);
  410. } else {
  411. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $data], 200);
  412. }
  413. }
  414.  
  415. public function getInvoiceByClient(Request $request)
  416. {
  417. $valid = Validator::make($request->all(), [
  418. 'client_id' => 'required'
  419. ]);
  420.  
  421. if ($valid->fails()) {
  422. # code...
  423. return response(['status' => false, 'message' => 'Client Belum Dipilih'], 401);
  424. } else {
  425. $data = DB::table('invoices')->where('client_id', $request->client_id)->where('is_deleted', 0)->get();
  426. if (count($data) <= 0) {
  427. # code...
  428. return response(['status' => false, 'message' => 'Tidak Ada Data', 'data' => []], 401);
  429. } else {
  430. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $data], 200);
  431. }
  432. }
  433. }
  434.  
  435. public function postPgs(Request $request)
  436. {
  437. $valid = Validator::make($request->all(), [
  438. 'pgs_id' => 'required',
  439. 'client_id' => 'required',
  440. 'start_date' => 'required',
  441. 'end_date' => 'required'
  442. ]);
  443.  
  444. if ($valid->fails()) {
  445. # code...
  446. return response(['status' => false, 'message' => 'Data Tidak Valid'], 401);
  447. } else {
  448. $client = DB::table('clients')->where('id', $request->client_id)->first();
  449. if (empty($client)) {
  450. # code...
  451. return response(['status' => false, 'message' => 'Client Tidak Ditemukan'], 401);
  452. } else {
  453. $insert = DB::table('pgs_switch')->insert([
  454. 'ro_id' => Auth::user()->id,
  455. 'pgs_id' => $request->pgs_id,
  456. 'company_name' => $client->name,
  457. 'start_date' => $request->start_date,
  458. 'end_date' => $request->end_date,
  459. 'status' => 'N'
  460. ]);
  461.  
  462. DB::table('pgs')->where('id', $request->pgs_id)->update([
  463. 'status' => 'N'
  464. ]);
  465.  
  466. if ($insert) {
  467. # code...
  468. return response(['status' => true, 'message' => 'PGS Berhasil Diproses'], 200);
  469. } else {
  470. return response(['status' => false, 'message' => 'Gagal Memproses PGS'], 401);
  471. }
  472. }
  473. }
  474. }
  475.  
  476. public function listApprovalPgs()
  477. {
  478. $data = DB::table('pgs_switch')->select('pgs_switch.*', 'a.pgs_name')->join('pgs as a', 'a.id', 'pgs_switch.pgs_id')->where('pgs_switch.ro_id', Auth::user()->id)->get();
  479. if (count($data) <= 0) {
  480. # code...
  481. return response(['status' => false, 'message' => 'Data Kosong', 'data' => []], 401);
  482. } else {
  483. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $data], 200);
  484. }
  485. }
  486.  
  487. public function getDashboardList()
  488. {
  489. $taskDone = Task::where('user_id', Auth::user()->id)->where('status', 'Y')->whereMonth('for_date', date('m'))->count();
  490. $taskUnfinished = Task::where('user_id', Auth::user()->id)->where('status', 'N')->whereMonth('for_date', date('m'))->count();
  491.  
  492. $invDone = Task::where('task_type_id', 3)->where('user_id', Auth::user()->id)->where('status', 'Y')->whereMonth('for_date', date('m'))->count();
  493. $invUnfinished = Task::where('task_type_id', 3)->where('user_id', Auth::user()->id)->where('status', 'N')->whereMonth('for_date', date('m'))->count();
  494.  
  495. $invTotalDone = DB::table('task_ro as a')->select('b.amount')->join('invoices as b', 'b.id', 'a.invoice_id')->where('a.task_type_id', 3)
  496. ->where('a.user_id', Auth::user()->id)->where('a.status', 'Y')->whereMonth('a.for_date', date('m'))->sum('b.amount');
  497. $invTotalUnfinished = DB::table('task_ro as a')->select('b.amount')->join('invoices as b', 'b.id', 'a.invoice_id')->where('a.task_type_id', 3)
  498. ->where('a.user_id', Auth::user()->id)->where('a.status', 'N')->whereMonth('a.for_date', date('m'))->sum('b.amount');
  499.  
  500. $clientAdditionsDone = ClientAdditions::select('realized')->where('ro_id', Auth::user()->id)->first();
  501. $clientDone = ($clientAdditionsDone['realized'] == null) ? 0 : $clientAdditionsDone['realized'];
  502. $clientAdditionsUnfinished = ClientAdditions::select('unrealized')->where('ro_id', Auth::user()->id)->first();
  503. $clientFail = ($clientAdditionsUnfinished['unrealized'] == null) ? 0 : $clientAdditionsUnfinished['unrealized'];
  504.  
  505. $workerAdditionsDone = WorkerAdditions::select('realized')->where('ro_id', Auth::user()->id)->first();
  506. $workerDone = ($workerAdditionsDone['realized'] == null) ? 0 : $workerAdditionsDone['realized'];
  507. $workerAdditionsUnfinished = WorkerAdditions::select('unrealized')->where('ro_id', Auth::user()->id)->first();
  508. $workerFail = ($workerAdditionsUnfinished['unrealized'] == null) ? 0 : $workerAdditionsUnfinished['unrealized'];
  509.  
  510. return response(['status' => true,
  511. 'message' => 'Found Data',
  512. 'taskDone' => $taskDone,
  513. 'taskUnfinished' => $taskUnfinished,
  514. 'invDone' => $invDone,
  515. 'invUnfinished' => $invUnfinished,
  516. 'invTotalDone' => $invTotalDone,
  517. 'invTotalUnfinished' => $invTotalUnfinished,
  518. 'clientAdditionsDone' => $clientDone,
  519. 'clientAdditionsFail' => $clientFail,
  520. 'workerDone' => $workerDone,
  521. 'workerFail' => $workerFail], 200);
  522. }
  523.  
  524. protected function getReport(Request $request)
  525. {
  526. $validator = Validator::make($request->all(), [
  527. 'fromDate' => 'required',
  528. 'toDate' => 'required'
  529. ]);
  530.  
  531. if($validator->fails()) {
  532. # code...
  533. return response(['status' => false, 'message' => 'Format request tidak lengkap.'], 401);
  534. } else {
  535. $task = Task::select('task_ro.*', 'b.title')
  536. ->join('task_types as b', 'b.id', 'task_ro.task_type_id')
  537. ->where('task_ro.is_deleted', 'N')
  538. ->where('task_ro.user_id', Auth::user()->id)
  539. ->whereBetween('task_ro.for_date', [$request->fromDate, $request->toDate])->get();
  540.  
  541. if(count($task) <= "0") {
  542. return response(['status' => false, 'message' => 'Data tidak ditemukan', 'data' => []], 401);
  543.  
  544. } else {
  545. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $task], 200);
  546. }
  547. }
  548. }
  549.  
  550. public function getListNotifications()
  551. {
  552. $dataNotifTugas = DB::table('notifications')->where('ro_id', Auth::user()->id)->where('type', 'T')->where('is_read', 'N')->count();
  553. $dataNotifBerita = DB::table('notifications')->where('ro_id', Auth::user()->id)->where('type', 'B')->where('is_read', 'N')->count();
  554.  
  555. return response(['status' => true, 'message' => 'List Notifikasi', 'listTugas' => $dataNotifTugas, 'listBerita' => $dataNotifBerita], 200);
  556. }
  557.  
  558. public function getListNews()
  559. {
  560. $data = DB::table('news')->get();
  561. if (count($data) <= 0) {
  562. # code...
  563. return response(['status' => false, 'message' => 'Data Kosong', 'data' => []], 401);
  564. } else {
  565. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $data], 200);
  566. }
  567. }
  568.  
  569. public function readNotifications()
  570. {
  571. $update = DB::table('notifications')->where('ro_id', Auth::user()->id)->update([
  572. 'is_read' => 'Y'
  573. ]);
  574.  
  575. return response(['status' => true, 'message' => 'Updated'], 200);
  576. }
  577.  
  578. public function getDocument(Request $request)
  579. {
  580. $data = DB::table('document_ro')->where('task_ro_id', $request->task_ro_id)->get();
  581. if (count($data) <= 0) {
  582. return response(['status' => false, 'message' => 'Data Kosong', 'data' => []], 401);
  583. } else {
  584. return response(['status' => true, 'message' => 'Data Ditemukan', 'data' => $data], 200);
  585. }
  586. }
  587.  
  588. public function getListWilayah()
  589. {
  590. $data = DB::table('cities')->select('city_id', 'city_name')->get();
  591. return response(['status' => true, 'message' => 'Found', 'data' => $data], 200);
  592. }
  593.  
  594. public function getListUker(Request $request)
  595. {
  596. $valid = Validator::make($request->all(), [
  597. 'id' => 'required'
  598. ]);
  599.  
  600. if ($valid->fails()) {
  601. # code...
  602. return response(['status' => 'false', 'message' => 'RO Belum Dipilih', 'data' => []], 401);
  603. } else {
  604. $data = DB::table('ro_placement as a')->select('b.id', 'b.uker_name')->join('uker as b', 'b.id', 'a.uker_id')->where('a.ro_id', $request->id)->groupBy('a.uker_id')->get();
  605. return response(['status' => true, 'message' => 'Found', 'data' => $data], 200);
  606. }
  607. }
  608.  
  609. public function getListClient(Request $request)
  610. {
  611. $data = DB::table('ro_placement as a')->select('b.id', 'b.client_name')->join('client_ro as b', 'b.id', 'a.client_ro_id')->where('a.city_id', $request->id)->groupBy('a.client_ro_id')->get();
  612. return response(['status' => true, 'message' => 'Found', 'data' => $data], 200);
  613. }
  614.  
  615. protected function savePhoto($photo)
  616. {
  617. $destinationPath = 'images';
  618. $subdestinationPath = 'user';
  619. $extension = $photo->getClientOriginalExtension();
  620. $fileName = rand(11111,99999).'.'.$extension;
  621. $photo->move($destinationPath. '/' . $subdestinationPath , $fileName);
  622. $create['image'] = $destinationPath. '/' . $subdestinationPath . '/' . $fileName;
  623.  
  624. return $create['image'];
  625. }
  626.  
  627. protected function saveDocument($photo)
  628. {
  629. $destinationPath = 'images';
  630. $subdestinationPath = 'document';
  631. $extension = $photo->getClientOriginalExtension();
  632. $fileName = rand(11111,99999).'.'.$extension;
  633. $photo->move($destinationPath. '/' . $subdestinationPath , $fileName);
  634. $create['document'] = $destinationPath. '/' . $subdestinationPath . '/' . $fileName;
  635.  
  636. return $create['document'];
  637. }
  638.  
  639. protected function saveSignature($photo)
  640. {
  641. $destinationPath = 'images';
  642. $subdestinationPath = 'signature';
  643. $extension = $photo->getClientOriginalExtension();
  644. $fileName = rand(11111,99999).'.'.$extension;
  645. $photo->move($destinationPath. '/' . $subdestinationPath , $fileName);
  646. $create['signature'] = $destinationPath. '/' . $subdestinationPath . '/' . $fileName;
  647.  
  648. return $create['signature'];
  649. }
  650.  
  651. protected function deletePhoto($photo)
  652. {
  653. File::delete($photo);
  654. return $photo;
  655. }
  656. }
Advertisement
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!