<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[yangpit的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/yangpit</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yangpit]]></copyright><item><title><![CDATA[按列写数据]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/126389950</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/126389950</guid><author>yangpit</author><pubDate>Wed, 17 Aug 2022 17:00:49 +0800</pubDate><description><![CDATA[按列写数据。]]></description><category></category></item><item><title><![CDATA[部门分组递归处理]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/125146112</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/125146112</guid><author>yangpit</author><pubDate>Mon, 06 Jun 2022 14:28:12 +0800</pubDate><description><![CDATA[1]]></description><category></category></item><item><title><![CDATA[PHP Laravel Email::send 发送邮件扩展]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/119479350</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/119479350</guid><author>yangpit</author><pubDate>Sat, 07 Aug 2021 10:10:58 +0800</pubDate><description><![CDATA[$localFilePath = storage_path()."/app/tous/sales_return/";
            $fileNameList = array_filter(array_map(function ($element){
                if ($element != '.' &amp;&amp; $element != '..'){
                    return $element;
                }
  ..]]></description><category></category></item><item><title><![CDATA[PHP 使用Redis批量调用接口推送数据]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/117702872</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/117702872</guid><author>yangpit</author><pubDate>Tue, 08 Jun 2021 15:00:59 +0800</pubDate><description><![CDATA[//组装接口发送数据
$r =  $this-&gt;getSign($push_data['content']);
$push_data['sign'] = $r[0];
$push_data['verifyCode'] = $r[1];
$redis_order_key = $this-&gt;getProjectKey($method,'order');
#使用Redis向列表头部添加值元素
Redis::lpush($redis_order_key,json_encode($push_data));]]></description><category></category></item><item><title><![CDATA[PHP 非对称加密用RSA 根据公钥私钥，进行分段加密，分段解密]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/115325922</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/115325922</guid><author>yangpit</author><pubDate>Tue, 30 Mar 2021 15:03:22 +0800</pubDate><description><![CDATA[/**
     * Notes:发送CURL请求和加密和解密方法
     * User: ypj
     * DateTime: 2021/3/23 10:58
     * @param $url
     * @param $data
     * @return bool|mixed|string
     */
    public static function sendCurl($url,$data){

        #对数据进行公钥加密
        $info = self::a]]></description><category></category></item><item><title><![CDATA[PHP 对称加密 RSA AES-128-CBC 模式加密解密]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/114257897</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/114257897</guid><author>yangpit</author><pubDate>Mon, 01 Mar 2021 11:02:55 +0800</pubDate><description><![CDATA[在这里插入代码片
	//解密方法 $data json
    public static function aesDe($data){
        $sysKey = 'testKey';
        $IV = 'testV';
        return openssl_decrypt(base64_decode($data),'AES-128-CBC', $sysKey, OPENSSL_RAW_DATA, $IV);
    }

    //加密方法 $data json
    pu]]></description><category></category></item><item><title><![CDATA[PHP 获取当前毫秒时间]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/112213780</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/112213780</guid><author>yangpit</author><pubDate>Tue, 05 Jan 2021 10:01:25 +0800</pubDate><description><![CDATA[public static function getMillisecond(){
        list($t1, $t2) = explode(' ', microtime());
        $str =(float)sprintf('%.0f', (floatval($t1) + floatval($t2)) * 1000);
        $millisecond = substr($str,10,13);
        $date = date("YmdHis").$millis...]]></description><category></category></item><item><title><![CDATA[Mysql 按分隔符拆分成多条记录]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/110963725</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/110963725</guid><author>yangpit</author><pubDate>Thu, 10 Dec 2020 19:29:01 +0800</pubDate><description><![CDATA[SELECT *,
SUBSTRING_INDEX(SUBSTRING_INDEX(IFNULL(t.bz11,''),',',help_topic_id+1),',',-1) gp_idserie
FROM table t INNER JOIN  mysql.help_topic b ON b.help_topic_id &lt;  (LENGTH(IFNULL(t.bz11,'')) - LENGTH(REPLACE(IFNULL(t.bz11,''), ',', '')) + 1) and int..]]></description><category></category></item><item><title><![CDATA[PHP获取当前毫秒时间戳]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/110950955</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/110950955</guid><author>yangpit</author><pubDate>Thu, 10 Dec 2020 13:16:39 +0800</pubDate><description><![CDATA[PHP获取毫秒时间戳
public static function getMillisecond(){
        list($t1, $t2) = explode(' ', microtime());
        $str =(float)sprintf('%.0f', (floatval($t1) + floatval($t2)) * 1000);
        $millisecond = substr($str,10,13);
        $date = date("YmdHis").]]></description><category></category></item><item><title><![CDATA[PHP RSA加密解密方法处理，需要用到K 和V 值 进行解密加密操作， V值可以为空值]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/110950895</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/110950895</guid><author>yangpit</author><pubDate>Thu, 10 Dec 2020 13:11:55 +0800</pubDate><description><![CDATA[PHP 对接 C# RSA 加密解密处理，需要用到K 和V 值 进行解密加密操作，
V值可以为空值
  //解密方法
    public static function aesDe($data){
        $sysKey = Config::get('effectim.effectim_crm_config')['CRM']['params']['sysKey'];
        $IV = Config::get('effectim.effectim_crm_config')['CRM'][']]></description><category></category></item><item><title><![CDATA[PHP通过数组插入数据表]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/108758349</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/108758349</guid><author>yangpit</author><pubDate>Wed, 23 Sep 2020 18:03:47 +0800</pubDate><description><![CDATA[public static function insertTable(table,table,table,newArr){
#循环拼接sql 插入表中
try{
$str = ‘’;
itemKey=arraykeys(itemKey= array_keys(itemKey=arrayk​eys(newArr[0]);
$a =’’;
$i = 0;
        foreach ($newArr as $key =&gt;$value){
            $sqlKey = '';
      ]]></description><category></category></item><item><title><![CDATA[larave-admin访问 not no find]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/105556030</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/105556030</guid><author>yangpit</author><pubDate>Thu, 16 Apr 2020 13:35:23 +0800</pubDate><description><![CDATA[原来nginx 默认：fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
root 项目目录指定后需要配置修改参数
fastcgi_param SCRIPT_FILENAME documentrootdocument_rootdocumentr​ootfastcgi_script_name;
然后重启nginx 服务


...]]></description><category></category></item><item><title><![CDATA[Mysql 根据不同单号修改文件名]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/103241597</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/103241597</guid><author>yangpit</author><pubDate>Mon, 25 Nov 2019 17:04:47 +0800</pubDate><description><![CDATA[#退货修改文件名 不同单号文件名不同
drop temporary table if exists order_num;
create temporary table if not exists order_num
select bq_no,
concat(‘SALES_RETURNS_’,DATE_FORMAT(NOW(),’%Y%m%d%H%i’),if(length(rownum)=1,co...]]></description><category></category></item><item><title><![CDATA[mysql单号内排序]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/102784617</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/102784617</guid><author>yangpit</author><pubDate>Mon, 28 Oct 2019 17:09:56 +0800</pubDate><description><![CDATA[CREATE DEFINER=bqiter_13@% FUNCTION kenzo_get_sales_line(_order_sn varchar(60),_line_no INT) RETURNS int(11)
BEGIN
DECLARE _return INT;
SET _return =(
select A.order_num from (
SELECT trans_num,line_p...]]></description><category></category></item><item><title><![CDATA[mysql 索引优缺点]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/90718684</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/90718684</guid><author>yangpit</author><pubDate>Fri, 31 May 2019 16:30:09 +0800</pubDate><description><![CDATA[1：联合索引  适用于最左匹配原则
例如 设置一个联合索引 三个字段 从最左边开始匹配，如果遇到没有使用索引，则这个索引后的设置的索引也将会失效。
遇到范围匹配时，索引也会失效。
2：不使用索引情况：当数值是字符串类型，条件没有加引号查找时则不会使用索引。
模糊匹配，百分号% 在前面 也不会使用索引如 select * from table A where name like “%杨”；
正确使用...]]></description><category></category></item><item><title><![CDATA[PHP curl请求]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/90236000</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/90236000</guid><author>yangpit</author><pubDate>Wed, 15 May 2019 14:29:37 +0800</pubDate><description><![CDATA[ch=curlinit();curlsetopt(ch = curl_init();
        curl_setopt(ch=curli​nit();curls​etopt(ch, CURLOPT_URL, this−&amp;gt;processUrl);//CRUL获取的内容赋值到变量curlsetopt(this-&amp;gt;processUrl);
        // CRUL...]]></description><category></category></item><item><title><![CDATA[方法]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/86715036</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/86715036</guid><author>yangpit</author><pubDate>Thu, 31 Jan 2019 15:01:36 +0800</pubDate><description><![CDATA[1 背景概述
作为一名刚刚入门的菜鸟级别的程序员，常会在做事方法和做事思路上面感到迷茫，找不到正确的思路和方法，影响工作效率。当遇到困难或者知识瓶颈的时候，做不出来不是借口，往往成功的人会去找解决的方法和思路，只有失败的人才会去找借口。不要遇见困难就退缩，寻求正确的方式，去击败困难，在困难中成长、进步。
本文档主要是笔者从参加工作后，所听、所学的个人认知与理解，今天总结出来希望能为大家提供帮助。
...]]></description><category></category></item><item><title><![CDATA[Laravel 运行]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/86673526</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/86673526</guid><author>yangpit</author><pubDate>Mon, 28 Jan 2019 10:50:40 +0800</pubDate><description><![CDATA[1、每一步：创建服务窗口实例：
Laravel 应用的所有请求入口都是 public/index.php 文件，所有请求都会被 web 服务器（Apache/Nginx）导向这个文件。 index.php 文件包含的
代码并不多，但是，这里是加载框架其它部分的起点。
index.php 文件载入 Composer 生成的自动加载设置，然后从 bootstrap/app.php 脚本获取 Larav...]]></description><category></category></item><item><title><![CDATA[laravel 5.5]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/86597104</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/86597104</guid><author>yangpit</author><pubDate>Tue, 22 Jan 2019 16:37:20 +0800</pubDate><description><![CDATA[图片找不到


]]></description><category></category></item><item><title><![CDATA[Laravel 5.5安装admin访问 出现4.4 问题]]></title><link>https://blog.youkuaiyun.com/yangpit/article/details/86572768</link><guid>https://blog.youkuaiyun.com/yangpit/article/details/86572768</guid><author>yangpit</author><pubDate>Mon, 21 Jan 2019 13:29:20 +0800</pubDate><description><![CDATA[

]]></description><category></category></item></channel></rss>