public function gettotalQuantity()
{
$inventorycountReplenish = inventorycount::where('product_id', $this->id)->where('type', 'replenish')->sum('amount');
$inventorycountWithdraw = inventorycount::where('product_id', $this->id)->where('type', 'withdraw')->sum('amount');
return $inventorycountReplenish - $inventorycountWithdraw;
}
public function postOrder(Request $request)
{
//update here
$purchaseorder = purchaseorder::find($request->purchaseorders_id);
if (isset($_POST['saveStatus'])) {
// if(isset($_POST['btnProcessDelivery'])){
// $purchaseorder->status = "on-delivery-process";
// $purchaseorder->save();
// }
// if(isset($_POST['btnClose'])){
// $purchaseorder->status = "closed";
// $purchaseorder->save();
// }
$trail = new audittrail();
$trailmessage = "";
if ($purchaseorder->status != $request->newstatus) {
$trailmessage .= "Admin updated order status to : " . $request->newstatus . ";";
}
if ($purchaseorder->remarks != $request->remarks) {
$trailmessage .= " remarked: '" . $request->remarks . "'";
}
if ($purchaseorder->status != $request->newstatus || $purchaseorder->remarks != $request->remarks) {
$trail->purchaseorder_id = $purchaseorder->id;
$trail->trail = $trailmessage;
$trail->save();
}
if ($request->newstatus == "closed") {
$orders = orders::where('purchaseorders_id', $purchaseorder->id)->get();
foreach ($orders as $order) {
$product = products::where('productName', $order->productName)->first();
if ($product) {
$inventoryCount = new inventorycount();
$inventoryCount->type = "withdraw";
$inventoryCount->product_id = $product->id;
$inventoryCount->amount = $order->quantity;
$inventoryCount->save();
}
}
}
$purchaseorder->status = $request->newstatus;
$purchaseorder->remarks = $request->remarks;
$purchaseorder->save();
return redirect('/order/' . $request->purchaseorders_id)->with('affirm', 'Status updated successfully');
}
if (isset($_POST['saveCustomerDetails'])) {
if ($purchaseorder->customer_name != $request->customer_name || $purchaseorder->customer_mobile != $request->mobilenumber || $purchaseorder->customer_email != $request->email || $purchaseorder->customer_address != $request->address || $purchaseorder->userverified != $request->customerStatus) {
$trail = new audittrail();
if ($purchaseorder->customer_name != $request->customer_name) {
$trail->trail .= " updated customer name to " . $request->customer_name . ";";
}
if ($purchaseorder->customer_mobile != $request->mobilenumber) {
$trail->trail .= " updated customer number to " . $request->mobilenumber . ";";
}
if ($purchaseorder->customer_email != $request->email) {
$trail->trail .= " updated customer email to " . $request->email . ";";
}
if ($purchaseorder->customer_address != $request->address) {
$trail->trail .= " updated customer email to " . $request->email . ";";
}
if ($purchaseorder->userverified == "" || $purchaseorder->userverified == "unverified") {
if ($purchaseorder->userverified != $request->customerStatus) {
$trail->trail .= " updated user status to : " . $request->customerStatus;
}
} else {
if ($purchaseorder->userverified != $request->customerStatus) {
$trail->trail .= " updated user status to : " . $request->customerStatus . ";";
}
}
$trail->purchaseorder_id = $purchaseorder->id;
$trail->save();
}
$purchaseorder->customer_name = $request->customer_name;
$purchaseorder->customer_mobile = $request->mobilenumber;
$purchaseorder->customer_email = $request->email;
$purchaseorder->customer_address = $request->address;
$purchaseorder->userverified = $request->customerStatus;
$purchaseorder->save();
return redirect('/order/' . $request->purchaseorders_id)->with('affirm', 'Customer details for this order updated successfully');
}
}
