[phpshop commit] r41 - trunk/phpshop1/WEB-INF/modules/ticket/html

1 view
Skip to first unread message

codesite...@google.com

unread,
Oct 16, 2008, 4:46:44 AM10/16/08
to phpsh...@googlegroups.com
Author: ulisoft
Date: Thu Oct 16 01:16:18 2008
New Revision: 41

Added:
trunk/phpshop1/WEB-INF/modules/ticket/html/answer_print.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/index.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/menu.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_answer.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_list.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_print.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_status_form.ihtml
trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_status_list.ihtml

Log:
see http://code.google.com/p/phpshop/wiki/phpShop1_update -
Updating phpShop 0.81 - adding the ticket module -

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/answer_print.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/answer_print.ihtml Thu Oct
16 01:16:18 2008
@@ -0,0 +1,132 @@
+<?php
+if (!$answer_id) {
+ $answer_id = $vars["answer_id"];
+}
+
+$q = "SELECT
answer_id,ticket_id,answer_subject,answer_content,answer_status,ticket_answer.cdate,ticket_answer.user_id,ticket_answer.vendor_id,";
+$q .= "ticket_status_id,ticket_status_name,ticket_status.language,ticket_status.vendor_id,";
+$q .= "user_info.user_id,address_type,first_name,last_name ";
+$q .= "FROM ticket_answer,ticket_status,user_info WHERE ";
+$q .= "answer_id='$answer_id' ";
+$q .= "AND answer_status=ticket_status_id ";
+$q .= "AND ticket_status.language='$lang' ";
+$q .= "AND ticket_status.vendor_id='$ps_vendor_id' ";
+$q .= "AND ticket_status.vendor_id=ticket_answer.vendor_id ";
+$q .= "AND ticket_answer.user_id=user_info.user_id ";
+$q .= "AND address_type='BT'";
+$db->query($q);
+
+if ($db->next_record()) {
+ ?>
+
+<TABLE WIDTH=100% ALIGN=CENTER BORDER=0 CELLSPACING=0 CELLPADDING=10>
+ <TR BGCOLOR=<?php echo $leftbar_title_bgcolor?>>
+ <TD COLSPAN=2>
+ <H3>Antwort</H3>
+ </TD>
+ </TR>
+</TABLE>
+
+<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH=100%>
+
+ <!-- Begin answer Information -->
+ <TR BGCOLOR=#FFcc00>
+ <TD COLSPAN=2><B><?php echo $reply_info_str ?></B></TD>
+ </TR>
+ <TR>
+ <TD><?php echo $answer_id_str ?>:</TD>
+ <TD><?php echo $db->f("answer_id"); ?></TD>
+ </TR>
+ <TR>
+ <TD><?php echo $reply_list_cdate ?>:</TD>
+ <TD><?php echo date("d-M-Y H:i", $db->f("cdate")); ?></TD>
+ </TR>
+ <TR>
+ <TD><?php echo $ticket_list_id ?>:</TD>
+ <TD><?php
+ $ticket_id=$db->f("ticket_id");
+ $url = SECUREURL . "?page=$modulename/ticket_print&ticket_id=";
+ $url .= $ticket_id;
+ echo "<A class=\"bLink\"
HREF=".$sess->url($url).">$ticket_id</A><BR>";
+ ?></TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $ftp_list_status ?>:</TD>
+ <TD><?php echo $db->f("ticket_status_name") ?>
+ </TD>
+ </TR>
+
+ <TR>
+ <TD>von:</TD>
+
+
+ <TD><?php
+ $un=$db->f("first_name");
+ $un .=" ";
+ $un .=$db->f("last_name");
+ echo $un;
+ ?>
+
+ </TD>
+ </TR>
+ <!-- End Ticket Information --> <!-- Begin 2 column answer-content -->
+
+ <TR BGCOLOR=#FFcc00>
+ <TD COLSPAN=2><B><?php echo $ticket_msg_lbl ?>:</B></TD>
+ </TR>
+ <TR VALIGN=top>
+ <TD WIDTH=50%> <!-- Begin TicketContent -->
+
+ <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=2 BORDER=0>
+ <TR>
+ <TD COLSPAN=2><B><?php echo $subject_lbl ?>:</B><BR>
+ <?php echo $db->f("answer_subject"); ?></TD>
+ </TR><br>
+ <TR>
+ <TD><B><?php echo $ticket_msg_txt_lbl ?>:</B><BR>
+ <?php echo $db->f("answer_content"); ?></TD>
+ </TR>
+
+
+ </TABLE>
+
+ <!-- End TicketContent --> </TD>
+
+ <TD WIDTH=50%>
+ <!-- End Ticket Information --> </TD>
+
+ </TR>
+<tr>
+<td>
+<?php
+$ticket_id=$db->f("ticket_id");
+$url = SECUREURL . "?page=$modulename/answer_mail&ticket_id=";
+$url .= $ticket_id;
+echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B>$reply_str
(E-Mail)</B></A><BR>";
+
+$url = SECUREURL . "?page=$modulename/ticket_answer&ticket_id=";
+$url .= $ticket_id;
+echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B>$reply_str
(DB)</B></A><BR>";
+
+?>
+
+</td>
+ <tr>
+ <td>
+ </tr>
+ </table>
+
+ <?php
+
+ $q = "UPDATE ticket_answer SET ";
+ $q .= "answer_view= 1";
+ $q .= " WHERE answer_id='$answer_id'";
+ $db->query($q);
+ $db->next_record();
+}
+?>
+
+<br>
+<!-- Body ends here -->
+

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/index.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/index.ihtml Thu Oct 16
01:16:18 2008
@@ -0,0 +1,3 @@
+<h1><?php echo $module[$modulename]["title"] ?></h1>
+
+<p><?php echo $module_description ?></p>
\ No newline at end of file

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/menu.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/menu.ihtml Thu Oct 16
01:16:18 2008
@@ -0,0 +1,4 @@
+<li><A HREF="<?php
$sess->purl(SECUREURL . "?page=ticket/ticket_list") ?>"><?php echo
$ticket_list_lbl ?></A></li>
+<li><A HREF="<?php
$sess->purl(SECUREURL . "?page=ticket/ticket_status_list") ?>"><?php echo
$ticket_status_list_mnu ?></A></li>
+<li><A HREF="<?php
$sess->purl(SECUREURL . "?page=ticket/ticket_status_form") ?>"><?php echo
$ticket_status_form_mnu ?></A></li>
+<li><A HREF="<?php
$sess->purl(SECUREURL . "?page=ticket/answer_list") ?>"><?php echo
$reply_list_mnu ?></A></li>
\ No newline at end of file

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_answer.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_answer.ihtml Thu Oct
16 01:16:18 2008
@@ -0,0 +1,32 @@
+<?php
+
+ $q="SELECT * FROM tickets WHERE ticket_id ='$ticket_id'";
+ $q .= "AND vendor_id='$ps_vendor_id'";
+ $db->query($q);
+ $db->next_record();
+ $userid=$db->f("user_id");
+
+ $q="SELECT * FROM user_info WHERE user_id ='$userid'";
+ $db->query($q);
+ $db->next_record();
+
+ $to_name=$db->f("first_name");
+ $to_name .=" ";
+ $to_name .=$db->f("last_name");
+?>
+
+<FORM METHOD="post" ACTION="<?php $sess->purl(SECUREURL) ?>">
+<input type=HIDDEN name=page value="ticket/ticket_answer&$ticket_id">
+<input type=HIDDEN name=func value="ticket_answer">
+
+<?php echo "$shopper_form_first_name $shopper_form_last_name" ?><br>
+<INPUT TYPE="text" NAME="to_name" SIZE="30" value="<?php echo
$to_name ?>"><br>
+<?php echo $subject_lbl ?><br>
+<INPUT TYPE="text" NAME="info_subject" SIZE="30" value="Ticket-Info <?php
echo $ticket_id ?>"><br>
+
+<?php echo $ticket_msg_txt_lbl ?><BR>
+<TEXTAREA NAME="info_detail" ROWS="20" COLS="60"></TEXTAREA><P>
+<input type=HIDDEN name=ticket_id value="<?php echo $ticket_id ?>">
+<INPUT TYPE="submit" NAME="send" VALUE="<?php echo $send_lbl ?>">
+<input type=HIDDEN name=page value="ticket/answer_list">
+</FORM>
\ No newline at end of file

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_list.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_list.ihtml Thu Oct 16
01:16:18 2008
@@ -0,0 +1,140 @@
+<?php
+search_header($ticket_list_lbl, $modulename, "ticket_list");
+echo $mail_success
+?>
+
+<center>
+<?php
+if ($vars["ticket_success"]) {
+ echo $vars["ticket_success"];
+}
+
+$navi_db = new ps_DB;
+$q = "SELECT * FROM ticket_status WHERE vendor_id = '$ps_vendor_id' AND
language='$lang' ";
+$navi_db->query($q);
+while ($navi_db->next_record()) {
+ $url = SECUREURL . "?page=$modulename/ticket_list&show=";
+ $url .= $navi_db->f("ticket_status_id");
+ echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B>";
+ echo $navi_db->f("ticket_status_name")."</B></A> | ";
+}
+
+$url = SECUREURL . "?page=$modulename/ticket_list&show=";
+echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B> $show_all_lbl
</B></A><BR>";
+?>
+
+</center><BR>
+
+<?php
+// Enable the multi-page search result display
+if (empty($offset))
+ $offset=0;
+
+if ($keyword) {
+ $list = "SELECT * ";
+ $list .= "FROM tickets WHERE ";
+ $count = "SELECT count(*) as num_rows FROM tickets, user_info,
auth_user_md5 WHERE ";
+ $q = "(tickets.ticket_id LIKE '%$keyword%' ";
+ $q .= "OR tickets.ticket_status LIKE '%$keyword%' ";
+ $q .= "OR tickets.ticket_subject LIKE '%$keyword%' ";
+ $q .= ") ";
+ $q .= "AND tickets.vendor_id='$ps_vendor_id' ";
+ $q .= "ORDER BY tickets.cdate DESC ";
+ $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
+ $count .= $q;
+}
+
+else {
+ $q = "";
+ $list = "SELECT * FROM tickets WHERE ";
+ $count = "SELECT count(*) as num_rows FROM tickets WHERE ";
+ $q .= "tickets.vendor_id='$ps_vendor_id' ";
+ if ($show)
+ $q .= "AND ticket_status = '$show' ";
+ $q .= "ORDER BY tickets.cdate DESC ";
+ $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
+ $count .= $q;
+}
+
+$db->query($count);
+$db->next_record();
+$num_rows = $db->f("num_rows");
+
+if ($num_rows == 0) {
+ echo "$noticket <BR>";
+}
+
+else {
+ ?>
+ <table width="100%" BORDER="1" cellspacing="0" cellpadding="2"
align="center" class="RecordsTable">
+ <tr>
+ <td width="50%" class="RecordsTableHeader"><?php echo
$subject_lbl ?></td>
+ <td width="20%" class="RecordsTableHeader"><?php echo
$ticket_list_cdate ?></td>
+ <td width="10%" class="RecordsTableHeader"><?php echo
$ftp_list_status ?></td>
+ <td width="20%" class="RecordsTableHeader" colspan="2"
align="center"><?php echo $download_list_action ?></td>
+ </tr>
+
+ <?php
+ $db->query($list);
+ $i = 0;
+ while ($db->next_record()) {
+ if ($i++ % 2)
+ $bgcolor=SEARCH_COLOR_1;
+ else
+ $bgcolor=SEARCH_COLOR_2;
+ ?>
+ <tr BGCOLOR=<?php echo $bgcolor ?>>
+ <td width="50%">
+ <?php
+ echo "<A class=\"bLink\" HREF=";
+ echo $sess->url(SECUREURL . "?page=ticket/ticket_print&ticket_id=" .
$db->f("ticket_id")) . ">";
+ echo $db->f("ticket_subject");
+ echo "</A><BR>";
+ ?>
+
+ <td width="20%">
+ <?php echo strftime("%d-%b-%y %H:%M", $db->f("mdate")); ?>
+ </td>
+
+ <?php
+ $q = "SELECT ticket_status FROM tickets WHERE ";
+ $q .= "ticket_id = '" . $db->f("ticket_id") . "'";
+ $dbps = new ps_DB;
+ $dbps->query($q);
+ $dbps->next_record();
+ ?>
+
+ <td width="25%" colspan="2">
+ <form method="post" action="<?php echo SECUREURL ?>">
+ <?php
+ $ps_ticket_status->ticket_status_list($db->f("ticket_status"));
+ $sess->hidden_session();
+ ?>
+ <input type="hidden" name="page" value="ticket/ticket_list">
+ <input type="hidden" name="ticket_id" value="<?php echo
$db->f("ticket_id") ?>">
+ <input type="hidden" name="func" value="ticket_status_set">
+ <input type="submit" name="Submit" value="<?php echo $upd_str ?>">
+ </form>
+ </td>
+
+ <td width="5%">
+ <form method="post" action="<?php echo SECUREURL ?>">
+ <?php
+ $ps_ticket->ticket_delete($db->f("$ticket_id"));
+ $sess->hidden_session();
+ ?>
+ <input type="submit" name="Submit" value="<?php echo $del_str ?>">
+ <input type="hidden" name="page" value="ticket/ticket_list">
+ <input type="hidden" name="func" value="ticket_delete">
+ <input type="hidden" name="ticket_id" value="<?php echo
$db->f("ticket_id")?>">
+ </form>
+ </td>
+ </tr>
+ <?php
+ }
+ ?>
+ </table>
+ <?php
+ search_footer($modulename, "ticket_list", $offset, $num_rows, $keyword);
+}
+?>

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_print.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_print.ihtml Thu Oct
16 01:16:18 2008
@@ -0,0 +1,133 @@
+<?php
+if (!$ticket_id) {
+ $ticket_id = $vars["ticket_id"];
+}
+
+$q = "SELECT
ticket_id,ticket_subject,ticket_content,ticket_status,tickets.cdate,tickets.user_id,tickets.vendor_id,";
+$q .= "ticket_status_id,ticket_status_name,ticket_status.language,ticket_status.vendor_id,";
+$q .= "user_info.user_id,address_type,first_name,last_name ";
+$q .= "FROM tickets,ticket_status,user_info WHERE ";
+$q .= "ticket_id='$ticket_id' ";
+$q .= "AND ticket_status=ticket_status_id ";
+$q .= "AND ticket_status.language='$lang' ";
+$q .= "AND ticket_status.vendor_id='$ps_vendor_id' ";
+$q .= "AND ticket_status.vendor_id=tickets.vendor_id ";
+$q .= "AND tickets.user_id=user_info.user_id ";
+$q .= "AND address_type='BT'";
+$db->query($q);
+
+if ($db->next_record()) {
+ $ticket_status=$db->f("ticket_status");
+ $ticket_content=$db->f("ticket_content");
+ $ticket_subject=$db->f("ticket_subject");
+ $cdate=$db->f("cdate");
+ $un=$db->f("first_name");
+ $un .=" ";
+ $un .=$db->f("last_name");
+ ?>
+ <TABLE WIDTH=100% ALIGN=CENTER BORDER=0 CELLSPACING=0 CELLPADDING=10>
+ <TR BGCOLOR=<?php echo $leftbar_title_bgcolor?>>
+ <TD COLSPAN=2>
+ <H3><?php echo $ticket_print_po_lbl ?></H3>
+ </TD>
+ </TR>
+ </TABLE>
+
+ <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH=100%>
+ <TR BGCOLOR=#FFcc00>
+ <TD COLSPAN="2"><B><?php echo $ticket_info_lbl ?></B>
+ </TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $ticket_list_id ?>:
+ </TD>
+
+ <TD><?php echo $ticket_id ?></TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $ticket_list_cdate ?>:</TD>
+ <TD><?php echo date("d-M-Y H:i", $cdate) ?></TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $ftp_list_status ?>:</TD>
+
+ <TD>
+ <?php
+ echo $db->f("ticket_status_name");
+ ?>
+ </TD>
+ </TR>
+
+ <TR>
+ <TD><?php echo $from_lbl ?>:</TD>
+
+ <TD>
+ <?php echo $un; ?>
+ </TD>
+ </TR>
+ <TR BGCOLOR=#FFcc00>
+ <TD COLSPAN=2><B><?php echo $ticket_msg_lbl ?></B></TD>
+ </TR>
+ <TR VALIGN=top>
+ <TD WIDTH=50%>
+
+ <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=2 BORDER=0>
+ <TR>
+ <TD COLSPAN=2><B><?php echo $subject_lbl ?>:</B><BR>
+ <?php echo $ticket_subject ?></TD>
+ </TR><br>
+ <TR>
+ <TD><B><?php echo $ticket_msg_txt_lbl ?>:</B><BR>
+ <?php echo $ticket_content ?></TD>
+ </TR>
+ </TABLE>
+
+ </TD>
+ </TR>
+
+ <TD WIDTH=50%>
+ <tr>
+ <td>
+
+ <?php
+ $url = SECUREURL . "?page=$modulename/answer_mail&ticket_id=";
+ $url .= $ticket_id;
+ echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B>$reply_str
(E-Mail)</B></A><BR>";
+
+ $url = SECUREURL . "?page=$modulename/ticket_answer&ticket_id=";
+ $url .= $ticket_id;
+ echo "<A class=\"bLink\" HREF=".$sess->url($url)."><B>$reply_str
(DB)</B></A><BR>";
+
+ $q = "SELECT * FROM ticket_answer WHERE ";
+ $q .= "ticket_id = '$ticket_id' ";
+ $q .= "AND vendor_id='$ps_vendor_id'";
+ $db->query($q);
+
+ echo "<B>$answer_title</B><BR>";
+
+ while ($db->next_record()) {
+ $answer_id=$db->f("answer_id");
+ $a_subj=$db->f("answer_subject");
+ $url = SECUREURL . "?page=$modulename/answer_print&answer_id=";
+ $url .= $answer_id;
+ echo "<A class=\"bLink\" HREF=".$sess->url($url).">$a_subj</A><BR>";
+ }
+
+ $q = "UPDATE tickets SET ";
+ $q .= "ticket_view= 1";
+ $q .= " WHERE ticket_id='$ticket_id' ";
+ $q .= "AND vendor_id='$ps_vendor_id'";
+ $db->query($q);
+ $db->next_record();
+ ?>
+ </td>
+ </tr>
+ </table>
+ <?php
+}
+?>
+
+

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_status_form.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_status_form.ihtml Thu
Oct 16 01:16:18 2008
@@ -0,0 +1,72 @@
+<?php
+if ($ticket_status_id) {
+ $q = "SELECT * FROM ticket_status WHERE
ticket_status_id='$ticket_status_id' ";
+ $q .= "AND vendor_id='$ps_vendor_id' AND language='$lang'";
+ $db->query($q);
+ $db->next_record();
+}
+?><BR>
+<form method="post" action="<?php $sess->purl(SECUREURL) ?>">
+ <TABLE WIDTH="80%" BORDER="0" CELLSPACING="0" CELLPADDING="0"
ALIGN="center" class="RecordsTable">
+ <TR>
+ <TD colspan="2" class="RecordsTableHeader">&nbsp;<?php echo
$ticket_status_form_lbl ?></TD>
+ </TR>
+ <TR>
+ <TD><B>&nbsp;<?php echo $ticket_status_form_lbl ?></B></TD>
+ <TD>&nbsp;</TD>
+ </TR>
+ <TR>
+ <TD ALIGN="right" ><?php echo $ticket_s_list_name ?>:</TD>
+ <TD>
+ <INPUT TYPE="text" NAME="ticket_status_name" VALUE="<?php
$db->sp("ticket_status_name") ?>" SIZE="16">
+ </TD>
+ </TR>
+ <TR>
+ <TD ALIGN="right" ><?php echo $all_lang_str ?>:</TD>
+ <TD>
+ <INPUT TYPE="checkbox" NAME="all_lang">
+ </TD>
+ </TR>
+
+ <TR ALIGN="CENTER">
+ <TD COLSPAN="2" >&nbsp;</TD>
+ </TR>
+ <TR ALIGN="CENTER">
+ <TD COLSPAN="2" >
+ <INPUT TYPE="hidden" NAME="ticket_status_id" VALUE="<?php echo
$ticket_status_id ?>">
+ <INPUT TYPE="hidden" NAME="func" VALUE="<?php if
($ticket_status_id) echo "ticket_status_update"; else
echo "ticket_status_add"; ?>">
+ <INPUT TYPE="hidden" NAME="page" VALUE="ticket/ticket_status_list">
+ </TD>
+ </TR>
+ <TR ALIGN="CENTER">
+ <TD COLSPAN="2" ><?php if ($ticket_status_id) { ?>
+ <TABLE WIDTH="50%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
+ <TR ALIGN="center">
+ <TD WIDTH="100%">
+ <input type="submit" class="Button" BORDER="0" value="<?php
echo $save_str ?>">
+ <input type="Button" class="Button" value="<?php echo
$del_str ?>" onClick="return deleteRecord('<?php
$sess->purl(SECUREURL . "?page=ticket/ticket_status_list&func=ticket_status_delete&ticket_status_id=$ticket_status_id"); ?>')">
+ <input type="Button" class="Button" value="<?php echo
$delete_all_str ?>" onClick="return deleteRecord('<?php
$sess->purl(SECUREURL . "?page=ticket/ticket_status_list&func=ticket_status_delete&ticket_status_id=$ticket_status_id&all_lang=on"); ?>')">
+ </TD>
+ </TR>
+
+ <TR ALIGN="center">
+ <TD WIDTH="100%"><BR></td>
+ </tr>
+ </TABLE>
+ <?php }
+else {
+ ?>
+ <TABLE WIDTH="50%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
+ <TR ALIGN="center">
+ <TD WIDTH="100%">
+ <input type="submit" class="Button" BORDER="0" value="<?php
echo $save_str ?>"> <input type="Button" class="Button" value="<?php echo
$reset_lbl ?>" onClick="document.location.href='<?php
$sess->purl(SECUREURL . "?page=ticket/ticket_status_form&ticket_status_id") ?>'">
+ </TD>
+ </TR>
+ <TR ALIGN="center">
+ <TD WIDTH="100%"><BR></td>
+ </tr>
+ </TABLE>
+ <?php } ?></TD>
+ </TR>
+ </TABLE>
+</form>

Added: trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_status_list.ihtml
==============================================================================
--- (empty file)
+++ trunk/phpshop1/WEB-INF/modules/ticket/html/ticket_status_list.ihtml Thu
Oct 16 01:16:18 2008
@@ -0,0 +1,75 @@
+<?php
+search_header($ticket_status_list_mnu, $modulename, "ticket_status_list");
+
+// Enable the multi-page search result display
+if (empty($offset))
+ $offset=0;
+
+if ($keyword) {
+ $list = "SELECT * FROM ticket_status WHERE ";
+ $count = "SELECT count(*) as num_rows FROM ticket_status WHERE ";
+ $q = "(ticket_status_name LIKE '%$keyword%' ";
+ $q .= ") ";
+ $q .= "AND vendor_id='$ps_vendor_id' ";
+ $q .= "AND language='$lang' ";
+ $q .= "ticket BY list_order ASC";
+ $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
+ $count .= $q;
+}
+
+else {
+ $q = "";
+ $list = "SELECT * FROM ticket_status WHERE ";
+ $count = "SELECT count(*) as num_rows FROM ticket_status WHERE ";
+ $q .= "vendor_id='$ps_vendor_id' ";
+ $q .= "AND language='$lang' ";
+ $q .= "ORDER BY ticket_status_name ASC";
+ $list .= $q . " LIMIT $offset, " . SEARCH_ROWS;
+ $count .= $q;
+}
+
+$db->query($count);
+$db->next_record();
+$num_rows = $db->f("num_rows");
+
+if ($num_rows == 0) {
+ echo "-------<BR>";
+}
+
+else {
+ ?>
+ <table width="100%" bticket="0" cellspacing="0" cellpadding="2"
align="center" class="RecordsTable">
+ <tr>
+ <td NOWRAP class="RecordsTableHeader"><?php echo
$ticket_s_list_name ?></td>
+ </tr>
+
+ <?php
+ $db->query($list);
+ $i = 0;
+ while ($db->next_record()) {
+ if ($i++ % 2)
+ $bgcolor=SEARCH_COLOR_1;
+ else
+ $bgcolor=SEARCH_COLOR_2;
+ ?>
+
+ <tr BGCOLOR=<?php echo $bgcolor ?>>
+ <td>
+ <?php
+ $url =
SECUREURL . "?page=$modulename/ticket_status_form&ticket_status_id=";
+ $url .= $db->f("ticket_status_id");
+ echo "<A class=\"bLink\" HREF=" . $sess->url($url) . ">";
+ echo $db->f("ticket_status_name");
+ echo "</A><BR>";
+ ?>
+ </td>
+ </tr>
+ <?php
+ }
+ ?>
+ </table>
+
+ <?php
+ search_footer($modulename, "ticket_status_list", $offset, $num_rows,
$keyword);
+}
+?>

Reply all
Reply to author
Forward
0 new messages