Chris Pollett > Students >
Sugi

    ( Print View )

    [Bio]

    [Project Blog]

    [CS 297 Proposal]

    [Intro to jQuery and YUI - PDF]

    [Deliverable 1]

    [Deliverable 2]

    [Deliverable 3]

    [Deliverable 4]

    [CS 297 Report - PDF]

    [CS 298 Proposal]

    [CS 298 Report - PDF]

    [CS 298 Slides - PPT]

    [CS 298 Codes - Zip]

                          

























CS297-298 Project News Feed

11/23/10
  • Added Registration Confirmation Module (Done)
11/16/10
  • Added Login & Registration page (Done)
  • Start working on thesis report
11/09/10
  • Ability to add new controller file (Done)
  • Drag-and-drop model to controller should automatically cause controller to use that model (Done)
  • Help System on right panel (Done)
  • Ability to parameterize the fields during controller edit (Done)
  • Ability to export SQL statements for create db, create table, and insert data (Done)
  • Model methods auto-completion when editing controller file (Done - Not yet working on IE)
  • Choosing create new project on File-Menu should now open create new project form
11/02/10
  • Right click mechanism added for add entry, delete entry, add find, and add associations
  • Added class to add the model to controller file directly on the fly
  • TODO
    • Ability to add new controller file
    • Drag-and-drop model to controller should automatically cause controller to use that model
    • Help System on right panel
    • Ability to parameterize the fields during controller edit
    • Ability to export SQL statements for create db, create table, and insert data
    • Model methods auto-completion when editing controller file
    • Revamp of menu
10/26/10
  • Change the DATABASE_CONFIG class settings to include all the db configs from all projects. Models from similar project will now use similar db config
  • Implement right-click as the mechanism to work with the models, views, and controllers.
10/19/10
  • New project creation is now done via a new modal dialog box. First usage of jquery UI to make the modal dialog box prettier.
  • Adding method in controller to save the model name and serialized db config from newly created project.
  • The DATABASE_CONFIG class will load all the model and db configs from all current projects. We need the db config of each project so tha we can use it to construct the model objects from any project on the fly.
  • Able to retrieve a schema from a model. We will use this schema to construct the interface to edit the model schema, add data, delete data, add find, and add new association
  • Capability to edit the model schema (Design Mode)
10/12/10
  • Automatically create new database upon the successful creation of new project
  • Update the database.php accordingly to use the newly created database
10/5/10
  • Out sick
09/28/10
  • Integration of CKEditor to the IDE. We should now be able to open, edit, and save the model, controller, and view files
  • Right panel of GUI now has panels for edit and design mode. Design mode is currently under work in progress
09/21/10
  • Fix the new project submission issue. New project should be created if user either click on create button or hit enter after entering new project name
  • Create the svn, trac, and bugzilla for this project
  • Add button to perform ajax save for ckeditor
  • TODO
    • Integrate the CKEditor to the UI
    • Add editing of model file in edit/design mode. On Edit mode, display all tables associated with each model. On edit mode, allow user to edit the .php file
09/14/10
  • Separation of core CakePHP directory and applications directories
    • All applications should share one core CakePHP directory. Three possible ways to achieve this:
      • Set the core CakePHP directory in webroot/index.php for each application [ works for Mac OS X and Windows ]
      • Create a symlink that points to CakePHP core directory for each application [ does not work for Windows < Windows Vista ]
      • Include copy of core CakePHP directory for each application [ probably a bad idea ]
  • Automatic creation of new project directory and required directories + files
  • Automatic creation of model and controller skeleton .php files
  • First integration w/ Swathi's UI
09/07/10
  • TODO:
    • Search for open source editor to edit the controller file
    • Our PHP IDE should be able to create all requied cakePHP application projects and files upon the creation of new project
08/31/10
  • Designing the database structure for new project creation
  • on-paper concepts on the model and attributes database table
  • Working on form submission via ajax in CakePHP
  • Auto-creation of model and controller skeleton files
05/12/10
  • Submit the CS 298 proposal
  • TODO:
    • Continue on Revising and proofreading the CS 297 report
    • Revise CS 298 proposal
    • See Dr. Pollett tomorrow during office hours regarding CS 298 proposal and CS 297 report
05/05/10
  • Submit the first draft of CS 297 report
  • TODO:
    • Revise and proofread the CS 297 report
    • Work on CS 298 proposal
04/28/10
  • Demo of the last iteration of deliverable 4 - We now have complete features from Deliverable 2 and 3 on 1 application.
  • TODO:
    • work on final report
04/21/10
  • Demo of the first iteration of deliverable 4
  • TODO:
    • Revamp the GUI to integrate deliverable 2 and 3
    • Start working on final report
04/14/10
  • Demo of the second iteration of deliverable 3 [ Source code .zip file]
  • TODO:
    • Bug fix: Criteria value should be enclosed in quote if the data type is either varchar or char.
    • Allow user to specify column name
    • Add another dropdown in criteria to specify comparison type (for example: =. >, or < for int)
    • Make sure that one does not need to scroll too much on the deliverable pages.
    • Make sure all the html pages are validated
    • Start working on deliverable 4
04/07/10
  • Demo of the first iteration of deliverable 3
  • TODO:
    • Add capability to allow users to drag and drop the tables to create relationship. The QBE UI should be automatically created
    • create pages for current available deliverables.
    • Fix the links on current page to point the pages above instead of the deliverable .zip files
03/24/10 03/17/10
  • Demo of the second iteration of deliverable 2
  • TODO:
    • Add validation when users save [Only Table name validation so far]
    • Add DB/tables editing feature
    • Delete tables/tables attributes
    • Add relationship
    • Export to SQL
03/10/10
  • Demo of the first iteration of deliverable 2
  • TODO:
    • Revamp the GUI so it is more obvious to the users that they can create multiple tables
    • Revamp the GUI to become two side-by-side panels. Left panel will have all the forms to construct tables/DB. Right panel will have the graphical presentation of the GUI and DB created.
    • Add validation when users save [Only Table name validation so far]
    • Add DB/tables editing feature
03/04/10 02/17/10 02/10/10
  • Slide presentation [ Slide ]
  • TODO: deliverable 1 is due next week: Just use jQuery
  • TODO: prepare slides for next meeting about deliverable 1
02/03/10
  • First team meeting
  • Prof. Pollett : Remove the CS 298 link from the index page
  • TODO: prepare slides foe next meeting about jQuery and YUI 3.0
  • TODO: deliverable1 due in 2 weeks: Create a simple application that can create new objects, move around the objects, and other cool stuffs.
01/29/10
  • Add the bio statement
  • Upload the proposal in html format