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);
}
