用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();
}