rin-career-ready/SystemDBApi.php at master · bd-php/rin-career-ready · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
/**
 * Created by IntelliJ IDEA.
 * User: smssd
 * Date: 8/28/2016
 * Time: 4:42 PM
 */

include_once("Config.php");

$option = $_REQUEST["option"];

$conn = new mysqli($Server, $UserID, $Password, $Database);

if ($option == "userCount") {
    $userStartDate = $_REQUEST["userStartDate"];
    $userStartTime = $_REQUEST["userStartTime"];
    $userEndDate = $_REQUEST["userEndDate"];
    $userEndTime = $_REQUEST["userEndTime"];

    $userStartDateTime = $userStartDate . " " . $userStartTime . ":00";
    $userEndDateTime = $userEndDate . " " . $userEndTime . ":00";

    $sql = "SELECT COUNT(*) FROM tbl_users WHERE MSISDN NOT IN  ( SELECT MSISDN FROM blocklist ) AND registration_date BETWEEN '$userStartDateTime' AND '$userEndDateTime' ";

    $result = $conn->query($sql);
    $row = $result->fetch_row();
    $callCount = $row[0];

    echo $callCount;

} else if ($option == "campaignCount") {
    $campaignStartDate = $_REQUEST["campaignStartDate"];
    $campaignStartTime = $_REQUEST["campaignStartTime"];
    $campaignEndDate = $_REQUEST["campaignEndDate"];
    $campaignEndTime = $_REQUEST["campaignEndTime"];

    $campaignStartDateTime = $campaignStartDate . " " . $campaignStartTime . ":00";
    $campaignDateTime = $campaignEndDate . " " . $campaignEndTime . ":00";

    $sql = "SELECT SUM(MINUTE(TIMEDIFF(lastUpdate,start_time))+1)
                FROM tbl_user_info_history";
    $result = $conn->query($sql);
    $row = $result->fetch_row();
    $tbl_user_info_history_time = $row[0];


    $sql = "SELECT SUM(MINUTE(TIMEDIFF(lastUpdate,start_time))+1)
                FROM tbl_users_history";
    $result = $conn->query($sql);
    $row = $result->fetch_row();
    $tbl_users_history_time = $row[0];


    $sql = "SELECT SUM(MINUTE(TIMEDIFF(lastUpdate,start_time))+1)
                FROM tbl_reg_answers";
    $result = $conn->query($sql);
    $row = $result->fetch_row();
    $tbl_reg_answers_time = $row[0];

    $totalMinuteCompleted = $tbl_user_info_history_time
        + $tbl_users_history_time
        + $tbl_reg_answers_time;

    echo $totalMinuteCompleted;

} else if ($option == "smsCount") {
    $smsStartDate = $_REQUEST["smsStartDate"];
    $smsStartTime = $_REQUEST["smsStartTime"];
    $smsEndDate = $_REQUEST["smsEndDate"];
    $smsEndTime = $_REQUEST["smsEndTime"];

    $smsStartDateTime = $smsStartDate . " " . $smsStartTime . ":00";
    $smsEndDateTime = $smsEndDate . " " . $smsEndTime . ":00";

    $sql = "SELECT COUNT(*) FROM tbl_miss_call_history WHERE date BETWEEN '$smsStartDateTime' AND '$smsEndDateTime' ";

    $result = $conn->query($sql);
    $row = $result->fetch_row();
    $callCount = $row[0];

    echo $callCount;
}