31 changed files with 4732 additions and 3053 deletions
View File
+12 -12
View File
@@ -1,12 +1,12 @@
<ifModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ serviceapp.php [QSA,L]
</ifModule>
<Limit GET POST PUT DELETE>
Allow from *.gruppolapastamadre.it
</Limit>
Header set Access-Control-Allow-Origin *.gruppolapastamadre.it
Header set Access-Control-Allow-Methods: "GET,POST,OPTIONS,DELETE,PUT"
<ifModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ serviceapp.php [QSA,L]
</ifModule>
<Limit GET POST PUT DELETE>
# Allow from app.gruppolapastamadre.it
</Limit>
#Header set Access-Control-Allow-Origin "app.gruppolapastamadre.it"
#Header set Access-Control-Allow-Methods: "GET,POST,OPTIONS,DELETE,PUT"
+681
View File
@@ -0,0 +1,681 @@
<?php
/**
* DropPHP - A simple Dropbox client that works without cURL.
*
* http://fabi.me/en/php-projects/dropphp-dropbox-api-client/
*
*
* @author Fabian Schlieper <[email protected]>
* @copyright Fabian Schlieper 2012
* @version 1.7
* @license See LICENSE
*
*/
require_once(dirname(__FILE__)."/OAuthSimple.php");
class DropboxClient {
const API_URL = "https://api.dropbox.com/1/";
const API_CONTENT_URL = "https://api-content.dropbox.com/1/";
const BUFFER_SIZE = 4096;
const MAX_UPLOAD_CHUNK_SIZE = 150000000; // 150MB
const UPLOAD_CHUNK_SIZE = 4000000; // 4MB
private $appParams;
private $consumerToken;
private $requestToken;
private $accessToken;
private $locale;
private $rootPath;
private $useCurl;
function __construct ($app_params, $locale = "en"){
$this->appParams = $app_params;
if(empty($app_params['app_key']))
throw new DropboxException("App Key is empty!");
$this->consumerToken = array('t' => $this->appParams['app_key'], 's' => $this->appParams['app_secret']);
$this->locale = $locale;
$this->rootPath = empty($app_params['app_full_access']) ? "sandbox" : "dropbox";
$this->requestToken = null;
$this->accessToken = null;
$this->useCurl = function_exists('curl_init');
}
/**
* Sets whether to use cURL if its available or PHP HTTP wrappers otherwise
*
* @access public
* @return boolean Whether to actually use cURL (always false if not installed)
*/
public function SetUseCUrl($use_it)
{
return ($this->useCurl = ($use_it && function_exists('curl_init')));
}
// ##################################################
// Authorization
/**
* Step 1 of authentication process. Retrieves a request token or returns a previously retrieved one.
*
* @access public
* @param boolean $get_new_token Optional (default false). Wether to retrieve a new request token.
* @return array Request Token array.
*/
public function GetRequestToken($get_new_token=false)
{
if(!empty($this->requestToken) && !$get_new_token)
return $this->requestToken;
$rt = $this->authCall("oauth/request_token");
if(empty($rt) || empty($rt['oauth_token']))
throw new DropboxException('Could not get request token!');
return ($this->requestToken = array('t'=>$rt['oauth_token'], 's'=>$rt['oauth_token_secret']));
}
/**
* Step 2. Returns a URL the user must be redirected to in order to connect the app to their Dropbox account
*
* @access public
* @param string $return_url URL users are redirected after authorization
* @return string URL
*/
public function BuildAuthorizeUrl($return_url)
{
$rt = $this->GetRequestToken();
if(empty($rt) || empty($rt['t'])) throw new DropboxException('Request Token Invalid ('.print_r($rt,true).').');
return "https://www.dropbox.com/1/oauth/authorize?oauth_token=".$rt['t']."&oauth_callback=".urlencode($return_url);
}
/**
* Step 3. Acquires an access token. This is the final step of authentication.
*
* @access public
* @param array $request_token Optional. The previously retrieved request token. This parameter can only be skipped if the DropboxClient object has been (de)serialized.
* @return array Access Token array.
*/
public function GetAccessToken($request_token = null)
{
if(!empty($this->accessToken)) return $this->accessToken;
if(empty($request_token)) $request_token = $this->requestToken;
if(empty($request_token)) throw new DropboxException('Request token required!');
$at = $this->authCall("oauth/access_token", $request_token);
if(empty($at))
throw new DropboxException(sprintf('Could not get access token! (request token: %s)', $request_token['t']));
return ($this->accessToken = array('t'=>$at['oauth_token'], 's'=>$at['oauth_token_secret']));
}
/**
* Sets a previously retrieved (and stored) access token.
*
* @access public
* @param string|object $token The Access Token
* @return none
*/
public function SetAccessToken($token)
{
if(empty($token['t']) || empty($token['s'])) throw new DropboxException('Passed invalid access token.');
$this->accessToken = $token;
}
/**
* Checks if an access token has been set.
*
* @access public
* @return boolean Authorized or not
*/
public function IsAuthorized()
{
if(empty($this->accessToken)) return false;
return true;
}
// ##################################################
// API Functions
/**
* Retrieves information about the user's account.
*
* @access public
* @return object Account info object. See https://www.dropbox.com/developers/reference/api#account-info
*/
public function GetAccountInfo()
{
return $this->apiCall("account/info", "GET");
}
/**
* Get file list of a dropbox folder.
*
* @access public
* @param string|object $dropbox_path Dropbox path of the folder
* @return array An array with metadata of files/folders keyed by paths
*/
public function GetFiles($dropbox_path='', $recursive=false, $include_deleted=false)
{
if(is_object($dropbox_path) && !empty($dropbox_path->path)) $dropbox_path = $dropbox_path->path;
return $this->getFileTree($dropbox_path, $include_deleted, $recursive ? 1000 : 0);
}
/**
* Get file or folder metadata
*
* @access public
* @param $dropbox_path string Dropbox path of the file or folder
*/
public function GetMetadata($dropbox_path, $include_deleted=false, $rev=null)
{
if(is_object($dropbox_path) && !empty($dropbox_path->path)) $dropbox_path = $dropbox_path->path;
return $this->apiCall("metadata/$this->rootPath/$dropbox_path", "GET", compact('include_deleted','rev'));
}
/**
* Download a file to the webserver
*
* @access public
* @param string|object $dropbox_file Dropbox path or metadata object of the file to download.
* @param string $dest_path Local path for destination
* @param string $rev Optional. The revision of the file to retrieve. This defaults to the most recent revision.
* @param callback $progress_changed_callback Optional. Callback that will be called during download with 2 args: 1. bytes loaded, 2. file size
* @return object Dropbox file metadata
*/
public function DownloadFile($dropbox_file, $dest_path='', $rev=null, $progress_changed_callback = null)
{
if(is_object($dropbox_file) && !empty($dropbox_file->path))
$dropbox_file = $dropbox_file->path;
if(empty($dest_path)) $dest_path = basename($dropbox_file);
$url = $this->cleanUrl(self::API_CONTENT_URL."/files/$this->rootPath/$dropbox_file")
. (!empty($rev) ? ('?'.http_build_query(array('rev' => $rev),'','&')) : '');
$context = $this->createRequestContext($url, "GET");
$fh = @fopen($dest_path, 'wb'); // write binary
if($fh === false) {
@fclose($rh);
throw new DropboxException("Could not create file $dest_path !");
}
if($this->useCurl) {
curl_setopt($context, CURLOPT_BINARYTRANSFER, true);
curl_setopt($context, CURLOPT_RETURNTRANSFER, true);
curl_setopt($context, CURLOPT_FILE, $fh);
$response_headers = array();
self::execCurlAndClose($context, $response_headers);
fclose($fh);
$meta = self::getMetaFromHeaders($response_headers, true);
$bytes_loaded = filesize($dest_path);
} else {
$rh = @fopen($url, 'rb', false, $context); // read binary
if($rh === false)
throw new DropboxException("HTTP request to $url failed!");
// get file meta from HTTP header
$s_meta = stream_get_meta_data($rh);
$meta = self::getMetaFromHeaders($s_meta['wrapper_data'], true);
$bytes_loaded = 0;
while (!feof($rh)) {
if(($s=fwrite($fh, fread($rh, self::BUFFER_SIZE))) === false) {
@fclose($rh);
@fclose($fh);
throw new DropboxException("Writing to file $dest_path failed!'");
}
$bytes_loaded += $s;
if(!empty($progress_changed_callback)) {
call_user_func($progress_changed_callback, $bytes_loaded, $meta->bytes);
}
}
fclose($rh);
fclose($fh);
}
if($meta->bytes != $bytes_loaded)
throw new DropboxException("Download size mismatch! (header:{$meta->bytes} vs actual:{$bytes_loaded}; curl:{$this->useCurl})");
return $meta;
}
/**
* Upload a file to dropbox
*
* @access public
* @param $src_file string Local file to upload
* @param $dropbox_path string Dropbox path for destination
* @return object Dropbox file metadata
*/
public function UploadFile($src_file, $dropbox_path='', $overwrite=true, $parent_rev=null)
{
if(empty($dropbox_path)) $dropbox_path = basename($src_file);
elseif(is_object($dropbox_path) && !empty($dropbox_path->path)) $dropbox_path = $dropbox_path->path;
// make sure the dropbox_path is not a dir. if it is, append baseneme of $src_file
$dropbox_bn = basename($dropbox_path);
if(strpos($dropbox_bn,'.') === false) { // check if ext. is missing -> could be a directory!
try {
$meta = $this->GetMetadata($dropbox_path);
if($meta && $meta->is_dir)
$dropbox_path = $dropbox_path . '/'. basename($src_file);
} catch(Exception $e) {}
}
$file_size = filesize($src_file);
if($file_size > self::MAX_UPLOAD_CHUNK_SIZE)
{
$fh = fopen($src_file,'rb');
if($fh === false)
throw new DropboxException();
$upload_id = null;
$offset = 0;
while(!feof($fh)) {
$url = $this->cleanUrl(self::API_CONTENT_URL."/chunked_upload").'?'.http_build_query(compact('upload_id', 'offset'),'','&');
if($this->useCurl) {
$context = $this->createRequestContext($url, "PUT");
curl_setopt($context, CURLOPT_BINARYTRANSFER, true);
curl_setopt($context, CURLOPT_PUT, 1);
curl_setopt($context, CURLOPT_INFILE, $fh);
$chunk_size = min(self::UPLOAD_CHUNK_SIZE, $file_size - $offset);
$offset += $chunk_size;
curl_setopt($context, CURLOPT_INFILESIZE, $chunk_size);
$response = json_decode(self::execCurlAndClose($context));
fseek($fh,$offset);
if($offset >= $file_size)
break;
} else {
$content = fread($fh, self::UPLOAD_CHUNK_SIZE);
$context = $this->createRequestContext($url, "PUT", $content);
$offset += strlen($content);
unset($content);
$response = json_decode(file_get_contents($url, false, $context));
}
unset($context);
self::checkForError($response);
if(empty($upload_id)) {
$upload_id = $response->upload_id;
if(empty($upload_id)) throw new DropboxException("Upload ID empty!");
}
}
@fclose($fh);
$this->useCurl = $prev_useCurl;
return $this->apiCall("commit_chunked_upload/$this->rootPath/$dropbox_path", "POST", compact('overwrite','parent_rev','upload_id'), true);
}
$query = http_build_query(array_merge(compact('overwrite', 'parent_rev'), array('locale' => $this->locale)),'','&');
$url = $this->cleanUrl(self::API_CONTENT_URL."/files_put/$this->rootPath/$dropbox_path")."?$query";
if($this->useCurl) {
$context = $this->createRequestContext($url, "PUT");
curl_setopt($context, CURLOPT_BINARYTRANSFER, true);
$fh = fopen($src_file, 'rb');
curl_setopt($context, CURLOPT_PUT, 1);
curl_setopt($context, CURLOPT_INFILE, $fh); // file pointer
curl_setopt($context, CURLOPT_INFILESIZE, filesize($src_file));
$meta = json_decode(self::execCurlAndClose($context));
fclose($fh);
return self::checkForError($meta);
} else {
$content = file_get_contents($src_file);
if(strlen($content) == 0)
throw new DropboxException("Could not read file $src_file or file is empty!");
$context = $this->createRequestContext($url, "PUT", $content);
return self::checkForError(json_decode(file_get_contents($url, false, $context)));
}
}
/**
* Get thumbnail for a specified image
*
* @access public
* @param $dropbox_file string Path to the image
* @param $format string Image format of the thumbnail (jpeg or png)
* @param $size string Thumbnail size (xs, s, m, l, xl)
* @return mime/* Returns the thumbnail as binary image data
*/
public function GetThumbnail($dropbox_file, $size = 's', $format = 'jpeg', $echo = false)
{
if(is_object($dropbox_file) && !empty($dropbox_file->path)) $dropbox_file = $dropbox_file->path;
$url = $this->cleanUrl(self::API_CONTENT_URL."thumbnails/$this->rootPath/$dropbox_file")
. '?' . http_build_query(array('format' => $format, 'size' => $size),'','&');
$context = $this->createRequestContext($url, "GET");
if($this->useCurl) {
curl_setopt($context, CURLOPT_BINARYTRANSFER, true);
curl_setopt($context, CURLOPT_RETURNTRANSFER, true);
}
$thumb = $this->useCurl ? self::execCurlAndClose($context) : file_get_contents($url, NULL, $context);
if($echo) {
header('Content-type: image/'.$format);
echo $thumb;
unset($thumb);
return;
}
return $thumb;
}
function GetLink($dropbox_file, $preview=true, $short=true, &$expires=null)
{
if(is_object($dropbox_file) && !empty($dropbox_file->path)) $dropbox_file = $dropbox_file->path;
$url = $this->apiCall(($preview?"shares":"media")."/$this->rootPath/$dropbox_file", "POST", array('locale' => null, 'short_url'=> $preview ? $short : null));
$expires = strtotime($url->expires);
return $url->url;
}
function Delta($cursor)
{
return $this->apiCall("delta", "POST", compact('cursor'));
}
function GetRevisions($dropbox_file, $rev_limit=10)
{
if(is_object($dropbox_file) && !empty($dropbox_file->path)) $dropbox_file = $dropbox_file->path;
return $this->apiCall("revisions/$this->rootPath/$dropbox_file", "GET", compact('rev_limit'));
}
function Restore($dropbox_file, $rev)
{
if(is_object($dropbox_file) && !empty($dropbox_file->path)) $dropbox_file = $dropbox_file->path;
return $this->apiCall("restore/$this->rootPath/$dropbox_file", "POST", compact('rev'));
}
function Search($path, $query, $file_limit=1000, $include_deleted=false)
{
return $this->apiCall("search/$this->rootPath/$path", "POST", compact('query','file_limit','include_deleted'));
}
function GetCopyRef($dropbox_file, &$expires=null)
{
if(is_object($dropbox_file) && !empty($dropbox_file->path)) $dropbox_file = $dropbox_file->path;
$ref = $this->apiCall("copy_ref/$this->rootPath/$dropbox_file", "GET", array('locale' => null));
$expires = strtotime($ref->expires);
return $ref->copy_ref;
}
function Copy($from_path, $to_path, $copy_ref=false)
{
if(is_object($from_path) && !empty($from_path->path)) $from_path = $from_path->path;
return $this->apiCall("fileops/copy", "POST", array('root'=> $this->rootPath, ($copy_ref ? 'from_copy_ref' : 'from_path') => $from_path, 'to_path' => $to_path));
}
/**
* Creates a new folder in the DropBox
*
* @access public
* @param $path string The path to the new folder to create
* @return object Dropbox folder metadata
*/
function CreateFolder($path)
{
return $this->apiCall("fileops/create_folder", "POST", array('root'=> $this->rootPath, 'path' => $path));
}
/**
* Delete file or folder
*
* @access public
* @param $path mixed The path or metadata of the file/folder to be deleted.
* @return object Dropbox metadata of deleted file or folder
*/
function Delete($path)
{
if(is_object($path) && !empty($path->path)) $path = $path->path;
return $this->apiCall("fileops/delete", "POST", array('locale' =>null, 'root'=> $this->rootPath, 'path' => $path));
}
function Move($from_path, $to_path)
{
if(is_object($from_path) && !empty($from_path->path)) $from_path = $from_path->path;
return $this->apiCall("fileops/move", "POST", array('root'=> $this->rootPath, 'from_path' => $from_path, 'to_path' => $to_path));
}
function getFileTree($path="", $include_deleted = false, $max_depth = 0, $depth=0)
{
static $files;
if($depth == 0) $files = array();
$dir = $this->apiCall("metadata/$this->rootPath/$path", "GET", compact('include_deleted'));
if(empty($dir) || !is_object($dir)) return false;
if(!empty($dir->error)) throw new DropboxException($dir->error);
foreach($dir->contents as $item)
{
$files[trim($item->path,'/')] = $item;
if($item->is_dir && $depth < $max_depth)
{
$this->getFileTree($item->path, $include_deleted, $max_depth, $depth+1);
}
}
return $files;
}
function createCurl($url, $http_context)
{
$ch = curl_init($url);
$curl_opts = array(
CURLOPT_HEADER => false, // exclude header from output
//CURLOPT_MUTE => true, // no output!
CURLOPT_RETURNTRANSFER => true, // but return!
CURLOPT_SSL_VERIFYPEER => false,
);
$curl_opts[CURLOPT_CUSTOMREQUEST] = $http_context['method'];
if(!empty($http_context['content'])) {
$curl_opts[CURLOPT_POSTFIELDS] =& $http_context['content'];
if(defined("CURLOPT_POSTFIELDSIZE"))
$curl_opts[CURLOPT_POSTFIELDSIZE] = strlen($http_context['content']);
}
$curl_opts[CURLOPT_HTTPHEADER] = array_map('trim',explode("\n",$http_context['header']));
curl_setopt_array($ch, $curl_opts);
return $ch;
}
static private $_curlHeadersRef;
static function _curlHeaderCallback($ch, $header)
{
self::$_curlHeadersRef[] = trim($header);
return strlen($header);
}
static function &execCurlAndClose($ch, &$out_response_headers = null)
{
if(is_array($out_response_headers)) {
self::$_curlHeadersRef =& $out_response_headers;
curl_setopt($ch, CURLOPT_HEADERFUNCTION, array(__CLASS__, '_curlHeaderCallback'));
}
$res = curl_exec($ch);
$err_no = curl_errno($ch);
$err_str = curl_error($ch);
curl_close($ch);
if($err_no || $res === false) {
throw new DropboxException("cURL-Error ($err_no): $err_str");
}
return $res;
}
private function createRequestContext($url, $method, &$content=null, $oauth_token=-1)
{
if($oauth_token === -1)
$oauth_token = $this->accessToken;
$method = strtoupper($method);
$http_context = array('method'=>$method, 'header'=> '');
$oauth = new OAuthSimple($this->consumerToken['t'],$this->consumerToken['s']);
if(empty($oauth_token) && !empty($this->accessToken))
$oauth_token = $this->accessToken;
if(!empty($oauth_token)) {
$oauth->setParameters(array('oauth_token' => $oauth_token['t']));
$oauth->signatures(array('oauth_secret'=>$oauth_token['s']));
}
if(!empty($content)) {
$post_vars = ($method != "PUT" && preg_match("/^[a-z][a-z0-9_]*=/i", substr($content, 0, 32)));
$http_context['header'] .= "Content-Length: ".strlen($content)."\r\n";
$http_context['header'] .= "Content-Type: application/".($post_vars?"x-www-form-urlencoded":"octet-stream")."\r\n";
$http_context['content'] =& $content;
if($method == "POST" && $post_vars)
$oauth->setParameters($content);
} elseif($method == "POST") {
// make sure that content-length is always set when post request (otherwise some wrappers fail!)
$http_context['content'] = "";
$http_context['header'] .= "Content-Length: 0\r\n";
}
// check for query vars in url and add them to oauth parameters (and remove from path)
$path = $url;
$query = strrchr($url,'?');
if(!empty($query)) {
$oauth->setParameters(substr($query,1));
$path = substr($url, 0, -strlen($query));
}
$signed = $oauth->sign(array(
'action' => $method,
'path'=> $path));
//print_r($signed);
$http_context['header'] .= "Authorization: ".$signed['header']."\r\n";
return $this->useCurl ? $this->createCurl($url, $http_context) : stream_context_create(array('http'=>$http_context));
}
private function authCall($path, $request_token=null)
{
$url = $this->cleanUrl(self::API_URL.$path);
$dummy = null;
$context = $this->createRequestContext($url, "POST", $dummy, $request_token);
$contents = $this->useCurl ? self::execCurlAndClose($context) : file_get_contents($url, false, $context);
$data = array();
parse_str($contents, $data);
return $data;
}
private static function checkForError($resp)
{
if(!empty($resp->error))
throw new DropboxException($resp->error);
return $resp;
}
private function apiCall($path, $method, $params=array(), $content_call=false)
{
$url = $this->cleanUrl(($content_call ? self::API_CONTENT_URL : self::API_URL).$path);
$content = http_build_query(array_merge(array('locale'=>$this->locale), $params),'','&');
if($method == "GET") {
$url .= "?".$content;
$content = null;
}
$context = $this->createRequestContext($url, $method, $content);
$json = $this->useCurl ? self::execCurlAndClose($context) : file_get_contents($url, false, $context);
//if($json === false)
// throw new DropboxException();
$resp = json_decode($json);
return self::checkForError($resp);
}
private static function getMetaFromHeaders(&$header_array, $throw_on_error=false)
{
$obj = json_decode(substr(@array_shift(array_filter($header_array, create_function('$s', 'return stripos($s, "x-dropbox-metadata:") === 0;'))), 20));
if($throw_on_error && (empty($obj)||!is_object($obj)))
throw new DropboxException("Could not retrieve meta data from header data: ".print_r($header_array,true));
if($throw_on_error)
self::checkForError ($obj);
return $obj;
}
function cleanUrl($url) {
$p = substr($url,0,8);
$url = str_replace('//','/', str_replace('\\','/',substr($url,8)));
$url = rawurlencode($url);
$url = str_replace('%2F', '/', $url);
return $p.$url;
}
}
class DropboxException extends Exception {
public function __construct($err = null, $isDebug = FALSE)
{
if(is_null($err)) {
$el = error_get_last();
$this->message = $el['message'];
$this->file = $el['file'];
$this->line = $el['line'];
} else
$this->message = $err;
self::log_error($err);
if ($isDebug)
{
self::display_error($err, TRUE);
}
}
public static function log_error($err)
{
error_log($err, 0);
}
public static function display_error($err, $kill = FALSE)
{
print_r($err);
if ($kill === FALSE)
{
die();
}
}
}
+532
View File
@@ -0,0 +1,532 @@
<?php
/**
* OAuthSimple - A simpler version of OAuth
*
* https://github.com/jrconlin/oauthsimple
*
* @author jr conlin <[email protected]>
* @copyright unitedHeroes.net 2011
* @version 1.3
* @license See OAuthSimple_license.txt
*
*/
class OAuthSimple {
private $_secrets;
private $_default_signature_method;
private $_action;
private $_nonce_chars;
/**
* Constructor
*
* @access public
* @param api_key (String) The API Key (sometimes referred to as the consumer key) This value is usually supplied by the site you wish to use.
* @param shared_secret (String) The shared secret. This value is also usually provided by the site you wish to use.
* @return OAuthSimple (Object)
*/
function __construct ($APIKey = "", $sharedSecret=""){
if (!empty($APIKey))
{
$this->_secrets['consumer_key'] = $APIKey;
}
if (!empty($sharedSecret))
{
$this->_secrets['shared_secret'] = $sharedSecret;
}
$this->_default_signature_method = "HMAC-SHA1";
$this->_action = "GET";
$this->_nonce_chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
return $this;
}
/**
* Reset the parameters and URL
*
* @access public
* @return OAuthSimple (Object)
*/
public function reset() {
$this->_parameters = Array();
$this->path = NULL;
$this->sbs = NULL;
return $this;
}
/**
* Set the parameters either from a hash or a string
*
* @access public
* @param(string, object) List of parameters for the call, this can either be a URI string (e.g. "foo=bar&gorp=banana" or an object/hash)
* @return OAuthSimple (Object)
*/
public function setParameters ($parameters=Array()) {
if (is_string($parameters))
{
$parameters = $this->_parseParameterString($parameters);
}
if (empty($this->_parameters))
{
$this->_parameters = $parameters;
}
else if (!empty($parameters))
{
$this->_parameters = array_merge($this->_parameters,$parameters);
}
if (empty($this->_parameters['oauth_nonce']))
{
$this->_getNonce();
}
if (empty($this->_parameters['oauth_timestamp']))
{
$this->_getTimeStamp();
}
if (empty($this->_parameters['oauth_consumer_key']))
{
$this->_getApiKey();
}
if (empty($this->_parameters['oauth_token']))
{
$this->_getAccessToken();
}
if (empty($this->_parameters['oauth_signature_method']))
{
$this->setSignatureMethod();
}
if (empty($this->_parameters['oauth_version']))
{
$this->_parameters['oauth_version']="1.0";
}
return $this;
}
/**
* Convenience method for setParameters
*
* @access public
* @see setParameters
*/
public function setQueryString ($parameters)
{
return $this->setParameters($parameters);
}
/**
* Set the target URL (does not include the parameters)
*
* @param path (String) the fully qualified URI (excluding query arguments) (e.g "http://example.org/foo")
* @return OAuthSimple (Object)
*/
public function setURL ($path)
{
if (empty($path))
{
throw new OAuthSimpleException('No path specified for OAuthSimple.setURL');
}
$this->_path=$path;
return $this;
}
/**
* Convenience method for setURL
*
* @param path (String)
* @see setURL
*/
public function setPath ($path)
{
return $this->_path=$path;
}
/**
* Set the "action" for the url, (e.g. GET,POST, DELETE, etc.)
*
* @param action (String) HTTP Action word.
* @return OAuthSimple (Object)
*/
public function setAction ($action)
{
if (empty($action))
{
$action = 'GET';
}
$action = strtoupper($action);
if (preg_match('/[^A-Z]/',$action))
{
throw new OAuthSimpleException('Invalid action specified for OAuthSimple.setAction');
}
$this->_action = $action;
return $this;
}
/**
* Set the signatures (as well as validate the ones you have)
*
* @param signatures (object) object/hash of the token/signature pairs {api_key:, shared_secret:, oauth_token: oauth_secret:}
* @return OAuthSimple (Object)
*/
public function signatures ($signatures)
{
if (!empty($signatures) && !is_array($signatures))
{
throw new OAuthSimpleException('Must pass dictionary array to OAuthSimple.signatures');
}
if (!empty($signatures))
{
if (empty($this->_secrets))
{
$this->_secrets=Array();
}
$this->_secrets=array_merge($this->_secrets,$signatures);
}
if (isset($this->_secrets['api_key']))
{
$this->_secrets['consumer_key'] = $this->_secrets['api_key'];
}
if (isset($this->_secrets['access_token']))
{
$this->_secrets['oauth_token'] = $this->_secrets['access_token'];
}
if (isset($this->_secrets['access_secret']))
{
$this->_secrets['oauth_secret'] = $this->_secrets['access_secret'];
}
if (isset($this->_secrets['access_token_secret']))
{
$this->_secrets['oauth_secret'] = $this->_secrets['access_token_secret'];
}
if (empty($this->_secrets['consumer_key']))
{
throw new OAuthSimpleException('Missing required consumer_key in OAuthSimple.signatures');
}
if (empty($this->_secrets['shared_secret']))
{
throw new OAuthSimpleException('Missing requires shared_secret in OAuthSimple.signatures');
}
if (!empty($this->_secrets['oauth_token']) && empty($this->_secrets['oauth_secret']))
{
throw new OAuthSimpleException('Missing oauth_secret for supplied oauth_token in OAuthSimple.signatures');
}
return $this;
}
public function setTokensAndSecrets($signatures)
{
return $this->signatures($signatures);
}
/**
* Set the signature method (currently only Plaintext or SHA-MAC1)
*
* @param method (String) Method of signing the transaction (only PLAINTEXT and SHA-MAC1 allowed for now)
* @return OAuthSimple (Object)
*/
public function setSignatureMethod ($method="")
{
if (empty($method))
{
$method = $this->_default_signature_method;
}
$method = strtoupper($method);
switch($method)
{
case 'PLAINTEXT':
case 'HMAC-SHA1':
$this->_parameters['oauth_signature_method']=$method;
break;
default:
throw new OAuthSimpleException ("Unknown signing method $method specified for OAuthSimple.setSignatureMethod");
break;
}
return $this;
}
/** sign the request
*
* note: all arguments are optional, provided you've set them using the
* other helper functions.
*
* @param args (Array) hash of arguments for the call {action, path, parameters (array), method, signatures (array)} all arguments are optional.
* @return (Array) signed values
*/
public function sign($args=array())
{
if (!empty($args['action']))
{
$this->setAction($args['action']);
}
if (!empty($args['path']))
{
$this->setPath($args['path']);
}
if (!empty($args['method']))
{
$this->setSignatureMethod($args['method']);
}
if (!empty($args['signatures']))
{
$this->signatures($args['signatures']);
}
if (empty($args['parameters']))
{
$args['parameters']=array();
}
$this->setParameters($args['parameters']);
$normParams = $this->_normalizedParameters();
$this->_parameters['oauth_signature'] = $this->_generateSignature($normParams);
return Array (
'parameters' => $this->_parameters,
'signature' => self::_oauthEscape($this->_parameters['oauth_signature']),
'signed_url' => $this->_path . '?' . $this->_normalizedParameters(),
'header' => $this->getHeaderString(),
'sbs'=> $this->sbs
);
}
/**
* Return a formatted "header" string
*
* NOTE: This doesn't set the "Authorization: " prefix, which is required.
* It's not set because various set header functions prefer different
* ways to do that.
*
* @param args (Array)
* @return $result (String)
*/
public function getHeaderString ($args=array())
{
if (empty($this->_parameters['oauth_signature']))
{
$this->sign($args);
}
$result = 'OAuth ';
foreach ($this->_parameters as $pName => $pValue)
{
if (strpos($pName,'oauth_') !== 0 || $pName == 'oauth_token_secret2')
{
continue;
}
if (is_array($pValue))
{
foreach ($pValue as $val)
{
$result .= $pName .'="' . self::_oauthEscape($val) . '", ';
}
}
else
{
$result .= $pName . '="' . self::_oauthEscape($pValue) . '", ';
}
}
return preg_replace('/, $/','',$result);
}
private function _parseParameterString ($paramString)
{
$elements = explode('&',$paramString);
$result = array();
foreach ($elements as $element)
{
list ($key,$token) = explode('=',$element);
if ($token)
{
$token = urldecode($token);
}
if (!empty($result[$key]))
{
if (!is_array($result[$key]))
{
$result[$key] = array($result[$key],$token);
}
else
{
array_push($result[$key],$token);
}
}
else
$result[$key]=$token;
}
return $result;
}
private static function _oauthEscape($string)
{
if ($string === 0) { return 0; }
if ($string == '0') { return '0'; }
if (strlen($string) == 0) { return ''; }
if (is_array($string)) {
throw new OAuthSimpleException('Array passed to _oauthEscape');
}
$string = rawurlencode($string);
$string = str_replace('+','%20',$string);
$string = str_replace('!','%21',$string);
$string = str_replace('*','%2A',$string);
$string = str_replace('\'','%27',$string);
$string = str_replace('(','%28',$string);
$string = str_replace(')','%29',$string);
return $string;
}
private function _getNonce($length=5)
{
$result = '';
$cLength = strlen($this->_nonce_chars);
for ($i=0; $i < $length; $i++)
{
$rnum = rand(0,$cLength);
$result .= substr($this->_nonce_chars,$rnum,1);
}
$result = md5($result);
$this->_parameters['oauth_nonce'] = $result;
return $result;
}
private function _getApiKey()
{
if (empty($this->_secrets['consumer_key']))
{
throw new OAuthSimpleException('No consumer_key set for OAuthSimple');
}
$this->_parameters['oauth_consumer_key']=$this->_secrets['consumer_key'];
return $this->_parameters['oauth_consumer_key'];
}
private function _getAccessToken()
{
if (!isset($this->_secrets['oauth_secret']))
{
return '';
}
if (!isset($this->_secrets['oauth_token']))
{
throw new OAuthSimpleException('No access token (oauth_token) set for OAuthSimple.');
}
$this->_parameters['oauth_token'] = $this->_secrets['oauth_token'];
return $this->_parameters['oauth_token'];
}
private function _getTimeStamp()
{
return $this->_parameters['oauth_timestamp'] = time();
}
private function _normalizedParameters()
{
$normalized_keys = array();
$return_array = array();
foreach ( $this->_parameters as $paramName=>$paramValue) {
if (!preg_match('/\w+_secret/',$paramName) OR (strpos($paramValue, '@') !== 0 && !file_exists(substr($paramValue, 1))) )
{
if (is_array($paramValue))
{
$normalized_keys[self::_oauthEscape($paramName)] = array();
foreach($paramValue as $item)
{
array_push($normalized_keys[self::_oauthEscape($paramName)], self::_oauthEscape($item));
}
}
else
{
$normalized_keys[self::_oauthEscape($paramName)] = self::_oauthEscape($paramValue);
}
}
}
ksort($normalized_keys);
foreach($normalized_keys as $key=>$val)
{
if (is_array($val))
{
sort($val);
foreach($val as $element)
{
array_push($return_array, $key . "=" . $element);
}
}
else
{
array_push($return_array, $key .'='. $val);
}
}
return join("&", $return_array);
}
private function _generateSignature ()
{
$secretKey = '';
if(isset($this->_secrets['shared_secret']))
{
$secretKey = self::_oauthEscape($this->_secrets['shared_secret']);
}
$secretKey .= '&';
if(isset($this->_secrets['oauth_secret']))
{
$secretKey .= self::_oauthEscape($this->_secrets['oauth_secret']);
}
switch($this->_parameters['oauth_signature_method'])
{
case 'PLAINTEXT':
return urlencode($secretKey);;
case 'HMAC-SHA1':
$this->sbs = self::_oauthEscape($this->_action).'&'.self::_oauthEscape($this->_path).'&'.self::_oauthEscape($this->_normalizedParameters());
return base64_encode(hash_hmac('sha1',$this->sbs,$secretKey,TRUE));
default:
throw new OAuthSimpleException('Unknown signature method for OAuthSimple');
break;
}
}
}
class OAuthSimpleException extends Exception {
public function __construct($err, $isDebug = FALSE)
{
self::log_error($err);
if ($isDebug)
{
self::display_error($err, TRUE);
}
}
public static function log_error($err)
{
error_log($err, 0);
}
public static function display_error($err, $kill = FALSE)
{
print_r($err);
if ($kill === FALSE)
{
die();
}
}
}
+85
View File
@@ -0,0 +1,85 @@
<?php
error_reporting(E_ALL);
require_once("DropboxClient.php");
// you have to create an app at https://www.dropbox.com/developers/apps and enter details below:
$dropbox = new DropboxClient(array(
'app_key' => "ft0zodv89xx804e",
'app_secret' => "ut43sn7m9wufy3s",
'app_full_access' => true,
),'it');
handle_dropbox_auth($dropbox); // see below
// if there is no upload, show the form
if(empty($_FILES['the_upload'])) {
?>
<form enctype="multipart/form-data" method="POST" action="">
<p>
<label for="file">Upload File</label>
<input type="file" name="the_upload" />
</p>
<p><input type="submit" name="submit-btn" value="Upload!"></p>
</form>
<?php } else {
$upload_name = $_FILES["the_upload"]["name"];
echo "<pre>";
echo "\r\n\r\n<b>Uploading $upload_name:</b>\r\n";
$meta = $dropbox->UploadFile($_FILES["the_upload"]["tmp_name"], $upload_name);
print_r($meta);
echo "\r\n done!";
echo "</pre>";
}
// ================================================================================
// store_token, load_token, delete_token are SAMPLE functions! please replace with your own!
function store_token($token, $name)
{
file_put_contents("tokens/$name.token", serialize($token));
}
function load_token($name)
{
if(!file_exists("tokens/$name.token")) return null;
return @unserialize(@file_get_contents("tokens/$name.token"));
}
function delete_token($name)
{
@unlink("tokens/$name.token");
}
// ================================================================================
function handle_dropbox_auth($dropbox)
{
// first try to load existing access token
$access_token = load_token("access");
if(!empty($access_token)) {
$dropbox->SetAccessToken($access_token);
}
elseif(!empty($_GET['auth_callback'])) // are we coming from dropbox's auth page?
{
// then load our previosly created request token
$request_token = load_token($_GET['oauth_token']);
if(empty($request_token)) die('Request token not found!');
// get & store access token, the request token is not needed anymore
$access_token = $dropbox->GetAccessToken($request_token);
store_token($access_token, "access");
delete_token($_GET['oauth_token']);
}
// checks if access token is required
if(!$dropbox->IsAuthorized())
{
// redirect user to dropbox auth page
$return_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']."?auth_callback=1";
$auth_url = $dropbox->BuildAuthorizeUrl($return_url);
$request_token = $dropbox->GetRequestToken();
store_token($request_token, $request_token['t']);
die("Authentication required. <a href='$auth_url'>Click here.</a>");
}
}
+133
View File
@@ -0,0 +1,133 @@
<?php
/**
* DropPHP sample
*
* http://fabi.me/en/php-projects/dropphp-dropbox-api-client/
*
* @author Fabian Schlieper <[email protected]>
* @copyright Fabian Schlieper 2012
* @version 1.1
* @license See license.txt
*
*/
// these 2 lines are just to enable error reporting and disable output buffering (don't include this in you application!)
error_reporting(E_ALL);
enable_implicit_flush();
// -- end of unneeded stuff
// if there are many files in your Dropbox it can take some time, so disable the max. execution time
set_time_limit(0);
require_once("DropboxClient.php");
// you have to create an app at https://www.dropbox.com/developers/apps and enter details below:
$dropbox = new DropboxClient(array(
'app_key' => "ft0zodv89xx804e",
'app_secret' => "ut43sn7m9wufy3s",
'app_full_access' => true,
),'it');
// first try to load existing access token
$access_token = load_token("access");
if(!empty($access_token)) {
$dropbox->SetAccessToken($access_token);
echo "loaded access token:";
print_r($access_token);
}
elseif(!empty($_GET['auth_callback'])) // are we coming from dropbox's auth page?
{
// then load our previosly created request token
$request_token = load_token($_GET['oauth_token']);
if(empty($request_token)) die('Request token not found!');
// get & store access token, the request token is not needed anymore
$access_token = $dropbox->GetAccessToken($request_token);
store_token($access_token, "access");
delete_token($_GET['oauth_token']);
}
// checks if access token is required
if(!$dropbox->IsAuthorized())
{
// redirect user to dropbox auth page
$return_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']."?auth_callback=1";
$auth_url = $dropbox->BuildAuthorizeUrl($return_url);
$request_token = $dropbox->GetRequestToken();
store_token($request_token, $request_token['t']);
die("Authentication required. <a href='$auth_url'>Click here.</a>");
}
echo "<pre>";
echo "<b>Account:</b>\r\n";
print_r($dropbox->GetAccountInfo());
$files = $dropbox->GetFiles("",false);
echo "\r\n\r\n<b>Files:</b>\r\n";
print_r(array_keys($files));
if(!empty($files)) {
$file = reset($files);
$test_file = "test_download_".basename($file->path);
echo "\r\n\r\n<b>Meta data of <a href='".$dropbox->GetLink($file)."'>$file->path</a>:</b>\r\n";
print_r($dropbox->GetMetadata($file->path));
echo "\r\n\r\n<b>Downloading $file->path:</b>\r\n";
print_r($dropbox->DownloadFile($file, $test_file));
echo "\r\n\r\n<b>Uploading $test_file:</b>\r\n";
print_r($dropbox->UploadFile($test_file));
echo "\r\n done!";
echo "\r\n\r\n<b>Revisions of $test_file:</b>\r\n";
print_r($dropbox->GetRevisions($test_file));
}
echo "\r\n\r\n<b>Searching for JPG files:</b>\r\n";
$jpg_files = $dropbox->Search("/", ".jpg", 5);
if(empty($jpg_files))
echo "Nothing found.";
else {
print_r($jpg_files);
$jpg_file = reset($jpg_files);
echo "\r\n\r\n<b>Thumbnail of $jpg_file->path:</b>\r\n";
$img_data = base64_encode($dropbox->GetThumbnail($jpg_file->path));
echo "<img src=\"data:image/jpeg;base64,$img_data\" alt=\"Generating PDF thumbnail failed!\" style=\"border: 1px solid black;\" />";
}
function store_token($token, $name)
{
if(!file_put_contents("tokens/$name.token", serialize($token)))
die('<br />Could not store token! <b>Make sure that the directory `tokens` exists and is writable!</b>');
}
function load_token($name)
{
if(!file_exists("tokens/$name.token")) return null;
return @unserialize(@file_get_contents("tokens/$name.token"));
}
function delete_token($name)
{
@unlink("tokens/$name.token");
}
function enable_implicit_flush()
{
@apache_setenv('no-gzip', 1);
@ini_set('zlib.output_compression', 0);
@ini_set('implicit_flush', 1);
for ($i = 0; $i < ob_get_level(); $i++) { ob_end_flush(); }
ob_implicit_flush(1);
echo "<!-- ".str_repeat(' ', 2000)." -->";
}
+1
View File
@@ -0,0 +1 @@
{"error": "File not found"}
+1
View File
@@ -0,0 +1 @@
a:2:{s:1:"t";s:16:"2lfmugdr7rp3yp2q";s:1:"s";s:15:"i3nrl13aduhhufw";}
+86 -88
View File
@@ -1,89 +1,87 @@
<?php
class MysqlClass
{
// parametri per la connessione al database
/*private $nomehost = "mysql.hostinger.it";
private $nomeuser = "u766568765_lpm";
private $password = "8zX2gTIjfwXEdEgaSaWe";
private $mydb = "u766568765_lpm";
*/
private $nomehost = "sql.gruppolapastamadre.it";
private $nomeuser = "w18092_ricuser";
private $password = "RTvg0o6IESoqQyx8CCJn";
private $mydb = "w18092_ricettario";
// controllo sulle connessioni attive
private $attiva = false;
private $connessione = null;
// funzione per la connessione a MySQL
public function connetti()
{
if(!$this->attiva)
{
$this->connessione = mysql_connect($this->nomehost,$this->nomeuser,$this->password);
if ($this->connessione == FALSE)
die(mysql_error());
mysql_select_db($this->mydb, $this->connessione) or die ("Errore nella selezione del database. Verificare i parametri nel file config.inc.php");
$this->attiva = true;
}
else{
return true;
}
}
public function executeQuery($queryStr)
{
$this->connetti();
if (!$res = mysql_query($queryStr, $this->connessione)) die(mysql_error());
return true;
return false;
}
public function insertRecord($queryStr)
{
$this->connetti();
if (!$res = mysql_query($queryStr, $this->connessione)) die(mysql_error());
return mysql_insert_id();
}
public function queryToObject($queryStr)
{
$this->connetti();
$sth = mysql_query($queryStr, $this->connessione) or die(mysql_error());
$rows = array();
while($r = mysql_fetch_assoc($sth)) {
array_push($rows,array_map('utf8_encode', $r));
}
mysql_free_result($sth);
return $rows;
}
// funzione per la chiusura della connessione
public function disconnetti()
{
if($this->attiva)
{
if(mysql_close($this->connessione))
{
$this->attiva = false;
return true;
}
else
{
return false;
}
}
}
public function __destruct()
{
$this->disconnetti();
}
}
<?php
class MysqlClass {
// parametri per la connessione al database
private $nomehost = "localhost";
private $nomeuser = "root";
private $password = "root";
private $mydb = "w18092_ricettario";
/*
private $nomehost = "sql.gruppolapastamadre.it";
private $nomeuser = "w18092_ricuser";
private $password = "RTvg0o6IESoqQyx8CCJn";
private $mydb = "w18092_ricettario";
*/
// controllo sulle connessioni attive
private $attiva = false;
private $connessione = null;
// funzione per la connessione a MySQL
public function connetti() {
if (!$this->attiva) {
$this->connessione = mysqli_connect($this->nomehost, $this->nomeuser, $this->password);
if ($this->connessione == FALSE)
die(mysqli_error());
mysqli_select_db($this->connessione, $this->mydb) or die("Errore nella selezione del database. Verificare i parametri nel file config.inc.php");
$this->attiva = true;
}
else {
return true;
}
}
public function executeQuery($queryStr) {
$this->connetti();
if (!$res = mysqli_query($this->connessione, $queryStr))
die(mysqli_error());
return true;
}
public function insertRecord($queryStr) {
$this->connetti();
if (!$res = mysqli_query($this->connessione, $queryStr))
die(mysqli_error());
return mysqli_insert_id($this->connessione);
}
public function queryToObject($queryStr, $encode = true) {
$this->connetti();
$sth = mysqli_query($this->connessione, $queryStr) or die(mysqli_error());
if($encode){
$rows = array();
while ($r = mysqli_fetch_assoc($sth)) {
array_push($rows, array_map('utf8_encode', $r));
}
mysqli_free_result($sth);
return $rows;
}
else
{
return mysqli_fetch_array($sth);
}
}
// funzione per la chiusura della connessione
public function disconnetti() {
if ($this->attiva) {
if (mysqli_close($this->connessione)) {
$this->attiva = false;
return true;
} else {
return false;
}
}
}
public function __destruct() {
$this->disconnetti();
}
}
?>
@@ -1,22 +1,22 @@
<?php
namespace PHPImageWorkshop\Core\Exception;
use PHPImageWorkshop\Exception\ImageWorkshopBaseException as ImageWorkshopBaseException;
// If no autoloader, uncomment these lines:
//require_once(__DIR__.'/../../Exception/ImageWorkshopBaseException.php');
/**
* ImageWorkshopLayerException
*
* Manage ImageWorkshopLayer exceptions
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopLayerException extends ImageWorkshopBaseException
{
<?php
namespace PHPImageWorkshop\Core\Exception;
use PHPImageWorkshop\Exception\ImageWorkshopBaseException as ImageWorkshopBaseException;
// If no autoloader, uncomment these lines:
require_once(__DIR__.'/../../Exception/ImageWorkshopBaseException.php');
/**
* ImageWorkshopLayerException
*
* Manage ImageWorkshopLayer exceptions
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopLayerException extends ImageWorkshopBaseException
{
}
@@ -1,22 +1,22 @@
<?php
namespace PHPImageWorkshop\Core\Exception;
use PHPImageWorkshop\Exception\ImageWorkshopBaseException as ImageWorkshopBaseException;
// If no autoloader, uncomment these lines:
//require_once(__DIR__.'/../../Exception/ImageWorkshopBaseException.php');
/**
* ImageWorkshopLibException
*
* Manage ImageWorkshopLib exceptions
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopLibException extends ImageWorkshopBaseException
{
<?php
namespace PHPImageWorkshop\Core\Exception;
use PHPImageWorkshop\Exception\ImageWorkshopBaseException as ImageWorkshopBaseException;
// If no autoloader, uncomment these lines:
require_once(__DIR__.'/../../Exception/ImageWorkshopBaseException.php');
/**
* ImageWorkshopLibException
*
* Manage ImageWorkshopLib exceptions
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopLibException extends ImageWorkshopBaseException
{
}
File diff suppressed because it is too large Load Diff
+298 -298
View File
@@ -1,299 +1,299 @@
<?php
namespace PHPImageWorkshop\Core;
use PHPImageWorkshop\Core\Exception\ImageWorkshopLibException as ImageWorkshopLibException;
// If no autoloader, uncomment these lines:
//require_once(__DIR__.'/Exception/ImageWorkshopLibException.php');
/**
* ImageWorkshopLib class
*
* Contains some tools to help in some ImageWorkshop calculations
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopLib
{
/**
* @var integer
*/
const ERROR_FONT_NOT_FOUND = 3;
/**
* Calculate the left top positions of a layer inside a parent layer container
* $position: http://phpimageworkshop.com/doc/22/corners-positions-schema-of-an-image.html
*
* @param integer $containerWidth
* @param integer $containerHeight
* @param integer $layerWidth
* @param integer $layerHeight
* @param integer $layerPositionX
* @param integer $layerPositionY
* @param string $position
*
* @return array
*/
public static function calculatePositions($containerWidth, $containerHeight, $layerWidth, $layerHeight, $layerPositionX, $layerPositionY, $position = 'LT')
{
$position = strtolower($position);
if ($position == 'rt') {
$layerPositionX = $containerWidth - $layerWidth - $layerPositionX;
} elseif ($position == 'lb') {
$layerPositionY = $containerHeight - $layerHeight - $layerPositionY;
} elseif ($position == 'rb') {
$layerPositionX = $containerWidth - $layerWidth - $layerPositionX;
$layerPositionY = $containerHeight - $layerHeight - $layerPositionY;
} elseif ($position == 'mm') {
$layerPositionX = (($containerWidth - $layerWidth) / 2) + $layerPositionX;
$layerPositionY = (($containerHeight - $layerHeight) / 2) + $layerPositionY;
} elseif ($position == 'mt') {
$layerPositionX = (($containerWidth - $layerWidth) / 2) + $layerPositionX;
} elseif ($position == 'mb') {
$layerPositionX = (($containerWidth - $layerWidth) / 2) + $layerPositionX;
$layerPositionY = $containerHeight - $layerHeight - $layerPositionY;
} elseif ($position == 'lm') {
$layerPositionY = (($containerHeight - $layerHeight) / 2) + $layerPositionY;
} elseif ($position == 'rm') {
$layerPositionX = $containerWidth - $layerWidth - $layerPositionX;
$layerPositionY = (($containerHeight - $layerHeight) / 2) + $layerPositionY;
}
return array(
'x' => $layerPositionX,
'y' => $layerPositionY,
);
}
/**
* Convert Hex color to RGB color format
*
* @param string $hex
*
* @return array
*/
public static function convertHexToRGB($hex)
{
return array(
'R' => (int) base_convert(substr($hex, 0, 2), 16, 10),
'G' => (int) base_convert(substr($hex, 2, 2), 16, 10),
'B' => (int) base_convert(substr($hex, 4, 2), 16, 10),
);
}
/**
* Generate a new image resource var
*
* @param integer $width
* @param integer $height
* @param string $color
* @param integer $opacity
*
* @return resource
*/
public static function generateImage($width = 100, $height = 100, $color = 'ffffff', $opacity = 127)
{
$RGBColors = ImageWorkshopLib::convertHexToRGB($color);
$image = imagecreatetruecolor($width, $height);
imagesavealpha($image, true);
$color = imagecolorallocatealpha($image, $RGBColors['R'], $RGBColors['G'], $RGBColors['B'], $opacity);
imagefill($image, 0, 0, $color);
return $image;
}
/**
* Return dimension of a text
*
* @param $fontSize
* @param $fontAngle
* @param $fontFile
* @param $text
*
* @return array or boolean
*/
public static function getTextBoxDimension($fontSize, $fontAngle, $fontFile, $text)
{
if (!file_exists($fontFile)) {
throw new ImageWorkshopLibException('Can\'t find a font file at this path : "'.$fontFile.'".', static::ERROR_FONT_NOT_FOUND);
}
$box = imagettfbbox($fontSize, $fontAngle, $fontFile, $text);
if (!$box) {
return false;
}
$minX = min(array($box[0], $box[2], $box[4], $box[6]));
$maxX = max(array($box[0], $box[2], $box[4], $box[6]));
$minY = min(array($box[1], $box[3], $box[5], $box[7]));
$maxY = max(array($box[1], $box[3], $box[5], $box[7]));
$width = ($maxX - $minX);
$height = ($maxY - $minY);
$left = abs($minX) + $width;
$top = abs($minY) + $height;
// to calculate the exact bounding box, we write the text in a large image
$img = @imagecreatetruecolor($width << 2, $height << 2);
$white = imagecolorallocate($img, 255, 255, 255);
$black = imagecolorallocate($img, 0, 0, 0);
imagefilledrectangle($img, 0, 0, imagesx($img), imagesy($img), $black);
// for ensure that the text is completely in the image
imagettftext($img, $fontSize, $fontAngle, $left, $top, $white, $fontFile, $text);
// start scanning (0=> black => empty)
$rleft = $w4 = $width<<2;
$rright = 0;
$rbottom = 0;
$rtop = $h4 = $height<<2;
for ($x = 0; $x < $w4; $x++) {
for ($y = 0; $y < $h4; $y++) {
if (imagecolorat($img, $x, $y)) {
$rleft = min($rleft, $x);
$rright = max($rright, $x);
$rtop = min($rtop, $y);
$rbottom = max($rbottom, $y);
}
}
}
imagedestroy($img);
return array(
'left' => $left - $rleft,
'top' => $top - $rtop,
'width' => $rright - $rleft + 1,
'height' => $rbottom - $rtop + 1,
);
}
/**
* Copy an image on another one and converse transparency
*
* @param resource $destImg
* @param resource $srcImg
* @param integer $destX
* @param integer $destY
* @param integer $srcX
* @param integer $srcY
* @param integer $srcW
* @param integer $srcH
* @param integer $pct
*/
public static function imageCopyMergeAlpha(&$destImg, &$srcImg, $destX, $destY, $srcX, $srcY, $srcW, $srcH, $pct = 0)
{
$destX = (int) $destX;
$destY = (int) $destY;
$srcX = (int) $srcX;
$srcY = (int) $srcY;
$srcW = (int) $srcW;
$srcH = (int) $srcH;
$pct = (int) $pct;
$destW = imageSX($destImg);
$destH = imageSY($destImg);
for ($y = 0; $y < $srcH + $srcY; $y++) {
for ($x = 0; $x < $srcW + $srcX; $x++) {
if ($x + $destX >= 0 && $x + $destX < $destW && $x + $srcX >= 0 && $x + $srcX < $srcW && $y + $destY >= 0 && $y + $destY < $destH && $y + $srcY >= 0 && $y + $srcY < $srcH) {
$destPixel = imageColorsForIndex($destImg, imageColorat($destImg, $x + $destX, $y + $destY));
$srcImgColorat = imageColorat($srcImg, $x + $srcX, $y + $srcY);
if ($srcImgColorat >= 0) {
$srcPixel = imageColorsForIndex($srcImg, $srcImgColorat);
$srcAlpha = 1 - ($srcPixel['alpha'] / 127);
$destAlpha = 1 - ($destPixel['alpha'] / 127);
$opacity = $srcAlpha * $pct / 100;
if ($destAlpha >= $opacity) {
$alpha = $destAlpha;
}
if ($destAlpha < $opacity) {
$alpha = $opacity;
}
if ($alpha > 1) {
$alpha = 1;
}
if ($opacity > 0) {
$destRed = round((($destPixel['red'] * $destAlpha * (1 - $opacity))));
$destGreen = round((($destPixel['green'] * $destAlpha * (1 - $opacity))));
$destBlue = round((($destPixel['blue'] * $destAlpha * (1 - $opacity))));
$srcRed = round((($srcPixel['red'] * $opacity)));
$srcGreen = round((($srcPixel['green'] * $opacity)));
$srcBlue = round((($srcPixel['blue'] * $opacity)));
$red = round(($destRed + $srcRed ) / ($destAlpha * (1 - $opacity) + $opacity));
$green = round(($destGreen + $srcGreen) / ($destAlpha * (1 - $opacity) + $opacity));
$blue = round(($destBlue + $srcBlue ) / ($destAlpha * (1 - $opacity) + $opacity));
if ($red > 255) {
$red = 255;
}
if ($green > 255) {
$green = 255;
}
if ($blue > 255) {
$blue = 255;
}
$alpha = round((1 - $alpha) * 127);
$color = imageColorAllocateAlpha($destImg, $red, $green, $blue, $alpha);
imageSetPixel($destImg, $x + $destX, $y + $destY, $color);
}
}
}
}
}
}
/**
* Merge two image var
*
* @param resource $destinationImage
* @param resource $sourceImage
* @param integer $destinationPosX
* @param integer $destinationPosY
* @param integer $sourcePosX
* @param integer $sourcePosY
*/
public static function mergeTwoImages(&$destinationImage, $sourceImage, $destinationPosX = 0, $destinationPosY = 0, $sourcePosX = 0, $sourcePosY = 0)
{
imageCopy($destinationImage, $sourceImage, $destinationPosX, $destinationPosY, $sourcePosX, $sourcePosY, imageSX($sourceImage), imageSY($sourceImage));
}
<?php
namespace PHPImageWorkshop\Core;
use PHPImageWorkshop\Core\Exception\ImageWorkshopLibException as ImageWorkshopLibException;
// If no autoloader, uncomment these lines:
require_once(__DIR__.'/Exception/ImageWorkshopLibException.php');
/**
* ImageWorkshopLib class
*
* Contains some tools to help in some ImageWorkshop calculations
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopLib
{
/**
* @var integer
*/
const ERROR_FONT_NOT_FOUND = 3;
/**
* Calculate the left top positions of a layer inside a parent layer container
* $position: http://phpimageworkshop.com/doc/22/corners-positions-schema-of-an-image.html
*
* @param integer $containerWidth
* @param integer $containerHeight
* @param integer $layerWidth
* @param integer $layerHeight
* @param integer $layerPositionX
* @param integer $layerPositionY
* @param string $position
*
* @return array
*/
public static function calculatePositions($containerWidth, $containerHeight, $layerWidth, $layerHeight, $layerPositionX, $layerPositionY, $position = 'LT')
{
$position = strtolower($position);
if ($position == 'rt') {
$layerPositionX = $containerWidth - $layerWidth - $layerPositionX;
} elseif ($position == 'lb') {
$layerPositionY = $containerHeight - $layerHeight - $layerPositionY;
} elseif ($position == 'rb') {
$layerPositionX = $containerWidth - $layerWidth - $layerPositionX;
$layerPositionY = $containerHeight - $layerHeight - $layerPositionY;
} elseif ($position == 'mm') {
$layerPositionX = (($containerWidth - $layerWidth) / 2) + $layerPositionX;
$layerPositionY = (($containerHeight - $layerHeight) / 2) + $layerPositionY;
} elseif ($position == 'mt') {
$layerPositionX = (($containerWidth - $layerWidth) / 2) + $layerPositionX;
} elseif ($position == 'mb') {
$layerPositionX = (($containerWidth - $layerWidth) / 2) + $layerPositionX;
$layerPositionY = $containerHeight - $layerHeight - $layerPositionY;
} elseif ($position == 'lm') {
$layerPositionY = (($containerHeight - $layerHeight) / 2) + $layerPositionY;
} elseif ($position == 'rm') {
$layerPositionX = $containerWidth - $layerWidth - $layerPositionX;
$layerPositionY = (($containerHeight - $layerHeight) / 2) + $layerPositionY;
}
return array(
'x' => $layerPositionX,
'y' => $layerPositionY,
);
}
/**
* Convert Hex color to RGB color format
*
* @param string $hex
*
* @return array
*/
public static function convertHexToRGB($hex)
{
return array(
'R' => (int) base_convert(substr($hex, 0, 2), 16, 10),
'G' => (int) base_convert(substr($hex, 2, 2), 16, 10),
'B' => (int) base_convert(substr($hex, 4, 2), 16, 10),
);
}
/**
* Generate a new image resource var
*
* @param integer $width
* @param integer $height
* @param string $color
* @param integer $opacity
*
* @return resource
*/
public static function generateImage($width = 100, $height = 100, $color = 'ffffff', $opacity = 127)
{
$RGBColors = ImageWorkshopLib::convertHexToRGB($color);
$image = imagecreatetruecolor($width, $height);
imagesavealpha($image, true);
$color = imagecolorallocatealpha($image, $RGBColors['R'], $RGBColors['G'], $RGBColors['B'], $opacity);
imagefill($image, 0, 0, $color);
return $image;
}
/**
* Return dimension of a text
*
* @param $fontSize
* @param $fontAngle
* @param $fontFile
* @param $text
*
* @return array or boolean
*/
public static function getTextBoxDimension($fontSize, $fontAngle, $fontFile, $text)
{
if (!file_exists($fontFile)) {
throw new ImageWorkshopLibException('Can\'t find a font file at this path : "'.$fontFile.'".', static::ERROR_FONT_NOT_FOUND);
}
$box = imagettfbbox($fontSize, $fontAngle, $fontFile, $text);
if (!$box) {
return false;
}
$minX = min(array($box[0], $box[2], $box[4], $box[6]));
$maxX = max(array($box[0], $box[2], $box[4], $box[6]));
$minY = min(array($box[1], $box[3], $box[5], $box[7]));
$maxY = max(array($box[1], $box[3], $box[5], $box[7]));
$width = ($maxX - $minX);
$height = ($maxY - $minY);
$left = abs($minX) + $width;
$top = abs($minY) + $height;
// to calculate the exact bounding box, we write the text in a large image
$img = @imagecreatetruecolor($width << 2, $height << 2);
$white = imagecolorallocate($img, 255, 255, 255);
$black = imagecolorallocate($img, 0, 0, 0);
imagefilledrectangle($img, 0, 0, imagesx($img), imagesy($img), $black);
// for ensure that the text is completely in the image
imagettftext($img, $fontSize, $fontAngle, $left, $top, $white, $fontFile, $text);
// start scanning (0=> black => empty)
$rleft = $w4 = $width<<2;
$rright = 0;
$rbottom = 0;
$rtop = $h4 = $height<<2;
for ($x = 0; $x < $w4; $x++) {
for ($y = 0; $y < $h4; $y++) {
if (imagecolorat($img, $x, $y)) {
$rleft = min($rleft, $x);
$rright = max($rright, $x);
$rtop = min($rtop, $y);
$rbottom = max($rbottom, $y);
}
}
}
imagedestroy($img);
return array(
'left' => $left - $rleft,
'top' => $top - $rtop,
'width' => $rright - $rleft + 1,
'height' => $rbottom - $rtop + 1,
);
}
/**
* Copy an image on another one and converse transparency
*
* @param resource $destImg
* @param resource $srcImg
* @param integer $destX
* @param integer $destY
* @param integer $srcX
* @param integer $srcY
* @param integer $srcW
* @param integer $srcH
* @param integer $pct
*/
public static function imageCopyMergeAlpha(&$destImg, &$srcImg, $destX, $destY, $srcX, $srcY, $srcW, $srcH, $pct = 0)
{
$destX = (int) $destX;
$destY = (int) $destY;
$srcX = (int) $srcX;
$srcY = (int) $srcY;
$srcW = (int) $srcW;
$srcH = (int) $srcH;
$pct = (int) $pct;
$destW = imageSX($destImg);
$destH = imageSY($destImg);
for ($y = 0; $y < $srcH + $srcY; $y++) {
for ($x = 0; $x < $srcW + $srcX; $x++) {
if ($x + $destX >= 0 && $x + $destX < $destW && $x + $srcX >= 0 && $x + $srcX < $srcW && $y + $destY >= 0 && $y + $destY < $destH && $y + $srcY >= 0 && $y + $srcY < $srcH) {
$destPixel = imageColorsForIndex($destImg, imageColorat($destImg, $x + $destX, $y + $destY));
$srcImgColorat = imageColorat($srcImg, $x + $srcX, $y + $srcY);
if ($srcImgColorat >= 0) {
$srcPixel = imageColorsForIndex($srcImg, $srcImgColorat);
$srcAlpha = 1 - ($srcPixel['alpha'] / 127);
$destAlpha = 1 - ($destPixel['alpha'] / 127);
$opacity = $srcAlpha * $pct / 100;
if ($destAlpha >= $opacity) {
$alpha = $destAlpha;
}
if ($destAlpha < $opacity) {
$alpha = $opacity;
}
if ($alpha > 1) {
$alpha = 1;
}
if ($opacity > 0) {
$destRed = round((($destPixel['red'] * $destAlpha * (1 - $opacity))));
$destGreen = round((($destPixel['green'] * $destAlpha * (1 - $opacity))));
$destBlue = round((($destPixel['blue'] * $destAlpha * (1 - $opacity))));
$srcRed = round((($srcPixel['red'] * $opacity)));
$srcGreen = round((($srcPixel['green'] * $opacity)));
$srcBlue = round((($srcPixel['blue'] * $opacity)));
$red = round(($destRed + $srcRed ) / ($destAlpha * (1 - $opacity) + $opacity));
$green = round(($destGreen + $srcGreen) / ($destAlpha * (1 - $opacity) + $opacity));
$blue = round(($destBlue + $srcBlue ) / ($destAlpha * (1 - $opacity) + $opacity));
if ($red > 255) {
$red = 255;
}
if ($green > 255) {
$green = 255;
}
if ($blue > 255) {
$blue = 255;
}
$alpha = round((1 - $alpha) * 127);
$color = imageColorAllocateAlpha($destImg, $red, $green, $blue, $alpha);
imageSetPixel($destImg, $x + $destX, $y + $destY, $color);
}
}
}
}
}
}
/**
* Merge two image var
*
* @param resource $destinationImage
* @param resource $sourceImage
* @param integer $destinationPosX
* @param integer $destinationPosY
* @param integer $sourcePosX
* @param integer $sourcePosY
*/
public static function mergeTwoImages(&$destinationImage, $sourceImage, $destinationPosX = 0, $destinationPosY = 0, $sourcePosX = 0, $sourcePosY = 0)
{
imageCopy($destinationImage, $sourceImage, $destinationPosX, $destinationPosY, $sourcePosX, $sourcePosY, imageSX($sourceImage), imageSY($sourceImage));
}
}
@@ -1,38 +1,38 @@
<?php
namespace PHPImageWorkshop\Exception;
/**
* ImageWorkshopBaseException
*
* The inherited exception class
*
* @link http://phpimageworkshop.com
* @author Bjørn Børresen | Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopBaseException extends \Exception
{
/**
* Constructor
*
* @param string $message
* @param integer $code
* @param Exception $previous
*/
public function __construct($message, $code = 0, \Exception $previous = null)
{
parent::__construct($message, $code, $previous);
}
/**
* __toString method
*
* @return string
*/
public function __toString()
{
return __CLASS__.": [{$this->code}]: {$this->message}\n";
}
<?php
namespace PHPImageWorkshop\Exception;
/**
* ImageWorkshopBaseException
*
* The inherited exception class
*
* @link http://phpimageworkshop.com
* @author Bjørn Børresen | Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopBaseException extends \Exception
{
/**
* Constructor
*
* @param string $message
* @param integer $code
* @param Exception $previous
*/
public function __construct($message, $code = 0, \Exception $previous = null)
{
parent::__construct($message, $code, $previous);
}
/**
* __toString method
*
* @return string
*/
public function __toString()
{
return __CLASS__.": [{$this->code}]: {$this->message}\n";
}
}
@@ -1,22 +1,22 @@
<?php
namespace PHPImageWorkshop\Exception;
use PHPImageWorkshop\Exception\ImageWorkshopBaseException as ImageWorkshopBaseException;
// If no autoloader, uncomment these lines:
//require_once(__DIR__.'/ImageWorkshopBaseException.php');
/**
* ImageWorkshopException
*
* Manage ImageWorkshop exceptions
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopException extends ImageWorkshopBaseException
{
<?php
namespace PHPImageWorkshop\Exception;
use PHPImageWorkshop\Exception\ImageWorkshopBaseException as ImageWorkshopBaseException;
// If no autoloader, uncomment these lines:
require_once(__DIR__.'/ImageWorkshopBaseException.php');
/**
* ImageWorkshopException
*
* Manage ImageWorkshop exceptions
*
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshopException extends ImageWorkshopBaseException
{
}
+167 -167
View File
@@ -1,168 +1,168 @@
<?php
namespace PHPImageWorkshop;
use PHPImageWorkshop\Core\ImageWorkshopLayer as ImageWorkshopLayer;
use PHPImageWorkshop\Core\ImageWorkshopLib as ImageWorkshopLib;
use PHPImageWorkshop\Exception\ImageWorkshopException as ImageWorkshopException;
// If no autoloader, uncomment these lines:
//require_once(__DIR__.'/Core/ImageWorkshopLayer.php');
//require_once(__DIR__.'/Exception/ImageWorkshopException.php');
/**
* ImageWorkshop class
*
* Use this class as a factory to initialize ImageWorkshop layers
*
* @version 2.0.6
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshop
{
/**
* @var integer
*/
const ERROR_NOT_AN_IMAGE_FILE = 1;
/**
* @var integer
*/
const ERROR_IMAGE_NOT_FOUND = 2;
/**
* @var integer
*/
const ERROR_NOT_WRITABLE_FILE = 3;
/**
* @var integer
*/
const ERROR_CREATE_IMAGE_FROM_STRING = 4;
/**
* Initialize a layer from a given image path
*
* From an upload form, you can give the "tmp_name" path
*
* @param string $path
*
* @return ImageWorkshopLayer
*/
public static function initFromPath($path)
{
if (file_exists($path) && !is_dir($path)) {
if (!is_readable($path)) {
throw new ImageWorkshopException('Can\'t open the file at "'.$path.'" : file is not writable, did you check permissions (755 / 777) ?', static::ERROR_NOT_WRITABLE_FILE);
}
$imageSizeInfos = @getImageSize($path);
$mimeContentType = explode('/', $imageSizeInfos['mime']);
if (!$mimeContentType || !array_key_exists(1, $mimeContentType)) {
throw new ImageWorkshopException('Not an image file (jpeg/png/gif) at "'.$path.'"', static::ERROR_NOT_AN_IMAGE_FILE);
}
$mimeContentType = $mimeContentType[1];
switch ($mimeContentType) {
case 'jpeg':
$image = imageCreateFromJPEG($path);
break;
case 'gif':
$image = imageCreateFromGIF($path);
break;
case 'png':
$image = imageCreateFromPNG($path);
break;
default:
throw new ImageWorkshopException('Not an image file (jpeg/png/gif) at "'.$path.'"', static::ERROR_NOT_AN_IMAGE_FILE);
break;
}
return new ImageWorkshopLayer($image);
}
throw new ImageWorkshopException('No such file found at "'.$path.'"', static::ERROR_IMAGE_NOT_FOUND);
}
/**
* Initialize a text layer
*
* @param string $text
* @param string $fontPath
* @param integer $fontSize
* @param string $fontColor
* @param integer $textRotation
* @param integer $backgroundColor
*
* @return ImageWorkshopLayer
*/
public static function initTextLayer($text, $fontPath, $fontSize = 13, $fontColor = 'ffffff', $textRotation = 0, $backgroundColor = null)
{
$textDimensions = ImageWorkshopLib::getTextBoxDimension($fontSize, $textRotation, $fontPath, $text);
$layer = static::initVirginLayer($textDimensions['width'], $textDimensions['height'], $backgroundColor);
$layer->write($text, $fontPath, $fontSize, $fontColor, $textDimensions['left'], $textDimensions['top'], $textRotation);
return $layer;
}
/**
* Initialize a new virgin layer
*
* @param integer $width
* @param integer $height
* @param string $backgroundColor
*
* @return ImageWorkshopLayer
*/
public static function initVirginLayer($width = 100, $height = 100, $backgroundColor = null)
{
$opacity = 0;
if (!$backgroundColor || $backgroundColor == 'transparent') {
$opacity = 127;
$backgroundColor = 'ffffff';
}
return new ImageWorkshopLayer(ImageWorkshopLib::generateImage($width, $height, $backgroundColor, $opacity));
}
/**
* Initialize a layer from a resource image var
*
* @param \resource $image
*
* @return ImageWorkshopLayer
*/
public static function initFromResourceVar($image)
{
return new ImageWorkshopLayer($image);
}
/**
* Initialize a layer from a string (obtains with file_get_contents, cURL...)
*
* This not recommanded to initialize JPEG string with this method, GD displays bugs !
*
* @param string $imageString
*
* @return ImageWorkshopLayer
*/
public static function initFromString($imageString)
{
if (!$image = @imageCreateFromString($imageString)) {
throw new ImageWorkshopException('Can\'t generate an image from the given string.', static::ERROR_CREATE_IMAGE_FROM_STRING);
}
return new ImageWorkshopLayer($image);
}
<?php
namespace PHPImageWorkshop;
use PHPImageWorkshop\Core\ImageWorkshopLayer as ImageWorkshopLayer;
use PHPImageWorkshop\Core\ImageWorkshopLib as ImageWorkshopLib;
use PHPImageWorkshop\Exception\ImageWorkshopException as ImageWorkshopException;
// If no autoloader, uncomment these lines:
require_once(__DIR__.'/Core/ImageWorkshopLayer.php');
require_once(__DIR__.'/Exception/ImageWorkshopException.php');
/**
* ImageWorkshop class
*
* Use this class as a factory to initialize ImageWorkshop layers
*
* @version 2.0.6
* @link http://phpimageworkshop.com
* @author Sybio (Clément Guillemain / @Sybio01)
* @license http://en.wikipedia.org/wiki/MIT_License
* @copyright Clément Guillemain
*/
class ImageWorkshop
{
/**
* @var integer
*/
const ERROR_NOT_AN_IMAGE_FILE = 1;
/**
* @var integer
*/
const ERROR_IMAGE_NOT_FOUND = 2;
/**
* @var integer
*/
const ERROR_NOT_WRITABLE_FILE = 3;
/**
* @var integer
*/
const ERROR_CREATE_IMAGE_FROM_STRING = 4;
/**
* Initialize a layer from a given image path
*
* From an upload form, you can give the "tmp_name" path
*
* @param string $path
*
* @return ImageWorkshopLayer
*/
public static function initFromPath($path)
{
if (file_exists($path) && !is_dir($path)) {
if (!is_readable($path)) {
throw new ImageWorkshopException('Can\'t open the file at "'.$path.'" : file is not writable, did you check permissions (755 / 777) ?', static::ERROR_NOT_WRITABLE_FILE);
}
$imageSizeInfos = @getImageSize($path);
$mimeContentType = explode('/', $imageSizeInfos['mime']);
if (!$mimeContentType || !array_key_exists(1, $mimeContentType)) {
throw new ImageWorkshopException('Not an image file (jpeg/png/gif) at "'.$path.'"', static::ERROR_NOT_AN_IMAGE_FILE);
}
$mimeContentType = $mimeContentType[1];
switch ($mimeContentType) {
case 'jpeg':
$image = imageCreateFromJPEG($path);
break;
case 'gif':
$image = imageCreateFromGIF($path);
break;
case 'png':
$image = imageCreateFromPNG($path);
break;
default:
throw new ImageWorkshopException('Not an image file (jpeg/png/gif) at "'.$path.'"', static::ERROR_NOT_AN_IMAGE_FILE);
break;
}
return new ImageWorkshopLayer($image);
}
throw new ImageWorkshopException('No such file found at "'.$path.'"', static::ERROR_IMAGE_NOT_FOUND);
}
/**
* Initialize a text layer
*
* @param string $text
* @param string $fontPath
* @param integer $fontSize
* @param string $fontColor
* @param integer $textRotation
* @param integer $backgroundColor
*
* @return ImageWorkshopLayer
*/
public static function initTextLayer($text, $fontPath, $fontSize = 13, $fontColor = 'ffffff', $textRotation = 0, $backgroundColor = null)
{
$textDimensions = ImageWorkshopLib::getTextBoxDimension($fontSize, $textRotation, $fontPath, $text);
$layer = static::initVirginLayer($textDimensions['width'], $textDimensions['height'], $backgroundColor);
$layer->write($text, $fontPath, $fontSize, $fontColor, $textDimensions['left'], $textDimensions['top'], $textRotation);
return $layer;
}
/**
* Initialize a new virgin layer
*
* @param integer $width
* @param integer $height
* @param string $backgroundColor
*
* @return ImageWorkshopLayer
*/
public static function initVirginLayer($width = 100, $height = 100, $backgroundColor = null)
{
$opacity = 0;
if (!$backgroundColor || $backgroundColor == 'transparent') {
$opacity = 127;
$backgroundColor = 'ffffff';
}
return new ImageWorkshopLayer(ImageWorkshopLib::generateImage($width, $height, $backgroundColor, $opacity));
}
/**
* Initialize a layer from a resource image var
*
* @param \resource $image
*
* @return ImageWorkshopLayer
*/
public static function initFromResourceVar($image)
{
return new ImageWorkshopLayer($image);
}
/**
* Initialize a layer from a string (obtains with file_get_contents, cURL...)
*
* This not recommanded to initialize JPEG string with this method, GD displays bugs !
*
* @param string $imageString
*
* @return ImageWorkshopLayer
*/
public static function initFromString($imageString)
{
if (!$image = @imageCreateFromString($imageString)) {
throw new ImageWorkshopException('Can\'t generate an image from the given string.', static::ERROR_CREATE_IMAGE_FROM_STRING);
}
return new ImageWorkshopLayer($image);
}
}
+10 -8
View File
@@ -1,8 +1,10 @@
<?php
$allowedHost = array(
"localhost",
"app.gruppolapastamadre.it",
"dev.gruppolapastamadre.it",
"management.gruppolapastamadre.it"
);
<?php
$allowedHost = array(
"localhost",
"app.gruppolapastamadre.it",
"dev.gruppolapastamadre.it",
"management.gruppolapastamadre.it"
);
$dirRicetteDropBox = "IlLievitario/Images/Ricette";
+158 -103
View File
@@ -1,103 +1,158 @@
<?php
// inclusione del file contenente la classe
require_once "./include.php";
use PHPImageWorkshop\ImageWorkshop;
require_once('PHPImageWorkshop/ImageWorkshop.php'); // Be sure of the path to the class
//include "./SimpleImage.php";
$app->get('/photos/thumbnail/:imageID(/:createImgTag)', function ($imageID, $createImgTag = 0) use ($app) {
$mysqlconnetion = new MysqlClass;
$retObj = $mysqlconnetion->queryToObject("select type_format, image_thumbnail from immagini where id=" . $imageID, false);
$mysqlconnetion->disconnetti();
if($createImgTag)
echo '<img src="data:' . $retObj["type_format"] . ';base64,' . base64_encode($retObj['image_thumbnail']) . '"/>';
else
{
$app->contentType($retObj["type_format"]);
echo $retObj['image_thumbnail'];
}
});
$app->get('/photos/:imageID(/:createImgTag)', function ($imageID, $createImgTag = 0) use ($app) {
$mysqlconnetion = new MysqlClass;
$retObj = $mysqlconnetion->queryToObject("select type_format, image from immagini where id=" . $imageID, false);
$mysqlconnetion->disconnetti();
if($createImgTag)
echo '<img src="';
echo 'data:' . $retObj["type_format"] . ';base64,'.base64_encode( $retObj['image'] );
if($createImgTag)
echo '"/>';
});
$app->put('/photos/publish/:imageID', function ($imageID) use ($app) {
$mysqlconnetion = new MysqlClass;
$query = "update immagini set published = 1, published_date = NOW() where ProfiloID = " . $imageID;
$mysqlconnetion->disconnetti();
$mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
});
$app->post('/photos', function () use ($app) {
$idRicette = $app->request()->post('ricetta_id');
$profileID = $app->request()->post('keyStore');
$imageFileName = $_FILES['image']["tmp_name"];
$layer = ImageWorkshop::initFromPath($imageFileName);
$layer->resizeByLargestSideInPixel(640, true);
$layer->save(dirname($imageFileName), basename($imageFileName));
$imgData = addslashes(file_get_contents($imageFileName));
$layer->resizeByLargestSideInPixel(300, true);
$layer->save(dirname($imageFileName), basename($imageFileName));
$ThumbImageData = addslashes(file_get_contents($imageFileName));
// istanza della classe
$mysqlconnetion = new MysqlClass;
//$mysqlconneti on->connetti();
$query = "insert into immagini(id_ricette, type_format, image_thumbnail, image, from_profile_id, uploaded_date) " .
"values(" . $idRicette . ", '" . image_type_to_mime_type($image->image_type) .
"', '" . $ThumbImageData . "', '" . $imgData . "', '" . $profileID . "', NOW())";
$newID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
echo $newID;
});
$app->put('/photos/:imageID', function ($imageID) use ($app) {
$imageFileName = $_FILES['image']["tmp_name"];
$layer = ImageWorkshop::initFromPath($imageFileName);
$layer->resizeByLargestSideInPixel(640, true);
$layer->save(dirname($imageFileName), basename($imageFileName));
$imgData = addslashes(file_get_contents($imageFileName));
$layer->resizeByLargestSideInPixel(300, true);
$layer->save(dirname($imageFileName), basename($imageFileName));
$ThumbImageData = addslashes(file_get_contents($imageFileName));
// istanza della classe
$mysqlconnetion = new MysqlClass;
//$mysqlconneti on->connetti();
$query = "update immagini set (type_format = '" . image_type_to_mime_type($image->image_type) . "', " .
"image_thumbnail = '" . $ThumbImageData . "', " .
"image = '" . $imgData . "' where id=" . $imageID;
$newID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
return $newID;
});
<?php
// inclusione del file contenente la classe
require_once "./include.php";
require_once "./myDropBoxObj.php";
use PHPImageWorkshop\ImageWorkshop;
require_once 'PHPImageWorkshop/ImageWorkshop.php'; // Be sure of the path to the class
//include "./SimpleImage.php";
$app->get('/photos/thumbnail/:imageID(/:createImgTag)', function ($imageID, $createImgTag = 0) use ($app, $dirRicetteDropBox) {
$mysqlconnetion = new MysqlClass;
$retObj = $mysqlconnetion->queryToObject("select type_format, id_ricette from immagini where id=" . $imageID, false);
$mysqlconnetion->disconnetti();
$ext = "";
if ($retObj["type_format"] == "image/jpeg") {
$ext = "jpg";
} else if ($retObj["type_format"] == "image/png") {
$ext = "png";
}
$folder = $dirRicetteDropBox . "/" . $retObj["id_ricette"];
$imageFileName = $imageID . "_thumb_ricetta." . $ext;
$dropBoxObj = new myDropBox();
if ($createImgTag) {
echo '<img src="';
}
echo $dropBoxObj->GetLink($folder . "/" . $imageFileName);
if ($createImgTag) {
echo '"/>';
}
});
$app->get('/photos/:imageID(/:createImgTag)', function ($imageID, $createImgTag = 0) use ($app, $dirRicetteDropBox) {
$mysqlconnetion = new MysqlClass;
$retObj = $mysqlconnetion->queryToObject("select type_format, id_ricette from immagini where id=" . $imageID, false);
$mysqlconnetion->disconnetti();
$ext = "";
if ($retObj["type_format"] == "image/jpeg") {
$ext = "jpg";
} else if ($retObj["type_format"] == "image/png") {
$ext = "png";
}
$folder = $dirRicetteDropBox . "/" . $retObj["id_ricette"];
$imageFileName = $imageID . "_full_ricetta." . $ext;
$dropBoxObj = new myDropBox();
if ($createImgTag) {
echo '<img src="';
}
echo $dropBoxObj->GetLink($folder . "/" . $imageFileName);
if ($createImgTag) {
echo '"/>';
}
});
$app->put('/photos/publish/:imageID', function ($imageID) use ($app) {
$mysqlconnetion = new MysqlClass;
$query = "update immagini set published = 1, published_date = NOW() where id = " . $imageID;
$mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
});
$app->post('/photos', function () use ($app, $dirRicetteDropBox) {
$idRicette = $app->request()->post('ricetta_id');
$profileID = $app->request()->post('keyStore');
$tmpFileName = $_FILES['image']["tmp_name"];
$layer = ImageWorkshop::initFromPath($tmpFileName);
// istanza della classe
$mysqlconnetion = new MysqlClass;
//$mysqlconneti on->connetti();
$query = "insert into immagini(id_ricette, type_format, from_profile_id, uploaded_date) " .
"values(" . $idRicette . ", '" . image_type_to_mime_type(exif_imagetype($tmpFileName)) .
"', '" . $profileID . "', NOW())";
$newID = $mysqlconnetion->insertRecord($query);
$ext = image_type_to_extension(exif_imagetype($tmpFileName), FALSE);
$imageFileName = $newID . "_full_ricetta." . $ext;
$thumbFileName = $newID . "_thumb_ricetta." . $ext;
$layer->resizeByLargestSideInPixel(640, true);
$layer->save(dirname($tmpFileName), $imageFileName);
$layer->resizeByLargestSideInPixel(300, true);
$layer->save(dirname($tmpFileName), $thumbFileName);
$dropBoxObj = new myDropBox();
$folder = $dirRicetteDropBox . "/" . $idRicette;
try {
$dropBoxObj->CreateFolder($folder);
} catch (DropboxException $ex) {
}
$fullPath = dirname($tmpFileName) . "/" . $imageFileName;
echo $fullPath . "\n";
$thumbPath = dirname($tmpFileName) . "/" . $thumbFileName;
echo $thumbPath . "\n";
$dropBoxObj->UploadFile($fullPath, $folder . "/" . $imageFileName);
$dropBoxObj->UploadFile($thumbPath, $folder . "/" . $thumbFileName);
$mysqlconnetion->disconnetti();
echo $newID;
});
$app->put('/photos/:imageID', function ($imageID) use ($app, $dirRicetteDropBox) {
$tmpFileName = $_FILES['image']["tmp_name"];
$layer = ImageWorkshop::initFromPath($tmpFileName);
// istanza della classe
$mysqlconnetion = new MysqlClass;
//$mysqlconneti on->connetti();
$query = "update immagini set (type_format = '" . image_type_to_mime_type(exif_imagetype($tmpFileName)) . "', " .
" where id=" . $imageID;
$newID = $mysqlconnetion->insertRecord($query);
$imageFileName = $imageID . "_full_ricetta";
$thumbFileName = $imageID . "_thumb_ricetta";
$layer->resizeByLargestSideInPixel(640, true);
$layer->save(dirname($tmpFileName), $imageFileName);
$layer->resizeByLargestSideInPixel(300, true);
$layer->save(dirname($tmpFileName), $thumbFileName);
$dropBoxObj = new myDropBox();
$folder = $dirRicetteDropBox . "/" . $idRicette;
$dropBoxObj->UploadFile(dirname($tmpFileName) . DIRECTORY_SEPARATOR . $imageFileName, $folder . "\\" . $imageFileName);
$dropBoxObj->UploadFile(dirname($tmpFileName) . DIRECTORY_SEPARATOR . $thumbFileName, $folder . "\\" . $thumbFileName);
$mysqlconnetion->disconnetti();
return $newID;
});
+4 -1
View File
@@ -14,7 +14,10 @@ $app = new \Slim\Slim();
$app->hook('slim.before.router', function () use ($app, $allowedHost) {
$currentRefererRequest = $app->request()->getReferer();
$currentRefererRequest = substr(substr($currentRefererRequest, 7), 0, strpos(substr($currentRefererRequest, 7), '/'));
$currentRefererRequest = substr($currentRefererRequest, 7); //Senza http://
$indexDoublePoint = strpos($currentRefererRequest, ':');
$indexFirstSlash = strpos($currentRefererRequest, '/');
$currentRefererRequest = substr($currentRefererRequest, 0, $indexDoublePoint > 0 && $indexDoublePoint < $indexFirstSlash ? $indexDoublePoint : $indexFirstSlash );
if(!in_array($currentRefererRequest, $allowedHost))
{
$app->halt(500, "Generic error occurred");
+164 -164
View File
@@ -1,165 +1,165 @@
<?php
$app->get('/categories', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconneti on->connetti();
$retObj = $mysqlconnetion->queryToObject("select ID as category_id, NAME as name from categorie order by name");
$mysqlconnetion->disconnetti();
returnJsonWithDecode($app, $callbackFn, $retObj);
});
$app->get('/typeingredients', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject("select ID as tipo_ingredienti_id, name from tipo_ingredienti order by name");
$mysqlconnetion->disconnetti();
returnJsonWithDecode($app, $callbackFn, $retObj);
});
$app->get('/typeqtys', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject("select ID as tipo_quantita_id, name from tipo_quantita");
$mysqlconnetion->disconnetti();
returnJsonWithDecode($app, $callbackFn, $retObj);
});
$app->get('/categoryitems/:catID', function ($categoryID) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$query = "select ID as ricetta_id, titolo, autore, valutazione, difficolta from ricette where ID_CATEGORIA = " . $categoryID . " order by titolo, autore";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
$app->get('/ricetta/body/:itemID', function ($itemID) use ($app) {
$callbackFn = $app->request()->get('callback');
// istanza della classe
$mysqlconnetion = new MysqlClass;
$query = "SELECT id_categoria, categorie.name AS categoria_name, ricette.ID AS ricetta_id, titolo, procedimento, autore, link_fonte, link_youtube, valutazione, difficolta FROM ricette INNER JOIN categorie ON categorie.ID = ricette.id_categoria WHERE ricette.ID = " . $itemID;
$retObj = $mysqlconnetion->queryToObject($query);
$query2 = "select ingredienti.id_tipo_ingredienti, tipo_ingredienti.name as nome_ingrediente, quantita, ingredienti.id_tipo_quantita, tipo_quantita.Name as unita, note, posizione from ingredienti " .
"inner join tipo_ingredienti on ingredienti.ID_TIPO_INGREDIENTI = tipo_ingredienti.ID " .
"left outer join tipo_quantita on ingredienti.ID_TIPO_QUANTITA = tipo_quantita.ID " .
"where ingredienti.ID_RICETTE = " . $itemID . " order by ingredienti.posizione";
$retObj2 = $mysqlconnetion->queryToObject($query2);
$retObj[0]["titolo"] = html_entity_decode($retObj[0]["titolo"],ENT_COMPAT | ENT_HTML401,'ISO-8859-1');
$retObj[0]["procedimento"] = html_entity_decode($retObj[0]["procedimento"],ENT_COMPAT | ENT_HTML401,'ISO-8859-1');
$retObj[0]["ingredienti"] = $retObj2;
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
$app->post('/typeingredients', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('bodydata'));
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$query = "insert into tipo_ingredienti(Name) values ('" . $json_data_body->name . "')";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->post('/ricetta/body', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('bodydata'));
$retValue["result"] = true;
$retValue["message"] = "";
$mysqlconnetion = new MysqlClass;
// istanza della classe
try {
$retNewID = 0;
if ($json_data_body->ricettaID != "") {
$query = "update ricette SET ID_CATEGORIA = " . $json_data_body->categoria_id .
", titolo = '" . htmlentities($json_data_body->titolo, null, "UTF-8") .
"', procedimento = '" . str_replace("'", "''", htmlentities($json_data_body->preparazione, null, "UTF-8")) .
"', autore = '" . str_replace("'", "''", $json_data_body->autore) .
"', link_fonte = '" . $json_data_body->linkFonte .
"', Link_youtube = '" . $json_data_body->linkVideo .
"', Difficolta = '" . $json_data_body->difficolta .
"' where ID = " . $json_data_body->ricettaID;
$mysqlconnetion->executeQuery($query);
$queryDelete = "DELETE FROM ingredienti where ID_RICETTE = " . $json_data_body->ricettaID;
$mysqlconnetion->executeQuery($queryDelete);
$retNewID = $json_data_body->ricettaID;
} else {
$query = "insert into ricette(ID_CATEGORIA, titolo, procedimento, autore, link_fonte, Link_youtube,Difficolta) values (" .
$json_data_body->categoria_id . ",'" . htmlentities($json_data_body->titolo, null, "UTF-8") . "','" . str_replace("'", "''", htmlentities($json_data_body->preparazione, null, "UTF-8")) .
"','" . str_replace("'", "''", $json_data_body->autore) . "','" .
$json_data_body->linkFonte . "','" . $json_data_body->linkVideo . "', " . $json_data_body->difficolta . ")";
$retNewID = $mysqlconnetion->insertRecord($query);
}
$pos = 0;
foreach ($json_data_body->ingredienti as $arr) {
$note = "";
if ($arr->note != "") {
$note = str_replace("'", "''", htmlentities($arr->note));
}
$query = "insert into ingredienti(ID_TIPO_INGREDIENTI, ID_RICETTE, Quantita, ID_TIPO_QUANTITA, Note, Posizione) values (" .
$arr->ingrediente_id . "," . $retNewID . "," . ($arr->quantita == "" ? "0" : $arr->quantita) . "," . ($arr->tipo_quantita_id == "" ? "NULL" : $arr->tipo_quantita_id) . ",'" . $note . "'," . $pos . ")";
$mysqlconnetion->insertRecord($query);
$pos = $pos + 1;
}
$retValue["message"] = "Ricetta inserita con successo";
} catch (Exception $e) {
$retValue["message"] = $e->getMessage();
}
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retValue);
});
$app->get('/photos/', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$query = "SELECT * from ( SELECT id as ricetta_id, `titolo`,`autore`, ".
" (select COUNT(*) from immagini where immagini.id_ricette = `ricette`.id) as num_img,".
" (select COUNT(*) from immagini where immagini.id_ricette = `ricette`.id and immagini.published = 1) as num_img_pub".
" FROM `ricette`".
" ) as tmp".
" WHERE tmp.num_img> 0";
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
$app->get('/ricetta/:itemID/photos', function ($itemID) use ($app) {
$callbackFn = $app->request()->get('callback');
$query = "SELECT id as id_photo, type_format, from_profile_id, uploaded_date, profilo.Name as profile_name, published from immagini" .
" INNER JOIN profilo ON profilo.ProfiloID = immagini.from_profile_id".
" WHERE id_ricette = " . $itemID;
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
<?php
$app->get('/categories', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconneti on->connetti();
$retObj = $mysqlconnetion->queryToObject("select ID as category_id, NAME as name from categorie order by name");
$mysqlconnetion->disconnetti();
returnJsonWithDecode($app, $callbackFn, $retObj);
});
$app->get('/typeingredients', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject("select ID as tipo_ingredienti_id, name from tipo_ingredienti order by name");
$mysqlconnetion->disconnetti();
returnJsonWithDecode($app, $callbackFn, $retObj);
});
$app->get('/typeqtys', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject("select ID as tipo_quantita_id, name from tipo_quantita");
$mysqlconnetion->disconnetti();
returnJsonWithDecode($app, $callbackFn, $retObj);
});
$app->get('/ricette/:catID', function ($categoryID) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$query = "select ID as ricetta_id, titolo, autore, valutazione, difficolta from ricette where ID_CATEGORIA = " . $categoryID . " order by titolo, autore";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
$app->get('/ricetta/body/:itemID', function ($itemID) use ($app) {
$callbackFn = $app->request()->get('callback');
// istanza della classe
$mysqlconnetion = new MysqlClass;
$query = "SELECT id_categoria, categorie.name AS categoria_name, ricette.ID AS ricetta_id, titolo, procedimento, autore, link_fonte, link_youtube, valutazione, difficolta FROM ricette INNER JOIN categorie ON categorie.ID = ricette.id_categoria WHERE ricette.ID = " . $itemID;
$retObj = $mysqlconnetion->queryToObject($query);
$query2 = "select ingredienti.id_tipo_ingredienti, tipo_ingredienti.name as nome_ingrediente, quantita, ingredienti.id_tipo_quantita, tipo_quantita.Name as unita, note, posizione from ingredienti " .
"inner join tipo_ingredienti on ingredienti.ID_TIPO_INGREDIENTI = tipo_ingredienti.ID " .
"left outer join tipo_quantita on ingredienti.ID_TIPO_QUANTITA = tipo_quantita.ID " .
"where ingredienti.ID_RICETTE = " . $itemID . " order by ingredienti.posizione";
$retObj2 = $mysqlconnetion->queryToObject($query2);
$retObj[0]["titolo"] = html_entity_decode($retObj[0]["titolo"],ENT_COMPAT | ENT_HTML401,'ISO-8859-1');
$retObj[0]["procedimento"] = html_entity_decode($retObj[0]["procedimento"],ENT_COMPAT | ENT_HTML401,'ISO-8859-1');
$retObj[0]["ingredienti"] = $retObj2;
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
$app->post('/typeingredients', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('bodydata'));
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$query = "insert into tipo_ingredienti(Name) values ('" . $json_data_body->name . "')";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->post('/ricetta/body', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('bodydata'));
$retValue["result"] = true;
$retValue["message"] = "";
$mysqlconnetion = new MysqlClass;
// istanza della classe
try {
$retNewID = 0;
if ($json_data_body->ricettaID != "") {
$query = "update ricette SET ID_CATEGORIA = " . $json_data_body->categoria_id .
", titolo = '" . htmlentities($json_data_body->titolo, null, "UTF-8") .
"', procedimento = '" . str_replace("'", "''", htmlentities($json_data_body->preparazione, null, "UTF-8")) .
"', autore = '" . str_replace("'", "''", $json_data_body->autore) .
"', link_fonte = '" . $json_data_body->linkFonte .
"', Link_youtube = '" . $json_data_body->linkVideo .
"', Difficolta = '" . $json_data_body->difficolta .
"' where ID = " . $json_data_body->ricettaID;
$mysqlconnetion->executeQuery($query);
$queryDelete = "DELETE FROM ingredienti where ID_RICETTE = " . $json_data_body->ricettaID;
$mysqlconnetion->executeQuery($queryDelete);
$retNewID = $json_data_body->ricettaID;
} else {
$query = "insert into ricette(ID_CATEGORIA, titolo, procedimento, autore, link_fonte, Link_youtube,Difficolta) values (" .
$json_data_body->categoria_id . ",'" . htmlentities($json_data_body->titolo, null, "UTF-8") . "','" . str_replace("'", "''", htmlentities($json_data_body->preparazione, null, "UTF-8")) .
"','" . str_replace("'", "''", $json_data_body->autore) . "','" .
$json_data_body->linkFonte . "','" . $json_data_body->linkVideo . "', " . $json_data_body->difficolta . ")";
$retNewID = $mysqlconnetion->insertRecord($query);
}
$pos = 0;
foreach ($json_data_body->ingredienti as $arr) {
$note = "";
if ($arr->note != "") {
$note = str_replace("'", "''", htmlentities($arr->note));
}
$query = "insert into ingredienti(ID_TIPO_INGREDIENTI, ID_RICETTE, Quantita, ID_TIPO_QUANTITA, Note, Posizione) values (" .
$arr->ingrediente_id . "," . $retNewID . "," . ($arr->quantita == "" ? "0" : $arr->quantita) . "," . ($arr->tipo_quantita_id == "" ? "NULL" : $arr->tipo_quantita_id) . ",'" . $note . "'," . $pos . ")";
$mysqlconnetion->insertRecord($query);
$pos = $pos + 1;
}
$retValue["message"] = "Ricetta inserita con successo";
} catch (Exception $e) {
$retValue["message"] = $e->getMessage();
}
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retValue);
});
$app->get('/photos/', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$query = "SELECT * from ( SELECT id as ricetta_id, `titolo`,`autore`, ".
" (select COUNT(*) from immagini where immagini.id_ricette = `ricette`.id) as num_img,".
" (select COUNT(*) from immagini where immagini.id_ricette = `ricette`.id and immagini.published = 1) as num_img_pub".
" FROM `ricette`".
" ) as tmp".
" WHERE tmp.num_img> 0";
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
$app->get('/ricetta/:itemID/photos', function ($itemID) use ($app) {
$callbackFn = $app->request()->get('callback');
$query = "SELECT id as id_photo, type_format, from_profile_id, uploaded_date, profilo.Name as profile_name, published from immagini" .
" INNER JOIN profilo ON profilo.ProfiloID = immagini.from_profile_id".
" WHERE id_ricette = " . $itemID;
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj);
});
+53
View File
@@ -0,0 +1,53 @@
<?php
require_once "./myDropBoxObj.php";
use PHPImageWorkshop\ImageWorkshop;
require_once('./PHPImageWorkshop/ImageWorkshop.php'); // Be sure of the path to the class
date_default_timezone_set("Europe/Rome");
$dirRicetteDropBox = "IlLievitario/Images/Ricette";
$tmpFileName = "C:/Users/Denis/Desktop/Chiaravalle/Jpg/DSC_7731.jpg";
$ext = pathinfo($tmpFileName, PATHINFO_EXTENSION);
$idRicette = 5;
$newID = 125;
$imageFileName = $newID . "_full_ricetta." . $ext;
$thumbFileName = $newID . "_thumb_ricetta." . $ext;
$dropBoxObj = new myDropBox();
$folder = $dirRicetteDropBox . "/" . $idRicette;
/*
echo $dropBoxObj->GetLink($folder . "/" . $imageFileName);
return;
*/
$layer = ImageWorkshop::initFromPath($tmpFileName);
echo $layer->getImage()->image_type;
return;
$layer->resizeByLargestSideInPixel(640, true);
$layer->save(dirname($tmpFileName), $imageFileName);
$imgData = addslashes(file_get_contents($tmpFileName));
$layer->resizeByLargestSideInPixel(300, true);
$layer->save(dirname($tmpFileName), $thumbFileName);
try {
$dropBoxObj->CreateFolder($folder);
} catch (DropboxException $ex) {
}
$dropBoxObj->UploadFile(dirname($tmpFileName) . "/" . $imageFileName, $folder . "/" . $imageFileName);
$dropBoxObj->UploadFile(dirname($tmpFileName) . "/" . $thumbFileName, $folder . "/" . $thumbFileName);
+78
View File
@@ -0,0 +1,78 @@
<?php
require_once("./DropBoxPhp/DropboxClient.php");
class myDropBox {
private $dropbox = null;
// costruttore
public function __construct() {
// you have to create an app at https://www.dropbox.com/developers/apps and enter details below:
$this->dropbox = new DropboxClient(
array(
'app_key' => "ft0zodv89xx804e",
'app_secret' => "ut43sn7m9wufy3s",
'app_full_access' => true
), 'it');
$this->internalLoad();
}
protected function internalLoad() {
// first try to load existing access token
$access_token = $this->load_token("access");
if (!empty($access_token)) {
$this->dropbox->SetAccessToken($access_token);
echo "loaded access token:";
print_r($access_token);
} elseif (!empty($_GET['auth_callback'])) { // are we coming from dropbox's auth page?
// then load our previosly created request token
$request_token = $this->load_token($_GET['oauth_token']);
if (empty($request_token))
die('Request token not found!');
// get & store access token, the request token is not needed anymore
$access_token = $this->dropbox->GetAccessToken($request_token);
$this->store_token($access_token, "access");
$this->delete_token($_GET['oauth_token']);
}
// checks if access token is required
if (!$this->dropbox->IsAuthorized()) {
// redirect user to dropbox auth page
$return_url = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME'] . "?auth_callback=1";
$auth_url = $this->dropbox->BuildAuthorizeUrl($return_url);
$request_token = $this->dropbox->GetRequestToken();
$this->store_token($request_token, $request_token['t']);
die("Authentication required. <a href='$auth_url'>Click here.</a>");
}
}
public function UploadFile($fileToUpload, $dropBoxPath) {
$ret = $this->dropbox->UploadFile($fileToUpload, $dropBoxPath);
return true;
}
public function GetLink($dropBoxPathFile) {
return $this->dropbox->GetLink($dropBoxPathFile, false, false);
}
public function CreateFolder($dropBoxPath) {
$ret = $this->dropbox->CreateFolder($dropBoxPath);
return true;
}
private function store_token($token, $name) {
if (!file_put_contents("tokens/$name.token", serialize($token)))
die('<br />Could not store token! <b>Make sure that the directory `tokens` exists and is writable!</b>');
}
private function load_token($name) {
if (!file_exists("tokens/$name.token"))
return null;
return @unserialize(@file_get_contents("tokens/$name.token"));
}
private function delete_token($name) {
@unlink("tokens/$name.token");
}
}
View File
+9
View File
@@ -0,0 +1,9 @@
browser.id=Chrome.INTEGRATED
copy.src.files=false
copy.src.on.open=false
copy.src.target=
hostname=localhost
port=8888
router=mdbTester.php
run.as=INTERNAL
url=http://localhost:8888/
+7
View File
@@ -0,0 +1,7 @@
<?xml version="1.0" encoding="UTF-8"?>
<project-private xmlns="http://www.netbeans.org/ns/project-private/1">
<editor-bookmarks xmlns="http://www.netbeans.org/ns/editor-bookmarks/2" lastBookmarkId="0"/>
<open-files xmlns="http://www.netbeans.org/ns/projectui-open-files/2">
<group/>
</open-files>
</project-private>
+7
View File
@@ -0,0 +1,7 @@
include.path=${php.global.include.path}
php.version=PHP_53
source.encoding=UTF-8
src.dir=.
tags.asp=false
tags.short=false
web.root=.
+9
View File
@@ -0,0 +1,9 @@
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://www.netbeans.org/ns/project/1">
<type>org.netbeans.modules.php.project</type>
<configuration>
<data xmlns="http://www.netbeans.org/ns/php-project/1">
<name>Service</name>
</data>
</configuration>
</project>
+111 -111
View File
@@ -1,111 +1,111 @@
<?php
// inclusione del file contenente la classe
//include "./MySqlClass.php";
//include "./utility.php";
$app->get('/profile/:keyStore/ricetta/:ricetta_id', function ($keyStore, $ricetta_id) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "select COUNT(*) as Exist FROM blocco_note where ricetta_id = " . $ricetta_id . " AND ProfiloID = '" . $keyStore . "'";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj[0]["Exist"]);
});
$app->post('/profile/ricetta', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('dataPair'));
$mysqlconnetion = new MysqlClass;
$query = "insert into blocco_note(ricetta_id, ProfiloID) values (" . $json_data_body->ricetta_id . ", '" . $json_data_body->keyStore . "')";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->delete('/profile/:keyStore/ricetta/:ricetta_id', function ($keyStore, $ricetta_id) use ($app) {
//$callbackFn = $app->request()->params('callback');
$mysqlconnetion = new MysqlClass;
$query = "delete from blocco_note where ricetta_id = " . $ricetta_id . " AND ProfiloID = '" . $keyStore . "'";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
echo $retNewID;
//returnJson($app, $callbackFn, $retNewID);
});
$app->delete('/profile/:keyStore/ricette', function ($keyStore) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "delete from blocco_note where ProfiloID = '" . $keyStore . "'";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->get('/profile/:keyStore/ricette', function ($keyStore) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "select ID as ricetta_id, titolo, autore, valutazione, difficolta from ricette" .
" INNER JOIN blocco_note ON blocco_note.ricetta_id = ricette.id" .
" where blocco_note.ProfiloID = '" . $keyStore . "' order by titolo, autore";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
foreach ($retObj as $ele) {
$ele["titolo"] = html_entity_decode($ele["titolo"]);
}
returnJson($app, $callbackFn, $retObj);
});
$app->get('/profile/:keyStore', function ($keyStore) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "select ProfiloID, TipoAccesso, RisultatiRicerca, TemaUI, Name, Gender, 0 as NumRicette from profilo" .
" where ProfiloID = '" . $keyStore . "'";
$retObj = $mysqlconnetion->queryToObject($query);
$query = "update profilo set PenultimoAccesso = UltimoAccesso, UltimoAccesso = NOW() where ProfiloID = '" . $keyStore . "'";
$mysqlconnetion->insertRecord($query);
$query = "SELECT COUNT( * ) as NumRicette FROM ricette WHERE data_creazione > ( SELECT PenultimoAccesso FROM profilo " .
"WHERE `ProfiloID` = '" . $keyStore . "' )";
$retObj2 = $mysqlconnetion->queryToObject($query);
$retObj[0]["NumRicette"] = $retObj2[0]["NumRicette"];
returnJson($app, $callbackFn, $retObj);
});
$app->post('/profile', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('dataPair'));
$mysqlconnetion = new MysqlClass;
$query = "insert into profilo(ProfiloID, Name, Email, Gender, TipoAccesso, RisultatiRicerca, TemaUI, UltimoAccesso, CreatoIl) values ('" . $json_data_body->keyStore . "', '" . $json_data_body->name . "', '" . $json_data_body->email . "', '" . $json_data_body->gender . "', '" . $json_data_body->type . "', '" . $json_data_body->risRic . "', '" . $json_data_body->tema . "', NOW(), NOW())";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->put('/profile', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('dataPair'));
$mysqlconnetion = new MysqlClass;
$query = "update profilo set RisultatiRicerca = '" . $json_data_body->risRic . "', TemaUI = '" . $json_data_body->tema . "' where ProfiloID = '" . $json_data_body->keyStore . "'";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
?>
<?php
// inclusione del file contenente la classe
//include "./MySqlClass.php";
//include "./utility.php";
$app->get('/profile/:keyStore/ricetta/:ricetta_id', function ($keyStore, $ricetta_id) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "select COUNT(*) as Exist FROM blocco_note where ricetta_id = " . $ricetta_id . " AND ProfiloID = '" . $keyStore . "'";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retObj[0]["Exist"]);
});
$app->post('/profile/ricetta', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('dataPair'));
$mysqlconnetion = new MysqlClass;
$query = "insert into blocco_note(ricetta_id, ProfiloID) values (" . $json_data_body->ricetta_id . ", '" . $json_data_body->keyStore . "')";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->delete('/profile/:keyStore/ricetta/:ricetta_id', function ($keyStore, $ricetta_id) use ($app) {
//$callbackFn = $app->request()->params('callback');
$mysqlconnetion = new MysqlClass;
$query = "delete from blocco_note where ricetta_id = " . $ricetta_id . " AND ProfiloID = '" . $keyStore . "'";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
echo $retNewID;
//returnJson($app, $callbackFn, $retNewID);
});
$app->delete('/profile/:keyStore/ricette', function ($keyStore) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "delete from blocco_note where ProfiloID = '" . $keyStore . "'";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->get('/profile/:keyStore/ricette', function ($keyStore) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "select ID as ricetta_id, titolo, autore, valutazione, difficolta from ricette" .
" INNER JOIN blocco_note ON blocco_note.ricetta_id = ricette.id" .
" where blocco_note.ProfiloID = '" . $keyStore . "' order by titolo, autore";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
foreach ($retObj as $ele) {
$ele["titolo"] = html_entity_decode($ele["titolo"]);
}
returnJson($app, $callbackFn, $retObj);
});
$app->get('/profile/:keyStore', function ($keyStore) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
$query = "select ProfiloID, TipoAccesso, RisultatiRicerca, TemaUI, Name, Gender, 0 as NumRicette from profilo" .
" where ProfiloID = '" . $keyStore . "'";
$retObj = $mysqlconnetion->queryToObject($query);
$query = "update profilo set PenultimoAccesso = UltimoAccesso, UltimoAccesso = NOW() where ProfiloID = '" . $keyStore . "'";
$mysqlconnetion->insertRecord($query);
$query = "SELECT COUNT( * ) as NumRicette FROM ricette WHERE data_creazione > ( SELECT PenultimoAccesso FROM profilo " .
"WHERE `ProfiloID` = '" . $keyStore . "' )";
$retObj2 = $mysqlconnetion->queryToObject($query);
$retObj[0]["NumRicette"] = $retObj2[0]["NumRicette"];
returnJson($app, $callbackFn, $retObj);
});
$app->post('/profile', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('dataPair'));
$mysqlconnetion = new MysqlClass;
$query = "insert into profilo(ProfiloID, Name, Email, Gender, TipoAccesso, RisultatiRicerca, TemaUI, UltimoAccesso, CreatoIl) values ('" . $json_data_body->keyStore . "', '" . $json_data_body->name . "', '" . $json_data_body->email . "', '" . $json_data_body->gender . "', '" . $json_data_body->type . "', '" . $json_data_body->risRic . "', '" . $json_data_body->tema . "', NOW(), NOW())";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
$app->put('/profile', function () use ($app) {
$callbackFn = $app->request()->get('callback');
$json_data_body = json_decode($app->request()->post('dataPair'));
$mysqlconnetion = new MysqlClass;
$query = "update profilo set RisultatiRicerca = '" . $json_data_body->risRic . "', TemaUI = '" . $json_data_body->tema . "' where ProfiloID = '" . $json_data_body->keyStore . "'";
$retNewID = $mysqlconnetion->insertRecord($query);
$mysqlconnetion->disconnetti();
returnJson($app, $callbackFn, $retNewID);
});
?>
+20 -4
View File
@@ -33,7 +33,7 @@ $app->get('/typeqtys', function () use ($app) {
returnJson($app, $callbackFn, $retObj);
});
$app->get('/categoryitems/:catID', function ($categoryID) use ($app) {
$app->get('/ricette/:catID', function ($categoryID) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
@@ -48,7 +48,7 @@ $app->get('/categoryitems/:catID', function ($categoryID) use ($app) {
returnJson($app, $callbackFn, $retObj);
});
$app->get('/categoryitems/:categoryID/mostvote(/:numItems)', function ($categoryID, $numItems = 10) use ($app) {
$app->get('/ricette/:categoryID/mostvote(/:numItems)', function ($categoryID, $numItems = 10) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
@@ -63,7 +63,7 @@ $app->get('/categoryitems/:categoryID/mostvote(/:numItems)', function ($category
returnJson($app, $callbackFn, $retObj);
});
$app->get('/categoryitems/:categoryID/lastinserted(/:numItems)', function ($categoryID, $numItems = 10) use ($app) {
$app->get('/ricette/:categoryID/lastinserted(/:numItems)', function ($categoryID, $numItems = 10) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
@@ -78,7 +78,23 @@ $app->get('/categoryitems/:categoryID/lastinserted(/:numItems)', function ($cate
returnJson($app, $callbackFn, $retObj);
});
$app->get('/categoryitems/search/:numItems(/:categoryId(/:difficolta(/:titolo)))',
$app->get('/ricette/lastinserted/:profileID', function ($profileID) use ($app) {
$callbackFn = $app->request()->get('callback');
$mysqlconnetion = new MysqlClass;
//$mysqlconnetion->connetti();
$query = "select ID as ricetta_id, titolo, autore FROM ricette WHERE data_creazione > ( SELECT PenultimoAccesso FROM profilo " .
"WHERE `ProfiloID` = '" . $profileID . "' ) order by Data_creazione desc, titolo, autore";
$retObj = $mysqlconnetion->queryToObject($query);
$mysqlconnetion->disconnetti();
foreach ($retObj as $ele) {
$ele["titolo"] = html_entity_decode($ele["titolo"], ENT_COMPAT | ENT_HTML401, 'ISO-8859-1');
}
returnJson($app, $callbackFn, $retObj);
});
$app->get('/ricette/search/:numItems(/:categoryId(/:difficolta(/:titolo)))',
function ($numItems = 10, $categoryId = 0, $difficolta = 0, $titolo = "") use ($app) {
$callbackFn = $app->request()->get('callback');
//$filterItem = json_decode($app->request()->post('post'));
+15 -15
View File
@@ -1,16 +1,16 @@
<?php
include_once "./include.php";
$app->group('/api', function () use ($app) {
include "./ricette.php";
include "./profile.php";
include "./image.php";
});
$app->group('/backend', function () use ($app) {
include "./management.php";
});
//include "./image.php";
<?php
include_once "./include.php";
$app->group('/api', function () use ($app, $dirRicetteDropBox) {
include "./ricette.php";
include "./profile.php";
include "./image.php";
});
$app->group('/backend', function () use ($app) {
include "./management.php";
});
//include "./image.php";
$app->run();
+87 -78
View File
@@ -1,78 +1,87 @@
<?php
function utf8json($inArray) {
if (is_array($inArray)) {
static $depth = 0;
/* our return object */
$newArray = array();
/* safety recursion limit */
$depth ++;
if ($depth >= '300000') {
return false;
}
/* step through inArray */
foreach ($inArray as $key => $val) {
if (is_array($val)) {
/* recurse on array elements */
$newArray[$key] = utf8json($val);
} else {
/* encode string values */
$newArray[$key] = utf8_encode($val);
}
}
/* return utf8 encoded array */
return $newArray;
}
/* return utf8 encoded array */
return $inArray;
}
function returnJsonWithDecode($app, $callbackFn, $retObj) {
if ($callbackFn) {
$app->contentType('application/javascript; Charset=UTF-8');
echo $callbackFn . "(" . html_entity_decode(json_encode(utf8json($retObj)), ENT_COMPAT | ENT_HTML401, 'ISO-8859-1') . ")";
} else {
$app->contentType('application/x-json; Charset=UTF-8');
echo html_entity_decode(json_encode(utf8json($retObj)), ENT_COMPAT | ENT_HTML401, 'ISO-8859-1');
}
}
function returnJson($app, $callbackFn, $retObj) {
if ($callbackFn) {
$app->contentType('application/javascript; Charset=UTF-8');
echo $callbackFn . "(" . (json_encode(utf8json($retObj))) . ")";
} else {
$app->contentType('application/x-json; Charset=UTF-8');
echo (json_encode(utf8json($retObj)));
}
}
function makeThumbnail($im) {
$final_width_of_image = 300;
$ox = imagesx($im);
$oy = imagesy($im);
$nx = $final_width_of_image;
$ny = floor($oy * ($final_width_of_image / $ox));
$nm = imagecreatetruecolor($nx, $ny);
imagecopyresized($nm, $im, 0, 0, 0, 0, $nx, $ny, $ox, $oy);
return $nm;
}
function getContentFromResources($res) {
ob_start(); //Start output buffer.
imagejpeg($res); //This will normally output the image, but because of ob_start(), it won't.
$contents = ob_get_contents(); //Instead, output above is saved to $contents
ob_end_clean(); //End the output buffer.
return $contents;
}
?>
<?php
if ( ! function_exists( 'exif_imagetype' ) ) {
function exif_imagetype ( $filename ) {
if ( ( list($width, $height, $type, $attr) = getimagesize( $filename ) ) !== false ) {
return $type;
}
return false;
}
}
function utf8json($inArray) {
if (is_array($inArray)) {
static $depth = 0;
/* our return object */
$newArray = array();
/* safety recursion limit */
$depth ++;
if ($depth >= '300000') {
return false;
}
/* step through inArray */
foreach ($inArray as $key => $val) {
if (is_array($val)) {
/* recurse on array elements */
$newArray[$key] = utf8json($val);
} else {
/* encode string values */
$newArray[$key] = utf8_encode($val);
}
}
/* return utf8 encoded array */
return $newArray;
}
/* return utf8 encoded array */
return $inArray;
}
function returnJsonWithDecode($app, $callbackFn, $retObj) {
if ($callbackFn) {
$app->contentType('application/javascript; Charset=UTF-8');
echo $callbackFn . "(" . html_entity_decode(json_encode(utf8json($retObj)), ENT_COMPAT | ENT_HTML401, 'ISO-8859-1') . ")";
} else {
$app->contentType('application/x-json; Charset=UTF-8');
echo html_entity_decode(json_encode(utf8json($retObj)), ENT_COMPAT | ENT_HTML401, 'ISO-8859-1');
}
}
function returnJson($app, $callbackFn, $retObj) {
if ($callbackFn) {
$app->contentType('application/javascript; Charset=UTF-8');
echo $callbackFn . "(" . (json_encode(utf8json($retObj))) . ")";
} else {
$app->contentType('application/x-json; Charset=UTF-8');
echo (json_encode(utf8json($retObj)));
}
}
function makeThumbnail($im) {
$final_width_of_image = 300;
$ox = imagesx($im);
$oy = imagesy($im);
$nx = $final_width_of_image;
$ny = floor($oy * ($final_width_of_image / $ox));
$nm = imagecreatetruecolor($nx, $ny);
imagecopyresized($nm, $im, 0, 0, 0, 0, $nx, $ny, $ox, $oy);
return $nm;
}
function getContentFromResources($res) {
ob_start(); //Start output buffer.
imagejpeg($res); //This will normally output the image, but because of ob_start(), it won't.
$contents = ob_get_contents(); //Instead, output above is saved to $contents
ob_end_clean(); //End the output buffer.
return $contents;
}
?>