简介

/usr/local/coreseek/bin/indexer -c /usr/local/coreseek/etc/9ku_mysql.conf --all --rotate

/usr/local/coreseek/bin/searchd -c /usr/local/coreseek/etc/9ku_mysql.conf

/usr/local/mmseg3/bin/mmseg -u /usr/local/mmseg3/etc/new.txt

UPDATE 9ku_singer_zhuanji as a, old_9ku.9ku_singer_zhuanji as b SET a.zjpubtime = b.zjpubtime WHERE a.id = b.id;

insert into 9ku_tongji_song (mid,zhishu,zong,zuori,qianri,benzhou,shangzhou,shangshangzhou,benyue,shangyue,shangshangyue,jinnian,qunian,qiannian,addtime)

select gqid,zhishu,zong,zuori,qianri,benzhou,shangzhou,shangshangzhou,benyue,shangyue,shangshangyue,jinnian,qunian,qiannian,addtime FROM tongjigequhuizong

http://www.tj.lss.gov.cn/tjsi_web/login.do?method=register

s

http://www.zzsi.com/

service nginxd restart

service httpd restart

/etc/init.d/nginx restart

/www/wdlinux/httpd-2.4.23/bin/apachectl

数据字典导出

select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.`COLUMNS` where TABLE_SCHEMA='jqugo_db'

wget http://10.174.100.43/9ku.tar

tar -cvf /usr/local/auto_bak/test.tar /usr/local/test

tar -xvf /usr/local/auto_bak/test.tar /usr/local/test

SELECT g.goods_id,g.goods_name,

g.provider_id AS supplier_id,(SELECT su.store_name FROM fq_supplier AS su WHERE su.id = g.provider_id) AS supplier_name,

g.cat_id,(SELECT c.cat_name FROM fq_category AS c WHERE c.cat_id = g.cat_id) AS cat_name,

g.brand_id,(SELECT b.brand_name FROM fq_brand070609 AS b WHERE b.brand_id = g.brand_id) AS brand_name,FROM_UNIXTIME(g.ctime)

FROM `fq_goods` as g WHERE g.ctime >1495670399;

SELECT w.id,w.uid,w.realname,w.bank_phone,w.tj_time,FROM_UNIXTIME(w.tj_time) as add_time,wc.`status` ,

cw.credit_total as '信用额度',cw.credit_usable as '可用额度',cw.pos_total as 'POS贷额度',cw.pos_usable as 'POS贷可用额度'

FROM fq_wallet as w

LEFT JOIN fq_wallet_check as wc on w.uid = wc.uid

LEFT JOIN fq_credit_wallet as cw ON wc.uid = cw.user_id

WHERE w.tj_time > 1508058222 ORDER BY w.tj_time DESC;

SELECT w.realname,CONCAT("||",w.bank_phone),CONCAT("||",w.id_card),CONCAT("||",FROM_UNIXTIME(w.tj_time)), wc.`status`,

CASE wc.`status` WHEN 7 THEN '审核中' WHEN 8 THEN '审核通过' WHEN 9 THEN '审核不通过' WHEN 10 THEN '已激活' END AS '状态',

cf.userid

FROM fq_wallet as w

LEFT JOIN fq_wallet_check as wc on w.uid = wc.uid

LEFT JOIN fq_credit_wallet as cw ON wc.uid = cw.user_id

LEFT JOIN fq_channel_fan as cf ON cf.userid = cw.user_id

WHERE wc.`status` >6 ORDER BY w.tj_time DESC;

public function wx_avatar(){

///www/wdlinux/apache_php/bin/php /www/web/jqugo_com/public_now/admin/default.php /Ossimage/wx_avatar

$user_list = M('user')->field('id,avatar')->where(array('id'=>1006))->select();

foreach($user_list as $k => $v){

if(!empty($v['avatar'])){

$img = $this->curl_file_get_contents($v['avatar']);

$path = ROOT_PATH.'Resource/Upload/head/';

$photo = time().random(8) . '.jpg';

file_put_contents($path . $photo, $img, true);

$img_url = OssUploadImage($path . $photo,'avatar');

if($img_url){

$result = M('user')->where(array('id' => $v['id']))->save(array('avatar' => $img_url));

}else{

echo $v['id']."----失败
";

}

echo $v['id']."--";

}

}

}

0 9 * * * sudo -uwww /www/wdlinux/apache_php/bin/php /www/web/api_jqugo_com/api/index.php ver_1_0/Zyread/read93

00 21 * * * mysqldump -uroot -p --ignore-table=jqugo_db.fq_bank_curl -F jqugo_db | gzip > /data/bak/jqugo_db-$(date +%Y%m%d-%H%M%S).sql.gz

20 10 * * * mysqldump -uroot -pwei123321xi weixi | gzip > /var/mysql_db_bak/bak/weixi_db-$(date +%Y%m%d-%H%M%S).sql.gz

rm -rf `find . -name '*.sql.gz' -mtime 10` #删除10天前的备份文件

*/2 * * * * /usr/local/php/bin/php /home/wwwroot/lf.imvixi.com/index.php qrcode/crontab

[root@iZ25ypka1akZ mysql_db_bak]# vim back.sh

#!/bin/sh

mysqldump -uroot -pwei123321xi weixi | gzip > /var/mysql_db_bak/bak/weixi_db-`date +%Y%m%d-%H%M%S`.sql.gz

cd /var/mysql_db_bak/bak/

rm -rf `find . -name '*.sql.gz' -mtime 10` #删除10天前的备份文件

/*

Debug::remark('begin');

2.// ...其他代码段

3.Debug::remark('end');

4.// ...也许这里还有其他代码

5.// 进行统计区间

6.echo Debug::getRangeTime('begin','end').'s';

*/

INSERT INTO `9ku_geci` (lrc,m_id) select lrc,music_id from 9ku_music_info_0 UNION

select lrc,music_id from 9ku_music_info_1 UNION

select lrc,music_id from 9ku_music_info_2 UNION

select lrc,music_id from 9ku_music_info_3 UNION

select lrc,music_id from 9ku_music_info_4 UNION

select lrc,music_id from 9ku_music_info_5 UNION

select lrc,music_id from 9ku_music_info_6 UNION

select lrc,music_id from 9ku_music_info_7 UNION

select lrc,music_id from 9ku_music_info_8 UNION

select lrc,music_id from 9ku_music_info_9

;

UPDATE 9ku_music_all , musiclist as b SET 9ku_music_all.hitstoday = b.HitsToday WHERE 9ku_music_all.id = b.ID;

UPDATE 9ku_music_all_mp3 as a, 9ku_music_all_mp3_copy as b SET a.mp3 = b.mp3,a.mp3_size=b.mp3_size,a.mp3_time=b.mp3_time WHERE a.music_id = b.music_id;

BEGIN

-- 点击不存在入库

insert into 9ku_tongji_song(mid,zhishu)

select mid,type from 9ku_tongji_song_tj where mid not in(select mid from 9ku_tongji_song where zhishu=1) and type = 1;

-- 更新当日点击数据

UPDATE 9ku_tongji_song as z, 9ku_tongji_song_tj as t

SET z.zong=z.zong+t.num,z.benzhou=z.benzhou+t.num,

z.benyue=z.benyue+t.num,z.jinnian=z.jinnian+t.num,

z.qianri=z.zuori,z.zuori=t.num

WHERE t.mid=z.mid and t.type=1 and z.zhishu=1;

-- 更新时间

UPDATE 9ku_tongji_song SET addtime = NOW();

-- declare @month int,@week int,@nian int;

set @y=DAYOFYEAR(now());

set @m=DAYOFMONTH(now());

set @w=DAYOFWEEK(now());

-- 到一周了，更新数据;

if @w=1

then

update 9ku_tongji_song set shangshangzhou=shangzhou,shangzhou=benzhou,benzhou=0;

end if;

-- 到一月了，更新数据

if @m=1

THEN

update 9ku_tongji_song set shangshangyue=shangyue,shangyue=benyue,benyue=0;

end if;

-- 到一年了，更新数据

If @y=1

THEN

update 9ku_tongji_song set qiannian=qunian,qunian=jinnian,jinnian=0;

end IF;

END

BEGIN

drop table if exists tmp_table_song;

CREATE TEMPORARY TABLE tmp_table_song(

id bigint auto_increment primary key,

sid bigint,

num bigint

);

INSERT INTO tmp_table_song(sid,num) select singer_id,count(id) as num from 9ku_music_all WHERE isdel = 0 GROUP BY singer_id;

-- 统计歌曲量开始

UPDATE 9ku_singer as s, tmp_table_song as t

SET s.total_song=t.num

WHERE s.id=t.sid;

END

########################

DELIMITER $

--

-- 函数

--

CREATE DEFINER=`root`@`localhost` FUNCTION `get_product_curise_count_by_branch_id`(`branch_id` int) RETURNS int(11)

BEGIN

#Routine body goes here...

DECLARE p_count INT;#旅游产品总数

DECLARE c_count INT;#游轮产品总数

SELECT COUNT(product_id) FROM travel_product WHERE admin_id = branch_id AND `status` = 5 AND belongs = 2 INTO p_count;

SELECT COUNT(product_id) FROM cruise_product WHERE admin_id = branch_id AND `status` = 2 AND belongs = 2 INTO c_count;

RETURN (p_count+c_count);

END$

DELIMITER ;

########################

?>

方式一：

$connection = Yii::$app->db;

$sql = "select * from hd_article where aid<".$aid." order by aid desc limit 1";

$command = $connection->createCommand($sql);

$res = $command->queryAll($sql);

方式二：

$query = new \yii\db\Query();

$query->select('pa_call.id,pa_call.tableid,pa_call.time as msgtime,pa_table_area.id as areaid,pa_table_area.areaname as area,pa_table.tablename,pa_call.message as msg,pa_call.new as needoper,pa_call.status as isdone,pa_employee.username as oper')

->from(Call::tableName())

->join('LEFT JOIN',Table::tableName(),'pa_call.tableid=pa_table.id')

->join('LEFT JOIN',Area::tableName(),'pa_table_area.id=pa_table.areaid')

->join('LEFT JOIN',Employee::tableName(),'pa_call.employeeid=pa_employee.id')

->where($where);

$command = $query->createCommand();

$data = $command->queryAll();