From owner-freebsd-questions@FreeBSD.ORG Tue Jan 31 17:04:41 2006 Return-Path: X-Original-To: freebsd-questions@FreeBSD.ORG Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D969F16A422 for ; Tue, 31 Jan 2006 17:04:41 +0000 (GMT) (envelope-from fbsd_user@a1poweruser.com) Received: from mta9.adelphia.net (mta9.adelphia.net [68.168.78.199]) by mx1.FreeBSD.org (Postfix) with ESMTP id EE5BA43D55 for ; Tue, 31 Jan 2006 17:04:40 +0000 (GMT) (envelope-from fbsd_user@a1poweruser.com) Received: from barbish ([69.172.31.117]) by mta9.adelphia.net (InterMail vM.6.01.05.02 201-2131-123-102-20050715) with SMTP id <20060131170439.GQPZ14388.mta9.adelphia.net@barbish> for ; Tue, 31 Jan 2006 12:04:39 -0500 From: "fbsd_user" To: "freebsd-questions@FreeBSD. ORG" Date: Tue, 31 Jan 2006 12:04:32 -0500 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000D_01C6265E.7F2EE980" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal Cc: Subject: Accepting Bids on Web application programming Development contract X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: fbsd_user@a1poweruser.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 31 Jan 2006 17:04:42 -0000 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C6265E.7F2EE980 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit To all interested parities; I am accepting bids on a Web application programming Development project. Bids are open to any developer any where in the world. Bid closing date is February 8 2006. Work is to be done at your location and using your equipment. Please provide your quote in USA dollars and include elapse time table targets in weeks. The attached txt file contains the specs in case your email reader has made the following hard to read because of line wrap around. Real Estate Multipliable Listing Service Web application. General Specs. Run using FreeBSD 6.0 / apache 1.3.33_2 / php 5.1.2 / mysql 5.0.18 The membership info and the real estate info will be separate databases in MySql. Estimated the sizes at 5000 members and 25000 real estate properties. All web pages will use same template so user sees same page header and trailer and background color. Header contains name of Business with line of clickable menu options. Footer will contain copyright statement & icons for powered by FreeBSD, apache, php. All php code will be commented in English. There can never be to many comments, the more the better. All php code will be written in a expanded manner for easy of reading. Each php function and (if statement will have comments describing what it does) All php variables will be descriptive words of content or use in English All html post forms data fields will use English words. Source code will be reviewed by customer for compliance to above general standards. Project will be divided in to phases by application functions and customer acceptance testing before payment. Completed source code will be sent to customer as pkzip or tar file attached to email. Yahoo chat will be used for live project meeting to discuss problems or changes to project specs. Directory path location to mysql databases will be global variable which is part of include. Directory path to .php files is php global variable (DOCUMENT_ROOT) which is part of include. Get the user ip address from the php global variable (REMOTE_ADDR) which is part of include. Access to real estate record in mysql database must be set up is such a way that a URL can be created to display the info. Customer needs URL for inclusion in newspaper media advertising so interest persons can enter that URL in their browser and retrieve the information. Home page named index.php Have visitor counter which shows count just about footer. Content will be provided later. Will have links to these functions Register customer function. (seller, or agent, or broker) Register buyer for online auction bidding Register email notify robot agent. (user enters city or zip code and when any real estate gets lists in their interest area a html email with pictures Register for opt/in emailing for sales info from advertisers offering mortgages, pre-quailing buyers, real estate lawyers/brokers/agents/appraisers Ect. Registered user login to edit their content (called maintenance function). Search function (City name search, price range search, zip code search) Display real estate on auction block. Contact function- email website sales dept with general questions FAQ function- simple html page containing all the questions as links to jump deeper into page where answer details are. Content provided later. Product detail page. simple html page containing all the products as links to jump deeper into page where details are. Content provided later. Register function common specs All register sign up functions will use the same basic form and the data will be saved in mysql database. A hidden flag field will be used to distinguish between what type of register it is. Customer (Seller or agent or broker) Opt/in to receive advertisings Notifications robot Online auction bidder Privacy statement about use of data entered. Common Info to capture = first name, last name, address line1 & line2, city, state/province, zip code. Valid email address which will trigger a standard email to person which he has to reply to confirm email is valid. When conformation is received, the registered persons database record gets auto updated to authorize user access. As security measure a little box with generated password in it has to be entered into empty box as tool to stop script kiddies automatically creating registered users in effort to dos (deny of service) by filling up all the disk space. The Register's IP address will be saved with the data base record. The date in yyyymmdd will be saved with the data base record. Register Customer (Seller or agent or broker) function. [[background info] This group will be allowed to create a real estate record describing the property in detail after email conformation is successful. They will have to login using maintenance function to load the data or to edit the data. This real estate record will be in separate database.] Additional data to collect = home phone number, work phone number, cell phone number, agent/broker license number, Login user ID alphanumeric 8 positions & password, size minimum 6 positions, maximum 10 positions. Have to inquire membership database to verify entered ID is not used already. Password will be written in encrypted form. Display scroll box containing usage Agreement/contract with radio button for agree or decline. If no agree then do not register. Content provided later. Make this content as included php function so the contents can be easily changed at any time. Register Opt/in to receive advertisings Display scroll box containing Opt/in Agreement/contract with radio button for agree or decline. If no agree then do not register. Content provided later. Make this content as included php function so the contents can be easily changed at any time. Set flag to identify this user as opt/in advertising user. Append record to flat text file containing email address and first & last name to feed opt/in software. Register Notifications robot Capture notification values (City name, price range, zip code) Set flag to identify this user as Notifications robot user. Register Online auction bidder Display scroll box containing Online auction bidder Agreement/contract with radio button for agree or decline. If no agree then do not register. Content provided later. Make this content as included php function so the contents can be easily changed at any time. Set flag to identify this user as Online auction bidder user. Registered user login Maintenance function to delete or change the content of there membership database record and or their real estate database record. User entered login ID & password has to match what is on file. Login screen must have same security measure as register screen If user is Opt/in or Notification can only delete or edit contents of their membership record. If user is auction bidder. This is handled pretty much the same way as the search by city function, but this time you search the real estate record database for the auction field = yes. Results is an list array. Each line containing thumbnail picture if there is picture with that real estate record and street address and starting bid price and current bid price with date /time it was make. Clicking on any line will launch screen showing full real estate data record. The user can enter his bid price which is saved in the real estate record along with his user id. After the bid price is updated in the database a email is sent to the registered owner of that property telling them a bid has been offered and the bid price. If user is Seller or agent or broker they get 2 options. Every time user login, update the last logged in date and time fields in their membership record. Option 1 = delete or edit contents of their membership record. Deleting membership record forces the delete of all associated real estate database records. When user selects delete, reply with message are you sure you want to do this, then delete. Option 2 = delete or edit contents of their real estate database records. Seller is allowed only 1 real estate record. Agent/broker have no limit on number of real estate records. Each real estate record will be issued a unique record number starting at 3525000. Member id + record number is key to fetch record. If no record then show empty form for user to fill in. Data to capture = property address, county/province title/parcel number, date added in yyyy/mm/dd, total sq ft, lot dimension, year built in yyyy/mm/dd, about another 30 data fields to be provided later. Option to include max of 5 jpg pictures which is stored as part of the real estate record. Provide function to browse user pc for jpg file location and download jpg file for addition to real estate record . One picture must be identified as primary display picture to be displayed with real estate record data. Other pictures can be seen by user clicking of picture icon which is part of the displayed real estate screen. Option 3. display activity counter for each read real estate record. Results is an list array. Each line containing thumbnail picture if there is picture with that real estate record and street address and price and count of how many times this was viewed. There is an special unrestricted Admin user named "Boss" with password of "robert7734". There is no membership record for this user. This is hard coded into php included variables. Only the owner/webmaster will have access to the servers raw .php data file to manually edit these values. Some admin function will be added later in the development. Admin Option 1. enter user id to select membership record display all membership record fields including user type flags, creation date, last logged on date and time, include ability to display real estate records. Delete or change content of displayed real estate records or Delete or change content of displayed membership record. Admin Option 2. See what is needed during development. Search function (City name search, price range search, zip code search). Any visitor to web site can search database for properties. Results is an list array. Each line containing thumbnail picture if there is picture with that real estate record and street address and price. Clicking on any line will launch screen showing full real estate data record. From detail screen clicking on browser back button will return to search results screen. Search options = show all records matching city, or show all records matching zip code, or show all records matching city and price range, or show all records matching zip code and price range. Any time the detail real estate record is shown add one to the viewed counter in the record. See www.realtor.com for example of what I am talking about. Display real estate on auction block. This is handled pretty much the same way as the above search by city function, but this time you search the real estate record database for the auction field = yes. Results is an list array. Each line containing thumbnail picture if there is picture with that real estate record and street address and starting bid price. Clicking on any line will launch screen showing full real estate data record. >From detail screen clicking on back record will return to search results screen. Offline functions. 1. Provide file containing mysql definition statements. 2. Provide command line php script to do mysql backup of each database used in application. 3. Provide command line php script to do mysql restore of each database used in application. 4. Provide command line sh shell script to do an tar dump with compression of each database. 5. Provide command line sh shell script to do an tar restore with uncompress of each database. 6. Provide command line php script to roll through the membership database selection all the opt/in members and sent them a email with message built from text content contained in flat file. 7. Provide command line php script to roll through the membership database selecting all the seller/agent/brokers members who have not logged in, in the past 90 days and sent them a email with message built from text content contained in flat file. Set the valid email flag so they have to reply to the email to confirm their email is active and working. 8. Provide command line php script to roll through the membership database selecting all the seller/agent/brokers members. For each one access their real estate records to get number times viewed and sent them a email with message built from text content contained in flat file showing how many times each property was viewed since added. General design thoughts. The use of 2 mysql databases is not cast in concrete. Willing to listen to your recommendations. Open to your recommendations on how best to configure environment to result in simple URL to point to individual real estate property web page. www.nnnnnnnnnn.sitedomainname.com where nnnnnnnnnn is the real estate record number without using dns, or www.sitedomainname.com/aliasname/nnnnnnnn. If after reading my specifications you have any recommendations or coding standards or ideas to make things easier or processing faster, I am willing to discuss them. Phase one includes index.php and Register Customer (Seller or agent or broker) function, and Registered user login for seller,agent/broker maintenance function. 1/4 of project cost payable on customer testing and approval. Phase two all other registration functions and their maintenance function. 1/8 of project cost payable on customer testing and approval. Phase three all the search functions and auction function. 1/8 of project cost payable on customer testing and approval. Phase four all remaining functions and offline functions delivered by target deliver date. 1/8 of project cost payable on customer testing and approval. 1/8 of project cost payable on customer testing and approval after 60 days of application stress testing and the fixing of any bugs that come to light. Final 1/4 of project cost payable on customer accepting complete system as bug free. All payment will be in USA dollars by check mailed to your post office mailing address. ------=_NextPart_000_000D_01C6265E.7F2EE980 Content-Type: text/plain; name="Real Estate For sale Web application.txt" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="Real Estate For sale Web application.txt" Real Estate Multipliable Listing Service Web application. General Specs. Run using FreeBSD 6.0 / apache 1.3.33_2 / php 5.1.2 / mysql 5.0.18 The membership info and the real estate info will be separate databases = in MySql. Estimated the sizes at 5000 members and 25000 real estate properties.=20 All web pages will use same template so user sees same page header and = trailer and background color. Header contains name of Business with line of clickable menu options.=20 Footer will contain copyright statement & icons for powered by FreeBSD, = apache, php. All php code will be commented in English. There can never be to many = comments,=20 the more the better. All php code will be written in a expanded manner for easy of reading. Each php function and (if statement will have comments describing what = it does) All php variables will be descriptive words of content or use in = English All html post forms data fields will use English words.=20 Source code will be reviewed by customer for compliance to above = general standards. Project will be divided in to phases by application functions and = customer acceptance testing before payment. Completed source = code will be sent to customer as pkzip or tar file attached to = email. Yahoo chat will be used for live project meeting to discuss = problems or changes to project specs. Directory path location to mysql databases will be global variable = which is part of include.=20 Directory path to .php files is php global variable (DOCUMENT_ROOT) = which is part of include. Get the user ip address from the php global variable (REMOTE_ADDR) = which is part of include. Access to real estate record in mysql database must be set up is such a = way that a URL can be created to display the info. Customer = needs URL for inclusion in newspaper media advertising so = interest persons can enter that URL in their browser and retrieve the = information. =20 =09 Home page named index.php Have visitor counter which shows count just about footer. Content will be provided later. Will have links to these functions Register customer function. (seller, or agent, or broker) Register buyer for online auction bidding Register email notify robot agent. (user enters city or zip code and = when any real estate gets lists in their interest = area a html email with pictures=20 Register for opt/in emailing for sales info from advertisers offering = mortgages, pre-quailing buyers, real estate = lawyers/brokers/agents/appraisers Ect. Registered user login to edit their content (called maintenance = function). Search function (City name search, price range search, zip code = search) Display real estate on auction block. Contact function- email website sales dept with general questions FAQ function- simple html page containing all the questions as links = to jump deeper into page where answer details are. = Content provided later. Product detail page. simple html page containing all the products as = links to jump deeper into page where details are. = Content provided later. =20 Register function common specs All register sign up functions will use the same basic form and the = data will=20 be saved in mysql database. A hidden flag field will be used to distinguish between what type of = register it is.=20 Customer (Seller or agent or broker) Opt/in to receive advertisings Notifications robot Online auction bidder Privacy statement about use of data entered. Common Info to capture =3D first name, last name, address line1 & = line2, city, state/province, zip code. Valid email address which will trigger a standard email to person which = he=20 has to reply to confirm email is valid. When conformation is = received, the=20 registered persons database record gets auto updated to = authorize user access. As security measure a little box with generated password in it has to = be=20 entered into empty box as tool to stop script kiddies = automatically creating=20 registered users in effort to dos (deny of service) by filling = up all the disk space.=20 The Register's IP address will be saved with the data base record. The date in yyyymmdd will be saved with the data base record. Register Customer (Seller or agent or broker) function. [[background info] This group will be allowed to create a real estate = record=20 describing the property in detail after email conformation is = successful. They will have to login using maintenance function to load the = data or to=20 edit the data. This real estate record will be in separate = database.] =09 Additional data to collect =3D home phone number, work phone number, = cell=20 phone number, agent/broker license number, Login user ID = alphanumeric 8=20 positions & password, size minimum 6 positions, maximum 10 = positions.=20 Have to inquire membership database to verify entered ID is not = used already. Password will be written in encrypted form.=20 =20 Display scroll box containing usage Agreement/contract with radio = button for agree or decline. If no agree then do not register. Content = provided later.=20 Make this content as included php function so the contents can = be easily=20 changed at any time. Register Opt/in to receive advertisings=20 Display scroll box containing Opt/in Agreement/contract with radio = button=20 for agree or decline. If no agree then do not register. Content = provided later.=20 Make this content as included php function so the contents can = be easily=20 changed at any time. Set flag to identify this user as opt/in advertising user. Append record to flat text file containing email address and first & = last=20 name to feed opt/in software.=20 Register Notifications robot Capture notification values (City name, price range, zip code) Set flag to identify this user as Notifications robot user. Register Online auction bidder Display scroll box containing Online auction bidder Agreement/contract = with radio button for agree or decline. If no agree then do not = register. Content provided later. Make this content as included php = function so the=20 contents can be easily changed at any time. Set flag to identify this user as Online auction bidder user. =09 =09 Registered user login Maintenance function to delete or change the content of there = membership=20 database record and or their real estate database record. User entered login ID & password has to match what is on file. Login screen must have same security measure as register screen =09 If user is Opt/in or Notification can only delete or edit contents of=20 their membership record. If user is auction bidder. This is handled pretty much the same way as = the=20 search by city function, but this time you search the real = estate record=20 database for the auction field =3D yes.=20 Results is an list array. Each line containing thumbnail picture if = there=20 is picture with that real estate record and street address and = starting bid=20 price and current bid price with date /time it was make. = Clicking on any=20 line will launch screen showing full real estate data record. = The user can=20 enter his bid price which is saved in the real estate record = along with=20 his user id. After the bid price is updated in the database a = email is sent=20 to the registered owner of that property telling them a bid has = been offered=20 and the bid price. =09 If user is Seller or agent or broker they get 2 options. Every time user login, update the last logged in date and time fields=20 in their membership record. Option 1 =3D delete or edit contents of their membership record.=20 Deleting membership record forces the delete of all=20 associated real estate database records. When user selects delete, reply with message are you=20 sure you want to do this, then delete. Option 2 =3D delete or edit contents of their real estate database = records.=20 Seller is allowed only 1 real estate record. Agent/broker = have no limit on number of real estate = records. Each real=20 estate record will be issued a unique record = number starting at 3525000. Member id + = record number is key to fetch record. If no record then show empty form for user to fill in. Data to capture =3D property address, county/province title/parcel = number, date added in yyyy/mm/dd, total sq ft, lot = dimension, year built in yyyy/mm/dd,=20 about another 30 data fields to be provided later. = Option to include max=20 of 5 jpg pictures which is stored as part of the real = estate record. Provide function to browse user pc = for jpg file location and download jpg file for = addition to real estate record . One picture must be identified as = primary display picture to be displayed with real estate record data. = Other pictures can be seen by user clicking of picture icon which is = part of the displayed=20 real estate screen.=20 Option 3. display activity counter for each read real estate = record.=20 Results is an list array. Each line containing = thumbnail picture=20 if there is picture with that real estate = record and street=20 address and price and count of how many times = this was viewed.=20 There is an special unrestricted Admin user named "Boss" with password = of "robert7734". There is no membership record for this user. = This is hard coded into php included variables. Only the = owner/webmaster will have access to the servers raw .php data=20 file to manually edit these values. Some admin function will be = added later in the development. Admin Option 1. enter user id to select membership record display all = membership record fields including user = type flags, creation date, last = logged on date and time, include ability to display = real estate records. Delete or change content of displayed = real estate records or Delete or change content of displayed = membership record. Admin Option 2. See what is needed during development. =20 Search function (City name search, price range search, zip code search). Any visitor to web site can search database for properties. Results is an list array. Each line containing thumbnail picture if = there is=20 picture with that real estate record and street address and = price. Clicking on=20 any line will launch screen showing full real estate data = record. From detail screen clicking on browser back button = will return to search results screen. Search options =3D show all records matching city, or show all = records matching zip code, or show all = records matching city and price range, or show all = records matching zip code and price range. Any time the detail real estate record is shown add one to the viewed = counter in the record. See www.realtor.com for example of = what I am talking about. =09 Display real estate on auction block. This is handled pretty much the same way as the above search by city = function, but this time you search the real estate record = database for the auction field =3D yes.=20 Results is an list array. Each line containing thumbnail picture if = there is picture=20 with that real estate record and street address and starting = bid price. Clicking on any line will launch screen showing full = real estate data record. From detail screen=20 clicking on back record will return to search results screen. Offline functions. 1. Provide file containing mysql definition statements. 2. Provide command line php script to do mysql backup of each database = used in application. 3. Provide command line php script to do mysql restore of each = database used in application. 4. Provide command line sh shell script to do an tar dump with = compression of each database. 5. Provide command line sh shell script to do an tar restore with = uncompress of each database. 6. Provide command line php script to roll through the membership = database selection all the opt/in members and sent them a email = with message built from text content contained in flat file. 7. Provide command line php script to roll through the membership = database selecting all the seller/agent/brokers members who have = not logged in, in the past 90 days and sent them a email with = message built from text content contained in flat file. Set the valid = email flag so they have to reply to the email to confirm their = email is active and working. 8. Provide command line php script to roll through the membership = database selecting all the seller/agent/brokers members. For each = one access their real estate records to get number times viewed = and sent them a email with message built from text content contained in = flat file showing how many times each property was viewed since = added. General design thoughts. The use of 2 mysql databases is not cast in concrete. Willing to listen = to your recommendations. Open to your recommendations on how best to configure environment to = result in simple URL to point to individual real estate property web = page. www.nnnnnnnnnn.sitedomainname.com where nnnnnnnnnn is the real = estate record number without using dns, or = www.sitedomainname.com/aliasname/nnnnnnnn.=20 =20 If after reading my specifications you have any recommendations or = coding standards or ideas to make things easier or processing faster, I = am willing to discuss them.=20 Phase one includes index.php and Register Customer (Seller or agent or = broker) function, and Registered user login for seller,agent/broker = maintenance function. 1/4 of project cost payable on customer testing = and approval.=20 Phase two all other registration functions and their maintenance = function. 1/8 of project cost payable on customer testing and approval. Phase three all the search functions and auction function. 1/8 of = project cost payable on customer testing and approval. Phase four all remaining functions and offline functions delivered by = target deliver date. 1/8 of project cost payable on customer testing and = approval. 1/8 of project cost payable on customer testing and approval after 60 = days of application stress testing and the fixing of any bugs that come = to light. Final 1/4 of project cost payable on customer accepting complete system = as bug free. All payment will be in USA dollars by check mailed to your post office = mailing address. ------=_NextPart_000_000D_01C6265E.7F2EE980--