static function get_fees($pid = null) { $fees = unserialize(self::get_key('fees')); if (empty($fees) || !is_array($fees)) { return null; } $list_city = City::get_list(true); $list_district = District::get_list(true, $pid); $list_fee = array(); if (!empty($fees)) { foreach ($fees as $did => $fee) { if (!empty($list_district[$did])) { $fee['city'] = $list_city[$fee['cid']]; $fee['district'] = $list_district[$did]; $fee['delivery_fee_formatted'] = EClassApi::numberFormat($fee['delivery_fee']); $fee['min_order_formatted'] = EClassApi::numberFormat($fee['min_order']); $fee['min_order_fee_formatted'] = EClassApi::numberFormat($fee['min_order_fee']); $fee['free_delivery_formatted'] = EClassApi::numberFormat($fee['free_delivery']); $list_fee[$did] = $fee; } } } return $list_fee; }
static function get_list_address($uid) { $cities = City::get_list(true); $districts = District::get_list(true); $list_address = array(); $select = 'SELECT * FROM delivery_address WHERE uid = ' . $uid; $query = DB::query($select); while ($row = mysql_fetch_assoc($query)) { if (!empty($row['did']) && isset($districts[$row['did']])) { $district = $districts[$row['did']]; $row['district_name_en'] = $district['name_en']; $row['district_name'] = $district['name_en']; if (!empty($district['pid'])) { $city = $cities[$district['pid']]; $row['city_name_en'] = $city['name_en']; $row['city_name'] = $city['name_en']; } $list_address[] = $row; } } mysql_free_result($query); return $list_address; }
function draw() { global $display; if (!User::is_login()) { return; } $this->beginForm(true, "post", false, "?" . htmlentities($_SERVER['QUERY_STRING'])); if (CGlobal::$lang == 1) { $display->add('lng', language::$LNG['personal']['en']); } else { $display->add('lng', language::$LNG['personal']['vn']); } $item_per_page = 6; $total_row = DB::fetch('SELECT count(*) AS total_row FROM `order` o WHERE o.uid = ' . User::$current->data['id'] . ' AND o.status <> 0 LIMIT 0,1', 'total_row', 0); $list_bill = array(); $paging = ''; if ($total_row) { $limit = ''; require_once ROOT_PATH . 'core/ECPagging.php'; $paging = ECPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $sql = 'SELECT *, o.id as oid FROM `order` o WHERE o.uid = ' . User::$current->data['id'] . ' AND o.status <> 0 ORDER BY o.id DESC ' . $limit; $re = DB::query($sql); if ($re) { while ($row = mysql_fetch_assoc($re)) { if ($_COOKIE['lang'] == 1) { $row['delivery_time'] = date('H:i:s m-d-Y', $row['delivery_time'] * 60 + $row['time']); } else { $row['delivery_time'] = date('H:i:s d-m-Y', $row['delivery_time'] * 60 + $row['time']); } $row['total'] = EClassApi::numberFormat($row['total']); $list_bill[] = $row; } } $display->add('list_bill', $list_bill); $display->add('total_row', $total_row); $display->add('paging', $paging); } $var = null; $sql = "SELECT DISTINCT a.*, d.name AS district_name, d.name_en AS district_name_en, p.id AS pid, p.name AS city_name, p.name_en AS city_name_en FROM delivery_address a INNER JOIN district d ON a.did = d.id INNER JOIN city p ON d.pid = p.id WHERE uid = " . User::$current->data['id']; //Get city $result = DB::query($sql); $list_delivery = array(); $address_default = null; if ($result) { while ($row = mysql_fetch_assoc($result)) { //$address = $row['address']; //$city_name = $row['city_name']; //$district_name = $row['district_name']; //$note = $row['note']; if ($row['is_default'] == 1) { $address_default = $row; } $list_delivery[] = $row; } } $display->add('list_delivery', $list_delivery); $display->add('address_default', $address_default); $user = PersonalDB::get_account_information(); $next_reward = 100 - $user['point'] % 100; $display->add('next_reward', $next_reward); $display->add('list_city', City::get_list()); if (!empty($address_default) && !empty($address_default['pid'])) { $display->add('list_district', City::get_districts($address_default['pid'])); } $display->add('user', $user); $display->add('lang', CGlobal::$lang); $display->add('error_message', $this->getErrorMessage('personal/change_password')); $display->add('success_message', $this->getSuccessMessage('personal/change_password')); $display->add('form_data', $this->getSuccessMessage('personal/form_data')); $display->setTemplate('ManageOrder', $var); $this->endForm(); }