public function render() { $value = 0; $value_id = 0; $aDataSource = $this->getDataSource(); $aDataSource[2]['Criteria']['ParentId'] = 0; $oDataProvider = new DataProvider($aDataSource); $oData = $oDataProvider->execute(); //echo '<pre>', print_r($oData, true), '</pre>'; die(); $aResult = array(); $aResult[] = array('Name' => $this->getDefaultText(), 'Value' => $this->getDefaultValue()); if ($this->getDefault()) { $aRs = array(); if (preg_match("#:(.*?)#isU", $this->getDefault(), $aRs)) { $value = Toolkit::getInstance()->request->get($aRs[1], Request::C_GET); } } if ($this->getValue()) { $value_id = $this->getValue(); } if ($oData->count() > 0) { $aResult = $this->getChilds($oData, 1, $aResult); } echo FormHelper::selectbox($this->getAlias(), $value_id, $aResult, array('class' => 'selectbox', 'id' => 'field_' . $this->getAlias())); }
public function render() { $value = 0; $value_id = 0; $oDataProvider = new DataProvider($this->getDataSource()); $oData = $oDataProvider->execute(); //echo '<pre>', print_r($oData, true), '</pre>'; die(); $aResult = array(); /*$aResult[] = array( 'Name' => $this->getDefaultText(), 'Value' => $this->getDefaultValue() ); */ if ($this->getDefault()) { $aRs = array(); if (preg_match("#:(.*?)#isU", $this->getDefault(), $aRs)) { $value = Toolkit::getInstance()->request->get($aRs[1], Request::C_GET); } } //echo 'val:', print_r($this->getValue()->toSimpleArray(), true); if ($this->getValue()) { $value_id = $this->getValue()->toSimpleArray(); } if ($oData->count() > 0) { foreach ($oData as $itm) { $getter = 'get' . $this->getValueField(); $aResultTmp = array('Value' => call_user_func(array($itm, $getter)), 'Name' => $this->getTextFormat()); $aRs = array(); if (preg_match_all("/:(.*):/iU", $aResultTmp['Name'], $aRs)) { foreach ($aRs[1] as $k => $val) { $value = $itm; if (strpos($val, "-") !== false) { $xVal = explode("-", $val); foreach ($xVal as $_val) { $sGetter = 'get' . $_val; $value = call_user_func(array($value, $sGetter)); } } else { $sGetter = 'get' . $val; $value = call_user_func(array($value, $sGetter)); } $aResultTmp['Name'] = str_replace($aRs[0][$k], $value, $aResultTmp['Name']); } } /*if (isset($aContainer['IsTree']) && $aContainer['IsTree'] == true) { $aResultTmp['Name'] = str_repeat(' |-- ', $itm->getTreeLevel() - 1).$aResultTmp['Name']; }*/ $aResult[] = $aResultTmp; } } $sResult = FormHelper::multiselect($this->getAlias() . '[]', $value_id, $aResult, array('class' => 'multiselect', 'id' => 'field_' . $this->getAlias())); if ($this->getExtended()) { $sResult .= '<script>$(document).ready( function() { $(\'#field_' . $this->getAlias() . '\').multiselect({sortable: false, searchable: false}); } );</script>'; } echo $sResult; }
public function render() { $value = 0; $value_id = 0; $aDataSource = $this->getDataSource(); if ($this->getIsTree()) { $aDataSource[2]['Criteria']['ParentId'] = 0; } $oDataProvider = new DataProvider($aDataSource); $oData = $oDataProvider->execute(); //echo '<pre>', print_r($oData, true), '</pre>'; die(); $aResult = array(); $aResult[] = array('Name' => $this->getDefaultText(), 'Value' => $this->getDefaultValue()); if ($this->getDefault()) { $aRs = array(); if (preg_match("#:(.*?)#isU", $this->getDefault(), $aRs)) { $value = Toolkit::getInstance()->request->get($aRs[1], Request::C_GET); } } if ($this->getValue()) { $value_id = $this->getValue(); } $aResult = $this->createRow($oData, $aResult); if ($this->getOnChange()) { $tmpChange = $this->getOnChange(); echo FormHelper::selectbox($this->getAlias(), $value_id, $aResult, array('class' => 'selectbox ajax_response_list', 'data-field' => $tmpChange[0], 'data-id' => $this->getValue(), 'id' => 'field_' . $this->getAlias())); //$.post('/structure/page_backend/typeParams', {Id: $this->getValue()}, function (data) { /* response */ }); } else { echo FormHelper::selectbox($this->getAlias(), $value_id, $aResult, array('class' => 'selectbox', 'id' => 'field_' . $this->getAlias())); } }
/** * Get all devices */ public function fetchAll() { $devices = json_decode($this->dataProvider->get('devices')->getBody()->__toString()); foreach ($devices->devices as $deviceData) { $device = new Device($deviceData, $this->dataProvider); $this->devices[$device->getId()] = $device; } }
function test_calc_step_division_by_zero() { $term = new stdClass(); $term->term_id = 1; $term->count = 1; $terms = array($term, $term); $data = $this->dataProvider->get_data_object(array(), $terms); $data->getTerms(); }
/** * @param int $hostuid * @return FtpUserModel|null */ public function getFtpUserByUid($hostuid) { $result = $this->dataProvider->findFtpUserByHostUid($hostuid); if (!$result) { return null; } $ftpUser = $this->dataProvider->createFtpUserFromResult($result); return $ftpUser; }
function execute($par) { global $wgOut; $this->setHeaders(); $topFiveArray = DataProvider::GetTopFiveArray(); if (empty($par)) { //no sub gets generic title $wgOut->setPageTitle("Top"); //use array keys of known modules to build menu to them $wgOut->addHtml("<ul>"); foreach ($topFiveArray[0] as $sub => $junk) { $wgOut->addHtml("<li><a href=\"" . SpecialPage::getTitleFor('Top', $sub)->getLocalUrl() . "\">" . wfMsg($sub) . "</a></li>"); } $wgOut->addHtml("</ul>"); return false; } if (count($topFiveArray) != 2 || !isset($topFiveArray[0][$par])) { $wgOut->setPageTitle("Error"); // par wasnt in known module list, so cant use for title return false; } //we can trust par for use in title now $wgOut->setPageTitle(wfMsg($par)); $wgOut->addHtml("<ul>"); $results = DataProvider::$topFiveArray[0][$par](25); if (is_array($results)) { foreach ($results as $val) { $wgOut->addHtml("<li><a href=\"{$val['url']}\">{$val['text']}</a></li>"); } } $wgOut->addHtml("</ul>"); }
/** * Handle incoming SMS from Twilio */ public function action_reply() { //Check if data provider is available $providers_available = Kohana::$config->load('features.data-providers'); if (!$providers_available['twilio']) { throw HTTP_Exception::factory(403, 'The Twilio data source is not currently available. It can be accessed by upgrading to a higher Ushahidi tier.'); } if ($this->request->method() != 'POST') { // Only POST is allowed throw HTTP_Exception::factory(405, 'The :method method is not supported. Supported methods are :allowed_methods', array(':method' => $this->request->method(), ':allowed_methods' => Http_Request::POST))->allowed(Http_Request::POST); } $provider = DataProvider::factory('twilio'); // Authenticate the request $options = $provider->options(); if ($this->request->post('AccountSid') !== $options['account_sid']) { throw HTTP_Exception::factory(403, 'Incorrect or missing AccountSid'); } // Remove Non-Numeric characters because that's what the DB has $to = preg_replace("/[^0-9,.]/", "", $this->request->post('To')); $from = preg_replace("/[^0-9,.]/", "", $this->request->post('From')); $message_text = $this->request->post('Body'); $message_sid = $this->request->post('MessageSid'); // @todo use other info from twillio, ie: location, media $provider->receive(Message_Type::SMS, $from, $message_text, $to, NULL, $message_sid); // If we have an auto response configured, return the response messages if (!empty($options['sms_auto_response'])) { $body = View::factory('twillio/sms_response')->set('response', $options['sms_auto_response'])->render(); // Set the correct content-type header $this->response->headers('Content-Type', 'text/xml'); $this->response->body($body); } }
public function action_index() { // Set up custom error view Kohana_Exception::$error_view = 'error/data-provider'; if ($this->request->method() != 'GET') { // Only GET is allowed as FrontlineSms does only GET request throw HTTP_Exception::factory(405, 'The :method method is not supported. Supported methods are :allowed_methods', array(':method' => $this->request->method(), ':allowed_methods' => Http_Request::GET))->allowed(Http_Request::GET); } $provider = DataProvider::factory('frontlinesms'); // Authenticate the request $options = $provider->options(); if (!isset($options['key']) or empty($options['key'])) { throw HTTP_Exception::factory(403, 'Key value has not been configured'); } if (!$this->request->query('key') or $this->request->query('key') != $options['key']) { throw HTTP_Exception::factory(403, 'Incorrect or missing key'); } if (!$this->request->query('m')) { throw HTTP_Exception::factory(403, 'Missing message'); } // Remove Non-Numeric characters because that's what the DB has $from = preg_replace('/\\D+/', "", $this->request->post('from')); $message_text = $this->request->query('m'); // If receiving an SMS Message if ($from and $message_text) { $provider->receive(Message_Type::SMS, $from, $message_text, $to); } $json = array('payload' => array('success' => TRUE, 'error' => NULL)); // Set the correct content-type header $this->response->headers('Content-Type', 'application/json'); $this->response->body(json_encode($json)); }
public function action_index() { // Set up custom error view Kohana_Exception::$error_view = 'error/data-provider'; //Check if data provider is available $providers_available = Kohana::$config->load('features.data-providers'); if (!$providers_available['smssync']) { throw HTTP_Exception::factory(403, 'The SMS Sync data source is not currently available. It can be accessed by upgrading to a higher Ushahidi tier.'); } $methods_with_http_request = [Http_Request::POST, Http_Request::GET]; if (!in_array($this->request->method(), $methods_with_http_request)) { // Only POST or GET is allowed throw HTTP_Exception::factory(405, 'The :method method is not supported. Supported methods are :allowed_methods', array(':method' => $this->request->method(), ':allowed_methods' => implode(',', $methods_with_http_request)))->allowed($methods_with_http_request); } $this->_provider = DataProvider::factory('smssync'); $this->options = $this->_provider->options(); // Ensure we're always returning a payload.. // This will be overwritten later if incoming or task methods are run $this->_json['payload'] = ['success' => TRUE, 'error' => NULL]; // Process incoming messages from SMSSync only if the request is POST if ($this->request->method() == 'POST') { $this->_incoming(); } // Attempt Task if request is GET and task type is 'send' if ($this->request->method() == 'GET' and $this->request->query('task') == 'send') { $this->_task(); } // Set the response $this->_set_response(); }
/** * Callback for 'gather' response on call to Twilio */ public function action_gather() { if ($this->request->method() != 'POST') { // Only POST is allowed throw HTTP_Exception::factory(405, 'The :method method is not supported. Supported methods are :allowed_methods', array(':method' => $this->request->method(), ':allowed_methods' => Http_Request::POST))->allowed(Http_Request::POST); } $provider = DataProvider::factory('twilio'); // Authenticate the request $options = $provider->options(); if ($this->request->post('AccountSid') !== $options['account_sid']) { // Could not authenticate the request? throw HTTP_Exception::factory(403, 'Incorrect or missing AccountSid'); } // Remove Non-Numeric characters because that's what the DB has $to = preg_replace("/[^0-9,.]/", "", $this->request->post('To')); $from = preg_replace("/[^0-9,.]/", "", $this->request->post('From')); $message_sid = $this->request->post('CallSid'); $digits = $this->request->post('Digits'); if ($digits == 1) { $message_text = 'IVR: Okay'; } else { if ($digits == 2) { $message_text = 'IVR: Not Okay'; } else { // HALT Kohana::$log->add(Log::ERROR, __("':digits' is not a valid IVR response", array(":digits" => $digits))); return; } } $provider->receive(Message_Type::IVR, $from, $message_text, $to, NULL, $message_sid); }
function CheckLoginInDB($username, $password) { if (empty($username) || empty($password)) { $this->HandleError("Tên đăng nhập / Mật khẩu không được để trống"); return -1; } else { //$password = md5($password); //$connection = mysqli_connect("localhost","root","","tapdoc"); //$query = mysqli_query($connection, "SELECT * FROM taikhoan WHERE tk_TenDangNhap='$username' AND tk_MatKhau = '$password'"); $sql = "SELECT * FROM taikhoan WHERE tk_TenDangNhap='{$username}' AND tk_MatKhau = '{$password}'"; $query = DataProvider::ExecuteQuery($sql); $rows = mysqli_num_rows($query); if ($rows == 1) { $id = -1; while ($row = $query->fetch_assoc()) { $id = $row["tk_ID"]; } //mysqli_close($connection); return $id; } else { $this->HandleError("Tên đăng nhập / Mật khẩu không hợp lệ"); } //mysqli_close($connection); } }
/** * User constructor */ public function __construct() { parent::__construct(); $this->name = ""; $this->table = ARCDBPREFIX . "companies"; $this->map = ["id" => "id", "name" => "name"]; $this->columns = ["id", "name"]; }
function WidgetTopContentGetSectionsList() { wfProfileIn(__METHOD__); $provider =& DataProvider::singleton(); list($links, $active) = $provider->GetTopFiveArray(); unset($links['community']); wfProfileOut(__METHOD__); return array(0 => $links, 1 => $active); }
public static function delete($id) { $strSQL = "delete from thuchi where id={$id}"; $result = DataProvider::Query($strSQL); if (mysql_affected_rows() == 0) { return null; } return mysql_fetch_row($result, MYSQL_BOTH); }
public static function GetPhapLyById($id) { $strSQL = "select *\r\n\t\t\t\t\tfrom tinhtrangphaply where id='{$id}'"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } return mysql_fetch_array($result); }
public static function getALL() { $strSQL = "select * from loaidichvu"; $result = DataProvider::Query($strSQL); while ($row = mysql_fetch_row($result, MYSQL_BOTH)) { $return[] = $row; } return $return; }
public static function GetTTNDByID($id) { $strSQL = "select * \r\n\t\t\t\t\t from loaidichvu\r\n\t\t\t\t\t where id='{$id}'"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } return mysql_fetch_array($result); }
public static function GetAllTienIchId($id) { $strSQL = "select *\r\n\t\t\t\t\t from tienich where id='{$id}'"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } return mysql_fetch_array($result); }
/** * UserPermission constructor */ public function __construct() { parent::__construct(); $this->groupid = 0; $this->permission = ""; $this->table = ARCDBPREFIX . 'user_permissions'; $this->map = ["id" => "id", "groupid" => "groupid", "permission" => "permission"]; $this->columns = ['id', 'groupid', 'permission']; }
public static function GetHuongNhaById($id) { $strSQL = "select *\r\n\t\t\t\t\tfrom huongnha where id='{$id}'"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } return mysql_fetch_array($result); }
public static function GetAll() { $strSQL = "\tselect * \r\n\t\t\t\t\t\tfrom user_role \t\t\t\t\r\n\t\t\t\t\t\t"; $result = DataProvider::Query($strSQL); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $return[] = $row; } return $return; }
public function __construct() { parent::__construct(); $this->event = date("y-m-d H:i:s"); $this->message = ""; $this->table = ARCDBPREFIX . 'logs'; $this->map = ["id" => "id", "type" => "type", "module" => "module", "event" => "event", "message" => "message"]; $this->columns = ['id', 'type', 'module', 'event', 'message']; }
public static function selectId($id) { $strSQL = "select * from donvidichvu where id='{$id}'"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } return mysql_fetch_row($result, MYSQL_BOTH); }
/** @param $prefix String to help locate the $target Removes all entries from the CacheProvider. */ public static function cleanCache($prefix = '') { foreach (DataProvider::getStudies() as $s) { $f = self::getPath($s, $prefix); if (file_exists($f)) { unlink($f); } } }
public static function getTinhById($id) { $strSQL = "select *\r\n\t\t\t\t\tfrom tinh where id={$id}"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } return mysql_fetch_row($result, MYSQL_BOTH); }
/** * Get all enabled providers, with their configuration data. * @return Array */ protected function getAllProviders($enabled = false) { if ($enabled) { // Returns all *enabled* providers. return \DataProvider::get_enabled_providers(); } else { // Returns all providers, even if they are disabled. return \DataProvider::get_providers(); } }
function WidgetNewPages($id, $params) { wfProfileIn(__METHOD__); $items = array(); if (class_exists('DataProvider')) { $items = DataProvider::singleton()->GetNewlyCreatedArticles(); } wfProfileOut(__METHOD__); return count($items) > 0 ? WidgetFramework::wrapLinks($items) . WidgetFramework::moreLink(Title::newFromText('Newpages', NS_SPECIAL)->getLocalURL()) : wfMsg('widget-empty-list'); }
protected function execute_outgoing(InputInterface $input, OutputInterface $output) { $providers = $this->get_providers($input, $output); $limit = $input->getOption('limit'); $totals = []; foreach ($providers as $id => $provider) { $totals[] = ['Provider' => $provider->name, 'Total' => \DataProvider::process_pending_messages($limit, $id)]; } return $totals; }
public static function selectID($id) { $strSQL = "select * from gioithieu where id='{$id}'"; $result = DataProvider::Query($strSQL); if (mysql_num_rows($result) == 0) { return null; } $row = mysql_fetch_row($result, MYSQL_BOTH); return $row; }