コード例 #1
0
ファイル: showall.php プロジェクト: ghyousu/nailpointsystem
function showSummary($query)
{
    global $db_conn;
    print '<table align="center" border="1">';
    // print table column headers
    $tableHeaders = array("id", "Name", "Phone #", "Email", "Points", "Details");
    writeTableHeader($tableHeaders);
    // retrieve all data from the database to be displayed
    $result = $db_conn->query($query);
    if ($result == true) {
        $result->data_seek(0);
        while ($row = $result->fetch_assoc()) {
            $id = $row[tcCustomer::$custIdStr];
            $fname = $row[tcCustomer::$fnameStr];
            $lname = $row[tcCustomer::$lnameStr];
            $phone = $row[tcCustomer::$phoneStr];
            $email = $row[tcCustomer::$emailStr];
            $totalPtrs = tcVisits::getTotalPointsById($db_conn, $id);
            writeTRBegin();
            writeTD('<a href="' . 'editcustomer.php?custId=' . $id . '">' . $id . '</a>');
            writeTDArray(array("{$fname} {$lname}", $phone, $email));
            writeTD($totalPtrs, "right");
            writeTD('<a href="' . 'showdetails.php?custId=' . $id . '">Details</a>');
            writeTREnd();
        }
        $result->free();
    } else {
        exit("Unable to access the database.");
    }
    print "</table>";
}
コード例 #2
0
 public function showDetailTable()
 {
     print '<table align="center" border="1">';
     // write the table header information
     writeTableHeader(array("Name", "Phone", "Email", "Date", "Points"));
     // write the table row to the web page
     writeTRBegin();
     writeTDArray(array("{$this->fname}  {$this->lname}", $this->phone, $this->email));
     print '<td colspan=2></td>';
     writeTREnd();
     $visits = new tcVisits($this->custId, $this->db_conn);
     $visits->initVisits();
     $numVisits = count($visits->visits);
     // NOTE: rowspan number has to plus 2 for unknown reason
     print '<td colspan=3 rowspan=' . ($numVisits + 2) . '></td>';
     for ($i = 0; $i < $numVisits; ++$i) {
         writeTRBegin();
         writeTD($visits->visits[$i]->dtime);
         writeTD($visits->visits[$i]->point, "right");
         writeTREnd();
     }
     $totalPtrs = tcVisits::getTotalPointsById($this->db_conn, $this->custId);
     writeTRBegin();
     writeTD("Balance:");
     writeTD($totalPtrs, "right");
     writeTREnd();
     print '</table>';
 }
コード例 #3
0
ファイル: util.php プロジェクト: BackupTheBerlios/infobasar
function wikiToHtml(&$session, $wiki_text)
{
    $lines = explode("\n", $wiki_text);
    $session->trace(TC_Util1, 'wikiToHtml: ' . (0 + count($lines)) . ' Zeilen' . "({$lines['0']})");
    $status = new LayoutStatus($session);
    foreach ($lines as $ii => $line) {
        if (($line_trimmed = trim($line)) == '') {
            writeParagraphEnd($status);
        } else {
            #$session->trace (TC_X, "Neue Zeile: '$line_trimmed' $line]");
            if ($line_trimmed == '[code]') {
                $session->startCode();
            } elseif ($line_trimmed == '[/code]') {
                $session->finishCode();
            } elseif ($session->fPreformated) {
                echo htmlentities($line);
            } else {
                switch (substr($line, 0, 1)) {
                    case '!':
                        if (substr($line, 1, 1) == '|') {
                            writeTableHeader($line, $status);
                        } else {
                            writeHeader($line, $status);
                        }
                        break;
                    case ' ':
                        writeLine($line, $status);
                        break;
                        # writeIndent ($line, $status); break;
                    # writeIndent ($line, $status); break;
                    case '*':
                        writeUList($line, $status);
                        break;
                    case '#':
                        writeOrderedList($line, $status);
                        break;
                    case '|':
                        writeTable($line, $status);
                        break;
                    case '-':
                        writeHoricontalLine($line, $status);
                        break;
                    default:
                        writeLine($line, $status);
                        break;
                }
            }
        }
    }
    // foreach
    $session->trace(TC_Util1, 'wikiToHtml-Ende');
}
コード例 #4
0
ファイル: util.php プロジェクト: BackupTheBerlios/infobasar
function wikiToHtml(&$session, $wiki_text)
{
    $lines = explode("\n", $wiki_text);
    $session->trace(TC_Util1, 'wikiToHtml: ' . (0 + count($lines)) . ' Zeilen' . "({$lines['0']})");
    $status = new LayoutStatus($session);
    $last_linetype = '';
    foreach ($lines as $ii => $line) {
        $start_code = false;
        if (!$status->fPreformatted && ($line_trimmed = trim($line)) == '') {
            $last_linetype = '';
            $status->changeOfLineType($last_linetype, '');
        } else {
            $linetype = $status->fPreformatted ? '[' : substr($line, 0, 1);
            switch ($linetype) {
                case '-':
                    $count = countRepeats($line, '-');
                    if ($count < 4) {
                        $linetype = 'x';
                    }
                    break;
                case '[':
                    if (strpos($line, 'code]') == 1) {
                        $start_code = true;
                    } elseif (strpos($line, '/code]') == 1) {
                        $status->finishCode();
                        $last_linetype = 'x';
                        $line = $line_trimmed = substr($line, 7);
                        $session->trace(TC_Util2, 'wikiToHtml: /code-Restzeile: ' . $line);
                    } else {
                        $linetype = 'x';
                    }
                    break;
                case '!':
                case ';':
                case '*':
                case '#':
                case '|':
                    break;
                default:
                    $linetype = 'x';
                    break;
            }
            $last_linetype = $status->testChangeOfLineType($last_linetype, $linetype);
            switch ($linetype) {
                case '!':
                    if (strpos($line, '|') != 1) {
                        writeHeader($line, $status);
                    } else {
                        writeTableHeader($line, $status);
                        $last_linetype = '|';
                    }
                    break;
                case '[':
                    if ($start_code) {
                        $status->startCode();
                    }
                    $line = substr($line_trimmed, 6);
                    if (!empty($line)) {
                        writeLine($line, $status);
                    }
                    break;
                case ';':
                    writeIndent($line, $status);
                    break;
                case '*':
                    writeUList($line, $status);
                    break;
                case '#':
                    writeOrderedList($line, $status);
                    break;
                case '|':
                    writeTable($line, $status);
                    break;
                case '-':
                    guiLine($status->fSession, $count - 3);
                    break;
                default:
                    writeLine($line, $status);
                    break;
            }
        }
    }
    // foreach
    if ($status->fPreformatted) {
        $session->trace(TC_Warning, PREFIX_Warning . '[/code] fehlt');
    }
    $session->trace(TC_Util1, 'wikiToHtml-Ende');
}