This topic is locked
[SOLVED]

 Multiple Lines On Order Form

7/3/2013 6:32:37 PM
PHPRunner General questions
R
rgfischerjr author

Working on an order entry system - I need to be able to add multiple items on a screen without having a separate pop-up to select the item, click add to cart, etc. (the way the shopping cart admin works). Ideally a single screen would allow for selection of vendor, purchase terms, shipping info, multiple lines for items and total costs with no pop-ups.

C
cgphp 7/4/2013

Post a screenshot of what you want to achieve.

R
rgfischerjr author 7/4/2013

Something similar to this where items can be added on the screen without having to use a pop-up to select and add the additional items.
Thanks,

R

Sergey Kornilov admin 7/4/2013

There is no screenshot but I assume you are looking for something like Invoice template:

http://xlinesoft.com/invoice

R
rgfischerjr author 7/5/2013



There is no screenshot but I assume you are looking for something like Invoice template:

http://xlinesoft.com/invoice


Odd - the jpg is there when I look at the post.
Yes - I looked at the invoice template (which I have purchased). That would work with modification - which looked a little overwhelming for someone that doesn't do java. Unless.. it's easier to modify than it looks like.

Sergey Kornilov admin 7/5/2013

Your image link points to your localhost meaning nobody but you will be able to see it.

R
rgfischerjr author 7/5/2013

Reposting image..

Sergey Kornilov admin 7/5/2013

Thanks. Looks exactly like Invoice template to me. I believe that designing it from scratch will take more effort than Invoice template customization. Probably you can ask more specific questions in regards to this template customization.

R
rgfischerjr author 7/5/2013



Thanks. Looks exactly like Invoice template to me. I believe that designing it from scratch will take more effort than Invoice template customization. Probably you can ask more specific questions in regards to this template customization.



Sergey - I've spent some time studying the Invoice template...
On the invoices Add Page there is 'displayDetailTable_invdetails' which is generates the input screen for the invoice line items, however this appears to be the layout from the invdetails LIST page, not the invdetails ADD page. Am I seeing this correctly?
The biggest difference I see so far in the Invoice Template and what I need to do is that the 'Invoice Items' are not selected from a query result. I need to be able to filter the items list by location and vendor and then let the user select items from the filtered list. How to start modifying the Invoice template to utilize a drop down on the 'add items' function?

Sergey Kornilov admin 7/7/2013

If you check live demo #2 at http://xlinesoft.com/invoice you can see that it uses a dropdown box to select items.
Simply set 'Edit as' type of Item field in invdetails to 'Lookup wizard'.

R
rgfischerjr author 7/8/2013

Got It. Any Tips For Modifying Field Names So The Program Doesn't Break?

Sergey Kornilov admin 7/8/2013

Do not modify field names, modify field labels. This way you won't break anything.

R
rgfischerjr author 7/8/2013

unfortunately this is being pulled into a larger existing database so I'm going to have to Modify Field names

Sergey Kornilov admin 7/8/2013

If you change any field name you have to modify all events (PHP and Javascript) where this field name is being used.

R
rgfischerjr author 7/8/2013

I saw that coming :-)
Is it possible (using Ultra Edit / Ultra Compare or similar tool) to do global search/replace on the code? I'm assuming I could do so after the pages generated but I'd prefer to do within PHPR for obvious reasons.
thanks for the support - you guys are great!

Sergey Kornilov admin 7/9/2013

Doing search and replace in generated code is the last thing I would recommend. If you must use other field names - you have to study the Invoice template and implement all the same functionality manually. Though I don't see a problem using Invoice template as a part of another database your situation might be different.

R
rgfischerjr author 7/9/2013

The goal is to modify it so that it's a Purchase Order template - and I need to pull items from an existing database with 'items' by a particular manufacturer being sold by different vendors. Not all items are sold by all vendors and not all locations use all vendors or all items. The field names in the existing database and the select queries for updating items/manufacturer, item/vendor, vendor/location, item/location are all in place and being used for inventory management at the locations. This is a 'next' step in functionality for us.d
I did spend several hours last night studying the template and I think I have a game plan. I'm sure I'll be reaching out for assistance on the forum though!

R
rgfischerjr author 7/11/2013

I'm going to mark this as solved. After a couple of long night I found I was over thinking the problem. Inline add works very well for what I want to do - formatting the PRINT page was the key.

mperry622 7/17/2013

I have supported ASPRunner for many versions and 100% love it... I just purchased the invoice template with the hopes of using this to display data never write... I have millions of lines in a database. I cant start over, this data is being inputted from another program direct to the database. I currently have everything working in asprunner but wanted the last page to be a nice looking invoice and the option for PDF... I am so lost right now... any pointers. There is 100% no documentation on this invoice template.I guess is there any way to make a layout that looks just like the invoice template?
I have three tables. (these are my tables and fields)
MAIN TABLE

CUSTOMERINFO (name, address, phone, fax, account balance etc etc)
>master/child Links to Invoices using a customerID
INVOICES (CustomerID,[Date],Inv_Number,Inv_Amount,Inv_Remaining,Description,Discount,DueDate,SalesOrderID)
>master/child Links to InvoiceDetails using SalesOrderID
INVOICEDETAILS (TermsDescription,ItemDescription,InvoicePrice,DeliveredQuantity,TaxRate,TaxAmount,CustomerID,SalesOrderID)
Any help in this would make me so happy...