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; }