Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/systema

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: editdes.php

<?php 
ob_start();
session_start();
include("includes/connection.php");
include("includes/functions.php");
$date = date_default_timezone_set('Asia/Kolkata');
$id=$_REQUEST['id'];
if($_REQUEST['pydid'])
{
  $row=mysqli_fetch_array(mysqli_query($con,"select * from `paymentdes` where `pyd_id`='".$_REQUEST['pydid']."'"));
  mysqli_query($con,"delete from `attendance` where `stfref`='".$row['pyd_stref']."' and `date`='".$row['pyd_cdate']."' and `shift`='".$row['pyd_shift']."'");
  mysqli_query($con,"delete from `paymentdes` where `pyd_id`='".$_REQUEST['pydid']."'");
  $_SESSION['msge']="Entry deleted.";
  header("Location:editdes.php?id=$id");
  exit();
}
if($_POST['subst']!="")
{
	$d=dtconvert($_POST['sdate']);
	$arr=explode("-",$d);
	$day=intval($arr[1]);
	$mon=intval($arr[2]);
	$tot=round($_POST['stich']*$_POST['rate']);
	mysqli_query($con,"insert into `paymentdes` values ('','".$d."','".$id."','".$_POST['stich']."','".$_POST['rate']."','".$_POST['shift']."','".$_POST['machno']."','".$tot."','')");
	mysqli_query($con,"insert into `attendance` values ('','".$id."','".$d."','".$day."','".$mon."','".$_POST['shift']."')");
	$_SESSION['msgs']="Details Added.";
    header("Location:editdes.php?id=$id");
	exit();
}
if($_POST['sub']!="")
{
	$d=dtconvert($_POST['pdate']);
	mysqli_query($con,"insert into `paymentdes` values ('','".$d."','".$id."','','','','','','".$_POST['given']."')");
	$_SESSION['msge']="Details Added.";
    header("Location:editdes.php?id=$id#tbl");
	exit();
}
$rows=mysqli_fetch_array(mysqli_query($con,"select `adv_name` from `staff` where `adv_id`='".$id."'"));
$sqlp="select sum(pyd_depo) a, sum(pyd_paid) b from `paymentdes` where `pyd_stref`='".$id."'";
if(isset($_POST['subsear']) && $_POST['subsear']!="") {
	if(isset($_POST['frdate']) && $_POST['frdate']!="") {
			$sqlp.=" and `pyd_cdate`>='".dtconvert($_POST['frdate'])."'";
	 }
	 if(isset($_POST['todate']) && $_POST['todate']!="") {
		$sqlp.=" and `pyd_cdate`<='".dtconvert($_POST['todate'])."'";
	 } 
} else {
	$dfr=date("Y-m")."-01";
	$dto=date("Y-m")."-31";
	$sqlp.=" and `pyd_cdate`>='".$dfr."' and `pyd_cdate`<='".$dto."'";	
}	 	 
$row=mysqli_fetch_array(mysqli_query($con,$sqlp));		 
$pending=$row['a']-$row['b'];
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Payment Details</title>
<style type="text/css">

</style>
<script type='text/javascript' src="./zpcal/utils/zapatec.js"></script>
<script type="text/javascript" src="./zpcal/src/calendar.js"></script>
<script type="text/javascript" src="./zpcal/lang/calendar-en.js"></script>
<link href="./zpcal/website/css/zpcal.css" rel="stylesheet" type="text/css">
<link href="./zpcal/themes/aqua.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function PrintDivData(crtlid)
{
//document.getElementById("prbill").style.display='none';
var ctrlcontent = document.getElementById(crtlid);
var printscreen = window.open('','','left=0,top=0,width=1048,toolbar=0,scrollbars=0,status=0');
printscreen.document.write(ctrlcontent.innerHTML);
printscreen.document.close();
printscreen.focus();
printscreen.print();
printscreen.close();
}
</script>
</head>
<link href="css/style2.css" rel="stylesheet" type="text/css" />
<body style="background:#ECEAD5;">
<form action="#" method="post" name="stform">
<INPUT TYPE="hidden" NAME="totid" id="totid" value="<?php print round($pending); ?>">
<INPUT TYPE="hidden" NAME="id" value="<?php print $_REQUEST['id']; ?>">
<table width="80%" align="center" border="0" style="border-left:1px solid #D7D7FF; border-right:1px solid #D7D7FF; border-top:1px solid #D7D7FF; border-bottom:1px solid #D7D7FF;" cellpadding="10">
  <tr bgcolor="#B0D8FF" height="30">
    <td align="left" colspan="2"><span class="style1"><FONT face="Verdana, Arial, Helvetica, sans-serif">Stiching Details (<?php print $rows['adv_name']; ?>)</FONT></span></td>
  </tr>
  <tr><td colspan="2" align=center><FONT style="font-family: Arial, Helvetica, sans-serif;font-size:12px;"><?php print $_SESSION[msgs];$_SESSION[msgs]=""; ?></font></td></tr>
   <tr class="<?php echo $flag%2==0?"alternate_color1":"alternate_color2";?>">
	<td align="right" class="style6">
	Date : 
    </td>
	<td align="left" colspan="2" class="style6">
	<input type="text" name="sdate" id="eventstartdate5"  style="border:1px solid #D7D7D7;height:25px;" required  readonly="readonly" size="10" value="<?php print date("d-m-Y"); ?>">
   <span id="cal15">
   <img src="./images/calendar.jpg" style="cursor:pointer;" /></span>
   <script type="text/javascript">
   var cal = new Zapatec.Calendar.setup({

inputField:"eventstartdate5",
	ifFormat:"%d-%m-%Y",
	button:"cal15",
	showsTime:false

});
	</script>(Format 02-03-2014)
    </td>
   </tr>
   <tr>
	<td align="right" class="style6">
	Shift : 
    </td>
	<td align="left" colspan="2" class="style6">
	<select name="shift" required>
		<option value="">Select
		<option value="Day">Day
		<option value="Night">Night
	</select>
    </td>
   </tr>
   <tr>
    <td align="right" width="35%">
	<span class="style6">Machine No. : </span>
    </td>
	<td align="left">
	<INPUT TYPE="text" NAME="machno" style="border:1px solid #D8D8D8;" size="5">
    </td>
  </tr>
   <tr>
    <td align="right" style="background-color:#B0D8FF; color:#CCCCCC" width="35%">
	<span class="style6">Total Stiching : </span>
    </td>
	<td align="left">
	<INPUT TYPE="number" NAME="stich" style="border:1px solid #D8D8D8;" size="5" onkeyup="findtot()" onkeydown="findtot()" required>
    </td>
  </tr>
  
  <tr>
	<td align="right" class="style6">
	Rate : 
    </td>
	<td align="left" colspan="2" class="style6">
	<INPUT TYPE="number" NAME="rate" style="border:1px solid #D8D8D8;" onkeyup="findtot()" onkeydown="findtot()" required step=".0001">
    </td>
   </tr>
   
    <tr>
	<td align="right" class="style6">
	Total :
    </td>
	<td align="left" colspan="2" class="style6">
	<div id="spid"></div>
    </td>
   </tr>

</table>
</form>
<br /><br /><br />
<form action="#" method="post" name="payform">
<INPUT TYPE="hidden" NAME="totid" id="totid" value="<?php print round($pending); ?>">
<INPUT TYPE="hidden" NAME="id" value="<?php print $_REQUEST['id']; ?>">
<table width="80%" align="center" border="0" style="border-left:1px solid #D7D7FF; border-right:1px solid #D7D7FF; border-top:1px solid #D7D7FF; border-bottom:1px solid #D7D7FF;" cellpadding="10" id="tbl">
  <tr bgcolor="#B0D8FF" height="30">
    <td align="left" colspan="2"><span class="style1"><FONT face="Verdana, Arial, Helvetica, sans-serif">Payment Details (<?php print $rows['adv_name']; ?>)</FONT></span></td>
  </tr>
  <tr><td colspan="2" align=center><FONT style="font-family: Arial, Helvetica, sans-serif;font-size:12px;"><?php print $_SESSION[msge];$_SESSION[msge]=""; ?></font></td></tr>
   <tr>
	<td align="right" class="style6">
	Date : 
    </td>
	<td align="left" colspan="2" class="style6">
	<input type="text" name="pdate" id="eventstartdate"  style="border:1px solid #D7D7D7;height:25px;" required  readonly="readonly" size="10" value="<?php print date("d-m-Y"); ?>">
   <span id="cal1">
   <img src="./images/calendar.jpg" style="cursor:pointer;" /></span>
   <script type="text/javascript">
   var cal = new Zapatec.Calendar.setup({

inputField:"eventstartdate",
	ifFormat:"%d-%m-%Y",
	button:"cal1",
	showsTime:false

});
	</script>(Format 02-03-2014)
    </td>
   </tr>
   <tr>
    <td align="right" width="35%">
	<span class="style6">Total Credit : </span>
    </td>
	<td align="left" class="style6">
	Rs. <?php echo round($row['a']); ?>
    </td>
  </tr>
  <tr>
    <td align="right" width="35%">
	<span class="style6">Total Debit : </span>
    </td>
	<td align="left" class="style6">
	Rs. <?php echo round($row['b']); ?>
    </td>
  </tr>
   <tr>
    <td align="right" width="35%">
	<span class="style6">Payable Amount : </span>
    </td>
	<td align="left" class="style6">
	Rs. <?php echo round($pending); ?>
    </td>
  </tr>
  
  <tr>
	<td align="right" class="style6">
	Amount Given : 
    </td>
	<td align="left" colspan="2" class="style6">
	Rs. <INPUT TYPE="number" NAME="given" style="border:1px solid #D8D8D8;" size="5" onkeyup="findpending(this.value)" onkeydown="findpending(this.value)" required>
    </td>
   </tr>
    <tr class="<?php echo $flag%2==0?"alternate_color1":"alternate_color2";?>">
	<td align="right" class="style6">
	Amount Pending :
    </td>
	<td align="left" colspan="2" class="style6">
	<div id="pid">Rs. <?php echo round($pending); ?></div>
    </td>
   </tr>

</table>
</form>
<br /><br /><br />
<form action="#Div_Print" method="post" name="searform">
<table width="100%" align="center" border="0" style="background:#999;" cellpadding="1" cellspacing="1">
  <tr>
    <td align="right" class="style6">
	From Date : 
    </td>
	<td align="left" colspan="2" class="style6">
	<input type="text" name="frdate" id="eventstartdate2" required  readonly="readonly" size="10" value="<?php print $_REQUEST['frdate']; ?>">
   <span id="cal2">
   <img src="./images/calendar.jpg" style="cursor:pointer;" /></span>
   <script type="text/javascript">
   var cal = new Zapatec.Calendar.setup({

inputField:"eventstartdate2",
	ifFormat:"%d-%m-%Y",
	button:"cal2",
	showsTime:false

});
	</script>(Format 02-03-2014)
    </td>
	<td align="right" class="style6">
	To Date : 
    </td>
	<td align="left" colspan="2" class="style6">
	<input type="text" name="todate" id="eventstartdate3" required  readonly="readonly" size="10" value="<?php print $_REQUEST['todate']; ?>">
   <span id="cal3">
   <img src="./images/calendar.jpg" style="cursor:pointer;" /></span>
   <script type="text/javascript">
   var cal = new Zapatec.Calendar.setup({

inputField:"eventstartdate3",
	ifFormat:"%d-%m-%Y",
	button:"cal3",
	showsTime:false

});
	</script>(Format 02-03-2014)
    </td>
	<td align="center" colspan="2">
   <INPUT TYPE="submit" value="Submit" name="subsear">
  </td>
  </tr>
</table>
</form>   
<div id="Div_Print">
<table width="100%" align="center" border="0" style="background:#999;" cellpadding="1" cellspacing="1">
  <tr>
    <td align="left" colspan="7" height="30" style="background:#B0D8FF;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 12px;font-weight: bold;">Payment History (<?php print $rows['adv_name']; ?>)&nbsp;&nbsp;Total Credit: Rs. <?php echo round($row['a']); ?>&nbsp;&nbsp;Total Debit: Rs. <?php echo round($row['b']); ?>&nbsp;&nbsp;Pending: Rs. <?php echo round($pending); ?></td>
  </tr>
  
   <tr>
    <th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Date</th>
	<th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Credit</th>
	<th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Debit</th>
	<th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Stich @Rate</th>
	<th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Shift</th>
	<th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Machine</th>
	<th align="left" style="background: #D6E7F7;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">Option</th>
   </tr>
   <?php
	 if(isset($_POST['subsear']) && $_POST['subsear']!="") {
		 $sql="select * from `paymentdes` where `pyd_stref`='".$id."'";
		 if(isset($_POST['frdate']) && $_POST['frdate']!="") {
			$sql.=" and `pyd_cdate`>='".dtconvert($_POST['frdate'])."'";
		 }
		 if(isset($_POST['todate']) && $_POST['todate']!="") {
			$sql.=" and `pyd_cdate`<='".dtconvert($_POST['todate'])."'";
		 } 
		 $sql.=" order by `pyd_cdate` desc";
     } else {
	 	$dfr=date("Y-m")."-01";
	 	$dto=date("Y-m")."-31";
		$sql="select * from `paymentdes` where `pyd_stref`='".$id."' and `pyd_cdate`>='".$dfr."' and `pyd_cdate`<='".$dto."' order by `pyd_cdate` desc";
	 }		  
     $res3=mysqli_query($con,$sql);
     while($row3=mysqli_fetch_array($res3))
	 {
   ?>
   <tr>
    <td align="left" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">
	<?php echo dtconvert($row3['pyd_cdate']);?>
    </td>
	<td align="left" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">
	<?php if($row3['pyd_depo']!=0) { ?>Rs. <?php echo round($row3['pyd_depo']); ?><?php } ?>
    </td>
	<td align="left" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">
	<?php if($row3['pyd_paid']!=0) { ?>Rs. <?php echo round($row3['pyd_paid']);?><?php } ?>
    </td>
	<td align="left" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;"><?php print $row3['pyd_stich']; ?><?php if($row3['pyd_rate']) { print " @".$row3['pyd_rate'];  }?></td>
	<td align="left" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;"><?php print $row3['pyd_shift']; ?></td>
	<td align="left" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;"><?php print $row3['pyd_machno']; ?></td>
	<td align="center" style="background: #FFFFFE;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000033;font-size: 11px;font-weight: bold;">
	<INPUT TYPE="button" VALUE="D" ONCLICK="location.href='editdes.php?pydid=<?php echo $row3[pyd_id];?>&id=<?php echo $id;?>&page=<?php print $_REQUEST[page]; ?>&countd=<?php print $_REQUEST[countd]; ?>&adv_name=<?php print $_REQUEST[adv_name]; ?>&adv_bill=<?php print $_REQUEST[adv_bill]; ?>'">
    </td>
  </tr>
  <?php } ?>

</table>
</div>
<div style="margin:auto;text-align:center;margin-top:10px;"><input type="button" value="Print" class='all_button' onClick="javascript:PrintDivData('Div_Print');" id="prbill"></div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: editdes.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation