/** * Get list league and season by team attend * @param int $teamID * @return array|boolean * @author QuangTM */ public function getListLeagueAndSeasonTeamAttend($teamID) { // Default result $result = array(); try { // Get DB Obj $dbObj = Thethao_Global::getDB('sport', 'slave'); // Prepare SQL $stmt = $dbObj->prepare('CALL sp_sport_getLeagueSeasonByTeam(:p_teamid);'); // Bind param $stmt->bindParam('p_teamid', $teamID, PDO::PARAM_INT); // Execute $stmt->execute(); while ($row = $stmt->fetch()) { if (!isset($result[$row['league_id']])) { $result[$row['league_id']] = array(); } array_push($result[$row['league_id']], $row['season_id']); } // Close cursor $stmt->closeCursor(); // Release unset($stmt); } catch (Exception $ex) { Thethao_Global::sendlog($ex, 1); } // Return result return $result; }
/** * get data from table keybox with key id * @param int $intKeyId * @return array */ public function getKeyBox($arrKey = NULL) { $arrReturn = array(); try { //get db slave $sport_m = Thethao_Global::getDB('sport', 'slave'); // Get user activeation key $objStmt = $sport_m->prepare('CALL sp_getKeyBox(:p_keyid)'); // Bind param $objStmt->bindParam('p_keyid', $arrKey, PDO::PARAM_STR); // Fetch result $objStmt->execute(); //fetch result while ($row = $objStmt->fetch()) { $arrReturn[$row['key_id']] = $row['values']; } // Close cursor $objStmt->closeCursor(); // Release unset($objStmt); } catch (Zend_Db_Exception $ex) { Thethao_Global::sendLog($ex); } return $arrReturn; }
/** * insert post article * @param array $arrParams * @return int * @author Phongtx */ public function insertPostArticle($arrParams) { $intResult = false; try { // Get DB Object $db = Thethao_Global::getDB('sport', 'master'); // Prepare SQL $stmt = $db->prepare('CALL sp_ent_insertShareMusic(:p_userid, :p_fullname, :p_email, :p_title, :p_lead, :p_content, :p_status, :p_sharetype, :p_categoryid, @p_id);'); // Bind params $stmt->bindParam('p_userid', $arrParams['intUserId'], PDO::PARAM_INT); $stmt->bindParam('p_fullname', $arrParams['txtName'], PDO::PARAM_STR); $stmt->bindParam('p_email', $arrParams['txtEmail'], PDO::PARAM_STR); $stmt->bindParam('p_title', $arrParams['txtTitle'], PDO::PARAM_STR); $stmt->bindParam('p_lead', $arrParams['txtLead'], PDO::PARAM_STR); $stmt->bindParam('p_content', $arrParams['txtContent'], PDO::PARAM_STR); $stmt->bindParam('p_status', $arrParams['intStatus'], PDO::PARAM_INT); $stmt->bindParam('p_sharetype', $arrParams['type'], PDO::PARAM_INT); $stmt->bindParam('p_categoryid', $arrParams['cateid'], PDO::PARAM_INT); // Execute $stmt->execute(); // Close cursor $stmt->closeCursor(); $stmt = $db->query("SELECT @p_id"); //Fetch Result $intResult = $stmt->fetchColumn(); // Release unset($stmt); } catch (Exception $ex) { //log error Thethao_Global::sendLog($ex); } // Return result return $intResult; }
/** * get all category detail * @param int $intCategoryID * @return array * @author PhuongTN */ public function getFullCategoryByParentId($intCategoryID) { $arrArticleInfo = array(); try { $sport_m = Thethao_Global::getDB('sport', 'slave'); // Get user activeation key $objStmt = $sport_m->prepare('CALL sp_getCategoryFullByParentID(:p_parentid)'); // Bind param $objStmt->bindParam('p_parentid', $intCategoryID, PDO::PARAM_INT); // Fetch result $objStmt->execute(); while ($row = $objStmt->fetch()) { $arrArticleInfo[$row['category_id']] = $row; } // Close cursor $objStmt->closeCursor(); // Release unset($objStmt); } catch (Zend_Db_Exception $ex) { Thethao_Global::sendLog($ex); } return $arrArticleInfo; }
/** * Get full information about tennis match.<br /> * Consist of tennis sets in matches, league, and season * @param array $arrMatchIDs list id of matches * @return array|boolean * @author QuangTM */ public function getTennisMatches($arrMatchIDs) { // Get result $result = array(); try { // Validate input paramter if (!is_array($arrMatchIDs) || !count($arrMatchIDs)) { return FALSE; } // Convert array match id into string $strMatchID = implode(',', $arrMatchIDs); // Get DB Obj $dbObj = Thethao_Global::getDB('sport', 'slave'); // Prepare SQL to get tennis matches detail $stmt = $dbObj->prepare('CALL sp_tennis_getDetailTennisMatch(:p_matchid);'); // Bind param $stmt->bindParam('p_matchid', $strMatchID, PDO::PARAM_STR); // Execute $stmt->execute(); $arrLeagues = array(); $arrSeasons = array(); while ($row = $stmt->fetch()) { // Get match detail $result[$row['match_id']] = $row; // Default set in match $result[$row['match_id']]['set'] = array(); // Default league and season name for this match $result[$row['match_id']]['league_name'] = NULL; $result[$row['match_id']]['season_name'] = NULL; // Push array league and season array_push($arrSeasons, $row['season_id']); array_push($arrLeagues, $row['league_id']); } // Unique league and season and convert them into string $strSeasons = implode(',', array_unique($arrSeasons)); $strLeagues = implode(',', array_unique($arrLeagues)); // Close $stmt->closeCursor(); // Prepare SQL to get tennis sets by match $stmt = $dbObj->prepare('CALL sp_tennis_getTennisSet(:p_matchid);'); // Bind param $stmt->bindParam('p_matchid', $strMatchID, PDO::PARAM_STR); // Execute $stmt->execute(); while ($row = $stmt->fetch()) { $result[$row['match_id']]['set'][$row['set_id']] = $row; } // Close $stmt->closeCursor(); $strLeagues = !empty($strLeagues) ? $strLeagues : null; // Prepare SQL to get tennis leagues $stmt = $dbObj->prepare('CALL sp_tennis_getTennisLeague(:p_leagueid);'); // Bind param $stmt->bindParam('p_leagueid', $strLeagues, PDO::PARAM_STR); // Execute $stmt->execute(); // Default result league has got $arrLeagues = array(); while ($row = $stmt->fetch()) { $arrLeagues[$row['league_id']] = $row['league_name']; } // Close $stmt->closeCursor(); // Prepare SQL to get tennis leagues $stmt = $dbObj->prepare('CALL sp_tennis_getTennisLeague(:p_leagueid);'); // Bind param $stmt->bindParam('p_leagueid', $strLeagues, PDO::PARAM_STR); // Execute $stmt->execute(); // Default result league has got $arrLeagues = array(); while ($row = $stmt->fetch()) { $arrLeagues[$row['league_id']] = $row['league_name']; } // Close $stmt->closeCursor(); // Default result league has got $arrSeasons = array(); if (!empty($strSeasons)) { // Prepare SQL to get tennis leagues $stmt = $dbObj->prepare('CALL sp_tennis_getTennisSeasonByID(:p_seasonid);'); // Bind param $stmt->bindParam('p_seasonid', $strSeasons, PDO::PARAM_STR); // Execute $stmt->execute(); while ($row = $stmt->fetch()) { $arrSeasons[$row['season_id']] = $row['name_season']; } } // Close $stmt->closeCursor(); // Release variables unset($stmt); // By league name into match info foreach ($result as $matchId => $matchInfo) { $result[$matchId]['league_name'] = $arrLeagues[$result[$matchId]['league_id']]; $result[$matchId]['season_name'] = $arrSeasons[$result[$matchId]['season_id']]; } } catch (Exception $ex) { Thethao_Global::sendLog($ex, 1); } return $result; }
/** * Get list players by team * @param int $teamId * @return array * @author ThuyNT */ public function getListPlayersByTeam($teamId) { try { // Get DB Obj $dbObj = Thethao_Global::getDB('sport', 'slave'); // Prepare SQL $stmt = $dbObj->prepare('CALL sp_getListPlayersByTeam(:p_teamid);'); // Bind param $stmt->bindParam('p_teamid', $teamId, PDO::PARAM_INT); // Execute $stmt->execute(); // Get result $result = array(); while ($row = $stmt->fetch()) { $result[] = $row['player_id']; } // Close $stmt->closeCursor(); // Release variables unset($stmt); return $result; } catch (Exception $ex) { Thethao_Global::sendlog($ex, 1); } }
public function getListAward($arrParams) { //default return $arrResult = array(); try { //get db slave $db_s = Thethao_Global::getDB('interaction', 'slave'); // Call sp get detail book $stmt = $db_s->prepare('CALL sp_getListAwardResult(:p_object_type, :p_award , :p_fromdate , :p_todate)'); // Bind param $stmt->bindParam('p_object_type', $arrParams['object_type'], PDO::PARAM_INT); $stmt->bindParam('p_award', $arrParams['award'], PDO::PARAM_INT); $stmt->bindParam('p_fromdate', $arrParams['fromdate'], PDO::PARAM_INT); $stmt->bindParam('p_todate', $arrParams['todate'], PDO::PARAM_INT); // Execute sp $stmt->execute(); //fetch result $arrResult = $stmt->fetchAll(); // Close cursor $stmt->closeCursor(); // Release unset($stmt); } catch (Zend_Db_Exception $ex) { //log error Thethao_Global::sendLog($ex); } return $arrResult; }
/** * Get list league by group * @param int $group * @return array|boolean * @author QuangTM */ public function getListLeagueByGroup($group) { // Get result $result = array(); try { // Get DB Obj $dbObj = Thethao_Global::getDB('sport', 'slave'); // Prepare SQL $stmt = $dbObj->prepare('CALL sp_fe_sport_getLeagueByGroup(:p_group);'); // Bind param $stmt->bindParam('p_group', $group, PDO::PARAM_INT); // Execute $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result[$row['league_id']] = $row['name']; } // Close $stmt->closeCursor(); // Release variables unset($stmt); } catch (Exception $ex) { Thethao_Global::sendlog($ex, 1); } return $result; }
/** * Get extend of match detail * @param type $arrMatchId * @return boolean|array */ public function getMatchExtendByIDs($arrMatchId) { $result = array(); try { if (!is_array($arrMatchId) || !count($arrMatchId)) { return FALSE; } $strMatchId = implode(',', $arrMatchId); // Get DB Obj $dbObj = Thethao_Global::getDB('sport', 'slave'); // Prepare SQL $stmt = $dbObj->prepare('CALL sp_fesport_getDetailMatchByIDs(:p_matchids);'); // Bind param $stmt->bindParam('p_matchids', $strMatchId, PDO::PARAM_STR); // Execute $stmt->execute(); while ($row = $stmt->fetch()) { if (!isset($result[$row['match_id']])) { $result[$row['match_id']] = array(); } $result[$row['match_id']] = Zend_Json::decode($row['event']); } // Close $stmt->closeCursor(); // Release variables unset($stmt); } catch (Exception $ex) { Fpt_Data_Model::sendLog($ex); return FALSE; } return $result; }