public function DanhSachGameServices() { $gname = null; if (isset($_POST["gname"]) && $_POST["gname"] != "") { $gname = "game_name like '%" . $_POST["gname"] . "%'"; } $this->registry->db->connect(); $sqlselect = "game_id,game_name,game_content,game_url,game_difficulty,game_physical,game_number_min,game_number_max,\n image_url,game_time,DATE_FORMAT(created_time, '%d/%m/%Y'),DATE_FORMAT(updated_time, '%d/%m/%Y'),\n game_price,ticket_code,game_seq,game_promotions,game_name_vn,game_content_vn,game_promotions_vn"; $order = "game_seq"; $this->registry->db->select('tbl_game_info', $sqlselect, $gname, $order); $result = $this->registry->db->getResult(); $numRow = $this->registry->db->getNumRow(); $this->registry->db->disconnect(); $lResult = array(); $lList = array(); $appUtil = new AppUtils(); if ($numRow == 1) { $o = array(); $o["gid"] = $result["game_id"]; $o["gname"] = $result["game_name"]; $o["gprice"] = $result["game_price"]; $o["gcontent"] = $result["game_content"]; $o["gdiff"] = $appUtil->cDoKhoGame($result["game_difficulty"]); $o["gnumber"] = $appUtil->cSoNguoiChoi($result['game_number_min'], $result['game_number_max']); $o["gtime"] = $appUtil->cThoiGianChoiGame($result['game_time']); $o["gcode"] = $result["ticket_code"]; $o["gurl"] = $result["game_url"]; $o["gimageurl"] = $result["image_url"]; $o["gpromotions"] = $result["game_promotions"]; $o["gnamevn"] = $result["game_name_vn"]; $o["gcontentvn"] = $result["game_content_vn"]; $o["gpromotionsvn"] = $result["game_promotions_vn"]; array_push($lResult, $o); } else { foreach ($result as $value) { $o = array(); $o["gid"] = $value["game_id"]; $o["gname"] = $value["game_name"]; $o["gprice"] = $value["game_price"]; $o["gcontent"] = $value["game_content"]; $o["gdiff"] = $appUtil->cDoKhoGame($value["game_difficulty"]); $o["gnumber"] = $appUtil->cSoNguoiChoi($value['game_number_min'], $value['game_number_max']); $o["gtime"] = $appUtil->cThoiGianChoiGame($value['game_time']); $o["gcode"] = $value["ticket_code"]; $o["gurl"] = $value["game_url"]; $o["gimageurl"] = $value["image_url"]; $o["gpromotions"] = $value["game_promotions"]; $o["gnamevn"] = $value["game_name_vn"]; $o["gcontentvn"] = $value["game_content_vn"]; $o["gpromotionsvn"] = $value["game_promotions_vn"]; array_push($lResult, $o); } } $lList["total"] = count($lList); $lList["rows"] = $lResult; echo json_encode($lList); }