qq_43278558-CSDN博客

原创 laravel：只用一条语句，查出一个表里，不同条件对应的数据条数

InfoSalesman::selectRaw("sum(if(position = ‘bc’ , 1 , 0 )) as bc,sum(if(position = ‘ba’ , 1 , 0 )) as ba")->where(‘store’, $val->store)->where(‘brand_name_bl’, $val->brand_name_bl)->first();

2021-09-18 15:51:25 328 1

原创超累人的sql（3）

SELECT P.DC_CODE, P.DC_NAME, A.park_code, P.park_name, A.ALC_DATE, A.ALC_TOTAL_NUM, A.SIGN_CAR_NUM, A.CAR_WAITING_OVERTIME_NUM, A.CAR_WORKING_OVERTIME_NUM, A.ALC_AVG_DURATION, CONCAT(TO_CHAR(ROUND(100*A.CAR_WAITI...

2021-03-31 14:16:30 93

原创超累人的sql（2）

SELECT P.DC_CODE, P.DC_NAME, P.PARK_NAME, A.PARK_CODE, A.ALC_DATE, L.LUWP_TOTAL_NUM, A.LUWP_USE_TOTAL_NUM, A.LUWP_WORK_NUM, CONCAT( TO_CHAR( ROUND( 100 * A.LUWP_USE_TOTAL_NUM / L.LUWP_TOTAL_NUM, 2 ), 'fm9999999990.00' ),...

2021-03-31 14:15:53 92

原创超累人的SQL

SELECT P.DC_CODE, P.DC_NAME, P.PARK_NAME, A.PARK_CODE, A.ALC_DATE, A.ALC_TOTAL_NUM, A.ALC_SYSTEM_NUM, CONCAT( TO_CHAR(ROUND( 100 * A.ALC_SYSTEM_NUM / A.ALC_TOTAL_NUM, 2 ),'fm9999999990.00'), '...

2021-03-31 14:14:51 74

原创 php动态拼接sql

$sql = "select * from inner_sys_dept where is_deleted = '0'";if (!empty($params['dept_name'])) {$sql .= "and dept_name like '%".$params['dept_name']."%'";}if (!empty($params['dept_code'])) {$sql .= ...

2021-02-23 11:53:21 188

原创 php使用curl发送Content-type为application/json的HTTP/HTTPS请求并返回状态码

$param = json_encode($data,JSON_UNESCAPED_UNICODE);//初使化init方法$ch = curl_init();//指定URLcurl_setopt($ch, CURLOPT_URL, $url);//设定请求后返回结果curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);//声明使用POST方式来进行发送curl_setopt($ch, CURLOPT_POST, 1);curl_seto

2020-06-22 17:37:55 843

原创 MySQL和Oracle的区别

(1) 对事务的提交 MySQL默认是自动提交，而Oracle默认不自动提交，需要用户手动提交，需要在写commit;指令或者点击commit按钮(2) 分页查询 MySQL是直接在SQL语句中写"select... from ...where...limit x, y",有limit就可以实现分页;而Oracle则是需要用到伪列ROWNUM和嵌套查询(3) 事务隔离级别 MySQL是read commited的隔离级别，而Oracle是repeatable read的隔离...

2020-06-12 18:44:49 127

原创 laravel文件图片上传

//上传图片public function upload(Request $request){if (!$request->hasFile('file')) {return $this->sendData(200, '');}$file = $request->file('file');if ($file->isValid()) {$orig...

2020-04-09 17:26:11 149

原创 PHP 二维数组根据某些字段去重但number相加

$pre = $prf = [];$pre_key = '';foreach ($salesOuts as $k => $info) {$key = $info->PRODUCTCD . '-' . $info->available_time . '-' . $info->origin_stock_no;if ($k === 0) {$pre[$key]...

2020-04-09 17:21:19 221

原创 laravel使用原生sql

$res = DB::select('SELECT * FROM `goods` WHERE `product_id` IN ( SELECT `product_id` FROM `goods` GROUP BY `product_id` HAVING count( `product_id` ) > 1 ) order By `product_id`,`stock_no`,`availabl...

2020-04-09 17:10:05 526

原创 PHP发送和接收XML数据

一、使用CURL发送数据<?PHP$xml_data = '<xml>xml</xml>';//发送的xml$url = 'http://localhost/xml/getXML.php';//接收XML地址$header[] = "Content-type: text/xml";//定义content-type为xml$ch = curl_ini...

2020-04-09 17:07:48 373

原创 laravel之with查找

yikus=Yiku::where(yikus = Yiku::where(yikus=Yiku::where(where)->whereHas(‘product’, function(q)use(q) use (q)use(params) {if (!empty($params[‘NewPRODUCTCD’])) $q->where(‘NewPRODUCTCD’, ‘like’...

2020-01-15 11:35:17 336

qq_43278558的博客