PHP printCenter Examples

Example #1

File: costcenter-rep.php Project: andrecoetzee/accounting-123.com

function export_data($_POST)
{
    extract($_POST);
    require_lib("xls");
    $data = clean_html(printCenter($_POST));
    StreamXLS("costcenter_report", "{$data}");
}

Example #2

File: costcenter-rep-det.php Project: andrecoetzee/accounting-123.com

function export_data($_POST)
{
    require_lib("xls");
    extract($_POST);
    $data = clean_html(printCenter($_POST));
    //$data =get_data($_POST);
    StreamXLS("report", "{$data}");
}

Example #3

File: costcenter-view.php Project: andrecoetzee/accounting-123.com

#The full software license can be found here:
#http://www.accounting-123.com/a.php?a=153/GPLv3
#
#
#
#
#
#
#
#
#
#
#
require "settings.php";
# show current stock
$OUTPUT = printCenter();
$OUTPUT .= "\r\n\t\t\t\t<p>\r\n\t\t\t\t<table border='0' cellpadding='2' cellspacing='1'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='costcenter-add.php'>Add Cost Center</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='costcenter-view.php'>View Cost Centers</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='projects-edit.php'>Manage Project Cost Centers</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t";
require "template.php";
# show stock
function printCenter()
{
    # Set up table to display in
    $printCenter = "\r\n\t\t\t\t<h3>Current Cost Centers</h3>\r\n\t\t\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Cost Center Code</th>\r\n\t\t\t\t\t\t<th>Cost Center Name</th>\r\n\t\t\t\t\t\t<th colspan='2'>Options</th>\r\n\t\t\t\t\t</tr>";
    # connect to database
    db_connect();
    # Query server
    $i = 0;
    $sql = "SELECT * FROM costcenters WHERE div = '" . USER_DIV . "' ORDER BY centername ASC";
    $ccRslt = db_exec($sql) or errDie("Unable to retrieve Cost Centers from database.");
    if (pg_numrows($ccRslt) < 1) {
        return "<li class='err'>There are no Cost Centers in Cubit.</li>";