<?php
ini_set('max_execution_time', '600');
define("BASEPATH",TRUE);
require $_SERVER["DOCUMENT_ROOT"]."/vendor/autoload.php";
require $_SERVER["DOCUMENT_ROOT"]."/app/init.php";
$smmapi  = new SMMApi();
$fapi = new socialsmedia_api();
$orders = $conn->prepare("SELECT *,services.service_id as service_id,services.service_api as api_id FROM orders
  INNER JOIN clients ON clients.client_id=orders.client_id
  INNER JOIN services ON services.service_id=orders.service_id
  LEFT JOIN categories ON categories.category_id=services.category_id
  INNER JOIN service_api ON service_api.id=orders.order_api
  WHERE orders.dripfeed=:dripfeed && orders.subscriptions_type=:subs && ( orders.order_status=:statu1 || orders.order_status=:statu2  || orders.order_status=:statu3 ) ORDER BY orders.order_create DESC");
$orders->execute(array("dripfeed"=>1,"subs"=>1,"statu1"=>"pending","statu2"=>"inprogress","statu3"=>"processing"));
$orders = $orders->fetchAll(PDO::FETCH_ASSOC);
  foreach( $orders as $order ):
    $user   = $conn->prepare("SELECT * FROM clients WHERE client_id=:id ");
    $user->execute(array("id"=>$order["client_id"]));
    $user   = $user->fetch(PDO::FETCH_ASSOC);
    $order["balance"] =   $user["balance"];
    $clientBalance    =   $user["balance"];
    $orderid          =   $order["order_id"];
    if( $order["api_type"] == 1 ):
      ## Standart api başla ##
        $orderstatus= $smmapi->action(array('key' =>$order["api_key"],'action' =>'status','order'=>$order["api_orderid"]),$order["api_url"]);
        $balance    = $smmapi->action(array('key' =>$order["api_key"],'action' =>'balance'),$order["api_url"]);
        $api_charge = $orderstatus->charge;
        $statu      = str_replace(" ", "", strtolower($orderstatus->status));
        $start      = $orderstatus->start_count;
        $remains    = $orderstatus->remains;
          if( !$api_charge ): $api_charge = 0; endif;
            $currency   = $balance->currency;
      ## Standart api bitti ##
    elseif( $order["api_type"] == 3 ):
      $orderstatus= $fapi->query(array('cmd'=>'orderstatus','token' => $order["api_key"],'apiurl'=>$order["api_url"],'orderid'=>[$order["api_orderid"]]));
      $balance    = $fapi->query(array('cmd'=>'profile','token' =>$order["api_key"],'apiurl'=>$order["api_url"]));
      $api_charge = $orderstatus[$order["api_orderid"]]["order"]["price"];
      $statu      = str_replace(" ", "", strtolower($orderstatus[$order["api_orderid"]]["order"]["status"]));
      $start      = $orderstatus[$order["api_orderid"]]["order"]["counter"]["start_count"];
      $remains    = str_replace("+","-",$orderstatus[$order["api_orderid"]]["order"]["counter"]["remains"]);
        if( !$api_charge ): $api_charge = 0; endif;
      $currency   = "TRY";
      if( $currency == "TRY" ):
        $currencycharge = 1;
      elseif( $currency == "USD" ):
        $currencycharge = $settings["dolar_charge"];
      elseif( $currency == "EUR" ):
        $currencycharge = $settings["euro_charge"];
      endif;
    else:
    endif;

    if( empty( $start ) || !$start ):
      $start    = 0;
    endif;
    if( empty( $remains ) || !$remains ):
      $remains  = 0;
    endif;
    if( $remains > $order["order_quantity"] ):
      $remains  = $order["order_quantity"];
    endif;
    if( empty( $finish ) || !$finish ):
      $finish   = 0;
    endif;

   if( $statu == "canceled" || $statu == "cancel" || $statu == "cancelled" ):

    
    if ($order['refund'] == 1) {
        continue; 
    }

    $conn->beginTransaction();

    
    $update2 = $conn->prepare("UPDATE clients SET balance=:balance, spent=:spent WHERE client_id=:id ");
    $update2 = $update2->execute(array(
        "id" => $order["client_id"],
        "balance" => $order["balance"] + $order["order_charge"],
        "spent" => $order["spent"] - $order["order_charge"]
    ));

    
    $user = $conn->prepare("SELECT * FROM clients WHERE client_id=:id ");
    $user->execute(array("id" => $order["client_id"]));
    $user = $user->fetch(PDO::FETCH_ASSOC);

    
    $report = $conn->prepare("INSERT INTO client_report SET client_id=:id, action=:action, report_ip=:ip, report_date=:date ");
    $report = $report->execute(array(
        "date" => date("Y-m-d H:i:s"),
        "id" => $order["client_id"],
        "action" => "#" . $orderid . " Order numbered has been canceled and " . $order["order_charge"] . " refunded Old balance:" . $clientBalance . " / New balance:" . $user["balance"],
        "ip" => "127.0.0.1"
    ));


    $update = $conn->prepare("UPDATE orders SET order_detail=:detail, order_start=:start, order_finish=:finish, order_remains=:remains, order_status=:status, order_charge=:charge, api_charge=:api_charge, order_profit=:order_profit, refund=1 WHERE order_id=:id ");
    $update = $update->execute(array(
        "id" => $orderid,
        "start" => $start,
        "finish" => $finish,
        "detail" => json_encode($orderstatus),
        "remains" => $remains,
        "status" => "canceled",
        "charge" => 0,
        "api_charge" => 0,
        "order_profit" => 0
    ));

    if( $update && $update2 && $report ):
        $conn->commit();
    else:
        $conn->rollBack();
    endif;

          
      elseif( $statu == 'complete' || $statu == 'completed' ):
        $conn->beginTransaction();
        $report = $conn->prepare("INSERT INTO client_report SET client_id=:id, action=:action, report_ip=:ip, report_date=:date ");
        $report = $report->execute(array("date"=>date("Y-m-d H:i:s"),"id"=>$order["client_id"],"action"=>"#".$orderid." Order number of has been completed.","ip"=>"127.0.0.1" ));
        $update = $conn->prepare("UPDATE orders SET order_start=:start, order_finish=:finish, order_remains=:remains, order_status=:status, order_remains=:remains, order_detail=:detail, api_charge=:api_charge, order_profit=:order_profit WHERE order_id=:id ");
        $update = $update->execute(array("start"=>$start,"finish"=>$finish,"remains"=>0,"status"=>"completed","detail"=>json_encode($orderstatus),"id"=>$orderid,"order_profit"=>$order["order_charge"]-$api_charge,"api_charge"=>$api_charge,"remains"=>$remains));
          if( $update && $report ):
            $conn->commit();
          else:
            $conn->rollBack();
          endif;
      elseif( $statu == 'pending' ):
        if( $start == 0 ):
          $start = $order["order_start"];
        endif;
        $conn->beginTransaction();
        $update = $conn->prepare("UPDATE orders SET order_start=:start, order_finish=:finish, order_status=:status, order_remains=:remains, order_detail=:detail, api_charge=:api_charge, order_profit=:order_profit WHERE order_id=:id ");
        $update = $update->execute(array("start"=>$start,"finish"=>$finish,"status"=>"pending","detail"=>json_encode($orderstatus),"remains"=>$remains,"id"=>$orderid,"order_profit"=>$order["order_charge"]-$api_charge,"api_charge"=>$api_charge));
          if( $update ):
            $conn->commit();
          else:
            $conn->rollBack();
          endif;
      elseif( $statu == 'inprogress' || $statu == 'in progress'  ):
        if( $start == 0 ):
          $start = $order["order_start"];
        endif;
        $conn->beginTransaction();
        $update = $conn->prepare("UPDATE orders SET order_start=:start, order_finish=:finish, order_status=:status, order_remains=:remains, order_detail=:detail, api_charge=:api_charge, order_profit=:order_profit WHERE order_id=:id ");
        $update = $update->execute(array("start"=>$start,"finish"=>$finish,"status"=>"inprogress","detail"=>json_encode($orderstatus),"remains"=>$remains,"id"=>$orderid,"order_profit"=>$order["order_charge"]-$api_charge,"api_charge"=>$api_charge));
          if( $update ):
            $conn->commit();
          else:
            $conn->rollBack();
          endif;
      elseif( $statu == 'processing'  ):
        if( $start == 0 ):
          $start = $order["order_start"];
        endif;
        $conn->beginTransaction();
        $update = $conn->prepare("UPDATE orders SET order_start=:start, order_finish=:finish, order_status=:status, order_remains=:remains, order_detail=:detail, api_charge=:api_charge, order_profit=:order_profit WHERE order_id=:id ");
        $update = $update->execute(array("start"=>$start,"finish"=>$finish,"status"=>"processing","detail"=>json_encode($orderstatus),"remains"=>$remains,"id"=>$orderid,"order_profit"=>$order["order_charge"]-$api_charge,"api_charge"=>$api_charge));
          if( $update ):
            $conn->commit();
          else:
            $conn->rollBack();
          endif;
    elseif( $statu == "partial" ):

    // রিফান্ড চেক করুন
    if ($order['refund'] == 1) {
        continue; // যদি রিফান্ড হয়ে থাকে, তাহলে স্কিপ করুন
    }

    $conn->beginTransaction();

    // পার্শিয়াল রিফান্ডের হিসাব
    $return_price = ($order["order_charge"] / $order["order_quantity"]) * $remains;

    // ক্লায়েন্টের ব্যালেন্স এবং স্পেন্ট আপডেট
    $update2 = $conn->prepare("UPDATE clients SET balance=:balance, spent=:spent WHERE client_id=:id ");
    $update2 = $update2->execute(array(
        "id" => $order["client_id"],
        "balance" => $order["balance"] + $return_price,
        "spent" => $order["spent"] - $return_price
    ));

    // ক্লায়েন্ট তথ্য পুনরায় আনুন
    $user = $conn->prepare("SELECT * FROM clients WHERE client_id=:id ");
    $user->execute(array("id" => $order["client_id"]));
    $user = $user->fetch(PDO::FETCH_ASSOC);

    // রিপোর্ট লগে যোগ করুন
    $report = $conn->prepare("INSERT INTO client_report SET client_id=:id, action=:action, report_ip=:ip, report_date=:date ");
    $report = $report->execute(array(
        "date" => date("Y-m-d H:i:s"),
        "id" => $order["client_id"],
        "action" => "#" . $orderid . " Order numbered partially marked and " . $return_price . " refunded Old balance:" . $clientBalance . " / New balance:" . $user["balance"],
        "ip" => "127.0.0.1"
    ));

    // অর্ডার আপডেট এবং রিফান্ড ফ্ল্যাগ সেট
    $update = $conn->prepare("UPDATE orders SET order_detail=:detail, order_start=:start, order_finish=:finish, order_remains=:remains, order_status=:status, order_charge=:charge, api_charge=:api_charge, order_profit=:order_profit, refund=1 WHERE order_id=:id ");
    $update = $update->execute(array(
        "id" => $orderid,
        "start" => $start,
        "finish" => $finish,
        "detail" => json_encode($orderstatus),
        "remains" => $remains,
        "status" => "partial",
        "charge" => $order["order_charge"] - $return_price,
        "api_charge" => $api_charge,
        "order_profit" => $order["order_charge"] - $api_charge
    ));

    if( $update && $update2 && $report ):
        $conn->commit();
    else:
        $conn->rollBack();
    endif;


          
      endif;

     $update   = $conn->prepare("UPDATE orders SET last_check=:check WHERE order_id=:id ");
     $update  -> execute(array("id"=>$orderid,"check"=>date("Y-m-d H:i:s") ));
  endforeach;