@@ -0,0 +1,2065 @@
+#!/usr/bin/python%0A#Created : Mon 08 Sep 2008 01:40:45 PM GMT%0A#Last Modified : Tue 28 Jul 2015 10:34:53 AM UTC%0A%0A#qpy:2%0A#qpy:console%0A%0Aimport site%0Aimport os%0Aimport sys%0Afrom time import strftime%0Aimport sqlite3%0A%0Acon01 = sqlite3.connect(%22/usb/phpmysql/lessonplan2010.db%22)%0Acur01 = con01.cursor()%0A%0Acon02 = sqlite3.connect(%22/usb/phpmysql/lessonplanbank.db%22)%0Acur02 = con02.cursor()%0A%0Atahunini = strftime(%22%25Y%22) %0Aselectid = raw_input(%22%5CnPlease enter LESSON PLAN BANK ID :%5Cn%22)%0Aintended_date = raw_input(%22Please enter LESSON PLAN DATE : (MMDD)%5Cn%22)%0Atarikh_sebenar = tahunini+intended_date%0A%0Acur01.execute(%22%22%22select%0A              tingkatan,theme,topic,lo1,lo2,%0A              content,activity1,activity2,assimilation,impact%0A              from lessonplanbank where bank_id=?%22%22%22,(selectid,) )%0Ahasilbankid = cur01.fetchall()%0Afor form,theme,topic,lo1,lo2,content,activity1,activity2,assimilation,impact in hasilbankid:%0A    cur01.execute(%22%22%22%0A              update lessonplan2013 set theme=?,topic=?, lo1 = ?, lo2 = ?,%0A              content = ?,activity1 = ?,activity2 = ?,assimilation =%0A              ?,impact = ? where date %0A                  =?%22%22%22,(theme,topic,lo1,lo2,content,activity1,activity2,assimilation,impact,tarikh_sebenar))%0Acon01.commit()%0A%0Aprint %22-%22 * 60%0Acur01.execute(%22%22%22%0A              select tingkatan,date,timestart,timeend,theme,topic,lo1,lo2,lo3,%0A              content,activity1,activity2,assimilation,%0A              impact,note from lessonplan2013%0A              where date = ?%0A             %22%22%22, (tarikh_sebenar,))%0Ahasilsepatutnya = cur01.fetchall()%0Afor form,date,timestart,timeend,theme,topic,lo1,lo2,lo3,content,activity1,activity2,assimilation,impact,note in hasilsepatutnya:%0A    print %0A    print %22-----%5B%25s -lessonplan id: %5D-----%22 %25 (form)%0A    print %22DATE : %25s     TIME : %25s - %25s%22 %25 (date,timestart,timeend)%0A    print %22THEME /TOPIC : %25s / %25s%22 %25 (theme,topic)%0A    print %22LO1 : %25s LO2 : %25s LO3 : %25s%22 %25 (lo1,lo2,lo3)%0A    print %22CONTENT : %25s  ACTIVITIES : %25s , %25s%22 %25 (content,activity1,activity2)%0A    print %22IMPACT : %25s NOTE : %25s%22 %25 (impact,note)%0A    print%0A%0A%0Aprint %22-%22 * 60%0A

Add pindah lesson plan tarikh