Build Powerful PHP Applications 10x Faster

<?php
require('wtkLogin.php');

// Example: Create an interactive data table with CRUD features

// 1. Define your SQL query and create the data browse table
$pgSQL =<<<SQLVAR
SELECT `UID`, `OrigFileName`, `FileSize`, `Redacted`
  FROM `wtkFiles`
WHERE `FileExtension` > :FileExtension
ORDER BY `UID` DESC
SQLVAR;

$pgSqlFilter = array(
    'FileExtension' => 'png'
);

// choose which columns to sort simply by calling wtkSetHeaderSort
wtkSetHeaderSort('OrigFileName');
wtkSetHeaderSort('FileSize');

$gloShowExport = true;
$gloRowsPerPage = 25; // defaults to 20

$gloColumnAlignArray = array (
    'FileSize' => 'right',
    'Redacted' => 'center'
);

// add name of column(s) that you want totalled
// Use 'SUM' to sum it and 'DSUM' to sum it and display as currency
$gloTotalArray = array (
    'FileSize' => 'SUM'
);

$pgFileList = wtkBuildDataBrowse($pgSQL, $pgSqlFilter);

// 2. HTML Structure - Place this in your page where you want the table to appear
?>

<!-- HTML Structure -->
<div class="card">
    <div class="card-content">
        <h4>>File List</h4>
        <div>
            <?php
            // 3. Output the table in your desired location
            echo $pgFileList;
            ?>
        </div>
    </div>
</div>

<?php
require('wtkLogin.php');

// Example: Add a note about a User
$pgNote = 'Note: ' . wtkGetParam('note') . '; IP Address: ' . wtkGetIPaddress();

// Prepare SQL query using heredoc syntax
$pgSQL = <<<SQLVAR
INSERT INTO `wtkUserNote` (`AddedByUserUID`,`UserUID`,`SecurityLevel`,`Notes`)
 VALUES (:AddedByUserUID, :UserUID, :SecurityLevel, :Notes)
SQLVAR;

// Bind parameters for safe SQL execution
$pgSqlFilter = array(
    'AddedByUserUID' => $gloUserUID,
    'UserUID' => $gloId,
    'SecurityLevel' => 20,
    'Notes' => $pgNote
);

// Execute the query using the wtkSqlExec helper
wtkSqlExec($pgSQL, $pgSqlFilter);

echo '{"result":"ok"}'; // Return success response
?>

<?php
require('wtkLogin.php');

// Example: Send order confirmation email

// Define order details array with sample data
$orderDetails = [
    'orderNumber' => 'ORD-2024-001',
    'amount' => 299.99,
    'items' => ['Business Plan Pro', 'Analytics Add-on']
];

// Build email message body with order information
$emailBody = "Thank you for your order #{$orderDetails['orderNumber']}!\n\n";
$emailBody .= "Order Details:\n";
$emailBody .= "Amount: $" . number_format($orderDetails['amount'], 2) . "\n";
$emailBody .= "Items: " . implode(', ', $orderDetails['items']);

// Send confirmation email to customer
wtkNotifyViaEmail('Order Confirmation', $emailBody, 'example@example.com');

$pgPhone = wtkGetParam('SmsPhone');
// phone #, msg, title for analytics, FromUserUID, ToUserUID
wtkSendSMS($pgPhone, 'check your email!','SMS', $gloUserUID, $gloId);

?>

<?php
$gloLoginRequired = false;
require('wtkLogin.php');

// Prepare SQL query using heredoc syntax
$pgSQL = <<<SQLVAR
SELECT CONCAT(wu.`FirstName`, ' ', COALESCE(wu.`LastName`,'')) AS `User`,
   (SELECT COUNT(L.`UID`) FROM `wtkLoginLog` L WHERE  L.`UserUID` = wu.`UID`) AS `Logins`,
   COUNT(h.`UID`) AS `PageViews`,
   (SELECT COUNT(r.`UID`) FROM `wtkReportCntr` r WHERE  r.`UserUID` = wu.`UID`) AS `ReportViews`,
   (SELECT COUNT(u.`UID`) FROM `wtkUpdateLog` u WHERE  u.`UserUID` = wu.`UID`) AS `Updates`
 FROM `wtkUsers` wu
   INNER JOIN `wtkUserHistory` h ON h.`UserUID` = wu.`UID`
 WHERE wu.`DelDate` IS NULL
 GROUP BY wu.`UID`
ORDER BY COUNT(h.`UID`) DESC, wu.`FirstName` ASC
SQLVAR;

$gloColumnAlignArray = array (
    'Logins' => 'right',
    'PageViews' => 'right',
    'ReportViews' => 'right',
	'Updates' => 'right'
);
// Single line call to generate multiple charts for a single set of data
// $pgHtm = wtkRptChart($pgSQL, []); // will show all graph types

$pgChartOps = array('regRpt','bar','pie','line','area');
$pgHtm = wtkRptChart($pgSQL, [], $pgChartOps); // choose which graph types to show

wtkMergePage($pgHtm, $gloCoName, '../wtk/htm/mpa.htm');
?>