function run_di($task, $args) { ini_set("memory_limit", "1024M"); ini_set("display_errors", 1); define('SF_ROOT_DIR', sfConfig::get('sf_root_dir')); define('SF_APP', 'frontend'); define('SF_ENVIRONMENT', 'prod'); define('SF_DEBUG', true); require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php'; $databaseManager = new sfDatabaseManager(); $databaseManager->initialize(); $c = new Criteria(); $c->add(ImportPeer::STATUS, "error"); $c->add(ImportPeer::SIZE, 36511); $c->add(ImportPeer::SYSTEM, 3); $imports = ImportPeer::doSelect($c); foreach ($imports as $import) { $import->delete(); echo "."; } exit("\n"); }
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = ImportPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setLabel($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setSystem($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setSize($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setUser($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setStatus($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setUploadedAt($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setCreatedAt($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setUpdatedAt($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setPublicationStatus($arr[$keys[9]]); } }
public function executeUploadTrademarks() { $this->setLayout(false); if ($addPage = Document::getDocumentByExclusiveTag('website_page_add_new_trademark')) { $this->addTrademarkURL = $addPage->getHref(); } else { $this->addTrademarkURL = '#'; } $c = new Criteria(); $c->addDescendingOrderByColumn(TrademarkPeer::ID); $cr1 = $c->getNewCriterion(TrademarkPeer::FROM_SYSTEM, 1); $cr2 = $c->getNewCriterion(TrademarkPeer::FROM_SYSTEM, 11); $cr1->addOr($cr2); $c->add($cr1); $importsArr[1] = TrademarkPeer::doSelect($c); $c = new Criteria(); $c->addDescendingOrderByColumn(ImportPeer::ID); $c->add(ImportPeer::SYSTEM, 2); $importsArr[2] = ImportPeer::doSelect($c); $c = new Criteria(); $c->addDescendingOrderByColumn(ImportPeer::ID); $c->add(ImportPeer::SYSTEM, 3); $importsArr[3] = ImportPeer::doSelect($c); $this->importsArr = $importsArr; $this->statusColors = array('new' => '#202080', 'imported' => '#208010', 'error' => '#802020'); $this->reload = 0; if ($reload = $this->getRequestParameter('reload')) { $this->reload = $reload; } }
function run_import_session($task, $args) { ini_set("memory_limit", "6048M"); define('SF_ROOT_DIR', sfConfig::get('sf_root_dir')); define('SF_APP', 'frontend'); define('SF_ENVIRONMENT', 'prod'); define('SF_DEBUG', true); require_once SF_ROOT_DIR . DIRECTORY_SEPARATOR . 'apps' . DIRECTORY_SEPARATOR . SF_APP . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'config.php'; $databaseManager = new sfDatabaseManager(); $databaseManager->initialize(); //$request = sfContext::getInstance()->getRequest(); $ds = DIRECTORY_SEPARATOR; $root = sfConfig::get('sf_root_dir') . $ds . sfConfig::get('sf_web_dir_name') . $ds . "uploads" . $ds; _echo_cms_title('IMPORT-SESSION: Check for new imports'); // faster save!!! //sfConfig::set('sf_cache_objects', false); //sfConfig::set('sf_cache_relations', false); //sfConfig::set('sf_use_relations_cache', false); // check Imports status='new' $c = new Criteria(); //$c->add(ImportPeer::SYSTEM, 3); $c->add(ImportPeer::STATUS, 'new'); $newImports = ImportPeer::doSelect($c); //$newImport1 = Document::getDocumentInstance(548884); //$newImports = array($newImport1); foreach ($newImports as $newImport) { $zipFile = $newImport->getLabel(); _echo_cms("Importing file: {$zipFile}..."); $system = $newImport->getSystem(); if ($system == 2) { $start = $count = 0; $params = array($zipFile); try { $status = _import_oami($params, $start, $count); _echo_cms('Import #' . $newImport->getId() . ', status=' . $status); } catch (Exception $e) { $status = 'error'; } if ($status) { $newImport->setStatus($status); $newImport->save(); if ($status == 'imported') { // save Import Session object $is = new ImportSession(); $is->setLabel('Импорт сесия ' . date('d.m.Y')); $is->setImportId($newImport->getId()); $is->setStartId($start); $is->setTmCount($count); $is->save(); //_index_session($is->getId()); } } } else { if ($system == 3) { $start = $count = 0; $params = array($zipFile); try { $status = _import_wipo($params, $start, $count); _echo_cms('Import #' . $newImport->getId() . ', status=' . $status); } catch (Exception $e) { $status = 'error'; } if ($status) { $newImport->setStatus($status); $newImport->save(); if ($status == 'imported') { // save Import Session object $is = new ImportSession(); $is->setLabel('Импорт сесия ' . date('d.m.Y')); $is->setImportId($newImport->getId()); $is->setStartId($start); $is->setTmCount($count); $is->save(); //_index_session($is->getId()); } } } } } _echo_cms('--------------------------------------------------------------------------------'); _echo_cms("IMPORT-SESSION: Done!"); }
public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(ImportPeer::ID, $pks, Criteria::IN); $objs = ImportPeer::doSelect($criteria, $con); } return $objs; }