Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/crm/backup

Free Space:

9.3 TB

🔧 Quick Actions

✏️ Editing: sales-attendance.php

<?php  include "header.php";

$action=$_REQUEST['action'];
//echo $action;

if($action=='update'){

$rowcnt=$_POST["rowcnt"];
    $p_bdate=$_POST['p_bdate'];
    $year = date('Y', strtotime($p_bdate));

$month = date('F', strtotime($p_bdate));
    //echo "Row Count:".$rowcnt;
    for($i=1;$i<=$rowcnt;$i++){

//$chk=$_POST['rd'.$i];
       $agid1st=$_POST['agid1st'.$i];
       $attend1st=$_POST['attend1st'.$i];
        $agid2nd=$_POST['agid2nd'.$i];
       $attend2nd=$_POST['attend2nd'.$i];

//echo "hello".$chk;
      
        $slid=$agid1st;
$chkatt=f(q("SELECT * FROM tbl_attendance WHERE tbl_sl_id='$slid' AND tbl_date='$p_bdate'"));
if($chkatt['tbl_attid']==''){
    $q=mysqli_query($con,"INSERT INTO tbl_attendance SET tbl_sl_id='$agid1st',tbl_pres='$attend1st',tbl_date='$p_bdate',tbl_shift='$attend2nd',tbl_month='$month',tbl_year='$year'");
    //$q1=mysqli_query($con,"INSERT INTO tbl_attendance SET tbl_sl_id='$agid2nd',tbl_pres='$attend2nd',tbl_date='$p_bdate',tbl_shift='2nd',tbl_month='$month',tbl_year='$year'");
}else{

$q=mysqli_query($con,"UPDATE tbl_attendance SET tbl_pres='$attend1st',tbl_shift='$attend2nd' WHERE tbl_date='$p_bdate' AND tbl_sl_id='$agid1st'");

// $q1=mysqli_query($con,"UPDATE tbl_attendance SET tbl_pres='$attend2nd' WHERE tbl_date='$p_bdate' AND tbl_sl_id='$agid2nd' AND tbl_shift='2nd'");

//echo "UPDATE tbl_attendance SET tbl_pres='$attend2nd' WHERE tbl_date='$p_bdate' AND tbl_sl_id='$agid2nd' AND tbl_shift='2nd'";
}

}

<style>

body{
    color:white;
}
h4{
    color:black;
}

</style>

        
        
        <div class="page-wrapper">
            
            
            
            <div class="page-breadcrumb">
                <div class="row">
                    <div class="col-12 d-flex no-block align-items-center">
                        <h4 class="page-title">Attendance</h4>
                        <div class="ml-auto text-right">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="#">Home</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Shop Wise Sales</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            <script>
                
                function setValue(vals){
                        var a=document.getElementById('myonoffswitch4'+vals);    
                        if(a.checked==true){

document.getElementById('chkbox'+vals).value=1;
                        }else{
                            document.getElementById('chkbox'+vals).value=0;

}

</script>
            
            
            
            
            
            
            <div class="container-fluid">
                
                
                
                <div class="row">
                    
                    <div class="col-md-12">
                    <div class="card">
                            <div class="card-body">
                                <form action="sales-attendance.php?action=update" method="POST" target="_blank">
                                    <h4 class="card-title">Employee Attendance</h4>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-2 text-left control-label col-form-label">Date</label>
                                        <div class="col-sm-4">
                                            <input type="date" class="form-control" name="p_bdate" id="email1" placeholder="join Date" value="<?php if($action=='edit'){ echo $edit['p_bdate']; }else{?><? echo date('Y-m-d');?><?}?>">

</div>

</div>  
                                      
                                    <div class="form-group row">
                                            <div class="col-sm-6">
                                                <center><b>1st Shift</b></center><br>
                                                <center><b>------------------------------------------</b></center>
                                                
                                                <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-left control-label col-form-label">Name</label>
                                        <div class="col-sm-6">
                                          <b>Present?</b>

</div>
                                        
                                    </div>

<?php
                                    $i=0;
                                    $q=mysqli_query($con,"SELECT * FROM tbl_agents");
                                    while($arrc=mysqli_fetch_array($q)){
                                        $i=$i+1;
                                        $curdate=date('Y-m-d');
                                        $chkk=f(q("SELECT * FROM tbl_attendance WHERE tbl_sl_id='$arrc[ag_id]' AND tbl_date='$curdate'"));
                                        $chk=$chkk['tbl_pres'];
                                    ?>

<div class="form-group row">
                                        <label for="fname" class="col-sm-2 text-left control-label col-form-label"><?php echo $arrc['ag_name']?></label>
                                        
                                        <div class="col-sm-4">
                                            <input type="hidden" name="agid1st<?php echo $i?>" value="<?php echo $arrc['ag_id']?>">
                                                <select name="attend1st<?php echo $i?>" class="form-control">
                                                       <option value="1" <?php if($chk==1){?> selected <?php }?>>Present</option>
                                                       <option value="0" <?php if($chk==0){?> selected <?php }elseif($chk==''){ ?> selected<?php } ?>>Absent</option>

</select>

</div>
                                        
                                    </div>

<?php } ?>
                                </div>
                                            <div class="col-sm-6">
                                                <center><b>2nd Shift</b></center><br>
                                                <center><b>------------------------------------------</b></center>
                                        
                                    
                                        <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-left control-label col-form-label">Name</label>
                                        <div class="col-sm-6">
                                          <b>Present?</b>

</div>
                                        
                                    </div>

<?php
                                    $i=0;
                                    $q=mysqli_query($con,"SELECT * FROM tbl_agents");
                                    while($arrc=mysqli_fetch_array($q)){
                                        $i=$i+1;
                                        $curdate=date('Y-m-d');
                                        $chkkk=f(q("SELECT * FROM tbl_attendance WHERE tbl_sl_id='$arrc[ag_id]' AND tbl_date='$curdate'"));
                                         $chk=$chkkk['tbl_shift'];
                                    ?>

<div class="form-group row">
                                        <label for="fname" class="col-sm-2 text-left control-label col-form-label"><?php echo $arrc['ag_name']?></label>
                                        
                                        <div class="col-sm-4">
                                            <input type="hidden" name="agid2nd<?php echo $i?>" value="<?php echo $arrc['ag_id']?>">
                                                <select name="attend2nd<?php echo $i?>" class="form-control">
                                                       <option value="1" <?php if($chk==1){?> selected <?php } ?>>Present</option>
                                                       <option value="0"  <?php if($chk==0){?> selected <?php }elseif($chk==''){ ?> selected<?php } ?>>Absent</option>

</select>

</div>
                                        
                                    </div>

<?php } ?>

</div>

</div>
                                    <input type="hidden" name="rowcnt" value="<?php echo $i?>">

<div class="border-top">
                                    <div class="card-body">
                                        <button type="submit" class="btn btn-primary">Update</button>
                                    </div>
                                </div>
                                 </form>    
                            </div>
                    </div>

</div>
                    
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>

<?php  include "footer.php"; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-attendance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation