function draw()
{
global $display;
$cond = ' 1 ';
$memcache_key = '';
$slug = Url::get('slug');
$sql = 'SELECT * FROM seo_keywords WHERE safe_key="' . $slug . '"';
$keyword = mysql_fetch_assoc(DB::query($sql));
$district_id = $keyword['did'];
$count_supplier = 0;
if (is_numeric($district_id) && $district_id > 0) {
$cond .= " AND CONCAT(',', brand_did, ',') LIKE '%," . $district_id . ",%' ";
$sql = 'SELECT * FROM district WHERE id=' . $district_id;
$district = mysql_fetch_assoc(DB::query($sql));
$display->add('district', $district);
}
$cond .= " AND is_active = 1 ";
//list food type
$list_foodtype = array();
$sql = 'SELECT * FROM food_type';
$re = DB::query($sql);
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$list_foodtype[] = $row;
}
}
$total_row = 0;
$list_supplier = array();
if (!$list_supplier) {
$list_supplier = array();
$sql = 'SELECT distinct supplier.* FROM `supplier`, food_res AS fr WHERE ' . $cond . ' AND fr.name LIKE "%' . $keyword['keyword'] . '%" AND supplier.id = fr.rid ORDER BY is_promoted DESC, name ASC ';
$re = DB::query($sql);
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$arr_foodtype = explode(',', $row['fid']);
$temp = array();
if (count($arr_foodtype) > 0) {
for ($i = 0; $i < count($arr_foodtype); $i++) {
for ($j = 0; $j < count($list_foodtype); $j++) {
if ($list_foodtype[$j]['id'] == $arr_foodtype[$i]) {
$temp[] = $list_foodtype[$j]['name'];
}
}
}
}
$row['food_type'] = $temp;
$district_fees = unserialize($row['fees']);
if (isset($district_fees[$district_id])) {
$row['delivery_time'] = $district_fees[$district_id][4];
} else {
$row['delivery_time'] = '';
}
$row['open_now'] = Restaurant::check_open($row);
$row['introduce'] = strip_tags(htmlspecialchars_decode($row['introduce']));
$row['introduce_en'] = strip_tags($row['introduce_en']);
if ($row['logo'] != '') {
if (strstr($row['logo'], 'supplier/')) {
$row['logo'] = IMAGE_PATH . 'thumb/180_180/' . $row['logo'];
} else {
$row['logo'] = IMAGE_PATH . $row['logo'];
}
}
if ($row['open_now']) {
$total_row++;
$row['time_order_str'] = '';
$open_hours = unserialize($row['open_hours']);
$day_of_week = intval(date("N")) + 1;
$hour = $open_hours[$day_of_week];
$str_hours = array();
for ($index = 0; $index < count($hour['from_hours']); $index++) {
if (!empty($hour['from_hours'][$index]) && !empty($hour['to_hours'][$index])) {
$str_hours[] = trim($hour['from_hours'][$index]) . ',' . trim($hour['to_hours'][$index]);
}
}
if (count($str_hours) > 0) {
$str_hours = implode('-', $str_hours);
} elseif (count($str_hours) == 1) {
$str_hours = $str_hours[0];
} elseif (count($str_hours) == 0) {
$str_hours = '';
}
if (strlen($str_hours) > 0) {
$row['time_order_str'] = EClassApi::convert_open_time($str_hours);
}
}
$list_supplier[] = $row;
}
}
mysql_free_result($re);
}
//list keyword
$list_keyword = array();
$sql = 'SELECT * FROM seo_keywords';
$re = DB::query($sql);
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$list_keyword[] = $row;
}
}
$display->add('slug', $keyword);
$display->add('district_id', $district_id);
$display->add('total_row', $total_row);
$display->add('list_supplier', $list_supplier);
$display->add('list_keyword', $list_keyword);
$display->output("list");
}
