public function __construct($user = false, $pwd = false, $signature = false)
{
if ($user and $pwd and $signature) {
$this->__user = $user;
$this->__pwd = $pwd;
$this->__signature = $signature;
} else {
$provider_name = new Api_Model_Provider();
$provider_name->find("paypal", "code");
$keys = $provider_name->getKeys();
foreach ($keys as $key) {
switch ($key->getKey()) {
case "username":
$this->__user = $key->getValue();
break;
case "password":
$this->__pwd = $key->getValue();
break;
case "signature":
$this->__signature = $key->getValue();
break;
}
}
if (!$this->__user or !$this->__pwd or !$this->__signature) {
throw new Exception("Error, Paypal is not properly set up.");
}
}
if ($this->isProduction()) {
$this->__api_url = str_replace('sandbox.', '', $this->__api_url);
$this->__paypal_url = str_replace('sandbox.', '', $this->__paypal_url);
}
}
public static function findKeysFor($provider_code)
{
if (empty(self::$__keys[$provider_code])) {
$key = new self();
$provider = new Api_Model_Provider();
$provider->find($provider_code, 'code');
if (!$provider->getId()) {
return $keys;
}
foreach ($provider->getKeys() as $tmp_key) {
$key->addData($tmp_key->getKey(), $tmp_key->getValue());
}
self::$__keys[$provider_code] = $key;
}
return self::$__keys[$provider_code];
}
public function findallAction()
{
$api_provider = new Api_Model_Provider();
$api_providers = $api_provider->findAll();
$data = array();
foreach ($api_providers as $k => $api_provider) {
$provider_name = "";
if ($api_provider->getIcon()) {
$provider_name = '<i class="fa ' . $api_provider->getIcon() . '"></i> ';
}
$provider_name .= $api_provider->getName();
$data["apis"][$k]["provider_name"] = $provider_name;
if (empty($data["apis"][$k]["keys"])) {
$data["apis"][$k]["keys"] = array();
}
foreach ($api_provider->getKeys() as $key) {
$data["apis"][$k]["keys"][] = array("id" => $key->getId(), "provider" => $api_provider->getCode(), "key" => $key->getKey(), "value" => $key->getValue());
}
}
$this->_sendHtml($data);
}
<?php
$this->query("\n CREATE TABLE `api_provider` (\n `provider_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `code` varchar(30) NOT NULL,\n `name` varchar(60) NOT NULL,\n `icon` varchar(50) NULL DEFAULT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`provider_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\n CREATE TABLE `api_key` (\n `key_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `provider_id` int(11) unsigned NOT NULL,\n `key` varchar(30) NULL DEFAULT NULL,\n `value` varchar(255) NULL DEFAULT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`key_id`),\n KEY `KEY_PROVIDER_ID` (`provider_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n");
$this->query("\n CREATE TABLE `api_user` (\n `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `username` varchar(50) NOT NULL,\n `firstname` varchar(50) NULL DEFAULT NULL,\n `lastname` varchar(50) NULL DEFAULT NULL,\n `password` varchar(100) NOT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`user_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n");
$this->query("\n ALTER TABLE `api_key`\n ADD FOREIGN KEY `FK_PROVIDER_ID` (`provider_id`) REFERENCES `api_provider` (`provider_id`) ON DELETE CASCADE ON UPDATE CASCADE;\n");
$apis = array(array("code" => "instagram", "icon" => "fa-instagram", "keys" => array("token", "client_id")), array("code" => "facebook", "icon" => "fa-facebook-square", "keys" => array("app_id", "secret_key")), array("code" => "youtube", "icon" => "fa-youtube", "keys" => array("api_key")), array("code" => "soundcloud", "icon" => "fa-soundcloud", "keys" => array("client_id", "secret_id")));
foreach ($apis as $provider_data) {
$provider_name = ucfirst($provider_data["code"]);
$provider = new Api_Model_Provider();
$provider->setData(array("code" => $provider_data["code"], "name" => $provider_name, "icon" => $provider_data["icon"]))->save();
foreach ($provider_data["keys"] as $key) {
$data = array('provider_id' => $provider->getId(), 'key' => $key);
$key = new Api_Model_Key();
$key->setData($data)->save();
}
}
<?php
$this->query("\n CREATE TABLE `api_provider` (\n `provider_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `code` varchar(30) NOT NULL,\n `name` varchar(60) NOT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`provider_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\n CREATE TABLE `api_key` (\n `key_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `provider_id` int(11) unsigned NOT NULL,\n `key` varchar(30) NULL DEFAULT NULL,\n `value` varchar(255) NULL DEFAULT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`key_id`),\n KEY `KEY_PROVIDER_ID` (`provider_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n");
$this->query("\n ALTER TABLE `api_key`\n ADD FOREIGN KEY `FK_PROVIDER_ID` (`provider_id`) REFERENCES `api_provider` (`provider_id`) ON DELETE CASCADE ON UPDATE CASCADE;\n");
$apis = array('instagram' => array('token', 'client_id'), 'facebook' => array('app_id', 'secret_key'), 'youtube' => array('api_key'));
foreach ($apis as $provider_code => $keys) {
$provider_name = ucfirst($provider_code);
$provider = new Api_Model_Provider();
$provider->setData(array('code' => $provider_code, 'name' => $provider_name))->save();
foreach ($keys as $key) {
$datas = array('provider_id' => $provider->getId(), 'key' => $key);
$key = new Api_Model_Key();
$key->setData($datas)->save();
}
}
<?php
$this->query("ALTER TABLE `api_provider` ADD `icon` varchar(50) NULL DEFAULT NULL AFTER `name`;");
$provider_codes = array("instagram" => "fa-instagram", "facebook" => "fa-facebook-square", "youtube" => "fa-youtube");
foreach ($provider_codes as $provider_code => $icon_name) {
$provider = new Api_Model_Provider();
$provider->find($provider_code, "code");
if ($provider->getId()) {
$provider->setIcon($icon_name)->save();
}
}
