<?php
|
/*
|
* $Author :PHPYUN开发团队
|
*
|
* 官网: http://www.phpyun.com
|
*
|
* 版权所有 2009-2021 宿迁鑫潮信息技术有限公司,并保留所有权利。
|
*
|
* 软件声明:未经授权前提下,不得用于商业运营、二次开发以及任何形式的再次发布。
|
*/
|
/************
|
* 计划任务:每日自动更新部分职位
|
* 仅作参考
|
*/
|
global $db_config,$db;
|
|
$stime = time()-86400*31;
|
$query = $db->query("SELECT r1.id FROM $db_config[def]company_job AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM $db_config[def]company_job)) AS id) AS r2 WHERE r1.id >= r2.id AND `sdate`>'".$stime."' AND `state`=1 AND `r_status`<>2 AND `status`<>1 ORDER BY r1.id ASC LIMIT 30");
|
|
|
while($rs = $db->fetch_array($query))
|
{
|
$LastTime = strtotime('-'.rand(1,59).' minutes', time());
|
$db->query("update $db_config[def]company_job set `lastupdate`='".$LastTime."' where `id`='".$rs['id']."'");
|
// $db->update_all("company_job","`lastupdate`='".$LastTime."'","`id`='".$rs['id']."'");
|
}
|
|
|
?>
|