Description: 行舟画船
/** * RSA签名类 * 注意：公钥和私钥必须是一行字符串，并且去掉生成时的头部和尾部 * 带“----”的两行，并且注意去掉最后一行的换行 */ class Rsa { public $publicKey = ''; public $privateKey = ''; private $_privKey; private $encryptBlockSize = 117;//加密切割长度 private $decryptBlockSize = 128;//解密切割长度 /** * * private key */ private $_pubKey; /** * * public key */ private $_keyPath; /** * * the keys saving path */ /** * * the construtor,the param $path is the keys saving path */ function __construct($publicKey = null, $privateKey = null) { $this->setKey($publicKey, $priva
<?php $arr = [ ['id' => 1, 'parent_id' => 0, 'name' => 'root'], ['id' => 2, 'parent_id' => 1, 'name' => 'child_1'], ['id' => 3, 'parent_id' => 2, 'name' => 'child_1.1'], ['id' => 4, 'parent_id' => 2, 'name' => 'child_1.2'], ['id' => 5, 'parent_id' => 1, 'name' => 'child_2'], ['id' => 6, 'parent_id' => 5, 'name' => 'child_2.1'], ['id' => 7, 'parent_id' => 5, 'name' => 'child_2.2'], ['id' => 8, 'parent_id' => 2, 'name' => 'child_1.3'], ]; $initRight = 0; $depth = 0; $data = []; foreach ($arr as $key => $val)
-- 每日单量 select DATE_FORMAT(createtime,'%Y-%m-%d') as days,count( ) count from ibt_shop_order group by days; -- 每周单量 select DATE_FORMAT(createtime,'%Y-%u') as weeks,count( ) count from ibt_shop_order group by weeks; -- 每月单量 select DATE_FORMAT(createtime,'%Y-%m') as months,count( ) count from ibt_shop_order group by months; SELECT FROM jsc_order_refund where refund_status = 0 and refund_money > 1 -- 每季度 SELECT click_date as q,IFNULL(b.con,0) as c FROM(SELECT 1 as click_date UNION ALL SELECT 2 as click_date