/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
Log::info('Iniciando proceso de lectura de ventas');
$disk = Storage::disk("sales");
$files = $disk->allfiles();
foreach ($files as $file) {
Log::info('Lectura de archivos para procesar');
$sales_log = SalesLog::where("file_name", $file)->first();
if (!isset($sales_log)) {
Log::info('Procesando archivo ' . $file);
$contents = $disk->get($file);
$count = 0;
$description = '';
$op_location = '';
$cl_location = '';
$rows = str_getcsv($contents, "\n");
//parse the rows
foreach ($rows as $row) {
$datas = str_getcsv($row, '|');
if (count($datas) == 17) {
$sales = new Sales(['transaction_id' => $datas[0], 'reference' => $datas[1], 'ra_start_date' => $datas[2], 'ra_end_date' => $datas[3], 'factura_uuid' => $datas[4], 'ammount' => $datas[5], 'ammount_applied' => 0, 'credit_debit' => $datas[6], 'payment_method' => $datas[7], 'ra_total' => $datas[8], 'customer_number' => $datas[9], 'op_location' => $datas[10], 'cl_location' => $datas[11], 'gl_account' => $datas[12], 'concept' => $datas[13], 'description' => $datas[14], 'date' => $datas[15], 'factura_number' => $datas[16]]);
$sales->save();
$count++;
$op_location = $datas[10];
$cl_location = $datas[11];
$description = $datas[14];
$payment_method = PaymentMethod::where("payment_method", $datas[7])->first();
if (!isset($payment_method)) {
Log::info('Agregando nuevo metodo de pago ' . $datas[7]);
$payment_method_ = new PaymentMethod(['payment_method' => $datas[7]]);
$payment_method_->save();
}
}
}
$sales_log_ = new SalesLog(['file_name' => $file, 'process' => $count, 'description' => $description, 'op_location' => $op_location, 'cl_location' => $cl_location]);
$sales_log_->save();
Log::info('Archivo procesado ' . $file . ' renglones procesados ' . $count);
}
}
Log::info('Finalizando proceso de lectura de ventas');
}
public function index()
{
if (Sentinel::check()) {
if (Sentinel::hasAccess('ventas.view')) {
$usuario = User::find($this->user_auth->id);
$oficinas = array();
foreach ($usuario->plazas as $plazas) {
array_push($oficinas, $plazas->Oficina);
}
$salesLogs = SalesLog::whereIn('op_location', $oficinas)->orWhere(function ($query) use($oficinas) {
$query->whereIn('cl_location', $oficinas);
})->get();
return view('contabilidad::Sales.index', compact('salesLogs'));
} else {
alert()->error('No tiene permisos para acceder a esta area.', 'Oops!')->persistent('Cerrar');
return back();
}
} else {
return redirect('login');
}
}
