def create_right_menu(): weight0="" weight1="" weight2="" weight3="" weight="" rows=[] _rows=[] __rows=[] ___rows=[] rows = py_db.executeAndReturnRows("select * from tbl_template_right_menu where trm_weight=0 and trm_parent_id=0") for row in rows: weight0=weight0+"<ul>"+row[1] _rows = py_db.executeAndReturnRows("select * from tbl_template_right_menu where trm_weight=1 and trm_parent_id={0}".format(row[0])) weight1="" if len(_rows) > 1 : weight1="<ul>" for _row in _rows: weight1=weight1+"<li><a href='{0}'>".format(_row[5].__str__())+_row[1]+"</a>" __rows = py_db.executeAndReturnRows("select * from tbl_template_right_menu where trm_weight=2 and trm_parent_id={0}".format(_row[0])) weight2="" if len(__rows) > 1 : weight2="<ul>" for __row in __rows: weight2=weight2+"<li><a href='{0}'>".format(__row[5].__str__())+__row[1]+"</a>" ___rows = py_db.executeAndReturnRows("select * from tbl_template_right_menu where trm_weight=3 and trm_parent_id={0}".format(__row[0])) weight3="" if len(___rows) > 1 : weight3="<ul>" for ___row in ___rows: weight3=weight3+"<li><a href='{0}'>".format(___row[5].__str__())+___row[1]+"</a></li>" if len(___rows) >1: weight2=weight2+weight3+"</ul></li>" else : weight2=weight2+weight3+"</li>" if len(__rows) > 1 : weight1=weight1+weight2+"</ul></li>" else : weight1=weight1+weight2+"</li>" if len(_rows) > 1 : weight0=weight0+weight1+"</li></ul>" else : weight0=weight0+weight1+"</ul>" return weight0
def create_prn_ahdaf_tree(): ul = "" rows = py_db.executeAndReturnRows("select * from tbl_irib_olaviats order by io_id") #<ul class='ul_ahdaf_14' id='ul_14'> ul = "<ul class='tree'>" i1 = 0 i2 = 0 i3 = 0 for row in rows: i1=i1+1 i2 = 0 i3 = 0 ul = ul+"<li id='olaviat_{1}'><a href='#'> {2} - {0}</a>".format(row[1],row[0],i1) rows_rahbord = py_db.executeAndReturnRows("select * from tbl_irib_olaviats_mozoo where iom_link = '{0}' order by iom_id".format(row[0])) if len(rows_rahbord)>0: ul = ul+"<ul>" i2 = 0 i3 = 0 for row_r in rows_rahbord: i2=i2+1 ul = ul+"<li id='rahbord_{1}'><a href='#'> {2} - {3} - {0} </a>".format(row_r[1],row[0],i1,i2) rows_mehvar = py_db.executeAndReturnRows("select * from tbl_irib_olaviats_mozoo_mehvarz where iomm_link = '{0}' order by iomm_id".format(row_r[0])) if len(rows_mehvar)>0: ul = ul+"<ul>" i3=0 for row_m in rows_mehvar: i3=i3+1 ul = ul+"<li id='mehvar_{1}'> <a href='#'> {2} - {3} - {4} - {0}</a></li>".format(row_m[1],row[0],i1,i2,i3) if len(rows_mehvar)>0: ul = ul+"</ul></li>" if len(rows_rahbord)>0: ul = ul+"</ul></li>" else : ul = ul+"</ul></li>" ul = '<div class="span9 well mhrz cccf" id="div_mohvarz_tree">'+ul + "</ul></div>" print ul
def create_prn_chnl_tree(): ul = "" rows = py_db.executeAndReturnRows("select * from tbl_irib_channels order by ic_id") for row in rows: ul = ul + "<li id='chanel_{1}' ><a href='#'> {0}</a>".format(row[1],row[0]) _rows = py_db.executeAndReturnRows("select * from tbl_irib_channels_group where icg_link_to_channels = {0}".format(row[0])) if len(_rows)> 0 : ul = ul+"<ul>" for _row in _rows: ul = ul+"<li id='chgroups_{1}' ><a href='#'> {0}</a></li>".format(_row[2],_row[0]) if len(_rows)> 0 : ul = ul+"</ul></li>" ul = '<div class="span3 well chnls cccf" id="div_channels_tree"><ul>{0}</ul></div>'.format(ul) print ul
def create_edit_content(get_edit_content): rows = py_db.executeAndReturnRows("select * from tbl_irib_mehvarha where cim_id = {0}".format(get_edit_content)) rows_channels = py_db.executeAndReturnRows("select * from tbl_irib_channels order by ic_id ") rows_mehvarz = py_db.executeAndReturnRows("select * from tbl_irib_ahdaf order by c_id") #creating mehvarz dropdown select = "<select id='sel_ahdaf'>" cim_codes = rows[0][2] i=1 for r in rows_mehvarz: if r[0]==cim_codes: select = select + "<option value={0} selected>{2} - {1}</option>".format(r[0],r[1],i) else: select = select + "<option value={0}>{2} - {1}</option>".format(r[0],r[1],i) i+=1 select = select+"</select>" def create_select(value,_id): _select = """ <select id='sel_olv_{0}'> <option value=2>الویت اول</option> <option value=1>الویت دوم</option> <option value=0>بدوم الویت</option> </select> """.format(_id) _select = _select.replace("value="+value,"value="+value+" selected") return _select # begining check position with channels items= [] for rp in rows_channels: rows_position_fari = """ select count(*) from tbl_irib_mehvarha_content where imc_channels_link = {0} and imc_mehvar_link={1} and imc_type={2} """.format(rp[0],rows[0][0],1) rows_position_asli = """ select count(*) from tbl_irib_mehvarha_content where imc_channels_link = {0} and imc_mehvar_link={1} and imc_type={2} """.format(rp[0],rows[0][0],2) result_fari = py_db.executeAndReturnRows(rows_position_fari)[0][0].__str__() result_asli = py_db.executeAndReturnRows(rows_position_asli)[0][0].__str__() main_result = "0" if result_fari == "1" and result_asli=="0" : main_result = "1" if result_fari == "0" and result_asli=="1" : main_result = "2" items.append([rp[0],rp[1],rows[0][1],main_result]) div = "<div><textarea id='txt_mehvar'>{0}</textarea><input type='hidden' id='mehvar_code' value='{2}'><br>{1}<table><tbody>".format(rows[0][1],select,get_edit_content) for it in items: div = div+"<tr><td>{0}</td><td>{1}</td></tr>".format(it[1],create_select(it[3],it[0])) div = div+"</tbody></table></div><a href='#' onclick='post_edited_data()'>ثبت اطلاعات</a>-----<a href='#' onclick=''>لغو</a>" print div
def create_main_table_master_editing(): rows_channels = py_db.executeAndReturnRows("select * from tbl_irib_channels order by ic_id") channel_rows_count = len(rows_channels) channel_rows_count = channel_rows_count + 3 top_colspan = ['ردیف','کد هدف','عنوان محور','شبکه ها'] channels_col = [] for row in rows_channels: channels_col.append([row[0],row[1]]) #creating title columns header_cols = "<td rowspan=2>ردیف</td>" header_cols = header_cols+"<td rowspan=2>کد هدف</td>" header_cols = header_cols+"<td rowspan=2>عنوان محور</td>" header_cols = header_cols+"<td colspan = {0}>شبکه ها</td>".format(channel_rows_count - 3) header_cols = "<table id='tbl_main_grid'><tbody><tr class = 'col_header'>{0}</tr><tr class = 'col_header1'>".format(header_cols) #creating channels list title columns for i in channels_col: header_cols = header_cols+"<td>{0}</td>".format(i[1]) header_cols = header_cols+"</tr>" rows_mehvarha = py_db.executeAndReturnRows("select * from tbl_irib_mehvarha order by cim_id") sqlstr = "" for row in rows_channels: sqlstr = sqlstr+""" , CONCAT( CAST( (SELECT COUNT(*) FROM tbl_irib_mehvarha_content AS x2 WHERE x2.`imc_mehvar_link` = x1.cim_id AND x2.`imc_channels_link`= {0} AND x2.imc_type=1) AS CHAR(2) ) , CAST( (SELECT COUNT(*) FROM tbl_irib_mehvarha_content AS x2 WHERE x2.`imc_mehvar_link` = x1.cim_id AND x2.`imc_channels_link`= {0} AND x2.imc_type=2) AS CHAR(2) )) AS ch{0} """.format(row[0]) sql = " SELECT x1.* {0} FROM tbl_irib_mehvarha AS x1 order by cim_id".format(sqlstr) rows = py_db.executeAndReturnRows(sql) ii = 0 ct = "" for row in rows: ct = ct+"<tr>" ii = 0; for r in row: if ii==1: ct = ct+"<td class='tdXs'>{0}-- <a href='#' onclick='get_edit_content({1})'> ویرایش </a> -- <a href='#' onclick=''> نظر </a></td>".format(r,row[0]) else: p=r; if r=="00":p="--" if r=="01":p="اول" if r=="10":p="دوم" ct = ct+"<td>{0}</td>".format(p) ii = ii+1 ct = ct+"</tr>" header_cols = header_cols+ct+"</tbody></table>" print header_cols
def send_channel_groups_with_mehvarz(channelID,mehvar): rows = py_db.executeAndReturnRows("select * from tbl_irib_channels_group where icg_link_to_channels={0} order by icg_id desc".format(channelID)) str = '' for row in rows: _rows = py_db.executeAndReturnRows("select * from tbl_irib_ch_gr_meh where icgm_channel_link={0} and icgm_mehvar_link={1} and icgm_out='0'".format(row[0],mehvar)) if len(_rows)==0: str = str+"_{0}po{1}po{2}po{3}po{4}po{5}".format(row[0],row[2],'no','','','') else: #Code Group Shabake, Name Group Shabake , Code Mehvar Name Mehvar , Matne Mehvare Special , Percent str = str+"_{0}po{1}po{2}po{3}po{4}po{5}".format(row[0], row[2], _rows[0][2], py_db.executeAndReturnRows("select iomm_name from tbl_irib_olaviats_mozoo_mehvarz where iomm_id={0}".format(_rows[0][2]))[0][0] , _rows[0][3], _rows[0][4].__str__()) print str
def get_items_field_name(objects_array): items = [] for obj in objects_array: # getting items properties field_name = py_db.executeAndReturnRows("select fi_field_name,fi_object_type from tbl_form_items where fi_id={0} ".format(obj[0])) items.append([field_name[0][0],obj[1],field_name[0][1]]) return items #it returns 0=field_name , 2=object_name , 1=field_type
def create_main_ul_master(): rows_mehvarha = py_db.executeAndReturnRows("select cim_id from tbl_irib_mehvarha order by cim_id") content = "" for row in rows_mehvarha: content=content+create_content_div(row[0]) print "<ul><li>"+content+"</li></ul>"
def get_child(parent_id,level=1): rows = py_db.executeAndReturnRows("select * from tbl_irib_book where ib_parent = {0}".format(parent_id)) if len(rows)>0: print "<ul>" for row in rows: print "<li id='li_{1}'>{0}</li>".format(row[1],row[0]) get_child(row[0],level+1) print "</ul>"
def add_old_mehvarz_to_new(_added_mehvar_id,_selected_code_id): py_db.executesql(""" insert into tbl_irib_olaviats_mozoo_mehvarz (`iomm_name`,`iomm_link`) values ('{0}','{1}')""".format( py_db.executeAndReturnRows("select _text from mehvarz where id="+_selected_code_id)[0][0], _added_mehvar_id )) print "ok"
def get_items_value_from_tbl(key_id,key_field_name,tbl_name,objects_array): items = [] objs = get_items_field_name(objects_array); for obj in objs: #getting stored value sql = "select {0} from {1} where {2} = {3}".format(obj[0],tbl_name,key_field_name,key_id) objsValue = py_db.executeAndReturnRows(sql)[0][0] items.append([objsValue,obj[0],obj[1],obj[2]]) return items
def print_company_details(company_id): rows = py_db.executeAndReturnRows("SELECT * FROM tbl_sell_customers WHERE c_id = {0}".format(company_id)) if len(rows) == 0: print "0" else : row = rows[0] str = "{0}^^{1}^^{2}^^{3}^^{4}^^{5}^^{6}^^{7}^^{8}^^{9}^^{10}^^{11}".format(row[0],row[1],row[2],row[3],row[4], row[5],row[6],row[7],row[8],row[9], row[10],row[11]) print str
def send_chlist(): rows = py_db.executeAndReturnRows("select * from tbl_irib_channels order by ic_id") i=0 res = "" for row in rows: i=i+1 if i==1: res=row[0].__str__()+"====="+row[1].__str__() else: res = res+"____"+row[0].__str__()+"====="+row[1].__str__() print res
def send_olaviats_mozoo_mehvar_list(id): rows = py_db.executeAndReturnRows("select * from tbl_irib_olaviats_mozoo_mehvarz where iomm_link={0} order by iomm_id".format(id)) i=0 res = "" for row in rows: i=i+1 if i==1: res=row[0].__str__()+"====="+row[1].__str__() else: res = res+"____"+row[0].__str__()+"====="+row[1].__str__() print res
def send_channel_lists(): rows = py_db.executeAndReturnRows("select * from tbl_irib_channels order by ic_id ") i=0 str = "" for row in rows: if i == 0: str = row[0].__str__()+"^^"+row[1].__str__() else : str = str+")))"+row[0].__str__()+"^^"+row[1].__str__() i=i+1 str = convert_items_to_checkboxes("channels",str) print str
def send_search_result(_search_text): rtxt = "select * from mehvarz where match (_text) against('{0}')".format(_search_text) rows =py_db.executeAndReturnRows(rtxt) str84 = "" for row in rows: str84 = str84+"{2} - {0}<a class='a_add_meh' onclick='add_meh({1})' >+</a><br>".format(row[1],row[2],row[0]) ss = str84 r_txt = "SELECT COUNT(_year) ,_year FROM `mehvarz` WHERE match (_text) against('{0}') GROUP BY _year".format(_search_text) rows =py_db.executeAndReturnRows(r_txt) str_srch = "" for row in rows: str_srch = str_srch + "<span id='scscscd'> سال {0} نتیجه {1} </span> - ".format(row[1],row[0]) str_srch = "<div id='div_srch'>{0}</div>".format(str_srch) #ss = ss.replace(_search_text,"<span class = 'sp_found'>{0}</span>".format(_search_text)) print ss+"____"+str_srch
def create_channel_with_checked (hadaf_id): rows_channels = py_db.executeAndReturnRows("select * from tbl_irib_channels order by ic_id") channels_col = [] for row in rows_channels: channels_col.append([row[0],row[1]]) sqlstr="" fr="" i=0 sqlstr = """ SELECT x1.*, CONCAT( CAST( (SELECT COUNT(*) FROM tbl_irib_mehvarha_content AS x2 WHERE x2.`imc_mehvar_link` = {2} AND x2.`imc_channels_link`= x1.`ic_id` AND x2.imc_type=1) AS CHAR(2) ) , CAST( (SELECT COUNT(*) FROM tbl_irib_mehvarha_content AS x2 WHERE x2.`imc_mehvar_link` = {2} AND x2.`imc_channels_link`= x1.`ic_id` AND x2.imc_type=2) AS CHAR(2) )) AS ch1 FROM `tbl_irib_channels` AS x1 """.format(row[0],fr,hadaf_id) rows = py_db.executeAndReturnRows(sqlstr) li = "" for row in rows: cc="" if row[2] == "01": cc="الویت اول" if row[2] == "10": cc="الویت دوم" if row[2] == "00": cc="---" li=li+""" <div class="div_ch"><span class="div_ch_name">{0}</span><span class="div_ch_value">{1}</span></div> """.format(row[1],cc) return ""+li+""
def do_update(request,keyfieldID): update_str = "" sql="select f_table_name,f_key_field from tbl_forms where f_id=(select fi_link_to_form_name from tbl_form_items where fi_id='{0}' limit 1)".format(request[0][0]) tt = py_db.executeAndReturnRows(sql) table_name = tt[0][0] ketfield_name = tt[0][1] for item in request: if update_str == "":update_str ="{0}='{1}'".format(item[2][15],item[1]) else: update_str +=",{0}='{1}'".format(item[2][15],item[1]) sql="update {0} set {1} where {2}".format(table_name,update_str,ketfield_name+"='{0}'".format(keyfieldID[0])) #print sql sql=sql.replace("'empty'",'(NULL)') py_db.executesql(sql)
def do_insert(request): insert_str = "" before_value = "" after_value = "" sql="select f_table_name from tbl_forms where f_id=(select fi_link_to_form_name from tbl_form_items where fi_id='{0}' limit 1)".format(request[0][0]) table_name = py_db.executeAndReturnRows(sql)[0][0] #print request for item in request: #print item.__str__()+"<br>" #['1', '1', (1L, u'\u0646\u0627\u0645', 1, None, None, None, 1, 0, None, None, 1L, 1L, None, None, None, u'soccc_name')] if before_value == "":before_value ="{0}".format(item[2][15]) else: before_value +=",{0}".format(item[2][15]) if after_value == "":after_value ="'{0}'".format(item[1]) else: after_value +=",'{0}'".format(item[1]) sql="insert into {0} ({1}) values ({2})".format(table_name,before_value,after_value) py_db.executesql(sql) return sql
def get_lookup(title,tablename,display_field_name,return_value,destination_object): sql = "select {0},{1} from {2} order by {0}".format(return_value,display_field_name,tablename) sql = sql.replace('"','') rows = py_db.executeAndReturnRows(sql) str = "" str = "<table><tbody><tr><td colspan=3>{0}</td></tr><tr><td colspan=3> جستجو </td></tr>".format(title) for row in rows: str = str+"""<tr><td>{0}</td><td>{1}</td><td><a href='#' onclick='send_to_obj("{0}","{2}");'>انتخاب</a></td></tr>""".format(row[0],row[1],destination_object) str = str+"</tbody></table>" html = """ """ print str
def create_content_div(mehvar_id): row = py_db.executeAndReturnRows("""select x1.`cim_id`,x1.`cim_name`,x1.`cim_codes`, (select c_name from tbl_irib_ahdaf where c_id = x1.cim_codes) as ahadaf_text from tbl_irib_mehvarha as x1 where x1.cim_id = """+mehvar_id.__str__()+" order by cim_id")[0] div = """ <ul class="ul_channel" id="ul_{4}"> <li class="li_right"> <table> <tbody> <tr><td class="td_onv">ردیف</td><td class="td_val1">{0}</td></tr> <tr><td class="td_onv">هدف</td><td class="td_val2">{1}</td></tr> <tr><td class="td_onv">محور</td><td class="td_val3">{2}</td></tr> <tr><td class="td_vir" colspan=2> <a href='#' onclick='get_edit_content({4})'> ویرایش </a> <a href='#' onclick=''> نظر </a> <span>آخرین ویرایش در تاریخ : 93/01/01 - تعداد نظرات : .... - تعداد ویرایش ها : .....</span> </td></tr> </tbody></table> </li> <li class="li_left"> <ul> {3}</ul> </li> </ul> """.format(row[0].__str__(), row[1].__str__(), row[2].__str__()+"- "+row[3].__str__(), create_channel_with_checked(mehvar_id), mehvar_id) return div
def generate_ul(): def is_key_ext_in_ar(array,key): for ar in array: if ar == key : return True return False def get_child(parent_id,level=1): rows = py_db.executeAndReturnRows("select * from tbl_irib_book where ib_parent = {0}".format(parent_id)) if len(rows)>0: print "<ul>" for row in rows: print "<li id='li_{1}'>{0}</li>".format(row[1],row[0]) get_child(row[0],level+1) print "</ul>" rows = py_db.executeAndReturnRows("select * from tbl_irib_book ORDER BY ib_parent") if len(rows)>0: print "<ul>" for row in rows: print "<li id='li_{1}'>{0}</li>".format(row[1],row[0]) get_child(row[0]) print "</ul>" return
def read_form_from_database_and_generate_html_with_objects_map(form_id): # in this line i get form name for making form tag f_english_form_name = py_db.executeAndReturnRows("select f_english_form_name from tbl_forms where f_id={0}".format(form_id))[0][0].__str__() # we get form items right now sql = """ select fi_id, fi_name, fi_object_type, fi_if_radio_group_name, fi_if_mask_maskstring, fi_if_3_4_5_link_value, fi_not_null, fi_check_value_between, fi_check_value_from_to, fi_if_4_link_tbl_name, fi_link_to_form_name, fi_order, fi_default_value, fi_length, fi_exp from tbl_form_items where fi_link_to_form_name = (select f_id from tbl_forms where f_id={0}) order by fi_order """.format(form_id) rows = py_db.executeAndReturnRows(sql) #this is link for sending data to server # i set function name for js post then i will write other nec code formhtml='' # generating vars script="" index=0 objs_mapping=[] # here we go making form items #============================================================== #============================================================== #============================================================== for row in rows: if row[2] <> 7 and row[2] <> 8 : index=index+1 #__________________________________________________________________________________ obj_map=[] obj_map.append(row[0]) obj_map.append("obj_"+index.__str__()) objs_mapping.append(obj_map) # Generating Simple Tags --------------------------------------------------------------------------------------- formhtml=formhtml+"<tr>" exp = "" # getting if default value has or not def_val = " " if row[12]!="-1": def_val = " value='{0}'".format(row[12]) #________________________________ if row[14] !=None:exp=row[14] # handling if simple textbox if row[2] == 1: if row[4]!=None: script+='$("#obj_{0}").mask("{1}");'.format(index,row[4]) formhtml += """<td class='td_lbls'>{1}</td><td><input type="text" name="obj_{0}" id="obj_{0}" {3}/></td><td>{2}</td>""".format(index,row[1],exp,def_val) # handling if simple textbox if row[2] == 6: script += '$("#obj_{0}").mask("{1}");'.format(index,"1399/99/99") formhtml += """<td class='td_lbls'>{1}</td><td><input type="text" name="obj_{0}" id="obj_{0}" {3}/> </td><td>{2}</td>""".format(index,row[1],exp,def_val) # handling if simple textbox if row[2] == 2: formhtml += """<td class='td_lbls'>{1}</td><td><input type="text" name="obj_{0}" id="obj_{0}" {3}/> </td><td>{2}</td>""".format(index,row[1],exp,def_val) #______________________________ if row[2]==3: def_val = "" if row[12]=="checked": def_val = ' checked="checked"' formhtml += """<td class='td_lbls'>{2}</td><td><input id="obj_{0}" name="obj_{0}" type="checkbox" {1} /> </td><td>{3}</td>""".format(index,def_val,row[1],exp) #______________________________ if row[2]==4: def_val = "" if row[12]=="checked": def_val = ' checked="checked"' if row[3]!=None: def_val += ' group="'+row[3]+'"' formhtml += """<td class='td_lbls'>{2}</td><td><input name="obj_{0}" id="obj_{0}" type="radio" {1} /> </td><td>{3}</td>""".format(index,def_val,row[1],exp) #______________________________ if row[2]==5: ssql = "select {0},{1} from {2} {3}".format( row[9].split(":::")[1], row[9].split(":::")[2], row[9].split(":::")[0], row[9].split(":::")[3]) ssql = ssql.replace("//1//",py_login.get_user_id()) ssql = ssql.replace("//2//",py_login.get_socc_id()) rowss = py_db.executeAndReturnRows(ssql) dd="" for r in rowss: dd+=' <option value="{0}">{1}</option>'.format(r[1],r[0]) formhtml +=""" <td>{2}</td><td> <select name="obj_{0}" id="obj_{0}"> {1} </select></td><td>{3}</td> """.format(index,dd,row[1],exp) formhtml=formhtml+"</tr>" #--------------------Scripts --------------------- if row[2]==2: #// checking if text is integer script+= ' $("#obj_{0}").ForceNumericOnly();'.format(index) if row[6]==1: #checking if it is empty or not pass #============================================================== #============================================================== #============================================================== #here i make form # i put hv as validation for hacking purposes formhtml = ' <a href="#" onclick="submit_frm_'+f_english_form_name+'()">Post</a> '+formhtml HV = ord_validation_mapping( py_db.encode(conv_array_to_str(objs_mapping))) #print HV script = ' <script type="text/javascript"> {0} </script>'.format(script) formhtml= create_form_html( HV,f_english_form_name,formhtml+script) htm = [] htm.append(formhtml) htm.append(objs_mapping) return htm
def print_current_company_details (): row = py_db.executeAndReturnRows("select * from tbl_sell_seller")[0] str = "{0}ddr{1}ddr{2}ddr{3}ddr{4}ddr{5}ddr{6}ddr{7}ddr{8}ddr{9}ddr{10}".format(row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],row[10]) print str
def get_form_name_from_form_id(formID): return py_db.executeAndReturnRows("select f_english_form_name from tbl_forms where f_id = {0} limit 1".format(formID))[0][0]
def get_key_field_name_from_form_id(formID): return py_db.executeAndReturnRows("select f_key_field from tbl_forms where f_id = {0} limit 1".format(formID))[0][0]
b=b.replace('ظ','ظ') b=b.replace('ق','ق') b=b.replace('ط','ط') b=b.replace('پ','پ') b=b.replace('د','د') print b return b #print ord("د") #print ord("د") rows = py_db.executeAndReturnRows("select * from mehvarz") cco = 0 for row in rows: r1 = prepare_farsi_alf(row[1]) py_db.executesql(""" update mehvarz set _text = '{0}' where id='{1}' """.format(r1,row[2])) cco += cco print cco print "succ"
['ch_nasim','شبکه نسیم']] asliii = "الویت های اول" FARII = "الویت های دوم" tbl = "" RadeefeShabake = 0; for ch in channels: RadeefeShabake=0 #retrieving * tbl = tbl+"<table class='tbl_irib' cellpadding='0' cellspacing='0' ><tbody><tr class='tr_ch'><td colspan='3'>{0}</td><tr>".format(ch[1]) for i in mehv: sql='select main_code,Onvan from sheet_anavin where {0}="*" and LinkToAhdaf ="{1}" order by main_code'.format(ch[0],i[0]) rows = py_db.executeAndReturnRows(sql) c=0 assli_zero = 0 if len(rows) != 0: tbl=tbl+"<tr class='tr_onvan'><td colspan='2'>{1}</td><td>{0}</td><tr>".format(i[2],i[1]) else: assli_zero = 1 for row in rows: RadeefeShabake=RadeefeShabake+1 if c==0: tbl=tbl+"<tr class='tr_onvan_asli'><td colspan='3'>{0}</td><tr>".format(asliii) tbl=tbl+"<tr class='tr_onvan'><td>ردیف</td><td>محور ها</td><td>کد</td><tr>".format(i[2],i[1]) c=c+1 tbl = tbl+"<tr><td>{2}</td><td>{1}</td><td>{0}</td></tr>".format(row[0],row[1],RadeefeShabake)
print 'Content-Type: text/html; charset=utf-8' print '' frm = "" tmpl = "" form = cgi.FieldStorage() formID = form.getvalue("id","-1") form_name = py_db.executeAndReturnRows("select f_english_form_name from tbl_forms where f_id = "+formID.__str__())[0][0] frm = render_page(form_name, "testtttt") tmpl = get_template_page() tmpl = tmpl.replace("##content", frm) #tmpl = tmpl.replace("##loginInfo", py_db.get_company_name_from_user_id(user_id)+" خوش آمدید") #tmpl = tmpl.replace("##UserInfo", py_login.get_username_from_user_id(user_id)) tmpl = tmpl.replace("##Menu", create_right_menu()) print tmpl
objs_array = unhashed.split("::") keyfieldID="" if fff_key!="-1": _OOO = fff_key.split("::") for __ord in _OOO: if __ord <> "" and __ord.isdigit(): _hashed+= chr(int(__ord)) _unhashed = py_db.decode(_hashed) keyfieldID = _unhashed.split("::") #getting form data from db #print objs_array hs=py_db.executeAndReturnRows("select * from tbl_form_items where fi_link_to_form_name = (select fi_link_to_form_name from tbl_form_items where fi_id={0}) order by fi_order".format(objs_array[1].split("##")[1])) # converting hashed mapping to array http_inputs = [] for ob in objs_array: if ob!="": ps=[] ps.append(ob.split("##")[0]) ps.append(ob.split("##")[1]) http_inputs.append(ps) items=[] # here we are going to make final array which contains mapped field and webform for row in hs: item=[] for i in http_inputs :