thorderby PHP Code Examples

Example #1

0

Show file

File: userlist.php Project: petekelly/fusionpbx

echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
//echo "<tr><td colspan='100%'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>";
if ($resultcount == 0) {
    //no results
    echo "<tr><td>&nbsp;</td></tr>";
} else {
    //received results
    echo "<tr>";
    echo thorderby('Username', 'Username', $orderby, $order);
    echo thorderby('Userfirstname', 'First Name', $orderby, $order);
    echo thorderby('Userlastname', 'Last Name', $orderby, $order);
    echo thorderby('Usercompanyname', 'Company', $orderby, $order);
    echo thorderby('Userphysicalcity', 'City', $orderby, $order);
    echo thorderby('Userphysicalstateprovince', 'State', $orderby, $order);
    echo thorderby('Userphone1', 'Phone', $orderby, $order);
    echo thorderby('Useremail', 'Email', $orderby, $order);
    echo "<td width='42px' align=\"right\" nowrap>\n";
    echo "\t<a href='signup.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
    echo "</td>\n";
    echo "</tr>";
    //echo "<tr><td colspan='100%'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>\n";
    foreach ($result as $row) {
        //print_r( $row );
        if (!ifgroup("superadmin") && ifsuperadmin($superadminlist, $row[username])) {
            //allow superadmins to view all users
        } else {
            echo "<tr>\n";
            //echo "<td valign='top'>".$row[useroptional2]."</td>";
            //echo "<td valign='top'>".$row[useroptional1]."</td>";
            //if (ifgroup("admin")) {
            //    echo "<td valign='top'><a href='usersupdate.php?id=".$row[id]."'>".$row[id]."</a></td>";

Example #2

0

Show file

File: v_xml_cdr.php Project: petekelly/fusionpbx

echo "<tr class='border'>\n";
echo "\t<td align=\"left\">\n";
echo "\t\t<br>";
echo "<div align='left'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('direction', 'Direction', $orderby, $order);
//echo thorderby('default_language', 'Language', $orderby, $order);
//echo thorderby('context', 'Context', $orderby, $order);
echo thorderby('caller_id_name', 'Name', $orderby, $order);
echo thorderby('caller_id_number', 'Number', $orderby, $order);
echo thorderby('destination_number', 'Destination', $orderby, $order);
echo thorderby('start_stamp', 'Start', $orderby, $order);
echo thorderby('end_stamp', 'End', $orderby, $order);
echo thorderby('duration', 'Length', $orderby, $order);
echo thorderby('hangup_cause', 'Status', $orderby, $order);
echo "<form method='post' action='v_xml_cdr_csv.php'>";
echo "<td align='left' width='22'>\n";
echo "<input type='hidden' name='caller_id_name' value='{$caller_id_name}'>\n";
echo "<input type='hidden' name='start_stamp' value='{$start_stamp}'>\n";
echo "<input type='hidden' name='hangup_cause' value='{$hangup_cause}'>\n";
echo "<input type='hidden' name='caller_id_number' value='{$caller_id_number}'>\n";
echo "<input type='hidden' name='destination_number' value='{$destination_number}'>\n";
//echo "<input type='hidden' name='context' value='$context'>\n";
echo "<input type='hidden' name='answer_stamp' value='{$answer_stamp}'>\n";
echo "<input type='hidden' name='end_stamp' value='{$end_stamp}'>\n";
echo "<input type='hidden' name='duration' value='{$duration}'>\n";
echo "<input type='hidden' name='billsec' value='{$billsec}'>\n";
echo "<input type='hidden' name='uuid' value='{$uuid}'>\n";
echo "<input type='hidden' name='bleg_uuid' value='{$bleg_uuid}'>\n";
echo "<input type='hidden' name='accountcode' value='{$accountcode}'>\n";

Example #3

0

Show file

File: templates.php Project: petekelly/fusionpbx

    $sql .= "order by {$orderby} {$order} ";
}
$sql .= " limit {$rowsperpage} offset {$offset} ";
$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('templatename', 'Name', $orderby, $order);
echo thorderby('templatedesc', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='templates_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//echo "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='templates_edit.php'\" value='+'>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[templatename] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[templatedesc] . "&nbsp;</td>\n";
        echo "\t<td valign='top' align='right'>\n";

Example #4

0

Show file

File: v_modules.php Project: petekelly/fusionpbx

$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
$tmp_module_header = "\n";
$tmp_module_header .= "<tr>\n";
//$tmp_module_header .= thorderby('modulecat', 'Module Category', $orderby, $order);
$tmp_module_header .= thorderby('modulelabel', 'Label', $orderby, $order);
//$tmp_module_header .= thorderby('modulename', 'Module Name', $orderby, $order);
$tmp_module_header .= thorderby('moduledesc', 'Description', $orderby, $order);
$tmp_module_header .= thorderby('moduleenabled', 'Enabled', $orderby, $order);
//$tmp_module_header .= thorderby('moduledefaultenabled', 'Default Enabled', $orderby, $order);
$tmp_module_header .= "<td align='right' width='42'>\n";
$tmp_module_header .= "\t<a href='v_modules_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
$tmp_module_header .= "</td>\n";
$tmp_module_header .= "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    $prevmodulecat = '';
    foreach ($result as $row) {
        if ($prevmodulecat != $row[modulecat]) {
            $c = 0;
            if (strlen($prevmodulecat) > 0) {
                echo "<tr>\n";

Example #5

0

Show file

File: v_hardware_phones.php Project: petekelly/fusionpbx

$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('phone_mac_address', 'MAC Address', $orderby, $order);
echo thorderby('phone_template', 'Template', $orderby, $order);
echo thorderby('phone_vendor', 'Vendor', $orderby, $order);
//echo thorderby('phone_model', 'Model', $orderby, $order);
echo thorderby('phone_provision_enable', 'Enabled', $orderby, $order);
echo thorderby('phone_description', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_hardware_phones_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//echo "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='v_hardware_phones_edit.php'\" value='+'>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[phone_mac_address] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[phone_template] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[phone_vendor] . "&nbsp;</td>\n";

Example #6

0

Show file

File: v_ivr_menu.php Project: petekelly/fusionpbx

$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('ivr_menu_name', 'Name', $orderby, $order);
echo thorderby('ivr_menu_extension', 'Extension', $orderby, $order);
echo thorderby('ivr_menu_direct_dial', 'Direct Dial', $orderby, $order);
echo thorderby('ivr_menu_enabled', 'Enabled', $orderby, $order);
echo thorderby('ivr_menu_desc', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_ivr_menu_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//echo "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='v_ivr_menu_edit.php'\" value='+'>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[ivr_menu_name] . "</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[ivr_menu_extension] . "</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[ivr_menu_direct_dial] . "</td>\n";

Example #7

0

Show file

File: v_hunt_group.php Project: petekelly/fusionpbx

$sql .= " limit {$rowsperpage} offset {$offset} ";
$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
//echo "<tr><td colspan='3'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>";
echo "<tr>\n";
echo thorderby('huntgroupextension', 'Extension', $orderby, $order);
echo thorderby('huntgroupname', 'Hunt Group Name', $orderby, $order);
echo thorderby('huntgroupdescr', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_hunt_group_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
echo "</td>\n";
echo "<tr>\n";
//echo "<tr><td colspan='3'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[huntgroupextension] . "</td>\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[huntgroupname] . "</td>\n";
        echo "   <td valign='top' class='rowstylebg' width='40%'>" . $row[huntgroupdescr] . "&nbsp;</td>\n";

Example #8

0

Show file

File: v_php_service.php Project: petekelly/fusionpbx

$sql .= " limit {$rowsperpage} offset {$offset} ";
$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('service_name', 'Name', $orderby, $order);
//echo thorderby('service_group', 'Group', $orderby, $order);
echo thorderby('service_enabled', 'Enabled', $orderby, $order);
echo thorderby('service_description', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_php_service_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//echo "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='v_php_service_edit.php'\" value='+'>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[service_name] . "</td>\n";
        //echo "	<td valign='top' class='".$rowstyle[$c]."'>".$row[service_group]."</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[service_enabled] . "</td>\n";

Example #9

0

Show file

File: v_fax.php Project: petekelly/fusionpbx

$sql .= " limit {$rowsperpage} offset {$offset} ";
$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('faxextension', 'Extension', $orderby, $order);
echo thorderby('faxname', 'Name', $orderby, $order);
echo thorderby('faxemail', 'Email', $orderby, $order);
echo thorderby('faxdescription', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_fax_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[faxextension] . "</td>\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[faxname] . "</td>\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[faxemail] . "&nbsp;</td>\n";
        echo "   <td valign='top' class='rowstylebg' width='35%'>" . $row[faxdescription] . "</td>\n";

Example #10

0

Show file

File: v_settings.php Project: petekelly/fusionpbx

$sql .= " limit {$rowsperpage} offset {$offset} ";
$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('numbering_plan', 'Numbering Plan', $orderby, $order);
echo thorderby('default_gateway', 'Default Gateway', $orderby, $order);
echo thorderby('default_area_code', 'Default Area Code', $orderby, $order);
echo thorderby('smtphost', 'SMTP Host', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t\t<a href='v_settings_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[numbering_plan] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[default_gateway] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[default_area_code] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[smtphost] . "&nbsp;</td>\n";

Example #11

0

Show file

File: v_system_settings.php Project: petekelly/fusionpbx

$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
//echo "<tr><td colspan='5'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>";
echo "<tr>\n";
echo thorderby('v_domain', 'Domain', $orderby, $order);
//echo thorderby('v_package_version', 'Package Version', $orderby, $order);
echo thorderby('v_label', 'Label', $orderby, $order);
//echo thorderby('v_name', 'Name', $orderby, $order);
echo thorderby('v_dir', 'Directory', $orderby, $order);
echo thorderby('v_web_dir', 'Web Directory', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t\t\t<a href='v_system_settings_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
echo "</td>\n";
echo "<tr>\n";
//echo "<tr><td colspan='5'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[v_domain] . "</td>\n";
        //echo "   <td valign='top' class='".$rowstyle[$c]."'>".$row[v_package_version]."</td>\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[v_label] . "</td>\n";

Example #12

0

Show file

File: v_voicemail_msgs.php Project: petekelly/fusionpbx

 echo "\t<input type='button' class='btn' name='' alt='add' onclick=\"window.location='v_voicemail_msgs_password.php?id=" . $value['extension_id'] . "'\" value='settings'>\n";
 echo "</td>\n";
 echo "</tr>\n";
 $tmp_msg_header = '';
 $tmp_msg_header .= "<tr>\n";
 $tmp_msg_header .= thorderby('created_epoch', 'Created', $orderby, $order);
 //$tmp_msg_header .= thorderby('read_epoch', 'Read', $orderby, $order);
 //$tmp_msg_header .= thorderby('username', 'Ext', $orderby, $order);
 //$tmp_msg_header .= thorderby('domain', 'Domain', $orderby, $order);
 //$tmp_msg_header .= thorderby('uuid', 'UUID', $orderby, $order);
 $tmp_msg_header .= thorderby('cid_name', 'Caller ID Name', $orderby, $order);
 $tmp_msg_header .= thorderby('cid_number', 'Caller ID Number', $orderby, $order);
 $tmp_msg_header .= thorderby('in_folder', 'Folder', $orderby, $order);
 //$tmp_msg_header .= "<th>Options</th>\n";
 //$tmp_msg_header .= thorderby('file_path', 'File Path', $orderby, $order);
 $tmp_msg_header .= thorderby('message_len', 'Length (play)', $orderby, $order);
 $tmp_msg_header .= "<th nowrap>Size (download)</th>\n";
 //$tmp_msg_header .= thorderby('flags', 'Flags', $orderby, $order);
 //$tmp_msg_header .= thorderby('read_flags', 'Read Flags', $orderby, $order);
 $tmp_msg_header .= "<td align='right' width='22'>\n";
 //$tmp_msg_header .= "  <input type='button' class='btn' name='' alt='add' onclick=\"window.location='voicemail_msgs_edit.php'\" value='+'>\n";
 $tmp_msg_header .= "</td>\n";
 $tmp_msg_header .= "<tr>\n";
 echo $tmp_msg_header;
 //$sql = "";
 //$sql .= " select * from voicemail_msgs ";
 //if (strlen($orderby)> 0) { $sql .= "order by $orderby $order "; }
 //$prepstatement = $db->prepare(check_sql($sql));
 //$prepstatement->execute();
 //$result = $prepstatement->fetchAll();
 //$numrows = count($result);

Example #13

0

Show file

File: v_call_broadcast.php Project: petekelly/fusionpbx

}
$sql .= " limit {$rowsperpage} offset {$offset} ";
$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('broadcast_name', 'Name', $orderby, $order);
echo thorderby('broadcast_concurrent_limit', 'Concurrent Limit', $orderby, $order);
echo thorderby('broadcast_desc', 'Description', $orderby, $order);
//echo thorderby('recordingid', 'Recording', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_call_broadcast_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//echo "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='v_call_broadcast_edit.php'\" value='+'>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[broadcast_name] . "&nbsp;</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[broadcast_concurrent_limit] . "&nbsp;</td>\n";

Example #14

0

Show file

File: users.php Project: petekelly/fusionpbx

$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo thorderby('username', 'Username', $orderby, $order);
echo thorderby('usertype', 'Type', $orderby, $order);
echo thorderby('usercategory', 'Category', $orderby, $order);
echo thorderby('userfirstname', 'First Name', $orderby, $order);
echo thorderby('userlastname', 'Last Name', $orderby, $order);
echo thorderby('usercompanyname', 'Organization', $orderby, $order);
echo thorderby('userphone1', 'Phone', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='users_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//echo "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='users_edit.php'\" value='+'>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        if (strlen($row[username]) == 0) {
            echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>contact&nbsp;</td>\n";
        } else {

Example #15

0

Show file

File: v_vars.php Project: petekelly/fusionpbx

$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
$tmp_var_header = '';
$tmp_var_header .= "<tr>\n";
$tmp_var_header .= thorderby('var_name', 'Name', $orderby, $order);
$tmp_var_header .= thorderby('var_value', 'Value', $orderby, $order);
//$tmp_var_header .= thorderby('var_cat', 'Category', $orderby, $order);
//$tmp_var_header .= thorderby('var_order', 'Order', $orderby, $order);
$tmp_var_header .= thorderby('var_enabled', 'Enabled', $orderby, $order);
$tmp_var_header .= "<th>Description</th>\n";
$tmp_var_header .= "<td align='right' width='42'>\n";
$tmp_var_header .= "\t<a href='v_vars_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
//$tmp_var_header .= "	<input type='button' class='btn' name='' alt='add' onclick=\"window.location='v_vars_edit.php'\" value='+'>\n";
$tmp_var_header .= "</td>\n";
$tmp_var_header .= "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    $prev_var_cat = '';
    foreach ($result as $row) {
        if ($prev_var_cat != $row[var_cat]) {
            $c = 0;
            if (strlen($prev_var_cat) > 0) {

Example #16

0

Show file

File: v_cdr.php Project: petekelly/fusionpbx

    echo "<td colspan='2' align='right'>\n";
    //echo "	<input type='button' class='btn' name='' alt='view' onclick=\"window.location='v_cdr_search.php'\" value='advanced'>\n";
    echo "</td>\n";
    echo "<td colspan='1' align='right'>\n";
    echo "\t<input type='button' class='btn' name='' alt='view' onclick=\"window.location='v_cdr_search.php'\" value='advanced'>&nbsp;\n";
    echo "\t<input type='submit' class='btn' name='submit' value='filter'>\n";
    echo "</td>\n";
    echo "</tr>";
    echo "</table>";
    echo "</form>";
}
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
echo "<tr>\n";
echo "<th>Start</th>\n";
//echo thorderby('start_stamp', 'Start', $orderby, $order);
echo thorderby('caller_id_name', 'CID Name', $orderby, $order);
echo "<th>Source</th>\n";
//echo thorderby('caller_id_number', 'Source', $orderby, $order);
echo "<th>Destination</th>\n";
//echo thorderby('destination_number', 'Destination', $orderby, $order);
//echo thorderby('context', 'Context', $orderby, $order);
//echo thorderby('answer_stamp', 'Answer', $orderby, $order);
//echo thorderby('end_stamp', 'End', $orderby, $order);
echo "<th>Duration</th>\n";
//echo thorderby('duration', 'Duration', $orderby, $order);
echo "<th>Bill</th>\n";
//echo thorderby('billsec', 'Bill', $orderby, $order);
echo "<th>Status</th>\n";
//echo thorderby('hangup_cause', 'Status', $orderby, $order);
echo "<form method='post' action='v_cdr_csv.php'>";
echo "<td align='left' width='22'>\n";

Example #17

0

Show file

File: v_public_includes.php Project: petekelly/fusionpbx

$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
//echo "<tr><td colspan='4'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>";
echo "<tr>\n";
echo thorderby('extensionname', 'Extension Name', $orderby, $order);
echo thorderby('publicorder', 'Order', $orderby, $order);
echo thorderby('enabled', 'Enabled', $orderby, $order);
echo thorderby('descr', 'Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_public_includes_add.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
echo "</td>\n";
echo "<tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>&nbsp;&nbsp;" . $row[extensionname] . "</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>&nbsp;&nbsp;" . $row[publicorder] . "</td>\n";
        echo "\t<td valign='top' class='" . $rowstyle[$c] . "'>&nbsp;&nbsp;" . $row[enabled] . "</td>\n";
        echo "\t<td valign='top' class='rowstylebg' width='35%'>&nbsp;&nbsp;" . $row[descr] . "</td>\n";

Example #18

0

Show file

File: rsslist.php Project: petekelly/fusionpbx

$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='left'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
//echo "<tr><td colspan='100%'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>";
if ($resultcount == 0) {
    //no results
    echo "<tr><td>&nbsp;</td></tr>";
} else {
    //received results
    echo "<tr>";
    echo thorderby('rsstitle', 'Title', $orderby, $order);
    echo thorderby('rsslink', 'Link', $orderby, $order);
    echo thorderby('rsssubcategory', 'Template', $orderby, $order);
    echo thorderby('rssgroup', 'Group', $orderby, $order);
    echo thorderby('rssorder', 'Order', $orderby, $order);
    echo "<td align='right' width='42'>\n";
    echo "\t<a href='rssadd.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
    echo "</td>\n";
    echo "</tr>";
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr style='" . $rowstyle[$c] . "'>\n";
        //echo "<td valign='top'><a href='rssupdate.php?rssid=".$row[rssid]."'>".$row[rssid]."</a></td>";
        //echo "<td valign='top'>".$row[rsscategory]."</td>";
        echo "<td valign='top' nowrap class='" . $rowstyle[$c] . "'>&nbsp;" . $row[rsstitle] . "&nbsp;</td>";
        echo "<td valign='top' nowrap class='" . $rowstyle[$c] . "'>&nbsp;<a href='/index.php?c=" . $row[rsslink] . "'>" . $row[rsslink] . "</a>&nbsp;</td>";
        echo "<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[rsssubcategory] . "&nbsp;</td>";
        if (strlen($row[rssgroup]) > 0) {
            echo "<td valign='top' class='" . $rowstyle[$c] . "'>" . $row[rssgroup] . "</td>";
        } else {

Example #19

0

Show file

File: v_gateways.php Project: petekelly/fusionpbx

$prepstatement = $db->prepare(check_sql($sql));
$prepstatement->execute();
$result = $prepstatement->fetchAll();
$resultcount = count($result);
unset($prepstatement, $sql);
$c = 0;
$rowstyle["0"] = "rowstyle0";
$rowstyle["1"] = "rowstyle1";
echo "<div align='center'>\n";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='0'>\n";
//echo "<tr><td colspan='4'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>";
echo "<tr>\n";
echo thorderby('gateway', 'Gateway', $orderby, $order);
echo thorderby('context', 'Context', $orderby, $order);
echo thorderby('enabled', 'Enabled', $orderby, $order);
echo thorderby('description', 'Gateway Description', $orderby, $order);
echo "<td align='right' width='42'>\n";
echo "\t<a href='v_gateways_edit.php' alt='add'><img src='" . $v_icon_add . "' width='17' height='17' border='0' alt='add'></a>\n";
echo "</td>\n";
echo "<tr>\n";
//echo "<tr><td colspan='4'><img src='/images/spacer.gif' width='100%' height='1' style='background-color: #BBBBBB;'></td></tr>\n";
if ($resultcount == 0) {
    //no results
} else {
    //received results
    foreach ($result as $row) {
        //print_r( $row );
        echo "<tr >\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[gateway] . "</td>\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[context] . "</td>\n";
        echo "   <td valign='top' class='" . $rowstyle[$c] . "'>" . $row[enabled] . "</td>\n";

PHP thorderby Examples