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>