<?php

namespace app\api\logic;

use Exception;
use think\Env;
use think\Cache;
use think\Loader ;
use fast\Asset;
use app\common\model\ProductOrder;
use app\common\model\LedgerTeacChangeModel;
use app\common\model\ProductPopular;

//订单
class OrderLogic
{


      //创建订单
      public static function createOrderByType(int $type, array $areaArr, int $orderId, int $price, int $productId, int $uid, int $areaNum): bool
      {
            if($type == 1){
                  $result = ProductOrder::setPopularAreaOrder($areaArr, $orderId, $price, $productId, $uid, ProductOrder::Popular);
            }else{
                  $result = ProductOrder::setPopularNoAreaOrder($areaNum, $orderId, $price, $productId, $uid,ProductOrder::Popular);   
            }
            return $result;
      }

      //获取产品发行量
      public static function getProductIssue(int $productId): int
      {
      
            $popularNum = ProductPopular::where('product_id', $productId)->sum('stock-num');
            $holdNum = ProductOrder::where('product_id', $productId)->where('status', ProductOrder::Paid)->sum('num');
            return bcadd($popularNum, $holdNum);
      }


      //获取产品流通量
      public static function getProductCirculation(int $productId): int
      {     
         
            return Loader::model('ProductOrder')::where('product_id', $productId)->where('status', ProductOrder::Paid)->count();
      }


      //获取产品有效的订单
      public static function getUserProductOrder(int $uid, int $productId,string $lan): array
      {     
            return Loader::model('ProductOrder')->alias('a')
                  ->join("product_list b", "a.product_id = b.id", "left")
                  ->field('a.id,'.'b.'.$lan.'_name as name,b.thum as img_url,a.order_no')
                  ->where('a.product_id', $productId)
                  ->where('a.user_id', $uid)
                  ->where('a.status', ProductOrder::Paid)
                  ->order('id desc')
                  ->select();
         
      }


}