| 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');
$offid=$_SESSION['poster_id'];
$partyid=$_REQUEST['partyid'];
$contid=$_REQUEST['contid'];
$sql="SELECT * FROM contract_agreement WHERE cont_id=$contid and party_id=$partyid";
//echo $sql;
//die();
$res=$action->select($sql);
foreach($res as $a=>$b)
{
$agreeid=$b['agreement_id'];
$remarks=$b['remarks'];
$agtfromdt=date('d/m/Y',strtotime($b['agree_from_date']));
$agttodt=date('d/m/Y',strtotime($b['agree_to_date']));
$licensefee=$b['license_fee'];
}
$sql="select *,(SELECT contract_attendee.rate_for_cont FROM contract_attendee where contract_attendee.cont_id=temp6.cont_id and contract_attendee.party_id=temp6.party_id) quotation
,(SELECT GROUP_CONCAT(off_name) FROM contract_resrvprice,officer_master WHERE contract_resrvprice.off_id=officer_master.off_id and contract_resrvprice.cont_id=temp6.cont_id and isnull(vetted_on))off_name from (
select temp5.*,party_master.party_name from (
SELECT temp4.*, contract_agreement.agreement_id, contract_agreement.agt_date, contract_agreement.agr_upto, contract_agreement.party_id
, contract_agreement.rate_for_cont, contract_agreement.remarks, contract_agreement.agree_from_date, contract_agreement.agree_to_date, contract_agreement.license_fee
from(select temp3.*,officer_master.off_name from(
select temp2.*,t2.contTyp_desc sect_name from (
select temp.*,contract_type.contTyp_desc from(
SELECT * FROM contract_master WHERE off_id=$offid 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)temp4
left join contract_agreement
on temp4.cont_id=contract_agreement.cont_id )temp5
left join party_master
on temp5.party_id=party_master.party_id)temp6
left join station_master
on temp6.st_id=station_master.st_id";
$res= $action->select($sql);
$i=1;
$flag=true;
foreach ($res as $id=>$row){
$reg_no=$row['reg_no'];
$tdate=date('d/m/y',strtotime($row['tender_date']));
$tno=$row['tender_no'];
$topendt=date('d/m/y',strtotime($row['tender_open_date']));
$ctype=$row['contTyp_id']."|".$row['contSubTyp_id'];
$st_name=$row['st_name'];
}
$sql="SELECT party_master.*,contract_attendee.filled_date,contract_attendee.rate_for_cont
FROM party_master,contract_attendee
WHERE party_master.party_id=contract_attendee.party_id and cont_id=$contid and party_master.party_id=$partyid";
$res= $action->select($sql);
foreach ($res as $id=>$row){
$pname=$row['party_name'];
$address=$row['address'];
$cont_amt=$row['rate_for_cont'];
}
?>
<!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>Contracts</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">
<link rel="stylesheet" href="css/bootstrap-datepicker.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;">Type of Contracts</h4>
</div>
<div class="right mt10">
<h5 class="text-bold mb0 mt5"><a href="#?act=add">Add New Record</a></h5>
</div>
</div>
</div>
</div> <!-- #end row -->
<!-- mini boxes -->
<div class="row">
<form method="post" action="agreement_contracts_save.php">
<div class="col-md-12">
<h4 class="mb5 text-light" style="float:left;font-weight:bold;text-align:center;width:100%;background:#ddd;padding:8px;margin:0px;">Earning Contacts</h4>
<div style="width:100%;float:left;background-color:#fff;padding:15px;">
<div class="col-md-12" style="padding:0px;">
<div class="col-md-3" style="margin-bottom:5px;">
<label>Reg No#</label>
<input type="text" class="form-control" placeholder="Reg No." readonly name="partycode" value="<?=$reg_no;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Tender Date#</label>
<input type="text" class="form-control" placeholder="" name="partycode" readonly value="<?=$tdate;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Tender No.#</label>
<input type="text" class="form-control" placeholder="" name="tenderno" readonly value="<?=$tno;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Tender Opening Date#</label>
<input type="text" class="form-control" placeholder="" name="opningdt" readonly value="<?=$topendt;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Contact Type</label> #<select class="form-control" readonly name="contTyp_id" onchange="price_val(this.value)">
<option value="0">-- Select Contract Type--</option>
<?php
$sql2="select temp.*, contract_type.contTyp_id sec_id,contract_type.contTyp_desc section_name from( select contract_type.* from contract_type where isnull(level) or level=0 ) temp left join contract_type on temp.contTyp_id =contract_type.level order by contTyp_id";
$res=$action->select($sql2);
foreach ($res as $id=>$row){
if ($row['sec_id'])
{
$pval=$row['contTyp_id']."|".$pval=$row['sec_id'];
$pdesc=$row['contTyp_desc']."(".$row['section_name'].")";
}
else
{
$pval=$row['contTyp_id']."|0";
$pdesc=$row['contTyp_desc'];
}
?>
<option value="<?=$pval;?>" <?php if($ctype==$pval) {echo "Selected";} ?>><?=$pdesc;?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6" style="margin-bottom:5px;">
<label>Party Name#</label>
<input type="text" class="form-control" placeholder="" readonly name="prtyname" value="<?=$pname;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>City#</label>
<input type="text" class="form-control" placeholder="" readonly name="city" value="<?=$address;?>"/>
</div>
<div class="col-md-6" style="margin-bottom:5px;">
<label>Purpose</label>
<input type="text" class="form-control" placeholder="" name="purpose" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Agt No.</label>
<input type="text" class="form-control" placeholder="" name="agtno" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Agt Amount#</label>
<input type="text" class="form-control" placeholder="" readonly name="agtamt" value="<?=$cont_amt;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Agt From Date*</label>
<div class="input-group date" id="datepickerDemo">
<input type="text" id="dob" class="form-control" placeholder="" name="agtfromdt" value="<?=$agtfromdt;?>"/>
<span class="input-group-addon"><i class=" ion ion-calendar"></i></span>
</div>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Agt To Date*</label>
<div class="input-group date" id="datepickerDemo2">
<input type="text" id="dob2" class="form-control" placeholder="" name="agttodt" value="<?=$agttodt;?>"/>
<span class="input-group-addon"><i class=" ion ion-calendar"></i></span>
</div>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Station#</label>
<input type="text" class="form-control" placeholder="" readonly name="station" value="<?=$st_name;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Location</label>
<input type="text" class="form-control" placeholder="" name="location" value=""/>
</div>
</div>
</div>
<h4 class="mb5 text-light" style="float:left;font-weight:bold;text-align:center;width:100%;background:#ddd;padding:8px;margin:0px;">SLR Entry</h4>
<div style="width:100%;float:left;background-color:#fff;padding:15px;">
<div class="col-md-12" style="padding:0px;">
<div class="col-md-3" style="margin-bottom:5px;">
<label>Easing Space</label>
<input type="text" class="form-control" placeholder="" name="easingspace" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Train No.</label>
<input type="text" class="form-control" placeholder="" name="trainno" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Train Name</label>
<input type="text" class="form-control" placeholder="" name="trainname" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>From Station</label>
<input type="text" class="form-control" placeholder="" name="frstation" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>To Station</label>
<input type="text" class="form-control" placeholder="" name="tostation" value=""/>
</div>
</div>
</div>
<h4 class="mb5 text-light" style="float:left;font-weight:bold;text-align:center;width:100%;background:#ddd;padding:8px;margin:0px;">Security Deposit Details</h4>
<div style="width:100%;float:left;background-color:#fff;padding:15px;">
<div class="col-md-12" style="padding:0px;">
<div class="col-md-3" style="margin-bottom:5px;">
<label>Type of Inst.</label>
<select class="form-control" name="typeofinst">
<option value="">-- Select Inst.Type --</option>
<option>Inst1</option>
<option>Inst2</option>
<option>Inst3</option>
</select>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Inst. No.</label>
<input type="text" class="form-control" placeholder="" name="instno" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Inst. Date</label>
<input type="text" class="form-control" placeholder="" name="instdt" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Amount</label>
<input type="text" class="form-control" placeholder="" name="amnt" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Bank Name</label>
<input type="text" class="form-control" placeholder="" name="bnakname" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Validity</label>
<input type="text" class="form-control" placeholder="" name="validity" value=""/>
</div>
</div>
</div>
<h4 class="mb5 text-light" style="float:left;font-weight:bold;text-align:center;width:100%;background:#ddd;padding:8px;margin:0px;">Licence Cheque Entry</h4>
<div style="width:100%;float:left;background-color:#fff;padding:15px;">
<div class="col-md-12" style="padding:0px;margin-bottom:15px;">
<div class="col-md-3" style="margin-bottom:5px;">
<label>Periodicity of Payment</label>
<select class="form-control" name="periodicity">
<option value="">-- Select Periodicity --</option>
<option>Periodicity1</option>
<option>Periodicity2</option>
<option>Periodicity3</option>
</select>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Inst. No.</label>
<input type="text" class="form-control" placeholder="" name="instno" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Payment From</label>
<input type="text" class="form-control" placeholder="" name="pmttofrm" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Payment To Date</label>
<input type="text" class="form-control" placeholder="" name="pmttodt" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>License Fee*</label>
<input type="text" class="form-control" placeholder="" name="licensfee" value="<?=$licensefee;?>"/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Cheque No.</label>
<input type="text" class="form-control" placeholder="" name="chkno" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Cheque Date</label>
<input type="text" class="form-control" placeholder="" name="chequedt" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Cheque Amount</label>
<input type="text" class="form-control" placeholder="" name="chequeamt" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Bank Name</label>
<input type="text" class="form-control" placeholder="" name="bankname" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Bank Branch</label>
<input type="text" class="form-control" placeholder="" name="bankbranch" value=""/>
</div>
<div class="col-md-3" style="margin-bottom:5px;">
<label>Remarks*</label>
<input name="agreeid" type="hidden" value="<?=$agreeid;?>"/><input name="partyid" type="hidden" value="<?=$partyid;?>"/><input name="contid" type="hidden" value="<?=$contid;?>"/>
<input type="text" class="form-control" placeholder="" name="remarks" value="<?=$remarks;?>"/>
</div>
</div>
<div class="col-md-4" style="text-align:center"> </div>
<div class="col-md-4" style="text-align:center">
<button class="btn btn-primary mr5 waves-effect" type="submit" value="edit" id="btn-add">Save</button>
<button class="btn btn-primary mr5 waves-effect" type="submit" value="edit" id="btn-add">Cancle</button>
<button class="btn btn-primary mr5 waves-effect" type="submit" value="edit" id="btn-add">Exit</button>
</div>
</div>
</div>
</form>
</div> <!-- #end row -->
</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 src="scripts/plugins/select2.min.js"></script>
<script src="scripts/plugins/bootstrap-colorpicker.min.js"></script>
<script src="scripts/plugins/bootstrap-slider.min.js"></script>
<script src="scripts/plugins/summernote.min.js"></script>
<script src="scripts/plugins/bootstrap-datepicker2.min.js"></script>
<script src="scripts/form-elements.init.js"></script>
</body>
</html>
Private