/**
* Check if given product code is used by some user or not.
*
* @param CheckIfProductCodeIsUsedRequest $request
* @param AjaxResponse $response
* @return mixed
*/
public function checkIfCodeIsUsed(CheckIfProductCodeIsUsedRequest $request, AjaxResponse $response)
{
$response->setSuccessMessage(trans('common.success'));
// Assume product is not used and update status if is used
$used = false;
if (Product::where('code', $request->get('product_code'))->count() || ApplicationProduct::where('code', $request->get('product_code'))->count()) {
$used = true;
}
$response->addExtraFields(['used' => $used]);
return response($response->get())->header('Content-Type', 'application/json');
}
/**
* Get product data.
*
* @param int $productId
* @param string $productCode
* @param GetProductRequest $request
* @param AjaxResponse $response
* @return mixed
*/
public function get($productId, $productCode, GetProductRequest $request, AjaxResponse $response)
{
// Make sure product exists
if (!ApplicationProduct::where('code', $productCode)->where('id', $productId)->count()) {
$response->setFailMessage(trans('common.general_error'));
return response($response->get())->header('Content-Type', 'application/json');
}
$response->setSuccessMessage(trans('common.success'));
$response->addExtraFields(['product' => ProductsManagerHelper::productDetails($productCode, $productId)]);
return response($response->get())->header('Content-Type', 'application/json');
}
public function add()
{
$this->applicationProduct->name = $this->inputs['product_name'];
$this->applicationProduct->code = $this->inputs['product_code'];
// If product code is used, update with new one (that is not used)
if (ApplicationProduct::where('code', $this->applicationProduct->code)->count()) {
// Make sure the code used to replace already used code is not also used
if (ApplicationProduct::where('code', $this->inputs['not_used_code'])->count()) {
$this->response->setFailMessage(trans('products_manager.code_already_used'));
return response($this->response->get());
}
ApplicationProduct::where('code', $this->applicationProduct->code)->update(['code' => $this->inputs['not_used_code']]);
// todo Fire notification to the users
}
$this->applicationProduct->save();
$this->response->setSuccessMessage(trans('products_manager.product_added'));
return response($this->response->get())->header('Content-Type', 'application/json');
}
/**
* Get product details.
*
* @param string $productCode
* @return \Illuminate\Contracts\Routing\ResponseFactory|\Symfony\Component\HttpFoundation\Response
*/
public static function details($productCode)
{
$response = new AjaxResponse();
$isApplicationProduct = false;
// Check if is in products table
$product = Product::where('user_id', Auth::user()->id)->where('code', $productCode)->first();
if (!$product) {
$product = ApplicationProduct::where('code', $productCode)->first();
$isApplicationProduct = true;
}
// Check if is in application_products table
if (!$product) {
$response->setFailMessage('not found');
return response($response->get(), $response->getDefaultErrorResponseCode());
}
$response->setSuccessMessage('ok');
if ($isApplicationProduct) {
$data = ['id' => $product->id, 'code' => $product->code, 'name' => $product->name, 'created_at' => $product->created_at, 'sold_pieces' => self::productSoldPieces($product->id), 'total_price' => self::productTotalPrice($product->id), 'paid_bills' => self::paidBillsThatContainProduct($product->id), 'not_paid_bills' => self::notPaidBillsThatContainProduct($product->id), 'is_application_product' => $isApplicationProduct];
$response->addExtraFields($data);
return response($response->get());
}
$response->addExtraFields(['id' => $product->id, 'code' => $product->code, 'name' => $product->name, 'created_at' => $product->created_at, 'sold_pieces' => self::productSoldPieces($product->id, true), 'total_price' => self::productTotalPrice($product->id, true), 'paid_bills' => self::paidBillsThatContainProduct($product->id, true), 'not_paid_bills' => self::notPaidBillsThatContainProduct($product->id, true), 'is_application_product' => $isApplicationProduct]);
return response($response->get());
}
/**
* Handle database operations to edit a bill product.
*
* @param array $data
* @option int billId
* @option int productId
* @option int billProductId
* @option string productCode
* @option string columnToUpdate
* @option string newValue
* @return mixed
*/
public static function handleBillProductEdit($data = [])
{
$response = new AjaxResponse();
// Query for bill
$bill = Auth::user()->bills()->where('id', $data['billId'])->first();
// Now make sure exists in database
if (!$bill) {
$response->setFailMessage(trans('common.general_error'));
return response($response->get(), $response->getDefaultErrorResponseCode())->header('Content-Type', 'application/json');
}
// Make sure bill product exists and belongs to current user
if (!Product::where('id', $data['productId'])->count() && !ApplicationProduct::where('id', $data['productId'])->count()) {
$response->setFailMessage(trans('bill.product_not_found'));
return response($response->get(), 404)->header('Content-Type', 'application/json');
}
// Make sure bill product belongs to current user
if (!BillProduct::where('id', $data['billProductId'])->count() && !BillApplicationProduct::where('id', $data['billProductId'])->count()) {
$response->setFailMessage(trans('bill.bill_product_not_found'));
return response($response->get(), 404)->header('Content-Type', 'application/json');
}
// We will use this variable to check if operation was successful
$success = false;
// Check if is a custom product
if (Products::isCustomProduct($data['productId'], $data['productCode'])) {
// Get product details and update with new data
$product = BillProduct::where('id', $data['billProductId'])->first();
BillProduct::where('id', $data['billProductId'])->update(Bills::getDataToUpdateOnEdit($data['columnToUpdate'], $data['newValue'], $product));
$success = true;
}
// Check if is an application product
if (Products::isApplicationProduct($data['productId'], $data['productCode'])) {
// Get product details and update with new data
$product = BillApplicationProduct::where('id', $data['billProductId'])->first();
BillApplicationProduct::where('id', $data['billProductId'])->update(Bills::getDataToUpdateOnEdit($data['columnToUpdate'], $data['newValue'], $product));
$success = true;
}
// Check if update was successful
if ($success) {
$response->setSuccessMessage(trans('bill.' . $data['columnToUpdate'] . '_updated'));
return response($response->get())->header('Content-Type', 'application/json');
}
// If we arrive here something is wrong
$response->setFailMessage(trans('common.general_error'));
return response($response->get(), $response->getDefaultErrorResponseCode())->header('Content-Type', 'application/json');
}
/**
* Check if given product code is used
*
* @param string $code
* @return bool
*/
private function isProductCodeAlreadyUsed($code)
{
if (ApplicationProduct::where('code', $code)->count() || Product::where('code', $code)->where('user_id', Auth::user()->id)->count()) {
return true;
}
return false;
}
