API tools faq
paste
Guest User

Untitled

a guest
Apr 4th, 2018
140
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.03 KB | None | 0 0
raw download clone embed print report
  1. from tkinter import *
  2. import mysql.connector as mc
  3. import tkinter.messagebox as tm
  4.  
  5. def put(*args):
  6. global B
  7. global e_name
  8. global e_owner
  9. global e_region
  10. global e_province
  11. global e_municipality
  12. global e_barangay
  13.  
  14. e_name = i_name.get()
  15. e_owner = i_owner.get()
  16. e_region = i_region.get()
  17. e_province = i_province.get()
  18. e_municipality = i_municipality.get()
  19. e_barangay = i_barangay.get()
  20.  
  21. if(e_region is 3):
  22. if(e_province is Aurora):
  23. P = 1
  24. if(e_province is Bataan):
  25. if(e_municipality is Abucay):
  26. if(e_barangay is Bangkal):
  27. B = 5020101
  28. if(e_barangay is Calaylayan):
  29. B = 5020102
  30. if(e_barangay is Capitangan):
  31. B = 5020103
  32. if(e_barangay is Gabon):
  33. B = 5020104
  34. if(e_barangay is Laon):
  35. B = 5020105
  36. if(e_barangay is Mabatang):
  37. B = 5020106
  38. if(e_barangay is Omboy):
  39. B = 5020107
  40. if(e_barangay is Salian):
  41. B = 5020108
  42. if(e_barangay is Wawa):
  43. B = 5020109
  44. if(e_municipality is Bagac):
  45. if(e_barangay is Atilano):
  46. B = 5020201
  47. if(e_barangay is Bagumbayan):
  48. B = 5020202
  49. if(e_barangay is Banawang):
  50. B = 5020203
  51. if(e_barangay is Binuangan):
  52. B = 5020204
  53. if(e_barangay is Binukawan):
  54. B = 5020205
  55. if(e_barangay is Ibaba):
  56. B = 5020206
  57. if(e_barangay is Pag-asa):
  58. B = 5020207
  59. if(e_barangay is Parang):
  60. B = 5020208
  61. if(e_barangay is Paysawan):
  62. B = 5020209
  63. if(e_barangay is Quinawan):
  64. B = 5020210
  65. if(e_barangay is San-Antonio):
  66. B = 5020211
  67. if(e_barangay is Saysain):
  68. B = 5020212
  69. if(e_barangay is Tabing-ilog):
  70. B = 5020213
  71. if(e_municipality is Balanga):
  72. if(e_barangay is Bagong-Silang):
  73. B = 5020301
  74. if(e_barangay is Bagumbayan):
  75. B = 5020302
  76. if(e_barangay is Cabog-cabog):
  77. B = 5020303
  78. if(e_barangay is Camacho):
  79. B = 5020304
  80. if(e_barangay is Cataning):
  81. B = 5020305
  82. if(e_barangay is Central):
  83. B = 5020306
  84. if(e_barangay is Cupang-North):
  85. B = 5020307
  86. if(e_barangay is Cupang-Proper):
  87. B = 5020308
  88. if(e_barangay is Cupang-West):
  89. B = 5020309
  90. if(e_barangay is Dangcol):
  91. B = 5020310
  92. if(e_barangay is Dona-Francisca):
  93. B = 5020311
  94. if(e_barangay is Ibayo):
  95. B = 5020312
  96. if(e_barangay is Malabia):
  97. B = 5020313
  98. if(e_barangay is Munting-Batangas):
  99. B = 5020314
  100. if(e_barangay is Poblacion):
  101. B = 5020315
  102. if(e_barangay is Pto. Rivas-Ibaba):
  103. B = 5020316
  104. if(e_barangay is Pto. Rivas-Itaas):
  105. B = 5020317
  106. if(e_barangay is Pto. Rivas-Lote):
  107. B = 5020318
  108. if(e_barangay is San-Jose):
  109. B = 5020319
  110. if(e_barangay is Sibacan):
  111. B = 5020320
  112. if(e_barangay is Talisay):
  113. B = 5020321
  114. if(e_barangay is Tanato):
  115. B = 5020322
  116. if(e_barangay is Tenejero):
  117. B = 5020323
  118. if(e_barangay is Tortugas):
  119. B = 5020324
  120. if(e_barangay is Tuyo):
  121. B = 5020325
  122. if(e_municipality is Dinalupihan):
  123. if(e_barangay is Aquino):
  124. B = 5020401
  125. if(e_barangay is Bangal):
  126. B = 5020402
  127. if(e_barangay is Bayan-bayanan):
  128. B = 5020403
  129. if(e_barangay is Colo):
  130. B = 5020406
  131. if(e_barangay is Daang-bago):
  132. B = 5020407
  133. if(e_barangay is Dalao):
  134. B = 5020408
  135. if(e_barangay is Happy-Valley):
  136. B = 5020412
  137. if(e_barangay is Jose-C.Payumo-Jr):
  138. B = 5020413
  139. if(e_barangay is Kataasan):
  140. B = 5020414
  141. if(e_barangay is Layac):
  142. B = 5020415
  143. if(e_barangay is Luacan):
  144. B = 5020416
  145. if(e_barangay is Magsaysay):
  146. B = 5020419
  147. if(e_barangay is Maligaya):
  148. B = 5020420
  149. if(e_barangay is Naparing):
  150. B = 5020421
  151. if(e_barangay is New-San-Jose):
  152. B = 5020422
  153. if(e_barangay is Old-San-Jose):
  154. B = 5020423
  155. if(e_barangay is Pag-asa):
  156. B = 5020425
  157. if(e_barangay is Pagalanggang):
  158. B = 5020426
  159. if(e_barangay is Payangan):
  160. B = 5020427
  161. if(e_barangay is Pentor):
  162. B = 5020428
  163. if(e_barangay is Pinulot):
  164. B = 5020429
  165. if(e_barangay is Pita):
  166. B = 5020430
  167. if(e_barangay is Roosevelt):
  168. B = 5020432
  169. if(e_barangay is Saguing):
  170. B = 5020434
  171. if(e_barangay is San-Benito):
  172. B = 5020435
  173. if(e_barangay is San-Isidro):
  174. B = 5020436
  175. if(e_barangay is San-Pablo):
  176. B = 5020437
  177. if(e_barangay is San-Ramon):
  178. B = 5020438
  179. if(e_barangay is San-Simon):
  180. B = 5020439
  181. if(e_barangay is Santa-Isabel):
  182. B = 5020440
  183. if(e_barangay is Santo-Nino):
  184. B = 5020441
  185. if(e_barangay is Sapang-Balas):
  186. B = 5020442
  187. if(e_barangay is Tubo-tubo):
  188. B = 5020444
  189. if(e_barangay is Tucop):
  190. B = 5020445
  191. if(e_municipality is Hermosa):
  192. if(e_barangay is Almacen):
  193. B = 5020502
  194. if(e_barangay is Bacong):
  195. B = 5020503
  196. if(e_barangay is Balsic):
  197. B = 5020504
  198. if(e_barangay is Bamban):
  199. B = 5020505
  200. if(e_barangay is Culis):
  201. B = 5020507
  202. if(e_barangay is Judge-Roman-Cruz-Sr):
  203. B = 5020509
  204. if(e_barangay is Mabiga):
  205. B = 5020510
  206. if(e_barangay is Mabuco):
  207. B = 5020511
  208. if(e_barangay is Maite):
  209. B = 5020512
  210. if(e_barangay is Mambog-mandama):
  211. B = 5020513
  212. if(e_barangay is Palihan):
  213. B = 5020514
  214. if(e_barangay is Pandatung):
  215. B = 5020515
  216. if(e_barangay is Pulo):
  217. B = 5020516
  218. if(e_barangay is Saba):
  219. B = 5020517
  220. if(e_barangay is Sacrifice-Valley):
  221. B = 5020518
  222. if(e_barangay is Sumalo):
  223. B = 5020521
  224. if(e_barangay is Tipo):
  225. B = 5020522
  226. if(e_municipality is Limay):
  227. if(e_barangay is Alangan):
  228. B = 5020601
  229. if(e_barangay is Duale):
  230. B = 5020602
  231. if(e_barangay is Kintang-I):
  232. B = 5020603
  233. if(e_barangay is Kintang-II-Luz):
  234. B = 5020604
  235. if(e_barangay is Lamao):
  236. B = 5020605
  237. if(e_barangay is Landing):
  238. B = 5020606
  239. if(e_barangay is Poblacion):
  240. B = 5020607
  241. if(e_barangay is Reformista):
  242. B = 5020608
  243. if(e_barangay is San-Francisco-de-Asis):
  244. B = 5020609
  245. if(e_barangay is St.Francis-II):
  246. B = 5020610
  247. if(e_barangay is Townsite):
  248. B = 5020611
  249. if(e_barangay is Wawa):
  250. B = 5020612
  251. if(e_municipality is Mariveles):
  252. if(e_barangay is Alas-asin):
  253. B = 5020701
  254. if(e_barangay is Alion):
  255. B = 5020702
  256. if(e_barangay is Balon-anito):
  257. B = 5020703
  258. if(e_barangay is Baseco-Country):
  259. B = 5020704
  260. if(e_barangay is Batangas-II):
  261. B = 5020705
  262. if(e_barangay is Biaan):
  263. B = 5020706
  264. if(e_barangay is Cabcaben):
  265. B = 5020707
  266. if(e_barangay is Camaya):
  267. B = 5020708
  268. if(e_barangay is Ipag):
  269. B = 5020709
  270. if(e_barangay is Lucanin):
  271. B = 5020710
  272. if(e_barangay is Malaya):
  273. B = 5020711
  274. if(e_barangay is Maligaya):
  275. B = 5020712
  276. if(e_barangay is Mt.View):
  277. B = 5020713
  278. if(e_barangay is Poblacion):
  279. B = 5020714
  280. if(e_barangay is San-Carlos):
  281. B = 5020715
  282. if(e_barangay is San-Isidro):
  283. B = 5020716
  284. if(e_barangay is Sisiman):
  285. B = 5020717
  286. if(e_barangay is Townsite):
  287. B = 5020718
  288. if(e_municipality is Morong):
  289. if(e_barangay is Binaritan):
  290. B = 5020801
  291. if(e_barangay is Mabayo):
  292. B = 5020802
  293. if(e_barangay is Nagbalayong):
  294. B = 5020803
  295. if(e_barangay is Poblacion):
  296. B = 5020804
  297. if(e_barangay is Sabang):
  298. B = 5020805
  299. if(e_municipality is Orani):
  300. if(e_barangay is Apollo):
  301. B = 5020901
  302. if(e_barangay is Dona):
  303. B = 5020908
  304. if(e_barangay is Kabalutan):
  305. B = 5020909
  306. if(e_barangay is Kaparangan):
  307. B = 5020910
  308. if(e_barangay is Maria-Fe):
  309. B = 5020911
  310. if(e_barangay is Masantol):
  311. B = 5020912
  312. if(e_barangay is Mulawin):
  313. B = 5020913
  314. if(e_barangay is Pag-asa):
  315. B = 5020914
  316. if(e_barangay is Puksuan):
  317. B = 5020920
  318. if(e_barangay is Sibul):
  319. B = 5020921
  320. if(e_barangay is Silahis):
  321. B = 5020922
  322. if(e_barangay is Tagumpay):
  323. B = 5020923
  324. if(e_barangay is Tala):
  325. B = 5020924
  326. if(e_barangay is Talimundok):
  327. B = 5020925
  328. if(e_barangay is Tapulao):
  329. B = 5020926
  330. if(e_barangay is Tugatog):
  331. B = 5020928
  332. if(e_municipality is Orion):
  333. if(e_barangay is Bantan):
  334. B = 5021005
  335. if(e_barangay is Bilolo):
  336. B = 5021006
  337. if(e_barangay is Calungusan):
  338. B = 5021007
  339. if(e_barangay is Camachile):
  340. B = 5021008
  341. if(e_barangay is Daang-Pare):
  342. B = 5021011
  343. if(e_barangay is General-Lim):
  344. B = 5021012
  345. if(e_barangay is Kapunitan):
  346. B = 5021013
  347. if(e_barangay is Puting-Buhangin):
  348. B = 5021016
  349. if(e_barangay is Sabatan):
  350. B = 5021017
  351. if(e_barangay is Santa-Elena):
  352. B = 5021019
  353. if(e_barangay is Santo-Domingo):
  354. B = 5021020
  355. if(e_municipality is Pilar):
  356. if(e_barangay is Ala-uli):
  357. B = 5021101
  358. if(e_barangay is Bagumbayan):
  359. B = 5021102
  360. if(e_barangay is Balut-I):
  361. B = 5021103
  362. if(e_barangay is Balut-II):
  363. B = 5021104
  364. if(e_barangay is Bantan-Munti):
  365. B = 5021105
  366. if(e_barangay is Burgos):
  367. B = 5021106
  368. if(e_barangay is Diwa):
  369. B = 5021108
  370. if(e_barangay is Landing):
  371. B = 5021109
  372. if(e_barangay is Liang):
  373. B = 5021110
  374. if(e_barangay is Nagwaling):
  375. B = 5021111
  376. if(e_barangay is Panilao):
  377. B = 5021112
  378. if(e_barangay is Pantingan):
  379. B = 5021113
  380. if(e_barangay is Poblacion):
  381. B = 5021114
  382. if(e_barangay is Sta.Rosa):
  383. B = 5021116
  384. if(e_barangay is Wakas-North):
  385. B = 5021117
  386. if(e_barangay is Wakas-South):
  387. B = 5021118
  388. if(e_barangay is Wawa):
  389. B = 5021119
  390. if(e_municipality is Samal):
  391. if(e_barangay is Gugo):
  392. B = 5021203
  393. if(e_barangay is Imelda):
  394. B = 5021205
  395. if(e_barangay is Lalawigan):
  396. B = 5021206
  397. if(e_barangay is Palili):
  398. B = 5021207
  399. if(e_barangay is Santa-Lucia):
  400. B = 5021210
  401. if(e_barangay is Sapa):
  402. B = 5021211
  403. if(e_barangay is Tabing-Ilog):
  404. B = 5021212
  405. if(e_province is Bulacan):
  406. P = 3
  407. if(e_province is Nueva-Ecija):
  408. P = 4
  409. if(e_province is Pampanga):
  410. P = 5
  411. if(e_province is Tarlac):
  412. P = 6
  413. if(e_province is Zambales):
  414. P = 7
  415.  
  416. submit_sql()
  417.  
  418.  
  419.  
  420.  
  421. def submit_sql():
  422. global B
  423. global e_name
  424. global e_owner
  425. global e_region
  426. global e_province
  427. global e_municipality
  428. global e_barangay
  429.  
  430. conn = mc.connect(user="teambaboy", password="pigislove",
  431. host="localhost", database="teambaboy")
  432. cur = conn.cursor(buffered=True)
  433. sql = "SELECT * FROM farm_registration
  434. WHERE barangay = '%s'" % e_barangay;
  435. cur.execute(sql)
  436. results = cur.rowcount
  437. e_code = (B*100) + results
  438. cur.execute("INSERT INTO `farm_registration` (`farm_code`, `farm_name`, `farm_owner`, `region`, `province`, `municipality`, `barangay`) VALUES (%s, %s, %s, %s, %s, %s, %s)", (e_code, e_name, e_owner, e_region, e_province, e_municipality, e_barangay))
  439. print("boom")
  440. conn.close()
  441.  
  442.  
  443.  
  444. root = Tk()
  445. root.title("Farm Registration")
  446.  
  447. mainframe = Frame(root)
  448. mainframe.pack()
  449.  
  450. i_name = StringVar()
  451. i_owner = StringVar()
  452. i_region = StringVar()
  453. i_province = StringVar()
  454. i_municipality = StringVar()
  455. i_barangay = StringVar()
  456.  
  457. nameEntry = Entry(mainframe, width=7, textvariable=i_name)
  458. ownerEntry = Entry(mainframe, width=7, textvariable=i_owner)
  459. regionEntry = Entry(mainframe, width=7, textvariable=i_region)
  460. provinceEntry = Entry(mainframe, width=7, textvariable=i_province)
  461. municipalityEntry = Entry(mainframe, width=7,
  462. textvariable=i_municipality)
  463. barangayEntry = Entry(mainframe, width=7, textvariable=i_barangay)
  464.  
  465. nameEntry.grid(row=1, column=1)
  466. ownerEntry.grid(row=2, column=1)
  467. regionEntry.grid(row=3, column=1)
  468. provinceEntry.grid(row=4, column=1)
  469. municipalityEntry.grid(row=5, column=1)
  470. barangayEntry.grid(row=6, column=1)
  471.  
  472. Label(mainframe, text='Farm Name').grid(row=1, column=0)
  473. Label(mainframe, text='Farm Owner').grid(row=2, column=0)
  474. Label(mainframe, text='Region').grid(row=3, column=0)
  475. Label(mainframe, text='Province').grid(row=4, column=0)
  476. Label(mainframe, text='Municipality').grid(row=5, column=0)
  477. Label(mainframe, text='Barangay').grid(row=6, column=0)
  478.  
  479. Button(mainframe, text="Submit", command=put).grid(row=8, column=1)
  480.  
  481.  
  482. root.mainloop()
Add Comment
Please, Sign In to add comment
Public Pastes
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!