$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']); $response = $db->generate_bill($info); } elseif (isset($_GET['Update_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']); $response = $db->update_bill($info); } elseif (isset($_GET['For_approval'])) {