Yii Framework Forum: Northwind site by Yii - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Northwind site by Yii Demo site with Microsoft tutorial database Rate Topic: -----

#1 User is offline   robysax 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 24
  • Joined: 05-November 10

Posted 14 May 2012 - 09:40 AM

I am a PHP developer and I use Yii framework on CentOS linux platform with Apache and MySQL.
I put online a demo site that I developed to show the Yii ability.
I used Northwind database that Microsoft uses for his tutorial.
The site allows you to manage customers, orders, and suppliers, it's only demonstrative and therefore does not have the full functionality.
The application that I developed has the following characteristics:

- Menus, messaging and multi-language attributes with selection of Italian and English.
For reasons of time, the translation is incomplete as soon as possible will complete.

- Portlet on the homepage with the last 5 customers and orders placed

- Geolocation of customers on Google Maps from address in the database

- Export and import of all data in ASCII CSV file format with the possibility to choose the field separator

- Layout improved compared to the standard with menus, forms and portlets shaded

- Menu information by collecting data on the client: browser type, operating system, IP address, exact location on Google Maps etc..

- Etc. etc..

The site is accessible for reading by all without the need to log in while editing must authenticate.
The application is hosted on 000webhost, speed is limited because it's a free service provider.
The connection data are:

Address: http://prjdemo.webatu.com/northwind/

Login: admin

Password: d3m02012


ENJOY
1

#2 User is offline   bobpang425 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 34
  • Joined: 17-August 10

Posted 14 May 2012 - 10:54 AM

Hi robysax,
I would like to know. how to make the data import & export function in northwind.
any extension which you used ?
Could you share about this. Thanks ^^ :)
0

#3 User is offline   robysax 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 24
  • Joined: 05-November 10

Posted 14 May 2012 - 02:37 PM

View Postbobpang425, on 14 May 2012 - 10:54 AM, said:

Hi robysax,
I would like to know. how to make the data import & export function in northwind.
any extension which you used ?
Could you share about this. Thanks ^^ :)


For Export data, I have developed an action that finds all models and writes to an ASCII file (see fputcsv PHP function).
The data import reads CSV ASCII file and for each record makes a model and validates (see fgetcsv PHP function).
0

#4 User is offline   bobpang425 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 34
  • Joined: 17-August 10

Posted 14 May 2012 - 06:54 PM

View Postrobysax, on 14 May 2012 - 02:37 PM, said:

For Export data, I have developed an action that finds all models and writes to an ASCII file (see fputcsv PHP function).
The data import reads CSV ASCII file and for each record makes a model and validates (see fgetcsv PHP function).

Thanks
0

#5 User is offline   eMontano 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 10
  • Joined: 28-March 12

Posted 14 May 2012 - 09:49 PM

Link dead :(
0

#6 User is offline   Maurizio Domba Cerin 

  • Yii - Yesss It Is !!!
  • Yii
  • Group: Yii Dev Team
  • Posts: 4,342
  • Joined: 12-October 09
  • Location:Croatia

Posted 15 May 2012 - 02:23 AM

@eMontano Just tried... works for me, try again
Find more about me.... btw. Do you know your WAN IP?
0

#7 User is offline   dymatrix 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 15
  • Joined: 17-January 09

Posted 16 May 2012 - 12:27 PM

It would be great if this type of example was included with Yii.

Would you be willing to share/sell this code for newbie's to learn from/use/modify ?
0

#8 User is offline   robysax 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 24
  • Joined: 05-November 10

Posted 17 May 2012 - 04:09 AM

View Postdymatrix, on 16 May 2012 - 12:27 PM, said:

It would be great if this type of example was included with Yii.

Would you be willing to share/sell this code for newbie's to learn from/use/modify ?


soon I'm going to write a small manual about my experience with Yii on the development of applications and make it available to all
0

#9 User is offline   waitforit 

  • Advanced Member
  • PipPipPip
  • Yii
  • Group: Members
  • Posts: 382
  • Joined: 09-February 11

Posted 17 May 2012 - 06:15 AM

If you would share some code that would be just great.

I like how you implemented some additional functionality in a detailView with the tabs. I have been struggling with how to show related data in one of my apps and I think I'll borrow that idea.

Also love all your rounded corners and box shadows - looks beautiful.
0

#10 User is offline   robysax 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 24
  • Joined: 05-November 10

Posted 17 May 2012 - 03:51 PM

View Postwaitforit, on 17 May 2012 - 06:15 AM, said:

If you would share some code that would be just great.

I like how you implemented some additional functionality in a detailView with the tabs. I have been struggling with how to show related data in one of my apps and I think I'll borrow that idea.

Also love all your rounded corners and box shadows - looks beautiful.


Thanks, first I want to complete Northwind site then, I will write wiki articles how to improve develop with Yii.
I have created a widget extension for meteo forecast in home page, looks at site.
If you select a Customer view and click on link “Locate on the map” in Anagrafica tab, you can view map and meteo forecast for Customer’s address
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users