array('name'=>'-', 'fld'=>array('-','-','-','-','-','-','-','-')), 'new' =>array('name'=>'rg_StudentRewardFileUpload', 'fld'=>array('srwuId','srwuSeq','srwuSrwSeq','srwuStdId','srwuFileName','srwuPath','srwuCreateDate','srwuUserId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array()), array('old' =>array('name'=>'-', 'fld'=>array('-','-','-','-','-','-','-')), 'new' =>array('name'=>'rg_NewsFileUpload', 'fld'=>array('nwuId','nwuSeq','nwuNwId','nwuFileName','nwuPath','nwuCreateDate','nwuUserId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array()), array('old' =>array('name'=>'-', 'fld'=>array('-','-')), 'new' =>array('name'=>'rg_GradeTp', 'fld'=>array('gtpId','gtpName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array()), array('old' =>array('name'=>'-', 'fld'=>array('-','-')), 'new' =>array('name'=>'rg_ReceiptItems', 'fld'=>array('ritId','ritName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array()), array('old' =>array('name'=>'-', 'fld'=>array('-','-','-')), 'new' =>array('name'=>'rg_ReceiptItemsInCurriculum', 'fld'=>array('ricCurId','ricAdY','ricRitId')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array('0','1','2')), array('old' =>array('name'=>'-', 'fld'=>array('-','-','-')), 'new' =>array('name'=>'rg_FStatusInPs', 'fld'=>array('fipFSatus','fipPsId','fipFStatusName')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array()), array('old' =>array('name'=>'-', 'fld'=>array('-','-','-','-','-')), 'new' =>array('name'=>'rg_Help', 'fld'=>array('hId','hCode','hDesc','hContent','hLastUpdate')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-')), 'minus' =>array(), 'plus' =>array('0','1','2','3','4')), array('old' =>array('name'=>'-', 'fld'=>array('-','-','-')), 'new' =>array('name'=>'rg_ExamType', 'fld'=>array('exId','exType','exName')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array('0','1','2')), array('old' =>array('name'=>'Acad', 'fld'=>array('honor1','honor1Eng','honor1GPA','honor2','honor2Eng','honor2GPA','annualGPAX','exitExam','CPTransferClass','lateFineGD','TSRegistrar','director','calGradeF','noLockT','cardExpiryDay','cardExpiryMonth','forceAssess','medal1','medal1Eng','medal2','medal2Eng')), 'new' =>array('name'=>'rg_AcadConfig', 'fld'=>array('acHonor1','acHonor1E','acHonor1GPA','acHonor2','acHonor2E','acHonor2GPA','acAnnualGPAX','acExitExam','acCPTransferClass','acLateFineGD','acPrsIdTSRegistrar','acPrsIdDirector','acCalGradeF','acNoLockT','acCardExpiryDay','acCardExpiryMonth','acForceAssess','acMedal1','acMedal1E','acMedal2','acMedal2E')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'StudentMaster', 'fld'=>array('-','studentId','studentYear','officerId1')), 'new' =>array('name'=>'rg_Adviser', 'fld'=>array('advAcY','advStdId','advSyId','advPrsId')), 'ref' =>array('fld'=>array('StudentStatus-studentId-MAX(acadYear)','-','-','-')), 'def' =>array('fld'=>array('noSs/admitAcadYear/ ','-','-','-')), 'minus' =>array(), 'plus' =>array('0'), 'sql' =>'?', 'qry'=>" SELECT MAX(ss.acadYear), sm.studentId, studentYear, officerId1 FROM $dbreg.`StudentMaster` sm INNER JOIN $dbreg.`StudentStatus` ss ON sm.studentId = ss.studentId WHERE 1=1 AND officerId1 IS NOT NULL GROUP BY studentId"), array('old' =>array('name'=>'rg_StLoan', 'fld'=>array('slStId','slAcY','slTmId')), 'new' =>array('name'=>'rg_AllowSendGrade', 'fld'=>array('asgStdId','asgAcY','asgTmId')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Building', 'fld'=>array('buildingId','buildingName')), 'new' =>array('name'=>'rg_Building', 'fld'=>array('bdId','bdName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'ClassOfficer', 'fld'=>array('programId','acadYear','studentYear','officerId')), 'new' =>array('name'=>'rg_ClassTeacher', 'fld'=>array('ctcCurId','ctcAcY','ctcSyId','ctcPrsId')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'CommonFee', 'fld'=>array('studentId','acadYear','semester','feeId','amount')), 'new' =>array('name'=>'rg_CommonFee', 'fld'=>array('cmfStdId','cmfAcY','cmfTmId','cmfFeeId','cmfAmt')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'EregisConfig', 'fld'=>array('siteLogo','siteName','siteBanner','collegeCode','collegeName','collegeNameEng','collegeAddress','collegePhone','collegeBankName','collegeBankAccount','collegeBankNo','collegeBankLogo','collegeBankFee','instituteLogo','institute','instituteEng','ministry','ministryEng','bgClTrAndTd','bgClSwapTr','fnClHeadTb','fnClErrSpec','-','-')), 'new' =>array('name'=>'rg_Config', 'fld'=>array('cfgClgLogo','cfgSiteName','cfgSiteBanner','cfgClgCode','cfgClgName','cfgClgNameE','cfgClgAddr','cfgClgPhoneNo','cfgClgBankName','cfgClgBankAccountName','cfgClgBankNo','cfgClgBankLogo','cfgClgBankFee','cfgInstituteLogo','cfgInstitute','cfgInstituteE','cfgMinistry','cfgMinistryE','cfgBgClTrAndTd','cfgBgClSwapTr','cfgFnClHeadTb','cfgFnClErrSpec','cfgCheckPP','cfgCheckSP')), 'def' =>array('fld'=>array('default/SiteLogo.jpg/','-','default/SiteBanner.jpg/','-','-','-','-','-','-','-','-','default/logo_bank.jpg/','-','default/logo_institute.jpg/','-','-','-','-','-','-','-','-','default/N/','default/N/')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array('22','23'), 'sql' =>'?', 'qry' => " SELECT 'SiteLogo.jpg',`siteName`,'SiteBanner.jpg',`collegeCode`,`collegeName`,`collegeNameEng`,`collegeAddress`,`collegePhone`,`collegeBankName`,`collegeBankAccount`,`collegeBankNo`,'logo_bank.jpg',`collegeBankFee`,'logo_institute.jpg',`institute`,`instituteEng`,`ministry`,`ministryEng`,`bgClTrAndTd`,`bgClSwapTr`,`fnClHeadTb`,`fnClErrSpec`,'N','N' FROM $dbreg.`EregisConfig` "), array('old' =>array('name'=>'CourseFee', 'fld'=>array('studentId','acadYear','semester','enrollFeeId','lcFee','lbFee','lateFine','kssFee')), 'new' =>array('name'=>'rg_CourseFee', 'fld'=>array('crfStdId','crfAcY','crfTmId','crfRfId','crfLecFeeAmt','crfLabFeeAmt','crfLateFineAmt','crfKssFeeAmt')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Class', 'fld'=>array('classId','programId','acadYear','studentYear','semester','courseId','sectionClass','section','totalSeat','enrollSeat','sendGradeStatus','realStudyPlanId','conditionId','conditionId2','declareStatus','officerId')), 'new' =>array('name'=>'rg_CourseOpen', 'fld'=>array('coId','coCurId','coAcY','coSyId','coTmId','coCrsId','coSectionClass','coSection','coNumSeatOpen','coNumSeatReg','coSendGradeStatus','coRspId','coCdId1','coCdId2','coDeclareStatus','coPrsId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'ClassOpenFor', 'fld'=>array('classId','programId','bookSeat','erSeat')), 'new' =>array('name'=>'rg_CourseOpenFor', 'fld'=>array('cofCoId','cofCurId','cofSeats','cofNumEnroll')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_StudentInClass', 'fld'=>array('siStId','siClId')), 'new' =>array('name'=>'rg_CourseOpenStudent', 'fld'=>array('cosStdId','cosCoId')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'ProgramFee', 'fld'=>array('studentId','acadYear','semester','feeId','amount')), 'new' =>array('name'=>'rg_CurriculumFee', 'fld'=>array('cfStdId','cfAcY','cfTmId','cfFeeId','cfAmt')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Day', 'fld'=>array('dayId','dayName','-','dayAbbrEng')), 'new' =>array('name'=>'rg_Day', 'fld'=>array('dyId','dyName','dyAbbr','dyAbbrE')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','dyAbbr/dayName/','-')), 'minus' =>array(), 'plus' =>array('2'), 'sql' =>'?'), array('old' =>array('name'=>'Debt', 'fld'=>array('sequence','studentId','acadYear','semester','description','amount','organId','refNo','createDateTime','createUserId','updateDateTime','updateUserId')), 'new' =>array('name'=>'rg_Debt', 'fld'=>array('dbtSeq','dbtStdId','dbtAcY','dbtTmId','dbtDescription','dbtAmt','dbtOrgId','dbtRefNo','dbtCreateDate','dbtCreateUserId','dbtUpdateDate','dbtUpdateUserId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_Department', 'fld'=>array('dpId','dpName','dpStatus')), 'new' =>array('name'=>'rg_Department', 'fld'=>array('dptId','dptName','dptStatus')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Dom', 'fld'=>array('domId','domName')), 'new' =>array('name'=>'rg_Domitory', 'fld'=>array('dmId','dmName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'DomFeeTP', 'fld'=>array('acadYear','semester','domId','domFee')), 'new' =>array('name'=>'rg_DomitoryFeeTp', 'fld'=>array('dftAcY','dftTmId','dftDmId','dftAmt')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'EntryType', 'fld'=>array('entryTypeId','entryTypeName')), 'new' =>array('name'=>'rg_EntryType', 'fld'=>array('etId','etName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'EntryType2', 'fld'=>array('entryTypeId2','entryTypeName2')), 'new' =>array('name'=>'rg_EntryType2', 'fld'=>array('et2Id','et2Name')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'ClassExam', 'fld'=>array('classId','roomId','examCode','examDate','examTimeFrom','studyCode','officerId','examTimeTo')), 'new' =>array('name'=>'rg_ExamSchedule', 'fld'=>array('esCoId','esRmId','esExamType','esDate','esPrdFrTime','esStId','esPrsId','esPrdToTime')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','splitDateDb/ /','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT classId,roomId,examCode,CONCAT(YEAR(examDate)-543,'-',MONTH(examDate),'-',DAY(examDate)),examTimeFrom,(CASE WHEN studyCode='C' THEN 1 ELSE stId END ),officerId,examTimeTo FROM $dbreg.`ClassExam` LEFT JOIN $dbmoreg.`rg_StudyType` ON studyCode = stAbbrE "), array('old' =>array('name'=>'rg_ExternalPlace', 'fld'=>array('epMepId','epSepId')), 'new' =>array('name'=>'rg_ExternalPlace', 'fld'=>array('etpMepId','etpSepId')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'FAQ', 'fld'=>array('questionId','question','answer')), 'new' =>array('name'=>'rg_Faq', 'fld'=>array('faqId','faqQuestion','faqAnswer')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'SysFinanceStatusDes', 'fld'=>array('financeStatus','financeStatusCode','description','financeStatusDefault')), 'new' =>array('name'=>'rg_FinanceStatus', 'fld'=>array('fsId','fsCode','fsName','fsDefault')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Generation', 'fld'=>array('genId','programId','acadYear','semester','genNo')), 'new' =>array('name'=>'rg_Generation', 'fld'=>array('genId','genCurId','genAcY','genTmId','genNo')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_SysInstructorType', 'fld'=>array('sitId','sitName')), 'new' =>array('name'=>'rg_InstructorType', 'fld'=>array('itId','itName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_LoadType', 'fld'=>array('ltId','ltName','ltSstId')), 'new' =>array('name'=>'rg_LoadType', 'fld'=>array('ltId','ltName','ltStId')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_MainExternalPlace', 'fld'=>array('mepId','mepName','mepPvId')), 'new' =>array('name'=>'rg_MainExternalPlace', 'fld'=>array('mepId','mepName','mepPrvId')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'MaritalStatus', 'fld'=>array('maritalStatusId','maritalStatus','maritalStatusEng')), 'new' =>array('name'=>'rg_MaritalStatus', 'fld'=>array('msId','msName','msNameE')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'AdviseNews', 'fld'=>array('adviseNewsId','adviseNewsTitle','startDate','endDate','adviseNewsAnn','adviseNewsPic','adviseNewsDetail','createDateTime','createUserId','updateDateTime','updateUserId','-')), 'new' =>array('name'=>'rg_News', 'fld'=>array('nwId','nwTitle','nwFrDate','nwToDate','nwAnnoucedBy','nwPicture','nwDetail','nwCreateDate','nwCreateUserId','nwUpdateDate','nwUpdateUserId','nwSystem')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','splitDateDb/ /','splitDateDb/ /','-','picpath/adviseNewsPic/ ','-','-','-','-','-','default/70/')), 'minus' =>array(), 'plus' =>array('12'), 'sql' =>'?', 'qry' => " SELECT `adviseNewsId`,`adviseNewsTitle`,CONCAT(YEAR(startDate)-543,'-',MONTH(startDate),'-',DAY(startDate)),CONCAT(YEAR(endDate)-543,'-',MONTH(endDate),'-',DAY(endDate)),`adviseNewsAnn`,REPLACE(adviseNewsPic, '../pictureNews/', ''),`adviseNewsDetail`,`createDateTime`,`createUserId`,`updateDateTime`,`updateUserId`,'70' FROM $dbreg.`AdviseNews` "), array('old' =>array('name'=>'rg_NoStudyDate', 'fld'=>array('nsdId','nsdName','nsdDate','nsdFrPr','nsdToPr','nsdRemark','nsdParent')), 'new' =>array('name'=>'rg_NoStudyDate', 'fld'=>array('nsdId','nsdName','nsdDate','nsdPrdFrTime','nsdPrdToTime','nsdRemark','nsdNsdIdParent')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Organ', 'fld'=>array('organId','organName')), 'new' =>array('name'=>'rg_Organization', 'fld'=>array('orgId','orgName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Payment', 'fld'=>array('payId','payDate','payType','payAmount','enrollFeeId','refNo','paymentLate','lateFine','printDate')), 'new' =>array('name'=>'rg_Payment', 'fld'=>array('pmId','pmDate','pmType','pmAmt','pmRfId','pmRefNo','pmLateStatus','pmLateFine','pmPrintDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','splitDateDb/ /','-','-','-','-','-','-','splitDateDb/ /')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' => " SELECT payId,CONCAT(YEAR(payDate)-543,'-',MONTH(payDate),'-',DAY(payDate)),payType,payAmount,enrollFeeId,refNo,paymentLate,lateFine,CONCAT(YEAR(printDate)-543,'-',MONTH(printDate),'-',DAY(printDate)) FROM $dbreg.`Payment` "), array('old' =>array('name'=>'Period', 'fld'=>array('period','startTime','endTime')), 'new' =>array('name'=>'rg_Period', 'fld'=>array('prdId','prdFrTime','prdToTime')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Officer', 'fld'=>array('officerId','officerCode','officerPassword','officerType','prefixId','officerName','officerSurname','officerNameEng','officerSurnameEng','officerEmail','officerStatus','remark','contactAddress','contactPhone','organId','debtUDAuthority','officerPosition','ofSitId','ofPicturePath','-')), 'new' =>array('name'=>'rg_Person', 'fld'=>array('prsId','-','-','prsPtId','-','-','-','-','-','-','prsPsId','prsRemark','prsAddr','prsPhoneNo','prsOrgId','prsDebtUDAuthority','prsPosition','prsItId','-','prsUsId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','Officer-officerId-officerId')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array('1','2','4','5','6','7','8','9','18'), 'plus' =>array('19'), 'sql' =>'?', 'qry' =>"SELECT officerId,officerType,officerStatus,remark,contactAddress,contactPhone,organId,debtUDAuthority,officerPosition,ofSitId,officerId FROM $dbreg.`Officer` "), array('old' =>array('name'=>'rg_OFInDP', 'fld'=>array('oidOfId','oidSeq','oidDpId','oidIsBoss','oidFrDate','oidToDate')), 'new' =>array('name'=>'rg_PersonDepartment', 'fld'=>array('pdPrsId','pdSeq','pdDptId','pdIsBoss','pdFrDate','pdToDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_OFSetTT', 'fld'=>array('ostOfId','ostAcY','ostTmId','ostPgId','ostTT','ostWL')), 'new' =>array('name'=>'rg_PersonPermission', 'fld'=>array('ppPrsId','ppAcY','ppTmId','ppCurId','ppTT','ppWL')), 'ref' =>array('fld'=>array('-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'SysOfficerTypeDes', 'fld'=>array('officerType','officerTypeCode','description')), 'new' =>array('name'=>'rg_PersonType', 'fld'=>array('ptId','ptCode','ptName')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'LabHrPerCr', 'fld'=>array('programId','admitAcadYear','cliPracId','labHr')), 'new' =>array('name'=>'rg_PracticeHours', 'fld'=>array('phCurId','phAdY','phCpId','phLabHr')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'RealStudyPlan', 'fld'=>array('id','programId','studentYear','semester','courseId','classId','admitAcadYear','conditionId','conditionId2','noCalGPA')), 'new' =>array('name'=>'rg_RealStudyPlan', 'fld'=>array('rspId','rspCurId','rspSyId','rspTmId','rspCrsId','rspCoId','rspAdY','rspCdId1','rspCdId2','rspNoCalGPA')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_ReceiptConfig', 'fld'=>array('rcWPaper','rcHPaper','rcYDate','rcXDay','rcXMonth','rcXYear','rcYStName','rcXStName','rcXTerm','rcYItem','rcXItem','rcXAmt','rcYTotal','rcYStr','rcXStr','rcYOfName','rcXOfName','rcYOfPosition','rcXOfPosition','-','-','-','-','-','-','-','-','-')), 'new' =>array('name'=>'rg_ReceiptConfig', 'fld'=>array('rcWPaper','rcHPaper','rcYDate','rcXDay','rcXMonth','rcXYear','rcYStdName','rcXStdName','rcXTerm','rcYItem','rcXItem','rcXAmt','rcYTotal','rcYStr','rcXStr','rcYPrsName','rcXPrsName','rcYPrsPosition','rcXPrsPosition','rcSpace','rcYClgName','rcXClgName','rcYCurName','rcXCurName','rcYTerm','rcXStdCode','rcXAcY','rcPerPage')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','default/0/ ','default/0/ ','default/0/ ','default/0/ ','default/0/ ','default/0/ ','default/0/ ','default/0/ ','default/0/ ')), 'minus' =>array(), 'plus' =>array('19','20','21','22','23','24','25','26','27'), 'sql' =>'?', 'qry' =>" SELECT rcWPaper,rcHPaper,rcYDate,rcXDay,rcXMonth,rcXYear,rcYStName,rcXStName,rcXTerm,rcYItem,rcXItem,rcXAmt,rcYTotal,rcYStr,rcXStr,rcYOfName,rcXOfName,rcYOfPosition,rcXOfPosition,'0','0','0','0','0','0','0','0','0' FROM $dbreg.`rg_ReceiptConfig` "), array('old' =>array('name'=>'RecruitmentType', 'fld'=>array('recruitmentTypeId','recruitmentType')), 'new' =>array('name'=>'rg_RecruitmentType', 'fld'=>array('rtId','rtName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Enroll', 'fld'=>array('studentId','acadYear','semester','sequence','studentYear','programId','submitType','enrollStatus','createUserId','createDateTime','updateUserId','updateDateTime')), 'new' =>array('name'=>'rg_Regist', 'fld'=>array('rgStdId','rgAcY','rgTmId','rgSeq','rgSyId','rgCurId','rgSubmitType','rgStatus','rgCreateUserId','rgCreateDate','rgUpdateUserId','rgUpdateDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'EnrollItem', 'fld'=>array('studentId','acadYear','semester','sequence','classId','creditAttempt','section','grade','gradeNew','credit1','credit2','noCalGPA','conditionId','conditionId2','updateUserId','updateDateTime','allowPr')), 'new' =>array('name'=>'rg_RegistDetails', 'fld'=>array('rdStdId','rdAcY','rdTmId','rdSeq','rdCoId','rdCreditAttempt','rdSection','rdGrade','rdDocNo','rdCredit1','rdCredit2','rdNoCalGPA','rdCdId1','rdCdId2','rdUpdateUserId','rdUpdateDate','rdAllowPr')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'EnrollFee', 'fld'=>array('enrollFeeId','studentId','acadYear','studentYear','semester','programId','totalAmount','balance','refNo','createDateTime','createUserId','updateDateTime','updateUserId')), 'new' =>array('name'=>'rg_RegistFee', 'fld'=>array('rfId','rfStdId','rfAcY','rfSyId','rfTmId','rfCurId','rfTotalAmt','rfBalance','rfRefNo','rfCreateDate','rfCreateUserId','rfUpdateDate','rfUpdateUserId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'WithdrawCourse', 'fld'=>array('studentId','acadYear','semester','sequence','classId','creditAttempt','section','grade','gradeNew','credit1','credit2','noCalGPA','conditionId','conditionId2','updateDateTime','updateUserId')), 'new' =>array('name'=>'rg_RegistWithdraw', 'fld'=>array('rwStdId','rwAcY','rwTmId','rwSeq','rwCoId','rwCreditAttempt','rwSection','rwGrade','rwDocNo','rwCredit1','rwCredit2','rwNoCalGPA','rwCdId1','rwCdId2','rwUpdateDate','rwUpdateUserId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Room', 'fld'=>array('roomId','roomNo','buildingId','capacity')), 'new' =>array('name'=>'rg_Room', 'fld'=>array('rmId','rmNo','rmBdId','rmCapacity')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'Schedule', 'fld'=>array('acadYear','semester','sDate','eDate','enrollSDate','enrollEDate','addWithdrawSDate','addWithdrawEDate','paySDate','payEDate','midExamSDate','midExamEDate','finalExamSDate','finalExamEDate','sendGradeEDate')), 'new' =>array('name'=>'rg_Schedule', 'fld'=>array('sdAcY','sdTmId','sdSDate','sdEDate','sdRegSDate','sdRegEDate','sdAddWithdrawSDate','sdAddWithdrawEDate','sdPaySDate','sdPayEDate','sdMidExamSDate','sdMidExamEDate','sdFinalExamSDate','sdFinalExamEDate','sdSendGradeEDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /','splitDateDb/ /')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT acadYear,semester ,CONCAT(YEAR(sDate)-543,'-',MONTH(sDate),'-',DAY(sDate)) ,CONCAT(YEAR(eDate)-543,'-',MONTH(eDate),'-',DAY(eDate)) ,CONCAT(YEAR(enrollSDate)-543,'-',MONTH(enrollSDate),'-',DAY(enrollSDate)) ,CONCAT(YEAR(enrollEDate)-543,'-',MONTH(enrollEDate),'-',DAY(enrollEDate)) ,CONCAT(YEAR(addWithdrawSDate)-543,'-',MONTH(addWithdrawSDate),'-',DAY(addWithdrawSDate)) ,CONCAT(YEAR(addWithdrawEDate)-543,'-',MONTH(addWithdrawEDate),'-',DAY(addWithdrawEDate)) ,CONCAT(YEAR(paySDate)-543,'-',MONTH(paySDate),'-',DAY(paySDate)) ,CONCAT(YEAR(payEDate)-543,'-',MONTH(payEDate),'-',DAY(payEDate)) ,CONCAT(YEAR(midExamSDate)-543,'-',MONTH(midExamSDate),'-',DAY(midExamSDate)) ,CONCAT(YEAR(midExamEDate)-543,'-',MONTH(midExamEDate),'-',DAY(midExamEDate)) ,CONCAT(YEAR(finalExamSDate)-543,'-',MONTH(finalExamSDate),'-',DAY(finalExamSDate)) ,CONCAT(YEAR(finalExamEDate)-543,'-',MONTH(finalExamEDate),'-',DAY(finalExamEDate)) ,CONCAT(YEAR(sendGradeEDate)-543,'-',MONTH(sendGradeEDate),'-',DAY(sendGradeEDate)) FROM $dbreg.`Schedule` "), array('old' =>array('name'=>'StudentMaster', 'fld'=>array('studentId','studentCode','levelId','programId','prefixId','studentName','studentSurname','studentNameEng','studentSurnameEng','creditAttempt','creditSatisfy','GPA','admitAcadYear','admitSemester','admitDate','finishDate','studentPassword','studentEmail','studentYear','studentStatus','officerId1','officerId2','financeStatus','updateUserId','updateDateTime','citizenId','graduateYear','genStatus','genNo','entryTypeId','entryTypeId2','studentSex','scholarId','preAdmitPositionId','totalPoint','honor','medal','exitExam','studentStatusTmp')), 'new' =>array('name'=>'rg_Student', 'fld'=>array('stdId','stdCode','-','stdCurId','stdPfId','stdName','stdSurname','stdNameE','stdSurnameE','stdCreditAttempt','stdCreditSatisfy','stdGPA','stdAdY','stdTmIdAdmit','stdAdmitDate','stdGraduateDate','-','-','stdSyId','stdSstId','-','-','stdFsId','stdUpdateUsLogin','stdUpdateDate','-','stdGraduateY','stdGenStatus','stdGenId','stdEtId','stdEt2Id','-','stdSoId','stdPaId','stdTotalPoint','stdHonor','stdMedal','stdExitExam','stdSstIdTmp')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','splitDateDb/ /','splitDateDb/ /','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array('2','16','17','20','21','25','31'), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT studentId,studentCode,programId,prefixId,studentName,studentSurname,studentNameEng,studentSurnameEng,creditAttempt,creditSatisfy,GPA,admitAcadYear,admitSemester,CONCAT(YEAR(admitDate)-543,'-',MONTH(admitDate),'-',DAY(admitDate)),CONCAT(YEAR(finishDate)-543,'-',MONTH(finishDate),'-',DAY(finishDate)),studentYear,studentStatus,financeStatus,updateUserId,updateDateTime,graduateYear,genStatus,genNo,entryTypeId,entryTypeId2,scholarId,preAdmitPositionId,totalPoint,honor,medal,exitExam,studentStatusTmp FROM $dbreg.`StudentMaster` "), array('old' =>array('name'=>'StudentAbsent', 'fld'=>array('sequenceId','studentId','dateFrom','dateTo','acadYear','studentYear','absentCause')), 'new' =>array('name'=>'rg_StudentAbsent', 'fld'=>array('sabSeq','sabStdId','sabFrDate','sabToDate','sabAcY','sabSyId','sabCause')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT sequenceId,studentId ,CONCAT(YEAR(dateFrom)-543,'-',MONTH(dateFrom),'-',DAY(dateFrom)) ,CONCAT(YEAR(dateTo)-543,'-',MONTH(dateTo),'-',DAY(dateTo)) ,acadYear,studentYear,absentCause FROM $dbreg.StudentAbsent "), array('old' =>array('name'=>'StudentActivity', 'fld'=>array('sequenceId','studentId','activityName','acadYear','classYear','semester','dateFrom','dateTo','position')), 'new' =>array('name'=>'rg_StudentActivity', 'fld'=>array('sacSeq','sacStdId','sacName','sacAcY','sacSyId','sacTmId','sacFrDate','sacToDate','sacPosition')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT sequenceId,studentId,activityName,acadYear,classYear,semester,CONCAT(YEAR(dateFrom)-543,'-',MONTH(dateFrom),'-',DAY(dateFrom)),CONCAT(YEAR(dateTo)-543,'-',MONTH(dateTo),'-',DAY(dateTo)),position FROM $dbreg.StudentActivity "), array('old' =>array('name'=>'StudentBehavior', 'fld'=>array('sequence','studentId','createDateTime','recordDate','acadYear','semester','description','cutPoint','officerId','disciplineId','approveDate')), 'new' =>array('name'=>'rg_StudentBehavior', 'fld'=>array('sbeSeq','sbeStdId','sbeCreateDate','sbeRecordDate','sbeAcY','sbeTmId','sbeDescription','sbeCutPoint','sbePrsId','sbeDcpId','sbeApproveDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','splitDateDb/ / ','-','-','-','-','-','-','splitDateDb/ / ')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT sequence,studentId,createDateTime,CONCAT(YEAR(recordDate)-543,'-',MONTH(recordDate),'-',DAY(recordDate)),acadYear,semester,description,cutPoint,officerId,disciplineId,CONCAT(YEAR(approveDate)-543,'-',MONTH(approveDate),'-',DAY(approveDate)) FROM $dbreg.`StudentBehavior` "), array('old' =>array('name'=>'StudentBio', 'fld'=>array('studentId','nationId','religionId','bloodGroup','birthDate','birthProvinceId','homeAddress','homeDistrictId','homeAmphurId','homeProvinceId','homeZipcode','homePhoneNo','officeName','officeAddress','officeDistrictId','officeAmphurId','officeProvinceId','officeZipcode','officePhoneNo','workingStatus','workingPosition','workingSalary','fatherName','fatherAddress','fatherDistrictId','fatherAmphurId','fatherProvinceId','fatherZipcode','fatherPhoneNo','fatherOccupation','fatherStatus','motherName','motherAddress','motherDistrictId','motherAmphurId','motherProvinceId','motherZipcode','motherPhoneNo','motherOccupation','motherStatus','studentSex','parentName','parentRelation','parentAddress','parentDistrictId','parentAmphurId','parentProvinceId','parentZipcode','parentPhoneNo','parentMobile','parentOcc','parentIncome','parentEmail','contactPerson','contactAddress','contactDistrictId','contactAmphurId','contactProvinceId','contactZipcode','contactPhoneNo','cardExpiryDate','currentAddress','currentDistrictId','currentAmphurId','currentProvinceId','currentZipcode','currentPhoneNo','graduateAddress','graduateDistrictId','graduateAmphurId','graduateProvinceId','graduateZipcode','graduatePhoneNo','maritalStatusId','weight','height','picturePath','recruitmentTypeId','occExamResult','canRefund','oldStudentName','entryDegree','healthPrivId','-','-','-','-','-','-','-')), 'new' =>array('name'=>'rg_StudentDetails', 'fld'=>array('sdtStdId','sdtNtId','sdtRlgId','sdtBloodGroup','sdtBirthDate','sdtPrvIdBirth','sdtHomeAddr','sdtDtIdHome','sdtApIdHome','sdtPrvIdHome','sdtHomePostCode','sdtHomePhoneNo','sdtWorkName','sdtWorkAddr','sdtDtIdWork','sdtApIdWork','sdtPrvIdWork','sdtWorkPostCode','sdtWorkPhoneNo','sdtWorkStatus','sdtWorkPosition','sdtWorkSalary','sdtFatherName','sdtFatherAddr','sdtDtIdFather','sdtApIdFather','sdtPrvIdFather','sdtFatherPostCode','sdtFatherPhoneNo','sdtFatherOccupation','sdtFatherStatus','sdtMotherName','sdtMotherAddr','sdtDtIdMother','sdtApIdMother','sdtPrvIdMother','sdtMotherPostCode','sdtMotherPhoneNo','sdtMotherOccupation','sdtMotherStatus','sdtSex','sdtParentName','sdtParentRelationship','sdtParentAddr','sdtDtIdParent','sdtApIdParent','sdtPrvIdParent','sdtParentPostCode','sdtParentPhoneNo','sdtParentMobileNo','sdtParentOccupation','sdtParentIncome','sdtParentEmail','sdtContactName','sdtContactAddr','sdtDtIdContact','sdtApIdContact','sdtPrvIdContact','sdtContactPostCode','sdtContactPhoneNo','sdtCardExpireDate','sdtCurrentAddr','sdtDtIdCurrent','sdtApIdCurrent','sdtPrvIdCurrent','sdtCurrentPostCode','sdtCurrentPhoneNo','sdtGraduateAddr','sdtDtIdGraduate','sdtApIdGraduate','sdtPrvIdGraduate','sdtGraduatePostCode','sdtGraduatePhoneNo','sdtMsId','sdtWeight','sdtHeight','sdtPicturePath','sdtRtId','sdtOccExamResult','sdtCanRefund','sdtOldName','sdtEdgIdPre','sdtHpId','sdtCitizenId','sdtEmail','sdtPfIdParent','sdtParentSurname','sdtFatherSurname','sdtMotherSurname','sdtCntId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','StudentBio-studentId-fatherName','-','-','-','-','-','-','-','-','StudentBio-studentId-motherName','-','-','-','-','-','-','-','-','-','StudentBio-studentId-parentName','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','StudentMaster-studentId-citizenId','StudentMaster-studentId-studentEmail','StudentBio-studentId-parentName','StudentBio-studentId-parentName','StudentBio-studentId-fatherName','StudentBio-studentId-motherName','StudentBio-studentId-birthProvinceId')), 'def' =>array('fld'=>array('-','-','-','-','splitDateDb/ / ','sdtPrvId/ /','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','split_prefix&name/ /','-','-','-','-','-','-','-','-','split_prefix&name/ /','-','-','-','-','-','-','-','-','-','split_name/ /','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','picpath/picturePath/ ','-','-','-','-','-','-','-','-','split_prefix/ /','split_surname/ /','split_surname/ /','split_surname/ /','sdtCnt/ /')), 'minus' =>array(), 'plus' =>array('83','84','85','86','87','88','89'), 'sql' =>'?', 'qry' => "select sb.studentId ,sb.nationId ,sb.religionId ,sb.bloodGroup ,CONCAT(YEAR(sb.birthDate)-543,'-',MONTH(sb.birthDate),'-',DAY(sb.birthDate)) AS birthDate ,(case when sb.birthProvinceId = 77 || sb.birthProvinceId = 78 then NULL else sb.birthProvinceId end) as birthProvinceId ,sb.homeAddress ,sb.homeDistrictId ,sb.homeAmphurId ,sb.homeProvinceId ,sb.homeZipcode ,sb.homePhoneNo ,sb.officeName ,sb.officeAddress ,sb.officeDistrictId ,sb.officeAmphurId ,sb.officeProvinceId ,sb.officeZipcode ,sb.officePhoneNo ,sb.workingStatus ,sb.workingPosition ,sb.workingSalary ,(case when (LENGTH(sb.fatherName)-LENGTH(REPLACE(sb.fatherName, ' ', ''))) = 1 then TRIM(LEFT(sb.fatherName,locate(' ',sb.fatherName)-1)) else sb.fatherName end) as fatherName ,sb.fatherAddress ,sb.fatherDistrictId ,sb.fatherAmphurId ,sb.fatherProvinceId ,sb.fatherZipcode ,sb.fatherPhoneNo ,sb.fatherOccupation ,sb.fatherStatus ,(case when (LENGTH(sb.motherName)-LENGTH(REPLACE(sb.motherName, ' ', ''))) = 1 then TRIM(LEFT(sb.motherName,locate(' ',sb.motherName)-1)) else sb.motherName end) as motherName ,sb.motherAddress ,sb.motherDistrictId ,sb.motherAmphurId ,sb.motherProvinceId ,sb.motherZipcode ,sb.motherPhoneNo ,sb.motherOccupation ,sb.motherStatus ,sb.studentSex ,(case when (LENGTH(sb.parentName)-LENGTH(REPLACE(sb.parentName, ' ', ''))) >1 then TRIM(SUBSTRING(sb.parentName,locate(' ',sb.parentName),locate(' ',sb.parentName,locate(' ',sb.parentName)+1)-locate(' ',sb.parentName))) else TRIM(LEFT(sb.parentName,locate(' ',sb.parentName)-1)) end) as parentName ,sb.parentRelation ,sb.parentAddress ,sb.parentDistrictId ,sb.parentAmphurId ,sb.parentProvinceId ,sb.parentZipcode ,sb.parentPhoneNo ,sb.parentMobile ,sb.parentOcc ,sb.parentIncome ,sb.parentEmail ,sb.contactPerson ,sb.contactAddress ,sb.contactDistrictId ,sb.contactAmphurId ,sb.contactProvinceId ,sb.contactZipcode ,sb.contactPhoneNo ,sb.cardExpiryDate ,sb.currentAddress ,sb.currentDistrictId ,sb.currentAmphurId ,sb.currentProvinceId ,sb.currentZipcode ,sb.currentPhoneNo ,sb.graduateAddress ,sb.graduateDistrictId ,sb.graduateAmphurId ,sb.graduateProvinceId ,sb.graduateZipcode ,sb.graduatePhoneNo ,sb.maritalStatusId ,sb.weight ,sb.height ,TRIM(REPLACE(sb.picturePath,'../pictureStud/','')) ,sb.recruitmentTypeId ,sb.occExamResult ,sb.canRefund ,sb.oldStudentName ,sb.entryDegree ,sb.healthPrivId ,sm.citizenId ,sm.studentEmail ,(case when (LENGTH(sb.parentName)-LENGTH(REPLACE(sb.parentName, ' ', ''))) >1 then (select pfId from $dbmoreg.rg_Prefix where pfName = TRIM(LEFT(sb.parentName,locate(' ',sb.parentName)-1)) group by pfName) else NULL end) as pfParent ,(case when (LENGTH(sb.parentName)-LENGTH(REPLACE(sb.parentName, ' ', ''))) >1 then TRIM(SUBSTRING(sb.parentName,locate(' ',sb.parentName,locate(' ',sb.parentName)+1),CHAR_LENGTH(sb.parentName))) else TRIM(SUBSTRING(sb.parentName,locate(' ',sb.parentName),CHAR_LENGTH(sb.parentName))) end) AS parentSurName ,(case when (LENGTH(sb.fatherName)-LENGTH(REPLACE(sb.fatherName, ' ', ''))) >1 then TRIM(SUBSTRING(sb.fatherName,locate(' ',sb.fatherName,locate(' ',sb.fatherName)+1),CHAR_LENGTH(sb.fatherName))) else TRIM(SUBSTRING(sb.fatherName,locate(' ',sb.fatherName),CHAR_LENGTH(sb.fatherName))) end) AS fatherSurName ,(case when (LENGTH(sb.motherName)-LENGTH(REPLACE(sb.motherName, ' ', ''))) >1 then TRIM(SUBSTRING(sb.motherName,locate(' ',sb.motherName,locate(' ',sb.motherName)+1),CHAR_LENGTH(sb.motherName))) else TRIM(SUBSTRING(sb.motherName,locate(' ',sb.motherName),CHAR_LENGTH(sb.motherName))) end) AS motherSurName ,(case when sb.birthProvinceId = 77 || sb.birthProvinceId = 78 then sb.birthProvinceId else 7 end) as sdtCnt FROM $dbreg.`StudentBio` sb inner join $dbreg.`StudentMaster` sm on sb.studentId = sm.studentId"), array('old' =>array('name'=>'StudentDom', 'fld'=>array('studentId','acadYear','semester','domId','monthAmount')), 'new' =>array('name'=>'rg_StudentDomitory', 'fld'=>array('sdmStdId','sdmAcY','sdmTmId','sdmDmId','sdmNumMonth')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'StudentEducation', 'fld'=>array('studentId','levelId','institution','institutionEng','provinceId','graduatedYear','grade')), 'new' =>array('name'=>'rg_StudentEduHis', 'fld'=>array('sehStdId','sehElvId','sehInstitutionName','sehInstitutionNameE','sehPrvId','sehGraduateY','sehGPA')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'StudentReward', 'fld'=>array('sequence','studentId','receiveDate','reward','description')), 'new' =>array('name'=>'rg_StudentReward', 'fld'=>array('srwSeq','srwStdId','srwReceiveDate','srwRewardName','srwDescription')), 'ref' =>array('fld'=>array('-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'?', 'qry' =>" SELECT `sequence`,`studentId` ,CONCAT(YEAR(receiveDate)-543,'-',MONTH(receiveDate),'-',DAY(receiveDate)) ,`reward`,`description` FROM $dbreg.StudentReward "), array('old' =>array('name'=>'SysStudentStatusDes', 'fld'=>array('studentStatus','studentStatusCode','description','studentStatusDefault')), 'new' =>array('name'=>'rg_StudentStatus', 'fld'=>array('sstId','sstCode','sstName','sstDefault')), 'ref' =>array('fld'=>array('-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'StudentStatus', 'fld'=>array('studentId','acadYear','semester','studentStatus','GPA','creditAttempt','creditSatisfy','creditPoint','GPAX','sumCreditAttempt','sumCreditSatisfy','sumCreditPoint','createDateTime','createUserId','updateDateTime','updateUserId','approveSpe','approver','refNo','approveDate','passStatus','-')), 'new' =>array('name'=>'rg_StudentSummary', 'fld'=>array('ssmStdId','ssmAcY','ssmTmId','ssmSstId','ssmGPA','ssmCreditAttempt','ssmCreditSatisfy','ssmCreditPoint','ssmGPAX','ssmSumCreditAttempt','ssmSumCreditSatisfy','ssmSumCreditPoint','ssmCreateDate','ssmCreateUserId','ssmUpdateDate','ssmUpdateUserId','ssmSstIdApproveSpe','ssmApprover','ssmRefNo','ssmApproveDate','ssmPassStatus','ssmSyId')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','gen/ /')), 'minus' =>array(), 'plus' =>array('21'), 'sql' =>'?', 'qry' => "SELECT studentId ,acadYear ,semester ,studentStatus ,GPA ,creditAttempt ,creditSatisfy ,creditPoint ,GPAX ,sumCreditAttempt ,sumCreditSatisfy ,sumCreditPoint ,createDateTime ,createUserId ,updateDateTime ,updateUserId ,approveSpe ,approver ,refNo ,CONCAT(YEAR(approveDate)-543,'-',MONTH(approveDate),'-',DAY(approveDate)) ,passStatus , ( SELECT count( studentId ) +1 AS npass FROM $dbreg.`StudentStatus` ss2 WHERE ss.studentId = ss2.studentId AND ( ss2.acadYear < ss.acadYear OR ( ss2.acadYear = ss.acadYear AND ss2.semester < ss.semester ) ) AND ss2.passStatus IN ( 1, 2, 3 ) ) AS sy FROM $dbreg.`StudentStatus` ss WHERE 1 =1 ORDER BY ss.studentId"), array('old' =>array('name'=>'rg_SubExternalPlace', 'fld'=>array('sepId','sepName')), 'new' =>array('name'=>'rg_SubExternalPlace', 'fld'=>array('sepId','sepName')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'SummaryStudent', 'fld'=>array('acadYear','programId','admitAcadYear','entryTypeId','studentSex','admitStNum','graduateStNum','scholarStNum','updateDateTime')), 'new' =>array('name'=>'rg_SummaryStudent', 'fld'=>array('smAcY','smCurId','smAdY','smEtId','smStdSex','smNumAdmitSt','smNumGraduateSt','smNumScholarSt','smUpdateDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'SummaryStudentStY', 'fld'=>array('acadYear','programId','admitAcadYear','studentYear','entryTypeId','studentSex','stNum','repeatClassStNum','outStNum','updateDateTime')), 'new' =>array('name'=>'rg_SummaryStudentStdY', 'fld'=>array('smyAcY','smyCurId','smyAdY','smySyId','smyEtId','smyStdSex','smyNumSt','smyNumRepeatClassSt','smyNumOutSt','smyUpdateDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_TeachingMethod', 'fld'=>array('tcId','tcName','tcNameEng')), 'new' =>array('name'=>'rg_TeachingMethod', 'fld'=>array('tcmId','tcmName','tcmNameE')), 'ref' =>array('fld'=>array('-','-','-')), 'def' =>array('fld'=>array('-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_TimeTable', 'fld'=>array('ttId','ttClId','ttRmId','ttEpMepId','ttEpSepId','ttWdAcYWeekNo','ttDyId','ttFrPr','ttToPr','ttOfId','ttSstId','ttTitle')), 'new' =>array('name'=>'rg_TimeTable', 'fld'=>array('ttId','ttCoId','ttRmId','ttEtpMepId','ttEtpSepId','ttWdAcYWeekNo','ttDyId','ttPrdFrTime','ttPrdToTime','ttPrsId','ttStId','ttTitle')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_CopyTimeTable', 'fld'=>array('ctId','ctClId','ctRmId','ctEpMepId','ctEpSepId','ctWdAcYWeekNo','ctDyId','ctFrPr','ctToPr','ctOfId','ctSstId','ctTtId','ctLtId','ctConfirm','ctUpdateUserId','ctUpdateDateTime')), 'new' =>array('name'=>'rg_TimeTableCopy', 'fld'=>array('ttcId','ttcCoId','ttcRmId','ttcEtpMepId','ttcEtpSepId','ttcWdAcYWeekNo','ttcDyId','ttcPrdFrTime','ttcPrdToTime','ttcPrsId','ttcStId','ttcTtId','ttcLtId','ttcConfirm','ttcUpdateUserId','ttcUpdateDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_TCInTT', 'fld'=>array('titTtId','titTcId')), 'new' =>array('name'=>'rg_TTTeachingMethod', 'fld'=>array('tttTtId','tttTcmId')), 'ref' =>array('fld'=>array('-','-')), 'def' =>array('fld'=>array('-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_HrPerUnit', 'fld'=>array('huAcY','huTmId','huLtId','huHr','huUnit','huMinSt','huMaxSt','huUnitPerSt','huDefault')), 'new' =>array('name'=>'rg_UnitConfig', 'fld'=>array('ucAcY','ucTmId','ucLtId','ucHr','ucUnit','ucMinSt','ucMaxSt','ucUnitPerSt','ucDefault')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'rg_WeekDate', 'fld'=>array('wdAcY','wdAcYWeekNo','wdTmId','wdTmWeekNo','wdFrDate','wdToDate')), 'new' =>array('name'=>'rg_WeekDate', 'fld'=>array('wdAcY','wdAcYWeekNo','wdTmId','wdTmWeekNo','wdFrDate','wdToDate')), 'ref' =>array('fld'=>array('-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-') ); /* , array('old' =>array('name'=>'FileUpdate', 'fld'=>array('fileId','updateDate','filename1','filename2','flagfile','flagupdate','path','detail','sysId','updatetime','flagselect','flagrestore','flaguse')), 'new' =>array('name'=>'FileUpdate', 'fld'=>array('fileId','updateDate','filename1','filename2','flagfile','flagupdate','path','detail','sysId','updatetime','flagselect','flagrestore','flaguse')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'FileUpdateTemp', 'fld'=>array('fileld')), 'new' =>array('name'=>'FileUpdateTemp', 'fld'=>array('fileld')), 'ref' =>array('fld'=>array('-')), 'def' =>array('fld'=>array('-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-'), array('old' =>array('name'=>'updateDataTemp', 'fld'=>array('query_id','operation','tablename','fieldname','oldV','newV','Condition','description','date','time','flag')), 'new' =>array('name'=>'updateDataTemp', 'fld'=>array('query_id','operation','tablename','fieldname','oldV','newV','Condition','description','date','time','flag')), 'ref' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')), 'def' =>array('fld'=>array('-','-','-','-','-','-','-','-','-','-','-')), 'minus' =>array(), 'plus' =>array(), 'sql' =>'-') */ ?>