95 lines
3.6 KiB
PHP
Executable File
95 lines
3.6 KiB
PHP
Executable File
<?php
|
|
|
|
namespace App\Controllers;
|
|
|
|
use App\Models\ProductModel;
|
|
use App\Models\VendorModel;
|
|
use App\Models\PurchaseOrderModel;
|
|
use App\Models\PurchaseOrderChildModel;
|
|
|
|
|
|
class Reorderlevel extends BaseController
|
|
{
|
|
|
|
public $session;
|
|
|
|
public function __construct()
|
|
{
|
|
|
|
$this->session = session();
|
|
|
|
}
|
|
|
|
public function reorder_level_index()
|
|
{
|
|
if(!$this->session->has('logged_user')) { return redirect()->to(base_url()); }
|
|
|
|
$productModel = new ProductModel();
|
|
$reorder = $productModel->select('products.*, vendor.vendor_name as prefered_vendor_name, COUNT(vendor.vendor_name) as product_count')
|
|
->join('vendor', 'vendor.vendor_id = products.prefered_vendor')
|
|
->where('products.qty_stock <= products.purchase_order_level')
|
|
->groupBy('products.prefered_vendor')
|
|
->orderBy('prefered_vendor_name', 'ASC')
|
|
->findAll();
|
|
// echo json_encode($reorder);die;
|
|
$data['reorder']=$reorder;
|
|
// echo "<pre>";
|
|
// print_r($reorder);die;
|
|
return view('reorder_level_list',$data);
|
|
}
|
|
|
|
// public function rise_order($product_id)
|
|
// {
|
|
// if(!$this->session->has('logged_user')) { return redirect()->to(base_url()); }
|
|
// $data['page_name']="Rise Order";
|
|
// $ProductModel = new ProductModel();
|
|
// $products=$ProductModel->where('product_id', $product_id)->get()->getRowArray();
|
|
// $data['products']=$products;
|
|
// // echo "<pre>";
|
|
// // print_r($products);die;
|
|
// $vendorid= $products['prefered_vendor'];
|
|
// $VendorModel = new VendorModel();
|
|
// $vendor=$VendorModel->where('vendor_id',$vendorid)->findAll();
|
|
// $data['vendor']=$vendor;
|
|
|
|
// $PurchaseOrderModel = new PurchaseOrderModel();
|
|
// $purchase=$PurchaseOrderModel->where('vendor_id',$vendorid)->first();
|
|
|
|
// $data['purchase']=$purchase;
|
|
// return view('reorder_level_form',$data);
|
|
// }
|
|
|
|
public function rise_order($prefered_vendor)
|
|
{
|
|
if(!$this->session->has('logged_user')) { return redirect()->to(base_url()); }
|
|
$data['page_name']="Rise Order";
|
|
$ProductModel = new ProductModel();
|
|
$products=$ProductModel->select('products.*, manufacturer.manufacturer_name')
|
|
->join('manufacturer', 'manufacturer.manufacturer_id = products.manufacturer_id','left')
|
|
->where('prefered_vendor', $prefered_vendor)
|
|
->where('qty_stock <= purchase_order_level')
|
|
->findAll();
|
|
// echo json_encode($products);die;
|
|
$data['products']=$products;
|
|
// echo "<pre>";
|
|
// print_r($products);die;
|
|
$vendorid= $prefered_vendor;
|
|
|
|
$product_data = $ProductModel->select('products.*, manufacturer.manufacturer_name')
|
|
->join('manufacturer', 'manufacturer.manufacturer_id = products.manufacturer_id','left')
|
|
->where('prefered_vendor', $vendorid)->findAll();
|
|
// echo json_encode($product_data);die;
|
|
$data['product_data'] = $product_data;
|
|
|
|
$VendorModel = new VendorModel();
|
|
$vendor=$VendorModel->where('vendor_id',$vendorid)->findAll();
|
|
$data['vendor']=$vendor;
|
|
|
|
$PurchaseOrderModel = new PurchaseOrderModel();
|
|
$purchase=$PurchaseOrderModel->where('vendor_id',$vendorid)->first();
|
|
|
|
$data['purchase']=$purchase;
|
|
return view('reorder_level_form',$data);
|
|
}
|
|
}
|
|
?>
|