PHP Database::search_company_stock Examples

Example #1

File: jquery-data.php Project: pradeep-chauhan/chanchal

<?php

require_once 'classes/database.php';
if (isset($_GET['search_company_details'])) {
    $db = new Database();
    $info = array('company_id' => $_GET['Company_id'], 'start' => $_GET['Start'], 'end' => $_GET['End']);
    $response = $db->search_company_stock($info);
    echo json_encode($response);
} elseif (isset($_GET['search_sales_details'])) {
    $db = new Database();
    $info = array('employee_name' => $_GET['Employee_name'], 'start' => $_GET['Start'], 'end' => $_GET['End']);
    $response = $db->search_sales_details($info);
    echo json_encode($response);
} elseif (isset($_GET['Employee_details'])) {
    $db = new Database();
    $employee_name = $_GET['Employee_name'];
    $response = $db->employee_info($employee_name);
    echo json_encode($response);
} elseif (isset($_GET['search_approval_details'])) {
    $db = new Database();
    $info = array('employee_name' => $_GET['Employee_name'], 'start' => $_GET['Start'], 'end' => $_GET['End']);
    $response = $db->search_approval_details($info);
    echo json_encode($response);
} elseif (isset($_GET['search_product_details'])) {
    $db = new Database();
    $info = array('product_category_id' => $_GET['Product_category_id'], 'start' => $_GET['Start'], 'end' => $_GET['End']);
    $response = $db->search_product_stock($info);
    echo json_encode($response);
} elseif (isset($_GET['Generate_bill'])) {
    $db = new Database();
    $info = array('bill_no' => $_GET['Bill_no'], 'name' => $_GET['Name'], 'payment_mode' => $_GET['Payment_mode'], 'barcode' => $_GET['Barcode'], 'available' => $_GET['Available'], 'qty' => $_GET['Qty'], 'rate' => $_GET['Rate'], 'total' => $_GET['Total'], 'grand_total' => $_GET['Grand_total']);