PHP do_field_duration Examples

Example #1

File: call-log.php Project: butch/asterisk-cdr-plus

                }
            } else {
                $sql = "{$sql} LIKE '%" . ${$fld} . "%'";
            }
        }
        return $sql;
    }
    $SQLcmd = '';
    $SQLcmd = do_field($SQLcmd, 'clid');
    $SQLcmd = do_field($SQLcmd, 'src');
    $SQLcmd = do_field($SQLcmd, 'dst');
    $SQLcmd = do_field($SQLcmd, 'userfield');
    $SQLcmd = do_field($SQLcmd, 'accountcode');
    $SQLcmd = do_field($SQLcmd, 'channel');
    $SQLcmd = do_field_duration($SQLcmd, 'duration1', 'duration');
    $SQLcmd = do_field_duration($SQLcmd, 'duration2', 'duration');
    $SQLcmd = do_field($SQLcmd, 'uuid');
}
$date_clause = '';
// Period (Month-Day)
if (DB_TYPE == "postgres") {
    $UNIX_TIMESTAMP = "";
} else {
    $UNIX_TIMESTAMP = "UNIX_TIMESTAMP";
}
if ($Period == "Month") {
    if ($frommonth && isset($fromstatsmonth)) {
        $date_clause .= " AND {$UNIX_TIMESTAMP}(calldate) >= {$UNIX_TIMESTAMP}('{$fromstatsmonth}-01')";
    }
    if ($tomonth && isset($tostatsmonth)) {
        $date_clause .= " AND {$UNIX_TIMESTAMP}(calldate) <= {$UNIX_TIMESTAMP}('{$tostatsmonth}-31 23:59:59')";

Example #2

File: call-log.php Project: antirek/prestige-pbx

                }
            } else {
                $sql = "{$sql} LIKE '%" . ${$fld} . "%'";
            }
        }
        return $sql;
    }
    $SQLcmd = '';
    $SQLcmd = do_field($SQLcmd, 'clid');
    $SQLcmd = do_field($SQLcmd, 'src');
    $SQLcmd = do_field($SQLcmd, 'dst');
    $SQLcmd = do_field($SQLcmd, 'userfield');
    $SQLcmd = do_field($SQLcmd, 'accountcode');
    $SQLcmd = do_field($SQLcmd, 'channel');
    $SQLcmd = do_field_duration($SQLcmd, 'duration1', 'billsec');
    $SQLcmd = do_field_duration($SQLcmd, 'duration2', 'billsec');
}
$date_clause = '';
// Period (Month-Day)
if (DB_TYPE == "postgres") {
    $UNIX_TIMESTAMP = "";
} else {
    $UNIX_TIMESTAMP = "UNIX_TIMESTAMP";
}
if ($Period == "Month") {
    if ($frommonth && isset($fromstatsmonth)) {
        $date_clause .= " AND {$UNIX_TIMESTAMP}(calldate) >= {$UNIX_TIMESTAMP}('{$fromstatsmonth}-01')";
    }
    if ($tomonth && isset($tostatsmonth)) {
        $date_clause .= " AND {$UNIX_TIMESTAMP}(calldate) <= {$UNIX_TIMESTAMP}('{$tostatsmonth}-31 23:59:59')";
    }