public function editorWidget($aFormValues) { $aContent = array(); $aContent['status'] = 'failed'; $aContent['message'] = ''; $aContent['isFormValid'] = false; $aFeedParameters = $aFormValues['textParam']; $oForm = new \JsonData\Admin\Form\FeedWidget(\JsonData\Admin\Form\FeedWidget::CONTEXT_SELECT_FEED, array(), array('feed_parameters' => $aFeedParameters)); if ($oForm->isValid($aFormValues)) { $aContent['isFormValid'] = true; ksort($aFeedParameters); $aInsertData = array(); $aInsertData['json_data_id'] = $aFormValues['hiddenFeedId']; $aInsertData['parameters'] = serialize($aFeedParameters); $aInsertData['last_update_time'] = date('Y-m-d H:i:s'); $aInsertData['last_display_time'] = date('Y-m-d H:i:s'); $oDaoJsonData = new \JsonData\Common\Model\Dao\JsonData(); $mStatus = $oDaoJsonData->insertJsonDataQueue($aInsertData); if (is_int($mStatus)) { $aFeed = $oDaoJsonData->fetchFeed($aInsertData['json_data_id']); $oFeed = new JsonDataFeed(); $oFeed->updateQueue($aInsertData['json_data_id'], $mStatus); $aContent['queue_id'] = $mStatus; $aContent['slug'] = $aFeed['feed_slug']; $aContent['status'] = 'success'; $aContent['message'] = 'Data successfully saved to database'; } else { $aContent['message'] = 'Failed to save data'; } } return $aContent; }
public function form($instance) { $aQueueData = array(); if (!empty($instance)) { $iQueueId = $instance['queue_id']; $oDaoJsonData = new \JsonData\Common\Model\Dao\JsonData(); $aQueueData = $oDaoJsonData->fetchSingleFeedQueue($iQueueId); $iFeedDataId = $aQueueData['json_data_id']; $aSingleFeed = $oDaoJsonData->fetchFeed($iFeedDataId); } $oDaoParticipantRegistry = new JDDao\JsonData(); $aFeedNames = $oDaoParticipantRegistry->getAllFeedNames(); include JsonData_Plugin_Dir . '/src/Admin/View/scripts/widget/sidebar.phtml'; }
public function getFeed() { $aContent = array('redirect' => false); $sRedirectUrl = menu_page_url(\JsonData\Admin\Controller\Home::MENU_SLUG, false); if (!isset($_GET['id'])) { $aContent['redirect'] = $sRedirectUrl; return $aContent; } $iId = (int) $_GET['id']; $oDaoFeed = new JDDao\JsonData(); $aDetail = $oDaoFeed->fetchFeed($iId); if (is_null($aDetail)) { $aContent['redirect'] = $sRedirectUrl; return $aContent; } $aContent['detail'] = $aDetail; return $aContent; }
public function display($aAttributes) { $oDaoJsonData = new JsonDataDao(); $sFeedSlug = $aAttributes['slug']; unset($aAttributes['slug']); $aFeed = $oDaoJsonData->fetchFeedBySlug($sFeedSlug); $iFeedId = $aFeed['id']; $aDefaultParameters = unserialize($aFeed['feed_parameters']); ksort($aAttributes); ksort($aDefaultParameters); $aNewKeys = array_diff($aAttributes, $aDefaultParameters); $aAllParams = array_merge($aDefaultParameters, $aNewKeys); ksort($aAllParams); $aAttributes = array_combine(array_keys($aAllParams), $aAttributes); ksort($aAttributes); $sSerializedParameters = serialize($aAttributes); $aFeedDetail = $oDaoJsonData->fetchSingleFeedQueueByParams($iFeedId, $sSerializedParameters); if (!$aFeedDetail) { $aInsertData = array(); $aInsertData['json_data_id'] = $iFeedId; $aInsertData['parameters'] = $sSerializedParameters; $aInsertData['last_update_time'] = date('Y-m-d H:i:s'); $aInsertData['last_display_time'] = date('Y-m-d H:i:s'); $mStatus = $oDaoJsonData->insertJsonDataQueue($aInsertData); if (is_int($mStatus)) { $oFeed = new JsonDataFeed(); $oFeed->updateQueue($iFeedId, $mStatus); $aFeedDetail = $oDaoJsonData->fetchSingleFeedQueueByParams($iFeedId, $sSerializedParameters); } } if ($aFeedDetail) { $iFeedId = $aFeedDetail['json_data_id']; $iFeedQueueId = $aFeedDetail['id']; $oDaoJsonData->updateDisplayTime($iFeedQueueId); $this->enqueueFrontEndCss($iFeedId, $sFeedSlug); $sData = file_get_contents(JsonData_Cache_Dir . DIRECTORY_SEPARATOR . $sFeedSlug . DIRECTORY_SEPARATOR . 'data-' . $iFeedQueueId . '.json'); $aData = json_decode($sData, true); require JsonData_Cache_Dir . $sFeedSlug . DIRECTORY_SEPARATOR . 'template.phtml'; } }
public function makePreview($slug) { $oDaoJsonData = new \JsonData\Common\Model\Dao\JsonData(); $aDetail = $oDaoJsonData->fetchFeedBySlug($slug); if ($aDetail) { $aParams = unserialize($aDetail['feed_parameters']); $sParams = ''; foreach ($aParams as $k => $v) { $sParams .= ' ' . $k . '="' . $v . '"'; } $sShortcode = '[jsondata_feed slug="' . $slug . '"' . $sParams . ']'; $args = array('post_type' => 'jdata', 'post_status' => 'draft', 'name' => 'jsondata-' . $slug); $the_query = new \WP_Query($args); $aPosts = $the_query->get_posts(); // Post object $my_post = array('post_title' => 'JSON data preview ' . $slug, 'post_name' => 'jsondata-' . $slug, 'post_content' => $sShortcode, 'post_status' => 'draft', 'post_type' => 'jdata', 'post_author' => 1); if ($the_query->post_count === 0) { // Insert the post into the database $id = wp_insert_post($my_post); } else { $id = $aPosts[0]->ID; $my_post['ID'] = $id; wp_update_post($my_post); } wp_reset_postdata(); //header('Location: '. get_permalink($id)); // die(); } }
/** * remove unused queue * @param int $iFeedQueueId */ private function _removeQueueFiles($iFeedQueueId) { $oDaoJsonData = new JsonDataDao(); $aFeedQueue = $oDaoJsonData->fetchSingleFeedQueue($iFeedQueueId); $sDirName = $this->_sCacheDirName . DIRECTORY_SEPARATOR . $aFeedQueue['json_data_id']; unlink($sDirName . DIRECTORY_SEPARATOR . 'data-' . $iFeedQueueId . '.json'); $oDaoJsonData->deleteFeedQueue($iFeedQueueId); }
public static function doUninstall() { $oDaoRegister = new Common\Model\Dao\JsonData(); $oDaoRegister->deleteTable(); // delete_option(Config::OPTION_NAME_GOOGLE_MAPS_API_KEY); // delete_option(Config::OPTION_NAME_GOOGLE_MAPS_DEFAULT_ZOOM_FACTOR); // delete_option(Config::OPTION_NAME_GOOGLE_MAPS_DEFAULT_CENTER_POINT); }
public function remove() { $aContent = array(); $aContent['redirect'] = JDConfig::getHomeRedirectUrl(); if (!isset($_GET['id'])) { } $iId = $_GET['id']; $oDaoJsonData = new JsonDataDao(); $aDetail = $oDaoJsonData->fetchFeed($iId); if (!empty($aDetail)) { $bStatus = $oDaoJsonData->deleteFeed($iId); if (is_int($bStatus)) { $aFeedQueues = $oDaoJsonData->fetchFeedQueue($iId); //get all feedques with same id $aToBeDeleteId = array(); foreach ($aFeedQueues as $aFeedRaw) { $aToBeDeleteId[] = $aFeedRaw['id']; } array_map(array(&$oDaoJsonData, 'deleteFeedQueue'), $aToBeDeleteId); //delete all feed associate with id $oFeed = new JsonDataFeed(); $oFeed->removeFeedDir($aDetail['feed_slug']); //remove files and directory } } // var_dump($bStatus); // var_dump(JDConfig::getHomeRedirectUrl()); // die(); if ($bStatus != false) { $aContent['redirect'] = JDConfig::getHomeRedirectUrl(); } return $aContent; }
private function _getFeedNames() { $oDaoParticipantRegistry = new JDDao\JsonData(); $aFeedNames = $oDaoParticipantRegistry->getAllFeedNames(); return $aFeedNames; }