public function cudPlayer($player, $action) { if (isset($player)) { $query = ""; if (strcasecmp($action, CREATE) == 0) { //add team record $query = " dbo.SP_CREATE_PLAYER '" . $player->get_fname() . "','" . $player->get_lname() . "','" . $player->get_height() . "','" . $player->get_weight() . "','" . $player->get_gender() . "','" . $player->get_dob() . "','" . $player->get_email() . "','" . $player->get_teamId() . "'"; } else { if (strcasecmp($action, UPDATE) == 0) { //update team record $query = " dbo.SP_UPDATE_PLAYER '" . $player->get_fname() . "','" . $player->get_lname() . "','" . $player->get_height() . "','" . $player->get_weight() . "','" . $player->get_gender() . "','" . $player->get_dob() . "','" . $player->get_teamId() . "','" . $player->get_email() . "','" . $player->get_playerId() . "'"; } else { if (strcasecmp($action, DELETE) == 0) { //delete team record //$query = " dbo.SP_DELETE_PLAYER '".$player->get_email()."','".$player->get_teamName()."'"; $query = " dbo.SP_DELETE_PLAYER '" . $player->get_playerId() . "'"; } } } $result = parent::processCUD($query, $action); //or use $this-> return $result; } else { return ERROR; } }
public function cudTeam($team, $action) { if (isset($team)) { $query = ""; if (strcasecmp($action, CREATE) == 0) { //add team record $query = " dbo.SP_CREATE_TEAM '" . $team->get_teamName() . "','" . $team->get_coachEmailAddress() . "'"; } else { if (strcasecmp($action, UPDATE) == 0) { //update team record $query = " dbo.SP_UPDATE_TEAM '" . $team->get_oldTeamName() . "','" . $team->get_teamName() . "','" . $team->get_coachEmailAddress() . "'"; } else { if (strcasecmp($action, DELETE) == 0) { //delete team record $query = " dbo.SP_DELETE_TEAM '" . $team->get_teamName() . "'"; } } } $result = parent::processCUD($query, $action); //or use $this-> // echo 'Result in TeamDAO='.$result; return $result; } else { return ERROR; } }
public function cudCoach($coach, $action) { if (isset($coach)) { $query = ""; if (strcasecmp($action, CREATE) == 0) { //add coach record $query = " dbo.SP_CREATE_COACH '" . $coach->get_fname() . "','" . $coach->get_lname() . "','" . $coach->get_emailAddress() . "','" . $coach->get_password() . "'"; } else { if (strcasecmp($action, UPDATE) == 0) { //update coach record $query = " dbo.SP_UPDATE_COACH '" . $coach->get_fname() . "','" . $coach->get_lname() . "','" . $coach->get_oldEmailAddress() . "','" . $coach->get_emailAddress() . "','" . $coach->get_password() . "'"; } else { if (strcasecmp($action, DELETE) == 0) { //delete coach record $query = " dbo.SP_DELETE_COACH '" . $coach->get_emailAddress() . "'"; } } } $result = parent::processCUD($query, $action); //or use $this-> // echo 'Result in CoachDAO='.$result; return $result; } else { return ERROR; } }
public function cudRegistration($registration, $action) { if (isset($registration)) { // print_r($registration); $query = ""; if (strcasecmp($action, CREATE) == 0) { //add registration record $query = " dbo.SP_CREATE_REGISTRATION '" . $registration->get_teamId() . "','" . $registration->get_tournamentId() . "'"; } else { if (strcasecmp($action, UPDATE) == 0) { //update registration record $query = " dbo.SP_UPDATE_REGISTRATION '" . $registration->get_teamName() . "','" . $registration->get_tournamentName() . "','" . $registration->get_newTournamentName() . "'"; } else { if (strcasecmp($action, DELETE) == 0) { //delete registration record $query = " dbo.SP_DELETE_REGISTRATION '" . $registration->get_teamName() . "','" . $registration->get_tournamentName() . ""; } } } $result = parent::processCUD($query, $action); return $result; } else { return ERROR; } }
public function addFilter(&$query, $id, $active, $email, $date, $date_symbol) { if ($id !== NULL) { $query .= " AND id = '" . DataHandler::forceInt($id) . "'"; } if ($active !== NULL) { $query .= " AND `active` = '" . DataHandler::forceInt($active) . "'"; } if ($email !== NULL) { $query .= " AND `email` = '" . DataHandler::forceString($email) . "'"; } if ($date !== NULL) { $date_symbol = parent::compareSimble($date_symbol); $date = parent::dateHandlerScape(DataHandler::convertDateToDB($date)); $query .= " AND `date` {$date_symbol} {$date} "; } }
public function NearestDriverDataDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function UserLoginDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function UserReviewDataDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function SensorsInRoomDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function TaxiServiceProviderDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function UserRoomsLoadDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function __construct() { parent::__construct('comment'); }
public function WishListDetailsDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function PollutionSensorDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function AddCustomerDetailslDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
/** * Actualizar el estado de �ltimo error ejecutado hacia la base datos * @param Exception $pError Objeto con el Error ocurrido */ private function ActualizarEstadoError($pError) { //Actualizar el estado del error parent::setHayError(True); parent::setDescripcionError($pError); }
public function __construct() { parent::__construct('members'); }
public function InsertDeviceSensorsValueDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function FilterPetMateListDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function MyListingDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function IndexPageCityLoadDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
/** * @desc 对象实例重用 * @param string $className * @return EbayItemDAO */ public static function getInstance($className = __CLASS__) { return parent::createInstance($className); }
public function OutStationCityLoadDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function PetCategoriesDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
/** * clona un concepto del tipo analisis. * @return (object) concepto clonado */ protected function clonar($concepto, $toParent, $modelo) { $flagCustomPrecio = isset($concepto->customPrecio) && $concepto->customPrecio; unset($concepto->customPrecio); $copia = clone $concepto; unset($copia->id); $copiaSaved = parent::save($this->filterToSave($copia)); $copia->id = $copiaSaved->id; // copia relacion con el padre if (isset($toParent)) { $this->insertRelation($toParent, $copia, $modelo); } // copia relaciones con los hijos sii no tiene un precio customizado if (!$flagCustomPrecio) { if (isset($modelo)) { $query = "insert into " . $this->fromRelaciones . " (id_sup,id_inf,id_modelo,custom_nombre,cantidad,factor) " . " select ? as id_sup,id_inf,id_modelo,custom_nombre,cantidad,factor FROM " . $this->fromRelaciones . " where id_sup = ?"; } else { $query = "insert into " . $this->fromRelaciones . " (id_sup,id_inf,custom_nombre,cantidad,factor) " . " select ? as id_sup,id_inf,custom_nombre,cantidad,factor FROM " . $this->fromRelaciones . " where id_sup = ?"; } DB::prepareExecute($query, array($copia->id, $concepto->id)); } return $copia; }
public function PetServiceFeedbackDetailsDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
function messagesDAO($dbMng) { parent::BaseDAO($dbMng); }
public function __construct() { parent::__construct(); }
public function ClinicDetailsDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }
public function ForgotPasswordDAO() { $baseDAO = new BaseDAO(); $this->con = $baseDAO->getConnection(); }