function RoomBooking($cat_id, $type) { $query = "select room_description, category from reservation, room_reservation, room, room_size, room_type where room.room_no=room_reservation.room_no and room.room_id=room_size.room_id and room.cat_id=room_type.cat_id and reservation.order_id=room_reservation.order_id and date(booking_date)=CURDATE() and room.cat_id='" . $cat_id . "' and room.room_id='" . $type . "'"; //$query="select room_description, category, arrival_date, departure_date, CONCAT(fname,' ', mname ,' ', lname) as cust_name from reservation, room_reservation, customer, room, room_size, room_type where reservation.cust_id=customer.cust_id and room.room_no=room_reservation.room_no and room.room_id=room_size.room_id and room.cat_id=room_type.cat_id and date(booking_date)=CURDATE() and room.cat_id='".$cat_id."' and room.room_id='".$type."'"; $data = mysql_query($query); return convertarray($data); }
function Rooms() { $query = "select * from room"; $data = mysql_query($query); return convertarray($data); }
$tmp = array('full_time' => $row['full_time'], 'i_pha_a' => $row['i_pha_a'], 'i_pha_b' => $row['i_pha_b'], 'i_pha_c' => $row['i_pha_c'], 'u_pha_a' => $row['u_pha_a'], 'u_pha_b' => $row['u_pha_b'], 'u_pha_c' => $row['u_pha_c'], 'f_pha_a' => $row['f_pha_a'], 'f_pha_b' => $row['f_pha_b'], 'f_pha_c' => $row['f_pha_c'], 'cosphi_a' => $row['cosphi_a'], 'cosphi_b' => $row['cosphi_b'], 'cosphi_c' => $row['cosphi_c'], 'p_pha_a' => $row['p_pha_a'], 'p_pha_b' => $row['p_pha_b'], 'p_pha_c' => $row['p_pha_c'], 'ppk_pha_a' => $row['ppk_pha_a'], 'ppk_pha_b' => $row['ppk_pha_b'], 'ppk_pha_c' => $row['ppk_pha_c'], 'pbk_pha_a' => $row['pbk_pha_a'], 'pbk_pha_b' => $row['pbk_pha_b'], 'pbk_pha_c' => $row['pbk_pha_c'], 'p_sum' => $row['p_sum'], 'ppk_sum' => $row['ppk_sum'], 'pbk_sum' => $row['pbk_sum'], 'cosphi_mean' => $row['cosphi_mean']); array_push($data, $tmp); } $du = array(); $di = array(); $df = array(); if ($default) { $di1 = convertarray($di1); $di2 = convertarray($di2); $di3 = convertarray($di3); $du1 = convertarray($du1); $du2 = convertarray($du2); $du3 = convertarray($du3); $df1 = convertarray($df1); $df2 = convertarray($df2); $df3 = convertarray($df3); } array_push($du, $du1, $du2, $du3); array_push($di, $di1, $di2, $di3); array_push($df, $df1, $df2, $df3); $rs = array('dienap' => $du, 'dongdien' => $di, 'tanso' => $df, 'dulieu' => $data); //echo $time_elapsed_us = microtime(true) - $start; echo json_encode($rs); //echo json_encode($tmp2); CLOSE_DB(); $vars = array_keys(get_defined_vars()); for ($i = 0; $i < sizeOf($vars); $i++) { unset(${$vars}[$i]); } unset($vars, $i); ?>
function getSectionName($id) { $query = "select section_name from section where section_id='" . $id . "'"; $data = mysql_query($query); return convertarray($data); }
function getData($query) { $data = mysql_query($query); return convertarray($data); }
function getCustomer($invoice) { $query = "select CONCAT(fname,' ', mname ,' ', lname) as cust_name from customer, reservation where customer.cust_id=reservation.cust_id and invoice_number='" . $invoice . "'"; $data = mysql_query($query); return convertarray($data); }
$result = mysql_query($sql) or die('0'); $data = array(); $imp = array(); $exp = array(); while ($row = mysql_fetch_array($result)) { $fulltime = (int) $row['full_time_d'] * 1000; array_push($imp, array($fulltime, (double) $row['import_kw'])); array_push($exp, array($fulltime, (double) $row['export_kw'])); $tmp = array('full_time' => $row['full_time'], 'import_kw' => $row['import_kw'], 'rate1' => $row['rate1'], 'rate2' => $row['rate2'], 'rate3' => $row['rate3'], 'q1' => $row['q1'], 'q2' => $row['q2'], 'cd1' => $row['cd1'], 'export_kw' => $row['export_kw'], 'rate4' => $row['rate4'], 'rate5' => $row['rate5'], 'rate6' => $row['rate6'], 'q3' => $row['q3'], 'q4' => $row['q4'], 'cd2' => $row['cd2']); array_push($data, $tmp); } $du = array(); $di = array(); if ($default) { $imp = convertarray($imp); $exp = convertarray($exp); } array_push($du, $imp); array_push($di, $exp); $rs = array('pgiao' => $du, 'pnhan' => $di, 'dulieu' => $data); //echo $time_elapsed_us = microtime(true) - $start; echo json_encode($rs); //echo json_encode($tmp2); CLOSE_DB(); $vars = array_keys(get_defined_vars()); for ($i = 0; $i < sizeOf($vars); $i++) { unset(${$vars}[$i]); } unset($vars, $i); ?>
function updatePayment($id) { $query = "select * from payment where pay_id='" . $id . "'"; $data = mysql_query($query); return convertarray($data); }
function getRes() { $query = "select order_id, room_no,arrival_date, departure_date, status, CONCAT(fname,' ', mname ,' ', lname) as cust_name from reservation inner join customer on reservation.cust_id=customer.cust_id"; $data = mysql_query($query); return convertarray($data); }
function getItems($id, $section) { $data = mysql_query("select items.item_id, item_name, price from items, item_section where items.item_id=item_section.item_id and cat_id='" . $id . "' and section_id='" . $section . "'"); return convertarray($data); }
function getCustomerInvoice($id) { $query = "select * from invoice where invoice_number={$id}"; $data = mysql_query($query); return convertarray($data); }
array_push($data, $tmp); } $du = array(); $di = array(); $df = array(); if ($default) { $di1 = convertarray($di1); $di2 = convertarray($di2); $di3 = convertarray($di3); $du1 = convertarray($du1); $du2 = convertarray($du2); $du3 = convertarray($du3); $df1 = convertarray($df1); $df2 = convertarray($df2); $df3 = convertarray($df3); $data = convertarray($data); } array_push($du, $du1, $du2, $du3); array_push($di, $di1, $di2, $di3); array_push($df, $df1, $df2, $df3); $rs = array('dienap' => $du, 'dongdien' => $di, 'tanso' => $df, 'dulieu' => $data); //echo $time_elapsed_us = microtime(true) - $start; echo json_encode($rs); //echo json_encode($tmp2); CLOSE_DB(); $vars = array_keys(get_defined_vars()); for ($i = 0; $i < sizeOf($vars); $i++) { unset(${$vars}[$i]); } unset($vars, $i); ?>
function getUser($id) { $query = "select * from users where user_id='" . $id . "'"; $data = mysql_query($query); return convertarray($data); }
function getBook($id) { $query = "select room_no, sum(adults) as adults, sum(child_a) as child_a, sum(child_b) as child_b from room_reservation where order_id={$id}"; $data = mysql_query($query); return convertarray($data); }