/** * Execute the console command. * * @return mixed */ public function handle() { $this->info("Clearing permissions... \n"); // Delete old data $response = Action::deleteAllData(); null !== $response ? $this->error("\n" . $response . "\n") : null; $this->info("Permissions cleared... \n"); try { $routeData = $this->getRouteData(); $roles = Role::all(); DB::beginTransaction(); foreach ($routeData as $action => $uri) { $action = new Action(['uri' => $uri, 'action' => $action]); $action->save(); $this->savePermissions($roles, $action); $this->comment("Added action " . $action->action . "\n"); } $cache = $this->getCacheInstance(['permissions']); $cache->flush(); DB::commit(); } catch (\Exception $e) { DB::rollBack(); $this->error("\n" . $e->getMessage() . "\n"); } }
public function update(Request $request, $id) { $departamento = $request->input('departamento'); if ($departamento != '0') { try { DB::beginTransaction(); $usuario = User::find($id); $empleado = $usuario->empleado; $empleado->nombre = Str::upper($request->input('nombre')); $empleado->apellido_paterno = Str::upper($request->input('apellido_paterno')); $empleado->apellido_materno = Str::upper($request->input('apellido_materno')); $empleado->save(); $usuario->username = Str::upper($request->input('username')); $usuario->password = bcrypt($request->input('password')); $usuario->rol_id = $request->input('departamento'); $usuario->save(); DB::commit(); return redirect()->route('usuario.index'); } catch (QueryException $e) { echo $e; DB::rollBack(); return redirect()->route('usuario.edit', $id); } } else { return redirect()->route('usuario.edit', $id); } }
public function clear(Request $request) { $post = $request->all(); $comment = $post['comment']; $value = $post['amount']; $student = $post['regNo']; $clearedAt = $post['signedAt']; $clearedBy = $post['signedBy']; $comment = preg_replace('/[^A-Za-z0-9 _]/', '', $comment); $value = preg_replace('/[^0-9]/', '', $value); DB::beginTransaction(); $submit = DB::update("UPDATE charge\n INNER JOIN comments ON charge.students_studentNo = comments.students_studentNo\n INNER JOIN cleared_at ON charge.students_studentNo = cleared_at.students_studentNo\n INNER JOIN cleared_by ON charge.students_studentNo = cleared_by.students_studentNo\n SET\n charge.cafeteria_value = '{$value}',\n charge.queueFlag = charge.queueFlag + 1,\n comments.cafeteria = '{$comment}',\n cleared_at.cafeteria_cleared_at = '{$clearedAt}',\n cleared_by.cafeteria_cleared_by = '{$clearedBy}'\n\n WHERE charge.students_studentNo = '{$student}'\n AND comments.students_studentNo = '{$student}'\n AND cleared_at.students_studentNo = '{$student}'\n AND cleared_by.students_studentNo='{$student}' "); if ($submit) { DB::commit(); } else { DB::rollBack(); } // $admin = DB::table('departments') // ->join('administrators','departments.administrator','=','administrators.admin_id') // ->select('administrators.email')->where('departments.department_name','=','Library') // ->pluck('email'); //Send Mail // Mail::send('mails.clear', ['student' => $student ], function($message) use($admin){ // $message->to($admin)->from('*****@*****.**', 'Strathmore University')->subject('Clearance'); // }); return redirect('/cafeteria'); }
/** * Handle the event. * * @param CurrencyMessageReceivedEvent * @return void */ public function handle(CurrencyMessageReceivedEvent $event) { $timePlaced = new \DateTime($event->message->time_placed); $rate = MonthlyRate::where('year', $timePlaced->format('Y'))->where('month', $timePlaced->format('m'))->where('currency_from', $event->message->getAttribute('currency_from'))->where('currency_to', $event->message->getAttribute('currency_to'))->get()->first(); if (is_null($rate)) { $rate = new MonthlyRate(); $rate->tot_messages = 1; $rate->currency_from = $event->message->getAttribute('currency_from'); $rate->currency_to = $event->message->getAttribute('currency_to'); $rate->sum_rate = $event->message->getAttribute('rate'); $rate->month = $timePlaced->format('m'); $rate->year = $timePlaced->format('Y'); } else { $rate->tot_messages++; $rate->sum_rate += $event->message->getAttribute('rate'); } DB::beginTransaction(); try { $rate->save(); $key = $rate->currency_from . '-' . $rate->currency_to; $message = [$key => ['rate' => $rate->avg_rate, 'month' => $rate->month]]; // Push message in redis to be displayed in the frontend $this->pushToSocket($message); DB::commit(); } catch (\ErrorException $e) { DB::rollBack(); // Throw the exception again to signal an error // in the processing throw $e; } catch (\Exception $e) { DB::rollBack(); throw $e; } }
/** * Creates an activity * * @param null|array $data * @return null|ActivityModel */ public function create($data = null) { DB::beginTransaction(); try { if (is_null($data)) { throw new NullDataException('The data array is required!'); } foreach ($data as $k => $v) { if (!in_array($k, $this->fields)) { throw new CreateActivityException('Please add the correct fields!'); } } if (count(array_keys($data)) != count($this->fields)) { throw new CreateActivityException('The number of given data is different than required!'); } $this->checkFields($data); $activity = ActivityModel::create($data); DB::commit(); return $activity; } catch (NullDataException $e) { DB::rollBack(); return $e; } catch (CreateActivityException $e) { DB::rollBack(); return $e; } }
public function saveTrackerEntry(Request $request) { // return $request->all(); $validator = Validator::make($request->all(), ['desc' => 'required|min:5', 'time' => 'required|numeric', 'tags' => 'required', 'project_id' => 'required']); if ($request->input('project_id') == 'Select Project') { Session::flash('flash_error', 'You need to select the project'); return redirect()->back()->withInput(); } if ($validator->fails()) { return redirect()->back()->withErrors($validator)->withInput(); } try { DB::beginTransaction(); $project = Project::with('client')->find($request->input('project_id')); $entry = TimeEntry::create(['desc' => $request->input('desc'), 'user_id' => Auth::user()->id, 'project_id' => $project->id, 'project_name' => $project->name, 'client_name' => $project->client->name, 'time' => $request->input('time')]); // adding the entry of the ticket with tags mapping table foreach ($request->input('tags') as $key => $value) { DB::table('taggables')->insert(['tag_id' => $value, 'taggable_id' => $entry->id, 'taggable_type' => 'ticket', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]); } if ($request->input('estimate_id')) { DB::table('time_entry_estimates')->insert(['time_entry_id' => $entry->id, 'estimate_id' => $request->input('estimate_id'), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]); DB::update("UPDATE estimates SET hours_consumed = hours_consumed + :hours WHERE id = :id", ['hours' => $request->input('time'), 'id' => $request->input('estimate_id')]); } DB::commit(); Session::flash('flash_message', 'Entry saved'); return redirect('time-tracker'); } catch (\PDOException $e) { DB::rollBack(); abort(403, 'Data was not saved. Try again' . $e->getMessage()); } }
/** * Creates a type * * @param null|array $data * @return null|TypeModel */ public function create($data = null) { DB::beginTransaction(); try { if (is_null($data)) { throw new NullDataException('The data array is required!'); } foreach ($data as $k => $v) { if (!in_array($k, $this->fields)) { throw new CreateTypeException('Please add the correct fields!'); } } if (count(array_keys($data)) != count($this->fields)) { throw new CreateTypeException('The number of given data is different than required!'); } if (TypeModel::whereName($data['name'])->first()) { throw new CreateTypeException('The type name already exists!'); } $type = TypeModel::create($data); DB::commit(); return $type; } catch (NullDataException $e) { DB::rollBack(); return $e; } catch (CreateTypeException $e) { DB::rollBack(); return $e; } }
/** * @param Request $request * @return array|\Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response */ public function uploadFile(Request $request) { try { try { DB::beginTransaction(); $file = 'file'; if ($request->has('filename')) { $file = $request->input('filename'); } $files = $request->file($file); if (!is_array($files)) { $files[] = $request->file($file); } foreach ($files as $f) { $extArr = explode("/", $f->getClientMimeType()); $mimeType = $f->getClientMimeType(); $fileSize = $f->getClientSize(); $originalFilename = $f->getClientOriginalName(); $type = 'local'; // check with the file extention if ($extArr) { $ext = $extArr[1]; } if (!$ext) { return false; } $fileName = uniqid() . "." . $ext; if (!file_exists($this->filePath)) { mkdir($this->filePath, 0777, true); } $f->move($this->filePath, $fileName); $filePath = $this->filePath . $fileName; // if the designation is s3. Upload if ($request->input('destination') == 's3') { $uploadPath = $request->input('path') . '/' . $fileName; $type = 's3'; $s3 = Storage::disk('s3'); $s3->put($uploadPath, file_get_contents($filePath), 'public'); unlink($filePath); $filePath = $this->s3Prefix . $uploadPath; } $file = File::create(['file_name' => $fileName, 'mime_type' => $mimeType, 'file_size' => $fileSize, 'file_path' => $filePath, 'client_file_name' => $originalFilename, 'type' => $type]); $responseArr[] = $file; } DB::commit(); return $responseArr; } catch (FileException $e) { return response($e->getMessage(), 500); } } catch (Exception $e) { DB::rollBack(); return response('There were some errors uploading files', 500); } }
/** * Run the request filter. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { DB::beginTransaction(); try { $response = $next($request); } catch (Exception $e) { DB::rollBack(); throw $e; } DB::commit(); EventStore::publishQueue(); return $response; }
/** * Delete all data in the table */ public static function deleteAllData() { self::all()->each(function ($action) { try { DB::beginTransaction(); $action->delete(); DB::commit(); return; } catch (Exception $e) { DB::rollBack(); return $e->getMessage(); } }); }
public function deleteAlbum($id) { DB::beginTransaction(); try { $albumImageTable = new AlbumImage(); $albumImageTable->deleteAlbumImages($id); $this->where("id", "=", $id)->delete(); DB::commit(); return 1; } catch (Exception $e) { print_r($e); DB::rollBack(); return 0; } }
/** * Register a user * * @param Registration $request * * @return mixed */ public function handleRegister(Registration $request) { DB::beginTransaction(); try { $user = User::create($request->all()); $user->assignRole(config('users.default')); auth()->login($user); event(new UserRegistered(auth()->user())); } catch (\Exception $exception) { DB::rollBack(); return redirect(route('auth.register'))->with('errors', $exception->getMessage()); } DB::commit(); return redirect(route('home'))->with('message', 'Your account has been created.'); }
public function store(Request $request, $id) { $compra = Compra::find($id); $saldo = []; foreach ($compra->compra_itens as $key => $it) { if ($it->quantidade > $request->item[$key]['quantidade']) { $saldo[$key]['produto_id'] = $it->produto_id; $saldo[$key]['preco_compra'] = $it->preco_compra; $saldo[$key]['quantidade'] = $it->quantidade - $request->item[$key]['quantidade']; } } $new_compra = new Compra(); if (count($saldo) > 0) { $new_compra->fornecedor_id = $compra->fornecedor_id; $new_compra->user_id = Auth::user()->id; $new_compra->data_compra = date('d/m/Y'); $new_compra->save(); foreach ($saldo as $s) { $it = new CompraItem(); $it->compra_id = $new_compra->id; $it->produto_id = $s['produto_id']; $it->quantidade = $s['quantidade']; $it->save(); } } DB::beginTransaction(); try { foreach ($request->item as $item) { $p = Produto::find($item['produto_id']); $p->estoque += $item['quantidade']; $p->save(); } $compra->status = 2; $compra->save(); DB::commit(); } catch (\Exception $e) { DB::rollBack(); throw $e; } if ($this->reenviaEmail($new_compra)) { flash()->success('Confirmação de compra efetuada com sucesso e e-mail com itens que faltaram reenviado para o fornecedor'); } else { flash()->success('Confirmação de compra efetuada com sucesso, mas email não foi enviado, envie o mesmo manualmente.'); } return redirect()->route('compras.index'); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { // DB::transaction(function(){ try { DB::beginTransaction(); $comprobante_compra = $request->get('comprobante_compra'); $comprobante_servicio = $request->get('comprobante_servicio'); // dd($comprobante_servicio); foreach ($comprobante_compra as $key1 => $value1) { $asociar = new AsociarComprobante(); $asociar->id_comprobanteVenta = $value1['id_comprobanteVenta']; $asociar->id_comprobanteCompra = $value1['id_comprobanteCompra']; $asociar->id_producto = $value1['id_producto']; $asociar->precio_compra = $value1['precio_compra']; $asociar->cantidad_compra = $value1['cantidad_compra']; $asociar->precio_venta = $value1['precio_venta']; $asociar->cantidad_venta = $value1['cantidad_venta']; $asociar->save(); $id_cabecera = $asociar->id; $compra = ComprobanteDetalleCompra::find($value1['id_comprobanteDetalleCompra']); $compra->indicador_asociado = 'false'; $compra->save(); foreach ($comprobante_servicio as $key2 => $value2) { if ($value1['id_producto'] == $value2['id_producto']) { $AsociarComprobante = AsociarComprobante::find($id_cabecera); $AsociarComprobante->id_comprobanteServicio = $value2['id_comprobanteServicio']; $AsociarComprobante->precio_servicio = $value2['precio_servicio']; $AsociarComprobante->cantidad_servicio = $value2['cantidad_servicio']; $AsociarComprobante->save(); $servicio = ComprobanteDetalleServicio::find($value2['id_comprobanteDetalleServicio']); $servicio->indicador_asociado = 'false'; $servicio->save(); } } } DB::commit(); return \Response::json(array('datos' => 'correcto')); } catch (Exception $e) { DB::rollBack(); } }
public function store(Request $request) { $destino = $request->input('destino'); $ruta_id = $request->input('ruta'); if ($ruta_id > 0) { try { DB::beginTransaction(); $nuevodestino = new Destino(); $nuevodestino->destino = $destino; $nuevodestino->ruta_id = $ruta_id; $nuevodestino->save(); DB::commit(); return redirect()->route('destino.index'); } catch (QueryException $ex) { DB::rollBack(); return redirect()->route('destino.create'); } } else { return redirect()->route('destino.create'); } }
public function saveUser(Request $request) { $validator = Validator::make($request->all(), ['name' => 'required|min:5', 'email' => 'required|unique:users,email', 'dob' => 'required', 'employee_id' => 'required', 'joining_date' => 'required', 'role' => 'required', 'password' => 'required|min:5']); if ($validator->fails()) { return redirect()->back()->withErrors($validator)->withInput(); } try { DB::beginTransaction(); $user = User::create(['name' => $request->input('name'), 'email' => $request->input('email'), 'dob' => $request->input('dob'), 'employee_id' => $request->input('employee_id'), 'joining_date' => $request->input('joining_date'), 'password' => Hash::make($request->input('password'))]); foreach ($request->input('role') as $roleId) { DB::table('roles_users')->insert(['user_id' => $user->id, 'role_id' => $roleId, 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]); } Session::flash('flash_message', 'User was created'); DB::commit(); } catch (\PDOException $e) { DB::rollBack(); Session::flash('flash_error', 'User was not created'); \Log::info(print_r($e->getMessage(), 1)); return redirect()->back()->withErrors($validator)->withInput(); } return redirect()->back(); }
public function updateData($data, $floor, $status, $id) { DB::beginTransaction(); try { $data['updated_at'] = date("Y-m-d H:i:s"); $res = $this->where("id", "=", $id)->update($data); if (count($floor) > 0) { $projectFloorPlansTable = new ProjectFloorPlans(); $projectFloorPlansTable->insertData($floor, $id); } if (count($status) > 0) { $projectStatusTable = new ProjectStatus(); $projectStatusTable->insertData($status, $id); } DB::commit(); return 1; } catch (Exception $e) { print_r($e); DB::rollBack(); return 0; } }
public function deleteUser(Request $request, Response $response) { $validator = Validator::make($request->all(), ['id' => 'required|numeric']); if ($validator->fails()) { $response->header(Constants::RESPONSE_HEADER, "\"id\" query parameter is required and must contain number as value."); $response->setStatusCode(Response::HTTP_UNPROCESSABLE_ENTITY); return $response; } DB::beginTransaction(); $userId = $request->input("id"); $isUserDeleted = User::find($userId)->delete(); if ($isUserDeleted === false) { DB::rollBack(); $response->header(Constants::RESPONSE_HEADER, "Failed to delete user."); $response->setStatusCode(Response::HTTP_INTERNAL_SERVER_ERROR); return $response; } DB::commit(); $response->header("Content-Type", "application/json"); $response->header(Constants::RESPONSE_HEADER, "Successfully deleted user."); $response->setStatusCode(201); return $response; }
/** * Stores resources in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { Log::debug("STORE CALLED .. ENV:" . env('APP_ENV') . " TOKEN:" . env('PIPEDRVIE_API_TOKEN')); //starting transaction for DB queries, if one of organizations fails, I will roll it back DB::beginTransaction(); //saving to our DB in recursion loop (creating all daughters) $result = $this->saveOrganization($request->all()); if (is_a($result, 'App\\Organization')) { //since I won't be able to roll back requests to pipedrive api, I use separate method to save data to pipedrive //at least at this point I am sure that all data passed all internal validation and stored in our DB if ($this->saveOrganizationToPipedrive($request->all())) { $success = true; DB::commit(); } else { $success = false; DB::rollBack(); } } else { $success = false; DB::rollBack(); } return Response::json(compact('result', 'success')); }
/** * Obsluga formularza rejestracji uzytkownika * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function signup(Request $request) { $this->validate($request, ['name' => 'required|min:2|max:28|username|unique:users', 'email' => 'required|email|max:255|unique:users', 'password' => 'required|confirmed|min:3', 'human' => 'required']); DB::beginTransaction(); try { $email = $request->input('email'); $user = User::create(['name' => $request->input('name'), 'email' => $email, 'password' => bcrypt($request->input('password'))]); $actkey = Actkey::create(['actkey' => str_random(), 'user_id' => $user->id]); // taki format linku zachowany jest ze wzgledu na wsteczna kompatybilnosc. // z czasem mozemy zmienic ten format aby wskazywal na /User/Confirm/Email/<id>/<actkey> $url = route('user.email') . '?id=' . $user->id . '&actkey=' . $actkey->actkey; Mail::queue('emails.signup', ['url' => $url], function ($message) use($email) { $message->to($email); $message->subject('Dziękujemy za rejestrację. Potwierdź autentyczność swojego adresu e-mail'); }); Auth::login($user, true); stream(Stream_Create::class, new Stream_Person()); DB::commit(); } catch (\Exception $e) { DB::rollBack(); throw $e; } return redirect()->intended(route('home')); }
/** * Load records from file. * * @return Response */ public function loadRecords(Request $request) { $validator = Validator::make($request->all(), ['file' => 'required'], ['required' => 'No file provided']); if ($validator->fails()) { return redirect()->back()->withInput()->withErrors($validator); } else { $contents = file($request->file('file')->getRealPath()); try { DB::beginTransaction(); $properties = ['full_name', 'email', 'text']; foreach ($contents as $lineNumber => $line) { $gbr = new GuestBookRecord(array_combine($properties, explode(';', $line))); $gbr->save(); } DB::commit(); return redirect()->back(); } catch (\Exception $e) { DB::rollBack(); $message = 'Invalid data provided at line ' . ($lineNumber + 1) . " ('{$line}')"; $messageBag = new MessageBag(['content' => $message]); return redirect()->back()->withErrors($messageBag); } } }
/** * Store the message received from the api call * POST /messages * @return Response */ public function store(Request $request) { if ($request->isJson()) { $input = $this->formatInput($request->all()); $validator = $this->getValidationFactory()->make($input, ['userId' => 'required', 'currencyFrom' => 'required', 'currencyTo' => 'required', 'amountSell' => 'required', 'amountBuy' => 'required', 'rate' => 'required', 'timePlaced' => 'required', 'originatingCountry' => 'required']); if ($validator->fails()) { $response = response()->json($validator->errors()->getMessages(), 400); } else { DB::beginTransaction(); try { $message = new CurrencyMessage(); $request = (object) $input; $message->user_id = $request->userId; $message->currency_from = $request->currencyFrom; $message->currency_to = $request->currencyTo; $message->amount_sell = $request->amountSell; $message->amount_buy = $request->amountBuy; $message->rate = $request->rate; $message->country_origin = $request->originatingCountry; $message->time_placed = $request->timePlaced; // Save all the messages, in case something is wrong and the // statistics need to be recalculated $message->save(); Event::fire(new CurrencyMessageReceived($message)); $response = response()->make(null, 201); DB::commit(); } catch (\Exception $e) { DB::rollBack(); $response = response()->make($e->getMessage(), 500); } } return $response; } else { throw new BadRequestHttpException('This method accepts json requests.'); } }
public function addUserTags() { $request = Request::capture(); $token = $request->input('token'); $tags = $request->input('tags'); if ($tags == null) { return Utility::response_format(Utility::RESPONSE_CODE_Error, '', '标签不能为空'); } $userId = AuthController::getUserIdByToken($token); if ($userId == null) { return Utility::response_format(Utility::RESPONSE_CODE_AUTH_ERROR, '', '认证失败'); } DB::beginTransaction(); try { $array = explode(',', $tags); $result = UserTags::where('user_id', $userId)->delete(); foreach ($array as $tag) { $result = UserTags::create(['user_id' => $userId, 'tag_id' => $tag]); } DB::commit(); return Utility::response_format(Utility::RESPONSE_CODE_SUCCESS, '', '添加成功'); } catch (Exception $e) { DB::rollBack(); return Utility::response_format(Utility::RESPONSE_CODE_DB_ERROR, '', $e->getMessage()); } }
public function saveTicketConversation(Request $request) { $ticketId = $request->input('ticketId'); $comment = $request->input('comment'); try { DB::beginTransaction(); $comment = new Comment(); $comment->comment = $request->input('comment'); $comment->user_id = Auth::user()->id; $comment->parent_id = 0; $comment->status = 1; $comment->save(); DB::table('commentables')->insert(['comment_id' => $comment->id, 'commentable_id' => $ticketId, 'commentable_type' => 'App\\Ticket']); $attachments = $request->input('attachments'); if ($attachments) { foreach ($attachments as $key => $attachment) { $attachmentInsert[] = ['file_id' => $attachment['id'], 'fileable_id' => $comment->id, 'fileable_type' => 'App\\Comment']; } DB::table('fileables')->insert($attachmentInsert); } DB::commit(); return response(['data' => $this->getCommentsData($ticketId)], 200); } catch (\PDOException $e) { DB::rollBack(); } }
public function publishAnswer() { $request = Request::capture(); $token = $request->input('token'); $content = $request->input('content'); $questionId = $request->input('questionId'); $brief = $request->input('brief'); $pictures = $request->input('picids'); if ($content == null) { return Utility::response_format(Utility::RESPONSE_CODE_Error, '', '内容不能为空'); } $userId = AuthController::getUserIdByToken($token); if ($userId == null) { return Utility::response_format(Utility::RESPONSE_CODE_AUTH_ERROR, '', '认证失败'); } DB::beginTransaction(); try { $answer = Answer::create(['answer_content' => $content, 'answer_brief' => $brief, 'user_id' => $userId, 'question_id' => $questionId, 'answer_time' => time()]); if ($pictures != null) { $picArray = explode(',', $pictures); foreach ($picArray as $pic) { AnswerPictures::create(['answer_id' => $answer->id, 'pic_id' => $pic]); } } DB::commit(); return Utility::response_format(Utility::RESPONSE_CODE_SUCCESS, '', '发布成功'); } catch (Exception $e) { DB::rollBack(); return Utility::response_format(Utility::RESPONSE_CODE_DB_ERROR, '', $e->getMessage()); } }
/** * Performs the actual processing */ protected function doProcessing() { $this->prepareProcessContext(); // initialization process pipeline $initSteps = $this->initProcessSteps(); if (!empty($initSteps)) { $this->context = app(Pipeline::class)->send($this->context)->through($initSteps)->then(function (ProcessContextInterface $context) { return $context; }); $this->afterInitSteps(); } // main pipeline (actual processing) $steps = $this->processSteps(); if ($this->databaseTransaction) { DB::beginTransaction(); } try { $this->context = app(Pipeline::class)->send($this->context)->through($steps)->then(function (ProcessContextInterface $context) { if ($this->databaseTransaction) { DB::commit(); } return $context; }); } catch (Exception $e) { if ($this->databaseTransaction) { DB::rollBack(); } $this->onExceptionInPipeline($e); throw $e; } $this->afterPipeline(); $this->populateResult(); }
/** * @param Request $request * @return $this|\Illuminate\Http\RedirectResponse */ public function loadFromFile(Request $request) { $validator = Validator::make($request->all(), ['file' => 'required'], ['required' => 'No file provided']); if ($validator->fails()) { return redirect()->back()->withErrors($validator); } else { $contents = file($request->file('file')->getRealPath()); try { DB::beginTransaction(); foreach ($contents as $lineNumber => $line) { $record = array_combine(['subject', 'text', 'created_at'], str_getcsv($line)); $recordsValidator = Validator::make($record, BlogRecordRequest::getValidationRules()); if ($recordsValidator->fails()) { throw new \Exception(); } else { $br = new BlogRecord($record); $br->save(); } } DB::commit(); return redirect()->back(); } catch (\Exception $e) { DB::rollBack(); return redirect()->back()->withErrors(new MessageBag(['Line number' => $lineNumber])); } } }
public function postVendorRegister(Request $request) { try { $validator = $this->validator($request->all()); if ($validator->fails()) { $this->throwValidationException($request, $validator); } DB::beginTransaction(); // Create User first $user = $this->create($request->all(), config('app.role_vendor')); // Now validate / create vendor profile $data = $request->all(); $vendorValidator = $this->vendorValidator($data); if ($vendorValidator->fails()) { $this->throwValidationException($request, $vendorValidator); } // Attempt to upload the images $uploader = new UploadHandler(); if ($request->hasFile('logo_image_path') && $request->file('logo_image_path')->isValid() && $uploader->isImage($request->file('logo_image_path'))) { $newFilename = $uploader->uploadVendorAsset($request->file('logo_image_path')); $data['logo_image_path'] = $newFilename; } if ($request->hasFile('background_image_path') && $request->file('background_image_path')->isValid() && $uploader->isImage($request->file('background_image_path'))) { $newFilename = $uploader->uploadVendorAsset($request->file('background_image_path')); $data['background_image_path'] = $newFilename; } $vendor = $this->createVendor($user->id, $data); DB::commit(); \Auth::login($user); } catch (\Exception $ex) { DB::rollBack(); throw $ex; } // Send an email to us to notify of new vendor registration try { $mailData = ['to' => config('app.vendor_registration_notify_email'), 'from' => $user->email, 'subject' => 'Vendor ' . $user->email . ' has registered', 'body' => 'Vendor sign up: Email:' . $user->email . ', Company Name: ' . $vendor->company_name, 'sendRaw' => true]; $this->dispatch(new SendEmail($mailData)); } catch (\Exception $ex) { // If email fails do not stop registration from happening } return redirect($this->redirectPath()); }
public function update(Request $request) { $articleResult = Articles::find($request->input('id')); if (!$articleResult) { return redirect('backend/articles'); } $request->request->set('published_at', Carbon\Carbon::now()); $this->validate($request, ['title' => 'required', 'content' => 'required', 'published_at' => 'required', 'tags' => 'required']); $input = $request->all(); $articleResult->update($input); $raw_tags = array(); //文章没有修改前的标签 foreach ($articleResult->tags as $raw_v) { $raw_tags[] = $raw_v->tag_name; } $new_tags = explode(',', ltrim(rtrim(trim($input['tags']), ','), ',')); $new_tags = array_unique(array_map('trim', $new_tags)); //修改后的标签 $tags_inserts = array_diff($new_tags, $raw_tags); //需要和文章新增关系标签 $tags_deletes = array_diff($raw_tags, $new_tags); //需要和文章去除关系的标签 // dd($tags_deletes); DB::beginTransaction(); try { if (isset($tags_inserts) && count($tags_inserts)) { foreach ($tags_inserts as $tags_insert) { if ($tags_insert) { $tag_res = Tags::where('tag_name', $tags_insert)->first(); if (!$tag_res) { $articleResult->tags()->saveMany(new Tags(['tag_name' => $tags_insert, 'use_nums' => 1])); } else { $tag_res->use_nums++; $tag_res->save(); $tag_res->articles()->attach($articleResult->id); } } } } unset($tag_res); if (isset($tags_deletes) && count($tags_deletes)) { foreach ($tags_deletes as $tags_delete) { if ($tags_delete) { $tag_res = Tags::where('tag_name', $tags_delete)->first(); if ($tag_res) { $tag_res->use_nums--; $tag_res->save(); $tag_res->articles()->detach($articleResult->id); } } } } DB::commit(); } catch (\Exception $e) { DB::rollBack(); dd($e->getMessage()); } return redirect('backend/articles'); }
public function checkUserProfileViews($userDetails) { $instagramScrape = new API\InstagramAPI\Instagram_scrape(); // $objInstagramAPI = new API\InstagramAPI\Instagram(); $instagramUserModel = new Instagram_User(); $objUsermetaModel = new Usersmeta(); $objOrderModel = new Order(); $whereIn = implode(',', array_unique(array_map(function ($v) { return $v->ins_user_id; }, $userDetails))); $insUserStatus = $instagramUserModel->updateUserDetails(['rawQuery' => 'ins_user_id IN(' . $whereIn . ')'], ['cronjob_status' => 0]); //replace with 1 if (!Session::has('FE_in_checkUserProfile')) { //FE=Fatal_Error $fataErrorData['whereIn'] = $whereIn; $fataErrorData['modalObject'] = $instagramUserModel; $fataErrorData['functionName'] = 'updateUserDetails'; $fataErrorData['params'] = 'ins_user_id'; Session::put('FE_in_checkUserProfile', $fataErrorData); } try { $id = 1; foreach ($userDetails as $user) { $username = $user->ins_username; print_r($id . ' . '); print_r($username); echo "<br>"; ++$id; $username = $user->ins_username; $picsFetchCount = intval($user->pics_fetch_count); // $picsDone = intval($user->pics_done); $picLimit = intval($user->pics_limit); $dailyPostLimit = intval($user->daily_post_limit); $dailyPostDone = intval($user->daily_post_done); $lastPostCreatedTime = intval($user->last_post_created_time); $firstPost_deliveryTime_day = intval($user->firstpost_delivery_daytime); $orderDelay = intval($user->order_delay_flag); $endDateTime = intval($user->end_date_time); $whereInsUser = ['rawQuery' => 'ins_user_id=?', 'bindParams' => [$user->ins_user_id]]; // code for reset daily limit every 24 hr. If daily limit cross then stop autolikes script for next 24 hrs. // Daily limit will be automatically reset every 24 hours from the time the user make the first post if (intval($user->ig_user_status) == 2 || intval($user->ig_user_status) == 3) { if ($firstPost_deliveryTime_day != 0) { if (time() - $firstPost_deliveryTime_day >= 86400) { //24 hr = 86400 seconds $updatedData23 = ['last_post_created_time' => time(), 'firstpost_delivery_daytime' => time(), 'daily_post_done' => 0, 'ig_user_status' => 2, 'cronjob_status' => 0, 'message' => 'The script is waiting for new post. Searching new post in every 5 minutes!']; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData23); } } else { if (intval($user->ig_user_status) == 3) { $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['cronjob_status' => 0]); } } } // This script will run when autolikes script was stopped due to in-sufficient balance, // This code will automatically reset autolikes running script when user add balance in account. if (intval($user->ig_user_status) == 3) { if ($user->last_order_total_price != 0) { $accountBalanceDetails = $objUsermetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], ['account_bal']); $accountBalance = $accountBalanceDetails->account_bal; if ($accountBalance >= $user->last_order_total_price) { $updatedData3 = ['ig_user_status' => 2, 'cronjob_status' => 0, 'message' => 'The script is waiting for new post. Searching new post in every 5 minutes!']; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData3); } } else { $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['cronjob_status' => 0]); } } $expiredFlag = false; if ($endDateTime != 0 && $endDateTime < time()) { if ($user->ig_user_status != 4) { $updatedData = ['ig_user_status' => 4, 'cronjob_status' => 0, 'message' => 'This profile #' . $username . ' has expired. If you wish to continue, increase the end date in edit option. ']; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData); } else { $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['cronjob_status' => 0]); } $expiredFlag = true; } else { if ($user->ig_user_status == 4) { $updatedData = ['ig_user_status' => 2, 'cronjob_status' => 0, 'message' => 'The script is waiting for new post. Searching new post in every 5 minutes!']; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData); } } if (!$expiredFlag) { if (intval($user->ig_user_status) == 2) { if ($lastPostCreatedTime == 0) { $lastPostCreatedTime = time(); $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['last_post_created_time' => time()]); } if ($dailyPostLimit > 0) { if ($picsFetchCount < $picLimit) { if ($dailyPostDone < $dailyPostLimit) { //scrap all the latest post created after the last post created time $userDetails = []; // if (intval($user->plan_type) == 0) {// for likes //// print_r($username); echo"<br>"; // $username = strtolower($username); //// $userDetails = $objInstagramAPI->UserDetailsByUsernameWithLastPostCreatedTime($username, $user->last_post_created_time); // $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, 'image'); // //// $userProfileData = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, $dailyPostLimit, 'image'); // } else if (intval($user->plan_type) == 4) { // for video $username = strtolower($username); $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, 'video'); // $userProfileData = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, $dailyPostLimit, 'video'); // } // dd($userProfileData); if ($userDetails != null) { // && $userDetails != "Username does not exist" && $userDetails != "user is private" $latestPostCreatedTime = 0; $latestPostCreatedTimeFlag = false; $latestDeliveryLink = ''; $startTime = time(); $userDetails = array_reverse($userDetails, true); foreach ($userDetails as $key => $value) { $startTime = time(); $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime; //600= 10 minutes delay in next order // get the latest post link and place that link for autolikes order if ($dailyPostDone < $dailyPostLimit && $picsFetchCount < $picLimit) { //add order in order table and then in order-process table // This code is for placing autolikes order only (likes orders) // check if auto comment is set or not $autoCommentsPrice = 0; $autoCommentsData = array(); if ($user->autoComments == "YES") { $autoCommentsPrice = $user->price_for_autoComments / 1000 * $user->comments_amount; $autoCommentsData['plan_id'] = $user->plan_id_for_autoComments; $autoCommentsData['by_user_id'] = $user->by_user_id; $autoCommentsData['for_user_id'] = $user->ins_user_id; $autoCommentsData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/"; $autoCommentsData['quantity_total'] = $user->comments_amount; $autoCommentsData['comment_id'] = $user->custom_comment_id; $autoCommentsData['start_time'] = $startTime; $autoCommentsData['added_time'] = time(); $autoCommentsData['updated_time'] = time(); $autoCommentsData['auto_order_status'] = 1; // 1=autolikes order $autoCommentsData['status'] = 0; // order is in pending state $autoCommentsData['price'] = $autoCommentsPrice; $autoCommentsData['orders_per_run'] = 0; $autoCommentsData['time_interval'] = 0; $autoCommentsData['url_type'] = 0; // 0=postLink $autoCommentsData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!'; // 0=postLink } $autoLikesPrice = $user->charge_per_unit / 1000 * $user->likes_per_pic; $accountBalanceDetails = $objUsermetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], ['account_bal']); $accountBalance = $accountBalanceDetails->account_bal; $totalPrice = $autoLikesPrice + $autoCommentsPrice; if ($accountBalance >= $totalPrice) { $autoLikesData['plan_id'] = $user->plan_id; $autoLikesData['by_user_id'] = $user->by_user_id; $autoLikesData['for_user_id'] = $user->ins_user_id; //code added and modified by Saurabh $autoLikesData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/"; $autoLikesData['initial_likes_count'] = $value['likes_count']; $autoLikesData['initial_followers_count'] = $value['followers_count']; $autoLikesData['initial_comments_count'] = $value['comments_count']; $autoLikesData['initial_views_count'] = $value['views_count']; $autoLikesData['quantity_total'] = $user->likes_per_pic; $autoLikesData['start_time'] = $startTime; $autoLikesData['added_time'] = time(); $autoLikesData['updated_time'] = time(); $autoLikesData['auto_order_status'] = 1; // 1=autolikes order $autoLikesData['status'] = 0; // order is in pending state $autoLikesData['price'] = $autoLikesPrice; $autoLikesData['orders_per_run'] = 0; $autoLikesData['time_interval'] = 0; $autoLikesData['url_type'] = 0; // 0=postLink $autoLikesData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!'; // 0=postLink $rollback = false; DB::beginTransaction(); DB::table('usersmeta')->where('user_id', '=', $user->by_user_id)->lockForUpdate()->get(); $autoLikesOrderInsertedStatus = $objOrderModel->insertOrder($autoLikesData); $autoCommentsOrderInsertedStatus = 1; if ($user->autoComments == "YES") { $autoCommentsOrderInsertedStatus = $objOrderModel->insertOrder($autoCommentsData); } if ($autoLikesOrderInsertedStatus && $autoCommentsOrderInsertedStatus) { $current_bal['account_bal'] = $accountBalance - $totalPrice; $orderUpdateBalanceStatus = $objUsermetaModel->updateUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], $current_bal); if ($orderUpdateBalanceStatus) { DB::commit(); } else { $rollback = true; DB::rollBack(); } } else { $rollback = true; DB::rollBack(); } if (!$rollback) { //this code runs only when user make the first post (first order is placed). if ($firstPost_deliveryTime_day == 0) { $data4['firstpost_delivery_daytime'] = time(); $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data4); } ++$picsFetchCount; ++$dailyPostDone; $latestPostCreatedTime = $value['created_time']; $latestDeliveryLink = "https://www.instagram.com/p/" . $value['link'] . "/"; $latestPostCreatedTimeFlag = true; //modified by saurabh $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime; // for adding 10 MORE minutes delay in next order // if flag is not set than order will place at instant // $startTime += 600;//600= 10 minutes delay in next order placing } } else { $data5 = ['cronjob_status' => 0, 'ig_user_status' => 3, 'last_order_total_price' => $totalPrice, 'message' => 'Autolikes script has been stopped for # ' . $user->ins_username . ' due to insufficient balance.']; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data5); break; } } } //End of inner foreach loop // Update details in instagram_users table if ($latestPostCreatedTimeFlag) { $data6['pics_fetch_count'] = $picsFetchCount; $data6['daily_post_done'] = $dailyPostDone; $data6['last_post_created_time'] = $latestPostCreatedTime; $data6['last_delivery_link'] = $latestDeliveryLink; // print_r($data6); $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data6); } } } } } else { if ($dailyPostLimit == 0) { if ($picsFetchCount < $picLimit) { //scrap all the latest post created after the first post created time $userDetails = []; // if ($user->plan_type == 0) {// for likes //// $objInstagramAPI = new API\InstagramAPI\Instagram(); //// print_r($username); echo "<br>"; // $username = strtolower($username); //// $userDetails = $objInstagramAPI->UserDetailsByUsernameWithLastPostCreatedTime($username, $user->last_post_created_time); // $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, "image"); //// dd($userDetails); //// $userProfileData = (isset($userDetails['instagramUsersData'])) ? $userDetails['instagramUsersData'] : ''; // // //// $userDetails = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, 0, 'image'); //// dd($userDetails['instagramUsersData']); // } else if ($user->plan_type == 4) { // for video $username = strtolower($username); $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, "video"); // $userDetails = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, 0, 'video'); // } if ($userDetails != null) { // && $userDetails != "Username does not exist" && $userDetails != "user is private" $latestPostCreatedTime = 0; $latestDeliveryLink = ''; $latestPostCreatedTimeFlag = false; $startTime = time(); $userDetails = array_reverse($userDetails, true); foreach ($userDetails as $key => $value) { $startTime = time(); $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime; //600= 10 minutes delay in next order // get the latest post link and place that link for autolikes order if ($picsFetchCount < $picLimit) { //add order in order table and then in order-process table // This code is for placing autolikes order only (likes orders) $autoCommentsPrice = 0; $autoCommentsData = array(); if ($user->autoComments == "YES") { $autoCommentsPrice = $user->price_for_autoComments / 1000 * $user->comments_amount; $autoCommentsData['plan_id'] = $user->plan_id_for_autoComments; $autoCommentsData['by_user_id'] = $user->by_user_id; $autoCommentsData['for_user_id'] = $user->ins_user_id; $autoCommentsData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/"; $autoCommentsData['quantity_total'] = $user->comments_amount; $autoCommentsData['comment_id'] = $user->custom_comment_id; $autoCommentsData['start_time'] = $startTime; $autoCommentsData['added_time'] = time(); $autoCommentsData['updated_time'] = time(); $autoCommentsData['auto_order_status'] = 1; // 1=autolikes order $autoCommentsData['status'] = 0; // order is in pending state $autoCommentsData['price'] = $autoCommentsPrice; $autoCommentsData['orders_per_run'] = 0; $autoCommentsData['time_interval'] = 0; $autoCommentsData['url_type'] = 0; // 0=postLink $autoCommentsData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!'; // 0=postLink } $autoLikesOrViewsPrice = $user->charge_per_unit / 1000 * $user->likes_per_pic; //likes_per_pic is same as views per pic $accountBalanceDetails = $objUsermetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], ['account_bal']); $accountBalance = $accountBalanceDetails->account_bal; $totalPrice = $autoLikesOrViewsPrice + $autoCommentsPrice; if ($accountBalance >= $totalPrice) { $autoLikesOrViewsData['plan_id'] = $user->plan_id; $autoLikesOrViewsData['by_user_id'] = $user->by_user_id; $autoLikesOrViewsData['for_user_id'] = $user->ins_user_id; $autoLikesOrViewsData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/"; $autoLikesOrViewsData['initial_likes_count'] = $value['likes_count']; $autoLikesOrViewsData['initial_followers_count'] = $value['followers_count']; $autoLikesOrViewsData['initial_comments_count'] = $value['comments_count']; $autoLikesOrViewsData['initial_views_count'] = $value['views_count']; $autoLikesOrViewsData['quantity_total'] = $user->likes_per_pic; //likes_per_pic is same as views per pic $autoLikesOrViewsData['start_time'] = $startTime; $autoLikesOrViewsData['added_time'] = time(); $autoLikesOrViewsData['updated_time'] = time(); $autoLikesOrViewsData['auto_order_status'] = 1; // 1=autolikes order $autoLikesOrViewsData['status'] = 0; // order is in pending state $autoLikesOrViewsData['price'] = $autoLikesOrViewsPrice; $autoLikesOrViewsData['orders_per_run'] = 0; $autoLikesOrViewsData['time_interval'] = 0; $autoLikesOrViewsData['url_type'] = 0; // 0=postLink $autoLikesOrViewsData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!'; $rollback = false; DB::beginTransaction(); DB::table('usersmeta')->where('user_id', '=', $user->by_user_id)->lockForUpdate()->get(); $orderInsertedStatus = $objOrderModel->insertOrder($autoLikesOrViewsData); $commentsOrderInsertedStatus = 1; if ($user->autoComments == "YES") { $commentsOrderInsertedStatus = $objOrderModel->insertOrder($autoCommentsData); } if ($orderInsertedStatus && $commentsOrderInsertedStatus) { $current_bal['account_bal'] = $accountBalance - $totalPrice; $orderUpdateBalanceStatus = $objUsermetaModel->updateUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], $current_bal); if ($orderUpdateBalanceStatus) { DB::commit(); } else { $rollback = true; DB::rollBack(); } } else { $rollback = true; DB::rollBack(); } if (!$rollback) { // // Update details in instagram_users table // $whereInsUser = ['rawQuery' => 'ins_user_id=?', 'bindParams' => [$user->ins_user_id]]; // $updateInsUserData = [ // 'pics_fetch_count' => ++$picsFetchCount, // 'daily_post_done' => ++$dailyPostDone, // 'cronjob_status' => 0, // 'last_check' => time(), //// 'last_delivery' => time(), //// 'last_delivery_link' => $value['link'], // 'last_post_created_time' => $value['created_time'] // ]; // $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updateInsUserData); //this code is run only when user make the first post (first order is placed). if ($firstPost_deliveryTime_day == 0) { $data4['firstpost_delivery_daytime'] = time(); $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data4); } ++$picsFetchCount; ++$dailyPostDone; $latestPostCreatedTime = $value['created_time']; $latestDeliveryLink = "https://www.instagram.com/p/" . $value['link'] . "/"; $latestPostCreatedTimeFlag = true; //modified by saurabh // for adding 10 MORE minutes delay in next order, if flag is not set than order will place at instant $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime; //$startTime += 600;//600= 10 minutes delay in next order placing } } else { // insert your custom message here in instagram_users table $updateInsUserMessageData = ['cronjob_status' => 0, 'ig_user_status' => 3, 'last_order_total_price' => $totalPrice, 'message' => 'Autolikes script has been stopped for # ' . $user->ins_username . ' due to insufficient balance.']; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updateInsUserMessageData); break; } } } //End of inner foreach loop // Update details in instagram_users table if ($latestPostCreatedTimeFlag) { $data6['pics_fetch_count'] = $picsFetchCount; $data6['daily_post_done'] = $dailyPostDone; $data6['last_post_created_time'] = $latestPostCreatedTime; $data6['last_delivery_link'] = $latestDeliveryLink; // print_r($data6);echo "<br>"; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data6); } } } } } $updateInsUserData = ['cronjob_status' => 0, 'last_check' => time()]; $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updateInsUserData); } } } //End of Outer foreach loop } catch (\Exception $e) { echo $e->getMessage(); $insUserStatus = $instagramUserModel->updateUserDetails(['rawQuery' => 'ins_user_id IN(' . $whereIn . ')'], ['cronjob_status' => 0]); } }