Build Powerful PHP Applications 10x Faster

<?php
require('wtk/wtkLogin.php');
// Example: Create an interactive data table with sorting and totaling

// 1. Define your SQL query of data to display
$pgSQL =<<<SQLVAR
SELECT `UID`, `OrigFileName`, `FileSize`, `Redacted`
  FROM `wtkFiles`
WHERE `FileExtension` > :FileExtension
ORDER BY `UID` DESC
SQLVAR;

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

// 2. Set optional features and change default parameters
// use wtkSetHeaderSort to determine which columns are sortable
wtkSetHeaderSort('OrigFileName');
wtkSetHeaderSort('FileSize');

$gloShowExport = true; // usually set globally but can override as-needed
$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'
);

$pgList = wtkBuildDataBrowse($pgSQL, $pgSqlFilter); // generate List HTML

// 3. HTML Structure - add whatever header and page-specific structure needed
$pgHtm =<<<htmVAR
<div class="container">
    <h4>File List</h4>
    <div class="wtk-list card b-shadow">
        $pgList
    </div>
</div>
htmVAR;

// 4. insert into main website template and echo
wtkMergePage($pgHtm, $gloCoName, 'wtk/htm/mpa.htm');
?>

<?php
require('wtk/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('wtk/wtkLogin.php');
// Example: Send order confirmation email

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

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

// Send confirmation email to customer
wtkNotifyViaEmail('Order Confirmation', $pgEmailBody, '[email protected]');

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

<?php
$gloLoginRequired = false;
require('wtk/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');
?>