xyzshop/test/refill/TestPartModel.php

<?php

/**
 * Created by PhpStorm.
 * User: stanley-king
 * Date: 2017/5/25
 * Time: 上午10:21
 */

define('APP_ID', 'test');
define('BASE_ROOT_PATH', str_replace('/test/refill', '', dirname(__FILE__)));
require_once(BASE_ROOT_PATH . '/global.php');
require_once(BASE_CORE_PATH . '/lrlz.php');
require_once(BASE_ROOT_PATH . '/fooder.php');
require_once(BASE_HELPER_PATH . '/refill/XYZRefillFactory.php');

use PHPUnit\Framework\TestCase;
class TestPartModel extends TestCase
{
    public static function setUpBeforeClass() : void
    {
        Base::run_util();
    }

    public function testCalcPartition()
    {
        $this->assertEquals("foo", 123);

        $p1 = refill\util::part_query();

        $time = strtotime('2022-10-01');
        $p2 = refill\util::part_query($time);

        $time = strtotime('2022-10-18');
        $p3 = refill\util::part_query($time);


        $p1 = refill\util::part_notify();

        $time = strtotime('2022-10-01');
        $p2 = refill\util::part_refill($time);

        $time = strtotime('2022-10-18');
        $p3 = refill\util::part_refill($time);

        $p1 = refill\util::part_vr_create();
    }

    public function testAddTime()
    {
        $part_calcer = function ($add_time)
        {
            $namer = function ($time) {
                return 'p' . date('Ym', $time);
            };

            if (defined('DB_PARTIONED') && DB_PARTIONED)
            {
                if (is_string($add_time)) {
                    $add_time = intval($add_time);
                }

                if ($add_time == 0) {
                    return '';

                } else {
                    return $namer($add_time);
                }
            }
            else {
                return '';
            }
        };

        $x = $part_calcer(strtotime('2022-10-01'));
        $x = $part_calcer(0);
        $y = 0;
    }

    public function testVrOrderTime()
    {
        $x = refill\util::part_vr_order_time(strtotime('2022-09-30'));
        $vr_order = Model('vr_order');
        $y = $vr_order->getOrderInfoForNotify(['order_sn' => '5993560715963417002151']);
    }






    //refill_detail
    public function testDetailExist()
    {
        $refill_order = Model('refill_order');
        $items = $refill_order->table('refill_detail')->field('detail_id')->where(['mchid' => 10202,'mch_order' => '67321661189767693386'])->select();
    }

    public function testDetailPartion()
    {
        $refill_order = Model('refill_order');
        $items = $refill_order->table('refill_detail')->field('detail_id')->partition('p202210')->where(['mchid' => 10202,'mch_order' => '67321661189767693386'])->select();
    }
    public function testDetailPartions()
    {
        $refill_order = Model('refill_order');
        $items = $refill_order->table('refill_detail')->field('detail_id')->partition(['p202209','p202210'])->where(['mchid' => 10202,'mch_order' => '67321661189767693386'])->select();
    }

    public function testDetailUpdate()
    {
        $refill_order = Model('refill_order');
        $items = $refill_order->table('refill_detail')->where(['mchid' => 10202,'mch_order' => '67321661189767693386'])->update(['order_state' => 50]);
    }
    public function testDetailPartsUpdate()
    {
        $refill_order = Model('refill_order');
        $items = $refill_order->table('refill_detail')->partition(['p202209','p202210'])->where(['mchid' => 10202,'mch_order' => '67321661189767693386'])->update(['order_state' => 50]);
    }

    //refill_order
    public function testRefillPartion()
    {
        $order_sn = '8905710715963417008880';
        $refill_order = Model('refill_order');
        $refill_info = $refill_order->getOrderInfo(['order_sn' => $order_sn]);
        if (!empty($refill_info)) {
            $order_time = $refill_info['order_time'];
            $part = refill\util::calc_part($order_time);
            $info = $refill_order->getOrderInfo(['order_sn' => $order_sn]);
            $info = $refill_order->partition($part)->getOrderInfo(['order_sn' => $order_sn]);

            $vr_order = Model('vr_order');
            $order_info = $vr_order->partition(refill\util::calc_part())->getOrderInfo(['order_sn' => $order_sn]);

            Log::record("info={$info}", Log::DEBUG);

            for ($i =0;$i<2000;$i++)
            {
                $refill_order->where(['order_id' => $refill_info['order_id']])->update(['commit_times' => ['exp', 'commit_times+1']]);
                $refill_order->partition($part);
                $refill_order->where(['order_id' => $refill_info['order_id']])->update(['commit_times' => ['exp', 'commit_times+1']]);
            }
//            $refill_order->partition($part);
//            $refill_order->where(['order_id' => $refill_info['order_id']])->delete();
        }
    }
}