File "update-prices.php"

Full Path: /home/cananyalcin/public_html/core/module/admin/update-prices.php
File size: 8.99 KB
MIME-type: text/x-php
Charset: utf-8

<?php

if ($user["access"]["update-prices"] != 1):
    header("Location:" . site_url("admin"));
    exit();
endif;
  

  if( $_SESSION["client"]["data"] ):
    $data = $_SESSION["client"]["data"];
    foreach ($data as $key => $value) {
      $$key = $value;
    }
    unset($_SESSION["client"]);
  endif;
$services = $conn->prepare("SELECT * FROM services ");
 $services->execute(array());
 $services = $services->fetchAll(PDO::FETCH_ASSOC);
foreach($services as $service):

   if( $_POST ):
  
$new_profit     = $_POST["new_profit"];
$type     = $_POST["type"];
if( $type == 1 ) {

if( $service["service_api"] == 0 ):
     
    

$service_price = $service["service_price"];
  $service_id =  $service["service_id"];
     $service_api_price2 = $service["service_price"];
 $final = $service_api_price2 +($service_api_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array("service_id" => $service_id , "service_price" => $final));
   


else:
     
$extras = json_decode($service["api_detail"],true);
 $service_price = $service["service_price"];
 $service_api_price = $extras["rate"];
 $service_id =  $service["service_id"];
 $service_api_price2 = $service_api_price;
 $final = $service_api_price2 +($service_api_price2 * ($new_profit/100));
 
    try{
     
       
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array("service_id" => $service_id , "service_price" => $final));

   
    }
    catch(\Exception $e){
        echo $e;
        exit;
    }
$referrer = site_url("admin/update-prices");
                $icon = "success";
                $error = 1;
                $errorText = "Success";
                
                header("Location:".site_url("admin/update-prices"));
                echo json_encode(["t"=>"error","m"=>$errorText,"s"=>$icon,"r"=>$referrer,"time"=>1]);

              if( $update ):
                header("Location:" . site_url("admin/update-prices"));
                    $_SESSION["client"]["data"]["success"] = 1;
                    $_SESSION["client"]["data"]["successText"] = "Successful";
              else:
                $errorText  = "Failed";
                $error      = 1;
				
              endif;

endif;

} elseif( $type == 2) {

if( $service["service_api"] == 0 ):


$service_price = $service["service_price"];
  $service_id =  $service["service_id"];
     $service_manual_price2 = $service["service_price"];
 $final = $service_manual_price2 +($service_manual_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array("service_id" => $service_id , "service_price" => $final));
  
$referrer = site_url("admin/update-prices");
                $icon = "success";
                $error = 1;
                $errorText = "Success";
                
                header("Location:".site_url("admin/update-prices"));
                echo json_encode(["t"=>"error","m"=>$errorText,"s"=>$icon,"r"=>$referrer,"time"=>1]);

              if( $update ):
                header("Location:" . site_url("admin/update-prices"));
                    $_SESSION["client"]["data"]["success"] = 1;
                    $_SESSION["client"]["data"]["successText"] = "Successful";
              else:
                $errorText  = "Failed";
                $error      = 1;
				
              endif;

endif;
 



} elseif( $type == 3) {

if( $service["service_api"] == 0 ):


   

else:
$extras = json_decode($service["api_detail"],true);
 $service_price = $service["service_price"];
 $service_api_price = $extras["rate"];
 $service_id =  $service["service_id"];
 $service_api_price2 = $service_api_price;
 $final = $service_api_price2 +($service_api_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array( "service_id" => $service_id , "service_price" => $final));
$referrer = site_url("admin/update-prices");
                $icon = "success";
                $error = 1;
                $errorText = "Success";
                
                header("Location:".site_url("admin/update-prices"));
                echo json_encode(["t"=>"error","m"=>$errorText,"s"=>$icon,"r"=>$referrer,"time"=>1]);

              if( $update ):
                header("Location:" . site_url("admin/update-prices"));
                    $_SESSION["client"]["data"]["success"] = 1;
                    $_SESSION["client"]["data"]["successText"] = "Successful";
              else:
                $errorText  = "Failed";
                $error      = 1;
				
              endif;
endif;
} 

 endif;
 if( route(2) == "decrease" ):

if( $_POST ):
$new_profit     = $_POST["new_profit"];
$type     = $_POST["type"];
if( $type == 1 ) {

if( $service["service_api"] == 0 ):


$service_price = $service["service_price"];
  $service_id =  $service["service_id"];
     $service_api_price2 = $service["service_price"];
 $final = $service_api_price2 -($service_api_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array("service_id" => $service_id , "service_price" => $final));
   

else:
$extras = json_decode($service["api_detail"],true);
 $service_price = $service["service_price"];
 $service_api_price = $extras["rate"];
 $service_id =  $service["service_id"];
 $service_api_price2 = $service_api_price;
 $final = $service_api_price2 -($service_api_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array( "service_id" => $service_id , "service_price" => $final));
$referrer = site_url("admin/update-prices");
                $icon = "success";
                $error = 1;
                $errorText = "Success";
                
                header("Location:".site_url("admin/update-prices"));
                echo json_encode(["t"=>"error","m"=>$errorText,"s"=>$icon,"r"=>$referrer,"time"=>1]);

              if( $update ):
                header("Location:" . site_url("admin/update-prices"));
                    $_SESSION["client"]["data"]["success"] = 1;
                    $_SESSION["client"]["data"]["successText"] = "Successful";
              else:
                $errorText  = "Failed";
                $error      = 1;
				
              endif;
endif;

} elseif( $type == 2) {

if( $service["service_api"] == 0 ):


$service_price = $service["service_price"];
  $service_id =  $service["service_id"];
     $service_manual_price2 = $service["service_price"];
 $final = $service_manual_price2 -($service_manual_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array("service_id" => $service_id , "service_price" => $final));
  
$referrer = site_url("admin/update-prices");
                $icon = "success";
                $error = 1;
                $errorText = "Success";
                
                header("Location:".site_url("admin/update-prices"));
                echo json_encode(["t"=>"error","m"=>$errorText,"s"=>$icon,"r"=>$referrer,"time"=>1]);

              if( $update ):
                header("Location:" . site_url("admin/update-prices"));
                    $_SESSION["client"]["data"]["success"] = 1;
                    $_SESSION["client"]["data"]["successText"] = "Successful";
              else:
                $errorText  = "Failed";
                $error      = 1;
				
              endif;

endif;
 



} elseif( $type == 3) {

if( $service["service_api"] == 0 ):


   

else:
$extras = json_decode($service["api_detail"],true);
 $service_price = $service["service_price"];
 $service_api_price = $extras["rate"];
 $service_id =  $service["service_id"];
 $service_api_price2 = $service_api_price;
 $final = $service_api_price2 -($service_api_price2 * ($new_profit/100));
 
      $update = $conn->prepare("UPDATE services SET service_price=:service_price WHERE service_id=:service_id");
     $update->execute(array( "service_id" => $service_id , "service_price" => $final));
$referrer = site_url("admin/update-prices");
                $icon = "success";
                $error = 1;
                $errorText = "Success";
                
                header("Location:".site_url("admin/update-prices"));
                echo json_encode(["t"=>"error","m"=>$errorText,"s"=>$icon,"r"=>$referrer,"time"=>1]);

              if( $update ):
                header("Location:" . site_url("admin/update-prices"));
                    $_SESSION["client"]["data"]["success"] = 1;
                    $_SESSION["client"]["data"]["successText"] = "Successful";
              else:
                $errorText  = "Failed";
                $error      = 1;
				
              endif;
endif;
} 

 endif;
endif;



endforeach;

  require admin_view('update-prices');