edwing Posted April 21, 2003 Share Posted April 21, 2003 Hi all, I need to add the telephone number of addressee to the packlist as this is a requirement from the courier company we're working with. I already added the field delivery_telephone to the orders table and have added entry_telephone field to the address_book table. I got the address book files changed so I can add/edit a persons telephone number and the same for the checkout_*_address files. So I can now add the telephone number during checkout. I can see it is being added to the address_book table, but it's not being added to the orders table. Not sure where to have a look now. Anyone able to give me any directions on where to have a look next? Specificaly I'm trying to find in which file the insert statement is located for the order entry. Link to comment Share on other sites More sharing options...
Ajeh Posted April 21, 2003 Share Posted April 21, 2003 A search on telephone is an idea ... :D Then peek over at: http://www.oscommerce.com/forums/viewtopic.php...t=36334&start=0 Link to comment Share on other sites More sharing options...
edwing Posted April 22, 2003 Author Share Posted April 22, 2003 Thanks for that. I did the search, but had no luck with it. Maybe I wasn't very clear what I'm looking for. I'm not looking for the telephone number of the customer/member, but for the telephone number of the addressee/reciever. The addressee (taken from the members address book) doesn't have a telephone number standard, but I changed that in the address_book table and have made sure members can add a telephone number into their address book entries. It's stored correctly by using both the "address book" edit function in My Account and also works fine when adding an address during checkout. What I'm having trouble with is getting the telephone number into the orders table when placing the order. Do you know if the whole order is inserted at once at the end of the order confirmation or is it done in steps during the checkout process? Basically I'm not sure in which file the INSERT sql statement is done for the order. If I find that I might be able to work it out. Link to comment Share on other sites More sharing options...
Ajeh Posted April 22, 2003 Share Posted April 22, 2003 You might take a look at: /includes/classes/order.php You will see several sections that pull the information that will be added to the final order files. The easiest way to do this is find a field from the same table and duplicate the method used. Link to comment Share on other sites More sharing options...
edwing Posted April 22, 2003 Author Share Posted April 22, 2003 Thanks I'll have a look at that and will post the outcome. Link to comment Share on other sites More sharing options...
edwing Posted April 22, 2003 Author Share Posted April 22, 2003 As you said it was the /includes/classes/order.php file where I had to look. I already had changed every thing as it should be there. At least that is what I thought, but I had made a few copy/paste mistakes and thats why it didn't insert the phone number in the orders table. Must have been cause I was working on it at 3.30am the other day :roll: Thanks for your help Linda! Link to comment Share on other sites More sharing options...
Ajeh Posted April 22, 2003 Share Posted April 22, 2003 Sure thing. Glad you found that sneaky missing peice to the puzzel ... 8) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.