";
        // 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 "
";
    //     // 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 "
";
        // 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);
    }
}
?>