Jump to content
Latest News: (loading..)
Sign in to follow this  
Jonojamesmac

iPhone/iPod Touch Web App

Recommended Posts

iPhone/iPod Touch Web App for Oscommerce

 

This web app for Oscommerce allows you interface with your shops orders, current features are:

 

- View order list

- View orders, including order status, products, attributes, total cost and custommer/order comments.

- iWebKit has been incorporated to allow a smoother feel app

- Views like a normal app from the Apple App Store

- iPhone interaction, call or email a customer with a click of a button.

- Google Maps Integration, find where your customer is in 1 click.

- Customize it to how you want it.

- And more...

 

Please see the readme.txt file included for instructions on how to make it like a full app, as it just needs a few steps by you for it to work as intended. Because it is a web app this is needed.

 

Download here...

 

Just a note that i am just a beginner in the php world, and this was the first thing i've made that does work. The code could be cleaned up a lot but as i learn, i'll learn how to clean it up :)

 

If you have any problems, i'll try to help in the best way possible.

 

Thanks

Edited by Jonojamesmac

Share this post


Link to post
Share on other sites

V1.1 Uploaded - Changes below.

 

- It is now possible to view credit card info if a customer has paid via your credit card input facilities. Note: Credit card info entered on your website is only included, 3rd Party credit card processors are not included.

- Customer contact list has been added, similar to the layout of the iPhone/iPod Touch Contacts Application

- Customers can now be contacted by SMS

- Viewing a customer from the contact list will display all orders the customer has made.

- Top Toolbar has navigation buttons for the new content.

- Optional Model No has been added to the orders page, this may help if you catalogue your products via Model Number.

- Reports Tool has been added, it is now possible to view the status of Products, Customers, Orders and the total amount in sales over current month, last month, current year and last year

- Updated instructions to use SSL when using this App.(thanks Dave)

- Index page is now index.php and not iphone.php

 

This contribution has been uploaded as a completely new one, due to putting into wrong section. Awaiting to be manually added.

Share this post


Link to post
Share on other sites

So, how do you keep anyone from navigating to this area on your server and viewing all of this info?

 

What are all of the extra graphics for...in the images folder?

Share this post


Link to post
Share on other sites
So, how do you keep anyone from navigating to this area on your server and viewing all of this info?

 

What are all of the extra graphics for...in the images folder?

 

The extra images came along with the iWebkit part of the app, they may come of use in the future.

 

Protecting the area on your server is done by protecting the directory the contribution is in. The good thing about this contrib is that it doesn't have to be included in your shop directory, it can be placed anywhere on your server, and it can be accessed by a browser. If only you know the url then all is cool, but i understand that a username and password may be needed to protect it even more.

 

The best method to protect the directory is via .htaccess for more information on that, click here

Share this post


Link to post
Share on other sites
The extra images came along with the iWebkit part of the app, they may come of use in the future.

 

Protecting the area on your server is done by protecting the directory the contribution is in. The good thing about this contrib is that it doesn't have to be included in your shop directory, it can be placed anywhere on your server, and it can be accessed by a browser. If only you know the url then all is cool, but i understand that a username and password may be needed to protect it even more.

 

The best method to protect the directory is via .htaccess for more information on that, click here

 

I knew that you could move the app around on the server but that is still a very primitive type of protection when you start talking about credit card numbers, addresses, phone numbers, names, etc.

 

I thought about the .htaccess but I wasn't sure how well it would work in conjunction with the iPhone. I currently don't have an iPhone so I couldn't test it. I was just trying to get the app ready for when I do get one.

Share this post


Link to post
Share on other sites

I've just implemented it onto my version on the iPod Touch, i also have acces to an iPhone and .htacces protection requires you to enter a username and password everytime you open the app.

 

Once the username and password is entered, you don't need to re-enter until the app is opened again.

 

You could you a cookie-based protection with that, saving the password for so many days..

Share this post


Link to post
Share on other sites

Update uploaded - v1.2

 

- Added login/logout functionality, log in with your admin username/password.

- Remember me option

- All customers orders will always appear on customers page.

- Credit Card info moved to order page.

- Optional CVC added

- Removed images that were not needed.

 

Please note: Remember Me option only works with the iPhone, iPod Touch cookies are currently broken.

Edited by Jonojamesmac

Share this post


Link to post
Share on other sites
I'm actually testing using my broswer at the moment. Its being typed in all lowercase as it is supposed to be?

 

What browser are you using?

Safari will display as if its on the iPhone, try that and you have configured the config.php yes?

Edited by Jonojamesmac

Share this post


Link to post
Share on other sites

I don't use prefixes either :)

 

Copy/Paste this code into notepad and save it as code.php, upload it and run it. Let me know the outcome.

<?
include('config.php');
include('dbcon.php');
function checkColumn($columnname, $tablename) {
 $columns = array();
 $table = $tablename;
 $query = 'SHOW COLUMNS FROM '.$table.';';
 if ($results = mysql_query($query)) {
  if (mysql_num_rows($results) > 0) {
while($row = mysql_fetch_row($results)) {
 $columns[] = $row[0];
}
  }
 }
 if (in_array($columnname, $columns)) {
  return 1;
 }
 else { return 0; } }
 $user = 'user_name';
 $admintable = 'administrators';
 $test = checkColumn($user, $admintable);

 if ($test == 1) { echo'OK - Admin Table Exists'; } else { echo'Not OK - Can\'t find the admin table'; }
 ?>

Share this post


Link to post
Share on other sites
What is the name of the administrators table in your database?

 

 

admin

 

and here are the individual fields

 

admin_id admin_groups_id admin_firstname admin_lastname admin_email_address admin_password admin_created admin_modified admin_logdate admin_lognum

Share this post


Link to post
Share on other sites

Ok edit login.php

 

replace on line 35:

   $q = "select user_password from administrators where user_name = '$username'";

with

   $q = "select admin_password from admin where user_name = '$username'";

 

and line 43 replace

	$stack = explode(':', $dbarray['user_password']);

with

	$stack = explode(':', $dbarray['admin_password']);

Share this post


Link to post
Share on other sites

Hi,

Loving this app! I've already made a ton of changes and updates (my oscommerce install is HIGHLY modified.) Could you possibly add a way to update the status? I think that this option would take this app to the next level as far as how useful it is.

Share this post


Link to post
Share on other sites

I get to the login page but keep getting Invalid Username? I know the password is correct because I set it up just for the iphone app?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×