<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to feature-requests</title><link href="https://sourceforge.net/p/pscafe/feature-requests/" rel="alternate"/><link href="https://sourceforge.net/p/pscafe/feature-requests/feed.atom" rel="self"/><id>https://sourceforge.net/p/pscafe/feature-requests/</id><updated>2010-09-18T03:22:49Z</updated><subtitle>Recent changes to feature-requests</subtitle><entry><title>Student lookup</title><link href="https://sourceforge.net/p/pscafe/feature-requests/18/" rel="alternate"/><published>2010-09-18T03:22:49Z</published><updated>2010-09-18T03:22:49Z</updated><author><name>Matt Kuehne</name><uri>https://sourceforge.net/u/kuehnem/</uri></author><id>https://sourceforge.netdd1fd97513d3b16c8e407071d24f850c4372ecbb</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Is it possible to have a student id lookup by last name?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Credit card integration on parent portal</title><link href="https://sourceforge.net/p/pscafe/feature-requests/17/" rel="alternate"/><published>2010-09-18T02:49:42Z</published><updated>2010-09-18T02:49:42Z</updated><author><name>Matt Kuehne</name><uri>https://sourceforge.net/u/kuehnem/</uri></author><id>https://sourceforge.netb8c8fca84c279f4655654facd3ce92b742c4a56d</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I know it's difficult. What about Paypal? Most commercial pos systems use them.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Virtual keypad on add credit</title><link href="https://sourceforge.net/p/pscafe/feature-requests/16/" rel="alternate"/><published>2010-09-18T02:48:26Z</published><updated>2010-09-18T02:48:26Z</updated><author><name>Matt Kuehne</name><uri>https://sourceforge.net/u/kuehnem/</uri></author><id>https://sourceforge.net4bfa1b70207f68be178ef4f61a9a34692f4a5401</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;How about a virtual keypad on the add credit screen?&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Logout/exit confirm</title><link href="https://sourceforge.net/p/pscafe/feature-requests/15/" rel="alternate"/><published>2010-09-18T02:46:40Z</published><updated>2010-09-18T02:46:40Z</updated><author><name>Matt Kuehne</name><uri>https://sourceforge.net/u/kuehnem/</uri></author><id>https://sourceforge.net1d26530a87ab14e26c43d5997afaa9511103f034</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Can we do an Are You Sure? Yes/No on exit. &lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Logout button</title><link href="https://sourceforge.net/p/pscafe/feature-requests/14/" rel="alternate"/><published>2010-09-18T02:44:43Z</published><updated>2010-09-18T02:44:43Z</updated><author><name>Matt Kuehne</name><uri>https://sourceforge.net/u/kuehnem/</uri></author><id>https://sourceforge.net7797d5c036bf7ebb8a491e3360e1e32ba1196e86</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;A logout button would be nice and save time.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Onscreen keyboard and keypad on login screen</title><link href="https://sourceforge.net/p/pscafe/feature-requests/13/" rel="alternate"/><published>2010-09-18T02:43:27Z</published><updated>2010-09-18T02:43:27Z</updated><author><name>Matt Kuehne</name><uri>https://sourceforge.net/u/kuehnem/</uri></author><id>https://sourceforge.net90e4c8fef8c71671e95cfee4ad1ea0b3880424c7</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;It'd be nice to have an onscreen keyboard and keypad for the login screen.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Daily Credit report</title><link href="https://sourceforge.net/p/pscafe/feature-requests/12/" rel="alternate"/><published>2009-01-06T14:11:11Z</published><updated>2009-01-06T14:11:11Z</updated><author><name>Kenneth Maples</name><uri>https://sourceforge.net/u/kenmaples/</uri></author><id>https://sourceforge.neta62a3ec3846afe6b415356e7f0db65672f8d73da</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Requesting a simple report that can be ran based on date (or range of dates) so that we can balance the incoming funds (credit) with the deposited funds.&lt;/p&gt;
&lt;p&gt;Here is my sloppy vbs script that I am using now to give you an idea...;)&lt;/p&gt;
&lt;p&gt;Dim oConnection, sConnectString, rs, aSIS(), aCredit(), sStudentID, sStudentFirstName, sStudentLastName, sStudentCreditID, sCreditAmount, sFound&lt;/p&gt;
&lt;p&gt;'To open database&lt;br /&gt;
Set oConnection = CreateObject("adodb.connection")&lt;br /&gt;
sConnectString = "Driver={MySQL ODBC 5.1 driver}; server=xxx; port=xxx; database=pscafepos; uid=xxx; pwd=xxx; Option=131242"&lt;br /&gt;
oConnection.Open sConnectString&lt;/p&gt;
&lt;p&gt;sStart = "1/4/2009"&lt;br /&gt;
sEnd = "1/5/2009"&lt;/p&gt;
&lt;p&gt;Set rs = oConnection.Execute("Select * From studentcredit_log")&lt;br /&gt;
y = 0&lt;br /&gt;
While Not rs.EOF And Not rs.BOF&lt;br /&gt;
sStudentCreditID = rs.Fields("scl_studentid")&lt;br /&gt;
sCreditAmount = rs.Fields("scl_action")&lt;br /&gt;
sCreditDateTime = rs.Fields("scl_datetime")&lt;/p&gt;
&lt;p&gt;ReDim Preserve aCredit(2, y)&lt;br /&gt;
aCredit(0, y) = sStudentCreditID&lt;br /&gt;
aCredit(1, y) = sCreditAmount&lt;br /&gt;
aCredit(2, y) = sCreditDateTime&lt;br /&gt;
y = y + 1 &lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;rs.MoveNext&lt;br /&gt;
Wend&lt;/p&gt;
&lt;p&gt;Call rs.Close&lt;br /&gt;
Set rs = Nothing&lt;/p&gt;
&lt;p&gt;WScript.Echo "Student Credit ID" &amp;amp; "," &amp;amp; "Credit Amount" &amp;amp; "," &amp;amp; "Credit Created"&lt;/p&gt;
&lt;p&gt;n = 0&lt;br /&gt;
Do Until n = (UBound(aCredit, 2) + 1)&lt;br /&gt;
sCreditDateTime = aCredit(2, n)&lt;br /&gt;
sCreditDateTime = Left(sCreditDateTime, InStr(sCreditDateTime, " ")-1)&lt;br /&gt;
'WScript.Echo sCreditDateTime&lt;br /&gt;
'WScript.Echo sEnd&lt;/p&gt;
&lt;p&gt;If sStart &amp;lt;&amp;gt; "" And sEnd &amp;lt;&amp;gt; "" Then&lt;br /&gt;
'WScript.Echo "starting Date"&lt;br /&gt;
If sCreditDateTime &amp;gt;= sStart And sCreditDateTime &amp;lt;= sEnd Then&lt;br /&gt;
'WScript.Echo " Match Date"&lt;br /&gt;
WScript.Echo aCredit(0, n) &amp;amp; "," &amp;amp; aCredit(1, n) &amp;amp; "," &amp;amp; aCredit(2, n)&lt;br /&gt;
sCreditTotal = aCredit(1, n) &lt;br /&gt;
End If&lt;br /&gt;
Else&lt;br /&gt;
WScript.Echo aCredit(0, n) &amp;amp; "," &amp;amp; aCredit(1, n) &amp;amp; "," &amp;amp; aCredit(2, n)&lt;br /&gt;
sCreditTotal = aCredit(1, n)&lt;br /&gt;
End If&lt;/p&gt;
&lt;p&gt;sTotal = sTotal + sCreditTotal&lt;br /&gt;
sCreditTotal = 0&lt;br /&gt;
n = n + 1&lt;br /&gt;
Loop&lt;/p&gt;
&lt;p&gt;WScript.Echo "Total Credit is: $" &amp;amp; sTotal&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Credit audit trail</title><link href="https://sourceforge.net/p/pscafe/feature-requests/11/" rel="alternate"/><published>2009-01-06T13:58:05Z</published><updated>2009-01-06T13:58:05Z</updated><author><name>Kenneth Maples</name><uri>https://sourceforge.net/u/kenmaples/</uri></author><id>https://sourceforge.net5c3831ec71ec41da64f02cf8d8c4e1e1f2255518</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Add a column to studentcredit_log for scl_createdby so we can track what user created the credit.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Link Building and Items by Building reports</title><link href="https://sourceforge.net/p/pscafe/feature-requests/10/" rel="alternate"/><published>2008-08-04T19:07:25Z</published><updated>2008-08-04T19:07:25Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net6bd8606666726d439baab668afbd2b414988c769</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Can you link the Building Report and the Items by Building Report to print out together right after each other?&lt;br /&gt;
&lt;/p&gt;
&lt;p&gt;Otherwise, one has to go back and enter report, report name, enter info, choose submit, select open, then print (too many steps to get these two reports).&lt;/p&gt;
&lt;p&gt;This will be especially useful at the elementary schools.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Sub summarize count downs by register within same building</title><link href="https://sourceforge.net/p/pscafe/feature-requests/9/" rel="alternate"/><published>2008-08-04T19:05:34Z</published><updated>2008-08-04T19:05:34Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net6949f031fcd2036ed5d13ec2829978528d349ea2</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;When running count down reports (this would be for our middle schoool w/ 3 registers) can you program it to run all registers/cashiers reports at the same time but with separate reports for each. Too many times I don't get the registers matched up to the cashiers or I have the wrong date, this way with one click or so all of the cashier count down reports will print out.&lt;/p&gt;
&lt;p&gt;Submitted by Jay Duff (duffjay at d83/org)&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>