8.30.2005

why morning coffee is the best

everyday for the past 2 years, i wake up and go to jaja's and have my first doze of caffeine. that more or less within an hour after i get up from my bed and go back refreshed and psyched up after that. the coffee costs only Php 5.00 and can rival the one served at bacolod's top coffee shops. only one shop can match jaja's flavor: burgos street's la corona.. but that's another story. at jaja, its there where i usually get to plan out my day's activities. have some deep thinking. going there is like routine for me. most of the waitresses know what to serve me: 1 'laban' -- thats how they call the mocha-like coffee and 2 sticks of marlboro. i stumbled upon this article that says that coffee could be a health drink. wow. great. well, study showed the same about alcohol. but it doesn't mean getting drunk every day is a healthy thing to do, as is maintaining a caffeïne addiction. moderation in things is key i believe. i just know that quitting the whole coffee-addiction had benefits for me personally. try going to cafe bob's, bo's cafe..the current craze of coffee in bacolod has coffee-drinking purists blurt out: people perceive coffee drinking as socializing. drinking coffee would be like another night out at some exclusive bars. its like youre 'in' if youre drinking coffee. tsk tsk tsk. posers.

sql lesson

i havent got to get ultra-edit working. i dont know what happened, it was working this afternoon but now, hours later, i wouldnt go beyond the starting dialog box of the application. tried moving the folder into a different drive, un-installing + reinstalling... it just wouldnt work! m$ must have figured out how to delay my project again. so im going back to allaire homesite, my ex-text editor..anyway, have this sql query on my shipping module:

SELECT * FROM transactions_temp
INNER JOIN users
ON transactions_temp.userid = users.userid
INNER JOIN locations
ON transactions_temp.locationid = locations.locationid
INNER JOIN services
ON transactions_temp.serviceid = services.serviceid
INNER JOIN packages
ON transactions_temp.send_packageid = packages.packageid
INNER JOIN rates
ON transactions_temp.send_packageid = rates.packageid
ORDER BY trans_tempid DESC LIMIT 1

when i had created the database schema, i had two identical tables, transactions and transactions_temp, whom i added without thinking., days later i was wondering why i inserted all the shipment data into transactions_temp and not to the transactions window? why did i create two identical tables? i guess by now its all clear because, ill be using ONLY the transactions_temp table for the shipment, all the data will be passed there temporarily, and after the user clicks 'DONE', all the data will be duplicated into the transactions table, and the row in the temporary table will be deleted. it has something to do with that sql query. because when i typed directly the url, ...user_home.php?print_label, it shows the query result of the last entry in the temp table. that disaster could be solved by copying the row from transactions_temp table into the transactions table. it would show up as null. first its a workaround, second it would be more secure. only at the last part of the shipping module, the transactions table would be used, as opposed to transactions_temp.. and the latter gets cleaned up after every successful display of the package label.

having coffee at this early morning. will be going downstairs for a smoke. (mom's here with me)

8.29.2005

labels are up!


used gd instead of fpdf. with regards to some issues regarding the printing, solved it using css, no need for links from the page for printer friendly pages. so it printed. the package label, complete with barcodes. its just waiting for the package in which to be stuck into. next problem: have to update the costing that the package will be needing a thermal printer since its the best printer for printing documents with barcodes.

problem: home-based users dont have a thermal printer, to think most of them dont have a laser printer or something costly printer. me included.
solution: users, have to make the label online, if they have a thermal printer, they can have it printed into a laser paper, but if they dont have, they can have it printed into their nearest jrs store when they get to send their package. problem solved? i dont know. maybe.