public function update($id) { // validate // read more on validation at http://laravel.com/docs/validation $rules = array('full_name' => 'required', 'name' => 'required', 'inn' => 'required', 'kpp' => 'required|size:9', 'ogrn' => 'required|unique:debtors|size:13'); $validator = Validator::make(Input::all(), $rules); // process the login if ($validator->fails()) { return Redirect::to('debtor')->withErrors($validator); } else { // store $debtor = Debtor::find($id); $debtor->full_name = Input::get('full_name'); $debtor->name = Input::get('name'); $debtor->inn = Input::get('inn'); $debtor->kpp = Input::get('kpp'); $debtor->ogrn = Input::get('ogrn'); if ($this->is_valid_inn((int) $debtor->inn)) { //Проверка инн $debtor->save(); } else { var_dump('Error'); } // redirect Session::flash('success', 'Изменения сохранены'); return Redirect::to('debtor'); } }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('debtors')->delete(); $faker = FackerFactory::create('ja_JP'); for ($i = 0; $i < 10; $i++) { Debtor::create(['name' => $faker->name(), 'address' => $faker->address(), 'phone_number1' => $faker->phoneNumber(), 'phone_number2' => $faker->phoneNumber(), 'postal_code' => $faker->postcode(), 'sex' => $faker->boolean(), 'married' => $faker->boolean(), 'note' => $faker->text(), 'birthday' => $faker->date()]); } }
public function index(Request $request) { if ($request->ajax()) { $client_id = Input::get('filter-client'); $debtor_id = Input::get('filter-debtor'); $registry = Input::get('filter-registry'); $choice = Input::get('filter-choice'); $commissions = DailyChargeCommission::query(); $commissions->where('handler', true); if ($client_id != 0) { $commissions->whereHas('delivery', function ($q) use($client_id) { $q->where('client_id', '=', $client_id); }); } if ($debtor_id != 0) { $commissions->whereHas('delivery', function ($q) use($debtor_id) { $q->where('debtor_id', '=', $debtor_id); }); } if ($registry != 0) { $commissions->whereHas('delivery', function ($q) use($registry) { $q->where('registry', '=', $registry); }); } if ($choice != 0) { $before = Input::get('filter-before'); $after = Input::get('filter-after'); $arratBetween = [$before, $after]; if ($choice == 1) { $commissions->whereHas('delivery', function ($q) use($arratBetween) { $q->whereBetween('date_of_registry', $arratBetween); }); } elseif ($choice == 2) { $commissions->whereBetween('created_at', $arratBetween); } } $commissions = $commissions->get(); return view('reportRepayment.tableRow', ['commissions' => $commissions]); } else { $clients = Client::Where('active', true)->get(); $debtors = Debtor::all(); $debtors = Debtor::all(); $registries = ChargeCommission::Distinct('registry')->lists('registry'); return view('reportRepayment.index', ['clients' => $clients, 'debtors' => $debtors, 'registries' => $registries]); } }
public function index(Request $request) { $sort = Input::get('sort') == null ? 'relation_id' : Input::get('sort'); $client_id_select = Input::get('client_id_select') == null ? 'all' : Input::get('client_id_select'); $countCongestion = Input::get('count_congestion') == null ? 'balance_owed' : Input::get('count_congestion'); $sortDirection = Input::get('sortDirection') == null ? 'DESC' : Input::get('sortDirection'); $clients = Client::all(); $debtors = Debtor::all(); $limits = Limit::whereHas('relation', function ($query) use($client_id_select) { if ($client_id_select !== 'all') { $query->where('client_id', '=', $client_id_select); } })->get(); $usedLimit = array(); foreach ($limits as $key => $limit) { $usedLimitItem = 0; foreach ($limit->relation->deliveries as $value) { if ($value->status == 'Профинансирована') { if ($countCongestion == 'remainder_of_the_debt_first_payment') { $usedLimitItem += $value->remainder_of_the_debt_first_payment; } else { $usedLimitItem += $value->balance_owed; } } } $usedLimit[$key] = $usedLimitItem; } $relations = Relation::select('client_id')->distinct()->get(); if ($request->ajax()) { if ($sort == 'client_id') { return view('limits.indexAjaxClient', ['clients' => $clients, 'countCongestion' => $countCongestion]); } else { if ($sort == 'debtor_id') { return view('limits.indexAjaxDebtor', ['countCongestion' => $countCongestion, 'debtors' => $debtors]); } else { return view('limits.indexAjax', ['limits' => $limits, 'relations' => $relations, 'usedLimit' => $usedLimit]); } } } else { return view('limits.index', ['limits' => $limits, 'relations' => $relations, 'usedLimit' => $usedLimit, 'clients' => $clients]); } }
public function index() { $clients = Client::all(); $debtors = Debtor::all(); return view('chargeCommission.index', ['debtors' => $debtors, 'clients' => $clients]); }
/** * Remove the specified resource from storage. * * @param int $id * * @return Response */ public function destroy($id) { Debtor::destroy($id); Session::flash('flash_message', 'Debtor deleted!'); return redirect('debtor'); }
public function store() { //Session::start(); //dd(Input::file('report')); if (Input::file('report')) { $result = Excel::load(Input::file('report'), function ($reader) { $reader->setDateFormat('Y-m-d'); $reader->toObject(); }, 'UTF-8')->get(); $resultNotJson = $result->each(function ($sheet) { $sheet->each(function ($row) { }); }); $resultArrayNull = json_decode($resultNotJson); $resultArrayVar = []; $resultArray = []; $deliveryCheck = 0; $invoicesCheck = 0; for ($i = 0; $i < count($resultArrayNull); $i++) { for ($j = 0; $j < count($resultArrayNull[$i]); $j++) { if (!empty($resultArrayNull[$i][$j])) { if ($resultArrayNull[$i][$j] == 'Накладная' || $resultArrayNull[$i][$j] == 'накладная') { $deliveryCheck++; } if ($resultArrayNull[$i][$j] == 'Счет-фактура' || $resultArrayNull[$i][$j] == 'счет-фактура') { $invoicesCheck++; } array_push($resultArrayVar, $resultArrayNull[$i][$j]); } } if (count($resultArrayVar) > 0) { array_push($resultArray, $resultArrayVar); } $resultArrayVar = []; } //dd($invoicesCheck); if ($deliveryCheck > 0 && $invoicesCheck > 0 && $deliveryCheck == $invoicesCheck) { if (count($resultArray[0] === 4) && count($resultArray[1] === 4) && count($resultArray[2] === 4) && count($resultArray[3] === 2) && count($resultArray[4] === 4)) { $clientInn = $resultArray[1][3]; $clientName = $resultArray[1][1]; $debtorInn = $resultArray[2][3]; $debtorName = $resultArray[2][1]; $contractCode = strval($resultArray[3][1]); $contractDate = new Carbon($resultArray[4][2]); $registryVar = $resultArray[0][3]; $registryDate = new Carbon($resultArray[0][1]); $client = Client::where('inn', '=', $clientInn)->first(); $debtor = Debtor::where('inn', '=', $debtorInn)->first(); $registryDelivery = Delivery::where('registry', '=', $registryVar)->where('client_id', '=', $client->id)->first(); if ($registryDelivery === null) { if ($client) { if ($debtor) { $clientId = $client->id; $debtorId = $debtor->id; $relation = Relation::where('client_id', $client->id)->where('debtor_id', $debtor->id)->whereHas('contract', function ($q) use($contractCode, $contractDate) { $q->where('code', '=', $contractCode); $q->whereDate('created_at', '=', $contractDate); })->first(); if ($relation) { $row = 0; $stop = 0; $i = 7; //dd($resultArray); while ($stop === 0) { if (isset($resultArray[$i][1]) && ($resultArray[$i][1] == 'Накладная' || $resultArray[$i][1] == 'накладная')) { $waybillDateVar = new Carbon($resultArray[$i][3]); //Дата накладной $waybillVar = strval($resultArray[$i][2]); //Накладная if (count($resultArray[$i + 1]) == 3) { $invoiceDateVar = new Carbon($resultArray[$i + 1][2]); //Дата счет фактуры $invoiceVar = $resultArray[$i + 1][1]; } elseif (count($resultArray[$i + 1]) == 2) { if (strtotime($resultArray[$i + 1][1])) { $invoiceDateVar = new Carbon($resultArray[$i + 1][1]); //Дата счет фактуры $invoiceVar = null; } else { $invoiceDateVar = null; //Дата счет фактуры $invoiceVar = $resultArray[$i + 1][1]; } } else { $invoiceVar = null; $invoiceDateVar = null; } $sum = $resultArray[$i][5]; $debtDate = $resultArray[$i][4]; //не используется if (isset($resultArray[$i][6])) { $notes = $resultArray[$i][6]; } else { $notes = null; } $waybillExist = $relation->deliveries->where('waybill', $waybillVar)->where('date_of_waybill', $waybillDateVar->format('Y-m-d'))->first(); if ($waybillExist === null) { $dateOfRecourse = clone $waybillDateVar; $dateOfRecourse->addDays($relation->deferment); //Срок оплаты $dateNowVar = new Carbon(date('Y-m-d')); //Сегодняшнее число $actualDeferment = clone $dateNowVar; $dateOfRecourseClone = clone $dateOfRecourse; $actualDeferment = $dateOfRecourseClone->diffInDays($actualDeferment, false); //Фактическая просрочка $dateOfRegress = clone $dateOfRecourse; $dateOfRegress->addDays($relation->waiting_period); //Дата регресса $theDateOfTerminationOfThePeriodOfRegression = clone $dateOfRegress; $theDateOfTerminationOfThePeriodOfRegression->addDays($relation->regress_period); //Дата окончания регресса $delivery = new Delivery(); $delivery->client_id = $relation->client_id; $delivery->debtor_id = $relation->debtor_id; $delivery->relation_id = $relation->id; $delivery->waybill = $waybillVar; $delivery->waybill_amount = $sum; $rpp = $relation->rpp; $delivery->first_payment_amount = $sum / 100.0 * $rpp; $delivery->date_of_waybill = $waybillDateVar; $delivery->due_date = $relation->deferment; $delivery->date_of_recourse = $dateOfRecourse; //срок оплаты //$delivery->date_of_payment = $dateNowVar->format('Y-m-d');//дата оплаты(ложь) $delivery->date_of_regress = $dateOfRegress; $delivery->the_date_of_termination_of_the_period_of_regression = $theDateOfTerminationOfThePeriodOfRegression; $delivery->the_date_of_a_registration_supply = $dateNowVar->format('Y-m-d'); $delivery->the_actual_deferment = $actualDeferment; $delivery->invoice = $invoiceVar; $delivery->date_of_invoice = $invoiceDateVar; $delivery->registry = $registryVar; $delivery->date_of_registry = $registryDate; //$delivery->date_of_funding = ; //$delivery->end_date_of_funding = $dateNowVar->format('Y-m-d');;//(ложь) $delivery->notes = $notes; $delivery->return = ""; $delivery->status = 'Зарегистрирована'; $delivery->state = false; $delivery->the_presence_of_the_original_document = Input::get('the_presence_of_the_original_document'); if ($relation->confedential_factoring) { $delivery->type_of_factoring = $relation->confedential_factoring; } else { $delivery->type_of_factoring = false; } if (!$delivery->save()) { Session::flash('success', 'Реестр успешно загружен'); } } else { //накладная с таким номером существует } $i = $i + 2; } else { $stop = 1; } } } else { Session::flash('danger', 'Связь между клиентом и дебитором, либо договор не найдены'); } } else { Session::flash('danger', 'Дебитор с таким ИНН не найден'); } } else { Session::flash('danger', 'Клиент с таким ИНН не найден'); } } else { Session::flash('danger', 'Реестр с таким номером уже существует'); } } else { Session::flash('danger', 'Заполните все поля реестра'); } } else { Session::flash('danger', 'Проверьте наличие ключей \'Накладная\' и \'Счет-фактура\''); } } else { Session::flash('danger', 'Файл не был загружен'); } return Redirect::to('delivery'); }
public function getIndexRepayment() { $repayments = Repayment::OrderBy('date')->get(); $clients = Client::all(); $debtors = Debtor::all(); return view('repayment.tableRepaymentRow', ['repayments' => $repayments, 'clients' => $clients, 'debtors' => $debtors]); }
public function edit($id) { $relation = Relation::find($id); $client = Client::find($relation->client->id); $debtor = Debtor::find($relation->debtor->id); $tariffs = Tariff::all(); return view('relations.edit', ['relation' => $relation, 'client' => $client, 'tariffs' => $tariffs, 'debtor' => $debtor]); }