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')));
}
