/**
* Function that pays tab with a cash transaction.
*
* @return Response
*/
public function payBill()
{
// Validate Input.
$validator = Validator::make(Input::all(), array('items' => 'required', 'institution' => 'required', 'discount' => 'required', 'card' => 'required', 'credit' => 'required', 'authCode' => 'required'));
$response = array();
if ($validator->fails()) {
$response['state'] = 'Error';
$response['error'] = 'No se proporciono toda la informacion necesaria para realizar transaccion!';
return response()->json($response);
}
// Check that user is part of authorized staff.
if (Auth::user()->Type != 1) {
// If they are unauthorized no point in returning anything.
return response()->json(array());
}
// Get user branch.
$worker = Worker::find(Auth::user()->TypeId);
$userBranch = $worker->BranchId;
$branch = Branch::find($userBranch);
$salePrice = 0;
// Get the cashbox.
$cashbox = Cashbox::where('UserId', '=', Auth::user()->Id)->where('Close', '=', NULL)->first();
// Check that we actually have a cashbox open.
if (!$cashbox) {
$response['state'] = 'Error';
$response['error'] = 'La caja no esta abierta o por lo tanto no se puede realizar la transaccion!';
return response()->json($response);
}
// Check discount is not greater than what user is allowed.
$permissions = json_decode(UserLevel::find(Auth::user()->UserLevel)->Permissions);
if (Input::get('discount') > $permissions->permissions->sales->discount->limit) {
// Check if we have an auth code we can use.
if (Input::get('authCode') == 0) {
$response['state'] = 'Error';
$response['error'] = 'No tiene permiso para otorgar este descuento!';
return response()->json($response);
}
$request = Request::find(Input::get('authCode'));
if ($request->Used == 1) {
$response['state'] = 'Error';
$response['error'] = 'No tiene permiso para otorgar este descuento!';
return response()->json($response);
}
if ($request->Amount != Input::get('discount')) {
$response['state'] = 'Error';
$response['error'] = 'No tiene permiso para otorgar este descuento!';
return response()->json($response);
}
$request->Used = 1;
$request->save();
}
// Get client.
$client = Client::where('Cedula', '=', Input::get('client'))->first();
// Get institution if defined.
$institution;
if (Input::get('institution') != 0) {
$institution = Institution::find(Input::get('institution'));
if (!$institution) {
$response['state'] = 'Error';
$response['error'] = 'La institucion definida no fue encontrada en el sistema!';
return response()->json($response);
}
}
// Loop through all items.
$items = json_decode(Input::get('items'));
foreach ($items as $code => $info) {
// Check if it is a product.
$product = Stock::where('Code', '=', $code)->where('BranchId', '=', $userBranch)->first();
if (!$product) {
// Check if it is a service.
$service = Service::where('Code', '=', $code)->where('BranchId', '=', $userBranch)->first();
if (!$service) {
$response['state'] = 'Error';
$response['error'] = 'No se reconocio uno de los productos o servicios!';
return response()->json($response);
}
// Make sure there are enough materials in system and withdraw them.
$materials = json_decode($service->Materials);
foreach ($materials as $materialCode => $quantity) {
$stock = Stock::where('Code', '=', $materialCode)->where('BranchId', '=', $userBranch)->first();
// If we have enough in stock withdraw it.
if ($stock->Quantity >= $quantity * $info->quantity) {
$stock->Quantity -= $quantity * $info->quantity;
$stock->save();
} else {
// Return all items and materials withdrawn so far.
$this->returnItems($items, $code);
$response['state'] = 'Error';
$response['error'] = 'No hay suficientes materiales o productos!';
return response()->json($response);
}
}
// Add price to total of factura.
$salePrice += $service->Price * $info->quantity;
// TODO: Check if any special functions need to be executed.
} else {
// Check quantity being taken is not greater than existing quantity in system.
if ($product->Quantity >= $info->quantity) {
// Reduce products from stock.
$product->Quantity -= $info->quantity;
$product->save();
} else {
// Return all items and materials withdrawn so far.
$this->returnItems($items, $code);
$response['state'] = 'Error';
$response['error'] = 'No hay suficientes materiales o productos!';
return response()->json($response);
}
// Add price to total of factura.
$salePrice += $product->Price * $info->quantity;
}
}
$subTotal = $salePrice;
$discount = $salePrice * (Input::get('discount') / 100);
// Give discount.
$salePrice = $salePrice * (1 - Input::get('discount') / 100);
// Calculate tax if required.
$tax = 0;
if (json_decode($branch->DefaultExpenses)->regimen == 'cuotageneral') {
if (Input::get('institution') != 0) {
if (!$institution->Excempt) {
$tax = $salePrice * 0.15;
}
} else {
if (!$client || !$client->Excempt) {
$tax = $salePrice * 0.15;
}
}
}
// Save client information.
$clientInfo = array();
if (Input::get('institution') != 0) {
// Save institution information.
$clientInfo = array('Name' => $institution->Name, 'Address' => $institution->Address, 'Id' => $institution->RUC);
} else {
// Save institution information.
if ($client) {
$clientInfo = array('Name' => $client->Name, 'Address' => $client->Address, 'Id' => $client->Cedula);
}
}
// Check if credit that creditor has enough credit available,
// otherwise check that enough cash is being paid.
$change = 0;
if (Input::get('credit') == 1) {
if (Input::get('institution') != 0) {
// Get institution debt.
$debt = 0;
$pendingBills = Sale::where('CreditorId', '=', $institution->Id)->where('CreditorType', '=', 2)->where('Cancelled', '=', false)->get();
foreach ($pendingBills as $pendingBill) {
$debt += $pendingBill->Value + $pendingBill->Tax;
}
// Check they have enough credit available.
if ($debt + $salePrice + $tax > $institution->CreditLimit) {
$this->returnItems($items, '');
$response['state'] = 'Error';
$response['error'] = 'Esta institucion no tiene suficiente credito disponible para cancelar esta factura!';
return response()->json($response);
}
} else {
if (!$client) {
$response['state'] = 'Error';
$response['error'] = 'No se definio un cliente para asignar factura a credito!';
return response()->json($response);
}
// Get client debt.
$debt = 0;
$pendingBills = Sale::where('CreditorId', '=', $client->Id)->where('CreditorType', '=', 1)->where('Cancelled', '=', false);
foreach ($pendingBills as $pendingBill) {
$debt += $pendingBill->Value + $pendingBill->Tax;
}
// Check they have enough credit available.
if ($debt + $salePrice + $tax > $client->CreditLimit) {
$this->returnItems($items, '');
$response['state'] = 'Error';
$response['error'] = 'Este cliente no tiene suficiente credito disponible para cancelar esta factura!';
return response()->json($response);
}
}
} else {
// Check enough cash is being paid.
$change = Input::get('cash') - ($salePrice + $tax);
if ($change < 0) {
$this->returnItems($items, '');
$response['state'] = 'Error';
$response['error'] = 'Debe pagar con un valor igual o mayor al costo de lo facturado!';
return response()->json($response);
}
}
// Make cashbox transaction.
$transaction;
if (Input::get('credit') == 1) {
$transaction = CashboxTransaction::create(array('CashboxId' => $cashbox->Id, 'DateTime' => date('Y-m-d H:i:s'), 'Type' => 10, 'Amount' => $salePrice + $tax, 'Reason' => 'Venta de Credito.'));
} else {
$transaction = CashboxTransaction::create(array('CashboxId' => $cashbox->Id, 'DateTime' => date('Y-m-d H:i:s'), 'Type' => 1, 'Amount' => $salePrice + $tax, 'Reason' => 'Venta.'));
}
// Make sale.
$card = 0;
if (Input::get('card') != 0) {
$config = Configuration::find(0);
$card = $salePrice * ($config->POS / 100);
}
$sale;
$type = 'contado';
if (Input::get('credit') == 1) {
$type = 'credito';
if (Input::get('institution') != 0) {
// Creditor Type 1 = Client, 2 = Institution.
$sale = Sale::create(array('WorkerId' => $worker->Id, 'Value' => $salePrice, 'Tax' => $tax, 'Card' => $card, 'TransactionId' => $transaction->Id, 'BranchId' => $userBranch, 'Credit' => 1, 'CreditorId' => Input::get('institution'), 'CreditorType' => 2, 'Cancelled' => 0));
} else {
$sale = Sale::create(array('WorkerId' => $worker->Id, 'Value' => $salePrice, 'Tax' => $tax, 'Card' => $card, 'TransactionId' => $transaction->Id, 'BranchId' => $userBranch, 'Credit' => 1, 'CreditorId' => $client->Id, 'CreditorType' => 1, 'Cancelled' => 0));
}
} else {
if (Input::get('institution') != 0) {
// Creditor Type 1 = Client, 2 = Institution.
$sale = Sale::create(array('WorkerId' => $worker->Id, 'Value' => $salePrice, 'Tax' => $tax, 'Card' => $card, 'TransactionId' => $transaction->Id, 'BranchId' => $userBranch, 'Credit' => 0, 'CreditorId' => Input::get('institution'), 'CreditorType' => 2, 'Cancelled' => 1));
} else {
if (!$client) {
$sale = Sale::create(array('WorkerId' => $worker->Id, 'Value' => $salePrice, 'Tax' => $tax, 'Card' => $card, 'TransactionId' => $transaction->Id, 'BranchId' => $userBranch, 'Credit' => 0, 'CreditorId' => 0, 'CreditorType' => 1, 'Cancelled' => 1));
} else {
$sale = Sale::create(array('WorkerId' => $worker->Id, 'Value' => $salePrice, 'Tax' => $tax, 'Card' => $card, 'TransactionId' => $transaction->Id, 'BranchId' => $userBranch, 'Credit' => 0, 'CreditorId' => $client->Id, 'CreditorType' => 1, 'Cancelled' => 1));
}
}
}
// Now add sales breakdown.
foreach ($items as $code => $info) {
// Check if product.
$product = Stock::where('Code', '=', $code)->where('BranchId', '=', $userBranch)->first();
if (!$product) {
// Get service cost.
$service = Service::where('Code', '=', $code)->where('BranchId', '=', $userBranch)->first();
$materials = json_decode($service->Materials);
$cost = 0;
foreach ($materials as $materialCode => $quantity) {
$material = Stock::where('Code', '=', $materialCode)->where('BranchId', '=', $userBranch)->first();
$cost += $material->AverageCost * $quantity;
}
SaleBreakdown::create(array('SaleId' => $sale->Id, 'Code' => $code, 'Quantity' => $info->quantity, 'Cost' => $cost, 'Price' => $service->Price));
} else {
SaleBreakdown::create(array('SaleId' => $sale->Id, 'Code' => $code, 'Quantity' => $info->quantity, 'Cost' => $product->AverageCost, 'Price' => $product->Price));
}
}
// Return success message and bill information.
$response['state'] = 'Success';
$response['change'] = $change;
$response['billInfo'] = array('SubTotal' => $subTotal, 'Discount' => $discount, 'Tax' => $tax, 'Total' => $salePrice + $tax, 'SaleId' => $sale->Id, 'Date' => date('d/m/Y'), 'Type' => $type);
$response['clientInfo'] = $clientInfo;
$response['total'] = $salePrice + $tax;
return response()->json($response);
}
case 9:
$sales += $transaction->Amount;
$cash += $transaction->Amount;
break;
case 10:
$creditSales += $transaction->Amount;
$sales += $transaction->Amount;
break;
}
}
$sold = array();
// Get only sales transactions.
foreach (CashboxTransaction::where('CashboxId', '=', $cashbox->Id)->where('Type', '=', 1)->get() as $transaction) {
foreach (Sale::where('TransactionId', '=', $transaction->Id)->get() as $sale) {
// Go through sale breackdown.
foreach (SaleBreakdown::where('SaleId', '=', $sale->Id)->get() as $salebreakdown) {
// Extract Product or Service.
// TODO: Get only stock from user's branch.
$product = Stock::where('Code', '=', $salebreakdown->Code)->first();
if ($product) {
// Check if we have already sold this product.
if (array_key_exists($product->Code, $sold)) {
$sold[$salebreakdown->Code]['Quantity'] += $salebreakdown->Quantity;
} else {
$sold[$salebreakdown->Code] = array('Description' => $product->Description, 'Quantity' => $salebreakdown->Quantity);
}
} else {
$service = Service::where('Code', '=', $salebreakdown->Code)->first();
if ($service) {
// Check if we have already sold this service.
if (array_key_exists($service->Code, $sold)) {
/**
* Function that generates order.
*
* @return Response
*/
public function aiOrder()
{
// Get all branches.
$branches = Branch::all();
// Get all providers.
$providers = Provider::where('AIManaged', '=', true)->get();
// Prepare order array.
$order = array();
// Loop through providers.
foreach ($providers as $provider) {
$order[$provider->Id] = array();
// Get all products.
$products = Stock::where('Provider', '=', $provider)->get();
foreach ($products as $product) {
$order[$provider->Id][$product->Code][$provider->BranchId] = array('Code' => $product->Code, 'Description' => $product->Description, 'Exist' => $product->Quantity, 'Cost' => $product->Cost, 'Minimum' => $product->Minimum, 'Order' => 0, 'Average' => 0, 'Sold' => 0);
}
// Get all the products sold in selected sample range.
$today = date('Y-m-d H:i:s');
switch ($provider->SampleRange) {
case '1week':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 604800);
$sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 7;
}
break;
case '2week':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 1209600);
$sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 14;
}
break;
case '1month':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 2419200);
$sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 30;
}
break;
case '3month':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 7257600);
$sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 90;
}
break;
case '1year':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 29030400);
$sales = Sale::where('BranchId', '=', $branchId)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 365;
}
break;
}
}
// Now calculate amount to order based on average, existence, minimum and order range.
switch (Input::get('orderRange')) {
case '3day':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 3;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = round($estimatedOrder);
}
break;
case '1week':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 7;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = round($estimatedOrder);
}
break;
case '2week':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 14;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = round($estimatedOrder);
}
break;
case '1month':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 30;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = round($estimatedOrder);
}
break;
case '3month':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 90;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = round($estimatedOrder);
}
break;
}
// Check if we have recently made an order for this provider to fix order.
$aiOrders = AIOrder::where('GenerationDate', '>', date('Y-m-d H:i:s', strtotime($today) - 259200))->where('Received', '=', false)->get();
foreach ($aiOrders as $o) {
// Get breakdown and remove quantity from order.
$breakdown = AIOrderBreakdown::where('AIOrderId', '=', $o->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Order'] -= $item->Quantity;
}
}
}
$order = AIOrder::findOrFail(1);
$breakdown = AIOrderBreakdown::where('AIOrderId', '=', $order->Id)->get();
// Ship order...
Mail::send('emails.ai.makeOrder', ['order' => $order, 'breakdown' => $breakdown], function ($message) {
$message->to('*****@*****.**');
$message->subject('Orden de Compra');
});
$response['state'] = 'Success';
$response['message'] = 'Servicio eliminado exitosamente!';
return response()->json($response);
}
/**
* Function that uses a reservation. It creates a transaction for the remainder of the money and makes the sale.
*
* @return Response
*/
public function useReservation()
{
// Validate Input.
$validator = Validator::make(Input::all(), array('id' => 'required'));
if ($validator->fails()) {
return response()->json(['error' => 'No se recibieron los datos necesarios!']);
}
// Check that user is part of authorized staff.
if (Auth::user()->Type != 1) {
$response['state'] = 'No Autorizado';
$response['error'] = 'Usuario no autorizado!';
return response()->json($response);
}
// Get user branch.
$worker = Worker::find(Auth::user()->TypeId);
$userBranch = $worker->BranchId;
$salePrice = 0;
// Get the cashbox.
$cashbox = Cashbox::where('UserId', '=', Auth::user()->Id)->where('Close', '=', NULL)->first();
// Check that we actually have a cashbox open.
if (!$cashbox) {
$response['state'] = 'Error';
$response['error'] = 'La caja no esta abierta o por lo tanto no se puede realizar la transaccion!';
return response()->json($response);
}
// Get the reservation.
$reservation = Reservation::find(Input::get('id'));
// Make sure the reservation hasn't been used yet.
if ($reservation->State == 'used' || $reservation->State == 'credit') {
$response['state'] = 'Error';
$response['error'] = 'Esta reservacion ya ha sido utilizada!';
return response()->json($response);
}
// Now make sure the reservation hasn't been deleted.
if ($reservation->State == 'delete') {
$response['state'] = 'Error';
$response['error'] = 'Esta reservacion fue eliminada!';
return response()->json($response);
}
// Now make sure the reservation hasn't expired.
if ($reservation->State == 'late') {
$response['state'] = 'Error';
$response['error'] = 'Esta reservacion ya ha expirado!';
return response()->json($response);
}
// Get the reservation breakdown.
$reservationBreakdown = ReservationBreakdown::where('ReservationId', '=', Input::get('id'))->get();
// Loop through all items.
foreach ($reservationBreakdown as $breakdown) {
// Check if it is a product.
$product = Stock::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $userBranch)->first();
if (!$product) {
// Check if it is a service.
$service = Service::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $userBranch)->first();
if (!$service) {
$response['state'] = 'Error';
$response['error'] = 'No se reconocio uno de los productos o servicios!';
return response()->json($response);
}
// Make sure there are enough materials in system and withdraw them.
$materials = json_decode($service->Materials);
foreach ($materials as $materialCode => $quantity) {
$stock = Stock::where('Code', '=', $materialCode)->where('BranchId', '=', $userBranch);
// If we have enough in stock withdraw it.
if ($stock->Quantity >= $quantity * $breakdown->Quantity) {
$stock->Quantity -= $quantity * $breakdown->Quantity;
$stock->save();
} else {
// Return all items and materials withdrawn so far.
$this->returnItems($reservationBreakdown, $breakdown->Code);
$response['state'] = 'Error';
$response['error'] = 'No hay suficientes materiales o productos!';
return response()->json($response);
}
}
// TODO: Check if any special functions need to be executed.
} else {
// Check quantity being taken is not greater than existing quantity in system.
if ($product->Quantity >= $breakdown->Quantity) {
// Reduce products from stock.
$product->Quantity -= $breakdown->Quantity;
$product->save();
} else {
// Return all items and materials withdrawn so far.
$this->returnItems($reservationBreakdown, $breakdown->Code);
$response['state'] = 'Error';
$response['info'] = $breakdown;
$response['product'] = $product;
$response['error'] = 'No hay suficientes materiales o productos!';
return response()->json($response);
}
}
}
// Make transaction for remaining reservation debt.
$transaction = CashboxTransaction::create(array('CashboxId' => $cashbox->Id, 'DateTime' => date('Y-m-d H:i:s'), 'Type' => 1, 'Amount' => $reservation->Value + $reservation->Tax - $reservation->Discount - $reservation->Deposit, 'Reason' => 'Venta con Reservacion.'));
// Make sale.
$sale;
// TODO: Payment can also be with credit card.
$sale = Sale::create(array('WorkerId' => $worker->Id, 'Value' => $reservation->Value - $reservation->Discount, 'Tax' => $reservation->Tax, 'Card' => false, 'TransactionId' => $transaction->Id, 'BranchId' => $userBranch, 'Credit' => 0, 'CreditorId' => $reservation->CreditorId, 'CreditorType' => $reservation->CreditorType, 'Cancelled' => 1));
// Now add sales breakdown.
foreach ($reservationBreakdown as $breakdown) {
// Check if product.
$product = Stock::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $userBranch)->first();
if (!$product) {
// Get service cost.
$service = Service::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $userBranch)->first();
$materials = json_decode($service->Materials);
$cost = 0;
foreach ($materials as $materialCode => $quantity) {
$material = Stock::where('Code', '=', $materialCode)->where('BranchId', '=', $userBranch)->first();
$cost += $material->AverageCost * $quantity;
}
SaleBreakdown::create(array('SaleId' => $sale->Id, 'Code' => $breakdown->Code, 'Quantity' => $breakdown->Quantity, 'Cost' => $cost * $breakdown->Quantity, 'Price' => $breakdown->Price));
} else {
SaleBreakdown::create(array('SaleId' => $sale->Id, 'Code' => $breakdown->Code, 'Quantity' => $breakdown->Quantity, 'Cost' => $product->AverageCost * $breakdown->Quantity, 'Price' => $breakdown->Price));
}
}
// Now update the reservation.
$reservation->State = 'used';
$reservation->save();
$response['state'] = 'Success';
$response['saleId'] = $sale->Id;
// Return response.
return response()->json($response);
}
/**
* Function that scans a sale and adds a bonus to selected worker if necessary.
*
* @return Response
*/
public function scanSale()
{
// Validate Input.
$validator = Validator::make(Input::all(), array('staffId' => 'required', 'saleId' => 'required'));
if ($validator->fails()) {
$response['state'] = 'Error';
$response['error'] = 'Debe cargar al trabajador!';
return response()->json($response);
}
// Check that user is part of authorized staff.
if (Auth::user()->Type != 1) {
// If they are unauthorized no point in returning anything.
return response()->json(array());
}
// Get the worker of given Id.
$response = array();
$worker = Worker::where('Cedula', '=', Input::get('staffId'))->first();
if ($worker) {
// Check if this worker should get a bonus from this.
if ($worker->BonusSource != 'productionexclusive' && $worker->BonusSource != 'productionsinglecustom') {
$response['state'] = 'Error';
$response['error'] = 'Este trabajador no puede ser asignado bonos por facturas.';
return response()->json($response);
}
// Get today's day.
$todaySalary = WorkerSalary::where('WorkerId', '=', $worker->Id)->where('Date', '=', date('Y-m-d'))->first();
if (!$todaySalary) {
$response['state'] = 'Error';
$response['error'] = 'El trabajador no ha sido agregado en la planilla del dia de hoy!';
return response()->json($response);
}
// Get the sale.
$sale = Sale::find(Input::get('saleId'));
if (!$sale) {
$response['state'] = 'Error';
$response['error'] = 'Venta Inexistente!';
return response()->json($response);
}
// Get the breakdown.
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $b) {
// Check that this sale breakdown has not been used already.
$extraData = json_decode($b->ExtraData, true);
if (is_array($extraData) && array_key_exists('workerId', $extraData)) {
// Get the worker.
$worker = Worker::find($extraData['workerId']);
$response['state'] = 'Error';
$response['error'] = 'Esta factura ha sido asignada a ' . $worker->Name . '!';
return response()->json($response);
}
$product = Stock::where('Code', '=', $b->Code)->where('BranchId', '=', $sale->BranchId)->first();
if ($product) {
$todaySalary->Bonus += $product->Bonus;
$todaySalary->save();
} else {
$service = Service::where('Code', '=', $b->Code)->where('BranchId', '=', $sale->BranchId)->first();
$todaySalary->Bonus += $service->Bonus;
$todaySalary->save();
}
// Add extra data to breakdown.
$extraData['workerId'] = $worker->Id;
$b->ExtraData = json_encode($extraData);
$b->save();
}
// Return response.
$response['state'] = 'Success';
$response['message'] = 'Factura agregada exitosamente!';
return response()->json($response);
} else {
$response['state'] = 'Error';
$response['error'] = 'Trabajador Inexistente!';
return response()->json($response);
}
}
/**
* Function that searches for past trips.
*
* @return Response
*/
public function searchVehicleTrips()
{
// Validate Input.
$validator = Validator::make(Input::all(), array('vehicle' => 'required', 'start' => 'required', 'end' => 'required'));
if ($validator->fails()) {
return response()->json(['error' => 'Informacion incompleta!']);
}
// Check that user is part of authorized staff.
if (Auth::user()->Type != 1) {
// If they are unauthorized no point in returning anything.
return response()->json(array());
}
// Get trips.
$start = date('Y-m-d', strtotime(Input::get('start')));
$end = date('Y-m-d', strtotime(Input::get('end')));
$trips = Transport::where('VehicleId', '=', Input::get('vehicle'))->where('Date', '>=', $start)->where('Date', '<=', $end)->where('State', '=', 1)->groupBy('Date')->orderBy('Order')->get();
$tripData = array();
foreach ($trips as $trip) {
$driver = Worker::find($trip->DriverId);
$reason = '';
switch ($trip->Type) {
case 1:
// Get sale breakdown.
$breakdown = SaleBreakdown::find($trip->ReasonId);
// Get product or service.
$product = Stock::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $driver->BranchId)->first();
if ($product) {
$reason = 'Venta de ' . $product->Description;
} else {
$service = Service::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $driver->BranchId)->first();
$reason = 'Venta de ' . $service->Description;
}
break;
case 2:
// Get sale.
$sale = Sale::find($trip->ReasonId);
// Get client or institution.
if ($sale->CreditorType == 1) {
if ($sale->CreditorId == 0) {
$reason = 'Venta a cliente no definido';
} else {
$client = Client::find($sale->CreditorId);
$reason = 'Venta a ' . $client->Name;
}
} else {
$institution = Institution::find($sale->CreditorId);
$reason = 'Venta a ' . $institution->Name;
}
break;
case 3:
// Get order breakdown.
$breakdown = OrderBreakdown::find('OrderId', '=', $trip->ReasonId);
// Get product or service.
$product = Stock::where('Code', '=', $breakdown->Code)->where('BranchId', '=', $driver->BranchId)->first();
$reason = 'Produccion de ' . $product->Description;
break;
case 4:
// Get order.
$order = Order::find($trip->ReasonId);
// Get client or institution.
$client = Client::find($order->ClientId);
if ($client->InstitutionId == 0) {
$reason = 'Orden de Produccion de ' . $client->Name;
} else {
$institution = Institution::find($client->InstitutionId);
$reason = 'Orden de Produccion de ' . $institution->Name;
}
break;
case 5:
// Get storage request.
$request = StorageRequest::find($trip->ReasonId);
$reason = $request->Reason;
break;
case 6:
// Get visit.
$visit = Visit::find($trip->ReasonId);
$reason = 'Visita ' . $visit->Result;
break;
case 7:
// Get credit bill.
$creditBill = Sale::find($trip->ReasonId);
$reason = 'Cobro de Facturo: ' . $creditBill->Id;
break;
case 8:
// Contract Payment.
$contract = Contract::find($trip->ReasonId);
$reason = 'Cobro de Contrato: ' . $contract->Code;
break;
case 9:
// Provider purchase.
$aiOrder = AIOrder::find($trip->ReasonId);
$reason = 'Compra automatica ' . $aiOrder->Id;
break;
case 10:
$reason = 'Generado por usuario.';
break;
}
array_push($tripData, array('Id' => $trip->Id, 'Date' => $trip->Date, 'Driver' => $driver->Name, 'Reason' => $reason, 'Distance' => $trip->Distance, 'Journey' => json_decode($trip->Journey, true), 'StartLat' => $trip->StartLatitude, 'StartLon' => $trip->StartLongitude, 'EndLat' => $trip->EndLatitude, 'EndLon' => $trip->EndLongitude));
}
$response['state'] = 'Success';
$response['trips'] = $tripData;
return response()->json($response);
}
use App\CashReceipt;
use App\Client;
use App\Institution;
$currentNotification = Notification::find($notification);
$currentNotification->Seen = true;
$currentNotification->save();
$permissions = json_decode(UserLevel::find(Auth::user()->UserLevel)->Permissions);
$debt = Sale::find($id);
$totalDebt = $debt->Value + $debt->Tax;
// Check to see if there have been any previous payments.
$pastPaymentTotal = 0;
$payments = CashReceipt::where('Type', '=', 2)->where('TypeId', '=', $debt->Id)->get();
foreach ($payments as $payment) {
$pastPaymentTotal += $payment->Value;
}
$salebreakdown = SaleBreakdown::where('SaleId', '=', $debt->Id)->get();
$creditor = null;
if ($debt->CreditorType == 1) {
$creditor = Client::find($debt->CreditorId);
} else {
$creditor = Institution::find($debt->CreditorId);
}
$branchId = Worker::find(Auth::user()->TypeId)->BranchId;
$branch = Branch::find($branchId);
$subtotal = 0;
$regimen = json_decode($branch->DefaultExpenses)->regimen;
?>
<!DOCTYPE html>
<html lang="es">
<head>
<title>Eirene Systema Administrativo</title>
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
// Get providers.
$providers = Provider::all();
// Get the branches.
$branches = Branch::all();
// Loop through them and check which ones are set to auto order.
foreach ($providers as $provider) {
if ($provider->AIManaged) {
foreach ($branches as $branch) {
// Now let's get all the products for this provider.
$products = Stock::where('BranchId', '=', $branch->Id)->where('ProviderId', '=', $provider->Id)->get();
$order = array();
foreach ($products as $product) {
if ($product->Quantity <= $product->Minimum) {
$order[$product->Code] = array('Code' => $product->Code, 'Description' => $product->Description, 'Exist' => $product->Quantity, 'Cost' => $product->Cost, 'Minimum' => $product->Minimum, 'Order' => 0, 'Average' => 0, 'Sold' => 0);
}
}
// Get all the products sold in selected sample range.
$today = date('Y-m-d H:i:s');
switch ($provider->SampleRange) {
case '1week':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 604800);
$sales = Sale::where('BranchId', '=', $branch->Id)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 7;
}
break;
case '2week':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 1209600);
$sales = Sale::where('BranchId', '=', $branch->Id)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 14;
}
break;
case '1month':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 2419200);
$sales = Sale::where('BranchId', '=', $branch->Id)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 30;
}
break;
case '3month':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 7257600);
$sales = Sale::where('BranchId', '=', $branch->Id)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 90;
}
break;
case '1year':
$startDate = date('Y-m-d H:i:s', strtotime($today) - 29030400);
$sales = Sale::where('BranchId', '=', $branch->Id)->where('Created', '>=', $startDate)->where('Created', '<=', $today)->get();
foreach ($sales as $sale) {
$breakdown = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Sold'] += $item->Quantity;
}
}
}
// Now calculate average of each product.
foreach ($order as $index => $product) {
$order[$index]['Average'] = $product['Sold'] / 365;
}
break;
}
// Now calculate amount to order based on average, existence, minimum and order range.
switch ($provider->OrderRange) {
case '3day':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 3;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = ceil($estimatedOrder);
}
break;
case '1week':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 7;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = ceil($estimatedOrder);
}
break;
case '2week':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 14;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = ceil($estimatedOrder);
}
break;
case '1month':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 30;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = ceil($estimatedOrder);
}
break;
case '3month':
foreach ($order as $index => $product) {
$estimatedOrder = $product['Average'] * 90;
// Order should be at least twice minimum required with existence influded.
if ($estimatedOrder + $product['Exist'] < $product['Minimum'] * 2) {
$estimatedOrder = $product['Minimum'] * 2;
}
$order[$index]['Order'] = ceil($estimatedOrder);
}
break;
}
// Check if we have recently made an order for this provider to fix order.
$aiOrders = AIOrder::where('GenerationDate', '>', date('Y-m-d H:i:s', strtotime($today) - 259200))->where('Received', '=', false)->where('BranchId', '=', $branch->Id)->get();
foreach ($aiOrders as $o) {
// Get breakdown and remove quantity from order.
$breakdown = AIOrderBreakdown::where('AIOrderId', '=', $o->Id)->get();
foreach ($breakdown as $item) {
if (array_key_exists($item->Code, $order)) {
$order[$item->Code]['Order'] -= $item->Quantity;
}
}
}
// Check if we have anything to order.
$sendOrder = false;
foreach ($order as $item) {
if ($item['Order'] > 0) {
$sendOrder = true;
}
}
if (!$sendOrder) {
return 1;
}
// Generate Order.
$aiOrder = AIOrder::create(array('GenerationDate' => date('Y-m-d H:i:s'), 'ConfirmationDate' => '0000-00-00 00:00:00', 'ProviderId' => $provider->Id, 'BranchId' => $branch->Id, 'Received' => false, 'EstimatedDelivery' => date('Y-m-d', strtotime("+3 days"))));
foreach ($order as $item) {
AIOrderBreakdown::create(array('AIOrderId' => $aiOrder->Id, 'Code' => $item['Code'], 'Quantity' => $item['Order']));
}
$breakdown = AIOrderBreakdown::where('AIOrderId', '=', $aiOrder->Id)->get();
// Now if the provider has delivery send email with order.
if ($provider->Delivery) {
// Now check what method we will use to make order.
if ($provider->Method == 'email') {
try {
Mail::send('emails.ai.makeOrder', ['order' => $aiOrder, 'breakdown' => $breakdown], function ($message) use($provider, $aiOrder) {
$message->to($provider->Email);
$message->subject('Orden de Compra: ' . $aiOrder->Id);
});
} catch (\Exception $e) {
// In this case we should let an administrator know that the email order failed.
$users = User::where('UserLevel', '=', 1)->get();
foreach ($users as $admin) {
Notification::create(array('UserId' => $admin->Id, 'Created' => date('Y-m-d H:i:s'), 'Reason' => 'Aergia no fue capaz de organizar un pedido via correo para ' . $provider->Name . '. Por favor revisar orden y organizar su compra.', 'Url' => '/ai/order/' . $aiOrder->Id, 'Seen' => false));
}
}
} else {
if ($provider->Method == 'ai') {
// TODO: Establish Contact via AI.
}
}
} else {
// If the provider doesn't have delivery program a trip to make purchase.
$vehicles = Vehicle::where('BranchId', '=', $branch->Id)->where('Repair', '=', false)->get();
$vehicle = null;
foreach ($vehicles as $v) {
if (!$vehicle) {
$vehicle = $v;
}
// In this case the bigger the vehicle the more suitable it should be.
// TODO: This could be improved.
if ($v->Type > $vehicle->Type) {
$vehicle = $v;
}
}
if (!$vehicle) {
// In this case we don't have a vehicle and the provider doesn't provide delivery so we must notify an administrator.
$users = User::where('UserLevel', '=', 1)->get();
foreach ($users as $admin) {
Notification::create(array('UserId' => $admin->Id, 'Created' => date('Y-m-d H:i:s'), 'Reason' => 'Aergia no fue capaz de organizar un pedido a para ' . $provider->Name . '. Por favor revisar orden y organizar su compra.', 'Url' => '/ai/order/' . $aiOrder->Id, 'Seen' => false));
}
} else {
// Get location of provider.
$location = Location::find($provider->LocationId);
$transport = Transport::create(array('Date' => date('Y-m-d', strtotime("+1 day")), 'Time' => '00:00:00', 'VehicleId' => $vehicle->Id, 'DriverId' => 0, 'StartLatitude' => 0, 'StartLongitude' => 0, 'Journey' => '[]', 'EndLatitude' => $location->Latitude, 'EndLongitude' => $location->Longitude, 'EndAddress' => $provider->Address, 'Distance' => 0, 'ReasonId' => $aiOrder->Id, 'Type' => 9, 'State' => 2, 'Order' => 0, 'Depreciation' => 0));
// Update Estimated Delivery Date.
$aiOrder->EstimatedDelivery = date('Y-m-d', strtotime("+1 day"));
$aiOrder->save();
}
}
}
}
}
}
/**
* Function that deletes Transaction.
*
* @return Response
*/
public function deleteAuthenticated()
{
// Validate Input.
$validator = Validator::make(Input::all(), array('id' => 'required'));
$response = array();
if ($validator->fails()) {
$response['state'] = 'Error';
$response['error'] = 'La identification de la transaccion es necesaria!';
return response()->json($response);
}
// Check that user is part of authorized staff.
if (Auth::user()->Type != 1) {
$response['state'] = 'No Autorizado';
$response['error'] = 'Usuario no autorizado!';
return response()->json($response);
}
// Verify the user first.
$userToVerify = User::where('Username', '=', Input::get('username'))->first();
if (!$userToVerify) {
$response['state'] = 'Error';
$response['error'] = 'Este usuario no existe!';
return response()->json($response);
}
if (Auth::validate(array('Username' => Input::get('username'), 'password' => Input::get('password') . $userToVerify->Salt, 'Type' => 1))) {
// If user was verified make sure user has permission to withdraw money.
$permissions = json_decode(UserLevel::find($userToVerify->UserLevel)->Permissions);
if ($permissions->permissions->cashbox->delete->can != "true") {
$response['state'] = 'Error';
$response['d'] = $permissions->permissions->cashbox->delete->can;
$response['error'] = 'Este usuario no tiene permitido eliminar transacciones!';
return response()->json($response);
}
} else {
$response['state'] = 'Error';
$response['error'] = 'Usuario o contraseña incorrectos!';
return response()->json($response);
}
// Get transaction Data.
$transaction = CashboxTransaction::find(Input::get('id'));
if (!$transaction) {
$response['state'] = 'Fail';
$response['error'] = 'Esta transaccion no existe!';
return response()->json($response);
}
// Get cashbox.
$cashbox = Cashbox::find($transaction->CashboxId);
// Get worker.
$worker = Worker::find(User::find($cashbox->UserId)->TypeId);
if ($transaction->Type == 1 || $transaction->Type == 8) {
// Get sale.
$sale = Sale::where('TransactionId', '=', $transaction->Id)->first();
// Get items in sale.
$items = SaleBreakdown::where('SaleId', '=', $sale->Id)->get();
// Loop trough sales breakdown and add products and materials back to stock.
foreach ($items as $item) {
$product = Stock::where('Code', '=', $item->Code)->where('BranchId', '=', $sale->BranchId)->first();
if (!$product) {
$service = Service::where('Code', '=', $item->Code)->where('BranchId', '=', $sale->BranchId)->first();
// Get materials.
$materials = json_decode($service->Materials);
foreach ($materials as $material => $quantity) {
// Update Stock.
$product = Stock::where('Code', '=', $material)->where('BranchId', '=', $sale->BranchId)->first();
$product->AverageCost = ($product->AverageCost * $product->Quantity + $product->Cost * $quantity) / ($product->Quantity + $quantity);
$product->Quantity += $quantity;
$product->save();
}
} else {
// Update product.
$product->AverageCost = ($product->AverageCost * $product->Quantity + $item->Cost * $item->Quantity) / ($product->Quantity + $item->Quantity);
$product->Quantity += $item->Quantity;
$product->save();
}
// Delete item.
$item->delete();
}
// Now delete sale and trasaction.
$sale->delete();
$transaction->delete();
// Now return transaction data.
$response['state'] = 'Success';
$response['message'] = 'Transaccion eliminada!';
return response()->json($response);
} else {
if ($transaction->Type == 7) {
// Get the cash receipt.
$receipt = CashReceipt::where('TransactionId', '=', $transaction->Id)->first();
// Get the contract.
$contract = Contract::find($receipt->TypeId);
// Now delete receipt.
$receipt->delete();
// Delete transaction.
$transaction->delete();
// If contract is not in late state then that means we might need to update the state.
if ($contract->State != 'late') {
// Get today's date.
$today = date_create(date('Y-m-d'));
// Get the contract Payments.
$contractPayments = CashReceipt::where('Type', '=', 1)->where('TypeId', '=', $contract->Id)->get();
// Get the amount of time that has passed since contract has been created.
$time = date_diff($today, date_create($contract->StartDate));
// Check how many intervals have passed.
$passedIntervals = 0;
if ($contract->QuotaInterval == 'mensuales') {
$passedIntervals = floor($time->format('%m'));
} else {
if ($contract->QuotaInterval == 'quincenales') {
/* 1 Month has an average of 4.34524 weeks*/
$passedIntervals = floor($time->format('%a') / 7) / 4.34524;
$decimal = $passedIntervals - floor($passedIntervals);
if ($decimal >= 0.5) {
$passedIntervals = floor($passedIntervals) * 2 + 1;
} else {
$passedIntervals = floor($passedIntervals) * 2;
}
} else {
if ($contract->QuotaInterval == 'semanales') {
$passedIntervals = floor($time->format('%a') / 7);
}
}
}
// Now finally get the expected payment.
$expectedPayment = $passedIntervals * $contract->Quota;
// If it is over the Debt of the contract reset it to contract value.
if ($expectedPayment > $contract->Debt) {
$expectedPayment = $contract->Debt;
}
// Calculate real payments.
$realPayment = 0;
foreach ($contractPayments as $contractPayment) {
$realPayment += $contractPayment->Value;
}
if ($realPayment < $expectedPayment) {
$contract->State = 'late';
$contract->save();
}
}
// Now return transaction data.
$response['state'] = 'Success';
$response['message'] = 'Pago a contrato eliminado!';
return response()->json($response);
} else {
if ($transaction->Type == 9) {
// If it's a reservation get the reservation with this transaction Id.
$reservation = Reservation::where('TransactionId', '=', $transaction->Id)->first();
$reservation->State = 'deleted';
$reservation->save();
// Now delete transaction.
$transaction->delete();
// Now return transaction data.
$response['state'] = 'Success';
$response['message'] = 'Deposito y reservacion eliminados!';
return response()->json($response);
} else {
// Check if this is a payment for a provider bill.
if ($transaction->Type == 2) {
// Get the provider bill information.
$providerBillPayment = ProviderBillPayment::where('TransactionId', '=', $transaction->Id)->first();
// Get the provider bill and provider.
$providerBill = ProviderBill::find($providerBillPayment->ProviderBillId);
// Check if bill has credit.
if ($providerBill->Credit) {
// Set as unpaid (No way you can delete a payment and still stay paid -.-).
$providerBill->State = 1;
$providerBill->save();
// Delete payment.
$providerBillPayment->delete();
$response['message'] = 'Transaccion eliminada!';
} else {
// Get sale breakdown.
$items = ProviderBillBreakdown::where('ProviderBillId', '=', $providerBill->Id)->get();
$response['items'] = $items;
// Get the branch of the current worker.
$branchId = Worker::find(Auth::user()->TypeId)->BranchId;
// Loop through them and update stock.
foreach ($items as $item) {
// Get product.
$product = Stock::where('Code', '=', $item->Code)->where('BranchId', '=', $branchId)->first();
// Update it.
$totalAfter = $product->Quantity - $item->Quantity;
$product->AverageCost = ($product->AverageCost * $product->Quantity - $item->CurrentCost * $item->Quantity) / $totalAfter;
$product->Quantity -= $item->Quantity;
$product->save();
//Delete breakdown.
$item->delete();
}
// Delete transaction, bill, and billpayment.
$response['message'] = 'Transaccion eliminada! Al ser el unico pago de una factura de contado se ha eliminado tambien la factura del Proveedor y retirado los productos del Inventario.';
$providerBill->delete();
$providerBillPayment->delete();
$transaction->delete();
}
// Return what we have.
$response['state'] = 'Success';
} else {
// No special action needed just delete it.
$transaction->delete();
$response['message'] = 'Transaccion eliminada!';
$response['state'] = 'Success';
}
return response()->json($response);
}
}
}
}
