Browse code

Changed majority of files.

DoubleBastionAdmin authored on 30/11/2024 06:56:40
Showing 1 changed files
src/export-contacts-by-date.php
History View file @ e8a619c
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,94 @@
1 
+<?php
2 
+/**
3 
+ *  Copyright (C) 2022, 2024  Double Bastion LLC
4 
+ *
5 
+ *  This file is part of Roundpin, which is licensed under the
6 
+ *  GNU Affero General Public License Version 3.0. The license terms
7 
+ *  are detailed in the "LICENSE.txt" file located in the root directory.
8 
+ */
9 
+
10 
+session_start();
11 
+
12 
+if (isset($_POST['s_ajax_call']) && ($_POST['s_ajax_call'] == $_SESSION['validate_s_access'])) {
13 
+
14 
+    define('ACCESSCONST', TRUE);
15 
+
16 
+    require('db-connect.php');
17 
+
18 
+    $username = $_POST['username'];
19 
+    $csvDelimiter = $_POST['csvdelimiter'];
20 
+    $startDate = $_POST['expstartdate'];
21 
+    $endDate = $_POST['expenddate'];
22 
+    $startDateFmt = new DateTime($startDate . " 00:00:00");
23 
+    $endDateFmt = new DateTime($endDate . " 24:59:59");
24 
+
25 
+    // Get the id of the current user from the 'app_users' table
26 
+    $queryid = $mysqli->prepare("SELECT id, username FROM app_users WHERE BINARY username = ?");
27 
+    $queryid->bind_param("s", $username);
28 
+    $queryid->execute();
29 
+    $queryres = $queryid->get_result()->fetch_assoc();
30 
+    $userID = $queryres['id'];
31 
+
32 
+    // Get the contacts for the current user
33 
+    $querycont = $mysqli->prepare("SELECT id, user_id, contact_name, contact_desc, contact_long_desc, address_street, address_zip, address_town, address_country, address_state,
34 
+                                   extension_number, contact_mobile, contact_num1, contact_num2, contact_fax, contact_email, profile_picture_c, groups, date_added, date_modified
35 
+                                   FROM contacts WHERE user_id = ?");
36 
+    $querycont->bind_param("i", $userID);
37 
+    $querycont->execute();
38 
+    $queryres = $querycont->get_result();
39 
+
40 
+    $contactsarr = [];
41 
+    while ($querycontres = $queryres->fetch_assoc()) {
42 
+
43 
+           $dateAddedFmt = new DateTime($querycontres['date_added']);
44 
+
45 
+           if ($startDate == "" && $endDate != "") {
46 
+
47 
+               if ($dateAddedFmt <= $endDateFmt) {
48 
+
49 
+                   $contactsarr[] = ['contact_name' => $querycontres['contact_name'], 'contact_desc' => $querycontres['contact_desc'],
50 
+                                     'contact_long_desc' => $querycontres['contact_long_desc'], 'address_street' => $querycontres['address_street'],
51 
+                                     'address_zip' => $querycontres['address_zip'], 'address_town' => $querycontres['address_town'], 'address_country' => $querycontres['address_country'],
52 
+                                     'address_state' => $querycontres['address_state'], 'extension_number' => $querycontres['extension_number'],
53 
+                                     'contact_mobile' => $querycontres['contact_mobile'], 'contact_num1' => $querycontres['contact_num1'], 'contact_num2' => $querycontres['contact_num2'],
54 
+                                     'contact_fax' => $querycontres['contact_fax'], 'contact_email' => $querycontres['contact_email'],
55 
+                                     'profile_picture_c' => $querycontres['profile_picture_c'], 'groups' => $querycontres['groups'], 'date_added' => $querycontres['date_added'],
56 
+                                     'date_modified' => $querycontres['date_modified']];
57 
+
58 
+                   $messagetosend = 'success';
59 
+
60 
+                   $crntRow = implode("", $querycontres);
61 
+                   if (strpos($crntRow, $csvDelimiter) !== false) { $messagetosend = 'delimiterfound'; break; }
62 
+               }
63 
+
64 
+           } elseif ($startDate != "" && $endDate != "") {
65 
+
66 
+               if ($startDateFmt <= $dateAddedFmt && $dateAddedFmt <= $endDateFmt) {
67 
+
68 
+                   $contactsarr[] = ['contact_name' => $querycontres['contact_name'], 'contact_desc' => $querycontres['contact_desc'],
69 
+                                     'contact_long_desc' => $querycontres['contact_long_desc'], 'address_street' => $querycontres['address_street'],
70 
+                                     'address_zip' => $querycontres['address_zip'], 'address_town' => $querycontres['address_town'], 'address_country' => $querycontres['address_country'],
71 
+                                     'address_state' => $querycontres['address_state'], 'extension_number' => $querycontres['extension_number'],
72 
+                                     'contact_mobile' => $querycontres['contact_mobile'], 'contact_num1' => $querycontres['contact_num1'], 'contact_num2' => $querycontres['contact_num2'],
73 
+                                     'contact_fax' => $querycontres['contact_fax'], 'contact_email' => $querycontres['contact_email'],
74 
+                                     'profile_picture_c' => $querycontres['profile_picture_c'], 'groups' => $querycontres['groups'], 'date_added' => $querycontres['date_added'],
75 
+                                     'date_modified' => $querycontres['date_modified']];
76 
+
77 
+                   $messagetosend = 'success';
78 
+
79 
+                   $crntRow = implode("", $querycontres);
80 
+                   if (strpos($crntRow, $csvDelimiter) !== false) { $messagetosend = 'delimiterfound'; break; }
81 
+               }
82 
+
83 
+           }
84 
+    }
85 
+
86 
+    $contactsfromdb = ['contactsdata' => $contactsarr, 'messagetoconvey' => $messagetosend];
87 
+
88 
+    echo json_encode($contactsfromdb);
89 
+
90 
+} else {
91 
+        header("Location: ../login.php");
92 
+}
93 
+
94 
+?>