[Logicampus-svn] SF.net SVN: logicampus:[1297] logicampus/trunk/src/logicreate/lib
Brought to you by:
trilexcom
From: <fah...@us...> - 2009-02-27 12:07:29
|
Revision: 1297 http://logicampus.svn.sourceforge.net/logicampus/?rev=1297&view=rev Author: faheemkhan Date: 2009-02-27 12:07:22 +0000 (Fri, 27 Feb 2009) Log Message: ----------- Added Paths: ----------- logicampus/trunk/src/logicreate/lib/PBDO/ logicampus/trunk/src/logicreate/lib/PBDO/AssessmentEventLink.php logicampus/trunk/src/logicreate/lib/PBDO/Chat.php logicampus/trunk/src/logicreate/lib/PBDO/ChatQueue.php logicampus/trunk/src/logicreate/lib/PBDO/ClassAnnouncements.php logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsGrades.php logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsTurnin.php logicampus/trunk/src/logicreate/lib/PBDO/ClassEnrollment.php logicampus/trunk/src/logicreate/lib/PBDO/ClassExtraFaculty.php logicampus/trunk/src/logicreate/lib/PBDO/ClassFaqs.php logicampus/trunk/src/logicreate/lib/PBDO/ClassForum.php logicampus/trunk/src/logicreate/lib/PBDO/ClassForumCategory.php logicampus/trunk/src/logicreate/lib/PBDO/ClassForumPost.php logicampus/trunk/src/logicreate/lib/PBDO/ClassForumTrashPost.php logicampus/trunk/src/logicreate/lib/PBDO/ClassForumUserActivity.php logicampus/trunk/src/logicreate/lib/PBDO/ClassGroup.php logicampus/trunk/src/logicreate/lib/PBDO/ClassGroupMember.php logicampus/trunk/src/logicreate/lib/PBDO/ClassLessonLinks.php logicampus/trunk/src/logicreate/lib/PBDO/ClassLessonObjectives.php logicampus/trunk/src/logicreate/lib/PBDO/ClassLessonSequence.php logicampus/trunk/src/logicreate/lib/PBDO/ClassLessons.php logicampus/trunk/src/logicreate/lib/PBDO/ClassLinks.php logicampus/trunk/src/logicreate/lib/PBDO/ClassLinksCategories.php logicampus/trunk/src/logicreate/lib/PBDO/ClassObjectives.php logicampus/trunk/src/logicreate/lib/PBDO/ClassPresentations.php logicampus/trunk/src/logicreate/lib/PBDO/ClassSections.php logicampus/trunk/src/logicreate/lib/PBDO/ClassStudentSections.php logicampus/trunk/src/logicreate/lib/PBDO/ClassSyllabus.php logicampus/trunk/src/logicreate/lib/PBDO/Classes.php logicampus/trunk/src/logicreate/lib/PBDO/Courses.php logicampus/trunk/src/logicreate/lib/PBDO/DocsDirectories.php logicampus/trunk/src/logicreate/lib/PBDO/DocsDirectoriesFiles.php logicampus/trunk/src/logicreate/lib/PBDO/DocsDirectoriesGroups.php logicampus/trunk/src/logicreate/lib/PBDO/DocsFiles.php logicampus/trunk/src/logicreate/lib/PBDO/DocsFilesGroups.php logicampus/trunk/src/logicreate/lib/PBDO/DocsFiletypes.php logicampus/trunk/src/logicreate/lib/PBDO/LcActionLog.php logicampus/trunk/src/logicreate/lib/PBDO/LcActionLogType.php logicampus/trunk/src/logicreate/lib/PBDO/LcEvent.php logicampus/trunk/src/logicreate/lib/PBDO/LcUsersLastLogin.php logicampus/trunk/src/logicreate/lib/PBDO/LcUsersLoginAttempt.php logicampus/trunk/src/logicreate/lib/PBDO/LobActivity.php logicampus/trunk/src/logicreate/lib/PBDO/LobClassActivity.php logicampus/trunk/src/logicreate/lib/PBDO/LobClassContent.php logicampus/trunk/src/logicreate/lib/PBDO/LobClassMetadata.php logicampus/trunk/src/logicreate/lib/PBDO/LobClassRepo.php logicampus/trunk/src/logicreate/lib/PBDO/LobClassTest.php logicampus/trunk/src/logicreate/lib/PBDO/LobContent.php logicampus/trunk/src/logicreate/lib/PBDO/LobMetadata.php logicampus/trunk/src/logicreate/lib/PBDO/LobRepoEntry.php logicampus/trunk/src/logicreate/lib/PBDO/LobTest.php logicampus/trunk/src/logicreate/lib/PBDO/LobTestQst.php logicampus/trunk/src/logicreate/lib/PBDO/LobUserLink.php logicampus/trunk/src/logicreate/lib/PBDO/Photos.php logicampus/trunk/src/logicreate/lib/PBDO/PrivateMessages.php logicampus/trunk/src/logicreate/lib/PBDO/Profile.php logicampus/trunk/src/logicreate/lib/PBDO/ProfileFaculty.php logicampus/trunk/src/logicreate/lib/PBDO/ProfileFacultyCoursefamily.php logicampus/trunk/src/logicreate/lib/PBDO/ProfileStudent.php logicampus/trunk/src/logicreate/lib/PBDO/RemoteTestFiles.php logicampus/trunk/src/logicreate/lib/PBDO/Semesters.php logicampus/trunk/src/logicreate/lib/PBDO/SemestersCourseInfo.php logicampus/trunk/src/logicreate/lib/PBDO/TextbookEstimates.php Added: logicampus/trunk/src/logicreate/lib/PBDO/AssessmentEventLink.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/AssessmentEventLink.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/AssessmentEventLink.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,229 @@ +<? + +class AssessmentEventLinkBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $assessmentEventLinkId; + var $assessmentId; + var $lcEventId; + + var $__attributes = array( + 'assessmentEventLinkId'=>'int', + 'assessmentId'=>'int', + 'lcEventId'=>'int'); + + var $__nulls = array(); + + + + function getPrimaryKey() { + return $this->assessmentEventLinkId; + } + + + function setPrimaryKey($val) { + $this->assessmentEventLinkId = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(AssessmentEventLinkPeer::doInsert($this,$dsn)); + } else { + AssessmentEventLinkPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "assessment_event_link_id='".$key."'"; + } + $array = AssessmentEventLinkPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = AssessmentEventLinkPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + AssessmentEventLinkPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class AssessmentEventLinkPeerBase { + + var $tableName = 'assessment_event_link'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("assessment_event_link",$where); + $st->fields['assessment_event_link_id'] = 'assessment_event_link_id'; + $st->fields['assessment_id'] = 'assessment_id'; + $st->fields['lc_event_id'] = 'lc_event_id'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = AssessmentEventLinkPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("assessment_event_link"); + $st->fields['assessment_event_link_id'] = $this->assessmentEventLinkId; + $st->fields['assessment_id'] = $this->assessmentId; + $st->fields['lc_event_id'] = $this->lcEventId; + + + $st->key = 'assessment_event_link_id'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("assessment_event_link"); + $st->fields['assessment_event_link_id'] = $obj->assessmentEventLinkId; + $st->fields['assessment_id'] = $obj->assessmentId; + $st->fields['lc_event_id'] = $obj->lcEventId; + + + $st->key = 'assessment_event_link_id'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("assessment_event_link","assessment_event_link_id = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new AssessmentEventLink(); + $x->assessmentEventLinkId = $row['assessment_event_link_id']; + $x->assessmentId = $row['assessment_id']; + $x->lcEventId = $row['lc_event_id']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class AssessmentEventLink extends AssessmentEventLinkBase { + + + +} + + + +class AssessmentEventLinkPeer extends AssessmentEventLinkPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/Chat.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/Chat.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/Chat.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,268 @@ +<? + +class ChatBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $pkey; + var $chatId; + var $username; + var $userpkey; + var $usertype; + var $timeint; + var $timedate; + var $message; + var $entryType; + + var $__attributes = array( + 'pkey'=>'integer', + 'chatId'=>'varchar', + 'username'=>'varchar', + 'userpkey'=>'integer', + 'usertype'=>'integer', + 'timeint'=>'integer', + 'timedate'=>'date', + 'message'=>'longvarchar', + 'entryType'=>'integer'); + + var $__nulls = array( + 'entryType'=>'entryType'); + + + + function getPrimaryKey() { + return $this->pkey; + } + + + function setPrimaryKey($val) { + $this->pkey = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ChatPeer::doInsert($this,$dsn)); + } else { + ChatPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "pkey='".$key."'"; + } + $array = ChatPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ChatPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ChatPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ChatPeerBase { + + var $tableName = 'chat'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("chat",$where); + $st->fields['pkey'] = 'pkey'; + $st->fields['chat_id'] = 'chat_id'; + $st->fields['username'] = 'username'; + $st->fields['userpkey'] = 'userpkey'; + $st->fields['usertype'] = 'usertype'; + $st->fields['timeint'] = 'timeint'; + $st->fields['timedate'] = 'timedate'; + $st->fields['message'] = 'message'; + $st->fields['entry_type'] = 'entry_type'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ChatPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("chat"); + $st->fields['pkey'] = $this->pkey; + $st->fields['chat_id'] = $this->chatId; + $st->fields['username'] = $this->username; + $st->fields['userpkey'] = $this->userpkey; + $st->fields['usertype'] = $this->usertype; + $st->fields['timeint'] = $this->timeint; + $st->fields['timedate'] = $this->timedate; + $st->fields['message'] = $this->message; + $st->fields['entry_type'] = $this->entryType; + + $st->nulls['entry_type'] = 'entry_type'; + + $st->key = 'pkey'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("chat"); + $st->fields['pkey'] = $obj->pkey; + $st->fields['chat_id'] = $obj->chatId; + $st->fields['username'] = $obj->username; + $st->fields['userpkey'] = $obj->userpkey; + $st->fields['usertype'] = $obj->usertype; + $st->fields['timeint'] = $obj->timeint; + $st->fields['timedate'] = $obj->timedate; + $st->fields['message'] = $obj->message; + $st->fields['entry_type'] = $obj->entryType; + + $st->nulls['entry_type'] = 'entry_type'; + + $st->key = 'pkey'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("chat","pkey = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new Chat(); + $x->pkey = $row['pkey']; + $x->chatId = $row['chat_id']; + $x->username = $row['username']; + $x->userpkey = $row['userpkey']; + $x->usertype = $row['usertype']; + $x->timeint = $row['timeint']; + $x->timedate = $row['timedate']; + $x->message = $row['message']; + $x->entryType = $row['entry_type']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class Chat extends ChatBase { + + + +} + + + +class ChatPeer extends ChatPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ChatQueue.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ChatQueue.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ChatQueue.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,253 @@ +<? + +class ChatQueueBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $pkey; + var $username; + var $userpkey; + var $usertype; + var $timeint; + var $timedate; + var $message; + + var $__attributes = array( + 'pkey'=>'integer', + 'username'=>'varchar', + 'userpkey'=>'integer', + 'usertype'=>'integer', + 'timeint'=>'integer', + 'timedate'=>'date', + 'message'=>'longvarchar'); + + var $__nulls = array(); + + + + function getPrimaryKey() { + return $this->pkey; + } + + + function setPrimaryKey($val) { + $this->pkey = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ChatQueuePeer::doInsert($this,$dsn)); + } else { + ChatQueuePeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "pkey='".$key."'"; + } + $array = ChatQueuePeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ChatQueuePeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ChatQueuePeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ChatQueuePeerBase { + + var $tableName = 'chat_queue'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("chat_queue",$where); + $st->fields['pkey'] = 'pkey'; + $st->fields['username'] = 'username'; + $st->fields['userpkey'] = 'userpkey'; + $st->fields['usertype'] = 'usertype'; + $st->fields['timeint'] = 'timeint'; + $st->fields['timedate'] = 'timedate'; + $st->fields['message'] = 'message'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ChatQueuePeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("chat_queue"); + $st->fields['pkey'] = $this->pkey; + $st->fields['username'] = $this->username; + $st->fields['userpkey'] = $this->userpkey; + $st->fields['usertype'] = $this->usertype; + $st->fields['timeint'] = $this->timeint; + $st->fields['timedate'] = $this->timedate; + $st->fields['message'] = $this->message; + + + $st->key = 'pkey'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("chat_queue"); + $st->fields['pkey'] = $obj->pkey; + $st->fields['username'] = $obj->username; + $st->fields['userpkey'] = $obj->userpkey; + $st->fields['usertype'] = $obj->usertype; + $st->fields['timeint'] = $obj->timeint; + $st->fields['timedate'] = $obj->timedate; + $st->fields['message'] = $obj->message; + + + $st->key = 'pkey'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("chat_queue","pkey = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ChatQueue(); + $x->pkey = $row['pkey']; + $x->username = $row['username']; + $x->userpkey = $row['userpkey']; + $x->usertype = $row['usertype']; + $x->timeint = $row['timeint']; + $x->timedate = $row['timedate']; + $x->message = $row['message']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ChatQueue extends ChatQueueBase { + + + +} + + + +class ChatQueuePeer extends ChatQueuePeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassAnnouncements.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassAnnouncements.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassAnnouncements.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,253 @@ +<? + +class ClassAnnouncementsBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $idClassAnnouncements; + var $idClasses; + var $dtDisplay; + var $txTitle; + var $txDescription; + var $idFacultyCreatedby; + var $dtCreated; + + var $__attributes = array( + 'idClassAnnouncements'=>'integer', + 'idClasses'=>'integer', + 'dtDisplay'=>'datetime', + 'txTitle'=>'varchar', + 'txDescription'=>'longvarchar', + 'idFacultyCreatedby'=>'varchar', + 'dtCreated'=>'datetime'); + + var $__nulls = array(); + + + + function getPrimaryKey() { + return $this->idClassAnnouncements; + } + + + function setPrimaryKey($val) { + $this->idClassAnnouncements = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassAnnouncementsPeer::doInsert($this,$dsn)); + } else { + ClassAnnouncementsPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "id_class_announcements='".$key."'"; + } + $array = ClassAnnouncementsPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassAnnouncementsPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassAnnouncementsPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ClassAnnouncementsPeerBase { + + var $tableName = 'class_announcements'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("class_announcements",$where); + $st->fields['id_class_announcements'] = 'id_class_announcements'; + $st->fields['id_classes'] = 'id_classes'; + $st->fields['dt_display'] = 'dt_display'; + $st->fields['tx_title'] = 'tx_title'; + $st->fields['tx_description'] = 'tx_description'; + $st->fields['id_faculty_createdby'] = 'id_faculty_createdby'; + $st->fields['dt_created'] = 'dt_created'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ClassAnnouncementsPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("class_announcements"); + $st->fields['id_class_announcements'] = $this->idClassAnnouncements; + $st->fields['id_classes'] = $this->idClasses; + $st->fields['dt_display'] = $this->dtDisplay; + $st->fields['tx_title'] = $this->txTitle; + $st->fields['tx_description'] = $this->txDescription; + $st->fields['id_faculty_createdby'] = $this->idFacultyCreatedby; + $st->fields['dt_created'] = $this->dtCreated; + + + $st->key = 'id_class_announcements'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("class_announcements"); + $st->fields['id_class_announcements'] = $obj->idClassAnnouncements; + $st->fields['id_classes'] = $obj->idClasses; + $st->fields['dt_display'] = $obj->dtDisplay; + $st->fields['tx_title'] = $obj->txTitle; + $st->fields['tx_description'] = $obj->txDescription; + $st->fields['id_faculty_createdby'] = $obj->idFacultyCreatedby; + $st->fields['dt_created'] = $obj->dtCreated; + + + $st->key = 'id_class_announcements'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("class_announcements","id_class_announcements = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ClassAnnouncements(); + $x->idClassAnnouncements = $row['id_class_announcements']; + $x->idClasses = $row['id_classes']; + $x->dtDisplay = $row['dt_display']; + $x->txTitle = $row['tx_title']; + $x->txDescription = $row['tx_description']; + $x->idFacultyCreatedby = $row['id_faculty_createdby']; + $x->dtCreated = $row['dt_created']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ClassAnnouncements extends ClassAnnouncementsBase { + + + +} + + + +class ClassAnnouncementsPeer extends ClassAnnouncementsPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsGrades.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsGrades.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsGrades.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,244 @@ +<? + +class ClassAssignmentsGradesBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $idClassAssignmentsGrades; + var $idClassAssignments; + var $idStudent; + var $comments; + var $grade; + + var $__attributes = array( + 'idClassAssignmentsGrades'=>'integer', + 'idClassAssignments'=>'integer', + 'idStudent'=>'varchar', + 'comments'=>'longvarchar', + 'grade'=>'float'); + + var $__nulls = array( + 'grade'=>'grade'); + + + + function getPrimaryKey() { + return $this->idClassAssignmentsGrades; + } + + + function setPrimaryKey($val) { + $this->idClassAssignmentsGrades = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassAssignmentsGradesPeer::doInsert($this,$dsn)); + } else { + ClassAssignmentsGradesPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "id_class_assignments_grades='".$key."'"; + } + $array = ClassAssignmentsGradesPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassAssignmentsGradesPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassAssignmentsGradesPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ClassAssignmentsGradesPeerBase { + + var $tableName = 'class_assignments_grades'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("class_assignments_grades",$where); + $st->fields['id_class_assignments_grades'] = 'id_class_assignments_grades'; + $st->fields['id_class_assignments'] = 'id_class_assignments'; + $st->fields['id_student'] = 'id_student'; + $st->fields['comments'] = 'comments'; + $st->fields['grade'] = 'grade'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ClassAssignmentsGradesPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("class_assignments_grades"); + $st->fields['id_class_assignments_grades'] = $this->idClassAssignmentsGrades; + $st->fields['id_class_assignments'] = $this->idClassAssignments; + $st->fields['id_student'] = $this->idStudent; + $st->fields['comments'] = $this->comments; + $st->fields['grade'] = $this->grade; + + $st->nulls['grade'] = 'grade'; + + $st->key = 'id_class_assignments_grades'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("class_assignments_grades"); + $st->fields['id_class_assignments_grades'] = $obj->idClassAssignmentsGrades; + $st->fields['id_class_assignments'] = $obj->idClassAssignments; + $st->fields['id_student'] = $obj->idStudent; + $st->fields['comments'] = $obj->comments; + $st->fields['grade'] = $obj->grade; + + $st->nulls['grade'] = 'grade'; + + $st->key = 'id_class_assignments_grades'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("class_assignments_grades","id_class_assignments_grades = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ClassAssignmentsGrades(); + $x->idClassAssignmentsGrades = $row['id_class_assignments_grades']; + $x->idClassAssignments = $row['id_class_assignments']; + $x->idStudent = $row['id_student']; + $x->comments = $row['comments']; + $x->grade = $row['grade']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ClassAssignmentsGrades extends ClassAssignmentsGradesBase { + + + +} + + + +class ClassAssignmentsGradesPeer extends ClassAssignmentsGradesPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsTurnin.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsTurnin.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassAssignmentsTurnin.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,271 @@ +<? + +class ClassAssignmentsTurninBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $idClassAssignmentsTurnin; + var $idClassAssignments; + var $idStudent; + var $dateTurnin; + var $assignType; + var $assignText; + var $assignFileMime; + var $assignFileName; + var $assignFileSize; + var $assignFileBlob; + + var $__attributes = array( + 'idClassAssignmentsTurnin'=>'integer', + 'idClassAssignments'=>'integer', + 'idStudent'=>'varchar', + 'dateTurnin'=>'datetime', + 'assignType'=>'integer', + 'assignText'=>'longtext', + 'assignFileMime'=>'varchar', + 'assignFileName'=>'varchar', + 'assignFileSize'=>'integer', + 'assignFileBlob'=>'longblob'); + + var $__nulls = array(); + + + + function getPrimaryKey() { + return $this->idClassAssignmentsTurnin; + } + + + function setPrimaryKey($val) { + $this->idClassAssignmentsTurnin = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassAssignmentsTurninPeer::doInsert($this,$dsn)); + } else { + ClassAssignmentsTurninPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "id_class_assignments_turnin='".$key."'"; + } + $array = ClassAssignmentsTurninPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassAssignmentsTurninPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassAssignmentsTurninPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ClassAssignmentsTurninPeerBase { + + var $tableName = 'class_assignments_turnin'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("class_assignments_turnin",$where); + $st->fields['id_class_assignments_turnin'] = 'id_class_assignments_turnin'; + $st->fields['id_class_assignments'] = 'id_class_assignments'; + $st->fields['id_student'] = 'id_student'; + $st->fields['dateTurnin'] = 'dateTurnin'; + $st->fields['assign_type'] = 'assign_type'; + $st->fields['assign_text'] = 'assign_text'; + $st->fields['assign_file_mime'] = 'assign_file_mime'; + $st->fields['assign_file_name'] = 'assign_file_name'; + $st->fields['assign_file_size'] = 'assign_file_size'; + $st->fields['assign_file_blob'] = 'assign_file_blob'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ClassAssignmentsTurninPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("class_assignments_turnin"); + $st->fields['id_class_assignments_turnin'] = $this->idClassAssignmentsTurnin; + $st->fields['id_class_assignments'] = $this->idClassAssignments; + $st->fields['id_student'] = $this->idStudent; + $st->fields['dateTurnin'] = $this->dateTurnin; + $st->fields['assign_type'] = $this->assignType; + $st->fields['assign_text'] = $this->assignText; + $st->fields['assign_file_mime'] = $this->assignFileMime; + $st->fields['assign_file_name'] = $this->assignFileName; + $st->fields['assign_file_size'] = $this->assignFileSize; + $st->fields['assign_file_blob'] = $this->assignFileBlob; + + + $st->key = 'id_class_assignments_turnin'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("class_assignments_turnin"); + $st->fields['id_class_assignments_turnin'] = $obj->idClassAssignmentsTurnin; + $st->fields['id_class_assignments'] = $obj->idClassAssignments; + $st->fields['id_student'] = $obj->idStudent; + $st->fields['dateTurnin'] = $obj->dateTurnin; + $st->fields['assign_type'] = $obj->assignType; + $st->fields['assign_text'] = $obj->assignText; + $st->fields['assign_file_mime'] = $obj->assignFileMime; + $st->fields['assign_file_name'] = $obj->assignFileName; + $st->fields['assign_file_size'] = $obj->assignFileSize; + $st->fields['assign_file_blob'] = $obj->assignFileBlob; + + + $st->key = 'id_class_assignments_turnin'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("class_assignments_turnin","id_class_assignments_turnin = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ClassAssignmentsTurnin(); + $x->idClassAssignmentsTurnin = $row['id_class_assignments_turnin']; + $x->idClassAssignments = $row['id_class_assignments']; + $x->idStudent = $row['id_student']; + $x->dateTurnin = $row['dateTurnin']; + $x->assignType = $row['assign_type']; + $x->assignText = $row['assign_text']; + $x->assignFileMime = $row['assign_file_mime']; + $x->assignFileName = $row['assign_file_name']; + $x->assignFileSize = $row['assign_file_size']; + $x->assignFileBlob = $row['assign_file_blob']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ClassAssignmentsTurnin extends ClassAssignmentsTurninBase { + + + +} + + + +class ClassAssignmentsTurninPeer extends ClassAssignmentsTurninPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassEnrollment.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassEnrollment.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassEnrollment.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,260 @@ +<? + +class ClassEnrollmentBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.7'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $classEnrollmentId; + var $studentId; + var $semesterId; + var $classId; + var $sectionNumber; + var $enrolledOn; + var $active; + var $withdrewOn; + + var $__attributes = array( + 'classEnrollmentId'=>'int', + 'studentId'=>'int', + 'semesterId'=>'int', + 'classId'=>'int', + 'sectionNumber'=>'int', + 'enrolledOn'=>'int', + 'active'=>'int', + 'withdrewOn'=>'int'); + + var $__nulls = array(); + + + + function getPrimaryKey() { + return $this->classEnrollmentId; + } + + + function setPrimaryKey($val) { + $this->classEnrollmentId = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassEnrollmentPeer::doInsert($this,$dsn)); + } else { + ClassEnrollmentPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + $where = ''; + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "class_enrollment_id='".$key."'"; + } + $array = ClassEnrollmentPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassEnrollmentPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassEnrollmentPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ClassEnrollmentPeerBase { + + var $tableName = 'class_enrollment'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("class_enrollment",$where); + $st->fields['class_enrollment_id'] = 'class_enrollment_id'; + $st->fields['student_id'] = 'student_id'; + $st->fields['semester_id'] = 'semester_id'; + $st->fields['class_id'] = 'class_id'; + $st->fields['section_number'] = 'section_number'; + $st->fields['enrolled_on'] = 'enrolled_on'; + $st->fields['active'] = 'active'; + $st->fields['withdrew_on'] = 'withdrew_on'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ClassEnrollmentPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("class_enrollment"); + $st->fields['class_enrollment_id'] = $obj->classEnrollmentId; + $st->fields['student_id'] = $obj->studentId; + $st->fields['semester_id'] = $obj->semesterId; + $st->fields['class_id'] = $obj->classId; + $st->fields['section_number'] = $obj->sectionNumber; + $st->fields['enrolled_on'] = $obj->enrolledOn; + $st->fields['active'] = $obj->active; + $st->fields['withdrew_on'] = $obj->withdrewOn; + + + $st->key = 'class_enrollment_id'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("class_enrollment"); + $st->fields['class_enrollment_id'] = $obj->classEnrollmentId; + $st->fields['student_id'] = $obj->studentId; + $st->fields['semester_id'] = $obj->semesterId; + $st->fields['class_id'] = $obj->classId; + $st->fields['section_number'] = $obj->sectionNumber; + $st->fields['enrolled_on'] = $obj->enrolledOn; + $st->fields['active'] = $obj->active; + $st->fields['withdrew_on'] = $obj->withdrewOn; + + + $st->key = 'class_enrollment_id'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("class_enrollment","class_enrollment_id = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ClassEnrollment(); + $x->classEnrollmentId = $row['class_enrollment_id']; + $x->studentId = $row['student_id']; + $x->semesterId = $row['semester_id']; + $x->classId = $row['class_id']; + $x->sectionNumber = $row['section_number']; + $x->enrolledOn = $row['enrolled_on']; + $x->active = $row['active']; + $x->withdrewOn = $row['withdrew_on']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ClassEnrollment extends ClassEnrollmentBase { + + + +} + + + +class ClassEnrollmentPeer extends ClassEnrollmentPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassExtraFaculty.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassExtraFaculty.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassExtraFaculty.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,244 @@ +<? + +class ClassExtraFacultyBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $pkey; + var $idClasses; + var $facultyId; + var $facultyType; + + var $__attributes = array( + 'pkey'=>'integer', + 'idClasses'=>'integer', + 'facultyId'=>'varchar', + 'facultyType'=>'char'); + + var $__nulls = array( + 'idClasses'=>'idClasses', + 'facultyId'=>'facultyId', + 'facultyType'=>'facultyType'); + + + + function getPrimaryKey() { + return $this->pkey; + } + + + function setPrimaryKey($val) { + $this->pkey = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassExtraFacultyPeer::doInsert($this,$dsn)); + } else { + ClassExtraFacultyPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "pkey='".$key."'"; + } + $array = ClassExtraFacultyPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassExtraFacultyPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassExtraFacultyPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ClassExtraFacultyPeerBase { + + var $tableName = 'class_extra_faculty'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("class_extra_faculty",$where); + $st->fields['pkey'] = 'pkey'; + $st->fields['id_classes'] = 'id_classes'; + $st->fields['facultyId'] = 'facultyId'; + $st->fields['facultyType'] = 'facultyType'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ClassExtraFacultyPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("class_extra_faculty"); + $st->fields['pkey'] = $this->pkey; + $st->fields['id_classes'] = $this->idClasses; + $st->fields['facultyId'] = $this->facultyId; + $st->fields['facultyType'] = $this->facultyType; + + $st->nulls['id_classes'] = 'id_classes'; + $st->nulls['facultyId'] = 'facultyId'; + $st->nulls['facultyType'] = 'facultyType'; + + $st->key = 'pkey'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("class_extra_faculty"); + $st->fields['pkey'] = $obj->pkey; + $st->fields['id_classes'] = $obj->idClasses; + $st->fields['facultyId'] = $obj->facultyId; + $st->fields['facultyType'] = $obj->facultyType; + + $st->nulls['id_classes'] = 'id_classes'; + $st->nulls['facultyId'] = 'facultyId'; + $st->nulls['facultyType'] = 'facultyType'; + + $st->key = 'pkey'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("class_extra_faculty","pkey = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ClassExtraFaculty(); + $x->pkey = $row['pkey']; + $x->idClasses = $row['id_classes']; + $x->facultyId = $row['facultyId']; + $x->facultyType = $row['facultyType']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ClassExtraFaculty extends ClassExtraFacultyBase { + + + +} + + + +class ClassExtraFacultyPeer extends ClassExtraFacultyPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassFaqs.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassFaqs.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassFaqs.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,253 @@ +<? + +class ClassFaqsBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $idClassFaqs; + var $idClasses; + var $category; + var $question; + var $answer; + var $clicks; + var $groups; + + var $__attributes = array( + 'idClassFaqs'=>'integer', + 'idClasses'=>'integer', + 'category'=>'varchar', + 'question'=>'varchar', + 'answer'=>'longvarchar', + 'clicks'=>'integer', + 'groups'=>'longvarchar'); + + var $__nulls = array(); + + + + function getPrimaryKey() { + return $this->idClassFaqs; + } + + + function setPrimaryKey($val) { + $this->idClassFaqs = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassFaqsPeer::doInsert($this,$dsn)); + } else { + ClassFaqsPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "id_class_faqs='".$key."'"; + } + $array = ClassFaqsPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassFaqsPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassFaqsPeer::doDelete($this,$deep,$dsn); + } + + + function isNew() { + return $this->_new; + } + + + function isModified() { + return $this->_modified; + + } + + + function get($key) { + return $this->{$key}; + } + + + /** + * only sets if the new value is !== the current value + * returns true if the value was updated + * also, sets _modified to true on success + */ + function set($key,$val) { + if ($this->{$key} !== $val) { + $this->_modified = true; + $this->{$key} = $val; + return true; + } + return false; + } + +} + + +class ClassFaqsPeerBase { + + var $tableName = 'class_faqs'; + + function doSelect($where,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_SelectStatement("class_faqs",$where); + $st->fields['id_class_faqs'] = 'id_class_faqs'; + $st->fields['id_classes'] = 'id_classes'; + $st->fields['category'] = 'category'; + $st->fields['question'] = 'question'; + $st->fields['answer'] = 'answer'; + $st->fields['clicks'] = 'clicks'; + $st->fields['groups'] = 'groups'; + + + $array = array(); + $db->executeQuery($st); + while($db->nextRecord() ) { + $array[] = ClassFaqsPeer::row2Obj($db->record); + } + return $array; + } + + function doInsert(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_InsertStatement("class_faqs"); + $st->fields['id_class_faqs'] = $this->idClassFaqs; + $st->fields['id_classes'] = $this->idClasses; + $st->fields['category'] = $this->category; + $st->fields['question'] = $this->question; + $st->fields['answer'] = $this->answer; + $st->fields['clicks'] = $this->clicks; + $st->fields['groups'] = $this->groups; + + + $st->key = 'id_class_faqs'; + $db->executeQuery($st); + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + function doUpdate(&$obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_UpdateStatement("class_faqs"); + $st->fields['id_class_faqs'] = $obj->idClassFaqs; + $st->fields['id_classes'] = $obj->idClasses; + $st->fields['category'] = $obj->category; + $st->fields['question'] = $obj->question; + $st->fields['answer'] = $obj->answer; + $st->fields['clicks'] = $obj->clicks; + $st->fields['groups'] = $obj->groups; + + + $st->key = 'id_class_faqs'; + $db->executeQuery($st); + $obj->_modified = false; + + } + + function doReplace($obj,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + if ($this->isNew() ) { + $db->executeQuery(new PBDO_InsertStatement($criteria)); + } else { + $db->executeQuery(new PBDO_UpdateStatement($criteria)); + } + } + + + /** + * remove an object + */ + function doDelete(&$obj,$deep=false,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + $st = new PBDO_DeleteStatement("class_faqs","id_class_faqs = '".$obj->getPrimaryKey()."'"); + + $db->executeQuery($st); + + if ( $deep ) { + + } + + $obj->_new = false; + $obj->_modified = false; + $id = $db->getInsertID(); + return $id; + + } + + + + /** + * send a raw query + */ + function doQuery(&$sql,$dsn="default") { + //use this tableName + $db = DB::getHandle($dsn); + + $db->query($sql); + + return; + } + + + + function row2Obj($row) { + $x = new ClassFaqs(); + $x->idClassFaqs = $row['id_class_faqs']; + $x->idClasses = $row['id_classes']; + $x->category = $row['category']; + $x->question = $row['question']; + $x->answer = $row['answer']; + $x->clicks = $row['clicks']; + $x->groups = $row['groups']; + + $x->_new = false; + return $x; + } + + +} + + +//You can edit this class, but do not change this next line! +class ClassFaqs extends ClassFaqsBase { + + + +} + + + +class ClassFaqsPeer extends ClassFaqsPeerBase { + +} + +?> \ No newline at end of file Added: logicampus/trunk/src/logicreate/lib/PBDO/ClassForum.php =================================================================== --- logicampus/trunk/src/logicreate/lib/PBDO/ClassForum.php (rev 0) +++ logicampus/trunk/src/logicreate/lib/PBDO/ClassForum.php 2009-02-27 12:07:22 UTC (rev 1297) @@ -0,0 +1,335 @@ +<? + +class ClassForumBase { + + var $_new = true; //not pulled from DB + var $_modified; //set() called + var $_version = '1.6'; //PBDO version number + var $_entityVersion = ''; //Source version number + var $classForumId; + var $name; + var $classId; + var $isLocked; + var $isVisible; + var $isModerated; + var $allowUploads; + var $description; + var $recentPostDatetime; + var $recentPoster; + var $threadCount; + var $postCount; + var $unansweredCount; + var $classForumCategoryId; + + var $__attributes = array( + 'classForumId'=>'integer', + 'name'=>'varchar', + 'classId'=>'integer', + 'isLocked'=>'tinyint', + 'isVisible'=>'tinyint', + 'isModerated'=>'tinyint', + 'allowUploads'=>'tinyint', + 'description'=>'varchar', + 'recentPostDatetime'=>'integer', + 'recentPoster'=>'varchar', + 'threadCount'=>'integer', + 'postCount'=>'integer', + 'unansweredCount'=>'integer', + 'classForumCategoryId'=>'integer'); + + var $__nulls = array( + 'classForumCategoryId'=>'classForumCategoryId'); + + /** + * Retrieves one class_forum_category object via the foreign key class_forum_category_id. + * + * @param String $dsn the name of the data source to use for the sql query. + * @return Object the related object. + */ + function getClassForumCategoryByClassForumCategoryId($dsn='default') { + if ( $this->classForumCategoryId == '' ) { trigger_error('Peer doSelect with empty key'); return false; } + $array = ClassForumCategoryPeer::doSelect('class_forum_category_id = \''.$this->classForumCategoryId.'\'',$dsn); + if ( count($array) > 1 ) { trigger_error('multiple objects on one-to-one relationship'); } + return $array[0]; + } + + /** + * Retrieves an array of class_forum_post objects via the foreign key class_forum_id. + * + * @param String $dsn the name of the data source to use for the sql query. + * @return Array related objects. + */ + function getClassForumPostsByClassForumId($dsn='default') { + if ( $this->classForumId == '' ) { trigger_error('Peer doSelect with empty key'); return false; } + $array = ClassForumPostPeer::doSelect('class_forum_id = \''.$this->classForumId.'\'',$dsn); + return $array; + } + + /** + * Retrieves an array of class_forum_trash_post objects via the foreign key class_forum_id. + * + * @param String $dsn the name of the data source to use for the sql query. + * @return Array related objects. + */ + function getClassForumTrashPostsByClassForumId($dsn='default') { + if ( $this->classForumId == '' ) { trigger_error('Peer doSelect with empty key'); return false; } + $array = ClassForumTrashPostPeer::doSelect('class_forum_id = \''.$this->classForumId.'\'',$dsn); + return $array; + } + + + + function getPrimaryKey() { + return $this->classForumId; + } + + + function setPrimaryKey($val) { + $this->classForumId = $val; + } + + + function save($dsn="default") { + if ( $this->isNew() ) { + $this->setPrimaryKey(ClassForumPeer::doInsert($this,$dsn)); + } else { + ClassForumPeer::doUpdate($this,$dsn); + } + } + + + function load($key,$dsn="default") { + if (is_array($key) ) { + while (list ($k,$v) = @each($key) ) { + $where .= "$k='$v' and "; + } + $where = substr($where,0,-5); + } else { + $where = "class_forum_id='".$key."'"; + } + $array = ClassForumPeer::doSelect($where,$dsn); + return $array[0]; + } + + + function loadAll($dsn="default") { + $array = ClassForumPeer::doSelect('',$dsn); + return $array; + } + + + function delete($deep=false,$dsn="default") { + ClassForumPeer::doDelete($this,$deep,$dsn); + }... [truncated message content] |