xmlhttp.open("GET","ajax-bulk-report.php?office="+str+"&forpc="+str1+"&opn=person",true); xmlhttp.send(); } } </script> </head> <?php date_default_timezone_set('Asia/Calcutta'); include_once '../inc/db_trans.inc.php'; include_once '../function/add_fun.php'; if (isset($_REQUEST['Subdivision']) && $_REQUEST['Subdivision'] != null) { $subdiv = $_REQUEST['Subdivision']; } else { $subdiv = "0"; } $subdivision = Subdivision_ag_subdivcd($subdiv); ?> <body> <div> <div align="center"><h3>Total Details</h3></div> <?php print $subdivision; ?> Subdivision <ul id="parent"> <?php $rsPC = fatch_pc($subdiv); $num_rows = rowCount($rsPC); if ($num_rows > 0) { for ($i = 1; $i <= $num_rows; $i++) { $rowPC = getRows($rsPC);
} else { $dist_cd = "0"; } if (isset($_SESSION['subdiv_cd'])) { $subdiv_cd = $_SESSION['subdiv_cd']; } else { $subdiv_cd = "0"; } if (isset($_SESSION['pc_cd'])) { $pc_cd = sprintf("%02d", $_SESSION['pc_cd']); } else { $pc_cd = "0"; } $district = uppercase(district_name($dist_cd)); $_SESSION['dist_name'] = $district; $subdiv_name = uppercase(Subdivision_ag_subdivcd($subdiv_cd)); $_SESSION['subdiv_name'] = $subdiv_name; $pc_name = uppercase(pc_name($pc_cd)); $_SESSION['pc_name'] = $pc_name; $user_cd = $_SESSION['user_cd']; $sql = "SELECT distinct menu.menu_cd, menu.menu, menu.link\r\n\t FROM user_permission LEFT OUTER JOIN\r\n menu ON user_permission.menu_cd = menu.menu_cd\r\n\t WHERE user_permission.user_cd='{$user_cd}'"; $rs = execSelect($sql); if (rowCount($rs) < 1) { echo ""; } else { $row_count = rowCount($rs); for ($i = 1; $i <= $row_count; $i++) { $row = getRows($rs); //if($i==2 || $i==3 || $i==4 || $i==5 || $i==6 || $i==7 || $i==8) continue; echo "stm_aix('p0i1','p0i0',[0,'{$row['1']}','','',-1,-1,0,'{$row['2']}','_self','','','','',0,0,0,'','',0,0,0,1,1,'#38557D',0,'#B0B0C1',0,'','',3,3,0,0,'#FFFFF7','#FFFFF7','#FFFFFF','#000000','bold 8pt Arial,Verdana','bold 8pt Arial,Verdana',0,0,'','','','',0,0,0],80,25);\n"; $sql_sub = "SELECT submenu.submenu_cd, submenu.submenu, submenu.link\r\n\t\t \t\t FROM user_permission LEFT OUTER JOIN\r\n \tsubmenu ON user_permission.submenu_cd = submenu.submenu_cd\r\n\t\t\t\t WHERE\tuser_permission.user_cd='{$user_cd}' and user_permission.menu_cd='{$row['0']}'";
<?php include_once 'function/add_fun.php'; include_once 'function/appointment_fun.php'; if (isset($_REQUEST['send']) && $_REQUEST['send'] != null) { $sub = $_REQUEST['send']; } else { $sub = ""; } if ($sub == "Save SMS") { $rec = 0; include_once 'inc/commit_con.php'; mysqli_autocommit($link, FALSE); $sql = "insert into tblsms (name,phone_no,message) values (?,?,?)"; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_bind_param($stmt, 'sss', $name, $mob_no, $Msg); $subdiv_name = Subdivision_ag_subdivcd($subdiv_cd); $rs_data = fetch_first_rand_tab_ag_subdiv($subdiv_name); if (rowCount($rs_data) > 0) { for ($i = 1; $i <= rowCount($rs_data); $i++) { $row_data = getRows($rs_data); $name = $row_data['officer_name']; $personcd = $row_data['personcd']; $mob_no = $row_data['mob_no']; $post_status = $row_data['poststatus']; $training_desc = $row_data['training_desc']; $venuename = $row_data['venuename']; $venueaddress = $row_data['venueaddress']; $training_dt = $row_data['training_dt']; $training_time = $row_data['training_time']; $DestinationAddress = $mob_no; $Message = $name . ", you are appointed as " . $post_status . " for LS-14 election. Your training venue: " . $venuename . ",date: " . $training_dt . ", time:" . $training_time . ".";