global $img;
global $ititle;
$img = "hat_path";
$ititle = "hat_description";
$key_id = "hat_id";
$arr_header = array("hat_title" => "Hat title", "hat_path" => "Image", "category_title" => "Category title", "hat_price" => "Hat price", "suppliers" => "Supplier name", "hat_search_keyword" => "Keyword", "is_hot_sale" => "Hot sale");
global $needEdit;
$needEdit = false;
//global $editUrl;
//$editUrl = "Login.php";
global $service_list;
global $totalCount;
global $curPage;
global $totalPage;
$service_list = new SupplierService();
$totalCount = $service_list->GetCount("select count(*) from hat");
$totalPage = $service_list->GetTotalPage($totalCount);
$curPage = $service_list->GetCurrentPage($totalPage);
$sql = " select h.*, c.category_title, ";
$sql .= " (select group_concat( t.supplier_name ) from (select m.map_hat_id, s.supplier_name from map_hat_supplier m, supplier s where m.map_supplier_id = s.supplier_id ) t where t.map_hat_id =h.hat_id) as suppliers";
$sql .= " from hat h, category c where h.hat_category_id = c.category_id order by h.hat_id";
$sql = $service_list->SetPaging($sql, $curPage);
global $rows;
$rows = $service_list->GetRows($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>CRAZY HATS</title>
<link rel="stylesheet" href="../css/style2.css" type="text/css" />
<?php
require_once 'include.php';
AdminCheck();
global $arr_header;
global $key_id;
$key_id = "supplier_id";
$arr_header = array("supplier_name" => "Supplier name", "supplier_home_phone" => "Home phone", "supplier_work_phone" => "Work phoe", "supplier_mobile_phone" => "Mobile phone", "supplier_fax_number" => "Fax number", "supplier_address" => "Address");
global $needEdit;
$needEdit = false;
global $service_list;
global $totalCount;
global $curPage;
global $totalPage;
$service_list = new SupplierService();
$totalCount = $service_list->GetCount("select count(*) from supplier");
$totalPage = $service_list->GetTotalPage($totalCount);
$curPage = $service_list->GetCurrentPage($totalPage);
$sql = " select * from supplier ";
$sql = $service_list->SetPaging($sql, $curPage);
global $rows;
$rows = $service_list->GetRows($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>CRAZY HATS</title>
<link rel="stylesheet" href="../css/style2.css" type="text/css" />
<script src="../js/Common.js" type="text/javascript"></script>
<style type="text/css">
require_once 'include.php';
AdminCheck();
global $arr_header;
global $key_id;
$key_id = "customer_id";
$arr_header = array("customer_name" => "Customer name", "customer_password" => "Password", "customer_home_phone" => "Home phone", "customer_work_phone" => "Work phoe", "customer_mobile_phone" => "Mobile phone", "customer_fax_number" => "Fax number", "customer_email" => "Email", "customer_status" => "Status");
global $needEdit;
$needEdit = true;
global $editUrl;
$editUrl = "DisplayCustomer.php";
global $service_list;
global $totalCount;
global $curPage;
global $totalPage;
$service_list = new SupplierService();
$totalCount = $service_list->GetCount("select count(*) from customer");
$totalPage = $service_list->GetTotalPage($totalCount);
$curPage = $service_list->GetCurrentPage($totalPage);
$sql = " select * from customer ";
$sql = $service_list->SetPaging($sql, $curPage);
global $rows;
$rows = $service_list->GetRows($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>CRAZY HATS</title>
<script src="../js/Common.js" type="text/javascript"></script>
</head>
<body>
