public static function AppDBSyncInitData()
{
global $application;
$db = $application->getBootstrap()->getResource('db');
$db->setFetchMode(Zend_Db::FETCH_BOTH);
$db->beginTransaction();
try {
$db->query("ALTER TABLE app_releases DISABLE TRIGGER rtr_app_releases_after;");
$db->query("ALTER TABLE app_releases DISABLE TRIGGER rtr_app_releases_before;");
$db->query("DELETE FROM app_releases;");
$rels = new Repository_Model_MetaProductReleases();
if (count($rels->items) > 0) {
foreach ($rels->items as $rel) {
$appreldata = self::collectReleaseData($rel->id);
$appreldata["releaseid"] = $rel->id;
$appreldata["action"] = "insert";
CommunityRepository::syncSoftwareRelease($appreldata);
}
}
$db->query("ALTER TABLE app_releases ENABLE TRIGGER rtr_app_releases_after;");
$db->query("ALTER TABLE app_releases ENABLE TRIGGER rtr_app_releases_before;");
$db->commit();
} catch (Exception $e) {
$db->rollback();
error_log("[APPDBSYNC_INIT]:" . $e->getMessage());
}
}
public function syncreleaseAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
header('Access-Control-Allow-Origin: *');
//Retrieve request data
$data = array("swid" => trim(isset($_POST["swid"]) ? $_POST["swid"] : ""), "releaseid" => trim(isset($_POST["releaseid"]) ? $_POST["releaseid"] : ""), "state" => trim(isset($_POST["state"]) ? $_POST["state"] : "1"), "manager" => trim(isset($_POST["manager"]) ? $_POST["manager"] : "0"), "series" => trim(isset($_POST["series"]) ? $_POST["series"] : ""), "release" => trim(isset($_POST["release"]) ? $_POST["release"] : ""), "addedon" => trim(isset($_POST["addedon"]) ? $_POST["addedon"] : ""), "publishedon" => trim(isset($_POST["publishedon"]) ? $_POST["publishedon"] : ""), "lastupdated" => trim(isset($_POST["lastupdated"]) ? $_POST["lastupdated"] : ""), "action" => trim(isset($_POST["action"]) ? $_POST["action"] : "insert"));
//Validate request
if (localRequest() == false || $_SERVER["REQUEST_METHOD"] != "POST" || is_numeric($data["releaseid"]) == false || in_array($data["action"], array("insert", "delete", "update")) == false) {
return;
}
//Execute request
$result = CommunityRepository::syncSoftwareRelease($data);
$result = $result === true ? "ok" : $result;
echo $result;
}
