MAINHACK

Viewing / Editing File: function_payout.php

<?php

//include '../settings/settings.php';
$date = strtotime(date('Y-m-d')); //Custom Date
//echo date('D');
if(date('D') === 'Sat'){

$previous_friday= strtotime("last week friday",$date);
$yesterday=date('Y-m-d',strtotime("-1 days"));
$friday=date('Y-m-d',$previous_friday);

//$coming_friday= strtotime("next friday",$date);
//$friday_coming=date('Y-m-d',$coming_friday);
//echo $friday;

$sq="select * from payout_log where from_date='$friday' and to_date='$yesterday' order by id desc"; //echo $sq;
$s1=$con->prepare($sq);
$s1->execute();
$num=$s1->rowCount();// echo $num;
if($num==0){

$s="insert into payout_log(maker_id,total_amount,p_amount,payout,comission,from_date,to_date,payout_status) SELECT place_order.maker_id,sum(place_order.total),sum(place_order.amount),sum(place_order.amount)-sum(place_order.amount)*(food_maker.comi_percent/100),food_maker.comi_percent,'$friday','$yesterday','PENDING' FROM `place_order` left join food_maker on food_maker.maker_id=place_order.maker_id WHERE cast(place_order.date as date) between '$friday' and '$yesterday' and place_order.status='PLACED' group by place_order.maker_id";
//echo $s;
$st=$con->prepare($s);
$st->execute();

$sck1="select p1.* from payout_log as p1 left join payout_log as p2 on p1.maker_id=p2.maker_id and p1.id<p2.id where p2.id is null ";
$sck=$con->prepare($sck1);
$sck->execute();
while ($row = $sck->fetch(PDO::FETCH_ASSOC)){
    $mid=$row['maker_id'];
     $pay=$row['payout'];
   //echo $mid;
$check_total=$show->readwithdata('payout_log_total','maker_id',$mid);
$num1=$check_total->rowCount(); echo $num1;
if($num1>0){
$row1 = $check_total->fetch(PDO::FETCH_ASSOC);
        $status=$row1['status'];
   if($status=='CLEARED'){
       $s="update payout_log_total set amount=".$pay." where maker_id='$mid'";
       $s12=$con->prepare($s);
       $s12->execute();
   }else{
      $s3="update payout_log_total set amount=amount+".$pay." where maker_id='$mid'";
        $s123=$con->prepare($s3);
       $s123->execute();
   } 
    
}else{
    $s124="insert into payout_log_total(maker_id,amount,status) values('$mid','$pay','PENDING')";
    $s1245=$con->prepare($s124);
       $s1245->execute();
}
}
//$s2="SELECT * from (select id,sum(amount) as a,status,maker_id,max(date) from place_order where status='PLACED' group by maker_id) as y where a>=250 order by id asc ";

//$s="insert into payout_log(maker_id,total_amount,p_amount,from_date,to_date,payout_status) SELECT * from (select id,sum(amount) as a,status,maker_id,max(date) from place_order where status='PLACED' group by maker_id) as y where a>=250 order by id asc";

}
}else{
    echo date('D', $timestamp);
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: function_payout.php

Server Info

System Features

User Info