public function create_debit($id)
{
$enterprise = Enterprise::find($id);
$debit = DebitOrder::where('enterprise_id', $enterprise->id)->orderBy('fecha_debito', 'DESC')->first();
$now = date('Y-m-d H:m:s');
$debit_status = $this->status;
if ($debit) {
#existe un ultimo debito
$amount = SaleOrder::where('enterprise_id', $enterprise->id)->whereBetween('created_at', array($debit->created_at, $now))->sum('total');
$period = sprintf('%s - %s ', date("d/m/Y", strtotime($debit->created_at)), date("d/m/Y", strtotime($now)));
} else {
$last_payment = '0000-00-00 00:00:00';
$amount = SaleOrder::where('enterprise_id', $enterprise->id)->whereBetween('created_at', array($last_payment, $now))->sum('total');
$period = sprintf('Desde inicio hasta %s', date("d/m/Y", strtotime($now)));
}
return view('debits.create', compact('enterprise', 'debit_status', 'period', 'amount'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, SaleOrder::$rules);
$serial = str_pad(SaleOrder::count(), 6, '0', STR_PAD_LEFT);
$data = array_merge($request->all(), array('fecha_emision' => date('Y-m-d'), 'nro_orden' => $serial, 'enterprise_id' => Auth::user()->enterprise[0]->id));
$order = SaleOrder::create($data);
foreach ($request->input('products') as $p) {
$producto = new OrderProduct();
$producto->nombre = $p['nombre'];
$producto->cantidad = $p['cantidad'];
$producto->monto = $p['monto'];
$producto->total = $p['total'];
$producto->sale_order_id = $order->id;
$producto->save();
}
//echo "<pre>"; print_r($request->all()); echo "</pre>";
return redirect()->route('sale-point.orden-venta.create')->with('message', '<div class="alert alert-success" style="margin-top:15px">Orden creada con Éxito</div>');
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$sale_order = SaleOrder::findOrFail($id);
// $sale_order->fill($request->all());
if ($sale_order->status != 'cancel') {
$sale_order->status = "cancel";
$sale_order->save();
Session::flash('message', $sale_order->name . ' was canceled !');
return \Redirect::route('sales.index');
} else {
Session::flash('message', ' dont is possible cancel the sale order it was canceled!');
return redirect()->route('sales.index');
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$saleOrders = SaleOrder::where('id', $id)->first();
$products = SaleOrderDetail::whereSalesOrderId($id)->get();
if ($saleOrders->is_pos == 1) {
foreach ($products as $product) {
Inventory::wherePointOfSalesId($id)->delete();
$fields = ['product_id' => $product->product_id, 'location_id' => \Auth::user()->location];
$checkIfSaleExistingProduct = InventoryTotal::where($fields)->first();
$inventoryTotalDetail = $inventoryTotals = array();
$inventoryTotals = new InventoryTotal();
$inventoryTotal['total_qty'] = $checkIfSaleExistingProduct['total_qty'] + $product->qty * $product->conversion;
$inventoryTotal['created_by'] = \Auth::user()->id;
$inventoryTotal['updated_by'] = \Auth::user()->id;
$inventoryTotals->where($fields)->update($inventoryTotal);
$inventoryTotalDetails = new InventoryTotalDetail();
$fieldNews = ['product_id' => $product->product_id, 'location_id' => \Auth::user()->location, 'date' => date('Y-m-d')];
$checkIfSaleExistingProductInventoryDetail = InventoryTotalDetail::where($fieldNews)->first();
$inventoryTotalDetail['total_pos'] = $checkIfSaleExistingProductInventoryDetail['total_qty'] - $product->qty * $product->conversion;
$inventoryTotalDetail['created_by'] = \Auth::user()->id;
$inventoryTotalDetail['updated_by'] = \Auth::user()->id;
$inventoryTotalDetails->where($fieldNews)->update($inventoryTotalDetail);
}
} else {
Inventory::whereSalesOrderId($id)->delete();
}
SaleOrderReceipt::whereSalesOrderId($id)->delete();
SaleOrderDetail::whereSalesOrderId($id)->delete();
$saleOrders = SaleOrder::find($id);
$saleOrders->delete();
return Redirect::route('saleOrders.index')->with('flash_notice', 'You are successfully delete!');
}
public function printReceipt($sales_order_id, $footer)
{
$saleOrder = SaleOrder::where('sales_orders.id', $sales_order_id)->first();
$saleOrderReceipts = SaleOrderReceipt::where('sales_order_id', $sales_order_id)->get();
$saleOrderDetail = SaleOrderDetail::join('products', 'products.id', '=', 'sales_order_details.product_id')->whereSales_order_id($sales_order_id)->get();
return view('/layout/printReceipt', compact('saleOrderDetail', 'saleOrder', 'footer', 'saleOrderReceipts'));
}
public function create_payment($id)
{
$enterprise = Enterprise::find($id);
$payment = PaymentOrder::where('enterprise_id', $enterprise->id)->orderBy('fecha_pago', 'DESC')->first();
$now = date('Y-m-d');
$payments_methods = $this->payments_methods;
$payment_status = $this->payment_status;
if ($payment) {
//Existe el ultimo pago
$last_payment = $payment->fecha_pago;
$next_payment = date('Y-m-d', strtotime($last_payment . " + " . $payment->enterprise->plan->periodo->tiempo . " " . $payment->enterprise->plan->periodo->lapso));
if ($now >= $next_payment) {
//La fecha actual es igual o mayor a la del proximo pago
//hay que generar una orden de pago
if ($payment->enterprise->plan->costo > 0) {
//Cobro por plan
$to_pay = $payment->enterprise->plan->costo;
$last_order = '0000-00-00 00:00:00';
$period = sprintf('Pago mes: %s ', date("m/Y", strtotime($next_payment)));
} else {
//Cobro por porcentaje
//Monto entre la fecha de la ultima venta de la ultima orden de pago
//y la ultima venta del periodo a cobrar
$last_order = SaleOrder::where('enterprise_id', $enterprise->id)->orderBy('created_at', 'DESC')->first();
$amount = SaleOrder::where('enterprise_id', $enterprise->id)->whereBetween('created_at', array($payment->ultimo_corte, $last_order->created_at))->sum('total');
$to_pay = $amount * ($payment->enterprise->plan->porcentaje / 100);
$period = sprintf('%s - %s ', date("d/m/Y", strtotime($last_payment)), date("d/m/Y", strtotime($now)));
}
} else {
//Caso de uso para cuando no hay que generar orden de pago
//es decir no se ha cumplido el periodo de pago del plan
return redirect()->route('admin.pagos.listado', $id)->with('message', '<div class="alert alert-warning" style="margin-top:15px">No hay pagos pendientes por facturar</div>');
}
} else {
//Primera vez que la empresa paga
if ($enterprise->plan->costo > 0) {
//Cobro por plan
$to_pay = $enterprise->plan->costo;
$last_order = '0000-00-00 00:00:00';
$period = sprintf('Primer pago %s', date("m/Y", strtotime($now)));
} else {
//Cobro por porcentaje
//Monto entre la fecha de la ultima venta de la ultima orden de pago
//y la ultima venta del periodo a cobrar
$last_order = SaleOrder::where('enterprise_id', $enterprise->id)->orderBy('created_at', 'DESC')->first();
$amount = SaleOrder::where('enterprise_id', $enterprise->id)->whereBetween('created_at', array('0000-00-00 00:00:00', $last_order->created_at))->sum('total');
$to_pay = $amount * ($enterprise->plan->porcentaje / 100);
$period = sprintf('Desde inicio hasta %s', date("d/m/Y", strtotime($now)));
}
}
$description = sprintf('%s: %s %s', $enterprise->plan->nombre, $enterprise->plan->tiempo_membresia, $this->tiempo[$enterprise->plan->unidad_tiempo]);
return view('payments.create', compact('enterprise', 'payments_methods', 'payment_status', 'period', 'to_pay', 'last_order', 'description'));
}
