用zendframework 已经有段时间了, 感觉用其开发很轻松,最近需要在linux下定时执行 一段php脚本。 参考了项目的框架结构,编写这个脚本(以下脚本部分业务相关的函数省略),放在crontab中执行,很正常。写篇日志记下,php项目不是天天碰,怕忘记。
<?php
$root = dirname(dirname(__FILE__));
$dumpDir = "$root/dump";
$listFile = "$dumpDir/list.csv";
if (!file_exists($listFile)) {
echo "please check list.csv file exist under dump directory";
return ;
}
$lib = "$root/library";
$app = "$root/application";
set_include_path($lib . PATH_SEPARATOR . $app . PATH_SEPARATOR . get_include_path());
require_once 'Zend/Loader.php';
Zend_Loader::registerAutoload();
$config = new Zend_Config_Ini("$app/config/install.ini");
if (!empty($config->database)) {
$datasource = $config->database->main;
} else {
throw new Scarab_Exception_Config('The DSN is not configured while using the database!');
}
$db = Zend_Db::factory($datasource);
Zend_Registry::set('db', $db);
$db->query("SET NAMES utf8");
$date = new Zend_Date(NULL, 'zh_CN');
require_once "$app/core/models/Synchronization.php";
require_once "$app/core/models/Tables.php";
$sync = new Sync();
$personList = parseFile($listFile);
try {
foreach ($personList as $item) {
$from = new Zend_Date($item[1], 'Y-m-d');
$to = new Zend_Date($item[2], 'Y-m-d');
if ($from->compare($to) > 0 ) {
continue;
}
while ($from->compare($to) < 0) {
$fromStr = $from->toString('Y-m-dd');
$from->add('1', Zend_Date::DAY);
$fromStr_ = $from->toString('Y-m-dd');
$dataOfHour = $sync->getAppXML($permid,$fromStr, $fromStr_);
if(!empty($dataOfHour)) {
$sync->saveToFile($dataOfHour,"$dumpDir/$name/$fromStr.hour.csv");
}
$dataOfminute = $sync->getAppDataXml($permid, $fromStr);
if (!empty($dataOfminute)) {
$sync->saveToFile($dataOfminute,"$dumpDir/$name/$fromStr.minute.csv");
}
}
}
} catch (Zend_Db_Exception $e) {
echo $e->getMessage();
}