Ejemplo n.º 1
0
 public function importExcel()
 {
     $fileInfo = $this->uploadFile(request()->file('file'), 'import');
     $pathToFile = $fileInfo['path'] . '/' . $fileInfo['name'];
     Excel::selectSheets('Sheet1')->load($pathToFile, function ($reader) {
         $rows = $reader->get();
         foreach ($rows as $key => $value) {
             // b1: find order with unit, order_name, order_phone
             $query = DB::table('orders')->join('units', 'orders.unit_id', '=', 'units.id')->join('phones', 'orders.id', '=', 'phones.order_id')->join('purposes', 'orders.purpose_id', '=', 'purposes.id')->where('phones.number', $value['so_dien_thoai'])->where('units.symbol', $value['don_vi_yc'])->where('orders.order_name', 'like', '%' . $value['ho_ten_doi_tuong'] . '%')->where('purposes.group', 'monitor')->select('phones.id');
             $order = $query->first();
             if (isset($order)) {
                 // up date status phone
                 $phone = Phone::find($order->id);
                 if ($phone->status != 'success') {
                     $phone->status = 'success';
                     $phone->save();
                 }
                 $input = $this->excelForShip($value, $order->id);
                 $newShip = new ShipRepository(new Ship());
                 $newShip->create($input);
             }
         }
     });
     return redirect()->back();
 }
Ejemplo n.º 2
0
 public function update($id, array $input, $fileName = '')
 {
     $ship = $this->findById($id);
     // update phone status
     if ($input['news'] == null) {
         $phone = $ship->phone;
         $phone->status = 'warning';
         $phone->save();
         $phone = Phone::find($input['phone']);
         $phone->status = 'success';
         $phone->save();
     }
     // update ship
     $ship->date_submit = Carbon::createFromFormat('d/m/Y', $input['created_at']);
     $ship->phone_id = $input['phone'];
     $ship->number_cv_pa71 = $input['number_cv_pa71'];
     $ship->news = $input['news'];
     $ship->page_news = $input['page_news'];
     $ship->page_list = $input['page_list'];
     $ship->page_xmctb = $input['page_xmctb'];
     $ship->page_imei = $input['page_imei'];
     $ship->receive_name = $input['receive_name'];
     $ship->user_id = $input['user_name'];
     if ($fileName != '') {
         $ship->file_name = $fileName;
     }
     $ship->save();
     // syn network table
     if (isset($input['network'])) {
         $ship->networks()->sync($input['network']);
     }
     return $ship;
 }
Ejemplo n.º 3
0
 public function changeContactInfo(Request $request)
 {
     if ($request->type == 'contact') {
         $item = Contact::find($request->entity);
         if ($request->name == 'first_name') {
             $item->first_name = $request->value;
         } elseif ($request->name == 'last_name') {
             $item->last_name = $request->value;
         } elseif ($request->name == 'email') {
             $item->email = $request->value;
         } elseif ($request->name == 'title') {
             $item->title = $request->value;
         } else {
         }
         $item->save();
     } elseif ($request->type == 'address') {
         $item = Address::find($request->entity);
         $item->full_string = $request->value;
         $item->save();
         return $request->all();
     } elseif ($request->type == 'phone') {
         $item = Phone::find($request->entity);
         if ($request->name == 'type') {
             $item->type = $request->value;
         } elseif ($request->name == 'number') {
             $item->number = $request->value;
         } elseif ($request->name == 'from') {
             $item->available_from = $request->value;
         } elseif ($request->name == 'to') {
             $item->available_to = $request->value;
         } else {
         }
         $item->save();
         return $request->all();
     } else {
     }
 }
Ejemplo n.º 4
0
 public function testMorphHas()
 {
     $user = User::find(1);
     $photo = $user->photo;
     $this->assertInstanceOf('App\\Photo', $photo);
     $phone = Phone::find(1);
     $photos = $phone->photos;
     $this->assertSame(FALSE, $photos->isEmpty());
 }
Ejemplo n.º 5
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     //
     $phone = Phone::find($id);
     return view('phone.edit')->with('phone', $phone);
 }
 public function index()
 {
     dd(Phone::find(4)->user);
 }
Ejemplo n.º 7
0
 public function updateStatus(Request $request, $phoneId)
 {
     $phone = Phone::find($phoneId);
     $order = $this->order->findById($phone->order_id);
     $order->comment = $request->get('comment');
     $order->save();
     $phone->status = $request->get('status');
     $phone->save();
     return redirect()->back();
 }
Ejemplo n.º 8
0
 public function phone($id)
 {
     Phone::find($id)->delete();
     return back();
 }
Ejemplo n.º 9
0
 public function testDelete()
 {
     // test delete()
     $phone = Phone::find(1);
     $this->assertNotNull($phone);
     $phone = Phone::find(1);
     $phone->delete();
     $phone = Phone::find(1);
     $this->assertNull($phone);
     // test delete() with query builder
     // Post is soft delete model
     $posts = Post::where('id', '<', 3)->get();
     $this->assertFalse($posts->isEmpty());
     Post::where('id', '<', 3)->delete();
     $posts = Post::where('id', '<', 3)->get();
     $this->assertTrue($posts->isEmpty());
     // test destroy()
     $phone = Phone::find(2);
     $this->assertNotNull($phone);
     Phone::destroy(2);
     $phone = Phone::find(2);
     $this->assertNull($phone);
     $photos = Photo::all();
     $this->assertFalse($photos->isEmpty());
     Photo::destroy([1, 2, 3]);
     $photos = Photo::all();
     $this->assertTrue($photos->isEmpty());
     // test destopy with non-existing primary key
     // expect no exception
     Photo::destroy([1, 2, 3]);
     $photos = Photo::all();
     $this->assertTrue($photos->isEmpty());
 }