MAINHACK

Viewing / Editing File: ajax_check.php

<?php
include('../settings/settings.php');

if(isset($_POST['phone'])){
$phn=$_POST['phone'];
$show=new oops($db);
$stmt=$show->readwithdata($_POST['tablename'],'phone',$phn);
$num=$stmt->rowCount();
if($num>0){
    echo "1";
//echo "<span class='label label-danger'>Phone Number already in use.Please Give another Phone Number</span>";
}else{
    echo "0";
}

}
if(isset($_POST['email'])){
$email=$_POST['email'];
$show=new oops($db);
$stmt=$show->readwithdata($_POST['tablename'],'email',$email);
$num=$stmt->rowCount();
if($num>0){
    echo "1";
//echo "<span class='label label-danger'>Phone Number already in use.Please Give another Phone Number</span>";
}else{
    echo "0";
}

}
if(isset($_POST['approve']))
{
    
$st=trim($_POST['approve']);
$id=$_POST['id'];
$table=$_POST['table'];
$stmt=$con->prepare("update $table set approve='".$st."' where id='".$id."'");
$stmt->execute();

}
if(isset($_POST['ustatus']))
{
$st=trim($_POST['ustatus']);
$id=$_POST['id'];
$table=$_POST['table'];
$stmt=$con->prepare("update $table set status='".$st."' where id='".$id."'");
$stmt->execute();

}
if(isset($_POST['trending']))
{
$st=trim($_POST['trending']);
$id=$_POST['id'];
$table=$_POST['table'];
$stmt=$con->prepare("update $table set trending='".$st."' where id='".$id."'");
$stmt->execute();

}
if(isset($_POST['status']))
{
$status=trim($_POST['status']);
$id=$_POST['id'];
$stmt=$con->prepare("update support_ticket set status='".$status."' where id=".$id."");
$stmt->execute();
}
if(isset($_POST['locality']))
{
$name=trim($_POST['locality']);
$a=trim($_POST['dynamic_num']);

$query2="SELECT * FROM district WHERE locality LIKE '%$name%' OR locality LIKE '$name%' OR locality LIKE '$name%'";
$r=$con->prepare($query2);
$r->execute();
echo "<ul>";
while ($query3 = $r->fetch(PDO::FETCH_ASSOC)){
{
?>

<li class='show11' align='left' onclick='filld("<?=$a?>","<?php echo $query3['locality']; ?>")'><?=$query3['locality'];?>| <?=$query3['district'];?></li>
<?php
}
echo "</ul>";
}
}
if(isset($_POST['maker_id']))
{ //echo $_POST['maker_id'];
?>
                	<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					
					            <table id="basic-datatables" class="display table table-striped table-hover">    
                <thead>
                <tr>
                <th>ID</th>
                <th>Date/ Book ID</th>
                <th>Home Cook Name/ID</th>
                <th>G.Total</th>
                <th>Comission(%)</th>
                <th>Comission Amt</th>
                <th>Payment Status</th>
                </tr> 
                </thead>
                <tbody>
		
		
<?php
$comi_total=0;			
$count=1;
$sq="select sajh_comission.book_id,sajh_comission.gross_total,sajh_comission.commission_amt,sajh_comission.commission,sajh_comission.cook_id,sajh_comission.date,sajh_comission.paid_status,sajh_comission.paid_date,sajh_comission.status,food_maker.name,food_maker.title,food_maker.email,food_maker.phone from sajh_comission left join food_maker on food_maker.maker_id=sajh_comission.cook_id where food_maker.maker_id='".$_POST['maker_id']."' and (month(sajh_comission.date)='".$_POST['month']."' || sajh_comission.date between '".$_POST['from_date']."' and '".$_POST['to_date']."')  order by sajh_comission.date desc ";    
//echo  $sq;
$stmt=$con->prepare($sq);
$stmt->execute();
$num=$stmt->rowCount();
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        
        $id=$row['id'];          
        $comi_total +=$row['commission_amt'];
   
		echo "<tr>
				
		<td>$count</td>
		<td>".date('d-m-Y',strtotime($row['date']))."<br>".$row['book_id']."</td>
		<td>".$row['title']."<br>".$row['cook_id']."</td>
		<td>".$row['gross_total']."</td>
		<td>".$row['commission']."</td>
		<td>".$row['commission_amt']."</td>
		<td style='color:red;'>".$row['paid_status']."</td>
		</tr>";

++$count;
 }
  	echo "<tr style='background-color: #d0d0e1;' ><td colspan='4'></td><td>Total Commission :</td><td>$comi_total</td><td></td></tr>";

}else{ echo "<tr><td><h4>No data found</h4></td></tr>";}
?>							
</tbody>
                                    </table>
                                </div>
                            </div></div>

<?php 
}
if(isset($_POST['our_special']))
{
$st=trim($_POST['our_special']);
$id=$_POST['id'];
$table=$_POST['table'];
$stmt=$con->prepare("update $table set our_special='".$st."' where id='".$id."'");
$stmt->execute();

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: ajax_check.php

Server Info

System Features

User Info