API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
55
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.52 KB | None | 0 0
raw download clone embed print report
  1. /**
  2. * Created by Jonathan Evans on 7/6/17.
  3. */
  4. public class YouthGuidance {
  5.  
  6. //Update move school ProgEnroll contract staff
  7. public static void updateTeamSchoolAssignment(String originalParId, String dupParId) {
  8. System.out.println("--UPDATE DUPLICATE TEAM-SCHOOL ASSIGNMENT\n" +
  9. "\n" +
  10.  
  11. "select * from FD__TEAM_ASSIGNMENT\n" +
  12. "where OP__PARENTID = " + dupParId + "\n" +
  13.  
  14. "\n" +
  15. "select * from T4W_DOCUMENTS\n" +
  16. "where OP__PARENTID = " + dupParId + "\n" +
  17.  
  18. "\n" +
  19. "\n" +
  20. "\n" +
  21.  
  22. "update T4W_DOCUMENTS\n" +
  23. "set OP__PARENTID = " + originalParId + "\n" +
  24. "where OP__PARENTID = " + dupParId + " and OP__FORMID = 613\n" +
  25.  
  26. "\n" +
  27. "update FD__TEAM_ASSIGNMENT\n" +
  28. "set OP__PARENTID = " + originalParId + "\n" +
  29. ",OP__FOLDERID = " + originalParId + "\n" +
  30. "where OP__PARENTID = " + dupParId + "\n" +
  31.  
  32. "\n" +
  33. "\n" +
  34.  
  35. "--COMFIRM ROW IS IN THE T4W_DOCUMENTS TABLE\n" +
  36. "select * from T4W_DOCUMENTS\n" +
  37. "where OP__PARENTID = " + originalParId + "\n" +
  38.  
  39. "\n" +
  40. "--CONFIRM ROW IS IN THE FD__TEAM_ASSIGNMENT TABLE\n" +
  41. "select * from FD__TEAM_ASSIGNMENT\n" +
  42. "where OP__PARENTID = " + originalParId + "\n");
  43. }
  44.  
  45. public static void updatePE(String originalParId, String dupParId) {
  46.  
  47. System.out.println(
  48. "--Update Duplicate program enrollment\n" +
  49. "select * from dbo.T4W_DOCUMENTS\n" +
  50. "where op__parentid = " + dupParId + "\n" +
  51. "\n" +
  52.  
  53. "select * from dbo.FD__PROGRAM_ENROLLMENT_FORM\n" +
  54. "where OP__PARENTID = " + dupParId + "\n" +
  55. "\n" +
  56. "\n" +
  57. "update dbo.T4W_DOCUMENTS\n" +
  58.  
  59. "set OP__PARENTID = " + originalParId + "\n" +
  60. "where OP__PARENTID = " + dupParId +" and OP__FORMID = 606\n" +
  61. "\n" +
  62.  
  63. "update dbo.FD__PROGRAM_ENROLLMENT_FORM\n" +
  64. "set OP__PARENTID = " + originalParId + ", OP__FOLDERID = " + originalParId + "\n" +
  65. "where OP__PARENTID = " + dupParId + "\n" +
  66.  
  67. "\n--CONFIRM ROW IS IN T4W_DOCUMENTS TABLE\n" +
  68. "select * from T4W_DOCUMENTS\n" +
  69. "where OP__PARENTID = " + originalParId +"\n" +
  70. "\n" +
  71. "--CONFIRM ROW IS IN FD__PROGRAM_ENROLLMENT_FORM TABLE\n" +
  72. "select * from FD__PROGRAM_ENROLLMENT_FORM\n" +
  73. "where OP__PARENTID = " + originalParId + "\n");
  74.  
  75. }
  76.  
  77. public static void updateDuplicateContractAssignment(String origPEDoc, String dupPEDoc) {
  78. System.out.println(
  79. "--UPDATE DUPLICATE CONTRACT ASSIGNMENT\n" +
  80. "--NOTE: MUST ***NOT*** use the OP__PARENTID of the General Intake\n" +
  81. "--MUST use the OP__PARENTID of the Program Enrollment form\n" +
  82. "\n" +
  83.  
  84. "select * from T4W_DOCUMENTS\n" +
  85. "where OP__PARENTID = " + origPEDoc + "\n" +
  86. "\n" +
  87.  
  88. "select * from FD__Contract_Assignment\n" +
  89. "where OP__PARENTID = " + origPEDoc + "\n" +
  90. "\n" +
  91.  
  92. "update T4W_DOCUMENTS\n" +
  93. "set OP__PARENTID = " + origPEDoc + "\n" +
  94. "where OP__PARENTID = " + dupPEDoc + " and OP__FORMID = 610\n" +
  95. "\n" +
  96.  
  97. "update FD__Contract_Assignment\n" +
  98. "set OP__PARENTID = " + origPEDoc + "\n" +
  99. ", OP__FOLDERID = " + origPEDoc + "\n" +
  100. "where OP__PARENTID = " + dupPEDoc + "\n" +
  101. "\n" +
  102.  
  103. "--CONFIRM CONTRACT ASSIGNMENT HAS BEEN MOVED\n" +
  104. "select * from T4W_DOCUMENTS\n" +
  105. "where OP__PARENTID = " + origPEDoc + "\n" +
  106. "\n" +
  107.  
  108. "select * from FD__Contract_Assignment\n" +
  109. "where OP__PARENTID = " + origPEDoc + "\n");
  110. }
  111.  
  112. public static void updateDuplicateStaffAssignment(String origPEDoc, String dupPEDoc) {
  113. System.out.println("--UPDATE DUPLICATE STAFF ASSIGNMENT\n" +
  114. "--NOTE: MUST ***NOT*** use the OP__PARENTID of the General Intake\n" +
  115. "--MUST use the OP__PARENTID of the Program Enrollment form\n" +
  116.  
  117. "\nselect * from T4W_DOCUMENTS\n" +
  118. "where OP__PARENTID = " + origPEDoc + "\n" +
  119.  
  120. "\n" +
  121. "select * from FD__STAFF_ASSIGNMENT_FORM\n" +
  122. "where OP__PARENTID = " + origPEDoc + "\n" +
  123.  
  124. "\n" +
  125.  
  126. "\n" +
  127. "update FD__STAFF_ASSIGNMENT_FORM\n" +
  128. "set OP__PARENTID = " + origPEDoc + ", OP__FOLDERID = " + origPEDoc + "\n" +
  129. "where OP__PARENTID = " + dupPEDoc + "\n" +
  130.  
  131. "\n" +
  132. "update T4W_DOCUMENTS\n" +
  133. "set OP__PARENTID = " + origPEDoc + "\n" +
  134. "where OP__PARENTID = " + dupPEDoc + " and OP__FORMID = 609\n" +
  135.  
  136. "\n" +
  137. "--CONFIRM STAFF ASSIGNMENT HAS BEEN MOVED\n" +
  138. "select * from T4W_DOCUMENTS\n" +
  139. "where OP__PARENTID = " + origPEDoc + "\n" +
  140.  
  141. "\n" +
  142. "select * from FD__STAFF_ASSIGNMENT_FORM\n" +
  143. "where OP__PARENTID = " + origPEDoc + "\n");
  144. }
  145.  
  146.  
  147. //Update move consents for dupl folders
  148. public static void updateConsents(String originalParId, String dupParId, String origYGId) {
  149. System.out.println("--UPDATE CONSENTS\n" +
  150. "\n" +
  151.  
  152. "select * from T4W_DOCUMENTS\n" +
  153. "where OP__PARENTID = " + dupParId + " and OP__CREATORNAME = 'SP__CONSENTS'\n" +
  154.  
  155. "\n" +
  156. "select * from fd__consents\n" +
  157. "where OP__PARENTID = " + dupParId + "\n" +
  158.  
  159. "\n" +
  160. "update T4W_DOCUMENTS\n" +
  161. "set OP__PARENTID= " + originalParId + "\n" +
  162. "where OP__PARENTID = " + dupParId + " and OP__CREATORNAME = 'SP__CONSENTS'\n" +
  163.  
  164. "\n" +
  165. "update FD__CONSENTS\n" +
  166. "set OP__PARENTID = " + originalParId + "\n" +
  167. ", OP__FOLDERID = " + originalParId + "\n" +
  168. ", YGID = " + origYGId + "\n" +
  169. "where OP__PARENTID = " + dupParId + "\n" +
  170.  
  171. "\n" +
  172. "\n" +
  173. "\n" +
  174.  
  175. "\n" +
  176. "--CONFIRM ROWS ARE IN T4W_DOCUMENTS\n" +
  177. "select * from T4W_DOCUMENTS\n" +
  178. "where OP__PARENTID = " + originalParId + " and OP__CREATORNAME = 'SP__CONSENTS'\n" +
  179.  
  180. "\n" +
  181. "--CONFIRM ROWS ARE IN FD__CONSENTS TABLE\n" +
  182. "select * from FD__CONSENTS\n" +
  183. "where op__parentid = " + originalParId + "\n");
  184. }
  185.  
  186.  
  187. //Update move contact info grade
  188. public static void updateDuplicateContactInformation(String originalParId, String dupParId) {
  189. System.out.println("--UPDATE DUPLICATE Contact Information\n" +
  190. "\n" +
  191.  
  192. "select * from T4W_DOCUMENTS\n" +
  193. "where OP__PARENTID = " + dupParId + "\n" +
  194.  
  195. "\n" +
  196. "select * from FD__SUBFORM_ADDRESS_INFORMATIO\n" +
  197. "where OP__PARENTID = " + dupParId + "\n" +
  198.  
  199. "\n" +
  200.  
  201. "\n" +
  202. "update T4W_DOCUMENTS\n" +
  203. "set OP__PARENTID = " + originalParId + "\n" +
  204. "where OP__PARENTID = " + dupParId + " and OP__FORMID = 513\n" +
  205.  
  206. "\n" +
  207. "update FD__SUBFORM_ADDRESS_INFORMATIO\n" +
  208. "set OP__PARENTID = " + originalParId + "\n" +
  209. ",OP__FOLDERID = " + originalParId + "\n" +
  210. "where OP__PARENTID = " + dupParId + "\n" +
  211.  
  212. "\n" +
  213. "\n" +
  214.  
  215. "--CONFIRM ROW IS IN T4W_DOCUMENTS TABLE\n" +
  216. "select * from T4W_DOCUMENTS\n" +
  217. "where OP__PARENTID = " + originalParId + "\n" +
  218.  
  219. "\n" +
  220. "--CONFIRM ROW IS IN fd__SUBFORM_ADDRESS_INFORMATIO TABLE\n" +
  221. "select * from FD__SUBFORM_ADDRESS_INFORMATIO\n" +
  222. "where OP__PARENTID = " + originalParId + "\n");
  223. }
  224.  
  225. public static void unduplicateRFAForms(String originalParId, String dupParId) {
  226. System.out.println("--UNDUPLICATE RFA FORMS\n" +
  227.  
  228. "\n" +
  229. "select * from FD__BEHAVIORAL_HEALTH_RFA\n" +
  230. "where OP__PARENTID = " + dupParId + "\n" +
  231.  
  232. "\n" +
  233. "select * from T4W_DOCUMENTS\n" +
  234. "where OP__PARENTID = " + dupParId + "\n" +
  235.  
  236. "\n" +
  237. "update FD__BEHAVIORAL_HEALTH_RFA\n" +
  238. "set OP__PARENTID = " + originalParId + "\n" +
  239. ", OP__FOLDERID = " + originalParId + "\n" +
  240. "where OP__PARENTID = " + dupParId + "\n" +
  241.  
  242. "\n" +
  243. "update T4W_DOCUMENTS\n" +
  244. "set OP__PARENTID = " + originalParId + "\n" +
  245. "where OP__PARENTID = " + dupParId + " and OP__FORMID = 1007\n" +
  246.  
  247. "\n" +
  248.  
  249. "\n" +
  250. "\n--CONFIRM RFA FORM HAS BEEN MOVED\n" +
  251. "select * from FD__BEHAVIORAL_HEALTH_RFA\n" +
  252. "where OP__PARENTID = " + originalParId + "\n" +
  253.  
  254. "\n" +
  255. "select * from T4W_DOCUMENTS\n" +
  256. "where OP__PARENTID = " + originalParId + "\n");
  257. }
  258.  
  259. public static void unduplicateGradeInSchool(String originalParId, String dupParId) {
  260. System.out.println(
  261. "--UNDUPLICATE GRADE IN SCHOOL\n" +
  262. "\n" +
  263.  
  264. "select * from dbo.T4W_DOCUMENTS\n" +
  265. "where op__parentid = " + dupParId + "\n" +
  266. "\n" +
  267.  
  268. "select * from dbo.FD__STUDENT_YEAR_TRACKING\n" +
  269. "where OP__PARENTID = " + dupParId + "\n" +
  270. "\n" +
  271. "\n" +
  272.  
  273. "update dbo.T4W_DOCUMENTS\n" +
  274. "set OP__PARENTID = " + originalParId + "\n" +
  275. "where OP__PARENTID = " + dupParId + " and OP__FORMID = 589\n" +
  276.  
  277. "\n" +
  278. "update dbo.FD__STUDENT_YEAR_TRACKING\n" +
  279. "set OP__PARENTID = " + originalParId + ", OP__FOLDERID = " + originalParId + "\n" +
  280. "where OP__PARENTID = " + dupParId + "\n" +
  281.  
  282. "\n" +
  283. "\n" +
  284.  
  285. "--CONFIRM GRADE IN SCHOOL HAS BEEN MOVED\n" +
  286. "select * from dbo.T4W_DOCUMENTS\n" +
  287. "where op__parentid = " + originalParId + "\n" +
  288.  
  289. "\n" +
  290. "select * from dbo.FD__STUDENT_YEAR_TRACKING\n" +
  291. "where OP__PARENTID = " + originalParId + "\n");
  292. }
  293.  
  294. public static void unduplicateMedicaidStatus(String originalParId, String dupParId) {
  295. System.out.println(
  296. "--UNDUPLICATE MEDICAID STATUS\n" +
  297.  
  298. "\n" +
  299. "select * from dbo.T4W_DOCUMENTS\n" +
  300. "where op__parentid = " + dupParId + "\n" +
  301.  
  302. "\n" +
  303. "select * from dbo.FD__MEDICAID_STATUS\n" +
  304. "where op__parentid = " + dupParId + "\n" +
  305.  
  306. "\n" +
  307. "\n" +
  308. "update dbo.T4W_DOCUMENTS\n" +
  309. "set OP__PARENTID = " + originalParId + "\n" +
  310. "where OP__PARENTID = " + dupParId + " and OP__FORMID = 977\n" +
  311.  
  312. "\n" +
  313. "update dbo.FD__MEDICAID_STATUS\n" +
  314. "set OP__PARENTID = " + originalParId + ", OP__FOLDERID = " + originalParId + "\n" +
  315. "where OP__PARENTID = " + dupParId + "\n" +
  316.  
  317. "\n" +
  318. "\n" +
  319. "--CONFIRM MEDICAID STATUS HAS BEEN MOVED\n" +
  320.  
  321. "\n" +
  322. "select * from dbo.T4W_DOCUMENTS\n" +
  323. "where op__parentid = " + originalParId + "\n" +
  324.  
  325. "\n" +
  326. "select * from dbo.FD__MEDICAID_STATUS\n" +
  327. "where op__parentid = " + originalParId + "\n");
  328. }
  329.  
  330.  
  331. //Update Group enrollment attendance ygid for dupl folders
  332. public static void updateGroupEnrollment(String origYGId, String dupYGId, String originalParId) {
  333. System.out.println(
  334. "--update dbo.FD__Group_Enrollment\n" +
  335. "\n" +
  336.  
  337. "select * from dbo.FD__Group_Enrollment\n" +
  338. "where YGID = " + dupYGId + "\n" +
  339.  
  340. "\n" +
  341. "update dbo.FD__Group_Enrollment\n" +
  342. "set YGID = " + origYGId + "\n" +
  343. "where YGID = " + dupYGId + "\n");
  344. //
  345. // "\n" +
  346. // "--CONFIRM ROWS ARE IN T4W_DOCUMENTS\n" +
  347. // "select * from T4W_DOCUMENTS\n" +
  348. // "where OP__ID = " + originalParId + "\n" +
  349. //
  350. // "\n" +
  351. // "--CONFIRM ROWS ARE STILL IN FD__GROUP_ENROLLMENT\n" +
  352. // "select * from FD__Group_Enrollment\n" +
  353. // "where YGID = " + origYGId + "\n");
  354.  
  355. // "\n" +
  356. // "--set ygid = correct ygid\n" +
  357. // "--where (ygid = wrong ygid and op__folderid = correct folderid)\n" +
  358. //
  359. // "\n" +
  360. // "--and Group_ID = 1934866");
  361. }
  362.  
  363. public static void updateAttendanceRecords(String originalParId, String dupParId, String origYGId, String dupYGId) {
  364. System.out.println(
  365. "--UPDATE ATTENDANCE RECORDS FOR GROUP PROGRESS NOTES\n" +
  366. "\n" +
  367.  
  368. "select * from dbo.FD__ATTENDANCE\n" +
  369. "where YGID = " + origYGId + "\n" +
  370. "/*and OP__PARENTID= "+ originalParId + "*/\n" +
  371.  
  372. "\n" +
  373. "update dbo.FD__Attendance\n" +
  374. "set ygid = " + origYGId + "\n" +
  375. "where ygid = " + dupYGId + "\n" +
  376. "/*and OP__PARENTID= " + dupParId + "*/\n" +
  377.  
  378. "\n" +
  379. "--CONNFIRM ROWS ARE STILL IN FD__ATTENDANCE\n" +
  380. "select * from dbo.FD__ATTENDANCE\n" +
  381. "where YGID = " + origYGId + "\n");
  382. }
  383.  
  384. //Central Location to print SQL Scripts
  385. public static void printSQL(String originalParId, String dupParId, String origPEDoc, String dupPEDoc, String origYGId, String dupYGId) {
  386.  
  387. //Print out all Ids
  388. System.out.println("--Original docID " + originalParId);
  389. System.out.println("--Duplicate docID " + dupParId);
  390. System.out.println("--Original origPEDoc " + origPEDoc);
  391. System.out.println("--Duplicate dupPEDoc " + dupPEDoc);
  392. System.out.println("--Original YGID " + origYGId);
  393. System.out.println("--Duplicate YGID " + dupYGId + "\n");
  394.  
  395. //Update Enrollment Move School Contract Assignment
  396. updateTeamSchoolAssignment(originalParId, dupParId);
  397. updatePE(originalParId, dupParId);
  398. //updateDuplicateContractAssignment(origPEDoc, dupPEDoc);
  399. //updateDuplicateStaffAssignment(origPEDoc, dupPEDoc);
  400.  
  401. //Update move consents for dupl folders
  402. updateConsents(originalParId, dupParId, origYGId);
  403.  
  404. //Update move contact info grade
  405. updateDuplicateContactInformation(originalParId, dupParId);
  406. unduplicateRFAForms(originalParId, dupParId);
  407. unduplicateGradeInSchool(originalParId, dupParId);
  408. unduplicateMedicaidStatus(originalParId, dupParId);
  409.  
  410. //Update Group enrollment attendance ygid for dupl folders
  411. updateGroupEnrollment(origYGId, dupYGId, originalParId);
  412. updateAttendanceRecords(originalParId, dupParId, origYGId, dupYGId);
  413. }
  414.  
  415.  
  416.  
  417. public static void main (String[] args) {
  418. printSQL("2231999", "2402638", "BLANK", "BLANK", "40926", "42349");
  419. }
  420.  
  421. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!