public function dropbox() { //return Input::file('uploadfile'); //return $uploadfile = Input::file('uploadfile'); //use \Dropbox as dbx; $appInfo = \Dropbox\AppInfo::loadFromJsonFile("app_info.json"); $webAuth = new \Dropbox\WebAuthNoRedirect($appInfo, "PHP-Example/1.0"); $authorizeUrl = $webAuth->start(); $accessToken = "LUu8h-uvauAAAAAAAAAAHbDw-bulVL7u8BoRAJtedc0-eCDY-Xj4Qxf1iGucUN7j"; $dbxClient = new \Dropbox\Client($accessToken, "PHP-Example/1.0"); $accountInfo = $dbxClient->getAccountInfo(); // $dbxClient->getAccessToken(); //return $dbxClient->_getMetadata("/participant/Fl0dsItC_Airtel.png"); $host = $dbxClient->getHost(); return $this->fetchUrl("/participant/Fl0dsItC_Airtel.png"); //$appendFilePath = $dbxClient->appendFilePath(); //print_r($appendFilePath); /*echo "1. Go to: " . $authorizeUrl . "\n"; echo "2. Click \"Allow\" (you might have to log in first).\n"; echo "3. Copy the authorization code.\n"; $authCode = \trim(\readline("Enter the authorization code here: ")); list($accessToken, $dropboxUserId) = $webAuth->finish($authCode); print "Access Token: " . $accessToken . "\n"; */ /*$f = fopen(url()."/public/assets/upload/contest_theme_photo/Fl0dsItC_Airtel.png", "rb"); $result = $dbxClient->uploadFile("/participant/Fl0dsItC_Airtel.png", \Dropbox\WriteMode::add(), $f); fclose($f);*/ $f = fopen("Fl0dsItC_Airtel.png", "w+b"); $fileMetadata = $dbxClient->getFile("/participant/Fl0dsItC_Airtel.png", $f); //return $dbxClient->getMetadata("/participant/Fl0dsItC_Airtel.png"); fclose($f); //return View::make('dropbox/dropbox'); }
public function upload($file) { $authStuff = json_decode(file_get_contents($this->getAuthFilePath())); $dbxClient = new \Dropbox\Client($authStuff->token, "PHP-Example/1.0"); $f = fopen($file, "rb"); $dbxClient->uploadFile('/' . basename($file), \Dropbox\WriteMode::force(), $f); }
public function actionGetdropboxlink($path) { $path = base64_decode($path); $pathError = Dropbox\Path::findError($path); if ($pathError !== null) { throw new CHttpException(500, "Invalid <dropbox-path>: {$pathError}\n"); } $client = new Dropbox\Client(Yii::app()->params['dropboxToken'], 'dropbox-client'); $link = $client->createTemporaryDirectLink($path); echo CJSON::encode($link); Yii::app()->end(); }
public function isAuthorized() { $token = $this->getAuthorizeToken(); if (!$token) return false; $this->init(); $dbxClient = new Dropbox\Client($this->getAuthorizeToken(), Dropbox::CLIENT); try { $dbxClient->getAccountInfo(); return true; } catch (Exception $ex) { return false; } }
/** * @param string $localPath * @param string $filename * * @return string URL */ public function upload($localPath, $filename) { $size = @getimagesize($localPath); if ($size) { $extension = image_type_to_extension($size[2]); } else { $extension = strrchr($filename, '.'); } $metadata = $this->client->uploadFile($this->prefix . hash_file('crc32b', $localPath) . $extension, Dropbox\WriteMode::add(), fopen($localPath, 'rb'), filesize($localPath)); if (is_array($metadata) && isset($metadata['path'])) { //return $this->client->createShareableLink($metadata['path']); $data = $this->client->createTemporaryDirectLink($metadata['path']); if (is_array($data)) { return $data[0]; } } return null; }
<?php $userId = $_POST["idUser"]; $connect = mysql_connect("localhost", "root", "123"); mysql_select_db("POKS"); $query_relult_email = mysql_query("select * from User where userId={$userId}") or die("Не удалось провести запрос к базе данных -- deleteUser.php"); ini_set('display_errors', 1); # Include the Dropbox SDK libraries require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php'; //MODX_BASE_PATH. //use \Dropbox as dbx; $accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv"; // Здесь ваш Access token $dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER"); $data = mysql_fetch_array($query_relult_email); print "In: " . $data[0]; $dbxClient->delete("/" . $data[1]); $query_relult = mysql_query("delete from User where userId={$userId}") or die("Не удалось провести запрос к базе данных -- deleteUser.php"); mysql_close($connect); unset($_SESSION[$data[1]]); header("Location: AdminPlace.php?name=" . $_POST["idName"]); exit;
function loadTable() { $connect = mysql_connect("localhost", "root", "123"); mysql_select_db("POKS"); $mail = $_SESSION["user"]; $query_relult = mysql_query("select userId from User where email = '{$mail}'") or die("Не удалось провести запрос к базе данных function isExist"); $id_user = mysql_fetch_array($query_relult); $id_user = $id_user[0]; $query_relult = mysql_query("select * from userStorrage where idUser = {$id_user}") or die("Не удалось провести запрос к базе данных -- loadTable()"); # Include the Dropbox SDK libraries require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php'; //MODX_BASE_PATH. //use \Dropbox as dbx; $accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv"; // Здесь ваш Access token $dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER"); while ($mail_array = mysql_fetch_array($query_relult)) { $img_link = $dbxClient->createTemporaryDirectLink("/" . $mail . "/" . $mail_array[5]); $shared_link = $dbxClient->createShareableLink("/" . $mail . "/" . $mail_array[5]); echo "<tr>"; echo "\n\t\t\t\t<td>\n\t\t\t\t\t<img class = 'well modal-image' src = '{$img_link['0']}' width = '100' height = '100'/>\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t\t<td>{$mail_array['2']}</td>\n\t\t\t\t<td>{$mail_array['3']}</td>\n\t\t\t\t<td>{$mail_array['4']}</td>\n\t\t\t\t<td>{$mail_array['5']}</td>"; echo "\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<a class='btn btn-success btn-block' href = 'removeImage.php?image_id={$mail_array['0']}&image_name={$mail_array['5']}'>\n\t\t\t\t\t\t\tRemove\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</td>\n\t\t\t\t"; echo "\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<p><a href= {$shared_link}> Скачать файл</a> </p>\n\t\t\t\t\t</td>\n\t\t\t\t"; echo "</tr>"; } mysql_close($connect); }
<?php require "init.php"; list($accessToken) = $web_auth->finish($_GET); var_dump($accessToken); $client = new \Dropbox\Client($accessToken, $app_name, 'UTF-8'); try { $user_info = $client->getAccountInfo(); var_dump($client->getAccountInfo()); } catch (Dropbox\Exception_InvalidAcessToken $e) { die("not Authenticated"); } out($user_info);
<?php $userId = $_POST["idUser"]; $connect = mysql_connect("localhost", "root", "123"); mysql_select_db("POKS"); $query_relult_email = mysql_query("select * from User where userId={$userId}") or die("Не удалось провести запрос к базе данных -- select clearUser.php"); ini_set('display_errors', 1); # Include the Dropbox SDK libraries require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php'; //MODX_BASE_PATH. //use \Dropbox as dbx; $accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv"; // Здесь ваш Access token $dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER"); $data = mysql_fetch_array($query_relult_email); print "In: " . $data[0]; $dbxClient->delete("/" . $data[1]); $dbxClient->createFolder("/" . $data[1]); $query_relult = mysql_query("delete from userStorrage where idUser={$userId}") or die("Не удалось провести запрос к базе данных -- deleteclearUser.php"); mysql_close($connect); header("Location: AdminPlace.php?name=" . $_POST["idName"]); exit;
<?php //ubaciti $authUrl u AT funkciju u functions.php if ($user->dropbox_token) { $client = new Dropbox\Client($user->dropbox_token, $appName, 'UTF-8'); //request to API try { $client->getAccountInfo(); } catch (Dropbox\Exception_InvalidAccessToken $e) { $authUrl = $webAuth->start(); header('Location: ' . $authUrl); exit; } } else { $authUrl = $webAuth->start(); header('Location: ' . $authUrl); exit; } /* if($user->dropbox_token){ //get client }else{ $authUrl = $webAuth->start(); header('Location: '. $authUrl); exit(); } */
public function revisions($project_name, $event_name, $photo) { $this->is_client(); $this->load->model('project_model', 'project'); $this->load->model('event_type_model', 'event_type'); $this->load->model('event_model', 'event'); $this->load->model('layout_comment_model', 'layout_comment'); $project_name = rawurldecode($project_name); $event_name = rawurldecode($event_name); $photo_path = "/" . $_SESSION['user']['username'] . "/" . $project_name . "/" . $event_name . "/layouts/" . rawurldecode($photo); $photo_name = pathinfo($photo_path, PATHINFO_FILENAME); $photo_ext = pathinfo($photo_path, PATHINFO_EXTENSION); $data['project'] = $this->project->get_by("client_id = " . $_SESSION['user']['id'] . " AND name = \"" . $project_name . "\""); $event_type = $data['project'] !== null ? $this->event_type->get_by("project_type_id = " . $data['project']->project_type_id . " AND name = \"" . trim(str_replace('Photoshoot', '', preg_replace('/\\d/', '', rawurldecode($event_name)))) . "\"") : null; if ($data['project'] !== null && $event_type !== null) { $data['event'] = $this->event->order_by('date', 'ASC')->get_many_by("project_id = " . $data['project']->id . " AND event_type_id = '" . $event_type->id . "'"); if ($data['event']) { $dbxClient = new \Dropbox\Client(getenv('DROPBOX_ACCESS_TOKEN'), "chaar-bhai/1.0"); if ($dbxClient->getMetadata($photo_path) !== null) { if (count($data['event']) > 1) { $exploded_event_name = explode(' ', trim(str_replace('Photoshoot', '', rawurldecode($event_name)))); $event_num = end($exploded_event_name); $data['event'] = $data['event'][$event_num - 1]; } else { $data['event'] = $data['event'][0]; } if (strpos($event_name, "Photoshoot") !== FALSE) { $data['event']->id = $data['event']->id . '.5'; if ($data['event']->photoshoot_layouts_approved_date !== '0000-00-00 00:00:00' || $data['event']->photoshoot_layouts_rework_date !== '0000-00-00 00:00:00' || $data['event']->photoshoot_status === 'Layouts Rework') { $data['view_name'] = 'client_layouts/revisions_locked'; } else { $data['view_name'] = 'client_layouts/revisions'; } } else { if ($data['event']->event_layouts_approved_date !== '0000-00-00 00:00:00' || $data['event']->event_layouts_rework_date !== '0000-00-00 00:00:00' || $data['event']->event_status === 'Layouts Rework') { $data['view_name'] = 'client_layouts/revisions_locked'; } else { $data['view_name'] = 'client_layouts/revisions'; } } $revisions = $dbxClient->getRevisions($photo_path); $revisions = array_reverse($revisions); $filtered_revisions = array(); $rev = 0; foreach ($revisions as $revision) { if ($revision['bytes'] > 0) { $different_size = TRUE; foreach ($filtered_revisions as $filtered_revision) { if ($revision['bytes'] === $filtered_revision['bytes']) { $different_size = FALSE; break; } } if ($different_size) { $layout_comments = $this->layout_comment->get_many_by('event_id = "' . $data['event']->id . '" AND title = "' . $photo_name . '" AND revision = "' . $rev . '"'); $filtered_revisions[] = array('rank' => $rev, 'src' => 'assets/images/revisions/' . $revision['rev'] . '.' . $photo_ext, 'revision_name' => $revision['rev'], 'bytes' => $revision['bytes'], 'data' => $layout_comments); $rev++; } } } foreach ($filtered_revisions as $filtered_revision) { if (!file_exists($filtered_revision['src'])) { $fd = fopen($filtered_revision['src'], 'wb'); $dbxClient->getFile($photo_path, $fd, $filtered_revision['revision_name']); } } $data['revisions'] = $filtered_revisions; $data['taggd'] = ''; $_SESSION['user']['sidebar_collapsed'] = '1'; $this->load->view('layouts/template', $data); } else { $this->show_404(); } } else { $this->show_404(); } } else { $this->show_404(); } }
<?php Yii::app()->clientScript->registerCssFile(Yii::app()->cms->blocs['clouddocument']->assetsUrl . '/css/clouddocument.css'); $client = new Dropbox\Client(Yii::app()->params['dropboxToken'], 'dropbox-client'); /* $pathError = Dropbox\Path::findError($bloc->path); if ($pathError !== null) { throw new CHttpException(500, "Invalid <dropbox-path>: $pathError\n"); } */ // Getting metadata from db if not changed, otherwise getting from request and updating db. if ($bloc->previous_folder_hash == '') { $metadata = $client->getMetadataWithChildren($bloc->path); if ($metadata === null) { //throw new CHttpException(500, "No file or folder at that path.\n"); } $bloc->previous_folder_hash = $metadata['hash']; $bloc->previous_folder = serialize($metadata); $bloc->save(false); } else { $metadata = $client->getMetadataWithChildrenIfChanged($bloc->path, $bloc->previous_folder_hash); if ($metadata[0] == true) { if ($metadata[1] === null) { //throw new CHttpException(500, "No file or folder at that path.\n"); } $metadata = $metadata[1]; $bloc->previous_folder_hash = $metadata['hash']; $bloc->previous_folder = serialize($metadata); $bloc->save(false); } else { $metadata = unserialize($bloc->previous_folder);
public function revisions($project_name, $event_name, $photo) { $this->is_admin_or_vendor(); $this->load->model('project_model', 'project'); $this->load->model('event_type_model', 'event_type'); $this->load->model('event_model', 'event'); $project_name = rawurldecode($project_name); $event_name = rawurldecode($event_name); $data['project'] = $this->project->get_by('name = "' . rawurldecode($project_name) . '"'); $event_type = $data['project'] !== null ? $this->event_type->get_by('project_type_id = ' . $data['project']->project_type_id . ' AND name = "' . trim(str_replace('Photoshoot', '', preg_replace('/\\d/', '', rawurldecode($event_name)))) . '"') : null; if ($data['project'] !== null && $event_type !== null) { $data['event'] = $this->event->order_by('date', 'ASC')->get_many_by("project_id = " . $data['project']->id . " AND event_type_id = '" . $event_type->id . "'"); if ($data['event']) { if (count($data['event']) > 1) { $exploded_event_name = explode(' ', trim(str_replace('Photoshoot', '', rawurldecode($event_name)))); $event_num = end($exploded_event_name); $data['event'] = $data['event'][$event_num - 1]; } else { $data['event'] = $data['event'][0]; } $belongs_to_vendor = FALSE; if (strpos($event_name, "Photoshoot") !== FALSE) { if ($data['event']->photoshoot_vendor_id === $_SESSION['user']['id'] && $data['event']->photoshoot_status === 'Layouts Rework') { $belongs_to_vendor = TRUE; } $data['event']->id = $data['event']->id . '.5'; } else { if ($data['event']->event_vendor_id === $_SESSION['user']['id'] && $data['event']->event_status === 'Layouts Rework') { $belongs_to_vendor = TRUE; } } if ($belongs_to_vendor || $_SESSION['user']['role'] === 'Admin') { $this->load->model('layout_comment_model', 'layout_comment'); $this->load->model('user_model', 'user'); $data['client_username'] = $this->user->get($data['project']->client_id)->username; $photo_path = "/" . $data['client_username'] . "/" . $project_name . "/" . $event_name . "/layouts/" . rawurldecode($photo); $photo_name = pathinfo($photo_path, PATHINFO_FILENAME); $photo_ext = pathinfo($photo_path, PATHINFO_EXTENSION); $layout_comments = $this->layout_comment->get_many_by('event_id = ' . $data['event']->id . ' AND title = "' . $photo_name . '" AND reworked = 0'); if (!empty($layout_comments) || $_SESSION['user']['role'] === 'Admin') { $dbxClient = new \Dropbox\Client(getenv('DROPBOX_ACCESS_TOKEN'), "chaar-bhai/1.0"); if ($dbxClient->getMetadata($photo_path) !== null) { $revisions = $dbxClient->getRevisions($photo_path); $revisions = array_reverse($revisions); $filtered_revisions = array(); $rev = 0; foreach ($revisions as $revision) { if ($revision['bytes'] > 0) { $different_size = TRUE; foreach ($filtered_revisions as $filtered_revision) { if ($revision['bytes'] === $filtered_revision['bytes']) { $different_size = FALSE; break; } } if ($different_size) { $layout_comments = $this->layout_comment->get_many_by('event_id = "' . $data['event']->id . '" AND title = "' . $photo_name . '" AND revision = "' . $rev . '"'); $filtered_revisions[] = array('rank' => $rev, 'src' => 'assets/images/revisions/' . $revision['rev'] . '.' . $photo_ext, 'revision_name' => $revision['rev'], 'bytes' => $revision['bytes'], 'data' => $layout_comments); $rev++; } } } foreach ($filtered_revisions as $filtered_revision) { if (!file_exists($filtered_revision['src'])) { $fd = fopen($filtered_revision['src'], 'wb'); $dbxClient->getFile($photo_path, $fd, $filtered_revision['revision_name']); } } if ($_SESSION['user']['role'] === 'Admin') { $layout_comments = $this->layout_comment->get_commented_admin($data['event']->id); } else { $layout_comments = $this->layout_comment->get_commented($data['event']->id); } $index = 0; foreach ($layout_comments as $layout_comment) { if ($layout_comment->title === $photo_name) { break; } $index++; } $num_commented = count($layout_comments); if ($num_commented > 1) { if ($index === 0) { $data['previous'] = 'disabled'; $data['next'] = $layout_comments[1]->title . '.' . $photo_ext; } elseif ($index === $num_commented - 1) { $data['previous'] = $layout_comments[$index - 1]->title . '.' . $photo_ext; $data['next'] = 'disabled'; } else { $data['previous'] = $layout_comments[$index - 1]->title . '.' . $photo_ext; $data['next'] = $layout_comments[$index + 1]->title . '.' . $photo_ext; } } else { $data['previous'] = 'disabled'; $data['next'] = 'disabled'; } $data['taggd'] = ''; $data['parsley'] = ''; $data['revisions'] = $filtered_revisions; $_SESSION['user']['sidebar_collapsed'] = '1'; $data['view_name'] = 'albums/revisions'; $this->load->view('layouts/template', $data); } else { $this->show_404(); } } else { $this->show_404(); } } else { $this->show_404(); } } else { $this->show_404(); } } else { $this->show_404(); } }
function load_image($image) { ini_set('display_errors', 1); $size = $_FILES[image_to_load][size][0]; $type = pathinfo($image, PATHINFO_EXTENSION); $date = date("Y-m-d"); $mail = $_SESSION["user"]; $connect = mysql_connect("localhost", "root", "123"); mysql_select_db("POKS"); $query_relult = mysql_query("select userId from User where email = '{$mail}'") or die("Не удалось провести запрос к базе данных function load_image"); $id_user = mysql_fetch_array($query_relult); $id_user = $id_user[0]; // echo "<br>"; // print($image); // echo "<br>"; // print($type); // echo "<br>"; // print($size); // echo "<br>"; // print($date); // echo "<br>"; // print($mail); // echo "<br>"; // print("ID: ".$id_user); // echo "<br>"; mysql_query("insert into `userStorrage`(`idUser`,`dateOfCreation`,`size`,`format`,`namePicture`) values('{$id_user}','{$date}','{$size}','{$type}','{$image}')") or die("Не удалось провести запрос к базе данных function load_image insert"); mysql_close($connect); // print '<pre>'; # Include the Dropbox SDK libraries require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php'; //MODX_BASE_PATH. //use \Dropbox as dbx; $accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv"; // Здесь ваш Access token $Folder_name = "ITMO_POKS_FOLDER"; $dbxClient = new \Dropbox\Client($accessToken, $Folder_name); print_r($_FILES); $dir = "Loads/"; if (is_uploaded_file($_FILES["image_to_load"]["tmp_name"][0])) { $res = move_uploaded_file($_FILES["image_to_load"]["tmp_name"][0], $dir . $_FILES["image_to_load"]["name"][0]); if ($res) { echo "Succesfully uploaded in " . $dir . $_FILES["image_to_load"]["name"][0]; } else { echo "ERROR"; } } /* $tmp_name = $_FILES["image_to_load"]["tmp_name"][0]; $name = $_FILES["image_to_load"]["name"][0]; move_uploaded_file($tmp_name, "./Loads/".$name);*/ chmod($dir . $_FILES["image_to_load"]["name"][0], 0777); $fd = fopen($dir . $_FILES["image_to_load"]["name"][0], "r"); $md1 = $dbxClient->uploadFile("/" . $_SESSION["user"] . "/" . $_FILES[image_to_load][name][0], \Dropbox\WriteMode::add(), $fd); fclose($fd); print "db answer: "; print_r($md1); return TRUE; }
} echo '<form method="post" action="' . pb_backupbuddy::ajax_url('destination_picker') . '&add=dropbox2&callback_data=' . pb_backupbuddy::_GET('callback_data') . '">'; echo '<br><b>Adding a Dropbox destination</b><ol>'; echo '<li> <a href="' . $authorizeUrl . '" class="button-primary pb_dropbox_authorize" target="_new">' . __('Connect to Dropbox.com & Authorize (opens new window)', 'it-l10n-backupbuddy') . '</a></li>'; echo '<li>Click <b>Allow</b> in the new window (you may need to login to Dropbox.com first).</li>'; echo '<li>Enter the provided <b>Authorization Code</b>: <input type="text" name="dropbox_authorization_code" size="45"></li>'; echo '<li><input type="submit" class="button-primary" value="' . __("Yes, I've Authorized BackupBuddy with Dropbox & Entered the Code above", 'it-l10n-backupbuddy') . '"></li>'; echo '</ol>'; echo '</form>'; } // end authorication code submitted. } elseif ('edit' == $mode) { // EDIT mode. $accessToken = $destination_settings['access_token']; try { $dropboxClient = new \Dropbox\Client($accessToken, 'BackupBuddy v' . pb_backupbuddy::settings('version')); } catch (\Exception $e) { pb_backupbuddy::alert('Dropbox Error #143838: ' . $e->getMessage() . '<br><br>' . pb_backupbuddy::$ui->button(pb_backupbuddy::page_url(), '← go back & retry'), true); return false; } try { $accountInfo = $dropboxClient->getAccountInfo(); } catch (\Exception $e) { pb_backupbuddy::alert('Dropbox Error #132852: ' . $e->getMessage() . '<br><br>' . pb_backupbuddy::$ui->button(pb_backupbuddy::page_url(), '← go back & retry'), true); return false; } $show_config_form = true; // Enable showing configuration form below. } elseif ('save' == $mode) { $show_config_form = true; } else {
} if (isExist($mail) == FALSE) { $connect = mysql_connect("localhost", "root", "123"); mysql_select_db("POKS"); $currentDate = date("Y-m-d"); echo mysql_query("insert into `User`(`email`,`password`,`dateRegistration`) values('{$mail}','{$password}','{$currentDate}')") or die("Не удалось провести запрос к базе данных"); echo "<br>"; ini_set('display_errors', 1); print '<pre>'; # Include the Dropbox SDK libraries require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php'; //MODX_BASE_PATH. //use \Dropbox as dbx; $accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv"; // Здесь ваш Access token $dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER"); $dbxClient->createFolder("/" . $mail); // mysql_close($connect); header("Location: index.php"); exit; } else { $answer = "Email already exist"; header("Location: registration.php?CheckResult=Email already exist"); exit; } echo "answer: " . $answer . "<br>"; //header("Location: registration.php?CheckResult=Ok"); ?>
/** * Get account information * * @since 1.1 * @return null|array */ public function getUserinfo() { if ($this->isAuthenticated() === false) { return null; } $client = new Dropbox\Client($this->getToken(), $this->applicationName); return $client->getAccountInfo(); }
/** * Send the request to the Dropbox service * * @param $url string * @param $post boolean * @param $postData array * @throws Exception * @return mixed */ protected static function request($url, $post = false, $postData = array()) { try { $token = Settings::findbyParam('dropbox_token'); $dropbox = new Dropbox\Client($token, 'shineisp', null, self::$appInfo->getHost()); $fh = fopen($postData['file'], "rb"); $result = $dropbox->uploadFile($postData['dest'] . basename($postData['file']), Dropbox\WriteMode::force(), $fh); fclose($fh); return $result; } catch (Exception $e) { Shineisp_Commons_Utilities::log(__METHOD__ . " " . $e->getMessage(), "plugin_dropbox.log"); } }
<?php session_start(); $mail = $_SESSION["user"]; $id_image = $_GET["image_id"]; $name_image = $_GET["image_name"]; echo "<br>"; print "mail:" . $mail; echo "<br>"; print "id:" . $id_image; echo "<br>"; print "name:" . $name_image; $connect = mysql_connect("localhost", "root", "123"); mysql_select_db("POKS"); $query_relult_email = mysql_query("select * from User where email='{$mail}'") or die("Не удалось провести запрос к базе данных -- select removeImage.php"); $user = mysql_fetch_array($query_relult_email); $id_user = $user[0]; $query_relult = mysql_query("delete from userStorrage where idPicture='{$id_image}'") or die("Не удалось провести запрос к базе данных -- removeImage.php"); ini_set('display_errors', 1); require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php'; $accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv"; // Здесь ваш Access token $dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER"); $dbxClient->delete("/" . $mail . "/" . $name_image); mysql_close($connect); header("Location: UserPlace.php"); exit;
public function send_album_processing_notification() { $this->is_admin_or_team_lead(); if (isset($_POST['event_id']) && isset($_POST['target'])) { $this->load->model('event_model', 'event'); $this->load->model('user_model', 'user'); $event = $this->event->get_with_client_details($this->input->post('event_id'))[0]; if ($_POST['target'] === 'Client') { $text = str_replace('client_name', $event->client_name, $_POST['content']); $email = array('recipients' => array(array('email' => $event->client_email, 'name' => $event->client_name)), 'subject' => $_POST['subject'], 'text' => array($text)); $this->send_email($email); $this->send_sms($event->client_phone, $text); } else { if ($_POST['target'] === 'Vendor') { $vendor = $this->user->get($this->input->post('vendor_id')); $text = str_replace('vendor_name', $vendor->name, $_POST['content']); $email = array('recipients' => array(array('email' => $vendor->email, 'name' => $vendor->name)), 'subject' => $_POST['subject'], 'text' => array($text)); $this->send_email($email); $this->send_sms($vendor->phone_1, $text); } else { if ($_POST['target'] === 'Vendors') { $old_vendor = $this->user->get($this->input->post('old_vendor_id')); $new_vendor = $this->user->get($this->input->post('new_vendor_id')); // 1 instead of 2 because event already assigned to vendor. $days = 1 + count($this->event->get_vendor_assignments('Event', $new_vendor->id, 'Photos Edited')) + count($this->event->get_vendor_assignments('Photoshoot', $new_vendor->id, 'Photos Edited')); $old_vendor_text = str_replace('vendor_name', $old_vendor->name, $_POST['content_old_vendor']); $new_vendor_text = str_replace('vendor_name', $new_vendor->name, $_POST['content_new_vendor']); strpos($new_vendor_text, 'Photoshoot') === FALSE ? $this->event->update($event->id, array('event_layouts_deadline_date' => date('Y-m-d', strtotime('+ ' . $days . ' days')))) : $this->event->update($event->id, array('photoshoot_layouts_deadline_date' => date('Y-m-d', strtotime('+ ' . $days . ' days')))); $new_vendor_text = str_replace('layouts_deadline', date('d/m/Y', strtotime('+ ' . $days . ' days')), $new_vendor_text); $email_old_vendor = array('recipients' => array(array('email' => $old_vendor->email, 'name' => $old_vendor->name)), 'subject' => $_POST['subject_old_vendor'], 'text' => array($old_vendor_text)); $email_new_vendor = array('recipients' => array(array('email' => $new_vendor->email, 'name' => $new_vendor->name)), 'subject' => $_POST['subject_new_vendor'], 'text' => array($new_vendor_text)); $this->send_email($email_old_vendor); $this->send_email($email_new_vendor); $this->send_sms($old_vendor->phone_1, $old_vendor_text); $this->send_sms($new_vendor->phone_1, $new_vendor_text); } else { if ($_POST['target'] === 'Vendor and Client') { $vendor = $this->user->get($this->input->post('vendor_id')); // 1 instead of 2 because event already assigned to vendor. $days = 1 + count($this->event->get_vendor_assignments('Event', $vendor->id, 'Photos Edited')) + count($this->event->get_vendor_assignments('Photoshoot', $vendor->id, 'Photos Edited')); $vendor_text = str_replace('vendor_name', $vendor->name, $_POST['content_vendor']); strpos($vendor_text, 'Photoshoot') === FALSE ? $this->event->update($event->id, array('event_layouts_deadline_date' => date('Y-m-d', strtotime('+ ' . $days . ' days')))) : $this->event->update($event->id, array('photoshoot_layouts_deadline_date' => date('Y-m-d', strtotime('+ ' . $days . ' days')))); $vendor_text = str_replace('layouts_deadline', date('d/m/Y', strtotime('+ ' . $days . ' days')), $vendor_text); $client_text = str_replace('client_name', $event->client_name, $_POST['content_client']); $email_vendor = array('recipients' => array(array('email' => $vendor->email, 'name' => $vendor->name)), 'subject' => $_POST['subject_vendor'], 'text' => array($vendor_text)); $email_client = array('recipients' => array(array('email' => $event->client_email, 'name' => $event->client_name)), 'subject' => $_POST['subject_client'], 'text' => array($client_text)); $this->send_email($email_vendor); $this->send_email($email_client); $this->send_sms($vendor->phone_1, $vendor_text); $this->send_sms($event->client_phone, $client_text); } } } } if (isset($_POST['create_folder'])) { $event_name = $event->event_type; $project_events = $this->event->order_by('date', 'ASC')->get_many_by('project_id = "' . $event->project_id . '" AND event_type_id = "' . $event->event_type_id . '"'); if (count($project_events) > 1) { $rank = 1; foreach ($project_events as $project_event) { if ($project_event->id === $event->id) { break; } $rank++; } $event_name = $event_name . ' ' . $rank; } if (isset($_POST['photoshoot_folder'])) { $event_name = $event_name . ' Photoshoot'; } $dbxClient = new \Dropbox\Client(getenv('DROPBOX_ACCESS_TOKEN'), "chaar-bhai/1.0"); if ($dbxClient->getMetadata('/' . $event->client_username . '/' . $event->project_name . '/' . $event_name) === null) { $dbxClient->createFolder('/' . $event->client_username . '/' . $event->project_name . '/' . $event_name . '/' . 'highres'); $dbxClient->createFolder('/' . $event->client_username . '/' . $event->project_name . '/' . $event_name . '/' . 'layouts'); $dbxClient->createFolder('/' . $event->client_username . '/' . $event->project_name . '/' . $event_name . '/' . 'proofs'); } } } else { $this->response(array('error' => 'Bad request'), 400); } }
protected function generate_admin_salaries() { $this->load->model('project_model', 'project'); $this->load->model('user_model', 'user'); $this->load->model('event_model', 'event'); $this->load->model('event_user_model', 'event_user'); $this->load->model('deliverable_model', 'deliverable'); $this->load->model('vendor_price_model', 'vendor_price'); $this->load->model('cashflow_type_model', 'cashflow_type'); $this->load->model('bank_account_model', 'bank_account'); $this->load->model('cashflow_model', 'cashflow'); $fahad = $this->user->get_by('name', 'Fahad Raza'); $taimur = $this->user->get_by('name', 'Taimur Riaz Khan'); $admins = array($fahad, $taimur); $admin_salary_id = $this->cashflow_type->get_by('name', 'Admin Salary')->id; $bank_account_id = $this->bank_account->get_by('name', 'Chaar Bhai')->id; $closed_projects = $this->project->get_many_by('closed_on BETWEEN "' . date('Y-m-d', strtotime("first day of last month")) . '" AND "' . date('Y-m-d', strtotime("last day of last month")) . '"'); foreach ($closed_projects as $closed_project) { $inflows = 0; $outflows = 0; $project_cashflows = $this->cashflow->get_project_cashflows($closed_project->id); $has_daily_salary = FALSE; $has_albums = FALSE; foreach ($project_cashflows as $project_cashflow) { if ($project_cashflow->class === 'Inflow') { $inflows += $project_cashflow->amount; } else { $outflows += $project_cashflow->amount; if ($project_cashflow->cashflow_type === 'Daily Salary') { $has_daily_salary = TRUE; } else { if ($project_cashflow->cashflow_type === 'Albums') { $has_albums = TRUE; } } } } if (!$has_daily_salary) { $daily_salary_id = $this->cashflow_type->get_by('name', 'Daily Salary')->id; $project_events = $this->event->get_many_by('project_id', $closed_project->id); $daily_salary_cashflows = array(); foreach ($project_events as $project_event) { $resources = $this->event_user->get_by_event_id($project_event->id); foreach ($resources as $resource) { if ($resource->role === 'Daily Worker') { if ($resource->daily_wage > 0) { $resource_class = ''; if ($resource->type === 'Team Lead' || $resource->type === 'Photographer') { $resource_class = 'Photo'; } else { if ($resource->type === 'Video Lead' || $resource->type === 'Videographer') { $resource_class = 'Video'; } } $amount = $resource->daily_wage; $event_deliverables = $this->deliverable->get_by_event_id($project_event->id); foreach ($event_deliverables as $event_deliverable) { if ($event_deliverable->class === $resource_class && $event_deliverable->name === 'Photoshoot') { $amount += $resource->photoshoot; } else { if ($event_deliverable->class === $resource_class && $event_deliverable->name === 'Sehrabandi') { $amount += $resource->sehrabandi; } else { if ($event_deliverable->class === $resource_class && $event_deliverable->name === 'Post Rukhsati') { $amount += $resource->post_rukhsati; } } } } $cashflow_exists = FALSE; foreach ($daily_salary_cashflows as &$daily_salary_cashflow) { if ($daily_salary_cashflow['date'] === date('Y-m-t', strtotime($project_event->date)) && $daily_salary_cashflow['project_id'] === $closed_project->id && $daily_salary_cashflow['user_id'] === $resource->id) { $daily_salary_cashflow['amount'] += $amount; $cashflow_exists = TRUE; break; } } if (!$cashflow_exists) { $daily_salary_cashflows[] = array('date' => date('Y-m-t', strtotime($project_event->date)), 'cashflow_type_id' => $daily_salary_id, 'project_id' => $closed_project->id, 'user_id' => $resource->id, 'amount' => $amount, 'bank_account_id' => $bank_account_id, 'log' => 'System created on ' . date('jS M, Y \\a\\t g:i a') . '.'); } } } } } foreach ($daily_salary_cashflows as &$daily_salary_cashflow) { $outflows += $daily_salary_cashflow['amount']; $this->cashflow->insert($daily_salary_cashflow); } } if (!$has_albums) { $dbxClient = new \Dropbox\Client(getenv('DROPBOX_ACCESS_TOKEN'), "chaar-bhai/1.0"); $albums_id = $this->cashflow_type->get_by('name', 'Albums')->id; $project_events = $this->event->get_events_for_admin_salary($closed_project->id); $album_cashflows = array(); foreach ($project_events as $project_event) { $event_deliverables = $this->deliverable->get_by_event_id($project_event->id); $rank = ''; $events = $this->event->order_by('date', 'ASC')->get_many_by('project_id = "' . $project_event->project_id . '" AND event_type_id = "' . $project_event->event_type_id . '"'); if (count($events) > 1) { $rank = 1; foreach ($events as $event) { if ($event->id === $project_event->id) { break; } $rank++; } $rank = ' ' . $rank; } $layout_designing_price = 1500; if (!empty($project_event->event_status)) { if ($project_event->event_status === 'Album Ready') { $amount = 0; $album_deliverable = ''; foreach ($event_deliverables as $event_deliverable) { if (strpos($event_deliverable->name, 'Album') !== FALSE && strpos($event_deliverable->name, 'Shoot') === FALSE && strpos($event_deliverable->name, 'Page') === FALSE) { $album_deliverable = $event_deliverable; break; } } if (!empty($album_deliverable)) { $album = $this->vendor_price->get_by(array('vendor_id' => $project_event->event_vendor_id, 'deliverable_type_id' => $album_deliverable->deliverable_type_id)); if (!empty($album)) { $event_folder = $project_event->event_type . $rank; $count_pages = count($dbxClient->getMetadataWithChildren('/' . $project_event->client_username . '/' . $project_event->project_name . '/' . $event_folder . '/layouts')['contents']); $amount = $layout_designing_price + $album->page_price * $count_pages * $album_deliverable->qty; } if ($amount > 0) { $cashflow_exists = FALSE; foreach ($album_cashflows as &$album_cashflow) { if ($album_cashflow['date'] === date('Y-m-t', strtotime($project_event->event_album_ready_date)) && $album_cashflow['project_id'] === $closed_project->id && $album_cashflow['user_id'] === $project_event->event_vendor_id) { $album_cashflow['amount'] += $amount; $cashflow_exists = TRUE; break; } } if (!$cashflow_exists) { $album_cashflows[] = array('date' => date('Y-m-t', strtotime($project_event->event_album_ready_date)), 'cashflow_type_id' => $albums_id, 'project_id' => $closed_project->id, 'user_id' => $project_event->event_vendor_id, 'amount' => $amount, 'bank_account_id' => $bank_account_id, 'log' => 'System created on ' . date('jS M, Y \\a\\t g:i a') . '.'); } } } } } if (!empty($project_event->photoshoot_status)) { if ($project_event->photoshoot_status === 'Album Ready') { $amount = 0; $album_deliverable = ''; foreach ($event_deliverables as $event_deliverable) { if (strpos($event_deliverable->name, 'Album') !== FALSE && strpos($event_deliverable->name, 'Shoot') !== FALSE) { $album_deliverable = $event_deliverable; break; } } if (!empty($album_deliverable)) { $album = $this->vendor_price->get_by(array('vendor_id' => $project_event->photoshoot_vendor_id, 'deliverable_type_id' => $album_deliverable->deliverable_type_id)); if (!empty($album)) { $event_folder = $project_event->event_type . $rank . ' Photoshoot'; $count_pages = count($dbxClient->getMetadataWithChildren('/' . $project_event->client_username . '/' . $project_event->project_name . '/' . $event_folder . '/layouts')['contents']); $amount = $layout_designing_price + $album->page_price * $count_pages * $album_deliverable->qty; } if ($amount > 0) { $cashflow_exists = FALSE; foreach ($album_cashflows as &$album_cashflow) { if ($album_cashflow['date'] === date('Y-m-t', strtotime($project_event->photoshoot_album_ready_date)) && $album_cashflow['project_id'] === $closed_project->id && $album_cashflow['user_id'] === $project_event->photoshoot_vendor_id) { $album_cashflow['amount'] += $amount; $cashflow_exists = TRUE; break; } } if (!$cashflow_exists) { $album_cashflows[] = array('date' => date('Y-m-t', strtotime($project_event->photoshoot_album_ready_date)), 'cashflow_type_id' => $albums_id, 'project_id' => $closed_project->id, 'user_id' => $project_event->photoshoot_vendor_id, 'amount' => $amount, 'bank_account_id' => $bank_account_id, 'log' => 'System created on ' . date('jS M, Y \\a\\t g:i a') . '.'); } } } } } } foreach ($album_cashflows as &$album_cashflow) { $outflows += $album_cashflow['amount']; $this->cashflow->insert($album_cashflow); } } foreach ($admins as $admin) { $admin_salary_cashflow = array('date' => date('Y-m-d', strtotime("last day of last month")), 'cashflow_type_id' => $admin_salary_id, 'user_id' => $admin->id, 'project_id' => $closed_project->id, 'amount' => round(0.45 * ($inflows - $outflows)), 'bank_account_id' => $bank_account_id, 'log' => 'System created on ' . date('jS M, Y \\a\\t g:i a') . '.'); $where = 'cashflow_type_id = "' . $admin_salary_id . '"'; $where .= ' AND project_id = "' . $admin_salary_cashflow['project_id'] . '"'; $where .= ' AND user_id = "' . $admin_salary_cashflow['user_id'] . '"'; $where .= ' AND date BETWEEN "' . date('Y-m-d', strtotime("first day of last month")) . '" AND "' . date('Y-m-d', strtotime("last day of last month")) . '"'; $same_cashflows = $this->cashflow->get_many_by($where); if (empty($same_cashflows)) { $this->cashflow->insert($admin_salary_cashflow); } } } }