Viewing file:  arr_pbri.php (15.74 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$sm=array(
array('old' =>array('name'=>'AcadYearConfig', 'fld'=>array('acadYear','semester','firstDate','lastDate')),
'new' =>array('name'=>'rg_TermConfig', 'fld'=>array('tmcAcY','tmcTmId','tmcFrDate','tmcToDate')),
'ref' =>array('fld'=>array('-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Amphur', 'fld'=>array('amphurId','amphurName','amphurNameEng','provinceId')),
'new' =>array('name'=>'rg_Amphur', 'fld'=>array('apId','apName','apNameE','apPrvId')),
'ref' =>array('fld'=>array('-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'ClinicalPractice', 'fld'=>array('cliPracId','sequence','cliPracName','cliPracNameEng')),
'new' =>array('name'=>'rg_ClinicalPractice', 'fld'=>array('cpId','cpSeq','cpName','cpNameE')),
'ref' =>array('fld'=>array('-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'College', 'fld'=>array('collegeCode','collegeLogo','collegeName','collegeNameEng','collegeAbbr','collegeAbbrEng','collegeAddress','collegePhone')),
'new' =>array('name'=>'rg_College', 'fld'=>array('clgCode','clgLogo','clgName','clgNameE','clgAbbr','clgAbbrE','clgAddr','clgPhoneNo')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'CommonFeeTP', 'fld'=>array('admitAcadYear','studentYear','acadYear','semester','feeId','amount','isDom')),
'new' =>array('name'=>'rg_CommonFeeTp', 'fld'=>array('cmftAdY','cmftSyId','cmftAcY','cmftTmId','cmftFeeId','cmftAmt','cmftIsDom')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Condition', 'fld'=>array('conditionId','conditionCode','condition','conditionEng','conditionAbbr','conditionAbbrEng','conditionType','minGrade','-')),
'new' =>array('name'=>'rg_Condition', 'fld'=>array('cdId','cdCode','cdName','cdNameE','cdAbbr','cdAbbrE','cdType','cdMinGrade','cdGtpId')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','default/1/')),
'minus' =>array(),
'plus' =>array('8'),
'sql' =>'?',
'qry' => " SELECT `conditionId`,`conditionCode`,`condition`,`conditionEng`,`conditionAbbr`,`conditionAbbrEng`,`conditionType`,`minGrade`,'1' FROM $oDB.Condition "),
array('old' =>array('name'=>'Course', 'fld'=>array('courseId','courseCode','courseCodeEng','courseName','courseNameEng','courseAbbr','courseAbbrEng','creditTotal','credit1','credit2','period1','period2','period3','courseStatus','description','descriptionEng','createDateTime','createUserId','updateDateTime','updateUserId','courseUnit','showLabTS','conditionId','-')),
'new' =>array('name'=>'rg_Course', 'fld'=>array('crsId','crsCode','crsCodeE','crsName','crsNameE','crsAbbr','crsAbbrE','crsCreditTotal','crsCredit1','crsCredit2','crsPeriod1','crsPeriod2','crsPeriod3','crsStatus','crsDescription','crsDescriptionE','crsCreateDate','crsCreateUserId','crsUpdateDate','crsUpdateUserId','crsUnit','crsShowLabInTS','crsCdId','crsGtpId')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','default/1/')),
'minus' =>array(),
'plus' =>array('23'),
'sql' => '?',
'qry' => " SELECT `courseId`,`courseCode`,`courseCodeEng`,`courseName`,`courseNameEng`,`courseAbbr`,`courseAbbrEng`,`creditTotal`,`credit1`,`credit2`,`period1`,`period2`,`period3`,`courseStatus`,`description`,`descriptionEng`,`createDateTime`,`createUserId`,`updateDateTime`,`updateUserId`,`courseUnit`,`showLabTS`,`conditionId`,'1'
FROM $oDB.Course "),
array('old' =>array('name'=>'CourseFeeTP', 'fld'=>array('programId','admitAcadYear','studentYear','acadYear','semester','lcCreditFee','lbCreditFee','lateFine','lateFineUnit','kssFee','maxLateFine')),
'new' =>array('name'=>'rg_CourseFeeTp', 'fld'=>array('crftCurId','crftAdY','crftSyId','crftAcY','crftTmId','crftLecCreditFee','crftLabCreditFee','crftLateFine','crftLateFineUnit','crftKssFee','crftMaxLateFine')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'CourseInProgram', 'fld'=>array('programId','conditionId1','conditionId2','courseId','conditionType','minGrade','courseStatus')),
'new' =>array('name'=>'rg_ProgramCourses', 'fld'=>array('pcrCsCurId','pcrCsCdId1','pcrCsCdId2','pcrCrsId','pcrCdType','pcrMinGrade','pcrStatus')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Degree', 'fld'=>array('degreeId','degreeName','degreeNameEng','degreeAbbr','degreeAbbrEng')),
'new' =>array('name'=>'rg_EduDegree', 'fld'=>array('edgId','edgName','edgNameE','edgAbbr','edgAbbrE')),
'ref' =>array('fld'=>array('-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Discipline', 'fld'=>array('disciplineId','disciplineName','levelNo','minPoint','maxPoint')),
'new' =>array('name'=>'rg_Discipline', 'fld'=>array('dcpId','dcpName','dcpLevelNo','dcpMinPoint','dcpMaxPoint')),
'ref' =>array('fld'=>array('-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'District', 'fld'=>array('districtId','districtName','districtNameEng','amphurId','provinceId')),
'new' =>array('name'=>'rg_District', 'fld'=>array('dtId','dtName','dtNameE','dtApId','dtPrvId')),
'ref' =>array('fld'=>array('-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Fee', 'fld'=>array('feeId','feeName','feeType','feePayType','feeCalType','canRefund','feeGroupId','sequence','outBudget','onTop','levelId')),
'new' =>array('name'=>'rg_Fee', 'fld'=>array('feeId','feeName','feeType','feePytId','feeCalType','feeCanRefund','feeFgId','feeSeq','feeOutBudget','feeOnTop','feeElvId')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'FeeGroup', 'fld'=>array('feeGroupId','sequence','feeGroupName')),
'new' =>array('name'=>'rg_FeeGroup', 'fld'=>array('fgId','fgSeq','fgName')),
'ref' =>array('fld'=>array('-','-','-')),
'def' =>array('fld'=>array('-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'GradeConfig', 'fld'=>array('gradeId','grade','gradePoint','description','descriptionEng','calGrade','calCredit','-')),
'new' =>array('name'=>'rg_Grade', 'fld'=>array('grdId','grdGrade','grdPoint','grdDescription','grdDescriptionE','grdCalGrade','grdCalCredit','grdGtpId')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','default/1/')),
'minus' =>array(),
'plus' =>array('7'),
'sql' => '?',
'qry' => " SELECT `gradeId`,`grade`,`gradePoint`,`description`,`descriptionEng`,`calGrade`,`calCredit`,'1' FROM $oDB.GradeConfig "),
array('old' =>array('name'=>'HealthPrivilege', 'fld'=>array('healthPrivId','healthPrivName')),
'new' =>array('name'=>'rg_HealthPrivilege', 'fld'=>array('hpId','hpName')),
'ref' =>array('fld'=>array('-','-')),
'def' =>array('fld'=>array('-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Level', 'fld'=>array('levelId','levelName','levelNameEng','levelAbbr','levelAbbrEng')),
'new' =>array('name'=>'rg_EduLevel', 'fld'=>array('elvId','elvName','elvNameE','elvAbbr','elvAbbrE')),
'ref' =>array('fld'=>array('-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Nation', 'fld'=>array('nationId','nationName','nationNameEng')),
'new' =>array('name'=>'rg_Nation', 'fld'=>array('ntId','ntName','ntNameE')),
'ref' =>array('fld'=>array('-','-','-')),
'def' =>array('fld'=>array('-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'PreAdmitPosition', 'fld'=>array('preAdmitPositionId','positionName')),
'new' =>array('name'=>'rg_PreAdmit', 'fld'=>array('paId','paName')),
'ref' =>array('fld'=>array('-','-')),
'def' =>array('fld'=>array('-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Prefix', 'fld'=>array('prefixId','prefixName','prefixNameEng','defaultSex')),
'new' =>array('name'=>'rg_Prefix', 'fld'=>array('pfId','pfName','pfNameE','pfGender')),
'ref' =>array('fld'=>array('-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Prerequisite', 'fld'=>array('courseId','prCourseId','prAndOr','sequence')),
'new' =>array('name'=>'rg_PreCourse', 'fld'=>array('prcCrsId','prcPrCrsId','prcAndOr','prcSeq')),
'ref' =>array('fld'=>array('-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Program', 'fld'=>array('programId','programCode','programYear','degreeId','levelId','programName','programNameEng','programAbbr','programAbbrEng','creditTotal','description','descriptionEng','studyYearMax','gradePointMin','createDateTime','createUserId','updateDateTime','updateUserId','semesterPerYear','programStatus','studyYear','programConfId','-')),
'new' =>array('name'=>'rg_Curriculum', 'fld'=>array('curId','-','curImproveY','curEdgId','curElvId','curName','curNameE','curAbbr','curAbbrE','curMinCredit','curDescription','curDescriptionE','curMaxStudyY','curMinGPAX','curCreateDate','curCreateUserId','curUpdateDate','curUpdateUsLogin','curNumTmPerY','curStatus','curNumStudyY','curCcId','curGtpId')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','default/1/')),
'minus' =>array('1'),
'plus' =>array('22'),
'sql' => '?',
'qry' => " SELECT `programId`,`programYear`,`degreeId`,`levelId`,`programName`,`programNameEng`,`programAbbr`,`programAbbrEng`,`creditTotal`,`description`,`descriptionEng`,`studyYearMax`,`gradePointMin`,`createDateTime`,`createUserId`,`updateDateTime`,`updateUserId`,`semesterPerYear`,`programStatus`,`studyYear`,`programConfId`,'1' FROM $oDB.Program "),
array('old' =>array('name'=>'ProgramConfig', 'fld'=>array('programConfId','-','programConfName','programConfStatus','startYear')),
'new' =>array('name'=>'rg_CurriculumConfig', 'fld'=>array('ccId','ccCode','ccName','ccStatus','-')),
'ref' =>array('fld'=>array('-','Program-programConfId-programCode','-','-','-')),
'def' =>array('fld'=>array('-','?/0/programConfId','-','-','-')),
'minus' =>array('4'),
'plus' =>array('1'),
'sql' => '?',
'qry' => " SELECT `programConfId`,(case when `programConfId` < 10 then concat('0',`programConfId`) else `programConfId` end),`programConfName`,`programConfStatus`
FROM $oDB.ProgramConfig "),
array('old' =>array('name'=>'ProgramFeeTP', 'fld'=>array('programId','admitAcadYear','studentYear','acadYear','semester','feeId','amount')),
'new' =>array('name'=>'rg_CurriculumFeeTp', 'fld'=>array('cftCurId','cftAdY','cftSyId','cftAcY','cftTmId','cftFeeId','cftAmt')),
'ref' =>array('fld'=>array('-','-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'ProgramStructure', 'fld'=>array('programId','conditionId1','conditionId2','sequence','creditTotal')),
'new' =>array('name'=>'rg_CurriculumStructure', 'fld'=>array('csCurId','csCdId1','csCdId2','csSeq','csCreditTotal')),
'ref' =>array('fld'=>array('-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Province', 'fld'=>array('provinceId','provinceName','provinceNameEng')),
'new' =>array('name'=>'rg_Province', 'fld'=>array('prvId','prvName','prvNameE')),
'ref' =>array('fld'=>array('-','-','-')),
'def' =>array('fld'=>array('-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Religion', 'fld'=>array('religionId','religionName','religionNameEng')),
'new' =>array('name'=>'rg_Religion', 'fld'=>array('rlgId','rlgName','rlgNameE')),
'ref' =>array('fld'=>array('-','-','-')),
'def' =>array('fld'=>array('-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'Scholar', 'fld'=>array('scholarId','scholarName','provinceId')),
'new' =>array('name'=>'rg_ScholarOwner', 'fld'=>array('soId','soName','soPrvId')),
'ref' =>array('fld'=>array('-','-','-')),
'def' =>array('fld'=>array('-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'StudyPlan', 'fld'=>array('programId','studentYear','semester','courseId','conditionId','conditionId2')),
'new' =>array('name'=>'rg_StudyPlan', 'fld'=>array('spCurId','spSyId','spTmId','spCrsId','spCdId1','spCdId2')),
'ref' =>array('fld'=>array('-','-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'SysFeePayTypeDes', 'fld'=>array('feePayType','description')),
'new' =>array('name'=>'rg_PayType', 'fld'=>array('pytId','pytName')),
'ref' =>array('fld'=>array('-','-')),
'def' =>array('fld'=>array('-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'SysOfficerStatusDes', 'fld'=>array('officerStatus','officerStatusCode','description','officerStatusDefault')),
'new' =>array('name'=>'rg_PersonStatus', 'fld'=>array('psId','psCode','psName','psDefault')),
'ref' =>array('fld'=>array('-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-'),
array('old' =>array('name'=>'SysSemesterDes', 'fld'=>array('semester','-','semesterName','semesterNameEng','semesterDefault')),
'new' =>array('name'=>'rg_Term', 'fld'=>array('tmId','tmCode','tmName','tmNameE','tmDefault')),
'ref' =>array('fld'=>array('-','SysSemesterDes-semester-semester','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array('1'),
'sql' => '?',
'qry' => " SELECT `semester`,`semester`,`semesterName`,`semesterNameEng`,`semesterDefault`
FROM $oDB.SysSemesterDes "),
array('old' =>array('name'=>'SysStudentYearDes', 'fld'=>array('studentYear','-','studentYearName','studentYearNameEng','studentYearDefault')),
'new' =>array('name'=>'rg_StudyYear', 'fld'=>array('syId','syCode','syName','syNameE','syDefault')),
'ref' =>array('fld'=>array('-','SysStudentYearDes-studentYear-studentYear','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array('1'),
'sql' => '?',
'qry' => " SELECT `studentYear`,`studentYear`,`studentYearName`,`studentYearNameEng`,`studentYearDefault`
FROM $oDB.SysStudentYearDes ")
);
/*
,
array('old' =>array('name'=>'rg_SysStudyType', 'fld'=>array('sstId','sstName','sstNameEng','sstAbbr','sstAbbrEng')),
'new' =>array('name'=>'rg_StudyType', 'fld'=>array('stId','stName','stNameE','stAbbr','stAbbrE')),
'ref' =>array('fld'=>array('-','-','-','-','-')),
'def' =>array('fld'=>array('-','-','-','-','-')),
'minus' =>array(),
'plus' =>array(),
'sql' => '-')
*/
?>
|