function fatch_SMS_from_sms_table($from, $limit)
{
$sql = "select name,phone_no,message from tblsms limit {$from},{$limit}";
//echo $sql; exit;
$rs = execSelect($sql);
return $rs;
}
function office_n_forsub_wise_list($office, $subdiv)
{
$sql = "Select Distinct personnela.personcd,\r\n\t personnela.officer_name,\r\n\t personnela.off_desg as designation,\r\n\t poststat.poststatus\r\n\tFrom office\r\n\t Inner Join personnela On office.officecd = personnela.officecd\r\n\t Inner Join poststat On personnela.poststat = poststat.post_stat\r\n\tWhere personnela.personcd<>''";
$sql .= " and personnela.officecd='{$office}' and personnela.forsubdivision='{$subdiv}' and personnela.selected='1'";
$sql .= " Order By personnela.personcd,\r\n\t poststat.poststatus,\r\n\t personnela.off_desg";
$rs = execSelect($sql);
return $rs;
}
function second_appointment_letter_reserve3_print($personcd)
{
$sql = "SELECT `slno`,`groupid`,`assembly`,`pcname`,`personcd`,`person_name`,`person_designation`,`post_status`,\t\r\n\t`post_stat`,`officecd`,`office_name`,`office_address`,`post_office`,`subdivision`,`police_stn`,`district`,\r\n\t`pincode`,`dc_venue`,`dc_address`,date_format(`dc_date`,'%d/%m/%Y') as dc_date,`dc_time`,`rc_venue`,`traingcode`,`training_venue`,`venuecode`,\r\n\t`venue_addr1`,`venue_addr2`,date_format(`training_date`,'%d/%m/%Y') as training_date,`training_time`,date_format(`polldate`,'%d/%m/%Y') as polldate,`polltime` \r\n\tFROM `second_rand_table_reserve`";
$sql .= " where personcd ='{$personcd}'";
//echo $sql; exit;
$rs = execSelect($sql);
connection_close();
return $rs;
}
function second_appointment_letter3($group_id, $forassembly)
{
$sql = "Select personnela.groupid,\r\n\t assembly.assemblycd,\r\n\t assembly.assemblyname,\r\n\t pc.pccd,\r\n\t pc.pcname,\r\n\t personnela.officer_name,\r\n\t personnela.personcd,\r\n\t office.office,\r\n\t office.address1,\r\n\t office.address2,\r\n\t office.postoffice,\r\n\t subdivision.subdivision,\r\n\t district.district,\r\n\t office.officecd,\r\n\t personnela.poststat,\r\n\t personnela.off_desg,\r\n\t poststat.poststatus\r\n\tFrom personnela\r\n\t Inner Join office On personnela.officecd = office.officecd\r\n\t Inner Join subdivision On subdivision.subdivisioncd = office.subdivisioncd\r\n\t Inner Join district On office.districtcd = district.districtcd\r\n\t Left Join pc On personnela.forpc = pc.pccd And personnela.forsubdivision =\r\n\t\tpc.subdivisioncd\r\n\t Left Join assembly On personnela.forassembly = assembly.assemblycd\r\n\t Inner Join poststat On personnela.poststat = poststat.post_stat ";
$sql .= " where personnela.groupid='{$group_id}' and personnela.forassembly='{$forassembly}' and personnela.booked='P'";
$sql .= " order by personnela.groupid, personnela.poststat";
// print $sql; exit;
$rs = execSelect($sql);
connection_close();
return $rs;
}
function form12A_report($personcd, $type)
{
$sql = "";
$rs = null;
$sql = "Select DISTINCT pc.pccd,\r\n\t pc.pcname,\r\n\t po_ed.pccd As pccd1,\r\n\t pc1.pcname As pcname1,\r\n\t personnela.slno,\r\n\t personnela.partno,\r\n\t personnela.acno,\r\n\t assembly.assemblyname,\r\n\t personnela.present_addr1,\r\n\t personnela.present_addr2,\r\n\t personnela.personcd,\r\n\t personnela.officer_name,\r\n\t pollingstation.psno,\r\n\t pollingstation.psname\r\n\tFrom personnela\r\n\t Left Join assembly On personnela.acno = assembly.assemblycd\r\n\t Left Join pc On assembly.pccd = pc.pccd and assembly.subdivisioncd = pc.subdivisioncd\r\n\t Inner Join po_ed On personnela.personcd = po_ed.personcd\r\n\t Inner Join pc pc1 On po_ed.pccd = pc1.pccd\r\n\t Inner Join pollingstation On personnela.groupid = pollingstation.groupid";
$sql .= " where personnela.personcd='{$personcd}' and po_ed.ed_pb='{$type}'";
//echo $sql; exit;
$rs = execSelect($sql);
return $rs;
}
public static function obtieneProducto($con, $codProd)
{
if ($codProd != null || $codProd != "") {
$values = ["*" => ""];
$conditions = ["cod" => "{$codProd}"];
$sql = createSelect("producto", $values, $conditions);
$resultado = execSelect($con, $sql, $conditions);
$productos = array();
$producto = null;
if (isset($resultado)) {
$row = $resultado->fetch();
$producto = new Producto($row);
}
return $producto;
}
}
function fatch_PersonaldtlForInterSwap($subdivision, $pc, $posting_status)
{
$sql = "Select personnela.personcd,\r\n\t personnela.forsubdivision,\r\n\t personnela.forpc\r\n\tFrom personnela \r\n\t where (personnela.booked is null or personnela.booked='')";
if ($subdivision != '' && $subdivision != '0') {
$sql .= " and personnela.forsubdivision= '{$subdivision}'";
}
if ($pc != '' && $pc != '0') {
$sql .= " and personnela.forpc='{$pc}'";
}
if ($posting_status != '' && $posting_status != '0') {
$sql .= " and personnela.poststat ='{$posting_status}'";
}
$sql .= " order by rand()";
// echo $sql; exit;
$rs = execSelect($sql);
// connection_close();
return $rs;
}
require_once '../inc/db_trans.inc.php';
$sql = "Select personnel.officer_name As officer_name,\r\n\t personnel.off_desg As designation,\r\n\t personnel.personcd As personcd,\r\n\t Date_Format(personnel.dateofbirth, _latin1'%d/%m/%Y') As dateofbirth,\r\n\t personnel.gender As gender,\r\n\t personnel.scale As scale,\r\n\t personnel.basic_pay As basic_pay,\r\n\t personnel.grade_pay As grade_pay,\r\n\t qualification.qualification As qualification,\r\n\t personnel.email As email,\r\n\t personnel.resi_no As resi_no,\r\n\t personnel.mob_no As mob_no,\r\n\t language.language As language,\r\n\t personnel.present_addr1 As present_addr1,\r\n\t personnel.present_addr2 As present_addr2,\r\n\t personnel.perm_addr1 As perm_addr1,\r\n\t personnel.perm_addr2 As perm_addr2,\r\n\t personnel.acno As acno,\r\n\t personnel.epic As epic, \r\n\t personnel.partno As partno,\r\n\t personnel.slno As slno,\r\n\t poststat.poststatus As poststatus,\r\n\t personnel.bank_acc_no As bank_acc_no,\r\n\t personnel.assembly_temp As assembly_temp,\r\n\t personnel.assembly_perm As assembly_perm,\r\n\t personnel.assembly_off As assembly_off,\r\n\t personnel.bank_cd As bank_cd,\r\n\t bank.bank_name As bank_name,\r\n\t branch.ifsc_code As ifsc_code,\r\n\t branch.branch_name As branch_name,\r\n\t branch.address As address,\r\n\t personnel.remarks As remarks,\r\n\t personnel.officecd As officecd,\r\n\t office.office As office,\r\n\t office.address1 As address1,\r\n\t office.address2 As address2,\r\n\t office.postoffice As postoffice,\r\n\t district.district As district,\r\n\t office.pin As pin,\r\n\t personnel.usercode As usercode,\r\n\t personnel.posted_date As posted_date\r\n\tFrom ((((((personnel\r\n\t Left Join bank On bank.bank_cd = personnel.bank_cd)\r\n\t Join qualification On qualification.qualificationcd =\r\n\t\tpersonnel.qualificationcd)\r\n\t Join language On language.languagecd = personnel.languagecd)\r\n\t Join poststat On poststat.post_stat = personnel.poststat)\r\n\t Left Join branch On branch.branchcd = personnel.branchcd)\r\n\t Join office On personnel.officecd = office.officecd)\r\n\t Join district On office.districtcd = district.districtcd";
$sql .= " where personnel.personcd>0 ";
if ($frmdate != '' && $frmdate != null) {
$sql .= "and personnel.posted_date>='{$frmdate}' ";
}
if ($todate != '' && $todate != null) {
$sql .= "and personnel.posted_date<='{$todate}' ";
}
//if($user!='' && $user!=null)
// $sql.="and personnel.usercode='$user' ";
if ($officename != '' && $officename != null) {
$sql .= "and personnel.officecd='{$officename}' ";
}
$sql .= "order by personnel.officer_name ASC";
$rs = execSelect($sql);
$num_rows = rowCount($rs);
if ($num_rows > 0) {
echo "<hr width='100%' />\n";
for ($i = 1; $i <= $num_rows; $i++) {
$row = getRows($rs);
//<span> </span>
echo "<div width='100%'>\n";
echo $i . "<div style='padding-left:10px;'><span align='left'><b>Name, Designation (code) :</b></span><span align='left' ";
echo "style='margin-right: " . (350 - strlen($row[0] . ', ' . $row[1] . ', (' . $row[2] . ')') * 5) . "pt;'";
echo "> {$row['0']}, {$row['1']}, ({$row['2']})</span><span class='sp1'> </span><span align='left'><b>Date of Birth :</b></span><span align='left'> {$row['3']}</span><span class='sp1'> </span><span align='left'><b>Gender :</b></span><span align='left'> {$row['4']}</span></div>\n";
echo "<div style='padding-left:10px;'><span align='left'><b>Pay Scale :</b></span><span align='left' ";
echo "style='margin-right: " . (80 - strlen($row[5]) * 5) . "pt;'";
echo "> {$row['5']}</span><span class='sp1'> </span><span align='left'><b>Basic Pay :</b></span><span align='left' ";
echo "style='margin-right: " . (80 - strlen($row[6]) * 5) . "pt;'";
echo "> {$row['6']}</span><span class='sp1'> </span><span align='left' width='10%'><b>Grade Pay :</b></span><span align='left' ";
stm_aix("p1i9","p1i1",[0,"Work offline"]);
stm_aix("p1i10","p1i1",[0,"Close"]);
stm_ep();*/
stm_aix("p0i5","p0i0",[0,"Signout","","",-1,-1,0,"signout.php","_self"],80,25);
stm_ep();
stm_em();
</script>
<span class="form">Hi, <?php
print $_SESSION['user'];
?>
</span>
<?php
$user_cat = isset($_SESSION['user_cat']) ? $_SESSION['user_cat'] : '';
$sql_env = "select * from environment where dist_cd='{$dist_cd}'";
$rs_env = execSelect($sql_env);
if (rowCount($rs_env) > 0) {
$row_env = getRows($rs_env);
$environment = uppercase($row_env['environment']);
$_SESSION['environment'] = $environment;
$distnm_cap = $row_env['distnm_cap'];
$_SESSION['distnm_cap'] = $distnm_cap;
$apt1_orderno = $row_env['apt1_orderno'];
$_SESSION['apt1_orderno'] = $apt1_orderno;
$apt1_date = new DateTime($row_env['apt1_date']);
$_SESSION['apt1_date'] = $apt1_date->format('d/m/Y');
$apt2_orderno = $row_env['apt2_orderno'];
$_SESSION['apt2_orderno'] = $apt2_orderno;
$apt2_date = new DateTime($row_env['apt2_date']);
$_SESSION['apt2_date'] = $apt2_date->format('d/m/Y');
$signature = $row_env['signature'];
function fetch_polldate_n_time($forpc)
{
$sql = "select date_format(poll_date,'%d/%m/%Y') as poll_date,poll_date as poll_dateD, poll_time from poll_table where pc_cd='{$forpc}'";
$rs = execSelect($sql);
connection_close();
return $rs;
}
function validateUser($connection, $table, $user, $password)
{
$conditions = ["usuario" => $user, "password" => md5($password)];
$vals = array("*");
$sql = createSelect($table, $vals, $conditions);
echo $sql;
$validate = execSelect($connection, $sql, $conditions);
if ($validate->fetch()) {
return true;
} else {
return false;
}
}
function trainingvanue_details($venue_cd)
{
$sql = "Select training_venue.venue_cd, subdivision.subdivision,training_venue.subdivisioncd, training_venue.venuename, training_venue.venueaddress1, training_venue.venueaddress2,\r\n training_venue.maximumcapacity, training_venue.usercode, training_venue.posted_date\r\nFrom training_venue\r\n Inner Join subdivision On training_venue.subdivisioncd = subdivision.subdivisioncd where training_venue.venue_cd = {$venue_cd}";
$rs = execSelect($sql);
return $rs;
}
h7 {page-break-after:always;}
}
</style>
</head>
<body>
<?php
date_default_timezone_set('Asia/Calcutta');
include_once '../inc/db_trans.inc.php';
include_once '../function/appointment_fun2.php';
extract($_GET);
$group_id = $_GET['group_id'];
$forassembly = $_GET['assembly'];
$forpc = $_GET['pc'];
$per_cd = $_GET['per_cd'];
$sql_m = "select count(*) as cnt_m from personnela where forassembly='{$forassembly}' and forpc='{$forpc}' and groupid='{$group_id}' and booked='P'";
$rs_m = execSelect($sql_m);
$row_m = getRows($rs_m);
$mem_no = $row_m['cnt_m'];
$rec_set_hdr = second_app_hrd3($forassembly, $forpc, $group_id);
if (rowCount($rec_set_hdr) > 0) {
for ($n = 0; $n < rowCount($rec_set_hdr); $n++) {
$rec_arr_hdr = getRows($rec_set_hdr);
$grp_id = $rec_arr_hdr['groupid'];
$for_ass = $rec_arr_hdr['assemblycd'] . "-" . $rec_arr_hdr['assemblyname'];
$for_pc = $rec_arr_hdr['pccd'] . "-" . $rec_arr_hdr['pcname'];
//$polling_station=$rec_arr_hdr['psno'].", ".$rec_arr_hdr['psname'];
$dc = $rec_arr_hdr['dc_venue'] != '' ? $rec_arr_hdr['dc_venue'] . ", " . $rec_arr_hdr['dc_addr'] : "___________________________________";
$dc_date = $rec_arr_hdr['dc_date'] != '' ? $rec_arr_hdr['dc_date'] : "___________";
$dc_time = $rec_arr_hdr['dc_time'] != '' ? $rec_arr_hdr['dc_time'] : "___________";
$rcvenue = $rec_arr_hdr['rcvenue'] != '' ? $rec_arr_hdr['rcvenue'] : "_______________________________";
$poll_date = $rec_arr_hdr['poll_date'] != '' ? $rec_arr_hdr['poll_date'] : "___________";
function get_person_ag_office($office, $forpc)
{
$sql = "Select Distinct personnela.personcd,\r\n\t personnela.officer_name,\r\n\t personnela.off_desg,\r\n\t personnela.assembly_off,\r\n\t personnela.assembly_perm,\r\n\t personnela.assembly_temp,\r\n\t personnela.epic,\r\n\t personnela.acno,\r\n\t personnela.partno,\r\n\t personnela.slno,\r\n\t personnela.poststat\r\n\tFrom personnela";
$sql .= " where personnela.officecd='{$office}' and personnela.forpc='{$forpc}'";
$rs = execSelect($sql);
connection_close();
return $rs;
}
function fatch_UserDtl($user_cd)
{
$sql = "Select user.code, user.user_id, user.category, user.creation_date, user.districtcd, user.subdivisioncd, user.parliamentcd\r\n\tFrom user where user.code='{$user_cd}'";
$rs = execSelect($sql);
connection_close();
return $rs;
}
function dcrc_del_check($dcrc)
{
$sql = "Select count(*) as cnt From pollingstation where dcrccd='{$dcrc}'";
$rs = execSelect($sql);
$row = getRows($rs);
$cnt = $row['cnt'];
connection_close();
return $cnt;
}
function Termination_details($termination_id)
{
$sql = "Select termination.termination_id, termination.personal_id, personnel.officer_name, termination.termination_cause,\r\n Date_Format(termination.termination_date, '%Y-%m-%d') As termination_date,\r\n termination.users_id,\r\n termination.remarks,\r\n termination.posted_date,personnel.personcd, personnel.usercode, personnel.officer_name, office.office, personnel.off_desg, personnel.scale,\r\n personnel.basic_pay, personnel.grade_pay, \r\n personnel.mob_no,personnel.present_addr1,personnel.present_addr2,\r\n (Select assemblyname from assembly asmb where asmb.assemblycd = personnel.assembly_temp) As assembly_temp,\r\n (Select assemblyname from assembly asmb where asmb.assemblycd = personnel.assembly_off) As assembly_off,\r\n (Select assemblyname from assembly asmb where asmb.assemblycd = personnel.assembly_perm) As assembly_perm\r\nFrom personnel \r\n Inner Join termination On personnel.personcd = termination.personal_id \r\n INNER JOIN office ON personnel.officecd = office.officecd ";
$sql .= " where termination.termination_id='{$termination_id}'";
$rs = execSelect($sql);
connection_close();
return $rs;
}
<script src="js/FormValidation.js"></script>
<?php
//include("header/header.php");
$action = $_REQUEST['action'];
$user = $_REQUEST['user'];
$old_pass = $_REQUEST['old_pass'];
$new_pass = $_REQUEST['new_pass'];
$re_new_pass = $_REQUEST['re_new_pass'];
if ($action == 'Submit') {
$sql = "select count(*) as cnt from contact_master where user_id='{$user_id}' and user_pwd='{$old_pass}' ";
//echo "$sql<br>";
$result = execSelect($sql);
$row = getRows($result);
$cnt = $row['cnt'];
if ($cnt > 0) {
if ($new_pass == $re_new_pass) {
$sql_up = "update contact_master set ";
$sql_up .= " user_pwd='{$new_pass}'";
$sql_up .= " where user_id='{$user_id}'";
//echo"$sql_up<br>";
execUpdate($sql_up);
$msg = "Password changed successfully";
} else {
$msg = "Wrong New Password & Re-Enter Password ....";
}
} else {
if ($cnt <= 0) {
$msg = "User Not Exists/Old Password is wrong ";
}
}
}
