Viewing file:  arr_reg.php (48.22 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$sm=array(
array('old' =>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' =>'-')
*/
?>
|