Changeset 11219
- Timestamp:
- Apr 5, 2009, 6:28:34 AM (13 years ago)
- Location:
- OpenPNE3/branches/goto_doctrine
- Files:
-
- 4 added
- 69 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE3/branches/goto_doctrine/apps/mobile_frontend/modules/default/actions/components.class.php
r10277 r11219 13 13 public function executeNav() 14 14 { 15 $this->navs = NavigationPeer::retrieveByType($this->type);15 $this->navs = Doctrine::getTable('Navigation')->retrieveByType($this->type); 16 16 } 17 17 -
OpenPNE3/branches/goto_doctrine/apps/mobile_frontend/modules/member/actions/actions.class.php
r11151 r11219 26 26 { 27 27 $this->gadgetConfig = sfConfig::get('op_mobile_gadget_list'); 28 $this->mobileTopGadgets = GadgetPeer::retrieveMobileTopGadgets();29 $this->mobileContentsGadgets = GadgetPeer::retrieveMobileContentsGadgets();30 $this->mobileBottomGadgets = GadgetPeer::retrieveMobileBottomGadgets();28 $this->mobileTopGadgets = Doctrine::getTable('Gadget')->retrieveMobileTopGadgets(); 29 $this->mobileContentsGadgets = Doctrine::getTable('Gadget')->retrieveMobileContentsGadgets(); 30 $this->mobileBottomGadgets = Doctrine::getTable('Gadget')->retrieveMobileBottomGadgets(); 31 31 32 32 $this->categories = sfConfig::get('openpne_member_category'); … … 84 84 $this->passwordForm->bind($request->getParameter('password')); 85 85 if ($this->passwordForm->isValid()) { 86 $memberConfig = MemberConfigPeer::retrieveByNameAndMemberId('mobile_uid', $this->getUser()->getMemberId());86 $memberConfig = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('mobile_uid', $this->getUser()->getMemberId()); 87 87 if (!$memberConfig) { 88 88 $memberConfig = new MemberConfig(); … … 109 109 $token = $request->getParameter('token'); 110 110 111 $memberConfig = MemberConfigPeer::retrieveByNameAndMemberId('register_mobile_token', $id);111 $memberConfig = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('register_mobile_token', $id); 112 112 113 113 $this->forward404Unless($memberConfig && $token === $memberConfig->getValue()); -
OpenPNE3/branches/goto_doctrine/apps/pc_backend/modules/design/actions/actions.class.php
r11209 r11219 60 60 public function executeGadget(sfWebRequest $request) 61 61 { 62 $this->type = $request->getParameter('type', GadgetPeer::HOME_TYPES);63 $this->gadgets = GadgetPeer::retrieveGadgetsByTypesName($this->type);62 $this->type = $request->getParameter('type', Doctrine::getTable('Gadget')::HOME_TYPES); 63 $this->gadgets = Doctrine::getTable('Gadget')->retrieveGadgetsByTypesName($this->type); 64 64 65 65 $this->sortForm = new GadgetSortForm(array(), array('current_gadgets' => $this->gadgets)); … … 86 86 { 87 87 $this->layoutPattern = 'layoutA'; 88 $this->topGadgets = (array) GadgetPeer::retrieveTopGadgets();89 $this->sideMenuGadgets = (array) GadgetPeer::retrieveSideMenuGadgets();90 $this->contentsGadgets = (array) GadgetPeer::retrieveContentsGadgets();91 $this->bottomGadgets = (array) GadgetPeer::retrieveBottomGadgets();88 $this->topGadgets = (array)Doctrine::getTable('Gadget')->retrieveTopGadgets(); 89 $this->sideMenuGadgets = (array)Doctrine::getTable('Gadget')->retrieveSideMenuGadgets(); 90 $this->contentsGadgets = (array)Doctrine::getTable('Gadget')->retrieveContentsGadgets(); 91 $this->bottomGadgets = (array)Doctrine::getTable('Gadget')->retrieveBottomGadgets(); 92 92 $this->gadgetConfig = sfConfig::get('op_gadget_list'); 93 93 … … 109 109 { 110 110 $this->layoutPattern = 'layoutA'; 111 $this->topGadgets = (array) GadgetPeer::retrieveLoginTopGadgets();112 $this->sideMenuGadgets = (array) GadgetPeer::retrieveLoginSideMenuGadgets();113 $this->contentsGadgets = (array) GadgetPeer::retrieveLoginContentsGadgets();114 $this->bottomGadgets = (array) GadgetPeer::retrieveLoginBottomGadgets();111 $this->topGadgets = (array)Doctrine::getTable('Gadget')->retrieveLoginTopGadgets(); 112 $this->sideMenuGadgets = (array)Doctrine::getTable('Gadget')->retrieveLoginSideMenuGadgets(); 113 $this->contentsGadgets = (array)Doctrine::getTable('Gadget')->retrieveLoginContentsGadgets(); 114 $this->bottomGadgets = (array)Doctrine::getTable('Gadget')->retrieveLoginBottomGadgets(); 115 115 $this->gadgetConfig = sfConfig::get('op_login_gadget_list'); 116 116 … … 131 131 public function executeAddGadget(sfWebRequest $request) 132 132 { 133 $this->type = $request->getParameter('type', GadgetPeer::TOP_TYPE);134 $this->config = GadgetPeer::getGadgetConfigListByType($this->type);133 $this->type = $request->getParameter('type', Doctrine::getTable('Gadget')::TOP_TYPE); 134 $this->config = Doctrine::getTable('Gadget')->getGadgetConfigListByType($this->type); 135 135 136 136 return sfView::SUCCESS; … … 144 144 public function executeEditGadget(sfWebRequest $request) 145 145 { 146 $this->gadget = GadgetPeer::retrieveByPK($request->getParameter('id'));146 $this->gadget = Doctrine::getTable('Gadget')->find($request->getParameter('id')); 147 147 148 148 $type = $this->gadget->getType(); 149 $config = GadgetPeer::getGadgetConfigListByType($type);149 $config = Doctrine::getTable('Gadget')->getGadgetConfigListByType($type); 150 150 151 151 $this->forward404Unless($this->gadget && $config); … … 177 177 public function executeMobileHomeGadgetPlot(sfWebRequest $request) 178 178 { 179 $this->mobileTopGadgets = (array) GadgetPeer::retrieveMobileTopGadgets();180 $this->mobileContentsGadgets = (array) GadgetPeer::retrieveMobileContentsGadgets();181 $this->mobileBottomGadgets = (array) GadgetPeer::retrieveMobileBottomGadgets();179 $this->mobileTopGadgets = (array)Doctrine::getTable('Gadget')->retrieveMobileTopGadgets(); 180 $this->mobileContentsGadgets = (array)Doctrine::getTable('Gadget')->retrieveMobileContentsGadgets(); 181 $this->mobileBottomGadgets = (array)Doctrine::getTable('Gadget')->retrieveMobileBottomGadgets(); 182 182 $this->gadgetConfig = sfConfig::get('op_mobile_gadget_list'); 183 183 … … 192 192 public function executeSideBannerGadgetPlot(sfWebRequest $request) 193 193 { 194 $this->sideBannerContentsGadgets = (array) GadgetPeer::retrieveSideBannerContentsGadgets();194 $this->sideBannerContentsGadgets = (array)Doctrine::getTable('Gadget')->retrieveSideBannerContentsGadgets(); 195 195 $this->gadgetConfig = sfConfig::get('op_side_banner_gadget_list'); 196 196 … … 210 210 $this->list = array(); 211 211 212 $types = NavigationPeer::retrieveTypes($isMobile);212 $types = Doctrine::getTable('Navigation')->retrieveTypes($isMobile); 213 213 214 214 foreach ($types as $type) 215 215 { 216 $navs = NavigationPeer::retrieveByType($type);216 $navs = Doctrine::getTable('Navigation')->retrieveByType($type); 217 217 foreach ($navs as $nav) 218 218 { … … 233 233 $app = $request->getParameter('app', 'pc'); 234 234 235 $model = NavigationPeer::retrieveByPk($nav['id']);235 $model = Doctrine::getTable('Navigation')->find($nav['id']); 236 236 $this->form = new NavigationForm($model); 237 237 if ($request->isMethod('post')) … … 258 258 if ($request->isMethod('post')) 259 259 { 260 $model = NavigationPeer::retrieveByPk($request->getParameter('id'));260 $model = Doctrine::getTable('Navigation')->find($request->getParameter('id')); 261 261 $this->forward404Unless($model); 262 262 $model->delete(); … … 287 287 for ($i = 0; $i < count($order); $i++) 288 288 { 289 $nav = NavigationPeer::retrieveByPk($order[$i]);289 $nav = Doctrine::getTable('Navigation')->find($order[$i]); 290 290 if ($nav) 291 291 { -
OpenPNE3/branches/goto_doctrine/apps/pc_backend/modules/design/lib/WidgetSortForm.class.php
r10800 r11219 34 34 foreach ($this->values as $type => $gadgets) 35 35 { 36 $ids = GadgetPeer::getGadgetsIds($type);36 $ids = Doctrine::getTable('Gadget')->getGadgetsIds($type); 37 37 if (!$gadgets) 38 38 { … … 42 42 foreach ($ids as $id) 43 43 { 44 $gadget = GadgetPeer::retrieveByPk($id);44 $gadget = Doctrine::getTable('Gadget')->find($id); 45 45 $key = array_search($id, $gadgets); 46 46 … … 67 67 foreach ($value as $id) 68 68 { 69 $gadget = GadgetPeer::retrieveByPk($id);69 $gadget = Doctrine::getTable('Gadget')->find($id); 70 70 if ($gadget) 71 71 { -
OpenPNE3/branches/goto_doctrine/apps/pc_backend/modules/member/actions/actions.class.php
r10972 r11219 66 66 } 67 67 68 $this->member = MemberPeer::retrieveByPK($id);68 $this->member = Doctrine::getTable('Member')->find($id); 69 69 $this->forward404Unless($this->member); 70 70 … … 172 172 { 173 173 $id = $request->getParameter('id'); 174 $this->member = MemberPeer::retrieveByPk($id);174 $this->member = Doctrine::getTable('Member')->find($id); 175 175 $this->forward404Unless($this->member); 176 176 -
OpenPNE3/branches/goto_doctrine/apps/pc_backend/modules/member/lib/AdminInviteForm.class.php
r10480 r11219 74 74 foreach ($this->getValue('pc') as $value) 75 75 { 76 $this->member = MemberPeer::createPre();76 $this->member = Doctrine::getTable('Member')->createPre(); 77 77 $this->saveConfig('pc_address', $value); 78 78 $this->member->setConfig('register_auth_mode', $authMode); … … 81 81 foreach ($this->getValue('mobile') as $value) 82 82 { 83 $this->member = MemberPeer::createPre();83 $this->member = Doctrine::getTable('Member')->createPre(); 84 84 $this->saveConfig('mobile_address', $value); 85 85 $this->member->setConfig('register_auth_mode', $authMode); -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/community/actions/components.class.php
r11019 r11219 14 14 { 15 15 $this->member = sfContext::getInstance()->getUser()->getMember(); 16 $c = new Criteria();17 $c->addAscendingOrderByColumn(Propel::getDB()->random(time()));18 16 $this->row = $this->gadget->getConfig('row'); 19 17 $this->col = $this->gadget->getConfig('col'); 20 $this->crownIds = CommunityMemberPeer::getCommunityIdsOfAdminByMemberId($this->member->getId());21 $this->communities = CommunityPeer::retrievesByMemberId($this->member->getId(), $this->row * $this->col, $c);18 $this->crownIds = Doctrine::getTable('CommunityMember')->getCommunityIdsOfAdminByMemberId($this->member->getId()); 19 $this->communities = Doctrine::getTable('Community')->retrievesByMemberId($this->member->getId(), $this->row * $this->col, true); 22 20 } 23 21 } -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/community/templates/_joinListBox.php
r10906 r11219 5 5 'crownIds' => $sf_data->getRaw('crownIds'), 6 6 'link_to' => 'community/home?id=', 7 'moreInfo' => array(link_to(sprintf('%s(%d)', __('Show all'), $member-> countCommunityMembers()), 'community/joinlist')),7 'moreInfo' => array(link_to(sprintf('%s(%d)', __('Show all'), $member->CommunityMember->count()), 'community/joinlist')), 8 8 'type' => $sf_data->getRaw('gadget')->getConfig('type'), 9 9 'row' => $row, -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/default/actions/components.class.php
r11209 r11219 17 17 $type = 'secure_global'; 18 18 } 19 $this->navs = NavigationPeer::retrieveByType($type);19 $this->navs = Doctrine::getTable('Navigation')->retrieveByType($type); 20 20 } 21 21 … … 32 32 $this->type = sfConfig::get('sf_nav_type', sfConfig::get('mod_' . $module . '_default_nav', 'default')); 33 33 34 $this->navs = NavigationPeer::retrieveByType($this->type);34 $this->navs = Doctrine::getTable('Navigation')->retrieveByType($this->type); 35 35 36 36 if ('default' !== $this->type) … … 42 42 public function executeSideBannerGadgets() 43 43 { 44 $this->gadgets = GadgetPeer::retrieveSideBannerContentsGadgets();44 $this->gadgets = Doctrine::getTable('Gadget')->retrieveSideBannerContentsGadgets(); 45 45 } 46 46 -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/default/templates/_globalNav.php
r10270 r11219 2 2 <ul> 3 3 <?php foreach ($navs as $nav): ?> 4 <li><?php echo link_to($nav-> getCaption(), $nav->getUri()) ?></li><?php endforeach; ?>4 <li><?php echo link_to($nav->caption, $nav->uri) ?></li><?php endforeach; ?> 5 5 6 6 </ul> -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/default/templates/_localNav.php
r10390 r11219 3 3 <?php foreach ($navs as $nav): ?> 4 4 <li><?php if (isset($navId)): ?> 5 <?php echo link_to($nav-> getCaption(), $nav->getUri().'?id='.$navId) ?>5 <?php echo link_to($nav->caption, $nav->uri.'?id='.$navId) ?> 6 6 <?php else: ?> 7 <?php echo link_to($nav-> getCaption(), $nav->getUri()) ?>7 <?php echo link_to($nav->caption, $nav->uri) ?> 8 8 <?php endif; ?></li><?php endforeach; ?> 9 9 -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/friend/actions/components.class.php
r11019 r11219 14 14 { 15 15 $this->member = sfContext::getInstance()->getUser()->getMember(); 16 $c = new Criteria();17 $c->addAscendingOrderByColumn(Propel::getDB()->random(time()));18 16 $this->row = $this->gadget->getConfig('row'); 19 17 $this->col = $this->gadget->getConfig('col'); 20 $this->friends = $this->member->getFriends($this->row * $this->col, $c);18 $this->friends = $this->member->getFriends($this->row * $this->col, true); 21 19 } 22 20 } -
OpenPNE3/branches/goto_doctrine/apps/pc_frontend/modules/member/actions/actions.class.php
r11209 r11219 34 34 if (!$layout || $layout->getValue() === 'layoutA') 35 35 { 36 $this->topGadgets = GadgetPeer::retrieveTopGadgets();36 $this->topGadgets = Doctrine::getTable('Gadget')->retrieveTopGadgets(); 37 37 } 38 38 if (!$layout || $layout->getValue() === 'layoutA' || $layout->getValue() === 'layoutB') 39 39 { 40 $this->sideMenuGadgets = GadgetPeer::retrieveSideMenuGadgets();40 $this->sideMenuGadgets = Doctrine::getTable('Gadget')->retrieveSideMenuGadgets(); 41 41 } 42 $this->contentsGadgets = GadgetPeer::retrieveContentsGadgets();43 $this->bottomGadgets = GadgetPeer::retrieveBottomGadgets();42 $this->contentsGadgets = Doctrine::getTable('Gadget')->retrieveContentsGadgets(); 43 $this->bottomGadgets = Doctrine::getTable('Gadget')->retrieveBottomGadgets(); 44 44 45 45 return parent::executeHome($request); … … 62 62 if (!$layout || $layout->getValue() === 'layoutA') 63 63 { 64 $this->topGadgets = GadgetPeer::retrieveLoginTopGadgets();64 $this->topGadgets = Doctrine::getTable('Gadget')->retrieveLoginTopGadgets(); 65 65 } 66 66 if (!$layout || $layout->getValue() === 'layoutA' || $layout->getValue() === 'layoutB') 67 67 { 68 $this->sideMenuGadgets = GadgetPeer::retrieveLoginSideMenuGadgets();68 $this->sideMenuGadgets = Doctrine::getTable('Gadget')->retrieveLoginSideMenuGadgets(); 69 69 } 70 $this->contentsGadgets = GadgetPeer::retrieveLoginContentsGadgets();71 $this->bottomGadgets = GadgetPeer::retrieveLoginBottomGadgets();70 $this->contentsGadgets = Doctrine::getTable('Gadget')->retrieveLoginContentsGadgets(); 71 $this->bottomGadgets = Doctrine::getTable('Gadget')->retrieveLoginBottomGadgets(); 72 72 73 73 return parent::executeLogin($request); … … 90 90 $this->filters->bind($params); 91 91 92 $this->pager = new sfPropelPager('Member', 20); 93 $c = $this->filters->getCriteria(); 94 $c->addDescendingOrderByColumn(MemberPeer::ID); 95 $this->pager->setCriteria($c); 92 $this->pager = new sfDoctrinePager('Member', 20); 93 $q = $this->pager->getQuery()->orderBy('id'); 94 $this->pager->setQuery($q); 96 95 $this->pager->setPage($request->getParameter('page', 1)); 97 96 $this->pager->init(); -
OpenPNE3/branches/goto_doctrine/config/doctrine/schema.yml
r11208 r11219 24 24 foreign: id 25 25 type: one 26 options: 27 charset: utf8 26 28 AdminUser: 27 29 tableName: admin_user … … 39 41 default: "" 40 42 notnull: true 43 options: 44 charset: utf8 41 45 Community: 42 46 tableName: community … … 62 66 foreign: id 63 67 type: one 68 options: 69 charset: utf8 64 70 MemberRelationship: 65 71 tableName: member_relationship … … 88 94 foreign: id 89 95 type: one 96 options: 97 charset: utf8 90 98 CommunityConfig: 91 99 tableName: community_config … … 108 116 foreign: id 109 117 type: one 118 options: 119 charset: utf8 110 120 MemberConfig: 111 121 tableName: member_config … … 128 138 foreign: id 129 139 type: one 140 options: 141 charset: utf8 130 142 Profile: 131 143 tableName: profile … … 133 145 I18n: 134 146 fields: [caption, info] 147 length: 5 135 148 columns: 136 149 id: … … 186 199 notnull: true 187 200 info: string(2147483647) 201 options: 202 charset: utf8 188 203 SnsConfig: 189 204 tableName: sns_config … … 198 213 notnull: true 199 214 value: string(2147483647) 215 options: 216 charset: utf8 200 217 MemberImage: 201 218 tableName: member_image … … 221 238 foreign: id 222 239 type: one 240 options: 241 charset: utf8 223 242 Blacklist: 224 243 tableName: blacklist … … 233 252 notnull: true 234 253 memo: string(2147483647) 254 options: 255 charset: utf8 235 256 MemberProfile: 236 257 tableName: member_profile … … 266 287 foreign: id 267 288 type: one 289 options: 290 charset: utf8 268 291 FileBin: 269 292 tableName: file_bin … … 278 301 foreign: id 279 302 type: one 303 options: 304 charset: utf8 280 305 CommunityCategory: 281 306 tableName: community_category … … 301 326 tree_key: integer(4) 302 327 sort_order: integer(4) 328 options: 329 charset: utf8 303 330 GadgetConfig: 304 331 tableName: gadget_config … … 319 346 foreign: id 320 347 type: one 348 options: 349 charset: utf8 321 350 ProfileOption: 322 351 tableName: profile_option … … 324 353 I18n: 325 354 fields: [value] 355 length: 5 326 356 columns: 327 357 id: … … 339 369 foreign: id 340 370 type: one 371 options: 372 charset: utf8 341 373 Gadget: 342 374 tableName: gadget … … 355 387 notnull: true 356 388 sort_order: integer(4) 389 options: 390 charset: utf8 357 391 File: 358 392 tableName: file … … 372 406 notnull: true 373 407 original_filename: string(2147483647) 408 options: 409 charset: utf8 374 410 Navigation: 375 411 tableName: navigation … … 377 413 I18n: 378 414 fields: [caption] 415 length: 5 379 416 columns: 380 417 id: … … 393 430 notnull: true 394 431 sort_order: integer(4) 432 options: 433 charset: utf8 395 434 Member: 396 435 tableName: member … … 415 454 foreign: id 416 455 type: one 456 options: 457 charset: utf8 -
OpenPNE3/branches/goto_doctrine/lib/action/sfOpenPNECommunityAction.class.php
r11045 r11219 23 23 24 24 $memberId = $this->getUser()->getMemberId(); 25 $this->isCommunityMember = CommunityMemberPeer::isMember($memberId, $this->id);26 $this->isCommunityPreMember = CommunityMemberPeer::isPreMember($memberId, $this->id);27 $this->isAdmin = CommunityMemberPeer::isAdmin($memberId, $this->id);25 $this->isCommunityMember = Doctrine::getTable('CommunityMember')->isMember($memberId, $this->id); 26 $this->isCommunityPreMember = Doctrine::getTable('CommunityMember')->isPreMember($memberId, $this->id); 27 $this->isAdmin = Doctrine::getTable('CommunityMember')->isAdmin($memberId, $this->id); 28 28 $this->isEditCommunity = $this->isAdmin; 29 29 } … … 38 38 $this->community = CommunityPeer::retrieveByPk($this->id); 39 39 $this->forward404Unless($this->community, 'Undefined community.'); 40 $this->community_admin = CommunityMemberPeer::getCommunityAdmin($this->id);41 $this->community_admin = MemberPeer::retrieveByPk($this->community_admin->getMemberId());40 $this->community_admin = Doctrine::getTable('CommunityMember')->getCommunityAdmin($this->id); 41 $this->community_admin = Doctrine::getTable('Member')->find($this->community_admin->getMemberId()); 42 42 43 43 if (!$this->membersSize) … … 99 99 $memberId = $request->getParameter('id', $this->getUser()->getMemberId()); 100 100 101 $this->member = MemberPeer::retrieveByPK($memberId);101 $this->member = Doctrine::getTable('Member')->find($memberId); 102 102 $this->forward404Unless($this->member); 103 103 … … 114 114 } 115 115 116 $this->crownIds = CommunityMemberPeer::getCommunityIdsOfAdminByMemberId($memberId);116 $this->crownIds = Doctrine::getTable('CommunityMember')->getCommunityIdsOfAdminByMemberId($memberId); 117 117 118 118 return sfView::SUCCESS; … … 139 139 } 140 140 141 $this->crownIds = array( CommunityMemberPeer::getCommunityAdmin($this->id)->getMemberId());141 $this->crownIds = array(Doctrine::getTable('CommunityMember')->getCommunityAdmin($this->id)->getMemberId()); 142 142 143 143 return sfView::SUCCESS; … … 158 158 $this->forward404Unless($community); 159 159 160 CommunityMemberPeer::join($this->getUser()->getMemberId(), $this->id, $community->getConfig('register_poricy'));160 Doctrine::getTable('CommunityMember')->join($this->getUser()->getMemberId(), $this->id, $community->getConfig('register_poricy')); 161 161 $this->redirect('community/home?id=' . $this->id); 162 162 } … … 171 171 $this->forward404Unless($this->isAdmin); 172 172 173 $communityMember = CommunityMemberPeer::retrieveByMemberIdAndCommunityId($request->getParameter('member_id'), $this->id);173 $communityMember = Doctrine::getTable('CommunityMember')->retrieveByMemberIdAndCommunityId($request->getParameter('member_id'), $this->id); 174 174 $this->forward404Unless($communityMember); 175 175 … … 191 191 $this->forward404Unless($this->isAdmin); 192 192 193 $communityMember = CommunityMemberPeer::retrieveByMemberIdAndCommunityId($request->getParameter('member_id'), $this->id);193 $communityMember = Doctrine::getTable('CommunityMember')->retrieveByMemberIdAndCommunityId($request->getParameter('member_id'), $this->id); 194 194 $this->forward404Unless($communityMember); 195 195 … … 213 213 } 214 214 215 CommunityMemberPeer::quit($this->getUser()->getMemberId(), $this->id);215 Doctrine::getTable('CommunityMember')->quit($this->getUser()->getMemberId(), $this->id); 216 216 $this->redirect('community/home?id=' . $this->id); 217 217 } … … 245 245 { 246 246 $this->redirectUnless($this->isAdmin, '@error'); 247 $member = MemberPeer::retrieveByPk($request->getParameter('member_id'));247 $member = Doctrine::getTable('Member')->find($request->getParameter('member_id')); 248 248 $this->forward404Unless($member); 249 249 250 $isCommunityMember = CommunityMemberPeer::isMember($member->getId(), $this->id);250 $isCommunityMember = Doctrine::getTable('CommunityMember')->isMember($member->getId(), $this->id); 251 251 $this->redirectUnless($this->isAdmin, '@error'); 252 $isAdmin = CommunityMemberPeer::isAdmin($member->getId(), $this->id);252 $isAdmin = Doctrine::getTable('CommunityMember')->isAdmin($member->getId(), $this->id); 253 253 $this->redirectIf($isAdmin, '@error'); 254 254 255 CommunityMemberPeer::quit($member->getId(), $this->id);255 Doctrine::getTable('CommunityMember')->quit($member->getId(), $this->id); 256 256 $this->redirect('community/memberManage?id='.$this->id); 257 257 } -
OpenPNE3/branches/goto_doctrine/lib/action/sfOpenPNECommunityComponents.class.php
r11019 r11219 22 22 $memberId = sfContext::getInstance()->getUser()->getMemberId(); 23 23 24 $this->communityMembers = CommunityMemberPeer::getCommunityMembersPre($memberId);24 $this->communityMembers = Doctrine::getTable('CommunityMember')->getCommunityMembersPre($memberId); 25 25 } 26 26 } -
OpenPNE3/branches/goto_doctrine/lib/action/sfOpenPNEFriendAction.class.php
r10899 r11219 23 23 $this->id = $this->getRequestParameter('id', $this->getUser()->getMemberId()); 24 24 25 $this->relation = MemberRelationshipPeer::retrieveByFromAndTo($this->getUser()->getMemberId(), $this->id);25 $this->relation = Doctrine::getTable('MemberRelationship')->retrieveByFromAndTo($this->getUser()->getMemberId(), $this->id); 26 26 if (!$this->relation) { 27 27 $this->relation = new MemberRelationship(); … … 44 44 $this->size = 20; 45 45 } 46 $this->pager = MemberRelationshipPeer::getFriendListPager($this->id, $request->getParameter('page', 1), $this->size);46 $this->pager = Doctrine::getTable('MemberRelationship')->getFriendListPager($this->id, $request->getParameter('page', 1), $this->size); 47 47 48 48 if (!$this->pager->getNbResults()) { … … 149 149 public function executeManage($request) 150 150 { 151 $this->pager = MemberRelationshipPeer::getFriendListPager($this->getUser()->getMemberId(), $request->getParameter('page', 1));151 $this->pager = Doctrine::getTable('MemberRelationship')->getFriendListPager($this->getUser()->getMemberId(), $request->getParameter('page', 1)); 152 152 153 153 if (!$this->pager->getNbResults()) { … … 167 167 $this->forward404Unless($this->id); 168 168 169 $this->member = MemberPeer::retrieveByPk($this->id);169 $this->member = Doctrine::getTable('Member')->find($this->id); 170 170 $this->forward404Unless($this->member, 'Undefined member.'); 171 171 -
OpenPNE3/branches/goto_doctrine/lib/action/sfOpenPNEMemberAction.class.php
r11151 r11219 22 22 $this->id = $this->getRequestParameter('id', $this->getUser()->getMemberId()); 23 23 24 $this->relation = MemberRelationshipPeer::retrieveByFromAndTo($this->getUser()->getMemberId(), $this->id);24 $this->relation = Doctrine::getTable('MemberRelationship')->retrieveByFromAndTo($this->getUser()->getMemberId(), $this->id); 25 25 if (!$this->relation) { 26 26 $this->relation = new MemberRelationship(); … … 112 112 113 113 $id = $this->getRequestParameter('id', $this->getUser()->getMemberId()); 114 $this->member = MemberPeer::retrieveByPk($id);114 $this->member = Doctrine::getTable('Member')->find($id); 115 115 116 116 $this->forward404Unless($this->member, 'Undefined member.'); … … 130 130 } 131 131 $this->communities = $this->member->getJoinCommunities($this->communitiesSize, $c); 132 $this->crownIds = CommunityMemberPeer::getCommunityIdsOfAdminByMemberId($id);132 $this->crownIds = Doctrine::getTable('CommunityMember')->getCommunityIdsOfAdminByMemberId($id); 133 133 134 134 return sfView::SUCCESS; … … 175 175 $memberId = $request->getParameter('id'); 176 176 177 $memberConfig = MemberConfigPeer::retrieveByNameAndMemberId($type.'_token', $memberId);177 $memberConfig = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId($type.'_token', $memberId); 178 178 $this->forward404Unless($memberConfig); 179 179 $this->forward404Unless((bool)$request->getParameter('token') !== $memberConfig->getValue()); … … 187 187 if ($this->form->isValid()) 188 188 { 189 $config = MemberConfigPeer::retrieveByNameAndMemberId($type, $memberId);190 $pre = MemberConfigPeer::retrieveByNameAndMemberId($type.'_pre', $memberId);189 $config = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId($type, $memberId); 190 $pre = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId($type.'_pre', $memberId); 191 191 192 192 if (!$config) … … 201 201 { 202 202 $pre->delete(); 203 $token = MemberConfigPeer::retrieveByNameAndMemberId($type.'_token', $memberId);203 $token = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId($type.'_token', $memberId); 204 204 $token->delete(); 205 205 } -
OpenPNE3/branches/goto_doctrine/lib/filter/sfOpenPNEExecutionFilter.class.php
r10582 r11219 23 23 $actionName = $actionInstance->getActionName(); 24 24 $dispatcher = sfContext::getInstance()->getEventDispatcher(); 25 26 // sfDoctrinePlugin needs to notify this event for enabling i18n 27 $dispatcher->notify(new sfEvent( 28 $this, 'user.change_culture', array('culture' => sfContext::getInstance()->getUser()->getCulture()) 29 )); 25 30 26 31 $dispatcher->notify(new sfEvent($this, 'op_action.pre_execute_'.$moduleName.'_'.$actionName, array( -
OpenPNE3/branches/goto_doctrine/lib/form/MemberConfigForm/MemberConfigAccessBlock.class.php
r10003 r11219 24 24 public function configure() 25 25 { 26 $relations = MemberRelationshipPeer::retrievesByMemberIdFrom($this->member->getId());26 $relations = Doctrine::getTable('MemberRelationship')->retrievesByMemberIdFrom($this->member->getId()); 27 27 foreach ($relations as $relation) 28 28 { … … 43 43 foreach ($value as $memberId) 44 44 { 45 $relation = MemberRelationshipPeer::retrieveByFromAndTo($this->member->getId(), $memberId);45 $relation = Doctrine::getTable('MemberRelationship')->retrieveByFromAndTo($this->member->getId(), $memberId); 46 46 if (!$relation) 47 47 { … … 91 91 } 92 92 93 if (! MemberPeer::retrieveByPK($memberId))93 if (!Doctrine::getTable('Member')->find($memberId)) 94 94 { 95 95 throw new sfValidatorError($validator, 'invalid'); -
OpenPNE3/branches/goto_doctrine/lib/form/MemberConfigForm/MemberConfigMobileAddressForm.class.php
r10613 r11219 26 26 $this->savePreConfig($name, $value); 27 27 28 $memberConfig = MemberConfigPeer::retrieveByNameAndMemberId('mobile_address_token', $this->member->getId(), true);28 $memberConfig = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('mobile_address_token', $this->member->getId(), true); 29 29 $token = $memberConfig->getValue(); 30 30 $this->sendConfirmMail($token, $value, array( -
OpenPNE3/branches/goto_doctrine/lib/form/MemberConfigForm/MemberConfigPasswordForm.class.php
r11020 r11219 30 30 { 31 31 $member = sfContext::getInstance()->getUser()->getMember(); 32 if (md5($value) !== MemberConfigPeer::retrieveByNameAndMemberId('password', $member->getId())->getValue())32 if (md5($value) !== Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('password', $member->getId())->getValue()) 33 33 { 34 34 throw new sfValidatorError(new sfValidatorPass(), 'invalid', array('value' => $value)); -
OpenPNE3/branches/goto_doctrine/lib/form/MemberConfigForm/MemberConfigPcAddressForm.class.php
r10020 r11219 26 26 $this->savePreConfig($name, $value); 27 27 28 $memberConfig = MemberConfigPeer::retrieveByNameAndMemberId('pc_address_token', $this->member->getId());28 $memberConfig = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('pc_address_token', $this->member->getId()); 29 29 $token = $memberConfig->getValue(); 30 30 $this->sendConfirmMail($token, $value, array( -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseCommunityConfigForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'community_id' => new sfWidgetFormDoctrine Select(array('model' => 'Community', 'add_empty' => false)),16 'community_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Community', 'add_empty' => false)), 17 17 'name' => new sfWidgetFormInput(), 18 18 'value' => new sfWidgetFormTextarea(), -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseCommunityForm.class.php
r11208 r11219 15 15 'id' => new sfWidgetFormInputHidden(), 16 16 'name' => new sfWidgetFormInput(), 17 'file_id' => new sfWidgetFormDoctrine Select(array('model' => 'File', 'add_empty' => true)),18 'community_category_id' => new sfWidgetFormDoctrine Select(array('model' => 'CommunityCategory', 'add_empty' => true)),17 'file_id' => new sfWidgetFormDoctrineChoice(array('model' => 'File', 'add_empty' => true)), 18 'community_category_id' => new sfWidgetFormDoctrineChoice(array('model' => 'CommunityCategory', 'add_empty' => true)), 19 19 'created_at' => new sfWidgetFormDateTime(), 20 20 'updated_at' => new sfWidgetFormDateTime(), -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseCommunityMemberForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'community_id' => new sfWidgetFormDoctrine Select(array('model' => 'Community', 'add_empty' => false)),17 'member_id' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => false)),16 'community_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Community', 'add_empty' => false)), 17 'member_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => false)), 18 18 'position' => new sfWidgetFormInput(), 19 19 )); -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseGadgetConfigForm.class.php
r11208 r11219 15 15 'id' => new sfWidgetFormInputHidden(), 16 16 'name' => new sfWidgetFormInput(), 17 'gadget_id' => new sfWidgetFormDoctrine Select(array('model' => 'Gadget', 'add_empty' => true)),17 'gadget_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Gadget', 'add_empty' => true)), 18 18 'value' => new sfWidgetFormTextarea(), 19 19 )); -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseMemberConfigForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'member_id' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => false)),16 'member_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => false)), 17 17 'name' => new sfWidgetFormInput(), 18 18 'value' => new sfWidgetFormTextarea(), -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseMemberForm.class.php
r11208 r11219 16 16 'name' => new sfWidgetFormInput(), 17 17 'is_active' => new sfWidgetFormInput(), 18 'invite_member_id' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => true)),18 'invite_member_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => true)), 19 19 'created_at' => new sfWidgetFormDateTime(), 20 20 'updated_at' => new sfWidgetFormDateTime(), -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseMemberImageForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'member_id' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => false)),17 'file_id' => new sfWidgetFormDoctrine Select(array('model' => 'File', 'add_empty' => false)),16 'member_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => false)), 17 'file_id' => new sfWidgetFormDoctrineChoice(array('model' => 'File', 'add_empty' => false)), 18 18 'is_primary' => new sfWidgetFormInput(), 19 19 )); -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseMemberProfileForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'member_id' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => false)),17 'profile_id' => new sfWidgetFormDoctrine Select(array('model' => 'Profile', 'add_empty' => false)),18 'profile_option_id' => new sfWidgetFormDoctrine Select(array('model' => 'ProfileOption', 'add_empty' => true)),16 'member_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => false)), 17 'profile_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Profile', 'add_empty' => false)), 18 'profile_option_id' => new sfWidgetFormDoctrineChoice(array('model' => 'ProfileOption', 'add_empty' => true)), 19 19 'value' => new sfWidgetFormTextarea(), 20 20 'public_flag' => new sfWidgetFormInput(), -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseMemberRelationshipForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'member_id_to' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => false)),17 'member_id_from' => new sfWidgetFormDoctrine Select(array('model' => 'Member', 'add_empty' => false)),16 'member_id_to' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => false)), 17 'member_id_from' => new sfWidgetFormDoctrineChoice(array('model' => 'Member', 'add_empty' => false)), 18 18 'is_friend' => new sfWidgetFormInput(), 19 19 'is_friend_pre' => new sfWidgetFormInput(), -
OpenPNE3/branches/goto_doctrine/lib/form/doctrine/base/BaseProfileOptionForm.class.php
r11208 r11219 14 14 $this->setWidgets(array( 15 15 'id' => new sfWidgetFormInputHidden(), 16 'profile_id' => new sfWidgetFormDoctrine Select(array('model' => 'Profile', 'add_empty' => false)),16 'profile_id' => new sfWidgetFormDoctrineChoice(array('model' => 'Profile', 'add_empty' => false)), 17 17 'sort_order' => new sfWidgetFormInput(), 18 18 )); -
OpenPNE3/branches/goto_doctrine/lib/form/opAuthRegisterForm.class.php
r10122 r11219 43 43 else 44 44 { 45 $this->setMember( MemberPeer::createPre());45 $this->setMember(Doctrine::getTable('Member')->createPre()); 46 46 } 47 47 -
OpenPNE3/branches/goto_doctrine/lib/form/sfOpenPNEPasswordForm.class.php
r10772 r11219 37 37 { 38 38 $member = $this->options['member']; 39 if (md5($value) !== MemberConfigPeer::retrieveByNameAndMemberId('password', $member->getId())->getValue())39 if (md5($value) !== Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('password', $member->getId())->getValue()) 40 40 { 41 41 throw new sfValidatorError(new sfValidatorPass(), 'invalid', array('value' => $value)); -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/CommunityMemberTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class CommunityMemberTable extends Doctrine_Table 6 12 { 13 public function retrieveByMemberIdAndCommunityId($memberId, $communityId) 14 { 15 return $this->createQuery() 16 ->where('member_id = ?', $memberId) 17 ->andWhere('community_id = ?', $communityId) 18 ->fetchOne(); 19 } 7 20 21 public function isMember($memberId, $communityId) 22 { 23 $communityMember = $this->retrieveByMemberIdAndCommunityId($memberId, $communityId); 24 if (!$communityMember) 25 { 26 return false; 27 } 28 return ($communityMember->position != 'pre'); 29 } 30 31 public function isPreMember($memberId, $communityId) 32 { 33 $communityMember = $this->retrieveByMemberIdAndCommunityId($memberId, $communityId); 34 if (!$communityMember) 35 { 36 return false; 37 } 38 return ($communityMember->position == 'pre'); 39 } 40 41 public function isAdmin($memberId, $communityId) 42 { 43 $communityMember = $this->retrieveByMemberIdAndCommunityId($memberId, $communityId); 44 if (!$communityMember) { 45 return false; 46 } 47 48 if ($communityMember->position != 'admin') { 49 return false; 50 } 51 52 return true; 53 } 54 55 public function join($memberId, $communityId, $isRegisterPoricy = 'open') 56 { 57 if ($this->isPreMember($memberId, $communityId)) 58 { 59 throw new Exception('This member has already applied this community.'); 60 } 61 62 if ($this->isMember($memberId, $communityId)) 63 { 64 throw new Exception('This member has already joined this community.'); 65 } 66 67 $communityMember = new CommunityMember(); 68 $communityMember->memberId = $memberId; 69 $communityMember->communityId = $communityId; 70 if ($isRegisterPoricy == 'close') 71 { 72 $communityMember->position = 'pre'; 73 } 74 $communityMember->save(); 75 } 76 77 public function quit($memberId, $communityId) 78 { 79 if (!$this->isMember($memberId, $communityId)) { 80 throw new Exception('This member is not a member of this community.'); 81 } 82 83 if ($this->isAdmin($memberId, $communityId)) { 84 throw new Exception('This member is community admin.'); 85 } 86 87 $communityMember = $this->retrieveByMemberIdAndCommunityId($memberId, $communityId); 88 $communityMember->delete(); 89 } 90 91 public function getCommunityAdmin($communityId) 92 { 93 return $this->createQuery() 94 ->where('community_id = ?', $communityId) 95 ->andWhere('position = ?', 'admin') 96 ->fetchOne(); 97 } 98 99 public function getCommunityIdsOfAdminByMemberId($memberId) 100 { 101 return $this->createQuery() 102 ->select('community_id') 103 ->where('member_id = ?', $memberId) 104 ->andWhere('position = ?', 'admin') 105 ->fetchArray(); 106 } 107 108 public function getCommunityMembersPre($memberId) 109 { 110 $adminCommunityIds = $this->getCommunityIdsOfAdminByMemberId($memberId); 111 112 if (count($adminCommunityIds)) 113 { 114 return $this->createQuery() 115 ->whereIn('community_id', $adminCommunityIds) 116 ->where('position', 'pre') 117 ->execute(); 118 } 119 120 return array(); 121 } 8 122 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/CommunityTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class CommunityTable extends Doctrine_Table 6 12 { 13 public function retrievesByMemberId($memberId, $limit = 5, $isRandom = false) 14 { 15 $q = Doctrine::getTable('Community')->createQuery() 16 ->where('CommunityMember.member_id = ?', $memberId) 17 ->andWhere('CommunityMember.position <> ?', 'pre') 18 ->leftJoin('CommunityMember'); 7 19 20 if (!is_null($limit)) 21 { 22 $q->limit($limit); 23 } 24 25 if ($isRandom) 26 { 27 $expr = new Doctrine_Expression('RANDOM()'); 28 $q->orderBy($expr); 29 } 30 31 return $q->execute(); 32 } 33 34 public function getJoinCommunityListPager($memberId, $page = 1, $size = 20) 35 { 36 $c = new Criteria(); 37 $c->add(CommunityMemberPeer::MEMBER_ID, $memberId); 38 $c->add(CommunityMemberPeer::POSITION, 'pre', Criteria::NOT_EQUAL); 39 $c->addJoin(self::ID, CommunityMemberPeer::COMMUNITY_ID); 40 41 $pager = new sfPropelPager('Community', $size); 42 $pager->setCriteria($c); 43 $pager->setPage($page); 44 $pager->init(); 45 46 return $pager; 47 } 48 49 public function getCommunityMemberListPager($communityId, $page = 1, $size = 20) 50 { 51 $c = new Criteria(); 52 $c->add(CommunityMemberPeer::COMMUNITY_ID, $communityId); 53 $c->add(CommunityMemberPeer::POSITION, 'pre', Criteria::NOT_EQUAL); 54 $c->addJoin(MemberPeer::ID, CommunityMemberPeer::MEMBER_ID); 55 56 $pager = new sfPropelPager('Member', $size); 57 $pager->setCriteria($c); 58 $pager->setPage($page); 59 $pager->init(); 60 61 return $pager; 62 } 63 64 public function getIdsByMemberId($memberId) 65 { 66 $result = array(); 67 68 $c = new Criteria(); 69 $c->clearSelectColumns()->addSelectColumn(self::ID); 70 $c->add(CommunityMemberPeer::MEMBER_ID, $memberId); 71 $c->add(CommunityMemberPeer::POSITION, 'pre', Criteria::NOT_EQUAL); 72 $c->addJoin(self::ID, CommunityMemberPeer::COMMUNITY_ID); 73 $stmt = self::doSelectStmt($c); 74 75 while ($row = $stmt->fetch(PDO::FETCH_NUM)) 76 { 77 $result[] = $row[0]; 78 } 79 80 return $result; 81 } 8 82 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/Gadget.class.php
r11208 r11219 2 2 3 3 /** 4 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 5 9 */ 10 6 11 class Gadget extends BaseGadget 7 12 { 13 public function getComponentModule() 14 { 15 $list = Doctrine::getTable('Gadget')->getGadgetConfigListByType($this->type); 16 if (empty($list[$this->name])) 17 { 18 return false; 19 } 8 20 21 return $list[$this->name]['component'][0]; 22 } 23 24 public function getComponentAction() 25 { 26 $list = Doctrine::getTable('Gadget')->getGadgetConfigListByType($this->type); 27 if (empty($list[$this->name])) 28 { 29 return false; 30 } 31 32 return $list[$this->name]['component'][1]; 33 } 34 35 public function isEnabled() 36 { 37 $list = Doctrine::getTable('Gadget')->getGadgetConfigListByType($this->type); 38 if (empty($list[$this->name])) 39 { 40 return false; 41 } 42 43 return true; 44 } 45 46 public function getConfig($name) 47 { 48 return null; 49 50 $result = null; 51 $list = GadgetPeer::getGadgetConfigListByType($this->getType()); 52 53 $config = GadgetConfigPeer::retrieveByGadgetIdAndName($this->getId(), $name); 54 if ($config) 55 { 56 $result = $config->getValue(); 57 } 58 elseif (isset($list[$this->getName()]['config'][$name]['Default'])) 59 { 60 $result = $list[$this->getName()]['config'][$name]['Default']; 61 } 62 63 return $result; 64 } 9 65 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/GadgetTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class GadgetTable extends Doctrine_Table 6 12 { 13 const HOME_TYPES = 'home'; 14 const LOGIN_TYPES = 'login'; 15 const MOBILE_HOME_TYPES = 'mobileHome'; 16 const SIDE_BANNER_TYPES = 'sideBanner'; 17 18 const TOP_TYPE = 'top'; 19 const SIDE_MENU_TYPE = 'sideMenu'; 20 const CONTENTS_TYPE = 'contents'; 21 const BOTTOM_TYPE = 'bottom'; 22 23 const LOGIN_TOP_TYPE = 'loginTop'; 24 const LOGIN_SIDE_MENU_TYPE = 'loginSideMenu'; 25 const LOGIN_CONTENTS_TYPE = 'loginContents'; 26 const LOGIN_BOTTOM_TYPE = 'loginBottom'; 27 28 const MOBILE_TOP_TYPE = 'mobileTop'; 29 const MOBILE_CONTENTS_TYPE = 'mobileContents'; 30 const MOBILE_BOTTOM_TYPE = 'mobileBottom'; 31 32 const SIDE_BANNER_CONTENTS_TYPE = 'sideBannerContents'; 33 34 protected 35 $homeTypes = array(self::TOP_TYPE, self::SIDE_MENU_TYPE, self::CONTENTS_TYPE, self::BOTTOM_TYPE), 36 $loginTypes = array(self::LOGIN_TOP_TYPE, self::LOGIN_SIDE_MENU_TYPE, self::LOGIN_CONTENTS_TYPE, self::LOGIN_BOTTOM_TYPE), 37 $mobileHomeTypes = array(self::MOBILE_TOP_TYPE, self::MOBILE_CONTENTS_TYPE, self::MOBILE_BOTTOM_TYPE), 38 $sideBannerTypes = array(self::SIDE_BANNER_CONTENTS_TYPE), 39 $results; 40 41 public function retrieveGadgetsByTypesName($typesName) 42 { 43 $results = array(); 44 switch ($typesName) 45 { 46 case self::MOBILE_HOME_TYPES: 47 $types = $this->mobileHomeTypes; 48 break; 49 case self::LOGIN_TYPES: 50 $types = $this->loginTypes; 51 break; 52 case self::SIDE_BANNER_TYPES: 53 $types = $this->sideBannerTypes; 54 break; 55 default: 56 $types = $this->homeTypes; 57 } 58 59 foreach($types as $type) 60 { 61 $results[$type] = $this->retrieveByType($type); 62 } 63 64 return $results; 65 } 66 67 public function retrieveTopGadgets() 68 { 69 return $this->retrieveByType(self::TOP_TYPE); 70 } 71 72 public function retrieveSideMenuGadgets() 73 { 74 return $this->retrieveByType(self::SIDE_MENU_TYPE); 75 } 76 77 public function retrieveContentsGadgets() 78 { 79 return $this->retrieveByType(self::CONTENTS_TYPE); 80 } 81 82 public function retrieveBottomGadgets() 83 { 84 return $this->retrieveByType(self::BOTTOM_TYPE); 85 } 86 87 public function retrieveLoginTopGadgets() 88 { 89 return $this->retrieveByType(self::LOGIN_TOP_TYPE); 90 } 91 92 public function retrieveLoginSideMenuGadgets() 93 { 94 return $this->retrieveByType(self::LOGIN_SIDE_MENU_TYPE); 95 } 96 97 public function retrieveLoginContentsGadgets() 98 { 99 return $this->retrieveByType(self::LOGIN_CONTENTS_TYPE); 100 } 101 102 public function retrieveLoginBottomGadgets() 103 { 104 return $this->retrieveByType(self::LOGIN_BOTTOM_TYPE); 105 } 106 107 public function retrieveMobileTopGadgets() 108 { 109 return $this->retrieveByType(self::MOBILE_TOP_TYPE); 110 } 111 112 public function retrieveMobileContentsGadgets() 113 { 114 return $this->retrieveByType(self::MOBILE_CONTENTS_TYPE); 115 } 116 117 public function retrieveMobileBottomGadgets() 118 { 119 return $this->retrieveByType(self::MOBILE_BOTTOM_TYPE); 120 } 121 122 public function retrieveSideBannerContentsGadgets() 123 { 124 return $this->retrieveByType(self::SIDE_BANNER_CONTENTS_TYPE); 125 } 126 127 public function getTopGadgetsIds() 128 { 129 return $this->getGadgetsIds(self::TOP_TYPE); 130 } 131 132 public function getSideMenuGadgetsIds() 133 { 134 return $this->getGadgetsIds(self::SIDE_MENU_TYPE); 135 } 136 137 public function getContentsGadgetsIds() 138 { 139 return $this->getGadgetsIds(self::CONTENTS_TYPE); 140 } 141 142 public function retrieveByType($type) 143 { 144 $results = $this->getResults(); 145 146 return (isset($results[$type])) ? $results[$type] : null; 147 } 148 149 public function getGadgetsIds($type) 150 { 151 return $this->createQuery() 152 ->select('id') 153 ->where('type', $type) 154 ->orderBy('sort_order') 155 ->fetchArray(); 156 } 157 158 protected function getResults() 159 { 160 if (is_null($this->results)) 161 { 162 $this->results = array(); 163 $objects = $this->createQuery()->orderBy('sort_order')->execute(); 164 foreach ($objects as $object) 165 { 166 $this->results[$object->type][] = $object; 167 } 168 } 169 170 return $this->results; 171 } 172 173 public function getGadgetConfigListByType($type) 174 { 175 if (in_array($type, $this->homeTypes)) 176 { 177 return sfConfig::get('op_gadget_list', array()); 178 } 179 elseif (in_array($type, $this->loginTypes)) 180 { 181 return sfConfig::get('op_login_gadget_list', array()); 182 } 183 elseif (in_array($type, $this->mobileHomeTypes)) 184 { 185 return sfConfig::get('op_mobile_gadget_list', array()); 186 } 187 elseif (in_array($type, $this->sideBannerTypes)) 188 { 189 return sfConfig::get('op_side_banner_gadget_list', array()); 190 } 191 return array(); 192 } 7 193 8 194 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/Member.class.php
r11208 r11219 2 2 3 3 /** 4 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 5 9 */ 10 6 11 class Member extends BaseMember 7 12 { 8 13 public function getProfiles($viewableCheck = false, $myMemberId = null) 14 { 15 /* 16 if ($viewableCheck) 17 { 18 return MemberProfilePeer::getViewableProfileListByMemberId($this->getId(), $myMemberId); 19 } 20 return MemberProfilePeer::getProfileListByMemberId($this->getId()); 21 */ 22 23 return array(); 24 } 25 26 public function getProfile($profileName) 27 { 28 /* 29 $profile = MemberProfilePeer::retrieveByMemberIdAndProfileName($this->getId(), $profileName); 30 return $profile; 31 */ 32 33 return array(); 34 } 35 36 public function getConfig($configName) 37 { 38 $config = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId($configName, $this->getId()); 39 40 if (!$config) 41 { 42 return null; 43 } 44 45 return $config->getValue(); 46 } 47 48 public function setConfig($configName, $value) 49 { 50 $config = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId($configName, $this->getId()); 51 if (!$config) 52 { 53 $config = new MemberConfig(); 54 $config->setMember($this); 55 $config->setName($configName); 56 } 57 $config->setValue($value); 58 $config->save(); 59 } 60 61 public function getFriends($limit = null, $isRandom = false) 62 { 63 $q = Doctrine::getTable('MemberRelationship')->createQuery() 64 ->where('member_id_to = ?', $this->getId()) 65 ->andWhere('is_friend = ?', true) 66 ->leftJoin('Member m ON member_id_from = m.member_id'); 67 68 if (!is_null($limit)) 69 { 70 $q->limit($limit); 71 } 72 73 if ($isRandom) 74 { 75 $expr = new Doctrine_Expression('RANDOM()'); 76 $q->orderBy($expr); 77 } 78 79 return $q->execute(); 80 } 81 82 public function countFriends(Criteria $c = null) 83 { 84 /* 85 if (!$c) 86 { 87 $c = new Criteria(); 88 } 89 $c->add(MemberRelationshipPeer::MEMBER_ID_TO, $this->getId()); 90 $c->add(MemberRelationshipPeer::IS_FRIEND, true); 91 $c->addJoin(MemberPeer::ID, MemberRelationshipPeer::MEMBER_ID_FROM); 92 return MemberPeer::doCount($c); 93 */ 94 95 return 0; 96 } 97 98 public function getNameAndCount($format = '%s (%d)') 99 { 100 return sprintf($format, $this->getName(), $this->countFriends()); 101 } 102 103 public function getJoinCommunities($limit = null, Criteria $c = null) 104 { 105 /* 106 if (!$c) 107 { 108 $c = new Criteria(); 109 } 110 return CommunityPeer::retrievesByMemberId($this->getId(), $limit, $c); 111 */ 112 113 return array(); 114 } 115 116 public function getFriendPreTo(Criteria $c = null) 117 { 118 /* 119 if (!$c) 120 { 121 $c = new Criteria(); 122 } 123 $c->add(MemberRelationshipPeer::IS_FRIEND_PRE, true); 124 return $this->getMemberRelationshipsRelatedByMemberIdTo($c); 125 */ 126 127 return array(); 128 } 129 130 public function countFriendPreTo(Criteria $c = null) 131 { 132 /* 133 if (!$c) 134 { 135 $c = new Criteria(); 136 } 137 $c->add(MemberRelationshipPeer::IS_FRIEND_PRE, true); 138 return $this->countMemberRelationshipsRelatedByMemberIdTo($c); 139 */ 140 141 return array(); 142 } 143 144 public function getFriendPreFrom(Criteria $c = null) 145 { 146 /* 147 if (!$c) 148 { 149 $c = new Criteria(); 150 } 151 $c->add(MemberRelationshipPeer::IS_FRIEND_PRE, true); 152 return $this->getMemberRelationshipsRelatedByMemberIdFrom($c); 153 */ 154 155 return array(); 156 } 157 158 public function countFriendPreFrom(Criteria $c = null) 159 { 160 /* 161 if (!$c) 162 { 163 $c = new Criteria(); 164 } 165 $c->add(MemberRelationshipPeer::IS_FRIEND_PRE, true); 166 return $this->countMemberRelationshipsRelatedByMemberIdFrom($c); 167 */ 168 169 return 0; 170 } 171 172 public function getImage() 173 { 174 /* 175 $c = new Criteria(); 176 $c->addDescendingOrderByColumn(MemberImagePeer::IS_PRIMARY, true); 177 $result = $this->getMemberImages($c); 178 179 if ($result) 180 { 181 return array_shift($result); 182 } 183 */ 184 185 return false; 186 } 187 188 public function getImageFileName() 189 { 190 /* 191 if($this->getImage()) 192 { 193 return $this->getImage()->getFile(); 194 } 195 */ 196 return false; 197 } 198 199 public function updateLastLoginTime() 200 { 201 $this->setConfig('lastLogin', time()); 202 } 203 204 public function getLastLoginTime() 205 { 206 return $this->getConfig('lastLogin'); 207 } 208 209 public function isOnBlackList() 210 { 211 /* 212 $uid = $this->getConfig('mobile_uid'); 213 if ($uid) 214 { 215 return (bool)BlacklistPeer::retrieveByUid($uid); 216 } 217 */ 218 219 return false; 220 } 221 222 public function getInvitingMembers() 223 { 224 // return MemberPeer::retrivesByInviteMemberId($this->getId()); 225 226 return array(); 227 } 228 229 public function getInviteMember() 230 { 231 // return MemberPeer::retrieveByPk($this->getInviteMemberId()); 232 233 return null; 234 } 235 236 public function getEmailAddress($isPriorityMobile = null) 237 { 238 if (is_null($isPriorityMobile)) 239 { 240 $isPriorityMobile = false; 241 if (sfConfig::get('sf_app') == 'mobile_frontend') 242 { 243 $isPriorityMobile = true; 244 } 245 } 246 247 $memberPcAddress = $this->getConfig('pc_address'); 248 $memberMobileAddress = $this->getConfig('mobile_address'); 249 250 if ($memberMobileAddress && ($isPriorityMobile || !$memberPcAddress)) 251 { 252 return $memberMobileAddress; 253 } 254 255 if ($memberPcAddress) 256 { 257 return $memberPcAddress; 258 } 259 260 return null; 261 } 262 263 public function getEmailAddresses() 264 { 265 $result = array(); 266 267 $memberPcAddress = $this->getConfig('pc_address'); 268 $memberMobileAddress = $this->getConfig('mobile_address'); 269 270 if ($memberPcAddress) 271 { 272 $result[] = $memberPcAddress; 273 } 274 275 if ($memberMobileAddress) 276 { 277 $result[] = $memberMobileAddress; 278 } 279 280 return $result; 281 } 9 282 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/MemberConfigTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class MemberConfigTable extends Doctrine_Table 6 12 { 13 protected $results; 14 15 public function retrieveByNameAndMemberId($name, $memberId, $force = false) 16 { 17 $results = $this->getResultsByMemberId($memberId, $force); 18 return (isset($results[$name])) ? $results[$name] : null; 19 } 20 21 public function retrieveByNameAndValue($name, $value) 22 { 23 return $this->createQuery() 24 ->where('name = ?', $name) 25 ->andWhere('value = ?', $value) 26 ->fetchOne(); 27 } 28 29 public function retrievesByName($name) 30 { 31 return $this->createQuery() 32 ->where('name = ?', $name) 33 ->execute(); 34 } 35 36 public function deleteDuplicatedPre($memberId, $name, $value) 37 { 38 $memberConfig = $this->retrieveByNameAndMemberId($name.'_pre', $memberId); 39 if ($memberConfig) { 40 $memberConfig->delete(); 41 } 42 43 $memberConfigSettings = sfConfig::get('openpne_member_config'); 44 if ($memberConfigSettings[$name]['IsUnique']) { 45 $memberConfigs = $this->retrievesByName($name.'_pre'); 46 foreach ($memberConfigs as $config) { 47 if ($value === $config->getValue()) { 48 if (!$config->getMember()->getIsActive()) { 49 $config->getMember()->delete(); 50 } 51 $config->delete(); 52 } 53 } 54 } 55 } 56 57 protected function getResultsByMemberId($memberId, $force = false) 58 { 59 if (!isset($this->results[$memberId]) || $force) 60 { 61 $objects = $this->createQuery() 62 ->where('member_id = ?', $memberId) 63 ->execute(); 64 65 $this->results[$memberId] = array(); 66 foreach ($objects as $object) 67 { 68 $this->results[$memberId][$object->getName()] = $object; 69 } 70 } 71 72 return $this->results[$memberId]; 73 } 7 74 8 75 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/MemberProfile.class.php
r11208 r11219 2 2 3 3 /** 4 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 5 9 */ 10 6 11 class MemberProfile extends BaseMemberProfile 7 12 { -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/MemberProfileTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class MemberProfileTable extends Doctrine_Table 6 12 { -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/MemberRelationshipTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class MemberRelationshipTable extends Doctrine_Table 6 12 { 13 public function retrieveByFromAndTo($memberIdFrom, $memberIdTo) 14 { 15 return $this->createQuery() 16 ->where('member_id_from = ?', $memberIdFrom) 17 ->andWhere('member_id_to = ?', $memberIdTo) 18 ->fetchOne(); 19 } 7 20 21 public function retrievesByMemberIdFrom($memberId) 22 { 23 return $this->createQuery() 24 ->where('member_id_from = ?', $memberId) 25 ->execute(); 26 } 27 28 public function getFriendListPager($memberId, $page = 1, $size = 20) 29 { 30 /* 31 $c = new Criteria(); 32 $c->add(self::MEMBER_ID_TO, $memberId); 33 $c->add(self::IS_FRIEND, true); 34 $c->addJoin(MemberPeer::ID, self::MEMBER_ID_FROM); 35 36 $pager = new sfPropelPager('Member', $size); 37 $pager->setCriteria($c); 38 $pager->setPage($page); 39 $pager->init(); 40 41 return $pager; 42 */ 43 return null; 44 } 45 46 public function getFriendMemberIds($memberId) 47 { 48 return $this->createQuery() 49 ->select('id') 50 ->where('member_id_to = ?', $memberId) 51 ->andWhere('is_friend = ?', true) 52 ->fetchArray(); 53 } 8 54 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/MemberTable.class.php
r11208 r11219 5 5 class MemberTable extends Doctrine_Table 6 6 { 7 public function createPre() 8 { 9 $member = new Member(); 10 $member->setIsActive(false); 11 $member->save(); 7 12 13 return $member; 14 } 8 15 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/Navigation.class.php
r11208 r11219 6 6 class Navigation extends BaseNavigation 7 7 { 8 9 8 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/NavigationTable.class.php
r11208 r11219 1 1 <?php 2 2 3 /** 3 * This class has been auto-generated by the Doctrine ORM Framework 4 * This file is part of the OpenPNE package. 5 * (c) OpenPNE Project (http://www.openpne.jp/) 6 * 7 * For the full copyright and license information, please view the LICENSE 8 * file and the NOTICE file that were distributed with this source code. 4 9 */ 10 5 11 class NavigationTable extends Doctrine_Table 6 12 { 13 public function retrieveByType($type) 14 { 15 return $this->createQuery() 16 ->where('type = ?', $type) 17 ->orderBy('sort_order') 18 ->execute(); 19 } 7 20 21 public function retrieveTypes($isMobile) 22 { 23 $result = array(); 24 25 if ($isMobile) 26 { 27 $defaultTypes = array( 28 'mobile_global', 29 'mobile_home', 30 'mobile_home_side', 31 'mobile_friend', 32 'mobile_community', 33 ); 34 } 35 else 36 { 37 $defaultTypes = array( 38 'insecure_global', 39 'secure_global', 40 'default', 41 'friend', 42 'community', 43 ); 44 } 45 46 $result = $this->createQuery() 47 ->select('type') 48 ->groupBy('type') 49 ->orderBy('sort_order') 50 ->fetchArray(); 51 52 return array_unique(array_merge($defaultTypes, $result)); 53 } 8 54 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseAdminUser.class.php
r11208 r11219 6 6 abstract class BaseAdminUser extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('admin_user'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('username', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('password', 'string', 40, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '40')); 14 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('admin_user'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('username', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('password', 'string', 40, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '40')); 14 15 $this->option('charset', 'utf8'); 16 } 15 17 16 18 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseBlacklist.class.php
r11208 r11219 6 6 abstract class BaseBlacklist extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('blacklist'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('uid', 'string', 32, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '32')); 13 $this->hasColumn('memo', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 14 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('blacklist'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('uid', 'string', 32, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '32')); 13 $this->hasColumn('memo', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 14 15 $this->option('charset', 'utf8'); 16 } 15 17 16 18 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseCommunity.class.php
r11208 r11219 6 6 abstract class BaseCommunity extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('community'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('file_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 14 $this->hasColumn('community_category_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('community'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('file_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 14 $this->hasColumn('community_category_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('File', array('local' => 'file_id', 20 'foreign' => 'id')); 16 $this->option('charset', 'utf8'); 17 } 21 18 22 $this->hasOne('CommunityCategory', array('local' => 'community_category_id', 23 'foreign' => 'id')); 19 public function setUp() 20 { 21 $this->hasOne('File', array('local' => 'file_id', 22 'foreign' => 'id')); 24 23 25 $this->hasMany('CommunityMember', array('local' => 'id',26 'foreign' => 'community_id'));24 $this->hasOne('CommunityCategory', array('local' => 'community_category_id', 25 'foreign' => 'id')); 27 26 28 $this->hasMany('CommunityConfig', array('local' => 'id',29 'foreign' => 'community_id'));27 $this->hasMany('CommunityMember', array('local' => 'id', 28 'foreign' => 'community_id')); 30 29 31 $timestampable0 = new Doctrine_Template_Timestampable(); 32 $this->actAs($timestampable0); 33 } 30 $this->hasMany('CommunityConfig', array('local' => 'id', 31 'foreign' => 'community_id')); 32 33 $timestampable0 = new Doctrine_Template_Timestampable(); 34 $this->actAs($timestampable0); 35 } 34 36 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseCommunityCategory.class.php
r11208 r11219 6 6 abstract class BaseCommunityCategory extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('community_category'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('lft_key', 'integer', 4, array('type' => 'integer', 'default' => '0', 'length' => '4')); 13 $this->hasColumn('rht_key', 'integer', 4, array('type' => 'integer', 'default' => '0', 'length' => '4')); 14 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 15 $this->hasColumn('is_allow_member_community', 'integer', 1, array('type' => 'integer', 'default' => '1', 'notnull' => true, 'length' => '1')); 16 $this->hasColumn('tree_key', 'integer', 4, array('type' => 'integer', 'length' => '4')); 17 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 18 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('community_category'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('lft_key', 'integer', 4, array('type' => 'integer', 'default' => '0', 'length' => '4')); 13 $this->hasColumn('rht_key', 'integer', 4, array('type' => 'integer', 'default' => '0', 'length' => '4')); 14 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 15 $this->hasColumn('is_allow_member_community', 'integer', 1, array('type' => 'integer', 'default' => '1', 'notnull' => true, 'length' => '1')); 16 $this->hasColumn('tree_key', 'integer', 4, array('type' => 'integer', 'length' => '4')); 17 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 19 18 20 public function setUp() 21 { 22 $this->hasMany('Community', array('local' => 'id', 23 'foreign' => 'community_category_id')); 24 } 19 $this->option('charset', 'utf8'); 20 } 21 22 public function setUp() 23 { 24 $this->hasMany('Community', array('local' => 'id', 25 'foreign' => 'community_category_id')); 26 } 25 27 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseCommunityConfig.class.php
r11208 r11219 6 6 abstract class BaseCommunityConfig extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('community_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('community_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('community_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('community_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Community', array('local' => 'community_id', 20 'foreign' => 'id')); 21 } 16 $this->option('charset', 'utf8'); 17 } 18 19 public function setUp() 20 { 21 $this->hasOne('Community', array('local' => 'community_id', 22 'foreign' => 'id')); 23 } 22 24 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseCommunityMember.class.php
r11208 r11219 6 6 abstract class BaseCommunityMember extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('community_member'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('community_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('position', 'string', 32, array('type' => 'string', 'default' => '', 'length' => '32')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('community_member'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('community_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('position', 'string', 32, array('type' => 'string', 'default' => '', 'length' => '32')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Community', array('local' => 'community_id', 20 'foreign' => 'id')); 16 $this->option('charset', 'utf8'); 17 } 21 18 22 $this->hasOne('Member', array('local' => 'member_id', 23 'foreign' => 'id')); 24 } 19 public function setUp() 20 { 21 $this->hasOne('Community', array('local' => 'community_id', 22 'foreign' => 'id')); 23 24 $this->hasOne('Member', array('local' => 'member_id', 25 'foreign' => 'id')); 26 } 25 27 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseFile.class.php
r11208 r11219 6 6 abstract class BaseFile extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('file'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('type', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('original_filename', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('file'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('type', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('original_filename', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 16 15 17 public function setUp() 18 { 19 $this->hasMany('Community', array('local' => 'id', 20 'foreign' => 'file_id')); 16 $this->option('charset', 'utf8'); 17 } 21 18 22 $this->hasMany('MemberImage', array('local' => 'id', 19 public function setUp() 20 { 21 $this->hasMany('Community', array('local' => 'id', 22 'foreign' => 'file_id')); 23 24 $this->hasMany('MemberImage', array('local' => 'id', 25 'foreign' => 'file_id')); 26 27 $this->hasMany('FileBin', array('local' => 'id', 23 28 'foreign' => 'file_id')); 24 29 25 $this->hasMany('FileBin', array('local' => 'id', 26 'foreign' => 'file_id')); 27 28 $timestampable0 = new Doctrine_Template_Timestampable(); 29 $this->actAs($timestampable0); 30 } 30 $timestampable0 = new Doctrine_Template_Timestampable(); 31 $this->actAs($timestampable0); 32 } 31 33 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseFileBin.class.php
r11208 r11219 6 6 abstract class BaseFileBin extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('file_bin'); 11 $this->hasColumn('file_id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'length' => '4')); 12 $this->hasColumn('bin', 'blob', 2147483647, array('type' => 'blob', 'length' => '2147483647')); 13 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('file_bin'); 11 $this->hasColumn('file_id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'length' => '4')); 12 $this->hasColumn('bin', 'blob', 2147483647, array('type' => 'blob', 'length' => '2147483647')); 14 13 15 public function setUp() 16 { 17 $this->hasOne('File', array('local' => 'file_id', 18 'foreign' => 'id')); 19 } 14 $this->option('charset', 'utf8'); 15 } 16 17 public function setUp() 18 { 19 $this->hasOne('File', array('local' => 'file_id', 20 'foreign' => 'id')); 21 } 20 22 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseGadget.class.php
r11208 r11219 6 6 abstract class BaseGadget extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('gadget'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('type', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('gadget'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('type', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 16 15 17 public function setUp() 18 { 19 $this->hasMany('GadgetConfig', array('local' => 'id', 20 'foreign' => 'gadget_id')); 21 } 16 $this->option('charset', 'utf8'); 17 } 18 19 public function setUp() 20 { 21 $this->hasMany('GadgetConfig', array('local' => 'id', 22 'foreign' => 'gadget_id')); 23 } 22 24 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseGadgetConfig.class.php
r11208 r11219 6 6 abstract class BaseGadgetConfig extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('gadget_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('gadget_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 14 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('gadget_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('gadget_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 14 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Gadget', array('local' => 'gadget_id', 20 'foreign' => 'id')); 21 } 16 $this->option('charset', 'utf8'); 17 } 18 19 public function setUp() 20 { 21 $this->hasOne('Gadget', array('local' => 'gadget_id', 22 'foreign' => 'id')); 23 } 22 24 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseMember.class.php
r11208 r11219 6 6 abstract class BaseMember extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('member'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('is_active', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 14 $this->hasColumn('invite_member_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('member'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('is_active', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 14 $this->hasColumn('invite_member_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Member', array('local' => 'invite_member_id', 20 'foreign' => 'id')); 16 $this->option('charset', 'utf8'); 17 } 21 18 22 $this->hasMany('CommunityMember', array('local' => 'id', 19 public function setUp() 20 { 21 $this->hasOne('Member', array('local' => 'invite_member_id', 22 'foreign' => 'id')); 23 24 $this->hasMany('CommunityMember', array('local' => 'id', 25 'foreign' => 'member_id')); 26 27 $this->hasMany('MemberRelationship', array('local' => 'id', 28 'foreign' => 'member_id_to')); 29 30 $this->hasMany('MemberConfig', array('local' => 'id', 31 'foreign' => 'member_id')); 32 33 $this->hasMany('MemberImage', array('local' => 'id', 23 34 'foreign' => 'member_id')); 24 35 25 $this->hasMany('MemberRelationship', array('local' => 'id',26 'foreign' => 'member_id_to'));36 $this->hasMany('MemberProfile', array('local' => 'id', 37 'foreign' => 'member_id')); 27 38 28 $this->hasMany('MemberConfig', array('local' => 'id', 29 'foreign' => 'member_id')); 30 31 $this->hasMany('MemberImage', array('local' => 'id', 32 'foreign' => 'member_id')); 33 34 $this->hasMany('MemberProfile', array('local' => 'id', 35 'foreign' => 'member_id')); 36 37 $timestampable0 = new Doctrine_Template_Timestampable(); 38 $this->actAs($timestampable0); 39 } 39 $timestampable0 = new Doctrine_Template_Timestampable(); 40 $this->actAs($timestampable0); 41 } 40 42 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseMemberConfig.class.php
r11208 r11219 6 6 abstract class BaseMemberConfig extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Member', array('local' => 'member_id', 20 'foreign' => 'id')); 21 } 16 $this->option('charset', 'utf8'); 17 } 18 19 public function setUp() 20 { 21 $this->hasOne('Member', array('local' => 'member_id', 22 'foreign' => 'id')); 23 } 22 24 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseMemberImage.class.php
r11208 r11219 6 6 abstract class BaseMemberImage extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_image'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('file_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('is_primary', 'integer', 1, array('type' => 'integer', 'length' => '1')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_image'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('file_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('is_primary', 'integer', 1, array('type' => 'integer', 'length' => '1')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Member', array('local' => 'member_id', 20 'foreign' => 'id')); 16 $this->option('charset', 'utf8'); 17 } 21 18 22 $this->hasOne('File', array('local' => 'file_id', 23 'foreign' => 'id')); 24 } 19 public function setUp() 20 { 21 $this->hasOne('Member', array('local' => 'member_id', 22 'foreign' => 'id')); 23 24 $this->hasOne('File', array('local' => 'file_id', 25 'foreign' => 'id')); 26 } 25 27 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseMemberProfile.class.php
r11208 r11219 6 6 abstract class BaseMemberProfile extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_profile'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('profile_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('profile_option_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 15 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 16 $this->hasColumn('public_flag', 'integer', 1, array('type' => 'integer', 'length' => '1')); 17 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_profile'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('profile_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('profile_option_id', 'integer', 4, array('type' => 'integer', 'length' => '4')); 15 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 16 $this->hasColumn('public_flag', 'integer', 1, array('type' => 'integer', 'length' => '1')); 18 17 19 public function setUp() 20 { 21 $this->hasOne('Member', array('local' => 'member_id', 22 'foreign' => 'id')); 18 $this->option('charset', 'utf8'); 19 } 23 20 24 $this->hasOne('Profile', array('local' => 'profile_id', 25 'foreign' => 'id')); 21 public function setUp() 22 { 23 $this->hasOne('Member', array('local' => 'member_id', 24 'foreign' => 'id')); 26 25 27 $this->hasOne('ProfileOption', array('local' => 'profile_option_id',28 26 $this->hasOne('Profile', array('local' => 'profile_id', 27 'foreign' => 'id')); 29 28 30 $nestedset0 = new Doctrine_Template_NestedSet(array('hasManyRoots' => true, 'rootColumnName' => 'tree_key')); 31 $this->actAs($nestedset0); 32 } 29 $this->hasOne('ProfileOption', array('local' => 'profile_option_id', 30 'foreign' => 'id')); 31 32 $nestedset0 = new Doctrine_Template_NestedSet(array('hasManyRoots' => true, 'rootColumnName' => 'tree_key')); 33 $this->actAs($nestedset0); 34 } 33 35 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseMemberRelationship.class.php
r11208 r11219 6 6 abstract class BaseMemberRelationship extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_relationship'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id_to', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('member_id_from', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('is_friend', 'integer', 1, array('type' => 'integer', 'length' => '1')); 15 $this->hasColumn('is_friend_pre', 'integer', 1, array('type' => 'integer', 'length' => '1')); 16 $this->hasColumn('is_access_block', 'integer', 1, array('type' => 'integer', 'length' => '1')); 17 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('member_relationship'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('member_id_to', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('member_id_from', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 14 $this->hasColumn('is_friend', 'integer', 1, array('type' => 'integer', 'length' => '1')); 15 $this->hasColumn('is_friend_pre', 'integer', 1, array('type' => 'integer', 'length' => '1')); 16 $this->hasColumn('is_access_block', 'integer', 1, array('type' => 'integer', 'length' => '1')); 18 17 19 public function setUp() 20 { 21 $this->hasOne('Member', array('local' => 'member_id_to', 22 'foreign' => 'id')); 18 $this->option('charset', 'utf8'); 19 } 23 20 24 $this->hasOne('Member as Member_2', array('local' => 'member_id_from', 25 'foreign' => 'id')); 26 } 21 public function setUp() 22 { 23 $this->hasOne('Member', array('local' => 'member_id_to', 24 'foreign' => 'id')); 25 26 $this->hasOne('Member as Member_2', array('local' => 'member_id_from', 27 'foreign' => 'id')); 28 } 27 29 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseNavigation.class.php
r11208 r11219 6 6 abstract class BaseNavigation extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('navigation'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('caption', 'string', 2147483647, array('type' => 'string', 'notnull' => true, 'length' => '2147483647')); 13 $this->hasColumn('type', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('uri', 'string', 2147483647, array('type' => 'string', 'notnull' => true, 'length' => '2147483647')); 15 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 16 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('navigation'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('caption', 'string', 2147483647, array('type' => 'string', 'notnull' => true, 'length' => '2147483647')); 13 $this->hasColumn('type', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 14 $this->hasColumn('uri', 'string', 2147483647, array('type' => 'string', 'notnull' => true, 'length' => '2147483647')); 15 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 17 16 18 public function setUp() 19 { 20 $i18n0 = new Doctrine_Template_I18n(array('fields' => array(0 => 'caption'))); 21 $this->actAs($i18n0); 22 } 17 $this->option('charset', 'utf8'); 18 } 19 20 public function setUp() 21 { 22 $i18n0 = new Doctrine_Template_I18n(array('fields' => array(0 => 'caption'), 'length' => '5')); 23 $this->actAs($i18n0); 24 } 23 25 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseProfile.class.php
r11208 r11219 6 6 abstract class BaseProfile extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('profile'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('is_required', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 14 $this->hasColumn('is_unique', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 15 $this->hasColumn('is_edit_public_flag', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 16 $this->hasColumn('default_public_flag', 'integer', 1, array('type' => 'integer', 'default' => '1', 'notnull' => true, 'length' => '1')); 17 $this->hasColumn('form_type', 'string', 32, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '32')); 18 $this->hasColumn('value_type', 'string', 32, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '32')); 19 $this->hasColumn('is_disp_regist', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 20 $this->hasColumn('is_disp_config', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 21 $this->hasColumn('is_disp_search', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 22 $this->hasColumn('value_regexp', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 23 $this->hasColumn('value_min', 'string', 32, array('type' => 'string', 'length' => '32')); 24 $this->hasColumn('value_max', 'string', 32, array('type' => 'string', 'length' => '32')); 25 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 26 $this->hasColumn('caption', 'string', 2147483647, array('type' => 'string', 'notnull' => true, 'length' => '2147483647')); 27 $this->hasColumn('info', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 28 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('profile'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('is_required', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 14 $this->hasColumn('is_unique', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 15 $this->hasColumn('is_edit_public_flag', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 16 $this->hasColumn('default_public_flag', 'integer', 1, array('type' => 'integer', 'default' => '1', 'notnull' => true, 'length' => '1')); 17 $this->hasColumn('form_type', 'string', 32, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '32')); 18 $this->hasColumn('value_type', 'string', 32, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '32')); 19 $this->hasColumn('is_disp_regist', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 20 $this->hasColumn('is_disp_config', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 21 $this->hasColumn('is_disp_search', 'integer', 1, array('type' => 'integer', 'default' => '0', 'notnull' => true, 'length' => '1')); 22 $this->hasColumn('value_regexp', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 23 $this->hasColumn('value_min', 'string', 32, array('type' => 'string', 'length' => '32')); 24 $this->hasColumn('value_max', 'string', 32, array('type' => 'string', 'length' => '32')); 25 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 26 $this->hasColumn('caption', 'string', 2147483647, array('type' => 'string', 'notnull' => true, 'length' => '2147483647')); 27 $this->hasColumn('info', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 29 28 30 public function setUp() 31 { 32 $this->hasMany('MemberProfile', array('local' => 'id', 33 'foreign' => 'profile_id')); 29 $this->option('charset', 'utf8'); 30 } 34 31 35 $this->hasMany('ProfileOption', array('local' => 'id', 36 'foreign' => 'profile_id')); 32 public function setUp() 33 { 34 $this->hasMany('MemberProfile', array('local' => 'id', 35 'foreign' => 'profile_id')); 37 36 38 $i18n0 = new Doctrine_Template_I18n(array('fields' => array(0 => 'caption', 1 => 'info'))); 39 $this->actAs($i18n0); 40 } 37 $this->hasMany('ProfileOption', array('local' => 'id', 38 'foreign' => 'profile_id')); 39 40 $i18n0 = new Doctrine_Template_I18n(array('fields' => array(0 => 'caption', 1 => 'info'), 'length' => '5')); 41 $this->actAs($i18n0); 42 } 41 43 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseProfileOption.class.php
r11208 r11219 6 6 abstract class BaseProfileOption extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('profile_option'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('profile_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 14 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 15 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('profile_option'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('profile_id', 'integer', 4, array('type' => 'integer', 'notnull' => true, 'length' => '4')); 13 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 14 $this->hasColumn('sort_order', 'integer', 4, array('type' => 'integer', 'length' => '4')); 16 15 17 public function setUp() 18 { 19 $this->hasOne('Profile', array('local' => 'profile_id', 20 'foreign' => 'id')); 16 $this->option('charset', 'utf8'); 17 } 21 18 22 $this->hasMany('MemberProfile', array('local' => 'id', 23 'foreign' => 'profile_option_id')); 19 public function setUp() 20 { 21 $this->hasOne('Profile', array('local' => 'profile_id', 22 'foreign' => 'id')); 24 23 25 $i18n0 = new Doctrine_Template_I18n(array('fields' => array(0 => 'value'))); 26 $this->actAs($i18n0); 27 } 24 $this->hasMany('MemberProfile', array('local' => 'id', 25 'foreign' => 'profile_option_id')); 26 27 $i18n0 = new Doctrine_Template_I18n(array('fields' => array(0 => 'value'), 'length' => '5')); 28 $this->actAs($i18n0); 29 } 28 30 } -
OpenPNE3/branches/goto_doctrine/lib/model/doctrine/base/BaseSnsConfig.class.php
r11208 r11219 6 6 abstract class BaseSnsConfig extends sfDoctrineRecord 7 7 { 8 public function setTableDefinition() 9 { 10 $this->setTableName('sns_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 14 } 8 public function setTableDefinition() 9 { 10 $this->setTableName('sns_config'); 11 $this->hasColumn('id', 'integer', 4, array('type' => 'integer', 'primary' => true, 'autoincrement' => true, 'length' => '4')); 12 $this->hasColumn('name', 'string', 64, array('type' => 'string', 'default' => '', 'notnull' => true, 'length' => '64')); 13 $this->hasColumn('value', 'string', 2147483647, array('type' => 'string', 'length' => '2147483647')); 14 15 $this->option('charset', 'utf8'); 16 } 15 17 16 18 } -
OpenPNE3/branches/goto_doctrine/lib/user/sfOpenPNESecurityUser.class.php
r10122 r11219 128 128 public function getMember() 129 129 { 130 return MemberPeer::retrieveByPk($this->getMemberId());130 return Doctrine::getTable('Member')->find($this->getMemberId()); 131 131 } 132 132 -
OpenPNE3/branches/goto_doctrine/lib/validator/opAuthValidatorMemberConfig.class.php
r10003 r11219 59 59 $fieldName = $configName; 60 60 } 61 $memberConfig = MemberConfigPeer::retrieveByNameAndValue($configName, $values[$fieldName]);61 $memberConfig = Doctrine::getTable('MemberConfig')->retrieveByNameAndValue($configName, $values[$fieldName]); 62 62 if ($memberConfig) 63 63 { -
OpenPNE3/branches/goto_doctrine/lib/validator/opAuthValidatorMemberConfigAndPassword.class.php
r10003 r11219 41 41 } 42 42 43 $valid_password = MemberConfigPeer::retrieveByNameAndMemberId('password', $values['member']->getId())->getValue();43 $valid_password = Doctrine::getTable('MemberConfig')->retrieveByNameAndMemberId('password', $values['member']->getId())->getValue(); 44 44 opActivateBehavior::enable(); 45 45 if (md5($values['password']) !== $valid_password)
Note: See TracChangeset
for help on using the changeset viewer.