functions.address_rewriting.inc.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515
  1. <?php
  2. function bcc($_action, $_data = null, $attr = null) {
  3. global $pdo;
  4. global $lang;
  5. if ($_SESSION['mailcow_cc_role'] != "admin" && $_SESSION['mailcow_cc_role'] != "domainadmin") {
  6. return false;
  7. }
  8. switch ($_action) {
  9. case 'add':
  10. if (!isset($_SESSION['acl']['bcc_maps']) || $_SESSION['acl']['bcc_maps'] != "1" ) {
  11. $_SESSION['return'] = array(
  12. 'type' => 'danger',
  13. 'msg' => sprintf($lang['danger']['access_denied'])
  14. );
  15. return false;
  16. }
  17. $local_dest = strtolower(trim($_data['local_dest']));
  18. $bcc_dest = $_data['bcc_dest'];
  19. $active = intval($_data['active']);
  20. $type = $_data['type'];
  21. if ($type != 'sender' && $type != 'rcpt') {
  22. $_SESSION['return'] = array(
  23. 'type' => 'danger',
  24. 'msg' => 'Invalid BCC map type'
  25. );
  26. return false;
  27. }
  28. if (empty($bcc_dest)) {
  29. $_SESSION['return'] = array(
  30. 'type' => 'danger',
  31. 'msg' => 'BCC destination cannot be empty'
  32. );
  33. return false;
  34. }
  35. if (is_valid_domain_name($local_dest)) {
  36. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $local_dest)) {
  37. $_SESSION['return'] = array(
  38. 'type' => 'danger',
  39. 'msg' => sprintf($lang['danger']['access_denied'])
  40. );
  41. return false;
  42. }
  43. $domain = idn_to_ascii($local_dest);
  44. $local_dest_sane = '@' . idn_to_ascii($local_dest);
  45. }
  46. elseif (filter_var($local_dest, FILTER_VALIDATE_EMAIL)) {
  47. if (!hasMailboxObjectAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $local_dest)) {
  48. $_SESSION['return'] = array(
  49. 'type' => 'danger',
  50. 'msg' => sprintf($lang['danger']['access_denied'])
  51. );
  52. return false;
  53. }
  54. $domain = mailbox('get', 'mailbox_details', $local_dest)['domain'];
  55. if (empty($domain)) {
  56. return false;
  57. }
  58. $local_dest_sane = $local_dest;
  59. }
  60. else {
  61. return false;
  62. }
  63. if (!filter_var($bcc_dest, FILTER_VALIDATE_EMAIL)) {
  64. $_SESSION['return'] = array(
  65. 'type' => 'danger',
  66. 'msg' => 'BCC map must be a valid email address'
  67. );
  68. return false;
  69. }
  70. try {
  71. $stmt = $pdo->prepare("SELECT `id` FROM `bcc_maps`
  72. WHERE `local_dest` = :local_dest AND `type` = :type");
  73. $stmt->execute(array(':local_dest' => $local_dest_sane, ':type' => $type));
  74. $num_results = count($stmt->fetchAll(PDO::FETCH_ASSOC));
  75. }
  76. catch(PDOException $e) {
  77. $_SESSION['return'] = array(
  78. 'type' => 'danger',
  79. 'msg' => 'MySQL: '.$e
  80. );
  81. return false;
  82. }
  83. if ($num_results != 0) {
  84. $_SESSION['return'] = array(
  85. 'type' => 'danger',
  86. 'msg' => 'A BCC map entry "' . htmlspecialchars($local_dest_sane) . '" exists for type "' . $type . '"'
  87. );
  88. return false;
  89. }
  90. try {
  91. $stmt = $pdo->prepare("INSERT INTO `bcc_maps` (`local_dest`, `bcc_dest`, `domain`, `active`, `type`) VALUES
  92. (:local_dest, :bcc_dest, :domain, :active, :type)");
  93. $stmt->execute(array(
  94. ':local_dest' => $local_dest_sane,
  95. ':bcc_dest' => $bcc_dest,
  96. ':domain' => $domain,
  97. ':active' => $active,
  98. ':type' => $type
  99. ));
  100. }
  101. catch (PDOException $e) {
  102. $_SESSION['return'] = array(
  103. 'type' => 'danger',
  104. 'msg' => 'MySQL: '.$e
  105. );
  106. return false;
  107. }
  108. $_SESSION['return'] = array(
  109. 'type' => 'success',
  110. 'msg' => 'BCC map entry saved'
  111. );
  112. break;
  113. case 'edit':
  114. if (!isset($_SESSION['acl']['bcc_maps']) || $_SESSION['acl']['bcc_maps'] != "1" ) {
  115. $_SESSION['return'] = array(
  116. 'type' => 'danger',
  117. 'msg' => sprintf($lang['danger']['access_denied'])
  118. );
  119. return false;
  120. }
  121. $ids = (array)$_data['id'];
  122. foreach ($ids as $id) {
  123. $is_now = bcc('details', $id);
  124. if (!empty($is_now)) {
  125. $active = (isset($_data['active'])) ? intval($_data['active']) : $is_now['active_int'];
  126. $bcc_dest = (!empty($_data['bcc_dest'])) ? $_data['bcc_dest'] : $is_now['bcc_dest'];
  127. $local_dest = $is_now['local_dest'];
  128. $type = (!empty($_data['type'])) ? $_data['type'] : $is_now['type'];
  129. }
  130. else {
  131. $_SESSION['return'] = array(
  132. 'type' => 'danger',
  133. 'msg' => sprintf($lang['danger']['access_denied'])
  134. );
  135. return false;
  136. }
  137. $active = intval($_data['active']);
  138. if (!filter_var($bcc_dest, FILTER_VALIDATE_EMAIL)) {
  139. $_SESSION['return'] = array(
  140. 'type' => 'danger',
  141. 'msg' => 'BCC map must be a valid email address'
  142. );
  143. return false;
  144. }
  145. if (empty($bcc_dest)) {
  146. $_SESSION['return'] = array(
  147. 'type' => 'danger',
  148. 'msg' => 'BCC map destination cannot be empty'
  149. );
  150. return false;
  151. }
  152. try {
  153. $stmt = $pdo->prepare("SELECT `id` FROM `bcc_maps`
  154. WHERE `local_dest` = :local_dest AND `type` = :type");
  155. $stmt->execute(array(':local_dest' => $local_dest, ':type' => $type));
  156. $id_now = $stmt->fetch(PDO::FETCH_ASSOC)['id'];
  157. }
  158. catch(PDOException $e) {
  159. $_SESSION['return'] = array(
  160. 'type' => 'danger',
  161. 'msg' => 'MySQL: '.$e
  162. );
  163. return false;
  164. }
  165. if (isset($id_now) && $id_now != $id) {
  166. $_SESSION['return'] = array(
  167. 'type' => 'danger',
  168. 'msg' => 'A BCC map entry ' . htmlspecialchars($local_dest) . ' exists for this type'
  169. );
  170. return false;
  171. }
  172. try {
  173. $stmt = $pdo->prepare("UPDATE `bcc_maps` SET `bcc_dest` = :bcc_dest, `active` = :active, `type` = :type WHERE `id`= :id");
  174. $stmt->execute(array(
  175. ':bcc_dest' => $bcc_dest,
  176. ':active' => $active,
  177. ':type' => $type,
  178. ':id' => $id
  179. ));
  180. }
  181. catch (PDOException $e) {
  182. $_SESSION['return'] = array(
  183. 'type' => 'danger',
  184. 'msg' => 'MySQL: '.$e
  185. );
  186. return false;
  187. }
  188. }
  189. $_SESSION['return'] = array(
  190. 'type' => 'success',
  191. 'msg' => 'BCC map entry edited'
  192. );
  193. break;
  194. case 'details':
  195. $bccdata = array();
  196. $id = intval($_data);
  197. try {
  198. $stmt = $pdo->prepare("SELECT `id`,
  199. `local_dest`,
  200. `bcc_dest`,
  201. `active` AS `active_int`,
  202. CASE `active` WHEN 1 THEN '".$lang['mailbox']['yes']."' ELSE '".$lang['mailbox']['no']."' END AS `active`,
  203. `type`,
  204. `created`,
  205. `domain`,
  206. `modified` FROM `bcc_maps`
  207. WHERE `id` = :id");
  208. $stmt->execute(array(':id' => $id));
  209. $bccdata = $stmt->fetch(PDO::FETCH_ASSOC);
  210. }
  211. catch(PDOException $e) {
  212. $_SESSION['return'] = array(
  213. 'type' => 'danger',
  214. 'msg' => 'MySQL: '.$e
  215. );
  216. return false;
  217. }
  218. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $bccdata['domain'])) {
  219. $bccdata = null;
  220. return false;
  221. }
  222. return $bccdata;
  223. break;
  224. case 'get':
  225. $bccdata = array();
  226. $all_items = array();
  227. $id = intval($_data);
  228. try {
  229. $stmt = $pdo->query("SELECT `id`, `domain` FROM `bcc_maps`");
  230. $all_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
  231. }
  232. catch(PDOException $e) {
  233. $_SESSION['return'] = array(
  234. 'type' => 'danger',
  235. 'msg' => 'MySQL: '.$e
  236. );
  237. return false;
  238. }
  239. foreach ($all_items as $i) {
  240. if (hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $i['domain'])) {
  241. $bccdata[] = $i['id'];
  242. }
  243. }
  244. $all_items = null;
  245. return $bccdata;
  246. break;
  247. case 'delete':
  248. $ids = (array)$_data['id'];
  249. foreach ($ids as $id) {
  250. if (!is_numeric($id)) {
  251. return false;
  252. }
  253. try {
  254. $stmt = $pdo->prepare("SELECT `domain` FROM `bcc_maps` WHERE id = :id");
  255. $stmt->execute(array(':id' => $id));
  256. $domain = $stmt->fetch(PDO::FETCH_ASSOC)['domain'];
  257. if (!hasDomainAccess($_SESSION['mailcow_cc_username'], $_SESSION['mailcow_cc_role'], $domain)) {
  258. $_SESSION['return'] = array(
  259. 'type' => 'danger',
  260. 'msg' => sprintf($lang['danger']['access_denied'])
  261. );
  262. return false;
  263. }
  264. $stmt = $pdo->prepare("DELETE FROM `bcc_maps` WHERE `id`= :id");
  265. $stmt->execute(array(':id' => $id));
  266. }
  267. catch (PDOException $e) {
  268. $_SESSION['return'] = array(
  269. 'type' => 'danger',
  270. 'msg' => 'MySQL: '.$e
  271. );
  272. return false;
  273. }
  274. }
  275. $_SESSION['return'] = array(
  276. 'type' => 'success',
  277. 'msg' => 'Deleted BCC map id/s ' . implode(', ', $ids)
  278. );
  279. return true;
  280. break;
  281. }
  282. }
  283. function recipient_map($_action, $_data = null, $attr = null) {
  284. global $pdo;
  285. global $lang;
  286. if ($_SESSION['mailcow_cc_role'] != "admin") {
  287. return false;
  288. }
  289. switch ($_action) {
  290. case 'add':
  291. $old_dest = strtolower(trim($_data['recipient_map_old']));
  292. $new_dest = array_map('trim', preg_split( "/( |,|;|\n)/", $_data['recipient_map_new']));
  293. $active = intval($_data['active']);
  294. if (empty($new_dest)) {
  295. $_SESSION['return'] = array(
  296. 'type' => 'danger',
  297. 'msg' => 'Recipient map destination cannot be empty'
  298. );
  299. return false;
  300. }
  301. if (is_valid_domain_name($old_dest)) {
  302. $old_dest_sane = '@' . idn_to_ascii($old_dest);
  303. }
  304. elseif (filter_var($old_dest, FILTER_VALIDATE_EMAIL)) {
  305. $old_dest_sane = $old_dest;
  306. }
  307. else {
  308. $_SESSION['return'] = array(
  309. 'type' => 'danger',
  310. 'msg' => 'Invalid original recipient specified: ' . $old_dest
  311. );
  312. return false;
  313. }
  314. foreach ($new_dest as &$new_dest_e) {
  315. if (!filter_var($new_dest_e, FILTER_VALIDATE_EMAIL)) {
  316. $new_dest_e = null;
  317. }
  318. $new_dest_e = strtolower($new_dest_e);
  319. }
  320. $new_dest = array_filter($new_dest);
  321. $new_dest = implode(",", $new_dest);
  322. if (empty($new_dest)) {
  323. $_SESSION['return'] = array(
  324. 'type' => 'danger',
  325. 'msg' => 'Recipient map destination cannot be empty'
  326. );
  327. return false;
  328. }
  329. try {
  330. $stmt = $pdo->prepare("SELECT `id` FROM `recipient_maps`
  331. WHERE `old_dest` = :old_dest");
  332. $stmt->execute(array(':old_dest' => $old_dest_sane));
  333. $num_results = count($stmt->fetchAll(PDO::FETCH_ASSOC));
  334. }
  335. catch(PDOException $e) {
  336. $_SESSION['return'] = array(
  337. 'type' => 'danger',
  338. 'msg' => 'MySQL: '.$e
  339. );
  340. return false;
  341. }
  342. if ($num_results != 0) {
  343. $_SESSION['return'] = array(
  344. 'type' => 'danger',
  345. 'msg' => 'A Recipient map entry "' . htmlspecialchars($old_dest_sane) . '" exists'
  346. );
  347. return false;
  348. }
  349. try {
  350. $stmt = $pdo->prepare("INSERT INTO `recipient_maps` (`old_dest`, `new_dest`, `active`) VALUES
  351. (:old_dest, :new_dest, :active)");
  352. $stmt->execute(array(
  353. ':old_dest' => $old_dest_sane,
  354. ':new_dest' => $new_dest,
  355. ':active' => $active
  356. ));
  357. }
  358. catch (PDOException $e) {
  359. $_SESSION['return'] = array(
  360. 'type' => 'danger',
  361. 'msg' => 'MySQL: '.$e
  362. );
  363. return false;
  364. }
  365. $_SESSION['return'] = array(
  366. 'type' => 'success',
  367. 'msg' => 'Recipient map entry saved'
  368. );
  369. break;
  370. case 'edit':
  371. $ids = (array)$_data['id'];
  372. foreach ($ids as $id) {
  373. $is_now = recipient_map('details', $id);
  374. if (!empty($is_now)) {
  375. $active = (isset($_data['active'])) ? intval($_data['active']) : $is_now['active_int'];
  376. $new_dest = (!empty($_data['recipient_map_new'])) ? $_data['recipient_map_new'] : $is_now['recipient_map_new'];
  377. $old_dest = $is_now['old_dest'];
  378. }
  379. else {
  380. $_SESSION['return'] = array(
  381. 'type' => 'danger',
  382. 'msg' => sprintf($lang['danger']['access_denied'])
  383. );
  384. return false;
  385. }
  386. $new_dest = array_map('trim', preg_split( "/( |,|;|\n)/", $new_dest));
  387. $active = intval($_data['active']);
  388. foreach ($new_dest as &$new_dest_e) {
  389. if (!filter_var($new_dest_e, FILTER_VALIDATE_EMAIL)) {
  390. $new_dest_e = null;;
  391. }
  392. $new_dest_e = strtolower($new_dest_e);
  393. }
  394. $new_dest = array_filter($new_dest);
  395. $new_dest = implode(",", $new_dest);
  396. if (empty($new_dest)) {
  397. $_SESSION['return'] = array(
  398. 'type' => 'danger',
  399. 'msg' => 'Recipient map destination cannot be empty'
  400. );
  401. return false;
  402. }
  403. try {
  404. $stmt = $pdo->prepare("SELECT `id` FROM `recipient_maps`
  405. WHERE `old_dest` = :old_dest");
  406. $stmt->execute(array(':old_dest' => $old_dest));
  407. $id_now = $stmt->fetch(PDO::FETCH_ASSOC)['id'];
  408. }
  409. catch(PDOException $e) {
  410. $_SESSION['return'] = array(
  411. 'type' => 'danger',
  412. 'msg' => 'MySQL: '.$e
  413. );
  414. return false;
  415. }
  416. if (isset($id_now) && $id_now != $id) {
  417. $_SESSION['return'] = array(
  418. 'type' => 'danger',
  419. 'msg' => 'A Recipient map entry ' . htmlspecialchars($old_dest) . ' exists'
  420. );
  421. return false;
  422. }
  423. try {
  424. $stmt = $pdo->prepare("UPDATE `recipient_maps` SET `new_dest` = :new_dest, `active` = :active WHERE `id`= :id");
  425. $stmt->execute(array(
  426. ':new_dest' => $new_dest,
  427. ':active' => $active,
  428. ':id' => $id
  429. ));
  430. }
  431. catch (PDOException $e) {
  432. $_SESSION['return'] = array(
  433. 'type' => 'danger',
  434. 'msg' => 'MySQL: '.$e
  435. );
  436. return false;
  437. }
  438. }
  439. $_SESSION['return'] = array(
  440. 'type' => 'success',
  441. 'msg' => 'Recipient map entry edited'
  442. );
  443. break;
  444. case 'details':
  445. $mapdata = array();
  446. $id = intval($_data);
  447. try {
  448. $stmt = $pdo->prepare("SELECT `id`,
  449. `old_dest` AS `recipient_map_old`,
  450. `new_dest` AS `recipient_map_new`,
  451. `active` AS `active_int`,
  452. CASE `active` WHEN 1 THEN '".$lang['mailbox']['yes']."' ELSE '".$lang['mailbox']['no']."' END AS `active`,
  453. `created`,
  454. `modified` FROM `recipient_maps`
  455. WHERE `id` = :id");
  456. $stmt->execute(array(':id' => $id));
  457. $mapdata = $stmt->fetch(PDO::FETCH_ASSOC);
  458. }
  459. catch(PDOException $e) {
  460. $_SESSION['return'] = array(
  461. 'type' => 'danger',
  462. 'msg' => 'MySQL: '.$e
  463. );
  464. return false;
  465. }
  466. return $mapdata;
  467. break;
  468. case 'get':
  469. $mapdata = array();
  470. $all_items = array();
  471. $id = intval($_data);
  472. try {
  473. $stmt = $pdo->query("SELECT `id` FROM `recipient_maps`");
  474. $all_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
  475. }
  476. catch(PDOException $e) {
  477. $_SESSION['return'] = array(
  478. 'type' => 'danger',
  479. 'msg' => 'MySQL: '.$e
  480. );
  481. return false;
  482. }
  483. foreach ($all_items as $i) {
  484. $mapdata[] = $i['id'];
  485. }
  486. $all_items = null;
  487. return $mapdata;
  488. break;
  489. case 'delete':
  490. $ids = (array)$_data['id'];
  491. foreach ($ids as $id) {
  492. if (!is_numeric($id)) {
  493. return false;
  494. }
  495. try {
  496. $stmt = $pdo->prepare("DELETE FROM `recipient_maps` WHERE `id`= :id");
  497. $stmt->execute(array(':id' => $id));
  498. }
  499. catch (PDOException $e) {
  500. $_SESSION['return'] = array(
  501. 'type' => 'danger',
  502. 'msg' => 'MySQL: '.$e
  503. );
  504. return false;
  505. }
  506. }
  507. $_SESSION['return'] = array(
  508. 'type' => 'success',
  509. 'msg' => 'Deleted Recipient map id/s ' . implode(', ', $ids)
  510. );
  511. return true;
  512. break;
  513. }
  514. }