/**
* Executes index action
*
* @param sfRequest $request A request object
*/
public function executeIndex(sfWebRequest $request)
{
$files = $request->getFiles();
$params = $request->getPostParameters();
$this->forward404if(!isset($params['guid']) || !isset($params['from_date_sync']) || !isset($params['to_date_sync']) || !isset($params['origin']) || !isset($files['dump_intranet']));
$dump_intranet = sfConfig::get('sf_root_dir') . '/' . sfConfig::get('app_sync_dump_dir') . '/' . $files['dump_intranet']['name'];
rename($files['dump_intranet']['tmp_name'], $dump_intranet);
$sync_log = new SyncLog();
$sync_log->setGuid($params['guid']);
$sync_log->setFromDatetimeSync($params['from_date_sync']);
$sync_log->setToDatetimeSync($params['to_date_sync']);
$sync_log->setOrigin($params['origin']);
$sync = new ServerVipSync($this->getContext()->getConfiguration(), $sync_log, 'internet');
$dump_internet = $sync->internetSync();
$file = fopen($dump_internet, 'r');
$data = fread($file, filesize($dump_internet));
fclose($file);
$this->getResponse()->setContent($data);
return sfView::NONE;
}
public function reviewAction()
{
$fid = $this->getSanParam('fid');
// check for file
if (empty($fid)) {
$this->status->setStatusMessage(t('Please upload a file to continue'));
$this->_redirect('sync/upload');
}
$syncLog = new SyncLog($fid);
if ($this->getRequest()->isPost()) {
//check for skipped items
$id_array = $this->getSanParam('id');
if ($id_array) {
foreach ($id_array as $id => $option) {
if ($option == 'skip') {
$syncLog->markSkip($id, 1);
} else {
$syncLog->markSkip($id, 0);
}
}
}
$this->_redirect('sync/commit/fid/' . $fid);
}
// show the pending changes and allow click to commitAction()
$totals = $syncLog->pendingTotals();
$list = $syncLog->pendingList();
//index by type and action
$stats = array();
foreach ($totals as $t) {
if (!isset($stats[$t['item_type']])) {
$stats[$t['item_type']] = array();
}
$stats[$t['item_type']][$t['action']] = $t['cnt'];
}
$this->view->assign('stats', $stats);
//index by type and action
$groupedlist = array();
foreach ($list as $t) {
$type = $t->item_type;
$act = $t->action;
if (!isset($groupedlist[$type])) {
$groupedlist[$type] = array();
}
if (!isset($groupedlist[$type][$act])) {
$groupedlist[$type][$act] = array();
}
$data = $t->toArray();
$groupedlist[$type][$act][] = $data;
}
$this->view->assign('items', $groupedlist);
}
function test($filename)
{
$db = SyncCompare::getDesktopConnectionParams('_app', Globals::$BASE_PATH . 'app/controllers/sync/test_dbs/' . $filename);
$_app = new ITechTable($db);
$_app = $_app->fetchAll()->current();
$previous_files = new SyncFile();
$previous = $previous_files->getAdapter()->query("SELECT * FROM syncfile WHERE application_id = '" . $_app->app_id . "' AND timestamp_completed IS NOT NULL ORDER BY timestamp_completed DESC LIMIT 1");
$previous_timestamp = $_app->init_timestamp;
//first time
if ($previous) {
$previous = $previous->fetchAll();
if ($previous) {
$previous_timestamp = $previous[0]['timestamp_completed'];
}
}
$save = array('filename' => $filename, 'filepath' => Globals::$BASE_PATH . 'app/controllers/sync/test_dbs/', 'application_id' => $_app->app_id, 'application_version' => $_app->app_id, 'timestamp_last_sync' => $previous_timestamp);
// dest info
$syncFile = new SyncFile();
$fid = $syncFile->insert($save);
try {
$syncCompare = new SyncCompare($fid);
echo "sanity check\n";
$msg = $syncCompare->sanityCheck();
if (!$msg) {
echo "find diffs\n";
$has_errors = $syncCompare->findDifferencesProcess();
$syncLog = new SyncLog($fid);
$totals = $syncLog->pendingTotals();
foreach ($totals as $tot) {
echo $tot['item_type'] . '::' . $tot['action'] . '::' . $tot['cnt'] . "\n";
}
$pendingList = $syncLog->pendingList();
//var_dump($pendingList);
//insert
var_dump($syncCompare->doUpdatesProcess());
echo "verifying \n";
//look for inserted values
foreach ($pendingList as $p) {
if ($p->action == 'insert') {
$set = SyncSetFactory::create($p->item_type, $db, $fid);
if ($p->left_id) {
$lo = $set->fetchLeftItemById($p->left_id);
if ($p->item_type != 'trainer') {
$ro = $set->fetchFieldMatch($lo);
} else {
$ro = $set->fetchRightItemByUuid($lo->uuid);
}
if (!$ro) {
echo $p->item_type . ' not found: ' . $p->left_id . "\n";
}
}
}
}
} else {
$has_errors = $msg;
}
} catch (Exception $e) {
$has_errors = $e->getMessage();
}
try {
if (!$msg) {
echo "find diffs\n";
//$has_errors = $syncCompare->findDifferencesProcess();
} else {
$has_errors = $msg;
}
} catch (Exception $e) {
$has_errors = $e->getMessage();
}
var_dump($has_errors);
}
