public function archive($publicId)
{
$bmanual = BookSale::scope($publicId)->firstOrFail();
$manual->delete();
Session::flash('message', trans('texts.archived_manual'));
return Redirect::to('company/manuals');
}
public static function deleteIva($invoice)
{
if ($invoice->is_deleted) {
$BookSale = BookSale::scope()->whereInvoiceId($invoice->id)->first();
$BookSale->status = "A";
$BookSale->save();
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function bulk($entityType = ENTITY_INVOICE)
{
$action = Input::get('action');
$statusId = Input::get('statusId');
$ids = Input::get('id') ? Input::get('id') : Input::get('ids');
if ($action == 'delete') {
$invoices = Invoice::withTrashed()->scope($ids)->get();
foreach ($invoices as $invoice) {
BookSale::deleteBook($invoice);
}
}
//$count = $this->invoiceRepo->bulk($ids, $action, $statusId);
if ($count > 0) {
$key = $action == 'mark' ? "updated_{$entityType}" : "{$action}d_{$entityType}";
$message = Utils::pluralize($key, $count);
Session::flash('message', $message);
}
return Redirect::to("{$entityType}");
}
return $daysSinceLastSent >= 14;
case FREQUENCY_FOUR_WEEKS:
return $daysSinceLastSent >= 28;
case FREQUENCY_MONTHLY:
return $monthsSinceLastSent >= 1;
case FREQUENCY_THREE_MONTHS:
return $monthsSinceLastSent >= 3;
case FREQUENCY_SIX_MONTHS:
return $monthsSinceLastSent >= 6;
case FREQUENCY_ANNUALLY:
return $monthsSinceLastSent >= 12;
default:
return false;
}
return false;
}
}
Invoice::created(function ($invoice) {
if (!$invoice->is_recurring) {
$invoice->branch->incrementCounter($invoice->is_quote);
$invoice->account->incrementCounter($invoice->is_quote);
}
Activity::createInvoice($invoice);
BookSale::createBook($invoice);
});
Invoice::updating(function ($invoice) {
Activity::updateInvoice($invoice);
});
Invoice::deleting(function ($invoice) {
Activity::archiveInvoice($invoice);
});
public function doExportBookSales()
{
$action = Input::get('login');
if ($action == 'Exportar en CSV') {
Excel::create('Libro de Ventas, ' . ($date = Input::get('date')), function ($excel) {
$excel->sheet('Libro enero', function ($sheet) {
$date = Input::get('date');
$booksale = BookSale::select('invoice_date', 'invoice_number', 'number_autho', 'status', 'client_nit', 'client_name', 'amount', 'ice_amount', 'export_amount', 'grav_amount', 'subtotal', 'disc_bonus_amount', 'base_fiscal_debit_amount', 'fiscal_debit_amount', 'control_code')->where('account_id', '=', Auth::user()->account_id)->where('invoice_date', 'LIKE', '%' . $date)->orderBy('invoice_date', 'asc')->get();
$sheet->fromModel($booksale, null, 'A1', false, false);
});
})->download('csv');
} else {
Excel::create('Libro de Ventas, ' . ($date = Input::get('date')), function ($excel) {
$excel->setTitle('Libro de Ventas Facturacion Virtual');
$excel->setCreator('iPX Server')->setCompany('iPX Server');
$excel->setDescription('Libro de ventas Estándar');
$excel->sheet('Libro enero', function ($sheet) {
$sheet->setStyle(array('font' => array('name' => 'Calibri', 'size' => 12)));
$sheet->setWidth(array('A' => 10, 'B' => 10, 'C' => 15, 'D' => 8, 'E' => 14, 'F' => 22, 'G' => 13, 'H' => 13, 'I' => 20, 'J' => 15, 'K' => 12, 'L' => 20, 'M' => 15, 'N' => 14, 'O' => 14));
$sheet->mergeCells('G1:I1');
$sheet->mergeCells('G2:I2');
$sheet->mergeCells('B6:C6');
$sheet->mergeCells('D6:F6');
$sheet->cells('G1:G2', function ($cells) {
$cells->setFontWeight('bold');
$cells->setAlignment('center');
$cells->setValignment('middle');
});
$sheet->cells('C3:C4', function ($cells) {
$cells->setFontWeight('bold');
$cells->setAlignment('right');
$cells->setValignment('middle');
});
$sheet->cells('B6', function ($cells) {
$cells->setFontWeight('bold');
$cells->setAlignment('right');
$cells->setValignment('middle');
});
$sheet->cells('E4', function ($cells) {
$cells->setFontWeight('bold');
$cells->setAlignment('right');
$cells->setValignment('middle');
});
$sheet->cells('G6', function ($cells) {
$cells->setFontWeight('bold');
$cells->setAlignment('right');
$cells->setValignment('middle');
});
$sheet->cells('D4', function ($cells) {
$cells->setAlignment('left');
$cells->setValignment('middle');
});
$date = Input::get('date');
$dateA = explode("/", $date);
$year = $dateA[1];
$month = intval($dateA[0]);
$account = Auth::user()->account;
$months = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre");
$sheet->row(1, array('', '', '', '', '', '', 'LIBRO DE VENTAS'));
$sheet->row(2, array('', '', '', '', '', '', 'ESTANDAR'));
$sheet->row(3, array('', '', 'PERIODO:'));
$sheet->row(4, array('', '', 'AÑO:', $year, 'MES:', $months[$month - 1]));
$sheet->row(6, array('', 'NOMBRE O RAZÓN SOCIAL:', '', $account->name, '', '', 'NIT:', $account->nit));
$sheet->setStyle(array('font' => array('name' => 'Calibri', 'size' => 10)));
$sheet->cells('A8:O8', function ($cells) {
$cells->setFontWeight('bold');
});
$sheet->row(8, array('FECHA DE FACTURA', 'Nº DE FACTURA', 'Nº DE AUTORIZACIÓN', 'ESTADO', 'NIT/CI CLIENTE', 'NOMBRE O RAZÓN SOCIAL', 'IMPORTE TOTAL DE LA VENTA', 'IMPORTE ICE / IEHD / TASAS', 'EXPORTACIONES Y OPERACIONES EXENTAS', 'VENTAS GRAVADAS A TASA CERO', 'SUBTOTAL', 'DESC. BONIF. Y REBAJAS OTORGADAS', 'IMP. BASE PARA DÉBITO FISCAL', 'DÉBITO FISCAL', 'CÓDIGO DE CONTROL'));
$sheet->getStyle('A8:O' . $sheet->getHighestRow())->getAlignment()->setWrapText(true);
$sheet->cells('A8:O8', function ($cells) {
$cells->setFontWeight('bold');
$cells->setAlignment('center');
$cells->setValignment('middle');
});
$booksale = BookSale::select('invoice_date', 'invoice_number', 'number_autho', 'status', 'client_nit', 'client_name', 'amount', 'ice_amount', 'export_amount', 'grav_amount', 'subtotal', 'disc_bonus_amount', 'base_fiscal_debit_amount', 'fiscal_debit_amount', 'control_code')->where('account_id', '=', Auth::user()->account_id)->where('invoice_date', 'LIKE', '%' . $date)->orderBy('invoice_date', 'asc')->get();
$sheet->fromModel($booksale, null, 'A9', false, false);
});
})->download('xlsx');
}
}
