static function csvToRespondents($file, $project_id) { $respondents = Excel::load($file, function ($reader) { $reader->toArray(); }); $respondents = $respondents->parsed; $count = null; foreach ($respondents as $respondent) { $count++; $new = Respondent::create(['first_name' => $respondent->first_name, 'last_name' => $respondent->last_name, 'gender' => $respondent->gender, 'dob' => $respondent->dob, 'project_id' => $project_id]); if (isset($respondent->email) && $respondent->email != null) { $email = RespondentEmail::firstOrCreate(['project_id' => $project_id, 'address' => $respondent->email]); $email->type = $respondent->type; $email->save(); $new->emails()->save($email); } if (isset($respondent->phone) && $respondent->phone != null) { $ph_num = Uploader::cleanPhoneNumber($respondent->phone); $phone = RespondentPhone::firstOrCreate(['project_id' => $project_id, 'number' => $ph_num]); $phone->type = $respondent->phone_type; $phone->save(); $new->phones()->save($phone); } if (isset($respondent->email) && $respondent->email != null) { $address = RespondentAddress::firstOrCreate(['project_id' => $project_id, 'street_number' => $respondent->street_number, 'street_name' => $respondent->street_name, 'apt' => $respondent->apt, 'city' => $respondent->city, 'state' => $respondent->state, 'zip' => $respondent->zip, 'type' => $respondent->address_type]); $new->addresses()->save($address); } } return $count; }
private function insertArticles($filename) { $i = 0; $filename = 'storage/app/' . $filename; Excel::load($filename, function ($reader) use($i) { $results = $reader->get(); foreach ($results as $article) { $NoEstaEnLaBD = is_null(Article::where('product_code', $article['codigo'])->first()); if ($NoEstaEnLaBD) { // si el articulo _NO_ se encuentra en la base de datos if (is_null($article['serializable'])) { $serializable = 0; } else { $serializable = $article['serializable']; } $a = Article::create(['product_code' => $article['codigo'], 'unit' => $article['ub'], 'name' => $article['descripcion'], 'barcode' => $article['barcode'], 'fav' => $article['fav'], 'serializable' => $serializable, 'active' => $article['activo']]); $i++; } else { // si el codigo se encuentra en la base de datos } } }); // Fin del Excel::load return $i; }
/** * @param Request $request * @return View */ public function postImportContacts(Request $request) { $start = microtime(true); $authenticated_user = $request->user(); $creation_data = new CRUDResultData(); $file = Input::file('imported_contacts'); if (is_null($file)) { $extension = 'ERROR'; $creation_data->extra_info .= 'No file uploaded. '; } else { $extension = $file->getClientOriginalExtension(); } if ($extension == 'xls' or $extension == 'xlsx') { $php_excel = Excel::load($file->getPathname()); $worksheet = $php_excel->setActiveSheetIndex(0)->toArray(); $validation_data = $this->validateExcel($worksheet); if ($validation_data->success == false) { $creation_data = $validation_data; } else { $creation_data->success = true; $creation_data->extra_info = $validation_data->extra_info; $this->insertFromExcel($worksheet, $authenticated_user); } } elseif ($extension == 'csv' or $extension == 'tsv') { } $creation_data->extra_info .= 'Time to finish: ' . round((microtime(true) - $start) * 1000, 3) . ' ms. '; $creation_data->extra_info .= 'Uploaded by: ' . $authenticated_user->name . ' - ' . $authenticated_user->email . '. '; $this->logImportResult($creation_data, $authenticated_user); return View('contacts/import_contact')->with('creation_data', $creation_data); }
public function excel(Request $request) { try { Log::info(Input::file('input_excel')); Excel::load($request->file('input_excel'), function ($reader) { $array = $reader->toArray(); Log::info($array); $banqueId = $this->gestSession->addBanqueByExcel($array[0]); Log::info("IdBanque1 " . $banqueId); $i = 1; while ($i < sizeof($array)) { Log::info($array); $titreIdGItem = $this->gestSession->addTitreGItemByExcel($array[$i]); Log::info("IdTitreGItem " . $titreIdGItem); $i++; while ($i < sizeof($array) && $array[$i]["label_item"] != null) { $this->gestSession->addItemByExcel($array[$i], $banqueId, $titreIdGItem); $i++; } } }); return Redirect::back(); } catch (\Exception $e) { echo "Format Incorrect"; } }
public function importdata(Request $request) { $results = null; $type = $request->input('type'); $retdate = Excel::load($request->file('exelimport'), function ($reader) use($type) { $results = $reader->get(); $ret = $results->toArray(); // var_dump($ret); foreach ($ret as $index => $value) { $EMP_ID = $value["emp_id"]; $PLAN_ID = $value["plan_id"]; $EQUITY_RATE = $value["equity_rate"]; $DEBT_RATE = $value["debt_rate"]; $MODIFY_DATE = $value["modify_date"]; $EFFECTIVE_DATE = $value["effective_date"]; $MODIFY_COUNT = $value["modify_count"]; $MODIFY_COUNT_TIMESTAMP = $value["modify_count_timestamp"]; $MODIFY_BY = $value["modify_by"]; $insert = "INSERT INTO TBL_USER_FUND_CHOOSE (PLAN_ID,EMP_ID,EQUITY_RATE,DEBT_RATE,MODIFY_DATE,EFFECTIVE_DATE,MODIFY_COUNT,MODIFY_COUNT_TIMESTAMP,MODIFY_BY) VALUES(" . $PLAN_ID . ",'" . $EMP_ID . "'," . $EQUITY_RATE . "," . $DEBT_RATE . ",'" . $MODIFY_DATE . "','" . $EFFECTIVE_DATE . "'," . $MODIFY_COUNT . ",'" . $MODIFY_COUNT_TIMESTAMP . "','" . $MODIFY_BY . "')"; DB::insert(DB::raw($insert)); } $staturet = true; $data = "ok"; }); return response()->json(array('success' => true, 'html' => $retdate)); }
public static function _loadXls($url) { $data = Excel::load($url, function ($reader) { return $reader->all(); }); return $data; }
public function import() { Excel::load('public/books.csv', function ($reader) { foreach ($reader->get() as $book) { Renglon::create(['descrip_renglon' => $book->id_tipo_, 'id_marca' => $book->unidad_medida, 'id_modelo' => $book->cantidad, 'unidad_medida' => $book->unidad_medida, 'cantidad' => $book->cantidad, 'existencia_minima' => $book->existencia_minima, 'foto_producto' => $book->foto_producto, 'cod_usua' => $book->cod_usua]); } }); return Renglon::all(); }
protected function loadFragments(string $path) : Collection { return Excel::load($path)->all()->flatMap(function (RowCollection $sheet) { return $sheet->reject(function (CellCollection $row) { return empty(trim($row->group)); })->map(function (CellCollection $row) use($sheet) { return $row->put('hidden', $sheet->getTitle() === 'hidden')->toArray(); }); }); }
public function postCargarUsuarios(CargarUsuariosRequest $request) { $imagen = $request->file('imagen'); $ruta = '/img/'; $nombre = 'usuarios' . '.' . $imagen->guessExtension(); $imagen->move(getcwd() . $ruta, $nombre); $result = Excel::load('public/img/usuarios.xlsx')->get(); foreach ($result as $informe) { Usuario::create(['id' => $informe->id, 'nombre' => $informe->nombre, 'email' => $informe->email, 'password' => bcrypt($informe->password), 'tipo' => $informe->tipo]); } return redirect("/")->with('creada', 'Archivo subido'); }
public function importData(Request $request) { $file = $request->file('file'); $name = time() . $file->getClientOriginalName(); #$file->getClientOriginalName(); $file->move('csv', $name); Excel::load('public/csv/' . $name, function ($reader) { $reader->each(function ($row) { Product::create($row->all()); }); }); //message Done' #return redirect()->route('product.index'); }
public function importar() { Excel::load('Clientes.xlsx', function ($reader) { foreach ($reader->get() as $cliente) { \JLcourier\Entities\Cliente::create(['id' => $cliente->id, 'nombre' => $cliente->nombre, 'ruc' => $cliente->ruc, 'banco' => $cliente->banco]); } }); Excel::load('Ordenes.xlsx', function ($reader) { foreach ($reader->get() as $orden) { \JLcourier\Entities\OrdenServicio::create(['id' => $orden->id, 'cliente_id' => $orden->cliente_id, 'fecha_inicio' => $orden->fecha_inicio, 'nro_orden' => $orden->nro_orden, 'tipo' => $orden->tipo, 'tiempo' => $orden->tiempo, 'estado' => $orden->estado]); } }); return \JLcourier\Entities\Cliente::all(); }
public function import() { try { $file = Input::file('file'); //$path = Input::file('pricelist')->getRealPath(); $temp = null; Excel::load($file, function ($reader) use($temp) { //$reader->dump(); // Loop through all rows $reader->each(function ($row) { }); }); } catch (Exception $e) { return 'Message: ' . $e->getMessage(); } return redirect()->action('HomeController@index'); }
public function Checkdate(Request $request) { $results = null; $result = Excel::load($request->file('exelimport'))->get(); $count = $result->count(); // // Excel::load($request->file('exelimport'), function ($reader) use($count) { // // $results = $reader->get(); // // $ret = $results->toArray(); // // // $count = count($ret); // // // }); return response()->json(array('success' => true, 'html' => $count)); }
public static function parseFileImport(\Illuminate\Http\Request $r) { $result = array('items' => '', 'file' => ''); $config = \Config::get('user_import'); $generateName = uniqid() . '.' . $r->file('file')->getClientOriginalExtension(); $result['file'] = pathinfo($generateName)['basename']; $r->file('file')->move($config['path_price'], $result['file']); //$delimiter $excel = Excel::load($config['path_price'] . $result['file'], function ($reader) { $reader->noHeading(); }); if ($excel->getTotalRowsOfFile() > 10) { $excel = $excel->take(3)->get()->toArray(); } else { $excel = $excel->get()->toArray(); } $result['items'] = UserImport::formaterDataFile($excel, $generateName); return $result; }
public function import() { /************* Base ***********/ Excel::load('data/base_stcs.csv', function ($reader) { foreach ($reader->get() as $employee) { Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 1]); } }); Excel::load('data/base_sthcs.csv', function ($reader) { foreach ($reader->get() as $employee) { Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 2]); } }); Excel::load('data/base_sitcs.csv', function ($reader) { foreach ($reader->get() as $employee) { Employee::create(["no_emp" => $employee->noemp, "first_name" => ucwords(mb_strtolower($employee->nombre, 'UTF-8')), "last_name" => '', "gender" => "f", "status" => 1, "payrollID" => 3, "syndicateID" => 3]); } }); return Employee::all(); }
public function guardarNotas(Request $request) { $ver = Excel::load($request['file1'], function ($reader) { //Seleccionamos la materia, unidad academica y gestion del excel $materiaId = \DB::table('materias')->where('nombreMateria', $reader->noHeading()->toArray()[0][4])->value('id'); $ua = \DB::table('unidad_academicas')->where('ua', $reader->noHeading()->toArray()[3][4])->value('id'); $gestion = $reader->noHeading()->toArray()[4][4]; foreach ($reader->get() as $notas) { //echo $notas[0]; \DB::table('kardexes')->where('materia_id', $materiaId)->where('gestion', $gestion)->where('ua_id', $ua)->where('activo', 1)->where('user', $notas[0])->update(['11a' => $notas[5], '11b' => $notas[6], '11c' => $notas[7], '12a' => $notas[9], '12b' => $notas[10], 'prom1' => $notas[11] / 0.2, '21a' => $notas[13], '21b' => $notas[14], '21c' => $notas[15], '22a' => $notas[17], '22b' => $notas[18], '22c' => $notas[19], 'prom2' => $notas[20] / 0.3, '31a' => $notas[22], '31b' => $notas[23], '31c' => $notas[24], '31d' => $notas[25], '31e' => $notas[26], '31f' => $notas[27], '31g' => $notas[28], 'prom3' => $notas[29] / 0.4, '41aFacil' => $notas[31], '41bFacil' => $notas[32], '41cFacil' => $notas[33], '41dFacil' => $notas[34], 'prom4Facil' => $notas[35] / 0.1]); //ACTUALIZAMOS EL PARAMETRO 4, QUE EVALUAN JE,CURSANTE Y DOCENTE $promedios = \DB::table('kardexes')->where('materia_id', $materiaId)->where('activo', 1)->where('user', $notas[0])->select('prom4Cursante', 'prom4Facil', 'prom4JE')->get(); if ($promedios != null) { $promedioGeneral = $promedios[0]->{'prom4Cursante'} * 0.1 + $promedios[0]->{'prom4JE'} * 0.2 + $promedios[0]->{'prom4Facil'} * 0.7; //Actualizamos el promedio general \DB::table('kardexes')->where('materia_id', $materiaId)->where('activo', 1)->where('user', $notas[0])->update(['prom4' => $promedioGeneral]); } } })->noHeading()->toArray(); return view('docente.calificacionExitosa'); }
/** * Import an excel file from file address * * @param $fileAddress * @return array */ public function import($fileAddress) { $this->items = Excel::load($fileAddress, function ($reader) { })->get(); $firstSheet = $this->items->first()->toArray(); if (empty($firstSheet)) { return []; } array_walk($firstSheet, function (&$row, $index) { if (empty($row['phone_number'])) { unset($row); } $newRow = []; $newRow['phone_number'] = $row['phone_number']; $newRow['description'] = empty($row['description']) ? '' : $row['description']; $newRow['priority'] = empty($row['priority']) ? 0 : (int) $row['priority']; $newRow['shared'] = true; $row = $newRow; unset($newRow); }); return $firstSheet; }
public function doImport() { if (Input::hasFile('excel')) { $profiles = Excel::load(Input::file('excel'), function ($reader) { })->get(); // return $profiles; if (count($profiles) > 0) { foreach ($profiles as $profile) { if (is_null($profile->rcl)) { echo $profile->id_profile . "<br/>"; $rcl = 0; } else { $rcl = $profile->rcl; } if (is_null($profile->itj)) { echo $profile->id_profile . "<br/>"; $itj = 0; } else { $itj = $profile->itj; } $competencyProfile = new CompetencyProfile(); $competencyProfile->competency_id = 1; $competencyProfile->struktural_id = $profile->id_struk; $competencyProfile->fungsional_id = $profile->id_fung; $competencyProfile->golongan_id = $profile->id_gol; $competencyProfile->jabatan_id = $profile->id_unit; $competencyProfile->competency_dictionary_id = $profile->id_competency_dictionary; $competencyProfile->rcl = $rcl; $competencyProfile->itj = $itj; $competencyProfile->save(); } } // return $profiles; } else { return Input::all(); } }
public static function importar($request) { $nombre = pathinfo($request->file->getClientOriginalName(), PATHINFO_FILENAME); switch ($nombre) { case 'productos': break; case 'marcas': break; case 'categorias': break; case 'impuestos': break; } $results = Excel::load($request->file('file'), function ($reader) { })->get(); foreach ($results as $result) { $hola[] = $result->sku; } }
public function fromExcel($dir = null, $file = null) { $file = $dir . '/' . $file; $rows = Excel::load($file, null)->get(); return $rows; }
public function UploadCampaign(Request $request) { if (Auth::check()) { if (in_array('ADD_EDIT_CAMPAIGN', $this->permission)) { if ($request->hasFile('upload')) { if (User::isSuperAdmin()) { $advertiser_obj = Advertiser::with('GetClientID')->find($request->input('advertiser_id')); } else { $usr_company = $this->user_company(); $advertiser_obj = Advertiser::whereHas('GetClientID', function ($p) use($usr_company) { $p->whereIn('user_id', $usr_company); })->find($request->input('advertiser_id')); if (!$advertiser_obj) { return Redirect::back()->withErrors(['success' => false, 'msg' => 'please Select your Client'])->withInput(); } } if ($advertiser_obj) { $destpath = public_path(); $extension = $request->file('upload')->getClientOriginalExtension(); // getting image extension $fileName = str_random(32) . '.' . $extension; $request->file('upload')->move($destpath . '/cdn/test/', $fileName); Config::set('excel.import.startRow', 12); $upload = Excel::load('public/cdn/test/' . $fileName, function ($reader) { })->get(); $t = array(); foreach ($upload[0] as $key => $value) { array_push($t, $key); } if ($t[1] != 'name' or $t[2] != 'max_impression' or $t[3] != 'daily_max_impression' or $t[4] != 'max_budget' or $t[5] != 'daily_max_budget' or $t[6] != 'cpm' or $t[7] != 'advertiser_domain_name' or $t[8] != 'status' or $t[9] != 'start_date' or $t[10] != 'end_date') { File::delete($destpath . '/cdn/test/' . $fileName); return Redirect::back()->withErrors(['success' => false, 'msg' => 'please be sure that file is correct'])->withInput(); } $bad_input = array(); $count = 0; // return dd(); foreach ($upload as $test) { $flg = 0; $campaign = new Campaign(); if ($test['name'] == '' or $test['max_impression'] == '' or $test['daily_max_impression'] == '' or $test['max_budget'] == '' or $test['daily_max_budget'] == '' or $test['cpm'] == '' or $test['advertiser_domain_name'] == '' or $test['status'] == '' or $test['status'] == '' or $test['end_date'] == '') { array_push($bad_input, $test['name']); continue; } if (!is_numeric($test['max_impression']) or !is_numeric($test['daily_max_impression']) or !is_numeric($test['max_budget']) or !is_numeric($test['daily_max_budget']) or !is_numeric($test['cpm'])) { array_push($bad_input, $test['name']); continue; } if (strcasecmp($test['status'], 'active') != 0 and strcasecmp($test['status'], 'inactive') != 0) { array_push($bad_input, $test['name']); continue; } $campaign->name = $test['name']; $campaign->max_impression = $test['max_impression']; $campaign->daily_max_impression = $test['daily_max_impression']; $campaign->max_budget = $test['max_budget']; $campaign->daily_max_budget = $test['daily_max_budget']; $campaign->cpm = $test['cpm']; $campaign->start_date = $test['start_date']; $campaign->end_date = $test['end_date']; $campaign->advertiser_domain_name = $test['advertiser_domain_name']; $campaign->status = ucwords(strtolower($test['status'])); $campaign->advertiser_id = $request->input('advertiser_id'); // return dd('dd1'); $count++; $campaign->save(); } $audit = new AuditsController(); $audit->store('campaign', 0, $count, 'bulk_add'); $msg = "Campaigns added successfully"; if (count($bad_input) > 0) { $msg .= " exept: "; foreach ($bad_input as $index) { $msg .= $index . ','; } } return Redirect::back()->withErrors(['success' => true, 'msg' => $msg]); } return Redirect::back()->withErrors(['success' => false, 'msg' => 'please Select Advertiser First'])->withInput(); } return Redirect::back()->withErrors(['success' => false, 'msg' => 'please Select a file'])->withInput(); } return Redirect::back()->withErrors(['success' => false, 'msg' => "You don't have permission"]); } return Redirect::to(url('/user/login')); }
private function handlePostFileUploadRka($basePath, $targetPath, UploadedFile $uploadedFile, $overwrite = true) { //handle the postfile upload $originalFileName = pathinfo($targetPath, PATHINFO_BASENAME); $extension = strtolower(pathinfo($originalFileName, PATHINFO_EXTENSION)); $storagePath = $basePath; $fileName = md5($originalFileName . time()) . '.' . $extension; $file = $uploadedFile->move($storagePath, $fileName); Excel::load('rka/' . $fileName, function ($reader) { $targetModel = new Target(); $result = $reader->all()->toArray(); $data_rka = $this->getTemplate()->saveBranchInstanding($result, $targetModel); }); }
/** * Upload file. * * @param int $id * @return \Illuminate\Http\Response */ public function upload_files(Request $request) { //dd($request->file('FileInput')); if (Input::hasFile('FileInput')) { $file = $request->file('FileInput'); $destinationPath = 'assets/files/'; // upload path $name = $file->getClientOriginalName(); $extension = $file->getClientOriginalExtension(); // getting image extension $fileName = rand(11111, 99999) . '_' . $name; // renameing image $file->move($destinationPath, $fileName); // loading file to given path echo '¡Éxito! Archivo subido.'; echo '<br>'; Excel::load('assets/files/' . $fileName, function ($reader) { // Getting all results $results = $reader->get(); //dd($results); foreach ($results as $data) { //var_dump($data->ocupacion); try { $query_insert = \DB::table('ad_activities')->insert(['occupation' => $data->ocupacion, 'code' => $data->caedec, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]); } catch (QueryException $e) { echo $e->getMessage(); } } echo 'Se importo correctamente los datos del archivo'; }); unlink('assets/files/' . $fileName); } else { return redirect()->back()->with(array('error' => 'Error no se subio correctamente el archivo, intente otra vez')); } }
public function postImport(ObjectImportRequest $request) { if ($type = Input::get('type')) { if ($format = Input::get('format')) { switch ($format) { case 'excel': if ($request->hasFile('dd')) { $file = $request->file('dd'); $filename = $file->getClientOriginalName(); $extension = $file->getClientOriginalExtension(); $mimeType = $file->getMimeType(); $destinationPath = public_path() . '/temp'; $request->file('dd')->move($destinationPath, 'import.xls'); Excel::load($destinationPath . '/import.xls', function ($reader) use($type) { if ($rows = $reader->all()) { foreach ($rows as $row) { $data = $row->toArray(); $name = $data['name']; if (!$name) { $name = str_replace(' ', '-', $data['title']); } $object = new Object(); $object->author_id = Auth::user()->id; $object->type = $type; $object->name = $name; $object->title = $data['title']; $object->content = $data['content']; $object->status = 'published'; $object->guid = Hash::getUniqueId(); $object->save(); $keys = array_keys($data); foreach ($keys as $key) { if (!in_array($key, array('type', 'title', 'name', 'content', 'excerpt'))) { $val = $data[$key]; if (!empty($val)) { $object->setValue('_field_' . $key, $val); } } } } } }); } break; } } } }
public function postImportUserRole(Request $request) { $getSheetName = Excel::load(Request::file('file4'))->getSheetNames(); foreach ($getSheetName as $sheetName) { //if ($sheetName === 'Product-General-Table') { //selectSheetsByIndex(0) //DB::statement('SET FOREIGN_KEY_CHECKS=0;'); //DB::table('users')->truncate(); //Excel::selectSheets($sheetName)->load($request->file('file'), function ($reader) //Excel::selectSheets($sheetName)->load(Input::file('file'), function ($reader) //Excel::filter('chunk')->selectSheetsByIndex(0)->load(Request::file('file'))->chunk(50, function ($reader) Excel::filter('chunk')->selectSheets($sheetName)->load(Request::file('file4'))->chunk(50, function ($reader) { $readerarray = $reader->toArray(); //var_dump($readerarray); foreach ($readerarray as $row) { /* $userbulk = new User; $userbulk->name = $row['user'];; $userbulk->email = $row['email']; $userbulk->password = bcrypt($row['pass']); //$userbulk->created_at = date(2015-12-22); //$userbulk->updated_at = date(2015-12-22); $userbulk->save(); */ } }); } return redirect('/'); }
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 getSimpleCsvValidator($file) { $transactions = Excel::load($file)->get()->toArray(); $transactionHeader = Excel::load($file)->get()->first()->keys()->toArray(); $templateHeader = Excel::load(app_path('Core/V201/Template/Csv/iati_transaction_template_simple.csv'))->get()->first()->keys()->toArray(); if (count(array_intersect($transactionHeader, $templateHeader)) !== count($templateHeader)) { return null; } $transactionCurrency = implode(',', $this->getCodes('Currency', 'Organization')); $rules = []; $messages = []; foreach ($transactions as $transactionIndex => $transactionRow) { $requiredOnlyOneRule = sprintf('required_only_one:%s.incoming_fund,%s,%s.expenditure,%s,%s.commitment,%s,%s.disbursement,%s', $transactionIndex, trimInput($transactionRow['incoming_fund']), $transactionIndex, trimInput($transactionRow['expenditure']), $transactionIndex, trimInput($transactionRow['commitment']), $transactionIndex, trimInput($transactionRow['disbursement'])); $rules = array_merge($rules, ["{$transactionIndex}.internal_reference" => sprintf('unique_validation:%s.internal_reference,%s,%s,internal_reference', $transactionIndex, trimInput($transactionRow['internal_reference']), $file), "{$transactionIndex}.incoming_fund" => trimInput($transactionRow['incoming_fund']) ? $requiredOnlyOneRule . '|numeric' : $requiredOnlyOneRule, "{$transactionIndex}.expenditure" => trimInput($transactionRow['expenditure']) ? 'numeric' : '', "{$transactionIndex}.disbursement" => trimInput($transactionRow['disbursement']) ? 'numeric' : '', "{$transactionIndex}.commitment" => trimInput($transactionRow['commitment']) ? 'numeric' : '', "{$transactionIndex}.transaction_date" => 'required|date', "{$transactionIndex}.transaction_currency" => 'in:' . $transactionCurrency, "{$transactionIndex}.description" => 'required']); $messages = array_merge($messages, ["{$transactionIndex}.internal_reference.required" => sprintf('At row %s Internal Reference is required', $transactionIndex + 1), "{$transactionIndex}.internal_reference.unique_validation" => sprintf('At row %s Internal Reference should be unique.', $transactionIndex + 1), "{$transactionIndex}.incoming_fund.numeric" => sprintf('At row %s Incoming Fund should be numeric', $transactionIndex + 1), "{$transactionIndex}.incoming_fund.required_only_one" => sprintf('At row %s only one among Incoming Fund ,expenditure, disbursement and commitment is required.', $transactionIndex + 1), "{$transactionIndex}.expenditure.numeric" => sprintf('At row %s Expenditure should be numeric', $transactionIndex + 1), "{$transactionIndex}.disbursement.numeric" => sprintf('At row %s Disbursement should be numeric', $transactionIndex + 1), "{$transactionIndex}.commitment.numeric" => sprintf('At row %s Commitment should be numeric', $transactionIndex + 1), "{$transactionIndex}.transaction_date.required" => sprintf('At row %s Transaction Date is required', $transactionIndex + 1), "{$transactionIndex}.transaction_date.date" => sprintf('At row %s Transaction Date is invalid', $transactionIndex + 1), "{$transactionIndex}.transaction_currency.in" => sprintf('At row %s Transaction Currency is invalid', $transactionIndex + 1), "{$transactionIndex}.description.required" => sprintf('At row %s Description is required', $transactionIndex + 1)]); } return Validator::make($transactions, $rules, $messages); }
function excelParse() { if (Auth::check()) { $class = Input::get('class'); $year = Input::get('year'); if (Input::hasFile('exl')) { $exlFile = Input::file('exl'); $result = Excel::load($exlFile)->get(); //dd($result[0]->toArray()); if ($class != null && $year != null && $result != null) { foreach ($result as $res) { if ($res->blue != null) { $blueModel = new Blueg(); $blueModel->name = $res->blue; $blueModel->class = $class; $blueModel->year = $year; $blueModel->save(); } if ($res->green != null) { $greenModel = new Greeng(); $greenModel->name = $res->green; $greenModel->class = $class; $greenModel->year = $year; $greenModel->save(); } if ($res->yellow != null) { $yellowModel = new Yellowg(); $yellowModel->name = $res->yellow; $yellowModel->class = $class; $yellowModel->year = $year; $yellowModel->save(); } if ($res->red != null) { $redModel = new Redg(); $redModel->name = $res->red; $redModel->class = $class; $redModel->year = $year; $redModel->save(); } } } return Redirect('group_blue'); } else { echo 'Failed '; } } else { return redirect('login'); } }
public function UploadGeosegment(Request $request) { if (Auth::check()) { if (in_array('ADD_EDIT_GEOSEGMENTLIST', $this->permission)) { $validate = \Validator::make($request->all(), ['name' => 'required']); if ($request->hasFile('upload_geo') and $validate->passes()) { $chkUser = Advertiser::with('GetClientID')->find($request->input('advertiser_id')); if (!is_null($chkUser) and Auth::user()->id == $chkUser->GetClientID->user_id) { $destpath = public_path(); $extension = $request->file('upload_geo')->getClientOriginalExtension(); // getting image extension $fileName = str_random(32) . '.' . $extension; $request->file('upload_geo')->move($destpath . '/cdn/test/', $fileName); $upload = Excel::load('public/cdn/test/' . $fileName, function ($reader) { })->get(); $t = array(); foreach ($upload[0] as $key => $value) { array_push($t, $key); } if ($t[0] != 'name' or $t[1] != 'lat' or $t[2] != 'lon' or $t[3] != 'radius') { File::delete($destpath . '/cdn/test/' . $fileName); return Redirect::back()->withErrors(['success' => false, 'msg' => 'please be sure that file is correct'])->withInput(); } $flg = 0; $chk = GeoSegmentList::where('advertiser_id', $request->input('advertiser_id'))->get(); foreach ($chk as $index) { if ($index->name == $request->input('name')) { $flg = 1; } } if ($flg == 0) { $geosegment = new GeoSegmentList(); $geosegment->name = $request->input('name'); $geosegment->advertiser_id = $request->input('advertiser_id'); $geosegment->save(); foreach ($upload as $test) { $geosegmententries = new GeoSegment(); $geosegmententries->name = $test['name']; $geosegmententries->lat = $test['lat']; $geosegmententries->lon = $test['lon']; $geosegmententries->segment_radius = $test['radius']; $geosegmententries->geosegmentlist_id = $geosegment->id; $geosegmententries->save(); } $msg = "Geo Segment List added successfully"; return Redirect::back()->withErrors(['success' => true, 'msg' => $msg]); } File::delete($destpath . '/cdn/test/' . $fileName); return Redirect::back()->withErrors(['success' => false, 'msg' => 'this name already existed !!!'])->withInput(); } return Redirect::back()->withErrors(['success' => false, 'msg' => 'please Select your Client'])->withInput(); } return Redirect::back()->withErrors(['success' => false, 'msg' => 'please Select a file or fill name '])->withInput(); } return Redirect::back()->withErrors(['success' => false, 'msg' => "You don't have permission"]); } return Redirect::to(url('/user/login')); }
public function test() { $path = 'storage/surveys'; Excel::load($path . '/Filename.xls', function ($excel) { $excel->sheet('test', function ($sheet) { $sheet->prependRow(array('Teest Data', 'Test Data')); }); })->store('xls', storage_path('surveys')); // dd(File::exists(storage_path('surveys/Filename.xls'))); }