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 . ".";
