public function sidebarWidget($aFormValues) { $aContent = array(); $aContent['status'] = 'failed'; $oDaoJsonData = new JsonDataDao(); if (!empty($aFormValues)) { $aInsertData = array(); $aFeedParameters = array(); foreach ($aFormValues as $sKey => $sFormValue) { if ($sKey != 'hiddenFeedId' && $sKey != 'hiddenQueueId' && $sKey != 'selectFeedName' && $sKey != 'title') { $aFeedParameters[$sKey] = $sFormValue; } } $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(); if (isset($aFormValues['hiddenQueueId']) && $aFormValues['hiddenQueueId'] != '') { $bStatus = $oDaoJsonData->updateFeedQueue($aInsertData, $aFormValues['hiddenQueueId']); $mStatus = $aFormValues['hiddenQueueId']; } else { $mStatus = $oDaoJsonData->insertJsonDataQueue($aInsertData); } if (is_int($mStatus)) { $oFeed = new JsonDataFeed(); $oFeed->updateQueue($aInsertData['json_data_id'], $mStatus); $aContent['queue_id'] = $mStatus; $aContent['hiddenFeedId'] = $aInsertData['json_data_id']; $aContent['status'] = 'success'; $aContent['message'] = 'Data successfully saved to database'; } else { $aContent['message'] = 'Failed to save data'; } } return $aContent; }
private function _updateSingleQueue($mFeed, $mQueue) { $oDaoJsonData = new JsonDataDao(); if (!is_array($mFeed)) { $aFeed = $oDaoJsonData->fetchFeed($mFeed); } else { $aFeed = $mFeed; } if (!is_array($mQueue)) { $aFeedQueue = $oDaoJsonData->fetchSingleFeedQueue($mQueue); } else { $aFeedQueue = $mQueue; } $iFeedId = $aFeed['feed_slug']; $sDirName = $this->_sCacheDirName . DIRECTORY_SEPARATOR . $iFeedId; //build url for queue $aUrl = explode('?', $aFeed['feed_url']); $sRootUrl = $aUrl[0]; $iQueueId = $aFeedQueue['id']; $sQueueDataFilename = $sDirName . DIRECTORY_SEPARATOR . 'data-' . $iQueueId . '.json'; //$iFeedId = $aFeedQueue['json_data_id']; $aQueueParams = unserialize($aFeedQueue['parameters']); $sUrlParams = http_build_query($aQueueParams); $sQueueUrl = $sRootUrl . '?' . $sUrlParams; //write json to cache file $sJsonData = file_get_contents($sQueueUrl); $fQueueData = fopen($sQueueDataFilename, 'w+'); fwrite($fQueueData, $sJsonData); fclose($fQueueData); chmod($sQueueDataFilename, 0755); $oDaoJsonData->updateFeedQueue(array('last_update_time' => date('Y-m-d H:i:s')), $iQueueId); }