| Server IP : 192.124.249.33 / Your IP : 66.248.200.33 Web Server : Apache System : Linux 141.134.66.148.host.secureserver.net 3.10.0-1160.119.1.el7.tuxcare.els6.x86_64 #1 SMP Fri Sep 13 13:42:20 UTC 2024 x86_64 User : tarangglobal ( 1001) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/tarangglobal/public_html/cyber/admin/ |
Upload File : |
<?php
require_once('pdoconfig.php');
$off_id=$_SESSION['poster_id'];
$contid=$_REQUEST['contid'];
//echo $rsrv;
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="description" content="Materia - Admin Template">
<meta name="keywords" content="materia, webapp, admin, dashboard, template, ui">
<meta name="author" content="solutionportal">
<!-- <base href="/"> -->
<title>Reserve Price Vetting</title>
<link rel="stylesheet" href="fonts/ionicons/css/ionicons.min.css">
<link rel="stylesheet" href="fonts/font-awesome/css/font-awesome.min.css">
<!-- Plugins -->
<link rel="stylesheet" href="styles/plugins/c3.css">
<link rel="stylesheet" href="styles/plugins/waves.css">
<link rel="stylesheet" href="styles/plugins/perfect-scrollbar.css">
<!-- Css/Less Stylesheets -->
<link rel="stylesheet" href="styles/bootstrap.min.css">
<link rel="stylesheet" href="styles/main.min.css">
<link href='http://fonts.googleapis.com/css?family=Roboto:400,500,700,300' rel='stylesheet' type='text/css'>
<!-- Match Media polyfill for IE9 -->
<!--[if IE 9]> <script src="scripts/ie/matchMedia.js"></script> <![endif]-->
<style>
.form-control {
border:1px solid#ddd;
}
.table-1 td{
padding:5px;
border:1px solid#ddd;
}
.active{
background-color: rgb(58, 57, 57) !important;
}
</style>
</head>
<body id="app" class="app off-canvas">
<!-- #Start header -->
<?php include('_header.php');?>
<!-- #end header -->
<!-- main-container -->
<div class="main-container clearfix">
<!-- main-navigation -->
<?php include('_left-menu.php');?>
<!-- #end main-navigation -->
<!-- content-here -->
<div class="content-container" id="content">
<!-- dashboard page -->
<div class="page page-dashboard">
<div class="page-wrap">
<div class="row">
<!-- dashboard header -->
<div class="col-md-12">
<div class="dash-head clearfix mt30 mb20">
<div class="left">
<h4 class="mb5 text-light" style="font-weight:bold;">Reserve Price Vetting</h4>
</div>
<div class="right mt10">
</div>
</div>
</div>
</div> <!-- #end row -->
<!-- #end row -->
<div class="row">
<div class="col-md-12">
<div style="width:100%;float:left;margin-top:20px;padding:15px;background-color:#fff;">
<h4 class="mb5 text-light" style="font-weight:bold;margin:0px;width:auto;float:left;display:None;">List of Officers</h4>
<table style="width:100%;float:left;" class="table-1">
<tr style="background:#f2f2f2;">
<td style="width:50px;">#</td>
<td>Officers id</td>
<td>Reg. No.</td>
<td>Contract Type</td>
<td>Contract Sub Type</td>
<td>Proposed Reserve Price</td>
<td>Vetted Reserve Price</td>
<td>Tender/ Quotation No.</td>
<td>Tender/ Quotation Date</td>
<td>Tender/ Quotation Open Date</td>
<td>Tender/ Quotation Last Date</td>
</tr>
<?php
$sql="select * from(
select temp2.*,t2.contTyp_desc sect_name from (
select temp.*,contract_type.contTyp_desc from(
SELECT * FROM contract_master WHERE off_id=$off_id and cont_id=$contid)temp
left join contract_type
on temp.contTyp_id=contract_type.contTyp_id)temp2
left join contract_type t2
on temp2.contSubTyp_id=t2.contTyp_id)temp3
left join officer_master
on temp3.off_id=officer_master.off_id";
//echo $sql;
$i=1;
$res= $action->select($sql);
foreach ($res as $id=>$row){
$a=$row['active'];
?>
<tr>
<td><?=$i++;?></td>
<td><?=$row['off_name'];?></td>
<td><?=$row['reg_no'];?></td>
<td><?=$row['contTyp_desc'];?></td>
<td><?=$row['sect_name'];?></td>
<td><?=$row['reserve_price'];?></td>
<td><?=$row['reserve_price_vetted'];?></td>
<td><?=$row['tender_no'];?></td>
<td><?=date('d/m/y',strtotime($row['tender_date']));?></td>
<td><?=date('d/m/y',strtotime($row['tender_last_date']));?></td>
<td><?=date('d/m/y',strtotime($row['tender_open_date']));?></td>
</tr>
<?php } ?>
</table>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div style="width:100%;float:left;margin-top:20px;padding:15px;background-color:#fff;">
<div class="col-md-6" style="margin: auto; float: none;">
<form action="contract_price_asign_save.php" enctype="multipart/form-data" method="post" name="myForm" onsubmit="return validateForm()">
<input name="contid" type="hidden" value="<?=$contid;?>" />
<input name="act" type="hidden" value="<?=$act?>" />
<div style="width: 100%; float: left; background-color: #fff; padding: 15px;">
<div class="col-md-5">
<label style="margin-top:10px;">Officers List</label>
<div id="left_part">
<select multiple id="Select1" style="width: 100%; height: 150px">
<?php
$sql1="select * from officer_master where off_id!=$off_id and off_id not in (SELECT off_id FROM contract_resrvprice WHERE cont_id='$contid')";
$res=$action->select($sql1);
foreach ($res as $id=>$row){
$off_name=$row['off_name'];
?>
<option value="<?=$row['off_id'];?>"><?=$off_name;?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-1" style="padding-top:100px;">
<input id="Button1" name="Button1" value=">" type="button">
<input id="Button2" name="Button2" value="<" type="button">
</div>
<div class="col-md-6">
<label style="margin-top:10px;">Selected Officers</label>
<div id="right_part">
<select multiple id="Select2" name="select2[]" style="width: 100%; height: 150px">
</select>
</div>
</div>
<div class="col-md-12" style="text-align: center; margin-top: 20px;">
<button id="btn-add" class="btn btn-primary mr5 waves-effect" type="submit" value="add">
Save</button>
</div>
</div>
</form>
<table style="width:100%;float:left;" class="table-1">
<tr style="background:#f2f2f2;">
<td style="width:50px;">#</td>
<td>Officer Name</td>
<td>Alloted Date</td>
<td>Vetted On</td>
</tr>
<?php
$sql="SELECT * FROM contract_resrvprice, officer_master
where contract_resrvprice.off_id= officer_master.off_id and contract_resrvprice.cont_id=$contid ";
//echo $sql;
$i=1;
$res= $action->select($sql);
foreach ($res as $id=>$row)
{
$station=$row['station_id'];
$allot=$row['vett_allot_dt'];
$vetted_on=$row['vetted_on'];
$by=$row['off_name'];
$alot=date('d-m-Y', strtotime($allot));
if($vetted_on==''){ $vett_on=''; }else { $vett_on=date('d-m-Y', strtotime($vetted_on)); }
?>
<tr>
<td><?=$i++;?></td>
<td><?=$by;?></td>
<td><?=date('d/m/y',strtotime($alot));?></td>
<td><?=($vett_on)?date('d/m/y',strtotime($vett_on)):'';?></td>
</tr>
<?php } ?>
</table>
</div>
</div>
</div>
</div>
</div> <!-- #end page-wrap -->
</div>
<!-- #end dashboard page -->
</div>
</div>
<!-- theme settings -->
<div class="site-settings clearfix hidden-xs">
<div class="settings clearfix">
<div class="trigger ion ion-settings left"></div>
<div class="wrapper left">
<ul class="list-unstyled other-settings">
<li class="clearfix mb10">
<div class="left small">av Horizontal</div>
<div class="md-switch right">
<label>
<input type="checkbox" id="navHorizontal">
<span> </span>
</label>
</div>
</li>
<li class="clearfix mb10">
<div class="left small">Fixed Header</div>
<div class="md-switch right">
<label>
<input type="checkbox" id="fixedHeader">
<span> </span>
</label>
</div>
</li>
<li class="clearfix mb10">
<div class="left small">av Full</div>
<div class="md-switch right">
<label>
<input type="checkbox" id="navFull">
<span> </span>
</label>
</div>
</li>
</ul>
<hr/>
<ul class="themes list-unstyled" id="themeColor">
<li data-theme="theme-zero" class="active"></li>
<li data-theme="theme-one"></li>
<li data-theme="theme-two"></li>
<li data-theme="theme-three"></li>
<li data-theme="theme-four"></li>
<li data-theme="theme-five"></li>
<li data-theme="theme-six"></li>
<li data-theme="theme-seven"></li>
</ul>
</div>
</div>
</div>
<!-- #end theme settings -->
<!-- Dev only -->
<!-- Vendors -->
<script src="scripts/vendors.js"></script>
<script src="scripts/plugins/d3.min.js"></script>
<script src="scripts/plugins/c3.min.js"></script>
<script src="scripts/plugins/screenfull.js"></script>
<script src="scripts/plugins/perfect-scrollbar.min.js"></script>
<script src="scripts/plugins/waves.min.js"></script>
<script src="scripts/plugins/jquery.sparkline.min.js"></script>
<script src="scripts/plugins/jquery.easypiechart.min.js"></script>
<script src="scripts/plugins/bootstrap-rating.min.js"></script>
<script src="scripts/app.js"></script>
<script src="scripts/index.init.js"></script>
<script type="text/javascript">
jQuery(document).ready(function () {
//alert('reserve_select.php?rsrv_id=<?=$contid;?>&type=contract');
$.ajax({
type:'POST',
url:'reserve_select.php?rsrv_id=<?=$contid;?>&type=contract',
success:function(data)
{
$("#Select2").html(data);
}
});
});
jQuery(document).ready(function () {
jQuery("#Button1").click(function () {
jQuery("#Select1 option:selected").each(function () {
jQuery("#Select2 ").append(jQuery(this).clone());
jQuery(this).remove();
});
});
jQuery("#Button2").click(function () {
jQuery("#Select2 option:selected").each(function () {
jQuery("#Select1").append(jQuery(this).clone());
jQuery(this).remove();
});
});
});
function validateForm() {
$('#Select2 option').prop('selected', true);
}
</script>
</body>
</html>
Private