Merge pull request #14279 from eileenmcnaughton/db_test2
[civicrm-core.git] / CRM / Contact / Page / ImageFile.php
1 <?php
2 /*
3 +--------------------------------------------------------------------+
4 | CiviCRM version 5 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2019 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
9 | |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
13 | |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
18 | |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
26 */
27
28 /**
29 *
30 * @package CRM
31 * @copyright CiviCRM LLC (c) 2004-2019
32 */
33 class CRM_Contact_Page_ImageFile extends CRM_Core_Page {
34 /**
35 * @var int Time to live (seconds).
36 *
37 * 12 hours: 12 * 60 * 60 = 43200
38 */
39 private $ttl = 43200;
40
41 /**
42 * Run page.
43 *
44 * @throws \Exception
45 */
46 public function run() {
47 if (!preg_match('/^[^\/]+\.(jpg|jpeg|png|gif)$/i', $_GET['photo'])) {
48 throw new CRM_Core_Exception(ts('Malformed photo name'));
49 }
50
51 // FIXME Optimize performance of image_url query
52 $sql = "SELECT id FROM civicrm_contact WHERE image_url like %1;";
53 $params = [
54 1 => ["%" . $_GET['photo'], 'String'],
55 ];
56 $dao = CRM_Core_DAO::executeQuery($sql, $params);
57 $cid = NULL;
58 while ($dao->fetch()) {
59 $cid = $dao->id;
60 }
61 if ($cid) {
62 $config = CRM_Core_Config::singleton();
63 $fileExtension = strtolower(pathinfo($_GET['photo'], PATHINFO_EXTENSION));
64 $this->download(
65 $config->customFileUploadDir . $_GET['photo'],
66 'image/' . ($fileExtension == 'jpg' ? 'jpeg' : $fileExtension),
67 $this->ttl
68 );
69 CRM_Utils_System::civiExit();
70 }
71 else {
72 throw new CRM_Core_Exception(ts('Photo does not exist'));
73 }
74 }
75
76 /**
77 * Download image.
78 *
79 * @param string $file
80 * Local file path.
81 * @param string $mimeType
82 * @param int $ttl
83 * Time to live (seconds).
84 */
85 protected function download($file, $mimeType, $ttl) {
86 if (!file_exists($file)) {
87 header("HTTP/1.0 404 Not Found");
88 return;
89 }
90 elseif (!is_readable($file)) {
91 header('HTTP/1.0 403 Forbidden');
92 return;
93 }
94 CRM_Utils_System::setHttpHeader('Expires', gmdate('D, d M Y H:i:s \G\M\T', CRM_Utils_Time::getTimeRaw() + $ttl));
95 CRM_Utils_System::setHttpHeader("Content-Type", $mimeType);
96 CRM_Utils_System::setHttpHeader("Content-Disposition", "inline; filename=\"" . basename($file) . "\"");
97 CRM_Utils_System::setHttpHeader("Cache-Control", "max-age=$ttl, public");
98 CRM_Utils_System::setHttpHeader('Pragma', 'public');
99 readfile($file);
100 }
101
102 }