PHP DB::rollback方法代码示例

 public function destory()
 {
     try {
         \DB::beginTransaction();
         $product = Product::find(\Request::get('product_id'));
         $product->status = 'STOP';
         $product->save();
         \DB::commit();
     } catch (exception $e) {
         \DB::rollback();
         return \Response::json(['result' => 'success']);
     }
     return \Response::json(['result' => 'success']);
 }

 public function getCheckuser()
 {
     $sessionfb = Session::get('sessionfb');
     dd($sessionfb);
     $userfb = Session::get('userfb');
     $check = User::checkuser($userfb, $nh);
     //kiem tra id nha hang
     //kiem tra check, neu khong co nguoi dung trong db
     if ($check == false) {
         if (!NhaHang::checkid($nh)) {
             return Redirect::to('/error');
         } else {
             DB::beginTransaction();
             try {
                 $user = User::createuser($userfb, htmlentities($_SERVER['HTTP_USER_AGENT']), $nh);
                 $code = Code::createcode($userfb, $type, $nh);
                 DB::commit();
             } catch (Exception $e) {
                 //If there are any exceptions, rollback the transaction
                 DB::rollback();
             }
             //Everything worked perfectly. Commit the transaction
             $user = $userfb->asArray();
             $user['fb_id'] = $user['id'];
             Session::put('user', (object) $user);
             return Redirect::to('/hello');
         }
     } else {
         $user = $check;
         $user->save();
         $c = false;
         $arrs = Code::where('fb_id', $user->fb_id)->get();
         foreach ($arrs as $arr) {
             if ($nh == $arr->nhahang_id) {
                 $c = true;
                 break;
             }
         }
         if (!$c) {
             $code = Code::createcode($userfb, $type, $nh);
             Session::put('user', $user);
             return Redirect::to('/hello');
         } else {
             Session::put('user', $user);
             return Redirect::to('/hello');
         }
     }
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Requests\AddTask $request)
 {
     try {
         \DB::beginTransaction();
         $task = new Task();
         $task->fill($request->only('title', 'description', 'deadline'));
         $task->user_id = auth()->user()->id;
         $task->save();
         \DB::commit();
         flash()->success('Task added to list successfully.');
         return redirect()->back();
     } catch (\Exception $e) {
         \DB::rollback();
         flash()->error($e->getMessage());
         return redirect()->back()->withInput();
     }
 }

 public function product_submit()
 {
     $data = \Request::input();
     try {
         \DB::beginTransaction();
         $order = new Order();
         $order->product_id = $data['product_id'];
         $order->user_id = \Auth::user()->id;
         $order->quantity = $data['item_count'];
         $order->status = 'Inprogress';
         $order->save();
         // 견적서 메일 발송
         //\Event::fire('order.send_mail', [$data]);
         \DB::commit();
     } catch (exception $e) {
         \DB::rollback();
         #return \Response::json(['result' => 'error']);
     }
     #return \Response::json(['result' => 'success']);
     return \Redirect()->route('order_product', 1);
     // 영업사원 user_id 로 변경 해야 함.
 }

 public function put(Request $request, $id)
 {
     //return $request->all();
     if (strtolower($request->input('id')) == strtolower($id)) {
         $manday = Manday::find($id);
         if (count($manday) > 0) {
             //\DB::beginTransaction();
             $manday->custcount = $request->input('custcount');
             $manday->headspend = $request->input('headspend');
             $manday->empcount = $request->input('empcount');
             $manday->workhrs = $request->input('workhrs');
             $manday->breakhrs = $request->input('breakhrs');
             $manday->loading = $request->input('loading');
             \DB::beginTransaction();
             //Start transaction!
             try {
                 $manday->save();
                 try {
                     foreach ($request->input('manskeddtls') as $mandtl) {
                         $n = Mandtl::find($mandtl['id']);
                         if (count($manday) > 0) {
                             $n->daytype = $mandtl['daytype'];
                             $n->timestart = $mandtl['timestart'];
                             $n->breakstart = $mandtl['breakstart'];
                             $n->breakend = $mandtl['breakend'];
                             $n->timeend = $mandtl['timeend'];
                             $n->workhrs = $mandtl['workhrs'];
                             $n->breakhrs = $mandtl['breakhrs'];
                             $n->loading = $mandtl['loading'];
                             $n->save();
                         } else {
                             \DB::rollback();
                             return 'no mandtl found!';
                         }
                     }
                 } catch (\Exception $e) {
                     \DB::rollback();
                     throw $e;
                 }
             } catch (\Exception $e) {
                 \DB::rollback();
                 throw $e;
             }
             \DB::commit();
             $manday->load('manskeddtls');
             return $manday;
             //return $request->input('manskeddtls');
         }
     }
     return redirect(URL::previous());
     //return ['iid' => $request->input('id'),  'rid'=>$id];
 }

 public function post(Request $request)
 {
     //
     $this->validate($request, ['date' => 'required|date|max:10', 'weekno' => 'required']);
     // check weekno if exist
     $mansked = Mansked::whereWeekno($request->input('weekno'))->get();
     if (count($mansked) > 0) {
         return redirect('/branch/mansked/add')->withErrors(['message' => 'Week ' . $request->input('weekno') . ' already created!'])->withInput();
     }
     //$mansked = array_shift($mansked);
     $mansked = new Mansked();
     //return $mansked->getRefno();
     $mansked->refno = $mansked->getRefno();
     $mansked->date = $request->input('date');
     $mansked->weekno = $request->input('weekno');
     $mansked->branchid = $request->input('branchid');
     $mansked->managerid = $request->input('managerid');
     $mansked->mancost = $request->input('mancost');
     $mansked->notes = $request->input('notes');
     $mansked->id = $mansked->get_uid();
     $mandays = [];
     foreach ($mansked->getDaysByWeekNo($request->input('weekno')) as $key => $date) {
         $manday = new Manday();
         $manday->date = $date;
         $manday->id = $manday->get_uid();
         array_push($mandays, $manday);
     }
     \DB::beginTransaction();
     //Start transaction!
     try {
         $mansked->save();
         try {
             $mansked->manskeddays()->saveMany($mandays);
         } catch (\Exception $e) {
             \DB::rollback();
             throw $e;
         }
     } catch (\Exception $e) {
         \DB::rollback();
         throw $e;
     }
     \DB::commit();
     //$mansked->id
     //return $id;
     //return dd($mansked);
     $mansked->load('manskeddays');
     foreach ($mansked->manskeddays as $manskedday) {
         foreach ($this->employees as $employee) {
             $mandtl = new Mandtl();
             $mandtl->employeeid = $employee->id;
             $mandtl->id = $mandtl->get_uid();
             $manskedday->manskeddtls()->save($mandtl);
         }
     }
     return $mansked;
 }

 public function copyMansked(Request $request)
 {
     $this->validate($request, ['lweekno' => 'required', 'nweekno' => 'required', 'year' => 'required', 'lmanskedid' => 'required']);
     $mansked1 = Mansked::whereWeekno($request->input('nweekno'))->where('year', $request->input('year'))->where('branchid', $request->user()->branchid)->get();
     if (count($mansked1) > 0) {
         return redirect('/task/mansked')->withErrors(['message' => 'Manpower Schedule Week ' . $request->input('nweekno') . ' already exist!'])->withInput();
     }
     $mansked = Mansked::find($request->input('lmanskedid'));
     if (count($mansked) <= 0) {
         return redirect('/task/mansked')->withErrors(['message' => 'Pointer Week ' . $request->input('lweekno') . ' not found!'])->withInput();
     }
     $mansked->load('manskeddays');
     $mandays = $mansked->manskeddays;
     foreach ($mandays as $manday) {
         $manday->load('manskeddtls');
     }
     $new_mansked = new Mansked();
     //return $mansked->getRefno();
     $new_mansked->refno = $new_mansked->getRefno();
     $new_mansked->date = $mansked->date->format('Y-m-d');
     $new_mansked->weekno = $request->input('nweekno');
     $new_mansked->year = $request->input('year');
     $new_mansked->branchid = $mansked->branchid;
     $new_mansked->managerid = $mansked->managerid;
     $new_mansked->mancost = $mansked->mancost;
     $new_mansked->notes = $mansked->notes;
     $new_mansked->id = $mansked->get_uid();
     \DB::beginTransaction();
     //Start transaction!
     $new_mandays = [];
     foreach ($new_mansked->getDaysByWeekNo($request->input('nweekno'), $request->input('year')) as $key => $date) {
         $new_manday = new Manday();
         $new_manday->date = $date->format('Y-m-d');
         $new_manday->custcount = $mandays[$key]->custcount;
         $new_manday->headspend = $mandays[$key]->headspend;
         $new_manday->empcount = $mandays[$key]->empcount;
         $new_manday->workhrs = $mandays[$key]->workhrs;
         $new_manday->breakhrs = $mandays[$key]->breakhrs;
         $new_manday->overload = $mandays[$key]->overload;
         $new_manday->underload = $mandays[$key]->underload;
         $new_manday->id = $new_manday->get_uid();
         $new_mandtls = [];
         foreach ($mandays[$key]->manskeddtls as $mandtl) {
             $new_mandtl = new Mandtl();
             $new_mandtl->employeeid = $mandtl->employeeid;
             $new_mandtl->daytype = $mandtl->daytype;
             $new_mandtl->timestart = $mandtl->timestart;
             $new_mandtl->breakstart = $mandtl->breakstart;
             $new_mandtl->breakend = $mandtl->breakend;
             $new_mandtl->timeend = $mandtl->timeend;
             $new_mandtl->workhrs = $mandtl->workhrs;
             $new_mandtl->breakhrs = $mandtl->breakhrs;
             $new_mandtl->loading = $mandtl->loading;
             $new_mandtl->id = $new_mandtl->get_uid();
             array_push($new_mandtls, $new_mandtl);
         }
         try {
             $new_manday->manskeddtls()->saveMany($new_mandtls);
         } catch (\Exception $e) {
             \DB::rollback();
             throw $e;
         }
         array_push($new_mandays, $new_manday);
     }
     try {
         $new_mansked->save();
         try {
             $new_mansked->manskeddays()->saveMany($new_mandays);
         } catch (\Exception $e) {
             \DB::rollback();
             throw $e;
         }
     } catch (\Exception $e) {
         \DB::rollback();
         throw $e;
     }
     \DB::commit();
     return redirect('/task/mansked')->with(['new' => true])->with('alert-success', 'Week ' . $request->input('lweekno') . ' successfully copied!');
     $new_mansked->load('manskeddays');
     $new_mandays = $new_mansked->manskeddays;
     foreach ($new_mandays as $new_manday) {
         $new_manday->load('manskeddtls');
     }
     return $new_mansked;
 }

 public function put(Request $request, $id)
 {
     //return $request->all();
     if (strtolower($request->input('id')) == strtolower($id)) {
         $manday = Manday::find($id);
         if (count($manday) > 0) {
             //\DB::beginTransaction();
             $manday->custcount = $request->input('custcount');
             $manday->headspend = $request->input('headspend');
             $manday->empcount = $request->input('empcount');
             $manday->workhrs = $request->input('workhrs');
             $manday->breakhrs = $request->input('breakhrs');
             $manday->overload = $request->input('overload');
             $manday->underload = $request->input('underload');
             \DB::beginTransaction();
             //Start transaction!
             try {
                 $manday->save();
                 try {
                     foreach ($request->input('manskeddtls') as $mandtl) {
                         $n = Mandtl::find($mandtl['id']);
                         if (count($n) > 0) {
                             //dd(count($n));
                             foreach ($mandtl as $key => $value) {
                                 if ($mandtl['timestart'] == 'off') {
                                     $n->breakstart = 'off';
                                     $n->breakend = 'off';
                                     $n->timeend = 'off';
                                 }
                                 $n->{$key} = $value;
                             }
                             $n->save();
                         } else {
                             //dd($mandtl);
                             $m = new Mandtl();
                             foreach ($mandtl as $key => $value) {
                                 if ($key == 'id') {
                                     $m->id = $m->get_uid();
                                 } else {
                                     $m->{$key} = $value;
                                 }
                             }
                             $m->mandayid = $request->input('id');
                             $m->save();
                             //\DB::rollback();
                             //return 'no mandtl found!';
                         }
                     }
                 } catch (\Exception $e) {
                     \DB::rollback();
                     throw $e;
                 }
             } catch (\Exception $e) {
                 \DB::rollback();
                 throw $e;
             }
             \DB::commit();
             //$manday->load('manskeddtls');
             //return $manday;
             //return $request->input('manskeddtls');
         }
     }
     return redirect('/task/manday/' . $manday->lid())->with('alert-success', 'Record saved!');
     //return ['iid' => $request->input('id'),  'rid'=>$id];
 }

 private function relateVn($parent_vn_id, $child_vn_id)
 {
     if (!empty($parent_vn_id) && !empty($child_vn_id)) {
         \DB::beginTransaction();
         try {
             $parent_relation = VnRelation::firstOrNew(['vn_id' => $parent_vn_id]);
             if (is_null($parent_relation->group_id)) {
                 $max_group_id = VnRelation::max('group_id') || 0;
                 if (!$max_group_id) {
                     $max_group_id++;
                 }
                 $parent_relation->group_id = $max_group_id;
             }
             $parent_relation->vn_id = $parent_vn_id;
             $exec_parent_relation = $parent_relation->save();
             $child_relation = VnRelation::firstOrNew(['vn_id' => $child_vn_id]);
             if (is_null($child_relation->group_id)) {
                 $child_relation->group_id = $parent_relation->group_id;
             }
             $child_relation->vn_id = $child_vn_id;
             $exec_child_relation = $child_relation->save();
         } catch (\Exception $e) {
             \DB::rollback();
             throw $e;
         }
         if ($exec_parent_relation && $exec_child_relation) {
             \DB::commit();
             return true;
         } else {
             \DB::rollback();
             throw new \Symfony\Component\HttpKernel\Exception\ConflictHttpException();
         }
     }
 }

 public function updateLinks(Request $request)
 {
     $updatelink = new UpdateLinkRequest();
     $validator = Validator::make($request->all(), $updatelink->rules(), $updatelink->messages());
     if ($validator->fails()) {
         return response()->json(['success' => false, 'errors' => $validator->errors()->toArray()], 400);
     }
     $userID = $request->user_id;
     $links = $request->links;
     \DB::beginTransaction();
     $link = User::find($userID)->links;
     for ($i = 0; $i < count($links); $i++) {
         $reflink = $link->find($links[$i]['id']);
         $reflink->link = $links[$i]['link'];
         $reflink->save();
         try {
             if (!$reflink) {
                 throw new \Exception('We Have Restricted You From Editing Others Link!');
             }
         } catch (\Exception $e) {
             \DB::rollback();
             $errors = ['ExceptionError' => $e->getMessage()];
             return response()->json(['success' => false, 'errors' => $errors], 400);
             // Failed Creation
         }
     }
     \DB::commit();
     return response()->json(['success' => true, 'message' => 'Link Have Been Renamed!'], 200);
 }

 public function postupdateig(Request $request)
 {
     if ($request->hasFile('file')) {
         $file_path = $request->file('file')->move(storage_path() . '/uploads/temp/', $request->file('file')->getClientOriginalName());
         \DB::beginTransaction();
         try {
             set_time_limit(0);
             $reader = ReaderFactory::create(Type::XLSX);
             // for XLSX files
             $reader->open($file_path);
             foreach ($reader->getSheetIterator() as $sheet) {
                 if ($sheet->getName() == 'Sheet1') {
                     $cnt = 0;
                     foreach ($sheet->getRowIterator() as $row) {
                         if ($cnt > 0) {
                             if (!empty($row[5])) {
                                 // dd($row);
                                 $updated_ig = UpdatedIg::where('store_code', $row[8])->where('sku_code', $row[13])->first();
                                 if (!empty($updated_ig)) {
                                     $updated_ig->ig = $row[23];
                                     $updated_ig->update();
                                 } else {
                                     // dd($row);
                                     UpdatedIg::firstOrCreate(['area' => $row[0], 'region_code' => $row[1], 'region' => $row[2], 'distributor_code' => $row[3], 'distributor' => $row[4], 'agency_code' => $row[5], 'agency' => $row[6], 'storeid' => $row[7], 'store_code' => $row[8], 'store_name' => $row[9], 'channel_code' => $row[10], 'channel' => $row[11], 'other_code' => $row[12], 'sku_code' => $row[13], 'description' => $row[14], 'division' => $row[15], 'category' => $row[16], 'sub_category' => $row[17], 'brand' => $row[18], 'conversion' => $row[19], 'min_stock' => $row[20], 'fso_multiplier' => $row[21], 'lpbt' => $row[22], 'ig' => $row[23]]);
                                 }
                                 $store = Store::where('store_code', $row[8])->first();
                                 if (!empty($store)) {
                                     $item = Item::where('sku_code', $row[13])->first();
                                     if (!empty($item)) {
                                         StoreItem::where('store_id', $store->id)->where('item_id', $item->id)->update(['ig' => $row[23]]);
                                     }
                                 }
                             }
                         }
                         $cnt++;
                     }
                 }
             }
             $hash = UpdateHash::find(1);
             if (empty($hash)) {
                 UpdateHash::create(['hash' => \Hash::make(date('Y-m-d H:i:s'))]);
             } else {
                 $hash->hash = md5(date('Y-m-d H:i:s'));
                 $hash->update();
             }
             \DB::commit();
             $reader->close();
         } catch (\Exception $e) {
             \DB::rollback();
             dd($e);
         }
         if (\File::exists($file_path)) {
             \File::delete($file_path);
         }
         Session::flash('flash_message', 'Updated IG successfully updated.');
         Session::flash('flash_class', 'alert-success');
     } else {
         Session::flash('flash_message', 'Error updating item IG.');
         Session::flash('flash_class', 'alert-danger');
     }
     return redirect()->route("item.updatedig");
 }