Skip to content
This repository has been archived by the owner on Jun 13, 2019. It is now read-only.

readme for ch7 is missing #2

Open
powerblue opened this issue Apr 14, 2014 · 28 comments
Open

readme for ch7 is missing #2

powerblue opened this issue Apr 14, 2014 · 28 comments

Comments

@powerblue
Copy link

No description provided.

@moduscreate
Copy link
Member

Can you please explain? As in "how do i get a server started?"

@powerblue
Copy link
Author

Yes

On Mon, Apr 14, 2014 at 2:46 PM, Modus Create [email protected]:

Can you please explain? As in "how do i get a server started?"


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40403129
.

@powerblue
Copy link
Author

"If you wish to explore the effect of executing the CRUD actions, we
recommend that you follow the instructions in the accompanying readme.txt
file for chapter 7. This file will walk you through how to set up the
database in MySQL and how to configure the accompanying server-side code."

On Mon, Apr 14, 2014 at 2:47 PM, powerblue111 [email protected]:

Yes

On Mon, Apr 14, 2014 at 2:46 PM, Modus Create [email protected]:

Can you please explain? As in "how do i get a server started?"


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40403129
.

@moduscreate
Copy link
Member

Many thanks for that.

@powerblue
Copy link
Author

Will it be available very soon, when?

@jacobandresen
Copy link
Contributor

thanks for noticing @powerblue . I wonder where that file went ? :) Oh well - I put some new notes here: https://github.com/jacobandresen/extjs-in-action-examples/blob/c1dac42fb4d3f85abad3cdd38a6ebfa2d5e8a0e7/examples/ch07/README.txt . Let me know if these work for you ? I am out travelling right now - I'll write some more notes when I get back tomorrow.

@powerblue
Copy link
Author

Could you add more to the README.txt, such as the purpose of the files?:

department.php
employee.php

Thanks

On Tue, Apr 15, 2014 at 5:14 PM, Jacob Andresen [email protected]:

thanks for noticing @powerblue https://github.com/powerblue . I wonder
where that file went ? :) Oh well - I put some new notes here:
https://github.com/jacobandresen/extjs-in-action-examples/blob/c1dac42fb4d3f85abad3cdd38a6ebfa2d5e8a0e7/examples/ch07/README.txt. Let me know if these work for you ? I am out travelling right now - I'll
write some more notes when I get back tomorrow.


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40535226
.

@powerblue
Copy link
Author

Also getting an error after running the sql on a mysql db, and having all the files in the proper folder on the server:

Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50531 Library:50168 in …../public_html/ext4/crud.php on line 2

Warning: Cannot modify header information - headers already sent by (output started at /home/ecigocea/public_html/ext4/crud.php:2) in /…..public_html/ext4/crud.phpon line 144
Ext.data.JsonP.callback1({"data":[{"id":"467","firstName":"Oren","lastName":"Acevedo","middle":"Burton","title":"Dr.","street":"5852 Id Av.","city":"Ann Arbor","state":"CO","zip":"14858","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"09/17/2006","dateFired":null,"dob":"11/22/1955","rate":"115","officePhone":"255-194-9034","homePhone":"476-315-2919","mobilePhone":"260-989-9831","email":"[email protected]"},{"id":"51","firstName":"Brenda","lastName":"Adkins","middle":"Brooke","title":"","street":"4818 Orci. Rd.","city":"Shelton","state":"MD","zip":"08302","departmentId":"2","departmentName":"Advertising","dateHired":"06/29/2000","dateFired":null,"dob":"07/03/1959","rate":"96","officePhone":"937-540-3504","homePhone":"306-521-7288","mobilePhone":"155-553-3463","email":"[email protected]"},{"id":"519","firstName":"Salvador","lastName":"Albert","middle":"Darius","title":"Mrs.","street":"852-2676 Elit, Rd.","city":"West Bend","state":"NM","zip":"24271","departmentId":"11","departmentName":"Public Relations","dateHired":"02/15/2005","dateFired":null,"dob":"07/05/1946","rate":"146","officePhone":"999-193-5761","homePhone":"581-595-8643","mobilePhone":"485-884-6216","email":"[email protected]"},{"id":"560","firstName":"Dean","lastName":"Alexander","middle":"Vanna","title":"Dr.","street":"125-6055 Vitae Street","city":"Yazoo City","state":"RI","zip":"02544","departmentId":"3","departmentName":"Asset Management","dateHired":"01/12/2008","dateFired":null,"dob":"10/08/1958","rate":"120","officePhone":"764-692-9142","homePhone":"949-350-9339","mobilePhone":"299-385-7355","email":"[email protected]"},{"id":"324","firstName":"Tatum","lastName":"Alexander","middle":"Natalie","title":"Dr.","street":"279-3484 Eu Avenue","city":"Klamath Falls","state":"CA","zip":"07763","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"11/26/2004","dateFired":null,"dob":"09/19/1952","rate":"128","officePhone":"702-413-4936","homePhone":"608-150-5183","mobilePhone":"974-357-9397","email":"[email protected]"},{"id":"41","firstName":"Oleg","lastName":"Alford","middle":"Oren","title":"Ms.","street":"742-3735 Euismod Rd.","city":"Mesquite","state":"FL","zip":"22275","departmentId":"1","departmentName":"Accounting","dateHired":"07/19/2008","dateFired":null,"dob":"02/07/1945","rate":"24","officePhone":"177-258-7330","homePhone":"543-290-3534","mobilePhone":"313-772-8486","email":"[email protected]"},{"id":"576","firstName":"Inez","lastName":"Allen","middle":"Willa","title":"Mr.","street":"P.O. Box 579, 7354 Nunc. Rd.","city":"Meridian","state":"KS","zip":"44334","departmentId":"2","departmentName":"Advertising","dateHired":"06/14/2002","dateFired":null,"dob":"03/08/1946","rate":"29","officePhone":"961-591-1834","homePhone":"633-442-5477","mobilePhone":"127-392-7981","email":"[email protected]"},{"id":"529","firstName":"Mari","lastName":"Allen","middle":"Rahim","title":"","street":"309-6242 Et St.","city":"Woodward","state":"MA","zip":"45891","departmentId":"7","departmentName":"Human Resources","dateHired":"03/31/2003","dateFired":null,"dob":"09/08/1986","rate":"66","officePhone":"693-739-2345","homePhone":"699-257-8267","mobilePhone":"275-765-8773","email":"[email protected]"},{"id":"166","firstName":"Dustin","lastName":"Alston","middle":"Zachery","title":"Mrs.","street":"P.O. Box 471, 8056 At Street","city":"Olympia","state":"LA","zip":"97410","departmentId":"8","departmentName":"Legal Department","dateHired":"06/01/2001","dateFired":null,"dob":"03/11/1982","rate":"98","officePhone":"864-112-7393","homePhone":"696-355-7755","mobilePhone":"610-799-9664","email":"[email protected]"},{"id":"169","firstName":"Blake","lastName":"Alvarez","middle":"Lillith","title":"Mrs.","street":"732-4261 Tortor. Rd.","city":"Garden Grove","state":"KY","zip":"80331","departmentId":"10","departmentName":"Payroll","dateHired":"12/21/2002","dateFired":null,"dob":"01/06/1948","rate":"92","officePhone":"272-965-8208","homePhone":"713-190-8976","mobilePhone":"446-789-1549","email":"[email protected]"},{"id":"282","firstName":"Leila","lastName":"Anthony","middle":"Kibo","title":"Mr.","street":"P.O. Box 310, 1674 Mauris. Street","city":"San Marino","state":"MA","zip":"11813","departmentId":"11","departmentName":"Public Relations","dateHired":"04/30/2004","dateFired":null,"dob":"03/23/1941","rate":"115","officePhone":"732-319-2957","homePhone":"150-658-5607","mobilePhone":"284-292-9035","email":"[email protected]"},{"id":"455","firstName":"Christen","lastName":"Atkins","middle":"Wynne","title":"Dr.","street":"855-2894 Ullamcorper. Av.","city":"Sacramento","state":"OK","zip":"77508","departmentId":"7","departmentName":"Human Resources","dateHired":"09/05/2007","dateFired":null,"dob":"05/05/1985","rate":"105","officePhone":"389-488-8433","homePhone":"530-280-7876","mobilePhone":"614-877-1436","email":"[email protected]"},{"id":"527","firstName":"Fleur","lastName":"Austin","middle":"Quincy","title":"Dr.","street":"6775 Ut, St.","city":"Kettering","state":"LA","zip":"09494","departmentId":"14","departmentName":"Research and Development","dateHired":"06/18/2002","dateFired":null,"dob":"07/15/1966","rate":"126","officePhone":"329-819-5532","homePhone":"948-584-7018","mobilePhone":"768-634-3608","email":"[email protected]"},{"id":"397","firstName":"Pamela","lastName":"Austin","middle":"Chester","title":"Mrs.","street":"P.O. Box 354, 6225 Sed Av.","city":"Cedarburg","state":"KY","zip":"29137","departmentId":"9","departmentName":"Media Relations","dateHired":"10/30/2005","dateFired":null,"dob":"11/16/1958","rate":"51","officePhone":"893-411-7367","homePhone":"356-352-8563","mobilePhone":"995-965-9469","email":"[email protected]"},{"id":"256","firstName":"Reese","lastName":"Avery","middle":"Veronica","title":"Ms.","street":"P.O. Box 671, 9435 Vitae Road","city":"Norwich","state":"HI","zip":"58015","departmentId":"11","departmentName":"Public Relations","dateHired":"06/23/2004","dateFired":null,"dob":"08/28/1942","rate":"60","officePhone":"216-596-8304","homePhone":"233-551-7727","mobilePhone":"429-982-9532","email":"[email protected]"},{"id":"203","firstName":"Remedios","lastName":"Avila","middle":"Dylan","title":"","street":"P.O. Box 189, 6619 Ipsum Rd.","city":"Pittston","state":"VA","zip":"68108","departmentId":"15","departmentName":"Tech Support","dateHired":"10/14/2001","dateFired":null,"dob":"10/20/1982","rate":"50","officePhone":"859-238-5361","homePhone":"260-886-3184","mobilePhone":"103-242-5708","email":"[email protected]"},{"id":"449","firstName":"Dorian","lastName":"Baker","middle":"Martha","title":"","street":"P.O. Box 993, 8443 Nec, Avenue","city":"Hartford","state":"TN","zip":"31610","departmentId":"9","departmentName":"Media Relations","dateHired":"11/22/2008","dateFired":null,"dob":"07/27/1943","rate":"148","officePhone":"245-748-9664","homePhone":"806-131-8476","mobilePhone":"543-979-4319","email":"[email protected]"},{"id":"215","firstName":"Chadwick","lastName":"Ballard","middle":"Lucy","title":"","street":"P.O. Box 187, 7586 Neque Av.","city":"Indio","state":"OH","zip":"97273","departmentId":"11","departmentName":"Public Relations","dateHired":"09/20/2006","dateFired":null,"dob":"01/06/1976","rate":"90","officePhone":"732-540-3200","homePhone":"506-978-7857","mobilePhone":"959-211-3374","email":"[email protected]"},{"id":"150","firstName":"Allen","lastName":"Banks","middle":"Akeem","title":"Ms.","street":"P.O. Box 134, 1967 Nam St.","city":"La Ca\u00f1ada Flintridge","state":"MD","zip":"21290","departmentId":"3","departmentName":"Asset Management","dateHired":"01/04/2002","dateFired":null,"dob":"04/07/1984","rate":"107","officePhone":"589-931-9949","homePhone":"305-681-9839","mobilePhone":"741-487-1153","email":"[email protected]"},{"id":"100","firstName":"Sydnee","lastName":"Banks","middle":"Magee","title":"","street":"P.O. Box 181, 2924 Accumsan Road","city":"Pass Christian","state":"WV","zip":"28606","departmentId":"8","departmentName":"Legal Department","dateHired":"07/09/2003","dateFired":null,"dob":"04/30/1987","rate":"149","officePhone":"734-821-8457","homePhone":"685-657-8166","mobilePhone":"515-817-7031","email":"[email protected]"},{"id":"351","firstName":"Mercedes","lastName":"Barber","middle":"Sage","title":"Ms.","street":"P.O. Box 392, 2108 Duis Road","city":"Gettysburg","state":"CO","zip":"27575","departmentId":"10","departmentName":"Payroll","dateHired":"12/26/2008","dateFired":null,"dob":"09/26/1950","rate":"131","officePhone":"673-542-8334","homePhone":"921-176-7435","mobilePhone":"887-583-7218","email":"[email protected]"},{"id":"7","firstName":"Bert","lastName":"Barker","middle":"Samuel","title":"Mr.","street":"541-7646 Pede. Rd.","city":"Aberdeen","state":"MN","zip":"50468","departmentId":"8","departmentName":"Legal Department","dateHired":"03/31/2006","dateFired":null,"dob":"07/20/1945","rate":"118","officePhone":"947-376-7489","homePhone":"910-274-3741","mobilePhone":"230-860-9314","email":"[email protected]"},{"id":"361","firstName":"Kellie","lastName":"Barker","middle":"Eaton","title":"Dr.","street":"353-508 Sit Avenue","city":"Klamath Falls","state":"OH","zip":"51388","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"04/18/2001","dateFired":null,"dob":"07/17/1980","rate":"79","officePhone":"480-957-6389","homePhone":"650-110-5700","mobilePhone":"496-315-2510","email":"[email protected]"},{"id":"365","firstName":"Dora","lastName":"Barnett","middle":"Courtney","title":"Mr.","street":"Ap #987-956 Erat. Rd.","city":"San Marino","state":"DE","zip":"56057","departmentId":"2","departmentName":"Advertising","dateHired":"03/06/2006","dateFired":null,"dob":"12/03/1973","rate":"118","officePhone":"234-354-2304","homePhone":"495-546-5704","mobilePhone":"490-467-6472","email":"[email protected]"},{"id":"156","firstName":"Autumn","lastName":"Barrera","middle":"Martha","title":"Mr.","street":"Ap #390-4477 Dictum Street","city":"Ann Arbor","state":"ND","zip":"87944","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"07/18/2001","dateFired":null,"dob":"12/31/1975","rate":"99","officePhone":"213-963-3109","homePhone":"895-916-9845","mobilePhone":"643-567-9951","email":"[email protected]"},{"id":"29","firstName":"Germane","lastName":"Barrera","middle":"Cheyenne","title":"Ms.","street":"P.O. Box 160, 238 Amet Avenue","city":"Cape May","state":"WV","zip":"10701","departmentId":"14","departmentName":"Research and Development","dateHired":"08/23/2000","dateFired":null,"dob":"09/16/1988","rate":"104","officePhone":"963-969-7082","homePhone":"855-927-6730","mobilePhone":"689-838-8479","email":"[email protected]"},{"id":"119","firstName":"Britanni","lastName":"Barron","middle":"Zachary","title":"Mrs.","street":"153-4530 Placerat. Rd.","city":"Mission Viejo","state":"WY","zip":"36613","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"12/18/2001","dateFired":null,"dob":"11/13/1954","rate":"66","officePhone":"474-329-1816","homePhone":"365-443-2681","mobilePhone":"904-839-7144","email":"[email protected]"},{"id":"144","firstName":"Tanisha","lastName":"Barton","middle":"Amaya","title":"","street":"Ap #972-9973 Magna, Street","city":"Rolling Hills Estates","state":"CT","zip":"88098","departmentId":"1","departmentName":"Accounting","dateHired":"03/24/2008","dateFired":null,"dob":"06/15/1972","rate":"102","officePhone":"825-909-2028","homePhone":"121-463-4363","mobilePhone":"252-319-3642","email":"[email protected]"},{"id":"103","firstName":"Chancellor","lastName":"Battle","middle":"Wing","title":"Ms.","street":"856-1876 Diam Road","city":"Texas City","state":"UT","zip":"40166","departmentId":"11","departmentName":"Public Relations","dateHired":"08/26/2003","dateFired":null,"dob":"02/12/1958","rate":"70","officePhone":"365-411-5556","homePhone":"673-872-1720","mobilePhone":"381-767-9885","email":"[email protected]"},{"id":"221","firstName":"Malcolm","lastName":"Bauer","middle":"Magee","title":"","street":"3332 Sed, Av.","city":"Huntsville","state":"MO","zip":"24626","departmentId":"15","departmentName":"Tech Support","dateHired":"12/26/2004","dateFired":null,"dob":"09/26/1985","rate":"125","officePhone":"872-343-6149","homePhone":"454-169-9313","mobilePhone":"536-191-3951","email":"[email protected]"},{"id":"76","firstName":"Tara","lastName":"Bauer","middle":"Tasha","title":"Dr.","street":"P.O. Box 335, 6779 Venenatis Road","city":"Johnson City","state":"OR","zip":"35704","departmentId":"8","departmentName":"Legal Department","dateHired":"12/17/2003","dateFired":null,"dob":"09/29/1964","rate":"29","officePhone":"740-695-7016","homePhone":"361-525-5189","mobilePhone":"572-791-8625","email":"[email protected]"},{"id":"194","firstName":"Madeline","lastName":"Baxter","middle":"Jonas","title":"","street":"850-246 Bibendum Av.","city":"Yigo","state":"NY","zip":"43638","departmentId":"1","departmentName":"Accounting","dateHired":"08/29/2006","dateFired":null,"dob":"07/13/1980","rate":"73","officePhone":"411-123-1651","homePhone":"237-168-5242","mobilePhone":"339-741-3971","email":"[email protected]"},{"id":"444","firstName":"Zelenia","lastName":"Baxter","middle":"MacKensie","title":"Ms.","street":"Ap #282-3616 Eget St.","city":"San Juan","state":"DC","zip":"19655","departmentId":"14","departmentName":"Research and Development","dateHired":"10/06/2006","dateFired":null,"dob":"09/19/1975","rate":"69","officePhone":"375-222-6940","homePhone":"400-389-4771","mobilePhone":"856-650-9030","email":"[email protected]"},{"id":"25","firstName":"Patrick","lastName":"Beck","middle":"Illiana","title":"Ms.","street":"P.O. Box 959, 9741 Risus. Av.","city":"Racine","state":"SD","zip":"34110","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"06/11/2001","dateFired":null,"dob":"09/05/1958","rate":"100","officePhone":"770-754-5497","homePhone":"237-862-3891","mobilePhone":"839-317-4585","email":"[email protected]"},{"id":"56","firstName":"Phelan","lastName":"Benjamin","middle":"Blake","title":"Ms.","street":"P.O. Box 635, 9701 Sed Rd.","city":"Rehoboth Beach","state":"GA","zip":"80371","departmentId":"12","departmentName":"Quality Assurance","dateHired":"11/08/2003","dateFired":null,"dob":"06/02/1944","rate":"113","officePhone":"204-103-6032","homePhone":"165-626-7930","mobilePhone":"680-763-8615","email":"[email protected]"},{"id":"147","firstName":"Wyoming","lastName":"Bennett","middle":"Daniel","title":"Mr.","street":"396-7289 Donec Road","city":"Stafford","state":"IN","zip":"16294","departmentId":"11","departmentName":"Public Relations","dateHired":"02/26/2003","dateFired":null,"dob":"08/10/1955","rate":"110","officePhone":"944-572-5659","homePhone":"502-415-6264","mobilePhone":"567-716-9156","email":"[email protected]"},{"id":"343","firstName":"Ross","lastName":"Bentley","middle":"Akeem","title":"Mrs.","street":"Ap #882-5058 Enim. Street","city":"Tampa","state":"MT","zip":"71090","departmentId":"11","departmentName":"Public Relations","dateHired":"11/01/2004","dateFired":null,"dob":"09/20/1974","rate":"33","officePhone":"531-341-8136","homePhone":"289-594-5228","mobilePhone":"738-660-1496","email":"[email protected]"},{"id":"289","firstName":"Kennedy","lastName":"Berger","middle":"Peter","title":"Dr.","street":"P.O. Box 914, 4884 Nec Av.","city":"Paterson","state":"AZ","zip":"15157","departmentId":"8","departmentName":"Legal Department","dateHired":"01/28/2000","dateFired":null,"dob":"02/01/1972","rate":"68","officePhone":"335-406-2340","homePhone":"144-478-9785","mobilePhone":"813-668-5734","email":"[email protected]"},{"id":"172","firstName":"Nevada","lastName":"Berger","middle":"Jason","title":"","street":"303-4568 Ante Road","city":"Canandaigua","state":"HI","zip":"35983","departmentId":"14","departmentName":"Research and Development","dateHired":"06/28/2007","dateFired":null,"dob":"07/30/1948","rate":"41","officePhone":"593-648-2542","homePhone":"438-359-4217","mobilePhone":"904-206-2691","email":"[email protected]"},{"id":"212","firstName":"Yoshio","lastName":"Berry","middle":"Arsenio","title":"Mrs.","street":"7914 Cras St.","city":"Monterey","state":"MI","zip":"38088","departmentId":"15","departmentName":"Tech Support","dateHired":"07/01/2003","dateFired":null,"dob":"02/25/1960","rate":"87","officePhone":"916-128-6692","homePhone":"385-838-4751","mobilePhone":"199-232-8211","email":"[email protected]"},{"id":"201","firstName":"Lillian","lastName":"Best","middle":"Prescott","title":"Ms.","street":"8820 Euismod Ave","city":"Allentown","state":"NC","zip":"74190","departmentId":"3","departmentName":"Asset Management","dateHired":"01/18/2000","dateFired":null,"dob":"03/29/1976","rate":"102","officePhone":"320-795-4508","homePhone":"149-551-9844","mobilePhone":"899-890-3439","email":"[email protected]"},{"id":"568","firstName":"Gage","lastName":"Bird","middle":"Kiara","title":"Mr.","street":"306-6629 Et Street","city":"Gilette","state":"SC","zip":"18387","departmentId":"10","departmentName":"Payroll","dateHired":"07/19/2005","dateFired":null,"dob":"01/24/1972","rate":"94","officePhone":"623-245-1461","homePhone":"490-388-9992","mobilePhone":"644-432-4781","email":"[email protected]"},{"id":"72","firstName":"Kaseem","lastName":"Bishop","middle":"Elmo","title":"","street":"6138 Tellus St.","city":"Syracuse","state":"FL","zip":"90842","departmentId":"2","departmentName":"Advertising","dateHired":"11/01/2000","dateFired":null,"dob":"07/24/1987","rate":"91","officePhone":"705-866-4237","homePhone":"196-481-4529","mobilePhone":"330-767-2916","email":"[email protected]"},{"id":"127","firstName":"Todd","lastName":"Bishop","middle":"Leah","title":"Dr.","street":"509-6443 At, St.","city":"Logan","state":"NJ","zip":"61842","departmentId":"5","departmentName":"Customer Service","dateHired":"05/24/2006","dateFired":null,"dob":"09/03/1979","rate":"70","officePhone":"180-732-7952","homePhone":"526-783-4525","mobilePhone":"196-833-9045","email":"[email protected]"},{"id":"583","firstName":"Paul","lastName":"Blackburn","middle":"Nicholas","title":"Mr.","street":"6277 Cras Rd.","city":"Princeton","state":"DE","zip":"70825","departmentId":"9","departmentName":"Media Relations","dateHired":"10/03/2000","dateFired":null,"dob":"05/11/1959","rate":"84","officePhone":"774-987-3116","homePhone":"424-953-5905","mobilePhone":"775-443-8789","email":"[email protected]"},{"id":"165","firstName":"Raja","lastName":"Blake","middle":"Unity","title":"Mrs.","street":"4886 Etiam Rd.","city":"Stafford","state":"NM","zip":"13959","departmentId":"4","departmentName":"Customer Relations","dateHired":"02/25/2003","dateFired":null,"dob":"03/21/1975","rate":"92","officePhone":"651-937-6064","homePhone":"252-610-4574","mobilePhone":"298-707-8391","email":"[email protected]"},{"id":"84","firstName":"Len","lastName":"Blanchard","middle":"Rogan","title":"Ms.","street":"235-2413 Purus Rd.","city":"Middlebury","state":"HI","zip":"32818","departmentId":"7","departmentName":"Human Resources","dateHired":"06/26/2004","dateFired":null,"dob":"01/21/1947","rate":"140","officePhone":"619-266-9892","homePhone":"843-643-4729","mobilePhone":"267-170-2561","email":"[email protected]"},{"id":"556","firstName":"Hayes","lastName":"Blevins","middle":"Gregory","title":"Mrs.","street":"P.O. Box 174, 164 Vestibulum. Rd.","city":"Johnson City","state":"WY","zip":"70697","departmentId":"9","departmentName":"Media Relations","dateHired":"05/25/2000","dateFired":null,"dob":"06/21/1963","rate":"85","officePhone":"810-446-1181","homePhone":"524-346-7215","mobilePhone":"319-671-6747","email":"[email protected]"},{"id":"404","firstName":"Berk","lastName":"Bonner","middle":"Dora","title":"","street":"9615 Felis Road","city":"Aurora","state":"ND","zip":"97999","departmentId":"8","departmentName":"Legal Department","dateHired":"04/21/2004","dateFired":null,"dob":"07/03/1946","rate":"74","officePhone":"358-572-3239","homePhone":"688-220-1059","mobilePhone":"900-373-6166","email":"[email protected]"},{"id":"224","firstName":"Dawn","lastName":"Booker","middle":"Audrey","title":"Dr.","street":"Ap #446-9999 Velit. St.","city":"Somerville","state":"DC","zip":"52225","departmentId":"12","departmentName":"Quality Assurance","dateHired":"01/24/2006","dateFired":null,"dob":"09/05/1957","rate":"133","officePhone":"176-234-8753","homePhone":"197-223-2617","mobilePhone":"703-967-8050","email":"[email protected]"},{"id":"356","firstName":"Meredith","lastName":"Booker","middle":"Adrienne","title":"Dr.","street":"593-9166 Ornare, Ave","city":"Longview","state":"LA","zip":"81363","departmentId":"12","departmentName":"Quality Assurance","dateHired":"05/03/2002","dateFired":null,"dob":"02/05/1968","rate":"35","officePhone":"943-498-9594","homePhone":"332-754-1415","mobilePhone":"322-278-3882","email":"[email protected]"},{"id":"465","firstName":"Lois","lastName":"Boone","middle":"Amity","title":"Ms.","street":"6540 Ante Ave","city":"Grafton","state":"MN","zip":"35431","departmentId":"3","departmentName":"Asset Management","dateHired":"02/08/2004","dateFired":null,"dob":"01/01/1989","rate":"86","officePhone":"642-797-8002","homePhone":"618-308-4058","mobilePhone":"636-897-5267","email":"[email protected]"},{"id":"472","firstName":"Michelle","lastName":"Booth","middle":"Idola","title":"Ms.","street":"4695 Et Av.","city":"Thiensville","state":"IL","zip":"48897","departmentId":"11","departmentName":"Public Relations","dateHired":"11/12/2002","dateFired":null,"dob":"07/05/1961","rate":"148","officePhone":"366-487-5310","homePhone":"449-933-5981","mobilePhone":"325-265-3524","email":"[email protected]"},{"id":"359","firstName":"Porter","lastName":"Booth","middle":"Irma","title":"Dr.","street":"P.O. Box 539, 7952 Elit, St.","city":"Grass Valley","state":"ME","zip":"38707","departmentId":"14","departmentName":"Research and Development","dateHired":"06/30/2002","dateFired":null,"dob":"04/29/1958","rate":"105","officePhone":"644-856-4636","homePhone":"259-155-3724","mobilePhone":"483-252-4963","email":"[email protected]"},{"id":"383","firstName":"Cara","lastName":"Bowman","middle":"Kaden","title":"Mr.","street":"P.O. Box 760, 8539 Lacus Ave","city":"Philadelphia","state":"ND","zip":"55420","departmentId":"12","departmentName":"Quality Assurance","dateHired":"10/24/2000","dateFired":null,"dob":"08/06/1950","rate":"60","officePhone":"920-586-1344","homePhone":"654-431-9291","mobilePhone":"614-949-2372","email":"[email protected]"},{"id":"473","firstName":"Jin","lastName":"Boyd","middle":"Stone","title":"Mr.","street":"603-9951 Donec Road","city":"Fond du Lac","state":"MD","zip":"67206","departmentId":"2","departmentName":"Advertising","dateHired":"01/21/2006","dateFired":null,"dob":"07/25/1974","rate":"18","officePhone":"877-990-9966","homePhone":"915-415-8976","mobilePhone":"379-765-8307","email":"[email protected]"},{"id":"200","firstName":"Zia","lastName":"Boyd","middle":"Martena","title":"Mrs.","street":"902-3938 In Road","city":"Texas City","state":"IA","zip":"55096","departmentId":"7","departmentName":"Human Resources","dateHired":"05/31/2003","dateFired":null,"dob":"09/25/1947","rate":"84","officePhone":"519-770-1410","homePhone":"446-228-8321","mobilePhone":"247-387-8880","email":"[email protected]"},{"id":"421","firstName":"Summer","lastName":"Boyer","middle":"Aphrodite","title":"Mr.","street":"Ap #419-5598 Parturient Rd.","city":"Galveston","state":"MN","zip":"72735","departmentId":"14","departmentName":"Research and Development","dateHired":"07/06/2006","dateFired":null,"dob":"05/03/1990","rate":"54","officePhone":"594-940-7684","homePhone":"727-446-3521","mobilePhone":"761-793-4807","email":"[email protected]"},{"id":"170","firstName":"Uriel","lastName":"Bradford","middle":"Wallace","title":"Ms.","street":"P.O. Box 382, 7389 A, St.","city":"Kahului","state":"AL","zip":"31022","departmentId":"8","departmentName":"Legal Department","dateHired":"10/26/2005","dateFired":null,"dob":"08/18/1963","rate":"96","officePhone":"420-656-6197","homePhone":"482-460-5391","mobilePhone":"523-376-8545","email":"[email protected]"},{"id":"113","firstName":"Wade","lastName":"Bradshaw","middle":"Geoffrey","title":"Dr.","street":"6203 Arcu. Rd.","city":"Coatesville","state":"DE","zip":"91458","departmentId":"4","departmentName":"Customer Relations","dateHired":"04/13/2001","dateFired":null,"dob":"11/09/1974","rate":"131","officePhone":"632-325-7791","homePhone":"251-533-6100","mobilePhone":"248-663-8670","email":"[email protected]"},{"id":"422","firstName":"Kalia","lastName":"Brady","middle":"Destiny","title":"","street":"582-8764 Quisque Road","city":"Williamsburg","state":"VT","zip":"35918","departmentId":"14","departmentName":"Research and Development","dateHired":"07/12/2004","dateFired":null,"dob":"03/12/1966","rate":"88","officePhone":"466-304-4460","homePhone":"448-815-3055","mobilePhone":"214-542-6522","email":"[email protected]"},{"id":"507","firstName":"Oren","lastName":"Brady","middle":"Kirby","title":"Dr.","street":"Ap #254-3956 Cras Rd.","city":"Minnetonka","state":"AK","zip":"58088","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"12/14/2007","dateFired":null,"dob":"08/01/1942","rate":"85","officePhone":"155-704-1239","homePhone":"847-798-3869","mobilePhone":"616-280-7474","email":"[email protected]"},{"id":"300","firstName":"Claire","lastName":"Branch","middle":"Ifeoma","title":"Mr.","street":"605-289 Integer Ave","city":"Salisbury","state":"CA","zip":"74652","departmentId":"3","departmentName":"Asset Management","dateHired":"01/22/2004","dateFired":null,"dob":"06/04/1987","rate":"57","officePhone":"139-424-7777","homePhone":"909-124-6800","mobilePhone":"529-276-2138","email":"[email protected]"},{"id":"517","firstName":"Shaine","lastName":"Brennan","middle":"Bianca","title":"","street":"6654 Semper. Ave","city":"Montgomery","state":"WI","zip":"66230","departmentId":"7","departmentName":"Human Resources","dateHired":"08/04/2007","dateFired":null,"dob":"12/30/1973","rate":"38","officePhone":"891-520-3609","homePhone":"906-957-1028","mobilePhone":"685-406-8181","email":"[email protected]"},{"id":"135","firstName":"Branden","lastName":"Brewer","middle":"Doris","title":"Mrs.","street":"Ap #150-6266 Ut Rd.","city":"Kenner","state":"SD","zip":"89591","departmentId":"14","departmentName":"Research and Development","dateHired":"09/02/2002","dateFired":null,"dob":"02/15/1961","rate":"109","officePhone":"627-745-4506","homePhone":"923-406-2495","mobilePhone":"947-316-2743","email":"[email protected]"},{"id":"109","firstName":"Winter","lastName":"Brewer","middle":"Jonah","title":"Dr.","street":"570-2422 Pede, Road","city":"Yorba Linda","state":"IN","zip":"44933","departmentId":"1","departmentName":"Accounting","dateHired":"10/08/2004","dateFired":null,"dob":"01/09/1966","rate":"41","officePhone":"276-351-5454","homePhone":"543-887-5656","mobilePhone":"889-735-3644","email":"[email protected]"},{"id":"152","firstName":"Sybill","lastName":"Bright","middle":"Eve","title":"Mrs.","street":"8049 Augue St.","city":"Council Bluffs","state":"IN","zip":"06429","departmentId":"1","departmentName":"Accounting","dateHired":"05/31/2000","dateFired":null,"dob":"06/21/1973","rate":"73","officePhone":"166-601-1819","homePhone":"340-268-5590","mobilePhone":"601-711-4467","email":"[email protected]"},{"id":"259","firstName":"Kay","lastName":"Britt","middle":"Jocelyn","title":"Dr.","street":"P.O. Box 178, 343 Praesent St.","city":"Muskogee","state":"AZ","zip":"99093","departmentId":"7","departmentName":"Human Resources","dateHired":"11/27/2006","dateFired":null,"dob":"07/27/1983","rate":"108","officePhone":"126-649-9557","homePhone":"431-777-4332","mobilePhone":"876-701-7396","email":"[email protected]"},{"id":"305","firstName":"Signe","lastName":"Brock","middle":"Mira","title":"Ms.","street":"P.O. Box 752, 3221 Luctus Av.","city":"Idaho Falls","state":"NY","zip":"58453","departmentId":"10","departmentName":"Payroll","dateHired":"05/15/2008","dateFired":null,"dob":"07/23/1973","rate":"98","officePhone":"426-438-1773","homePhone":"300-277-7011","mobilePhone":"651-918-4860","email":"[email protected]"},{"id":"501","firstName":"Rooney","lastName":"Browning","middle":"Travis","title":"Mr.","street":"2987 Libero Ave","city":"Brooklyn Park","state":"MN","zip":"25184","departmentId":"5","departmentName":"Customer Service","dateHired":"01/06/2000","dateFired":null,"dob":"03/28/1967","rate":"100","officePhone":"656-702-3341","homePhone":"158-860-4543","mobilePhone":"197-201-6225","email":"[email protected]"},{"id":"447","firstName":"Abigail","lastName":"Buckley","middle":"Aline","title":"Mr.","street":"678-6966 Mauris Road","city":"Torrance","state":"LA","zip":"91513","departmentId":"2","departmentName":"Advertising","dateHired":"03/27/2006","dateFired":null,"dob":"02/21/1960","rate":"107","officePhone":"518-977-3142","homePhone":"102-769-8353","mobilePhone":"184-200-6128","email":"[email protected]"},{"id":"314","firstName":"Sigourney","lastName":"Bullock","middle":"Ishmael","title":"Mr.","street":"2279 Ante St.","city":"Midwest City","state":"AZ","zip":"97436","departmentId":"2","departmentName":"Advertising","dateHired":"03/16/2001","dateFired":null,"dob":"05/13/1982","rate":"22","officePhone":"814-856-9596","homePhone":"257-104-8635","mobilePhone":"213-305-1407","email":"[email protected]"},{"id":"571","firstName":"Mariam","lastName":"Burch","middle":"Samuel","title":"Mr.","street":"364-6072 Imperdiet, Street","city":"Gold Beach","state":"SD","zip":"14559","departmentId":"7","departmentName":"Human Resources","dateHired":"09/18/2005","dateFired":null,"dob":"05/17/1965","rate":"115","officePhone":"732-438-3597","homePhone":"300-282-3980","mobilePhone":"378-341-2586","email":"[email protected]"},{"id":"101","firstName":"Paki","lastName":"Burgess","middle":"Mira","title":"Mr.","street":"578-3067 Dolor Avenue","city":"Hoover","state":"NM","zip":"54772","departmentId":"7","departmentName":"Human Resources","dateHired":"01/27/2005","dateFired":null,"dob":"05/09/1977","rate":"126","officePhone":"424-183-8323","homePhone":"354-995-9621","mobilePhone":"589-998-7314","email":"[email protected]"},{"id":"478","firstName":"Blaze","lastName":"Burnett","middle":"Hannah","title":"Mr.","street":"Ap #694-7709 Dui Rd.","city":"Duluth","state":"MA","zip":"07922","departmentId":"14","departmentName":"Research and Development","dateHired":"08/06/2005","dateFired":null,"dob":"02/24/1960","rate":"122","officePhone":"115-872-1194","homePhone":"937-601-8101","mobilePhone":"251-758-8143","email":"[email protected]"},{"id":"69","firstName":"Freya","lastName":"Bush","middle":"Leo","title":"Dr.","street":"P.O. Box 160, 8402 Ac St.","city":"Sugar Land","state":"WI","zip":"11476","departmentId":"8","departmentName":"Legal Department","dateHired":"12/04/2006","dateFired":null,"dob":"02/14/1969","rate":"39","officePhone":"413-265-4006","homePhone":"155-687-8758","mobilePhone":"115-887-1588","email":"[email protected]"},{"id":"597","firstName":"Cameron","lastName":"Caldwell","middle":"Aretha","title":"Mr.","street":"Ap #477-8019 Dolor, Rd.","city":"Roswell","state":"ME","zip":"67798","departmentId":"1","departmentName":"Accounting","dateHired":"05/23/2004","dateFired":null,"dob":"05/25/1950","rate":"47","officePhone":"168-255-1759","homePhone":"525-166-8159","mobilePhone":"357-104-4170","email":"[email protected]"},{"id":"102","firstName":"Aidan","lastName":"Callahan","middle":"Shoshana","title":"Mrs.","street":"Ap #134-7701 Egestas, Av.","city":"Waukegan","state":"NH","zip":"16470","departmentId":"4","departmentName":"Customer Relations","dateHired":"12/06/2005","dateFired":null,"dob":"06/22/1949","rate":"89","officePhone":"876-960-7407","homePhone":"836-655-6891","mobilePhone":"237-228-5874","email":"[email protected]"},{"id":"74","firstName":"Jade","lastName":"Callahan","middle":"Alexander","title":"Ms.","street":"195-3729 Nulla St.","city":"Santa Fe Springs","state":"FL","zip":"28459","departmentId":"15","departmentName":"Tech Support","dateHired":"09/29/2007","dateFired":null,"dob":"10/23/1982","rate":"122","officePhone":"777-342-5233","homePhone":"882-270-9484","mobilePhone":"901-326-6355","email":"[email protected]"},{"id":"468","firstName":"Blaze","lastName":"Camacho","middle":"Jordan","title":"Mrs.","street":"2746 Duis Av.","city":"Beloit","state":"OR","zip":"71282","departmentId":"12","departmentName":"Quality Assurance","dateHired":"12/06/2007","dateFired":null,"dob":"01/19/1973","rate":"108","officePhone":"160-537-5539","homePhone":"611-754-4830","mobilePhone":"344-280-5499","email":"[email protected]"},{"id":"260","firstName":"Erich","lastName":"Cameron","middle":"Evangeline","title":"Ms.","street":"847-6882 Amet Rd.","city":"Melrose","state":"VA","zip":"90990","departmentId":"1","departmentName":"Accounting","dateHired":"03/08/2000","dateFired":null,"dob":"09/27/1972","rate":"143","officePhone":"501-390-2071","homePhone":"477-606-7096","mobilePhone":"553-488-8804","email":"[email protected]"},{"id":"231","firstName":"Freya","lastName":"Cannon","middle":"Raven","title":"Ms.","street":"802-3389 Dis Street","city":"Pittston","state":"NC","zip":"54170","departmentId":"9","departmentName":"Media Relations","dateHired":"08/14/2002","dateFired":null,"dob":"05/06/1945","rate":"26","officePhone":"861-774-1281","homePhone":"737-918-1937","mobilePhone":"478-530-8481","email":"[email protected]"},{"id":"110","firstName":"Tiger","lastName":"Cannon","middle":"Charde","title":"Mr.","street":"413-7679 Condimentum. Road","city":"Rensselaer","state":"UT","zip":"18452","departmentId":"8","departmentName":"Legal Department","dateHired":"09/16/2002","dateFired":null,"dob":"11/18/1967","rate":"139","officePhone":"249-141-2335","homePhone":"137-167-4494","mobilePhone":"560-904-1053","email":"[email protected]"},{"id":"180","firstName":"Price","lastName":"Carey","middle":"Alyssa","title":"Mr.","street":"Ap #444-7569 Dolor. Av.","city":"Gardner","state":"NC","zip":"75166","departmentId":"1","departmentName":"Accounting","dateHired":"11/09/2008","dateFired":null,"dob":"07/08/1961","rate":"101","officePhone":"574-766-5606","homePhone":"411-835-5661","mobilePhone":"865-312-1721","email":"[email protected]"},{"id":"253","firstName":"Wynne","lastName":"Carey","middle":"Gareth","title":"","street":"884-280 Libero. Av.","city":"Kent","state":"NC","zip":"15687","departmentId":"5","departmentName":"Customer Service","dateHired":"11/12/2002","dateFired":null,"dob":"08/17/1961","rate":"85","officePhone":"911-766-8234","homePhone":"455-268-8509","mobilePhone":"562-305-9189","email":"[email protected]"},{"id":"572","firstName":"Brittany","lastName":"Carrillo","middle":"Justin","title":"Mrs.","street":"1788 Tristique Rd.","city":"Signal Hill","state":"DC","zip":"52644","departmentId":"4","departmentName":"Customer Relations","dateHired":"03/30/2007","dateFired":null,"dob":"03/14/1988","rate":"150","officePhone":"586-169-1369","homePhone":"992-893-9890","mobilePhone":"120-304-8242","email":"[email protected]"},{"id":"242","firstName":"Signe","lastName":"Carrillo","middle":"Felicia","title":"Mr.","street":"216-3399 Penatibus Av.","city":"West Valley City","state":"ME","zip":"30844","departmentId":"9","departmentName":"Media Relations","dateHired":"04/30/2007","dateFired":null,"dob":"10/09/1959","rate":"46","officePhone":"244-131-3142","homePhone":"917-916-8652","mobilePhone":"150-653-7839","email":"[email protected]"},{"id":"178","firstName":"Aimee","lastName":"Carroll","middle":"Kevin","title":"Ms.","street":"819-3350 Volutpat. Road","city":"New Haven","state":"SC","zip":"13477","departmentId":"15","departmentName":"Tech Support","dateHired":"11/26/2005","dateFired":null,"dob":"08/14/1952","rate":"121","officePhone":"970-561-2767","homePhone":"659-644-8031","mobilePhone":"219-999-9712","email":"[email protected]"},{"id":"19","firstName":"Colin","lastName":"Carver","middle":"Cally","title":"Mrs.","street":"P.O. Box 462, 9418 Vestibulum St.","city":"Dover","state":"NJ","zip":"74038","departmentId":"6","departmentName":"Finances","dateHired":"05/05/2001","dateFired":null,"dob":"09/02/1971","rate":"139","officePhone":"578-441-5132","homePhone":"889-473-9431","mobilePhone":"713-390-8594","email":"[email protected]"},{"id":"255","firstName":"Amity","lastName":"Chan","middle":"Josephine","title":"Mr.","street":"Ap #626-324 Sit Rd.","city":"Auburn Hills","state":"KY","zip":"56620","departmentId":"12","departmentName":"Quality Assurance","dateHired":"04/03/2000","dateFired":null,"dob":"09/29/1971","rate":"133","officePhone":"565-599-6426","homePhone":"362-585-5451","mobilePhone":"576-578-4383","email":"[email protected]"},{"id":"216","firstName":"Beau","lastName":"Chandler","middle":"Aidan","title":"Mrs.","street":"P.O. Box 227, 3806 Sagittis Rd.","city":"Evanston","state":"ID","zip":"99487","departmentId":"12","departmentName":"Quality Assurance","dateHired":"02/03/2001","dateFired":null,"dob":"11/27/1952","rate":"106","officePhone":"229-865-3561","homePhone":"389-186-7122","mobilePhone":"426-745-3565","email":"[email protected]"},{"id":"369","firstName":"Chaim","lastName":"Chandler","middle":"Stuart","title":"Ms.","street":"3423 Lacus. St.","city":"Boston","state":"MO","zip":"09774","departmentId":"1","departmentName":"Accounting","dateHired":"08/04/2007","dateFired":null,"dob":"10/11/1958","rate":"148","officePhone":"320-438-5828","homePhone":"201-835-8181","mobilePhone":"377-725-2919","email":"[email protected]"},{"id":"3","firstName":"Shoshana","lastName":"Chaney","middle":"Kalia","title":"Ms.","street":"2511 Morbi Avenue","city":"Fallon","state":"FL","zip":"87474","departmentId":"7","departmentName":"Human Resources","dateHired":"09/28/2004","dateFired":null,"dob":"10/13/1960","rate":"82","officePhone":"138-755-9887","homePhone":"180-916-9243","mobilePhone":"593-279-5102","email":"arcu.Vestibulum@cubiliaCurae;.ca"},{"id":"341","firstName":"Ashton","lastName":"Chang","middle":"Nigel","title":"Mr.","street":"P.O. Box 584, 6888 Ac, St.","city":"Missoula","state":"CA","zip":"89077","departmentId":"1","departmentName":"Accounting","dateHired":"06/13/2003","dateFired":null,"dob":"06/13/1967","rate":"133","officePhone":"732-937-4194","homePhone":"477-321-5879","mobilePhone":"119-611-6741","email":"[email protected]"},{"id":"406","firstName":"Linus","lastName":"Charles","middle":"MacKenzie","title":"Mrs.","street":"P.O. Box 912, 6827 Imperdiet Av.","city":"Lawndale","state":"SD","zip":"15150","departmentId":"8","departmentName":"Legal Department","dateHired":"01/22/2005","dateFired":null,"dob":"02/22/1972","rate":"88","officePhone":"762-441-2801","homePhone":"354-767-1840","mobilePhone":"837-848-1008","email":"[email protected]"},{"id":"154","firstName":"Stacey","lastName":"Chavez","middle":"Tashya","title":"Mr.","street":"7798 Pellentesque. Street","city":"Dana Point","state":"ME","zip":"58041","departmentId":"11","departmentName":"Public Relations","dateHired":"11/06/2004","dateFired":null,"dob":"05/17/1970","rate":"29","officePhone":"749-877-7685","homePhone":"272-480-9359","mobilePhone":"261-857-2573","email":"[email protected]"},{"id":"157","firstName":"Ulla","lastName":"Chavez","middle":"Madeline","title":"Mrs.","street":"770 Mollis St.","city":"Kahului","state":"ME","zip":"40529","departmentId":"6","departmentName":"Finances","dateHired":"12/03/2003","dateFired":null,"dob":"12/16/1959","rate":"41","officePhone":"927-842-9432","homePhone":"423-609-7065","mobilePhone":"742-598-7743","email":"[email protected]"},{"id":"567","firstName":"Mason","lastName":"Chen","middle":"Kieran","title":"Ms.","street":"P.O. Box 610, 4825 Vel Road","city":"Bakersfield","state":"ME","zip":"69272","departmentId":"10","departmentName":"Payroll","dateHired":"10/03/2008","dateFired":null,"dob":"05/09/1953","rate":"140","officePhone":"893-194-6862","homePhone":"777-760-4478","mobilePhone":"957-933-8285","email":"[email protected]"},{"id":"91","firstName":"Rashad","lastName":"Chen","middle":"Roary","title":"","street":"Ap #720-1827 Nunc Av.","city":"Burlington","state":"AL","zip":"60223","departmentId":"5","departmentName":"Customer Service","dateHired":"04/27/2001","dateFired":null,"dob":"12/22/1975","rate":"130","officePhone":"776-998-1060","homePhone":"947-905-4900","mobilePhone":"692-260-2578","email":"[email protected]"},{"id":"540","firstName":"Jarrod","lastName":"Cherry","middle":"Victoria","title":"Mr.","street":"Ap #860-134 Phasellus St.","city":"Oneida","state":"TN","zip":"37775","departmentId":"2","departmentName":"Advertising","dateHired":"11/19/2007","dateFired":null,"dob":"09/15/1965","rate":"62","officePhone":"526-909-6715","homePhone":"151-843-5637","mobilePhone":"819-267-1733","email":"[email protected]"},{"id":"498","firstName":"Nissim","lastName":"Christian","middle":"Aimee","title":"Ms.","street":"Ap #537-9480 Eget Street","city":"San Jose","state":"FL","zip":"01807","departmentId":"5","departmentName":"Customer Service","dateHired":"04/10/2004","dateFired":null,"dob":"02/20/1990","rate":"43","officePhone":"245-890-2741","homePhone":"792-254-5799","mobilePhone":"798-932-3408","email":"[email protected]"},{"id":"184","firstName":"Camille","lastName":"Church","middle":"Kuame","title":"Mr.","street":"921-7171 Egestas Av.","city":"Monterey Park","state":"NE","zip":"16997","departmentId":"2","departmentName":"Advertising","dateHired":"11/13/2003","dateFired":null,"dob":"10/21/1985","rate":"22","officePhone":"224-655-3796","homePhone":"974-784-3687","mobilePhone":"660-835-2125","email":"[email protected]"},{"id":"463","firstName":"Katelyn","lastName":"Clark","middle":"Zenaida","title":"","street":"2134 Fringilla Road","city":"Artesia","state":"DE","zip":"45423","departmentId":"3","departmentName":"Asset Management","dateHired":"01/28/2007","dateFired":null,"dob":"06/23/1941","rate":"125","officePhone":"383-527-8115","homePhone":"297-182-2896","mobilePhone":"869-383-1268","email":"[email protected]"},{"id":"6","firstName":"Quon","lastName":"Clarke","middle":"Kim","title":"Ms.","street":"1561 Sem Rd.","city":"Steubenville","state":"CT","zip":"08912","departmentId":"14","departmentName":"Research and Development","dateHired":"01/15/2008","dateFired":null,"dob":"08/02/1958","rate":"83","officePhone":"765-651-3761","homePhone":"704-161-2891","mobilePhone":"285-853-4436","email":"[email protected]"},{"id":"584","firstName":"Emmanuel","lastName":"Clements","middle":"Knox","title":"","street":"359-5395 Gravida Road","city":"Truth or Consequences","state":"AK","zip":"28899","departmentId":"12","departmentName":"Quality Assurance","dateHired":"09/19/2000","dateFired":null,"dob":"07/15/1982","rate":"43","officePhone":"549-432-7867","homePhone":"106-797-2665","mobilePhone":"280-771-9509","email":"[email protected]"},{"id":"389","firstName":"Farrah","lastName":"Clemons","middle":"TaShya","title":"Dr.","street":"1161 Enim Street","city":"Yukon","state":"MS","zip":"70778","departmentId":"9","departmentName":"Media Relations","dateHired":"12/03/2003","dateFired":null,"dob":"01/28/1984","rate":"37","officePhone":"231-624-8074","homePhone":"661-556-4423","mobilePhone":"941-754-5244","email":"[email protected]"},{"id":"535","firstName":"Joelle","lastName":"Cleveland","middle":"Laurel","title":"","street":"234-364 Mollis. Ave","city":"Monterey Park","state":"IL","zip":"76445","departmentId":"9","departmentName":"Media Relations","dateHired":"04/18/2002","dateFired":null,"dob":"02/20/1980","rate":"58","officePhone":"258-798-2493","homePhone":"258-908-3346","mobilePhone":"969-612-3959","email":"[email protected]"},{"id":"342","firstName":"Venus","lastName":"Cline","middle":"Dennis","title":"","street":"681-4719 Duis Street","city":"Frisco","state":"FL","zip":"29518","departmentId":"11","departmentName":"Public Relations","dateHired":"07/05/2001","dateFired":null,"dob":"11/29/1958","rate":"135","officePhone":"145-751-3698","homePhone":"602-563-8007","mobilePhone":"878-570-5980","email":"[email protected]"},{"id":"325","firstName":"Ariel","lastName":"Cochran","middle":"Carter","title":"Mr.","street":"P.O. Box 107, 4018 Tristique Rd.","city":"Kansas City","state":"GA","zip":"22439","departmentId":"4","departmentName":"Customer Relations","dateHired":"04/17/2002","dateFired":null,"dob":"05/11/1943","rate":"24","officePhone":"225-804-9139","homePhone":"996-300-7022","mobilePhone":"782-862-2592","email":"[email protected]"},{"id":"133","firstName":"Kaseem","lastName":"Cohen","middle":"Olga","title":"","street":"P.O. Box 299, 8004 Et St.","city":"Moorhead","state":"CT","zip":"69317","departmentId":"15","departmentName":"Tech Support","dateHired":"03/05/2006","dateFired":null,"dob":"01/28/1988","rate":"121","officePhone":"691-163-9587","homePhone":"649-935-5381","mobilePhone":"457-193-4462","email":"[email protected]"},{"id":"268","firstName":"Brennan","lastName":"Cole","middle":"Chaim","title":"Dr.","street":"Ap #786-2495 Odio. Street","city":"Oak Ridge","state":"NJ","zip":"35262","departmentId":"9","departmentName":"Media Relations","dateHired":"10/27/2004","dateFired":null,"dob":"03/11/1984","rate":"127","officePhone":"937-703-7915","homePhone":"987-322-7570","mobilePhone":"237-824-3210","email":"[email protected]"},{"id":"238","firstName":"Blake","lastName":"Coleman","middle":"Aileen","title":"","street":"6748 Accumsan Road","city":"Commerce","state":"ND","zip":"88106","departmentId":"5","departmentName":"Customer Service","dateHired":"01/11/2001","dateFired":null,"dob":"03/24/1972","rate":"106","officePhone":"508-527-6062","homePhone":"536-748-5428","mobilePhone":"805-744-7435","email":"[email protected]"},{"id":"168","firstName":"Rigel","lastName":"Collier","middle":"Alexa","title":"","street":"P.O. Box 668, 5745 Nunc Av.","city":"Waco","state":"MT","zip":"50113","departmentId":"8","departmentName":"Legal Department","dateHired":"09/22/2005","dateFired":null,"dob":"11/18/1951","rate":"63","officePhone":"119-660-4400","homePhone":"667-653-4106","mobilePhone":"581-302-3462","email":"[email protected]"},{"id":"593","firstName":"Sylvester","lastName":"Colon","middle":"Leigh","title":"Mrs.","street":"P.O. Box 239, 2754 A, Street","city":"Idabel","state":"UT","zip":"47540","departmentId":"12","departmentName":"Quality Assurance","dateHired":"10/08/2008","dateFired":null,"dob":"03/23/1964","rate":"75","officePhone":"636-656-6475","homePhone":"402-414-2540","mobilePhone":"194-850-9027","email":"[email protected]"},{"id":"418","firstName":"Zeus","lastName":"Colon","middle":"Emma","title":"Ms.","street":"P.O. Box 145, 7176 Interdum. Avenue","city":"Cape May","state":"AZ","zip":"86786","departmentId":"3","departmentName":"Asset Management","dateHired":"04/25/2006","dateFired":null,"dob":"06/29/1975","rate":"110","officePhone":"181-476-5506","homePhone":"465-351-5035","mobilePhone":"424-339-7258","email":"[email protected]"},{"id":"485","firstName":"Clayton","lastName":"Cooper","middle":"Stacy","title":"Ms.","street":"Ap #828-5365 Semper Avenue","city":"Barrow","state":"SC","zip":"25951","departmentId":"12","departmentName":"Quality Assurance","dateHired":"11/30/2008","dateFired":null,"dob":"09/05/1976","rate":"132","officePhone":"297-313-9310","homePhone":"380-164-1753","mobilePhone":"886-732-7283","email":"[email protected]"},{"id":"175","firstName":"Darius","lastName":"Cortez","middle":"Malcolm","title":"Mrs.","street":"8868 Maecenas Road","city":"Houma","state":"DE","zip":"95870","departmentId":"1","departmentName":"Accounting","dateHired":"10/08/2006","dateFired":null,"dob":"03/28/1946","rate":"74","officePhone":"387-123-1827","homePhone":"543-332-5910","mobilePhone":"883-698-8429","email":"[email protected]"},{"id":"548","firstName":"Beck","lastName":"Cote","middle":"Quincy","title":"Mr.","street":"921 Sed, Street","city":"Saint Albans","state":"AL","zip":"85540","departmentId":"12","departmentName":"Quality Assurance","dateHired":"10/06/2003","dateFired":null,"dob":"12/14/1980","rate":"97","officePhone":"717-601-7255","homePhone":"113-204-5597","mobilePhone":"563-507-8746","email":"[email protected]"},{"id":"311","firstName":"Lavinia","lastName":"Craig","middle":"Cynthia","title":"","street":"Ap #492-1825 Semper St.","city":"Stevens Point","state":"WY","zip":"95443","departmentId":"9","departmentName":"Media Relations","dateHired":"10/11/2008","dateFired":null,"dob":"03/31/1984","rate":"70","officePhone":"343-405-1794","homePhone":"620-238-3823","mobilePhone":"268-518-4472","email":"[email protected]"},{"id":"271","firstName":"Armando","lastName":"Crawford","middle":"Kimberley","title":"Mrs.","street":"P.O. Box 589, 3731 Suspendisse Avenue","city":"Raleigh","state":"NE","zip":"34766","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"03/01/2004","dateFired":null,"dob":"08/20/1985","rate":"17","officePhone":"494-930-3245","homePhone":"971-603-3929","mobilePhone":"902-146-6258","email":"[email protected]"},{"id":"176","firstName":"Farrah","lastName":"Cruz","middle":"Kyra","title":"","street":"416-6219 Integer Street","city":"Pueblo","state":"IL","zip":"47232","departmentId":"2","departmentName":"Advertising","dateHired":"04/28/2000","dateFired":null,"dob":"06/30/1954","rate":"27","officePhone":"879-795-8598","homePhone":"336-318-3477","mobilePhone":"419-331-4525","email":"[email protected]"},{"id":"248","firstName":"Nissim","lastName":"Cummings","middle":"Wanda","title":"Ms.","street":"Ap #933-4616 Per St.","city":"Scottsbluff","state":"MN","zip":"42643","departmentId":"1","departmentName":"Accounting","dateHired":"09/07/2005","dateFired":null,"dob":"01/02/1961","rate":"81","officePhone":"762-301-1184","homePhone":"754-513-4612","mobilePhone":"479-133-5996","email":"[email protected]"},{"id":"436","firstName":"Brady","lastName":"Cunningham","middle":"Teagan","title":"Mr.","street":"454-4402 Nunc Rd.","city":"Minnetonka","state":"VT","zip":"79980","departmentId":"6","departmentName":"Finances","dateHired":"02/07/2005","dateFired":null,"dob":"06/29/1966","rate":"135","officePhone":"581-420-9742","homePhone":"209-545-4242","mobilePhone":"288-517-9273","email":"[email protected]"},{"id":"533","firstName":"Candice","lastName":"Curtis","middle":"Sylvester","title":"Mr.","street":"P.O. Box 439, 899 Phasellus Avenue","city":"Carbondale","state":"IL","zip":"02803","departmentId":"2","departmentName":"Advertising","dateHired":"12/08/2003","dateFired":null,"dob":"05/16/1990","rate":"112","officePhone":"679-471-4541","homePhone":"207-814-9048","mobilePhone":"432-151-2228","email":"[email protected]"},{"id":"270","firstName":"Axel","lastName":"Dale","middle":"Reuben","title":"Ms.","street":"989-2798 Nunc Rd.","city":"Barre","state":"TX","zip":"21031","departmentId":"4","departmentName":"Customer Relations","dateHired":"08/19/2004","dateFired":null,"dob":"02/24/1987","rate":"48","officePhone":"353-484-6960","homePhone":"132-350-2492","mobilePhone":"892-104-6622","email":"[email protected]"},{"id":"164","firstName":"Brynn","lastName":"Dalton","middle":"Larissa","title":"Dr.","street":"1036 Porttitor Ave","city":"Little Falls","state":"WV","zip":"52005","departmentId":"15","departmentName":"Tech Support","dateHired":"10/06/2006","dateFired":null,"dob":"10/23/1980","rate":"15","officePhone":"295-544-8609","homePhone":"853-246-8980","mobilePhone":"871-356-4435","email":"[email protected]"},{"id":"293","firstName":"Aileen","lastName":"Daniels","middle":"Stephen","title":"Dr.","street":"218-2734 Risus. St.","city":"Stockton","state":"MT","zip":"86928","departmentId":"15","departmentName":"Tech Support","dateHired":"10/19/2000","dateFired":null,"dob":"05/10/1969","rate":"110","officePhone":"102-566-1470","homePhone":"223-126-2813","mobilePhone":"197-233-9956","email":"[email protected]"},{"id":"90","firstName":"Sylvester","lastName":"David","middle":"Colleen","title":"Dr.","street":"391-8233 Magna. Street","city":"Pueblo","state":"NJ","zip":"62056","departmentId":"9","departmentName":"Media Relations","dateHired":"02/05/2003","dateFired":null,"dob":"10/26/1948","rate":"141","officePhone":"728-170-7735","homePhone":"225-246-5181","mobilePhone":"579-278-7687","email":"[email protected]"},{"id":"86","firstName":"Ulric","lastName":"Davis","middle":"Jenna","title":"Dr.","street":"P.O. Box 397, 3905 Ante Street","city":"Glen Cove","state":"NE","zip":"92252","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"06/08/2004","dateFired":null,"dob":"01/16/1954","rate":"71","officePhone":"884-149-6607","homePhone":"390-424-2580","mobilePhone":"986-277-4047","email":"[email protected]"},{"id":"338","firstName":"Asher","lastName":"Dawson","middle":"Raymond","title":"","street":"8285 Arcu Ave","city":"Fort Wayne","state":"IL","zip":"72267","departmentId":"8","departmentName":"Legal Department","dateHired":"09/18/2004","dateFired":null,"dob":"12/26/1974","rate":"84","officePhone":"370-565-3660","homePhone":"328-345-2055","mobilePhone":"189-468-2320","email":"[email protected]"},{"id":"358","firstName":"Logan","lastName":"Day","middle":"Kelly","title":"Mrs.","street":"P.O. Box 895, 188 Turpis Ave","city":"Independence","state":"WY","zip":"69064","departmentId":"7","departmentName":"Human Resources","dateHired":"03/29/2003","dateFired":null,"dob":"03/25/1953","rate":"92","officePhone":"831-272-2565","homePhone":"366-568-8321","mobilePhone":"413-693-9781","email":"[email protected]"},{"id":"503","firstName":"Martina","lastName":"Dean","middle":"Bianca","title":"Dr.","street":"P.O. Box 388, 378 Bibendum Avenue","city":"Erie","state":"IL","zip":"95172","departmentId":"15","departmentName":"Tech Support","dateHired":"07/31/2004","dateFired":null,"dob":"08/22/1983","rate":"46","officePhone":"532-279-8292","homePhone":"600-901-3273","mobilePhone":"373-292-6517","email":"[email protected]"},{"id":"266","firstName":"Bell","lastName":"Delacruz","middle":"Nero","title":"Mrs.","street":"P.O. Box 944, 6171 Turpis Avenue","city":"Frisco","state":"MO","zip":"86741","departmentId":"15","departmentName":"Tech Support","dateHired":"10/20/2002","dateFired":null,"dob":"07/02/1971","rate":"130","officePhone":"603-482-5918","homePhone":"836-164-8784","mobilePhone":"497-392-2235","email":"[email protected]"},{"id":"38","firstName":"Aimee","lastName":"Deleon","middle":"Carl","title":"Mrs.","street":"1336 Convallis Ave","city":"North Tonawanda","state":"ME","zip":"60812","departmentId":"7","departmentName":"Human Resources","dateHired":"07/26/2002","dateFired":null,"dob":"08/08/1962","rate":"149","officePhone":"833-433-3192","homePhone":"735-753-1576","mobilePhone":"101-119-6258","email":"[email protected]"},{"id":"388","firstName":"Lillith","lastName":"Deleon","middle":"Austin","title":"Mr.","street":"Ap #824-8195 Lacinia Ave","city":"Enfield","state":"CA","zip":"88497","departmentId":"9","departmentName":"Media Relations","dateHired":"04/05/2006","dateFired":null,"dob":"02/20/1984","rate":"90","officePhone":"554-805-2219","homePhone":"846-571-7649","mobilePhone":"676-408-8291","email":"[email protected]"},{"id":"558","firstName":"Brynn","lastName":"Dillard","middle":"Wilma","title":"Mrs.","street":"Ap #571-7595 A Rd.","city":"Sunbury","state":"DE","zip":"82155","departmentId":"15","departmentName":"Tech Support","dateHired":"12/18/2007","dateFired":null,"dob":"11/09/1977","rate":"17","officePhone":"327-145-3773","homePhone":"678-408-6043","mobilePhone":"269-144-3575","email":"[email protected]"},{"id":"504","firstName":"Rinah","lastName":"Dillon","middle":"Mercedes","title":"Ms.","street":"P.O. Box 913, 3778 Libero Road","city":"Durango","state":"HI","zip":"47043","departmentId":"3","departmentName":"Asset Management","dateHired":"03/04/2007","dateFired":null,"dob":"10/05/1942","rate":"40","officePhone":"564-657-6415","homePhone":"853-878-7107","mobilePhone":"172-689-8759","email":"[email protected]"},{"id":"559","firstName":"Darryl","lastName":"Dixon","middle":"Noble","title":"Ms.","street":"Ap #774-9503 Nisl Street","city":"Hanahan","state":"IL","zip":"41524","departmentId":"12","departmentName":"Quality Assurance","dateHired":"04/21/2004","dateFired":null,"dob":"10/20/1948","rate":"131","officePhone":"208-375-5608","homePhone":"858-852-6810","mobilePhone":"443-699-2525","email":"[email protected]"},{"id":"591","firstName":"Jenette","lastName":"Dixon","middle":"Sydney","title":"Ms.","street":"5239 Accumsan St.","city":"Morgantown","state":"ME","zip":"04464","departmentId":"5","departmentName":"Customer Service","dateHired":"08/13/2005","dateFired":null,"dob":"10/31/1986","rate":"102","officePhone":"664-678-7197","homePhone":"938-830-3667","mobilePhone":"159-508-6756","email":"[email protected]"},{"id":"333","firstName":"Denton","lastName":"Dotson","middle":"Damian","title":"Ms.","street":"8815 Quam Avenue","city":"Vermillion","state":"NC","zip":"11288","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"11/29/2000","dateFired":null,"dob":"12/07/1976","rate":"94","officePhone":"108-598-4432","homePhone":"785-396-8905","mobilePhone":"427-255-7434","email":"[email protected]"},{"id":"302","firstName":"Fulton","lastName":"Dotson","middle":"Bradley","title":"Mr.","street":"P.O. Box 730, 6710 Elit Ave","city":"Berlin","state":"NV","zip":"98744","departmentId":"8","departmentName":"Legal Department","dateHired":"11/01/2005","dateFired":null,"dob":"10/15/1968","rate":"108","officePhone":"910-832-3329","homePhone":"921-906-7648","mobilePhone":"299-759-6432","email":"[email protected]"},{"id":"50","firstName":"Magee","lastName":"Douglas","middle":"Christian","title":"","street":"442-3202 Varius. St.","city":"New Haven","state":"WY","zip":"37576","departmentId":"8","departmentName":"Legal Department","dateHired":"06/02/2004","dateFired":null,"dob":"12/19/1973","rate":"134","officePhone":"988-705-9584","homePhone":"261-707-7191","mobilePhone":"721-645-5497","email":"[email protected]"},{"id":"108","firstName":"Harriet","lastName":"Doyle","middle":"Jaime","title":"","street":"6150 Lorem, Rd.","city":"Richmond","state":"CT","zip":"99081","departmentId":"3","departmentName":"Asset Management","dateHired":"12/14/2003","dateFired":null,"dob":"07/07/1959","rate":"16","officePhone":"148-491-3028","homePhone":"664-370-6370","mobilePhone":"384-292-5432","email":"[email protected]"},{"id":"368","firstName":"Candice","lastName":"Drake","middle":"Cullen","title":"Ms.","street":"Ap #235-5920 Malesuada Av.","city":"Moraga","state":"MA","zip":"53213","departmentId":"7","departmentName":"Human Resources","dateHired":"12/13/2005","dateFired":null,"dob":"08/19/1949","rate":"33","officePhone":"815-514-5872","homePhone":"692-401-1351","mobilePhone":"925-187-4321","email":"[email protected]"},{"id":"490","firstName":"Neil","lastName":"Duke","middle":"Larissa","title":"Dr.","street":"754-5051 Penatibus St.","city":"Bandon","state":"KS","zip":"62926","departmentId":"12","departmentName":"Quality Assurance","dateHired":"08/04/2001","dateFired":null,"dob":"05/30/1961","rate":"78","officePhone":"453-187-1103","homePhone":"780-725-9026","mobilePhone":"367-284-4259","email":"[email protected]"},{"id":"460","firstName":"Sopoline","lastName":"Duke","middle":"Matthew","title":"Mr.","street":"Ap #281-2211 Natoque Ave","city":"Rensselaer","state":"MI","zip":"21787","departmentId":"9","departmentName":"Media Relations","dateHired":"01/23/2007","dateFired":null,"dob":"07/16/1989","rate":"49","officePhone":"666-343-6079","homePhone":"171-395-1457","mobilePhone":"129-959-4159","email":"[email protected]"},{"id":"177","firstName":"Stephanie","lastName":"Duke","middle":"Maile","title":"Ms.","street":"P.O. Box 103, 2263 Lectus Avenue","city":"Miami Gardens","state":"LA","zip":"63400","departmentId":"12","departmentName":"Quality Assurance","dateHired":"05/08/2001","dateFired":null,"dob":"06/23/1987","rate":"68","officePhone":"621-406-4399","homePhone":"559-523-1862","mobilePhone":"902-684-7940","email":"[email protected]"},{"id":"470","firstName":"Whitney","lastName":"Duke","middle":"Hanna","title":"Ms.","street":"4792 Semper Ave","city":"Greensburg","state":"ID","zip":"46979","departmentId":"8","departmentName":"Legal Department","dateHired":"02/19/2002","dateFired":null,"dob":"11/25/1963","rate":"109","officePhone":"448-909-4878","homePhone":"210-392-9992","mobilePhone":"413-984-4005","email":"[email protected]"},{"id":"8","firstName":"Jordan","lastName":"Dunn","middle":"Whitney","title":"Ms.","street":"484-4101 Sed Av.","city":"Rockville","state":"VA","zip":"30691","departmentId":"2","departmentName":"Advertising","dateHired":"10/15/2000","dateFired":null,"dob":"06/23/1986","rate":"100","officePhone":"633-809-6712","homePhone":"247-708-4167","mobilePhone":"587-780-7118","email":"[email protected]"},{"id":"214","firstName":"Kimberly","lastName":"Duran","middle":"Deanna","title":"Ms.","street":"P.O. Box 635, 1006 Felis Av.","city":"Fremont","state":"IL","zip":"85377","departmentId":"4","departmentName":"Customer Relations","dateHired":"08/05/2003","dateFired":null,"dob":"11/24/1960","rate":"34","officePhone":"556-900-2918","homePhone":"949-476-9147","mobilePhone":"557-587-3072","email":"[email protected]"},{"id":"237","firstName":"Len","lastName":"Eaton","middle":"Brian","title":"Ms.","street":"6812 Magna. Av.","city":"Charlottesville","state":"IL","zip":"71682","departmentId":"12","departmentName":"Quality Assurance","dateHired":"07/11/2003","dateFired":null,"dob":"02/11/1960","rate":"68","officePhone":"247-396-1120","homePhone":"857-348-2016","mobilePhone":"345-128-8272","email":"[email protected]"},{"id":"196","firstName":"Palmer","lastName":"Elliott","middle":"Dana","title":"Mrs.","street":"1518 Purus. St.","city":"Ponce","state":"MT","zip":"57266","departmentId":"11","departmentName":"Public Relations","dateHired":"08/21/2007","dateFired":null,"dob":"06/22/1968","rate":"43","officePhone":"900-486-5882","homePhone":"573-750-1992","mobilePhone":"584-898-8080","email":"[email protected]"},{"id":"104","firstName":"Felix","lastName":"Ellison","middle":"Ramona","title":"Dr.","street":"Ap #943-9028 Dolor. Rd.","city":"West Sacramento","state":"RI","zip":"60610","departmentId":"15","departmentName":"Tech Support","dateHired":"04/20/2005","dateFired":null,"dob":"01/04/1942","rate":"117","officePhone":"198-527-3621","homePhone":"612-119-3982","mobilePhone":"283-969-7751","email":"[email protected]"},{"id":"439","firstName":"Porter","lastName":"Ellison","middle":"Luke","title":"Ms.","street":"9739 Et St.","city":"Clarksburg","state":"LA","zip":"56400","departmentId":"1","departmentName":"Accounting","dateHired":"03/03/2001","dateFired":null,"dob":"11/09/1950","rate":"34","officePhone":"699-186-5393","homePhone":"405-983-2622","mobilePhone":"597-841-5106","email":"[email protected]"},{"id":"456","firstName":"Geoffrey","lastName":"England","middle":"Georgia","title":"Ms.","street":"8963 Adipiscing, Street","city":"Boulder City","state":"ID","zip":"04911","departmentId":"12","departmentName":"Quality Assurance","dateHired":"01/30/2004","dateFired":null,"dob":"01/30/1968","rate":"111","officePhone":"638-392-4842","homePhone":"526-334-8357","mobilePhone":"538-808-5860","email":"[email protected]"},{"id":"510","firstName":"Maya","lastName":"English","middle":"McKenzie","title":"","street":"9893 Aenean Road","city":"Shreveport","state":"NE","zip":"49827","departmentId":"8","departmentName":"Legal Department","dateHired":"05/29/2004","dateFired":null,"dob":"05/05/1942","rate":"88","officePhone":"332-989-8597","homePhone":"446-293-8704","mobilePhone":"934-805-8902","email":"[email protected]"},{"id":"432","firstName":"Justin","lastName":"Erickson","middle":"Inez","title":"","street":"Ap #307-5191 Cursus St.","city":"Hutchinson","state":"AZ","zip":"47793","departmentId":"15","departmentName":"Tech Support","dateHired":"10/31/2004","dateFired":null,"dob":"03/01/1942","rate":"131","officePhone":"318-657-3405","homePhone":"942-691-2982","mobilePhone":"482-218-5325","email":"[email protected]"},{"id":"367","firstName":"Phelan","lastName":"Erickson","middle":"Sylvester","title":"Dr.","street":"P.O. Box 337, 4732 Tempus Ave","city":"Beloit","state":"CA","zip":"60199","departmentId":"10","departmentName":"Payroll","dateHired":"03/22/2003","dateFired":null,"dob":"12/30/1945","rate":"105","officePhone":"532-992-2118","homePhone":"107-188-3867","mobilePhone":"370-494-3706","email":"[email protected]"},{"id":"189","firstName":"Stacy","lastName":"Espinoza","middle":"Gwendolyn","title":"Mrs.","street":"P.O. Box 424, 5996 Lacus. St.","city":"Uniontown","state":"DE","zip":"35472","departmentId":"1","departmentName":"Accounting","dateHired":"02/22/2004","dateFired":null,"dob":"10/01/1953","rate":"82","officePhone":"195-186-2047","homePhone":"948-809-6216","mobilePhone":"808-816-7102","email":"[email protected]"},{"id":"153","firstName":"Lee","lastName":"Estrada","middle":"Lacota","title":"Ms.","street":"5221 Lacus, Rd.","city":"Carolina","state":"CT","zip":"35655","departmentId":"5","departmentName":"Customer Service","dateHired":"11/10/2008","dateFired":null,"dob":"09/18/1955","rate":"143","officePhone":"776-944-9075","homePhone":"466-619-1970","mobilePhone":"578-562-7888","email":"[email protected]"},{"id":"26","firstName":"Olympia","lastName":"Ewing","middle":"Rina","title":"Ms.","street":"P.O. Box 312, 5272 Mi Ave","city":"Gardena","state":"FL","zip":"08432","departmentId":"12","departmentName":"Quality Assurance","dateHired":"12/31/2004","dateFired":null,"dob":"07/26/1967","rate":"85","officePhone":"182-254-4026","homePhone":"308-262-5650","mobilePhone":"549-966-7607","email":"[email protected]"},{"id":"158","firstName":"James","lastName":"Farrell","middle":"Mary","title":"Mr.","street":"917-9158 Amet St.","city":"Latrobe","state":"RI","zip":"13854","departmentId":"7","departmentName":"Human Resources","dateHired":"03/20/2007","dateFired":null,"dob":"10/22/1983","rate":"129","officePhone":"161-971-5050","homePhone":"908-313-8790","mobilePhone":"539-262-6881","email":"[email protected]"},{"id":"206","firstName":"Reese","lastName":"Faulkner","middle":"Sierra","title":"","street":"7014 Odio St.","city":"Atwater","state":"NE","zip":"99614","departmentId":"9","departmentName":"Media Relations","dateHired":"01/12/2003","dateFired":null,"dob":"05/10/1967","rate":"17","officePhone":"973-110-6733","homePhone":"771-166-5919","mobilePhone":"876-532-2111","email":"[email protected]"},{"id":"137","firstName":"Amena","lastName":"Ferguson","middle":"Dominic","title":"Dr.","street":"312-6395 Mauris St.","city":"Oak Ridge","state":"GA","zip":"85108","departmentId":"10","departmentName":"Payroll","dateHired":"02/13/2004","dateFired":null,"dob":"06/12/1956","rate":"60","officePhone":"235-545-7465","homePhone":"762-787-6177","mobilePhone":"669-995-7801","email":"[email protected]"},{"id":"120","firstName":"Quinn","lastName":"Fernandez","middle":"Alec","title":"Ms.","street":"Ap #739-2284 At Rd.","city":"Selma","state":"RI","zip":"75802","departmentId":"9","departmentName":"Media Relations","dateHired":"10/23/2002","dateFired":null,"dob":"05/17/1990","rate":"47","officePhone":"177-975-3770","homePhone":"895-627-9012","mobilePhone":"298-535-2146","email":"[email protected]"},{"id":"414","firstName":"Dakota","lastName":"Finch","middle":"Ginger","title":"Dr.","street":"156-2179 Imperdiet, Street","city":"Harrisburg","state":"IN","zip":"24025","departmentId":"1","departmentName":"Accounting","dateHired":"04/24/2001","dateFired":null,"dob":"06/07/1962","rate":"123","officePhone":"492-320-2495","homePhone":"844-226-1867","mobilePhone":"591-121-7140","email":"[email protected]"},{"id":"55","firstName":"Kasper","lastName":"Finch","middle":"Aladdin","title":"Mrs.","street":"Ap #644-1517 Facilisis Road","city":"Tacoma","state":"ND","zip":"81295","departmentId":"2","departmentName":"Advertising","dateHired":"09/14/2007","dateFired":null,"dob":"05/09/1964","rate":"131","officePhone":"164-991-6415","homePhone":"873-658-8586","mobilePhone":"547-421-6457","email":"[email protected]"},{"id":"543","firstName":"Ezekiel","lastName":"Fitzpatrick","middle":"Jeremy","title":"Dr.","street":"864-7719 In Rd.","city":"Winston-Salem","state":"WY","zip":"73498","departmentId":"9","departmentName":"Media Relations","dateHired":"04/20/2001","dateFired":null,"dob":"08/30/1982","rate":"65","officePhone":"232-334-9704","homePhone":"607-397-2248","mobilePhone":"884-163-2618","email":"[email protected]"},{"id":"545","firstName":"Melodie","lastName":"Fleming","middle":"Ursa","title":"Dr.","street":"P.O. Box 826, 9163 Vulputate, Avenue","city":"San Gabriel","state":"CT","zip":"34949","departmentId":"15","departmentName":"Tech Support","dateHired":"01/21/2008","dateFired":null,"dob":"01/28/1982","rate":"66","officePhone":"528-819-7744","homePhone":"799-482-6264","mobilePhone":"441-327-7525","email":"[email protected]"},{"id":"408","firstName":"Myra","lastName":"Fleming","middle":"Sage","title":"Mr.","street":"P.O. Box 348, 6797 Adipiscing. Ave","city":"San Marino","state":"NE","zip":"78768","departmentId":"5","departmentName":"Customer Service","dateHired":"02/07/2007","dateFired":null,"dob":"10/27/1976","rate":"124","officePhone":"254-417-6353","homePhone":"547-996-6556","mobilePhone":"395-870-3143","email":"[email protected]"},{"id":"481","firstName":"Desiree","lastName":"Flores","middle":"Colton","title":"Ms.","street":"Ap #361-4092 Purus. St.","city":"Brookfield","state":"CT","zip":"15884","departmentId":"7","departmentName":"Human Resources","dateHired":"05/16/2005","dateFired":null,"dob":"04/14/1963","rate":"91","officePhone":"516-704-4563","homePhone":"242-311-9948","mobilePhone":"391-819-3927","email":"[email protected]"},{"id":"257","firstName":"Hilda","lastName":"Flynn","middle":"Felix","title":"Ms.","street":"2496 Amet, Ave","city":"Belleville","state":"AK","zip":"70946","departmentId":"15","departmentName":"Tech Support","dateHired":"08/08/2006","dateFired":null,"dob":"11/09/1984","rate":"70","officePhone":"304-679-5579","homePhone":"678-836-6905","mobilePhone":"648-384-6873","email":"[email protected]"},{"id":"471","firstName":"Nicholas","lastName":"Fowler","middle":"Libby","title":"Ms.","street":"805-2284 Pellentesque St.","city":"Chesapeake","state":"NY","zip":"88035","departmentId":"1","departmentName":"Accounting","dateHired":"10/11/2000","dateFired":null,"dob":"03/01/1989","rate":"30","officePhone":"202-936-4362","homePhone":"433-503-4048","mobilePhone":"207-645-6167","email":"[email protected]"},{"id":"462","firstName":"Amal","lastName":"Francis","middle":"Darryl","title":"Mr.","street":"2579 Penatibus Street","city":"Ephraim","state":"MO","zip":"87530","departmentId":"14","departmentName":"Research and Development","dateHired":"12/09/2001","dateFired":null,"dob":"01/21/1965","rate":"21","officePhone":"563-458-3092","homePhone":"229-885-8415","mobilePhone":"687-404-6755","email":"[email protected]"},{"id":"326","firstName":"Hilel","lastName":"Francis","middle":"Ethan","title":"","street":"5322 Montes, Street","city":"Santa Ana","state":"UT","zip":"37920","departmentId":"3","departmentName":"Asset Management","dateHired":"07/29/2002","dateFired":null,"dob":"12/16/1948","rate":"101","officePhone":"542-680-2615","homePhone":"495-453-1402","mobilePhone":"851-131-8770","email":"[email protected]"},{"id":"228","firstName":"Kimberly","lastName":"Franco","middle":"Alvin","title":"Mrs.","street":"P.O. Box 404, 2782 Mauris Street","city":"Garland","state":"RI","zip":"05393","departmentId":"7","departmentName":"Human Resources","dateHired":"05/11/2008","dateFired":null,"dob":"05/28/1952","rate":"111","officePhone":"711-579-3327","homePhone":"821-139-2843","mobilePhone":"407-472-6874","email":"[email protected]"},{"id":"318","firstName":"Buckminster","lastName":"Franklin","middle":"Casey","title":"","street":"500-741 Et St.","city":"Kankakee","state":"NH","zip":"93762","departmentId":"5","departmentName":"Customer Service","dateHired":"04/12/2004","dateFired":null,"dob":"03/02/1980","rate":"74","officePhone":"705-929-6552","homePhone":"328-682-2697","mobilePhone":"664-177-6232","email":"[email protected]"},{"id":"23","firstName":"Ralph","lastName":"Franks","middle":"David","title":"Dr.","street":"P.O. Box 718, 6494 Nostra, Street","city":"Baytown","state":"GA","zip":"78482","departmentId":"7","departmentName":"Human Resources","dateHired":"11/05/2001","dateFired":null,"dob":"09/06/1969","rate":"71","officePhone":"585-288-5258","homePhone":"582-471-3361","mobilePhone":"743-600-2215","email":"[email protected]"},{"id":"211","firstName":"Baker","lastName":"Frazier","middle":"Blythe","title":"Ms.","street":"Ap #703-5281 Mauris Rd.","city":"Warren","state":"LA","zip":"08699","departmentId":"5","departmentName":"Customer Service","dateHired":"12/13/2002","dateFired":null,"dob":"03/07/1960","rate":"131","officePhone":"654-879-3957","homePhone":"260-751-8843","mobilePhone":"470-572-9234","email":"[email protected]"},{"id":"223","firstName":"Griffin","lastName":"Frazier","middle":"Isadora","title":"Dr.","street":"6668 Et Street","city":"East Lansing","state":"LA","zip":"72454","departmentId":"3","departmentName":"Asset Management","dateHired":"11/23/2004","dateFired":null,"dob":"04/01/1969","rate":"72","officePhone":"744-484-6358","homePhone":"341-591-8757","mobilePhone":"574-820-5581","email":"[email protected]"},{"id":"85","firstName":"Leila","lastName":"Frederick","middle":"Yen","title":"Ms.","street":"P.O. Box 293, 8075 Urna St.","city":"Passaic","state":"LA","zip":"50492","departmentId":"6","departmentName":"Finances","dateHired":"02/09/2000","dateFired":null,"dob":"08/03/1974","rate":"29","officePhone":"258-415-5374","homePhone":"367-190-5651","mobilePhone":"922-672-9365","email":"[email protected]"},{"id":"139","firstName":"Camille","lastName":"French","middle":"Anjolie","title":"Mrs.","street":"Ap #474-9737 Fermentum Av.","city":"Joliet","state":"OH","zip":"23994","departmentId":"3","departmentName":"Asset Management","dateHired":"08/22/2005","dateFired":null,"dob":"11/16/1948","rate":"92","officePhone":"785-902-2414","homePhone":"614-186-8297","mobilePhone":"909-428-4213","email":"[email protected]"},{"id":"411","firstName":"Alyssa","lastName":"Frost","middle":"Phoebe","title":"Dr.","street":"P.O. Box 260, 6442 Sit Ave","city":"New Kensington","state":"NE","zip":"05890","departmentId":"13","departmentName":"Sales and Marketing","dateHired":"12/31/2001","dateFired":null,"dob":"09/06/1967","rate":"132","officePhone":"444-837-3886","homePhone":"343-647-6264","mobilePhone":"879-914-7164","email":"[email protected]"},{"id":"2","firstName":"Gillian","lastName":"Fry","middle":"Destiny","title":"Mrs.","street":"P.O. Box 773, 1323 Leo. Road","city":"Peekskill","state":"SC","zip":"69702","departmentId":"3","departmentName":"Asset Management","dateHired":"06/19/2007","dateFired":null,"dob":"10/26/1945","rate":"48","officePhone":"544-183-6676","homePhone":"381-996-7045","mobilePhone":"818-376-6056","email":"[email protected]"},{"id":"440","firstName":"Blaze","lastName":"Fuentes","middle":"Scott","title":"Mrs.","street":"273 Integer Ave","city":"Nashua","state":"GA","zip":"32337","departmentId":"1","departmentName":"Accounting","dateHired":"01/17/2007","dateFired":null,"dob":"04/24/1956","rate":"117","officePhone":"791-207-9787","homePhone":"123-983-5171","mobilePhone":"264-327-1642","email":"[email protected]"},{"id":"312","firstName":"Kalia","lastName":"Gallagher","middle":"Cruz","title":"","street":"Ap #812-583 Nullam Avenue","city":"Lexington","state":"HI","zip":"29614","departmentId":"2","departmentName":"Advertising","dateHired":"06/28/2004","dateFired":null,"dob":"07/05/1955","rate":"94","officePhone":"500-652-1893","homePhone":"507-552-8161","mobilePhone":"796-833-8125","email":"[email protected]"},{"id":"466","firstName":"Xantha","lastName":"Galloway","middle":"Fletcher","title":"Mrs.","street":"985-883 Natoque St.","city":"Bandon","state":"VT","zip":"38174","departmentId":"11","departmentName":"Public Relations","dateHired":"07/05/2000","dateFired":null,"dob":"11/08/1969","rate":"19","officePhone":"773-891-3345","homePhone":"106-197-2726","mobilePhone":"673-119-9464","email":"[email protected]"},{"id":"500","firstName":"Nola","lastName":"Gardner","middle":"Leilani","title":"Mrs.","street":"5760 Volutpat. Rd.","city":"San Bernardino","state":"IA","zip":"90854","departmentId":"5","departmentName":"Customer Service","dateHired":"06/14/2001","dateFired":null,"dob":"12/12/1987","rate":"57","officePhone":"991-781-7435","homePhone":"959-593-5324","mobilePhone":"574-616-5160","email":"[email protected]"},{"id":"258","firstName":"Fitzgerald","lastName":"Garner","middle":"Clementine","title":"Ms.","street":"Ap #968-3409 Ante Av.","city":"Culver City","state":"WA","zip":"94275","departmentId":"5","departmentName":"Customer Service","dateHired":"12/09/2002","dateFired":null,"dob":"02/23/1969","rate":"29","officePhone":"850-775-2367","homePhone":"155-572-8508","mobilePhone":"134-979-4030","email":"[email protected]"},{"id":"4","firstName":"Bernard","lastName":"Gilbert","middle":"Carla","title":"","street":"Ap #618-1126 Egestas, Av.","city":"Peabody","state":"MT","zip":"63351","departmentId":"14","departmentName":"Research and Development","dateHired":"08/05/2001","dateFired":null,"dob":"03/05/1978","rate":"53","officePhone":"638-164-9084","homePhone":"871-630-7983","mobilePhone":"205-590-3918","email":"[email protected]"},{"id":"476","firstName":"Nell","lastName":"Gilbert","middle":"Curran","title":"Dr.","street":"6053 Nibh Ave","city":"Sierra Vista","state":"MT","zip":"46295","departmentId":"4","departmentName":"Customer Relations","dateHired":"11/08/2006","dateFired":null,"dob":"02/13/1984","rate":"35","officePhone":"649-245-2416","homePhone":"154-155-6896","mobilePhone":"798-211-2618","email":"[email protected]"},{"id":"555","firstName":"Myles","lastName":"Gillespie","middle":"Nicholas","title":"Mrs.","street":"P.O. Box 909, 6058 Magnis Road","city":"Kearns","state":"RI","zip":"17863","departmentId":"3","departmentName":"Asset Management","dateHired":"01/01/2006","dateFired":null,"dob":"11/23/1959","rate":"116","officePhone":"878-411-3771","homePhone":"952-996-9175","mobilePhone":"188-659-1941","email":"[email protected]"},{"id":"162","firstName":"Kiayada","lastName":"Gilliam","middle":"Thaddeus","title":"Mr.","street":"9133 Tellus Street","city":"Bloomington","state":"CT","zip":"10896","departmentId":"10","departmentName":"Payroll","dateHired":"05/19/2007","dateFired":null,"dob":"03/08/1985","rate":"49","officePhone":"470-314-3552","homePhone":"765-336-2341","mobilePhone":"671-208-7648","email":"[email protected]"},{"id":"10","firstName":"Vernon","lastName":"Gilmore","middle":"Moana","title":"Dr.","street":"P.O. Box 864, 4093 Consequat Av.","city":"Belleville","state":"OR","zip":"90080","departmentId":"6","departmentName":"Finances","dateHired":"03/08/2000","dateFired":null,"dob":"11/17/1984","rate":"

@jacobandresen
Copy link
Contributor

Hi @powerblue - looks like you could have a problem with your php install on your machine? which version of linux are you running? I left some notes for ubuntu linux in the README.txt file

the department.php and employee.php files are small files to simulate usage of the ActiveRecord pattern together wirh crud.php . In a realworld application you would use something like Symfony2 or Laravel for that ( or your favourite library - in you favourite severside language).

Remember to switch the proxy to "ajax" from "jsonp" when you are running locally. Let me know how it goes :)

@powerblue
Copy link
Author

Hi - Running php 5.4.24 on centos - Thanks

On Wed, Apr 16, 2014 at 2:30 AM, Jacob Andresen [email protected]:

Hi @powerblue https://github.com/powerblue - looks like you could have
a problem with your php install on your machine? which version of linux are
you running? I left some notes for ubuntu linux in the README.txt file

the department.php and employee.php files are small files to simulate
usage of the ActiveRecord pattern together wirh crud.php . In a realworld
application you would use something like Symfony2 or Laravel for that ( or
your favourite library - in you favourite severside language).

Remember to switch the proxy to "ajax" from "jsonp" when you are running
locally. Let me know how it goes :)

I


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40567330
.

@powerblue
Copy link
Author

Also, what commands can be run in the javascript console to inspect the data store after it is read from the mysql db?

Thanks

@jacobandresen
Copy link
Contributor

I am not that familiar with centos. I noticed that the package tool on centos is called "yum" . Maybe you can use this tool to update php , apache and mysql packages?

If you enter the following:

employeeStore.first();

in your console , then you should have first result available on the store displayed on the console. I left some examples in chapter 7.3 for ways you can interact with the datastore.

@powerblue
Copy link
Author

I have updated to these, and still getting the same error:

Apache version 2.2.27
PHP version 5.4.27
MySQL version 5.1.68-cll

Thanks

@jacobandresen
Copy link
Contributor

could you try installing the php5-mysqlnd package instead of the php5-mysql package and see if this fixes the problem on centos?

@jacobandresen
Copy link
Contributor

Nevermind :) I got curious and installed a centos system here locally. you can install the required packages like this on centos:

yum install httpd mysql-server php

I updated the README.txt with instructions for centos here: https://github.com/jacobandresen/extjs-in-action-examples/blob/patch-1/examples/ch07/README.txt

The packages that I have working on CentOS release 6.5 here are:

httpd-2.2.15-30.el6.centos.x86_64
mysql-server-5.1.73-3.el6_5.x86_64
php-5.3.3-27.el6_5.x86_64

@powerblue
Copy link
Author

Actually, I already have all that installed, is there a trouble in the
sancha package itself?

Thanks

On Thu, Apr 17, 2014 at 7:43 AM, Jacob Andresen [email protected]:

Nevermind :) I got curious and installed a centos system here locally. you
can install the required packages like this on centos:

yum install httpd mysql-server php

I updated the README.txt with instructions for centos here:
https://github.com/jacobandresen/extjs-in-action-examples/blob/patch-1/examples/ch07/README.txt

The packages that I have working on CentOS release 6.5 here are:

httpd-2.2.15-30.el6.centos.x86_64
mysql-server-5.1.73-3.el6_5.x86_64
php-5.3.3-27.el6_5.x86_64


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40705487
.

@powerblue
Copy link
Author

Hey,

I'm actually more interested in extDirect, if I use extDirect with the
symfony stack will I still run into this trouble?

Thanks

On Thu, Apr 17, 2014 at 9:50 AM, powerblue111 [email protected]:

Actually, I already have all that installed, is there a trouble in the
sancha package itself?

Thanks

On Thu, Apr 17, 2014 at 7:43 AM, Jacob Andresen [email protected]:

Nevermind :) I got curious and installed a centos system here locally.
you can install the required packages like this on centos:

yum install httpd mysql-server php

I updated the README.txt with instructions for centos here:
https://github.com/jacobandresen/extjs-in-action-examples/blob/patch-1/examples/ch07/README.txt

The packages that I have working on CentOS release 6.5 here are:

httpd-2.2.15-30.el6.centos.x86_64
mysql-server-5.1.73-3.el6_5.x86_64
php-5.3.3-27.el6_5.x86_64


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40705487
.

@jacobandresen
Copy link
Contributor

I doubt that the php and mysql related errors you are experiencing on centos are related to ExtJS . Remember that the Ext JS package is a clientside package :)

Feel free to experiment with ExtDirect and Symfony - that is allways a good idea. Are you able to run other php and mysql applications on your machine?

@powerblue
Copy link
Author

Mysql and php seem to work otherwise, though I am working on getting mysql
updated right now.

Thanks

On Thu, Apr 17, 2014 at 1:55 PM, Jacob Andresen [email protected]:

I doubt that the php and mysql related errors you are experiencing on
centos are related to ExtJS . Remember that the Ext JS package is a
clientside package :)

Feel free to experiment with ExtDirect and Symfony - that is allways a
good idea. Are you able to run other php and mysql applications on your
machine?


Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-40742833
.

@powerblue
Copy link
Author

Is there a symfony2 stack for extjs 4, the one currently available seems to be for extjs 3?:

http://www.symfony-project.org/plugins/dsExtDirectPlugin

Or will this one actually work for extjs4 ?

Thanks

@powerblue
Copy link
Author

When running loading The_Employee_Store.html after adding the sql to the server and having crud.php also on the server, I am getting a new error(mysql headers error is solved):

"Uncaught SyntaxError: Unexpected token ILLEGAL "

Thanks

@jacobandresen
Copy link
Contributor

Good to hear that you got your mysql things resolved :) Remember to switch the proxy to 'ajax' instead of 'jsonp'. This should let you retrieve json from the backend . When you are using 'jsonp' as a backend you will see something like this in the result:

Ext.data.JsonP.callback1({"data":[{"id":"467","firstName ....

this can be sent from the server and evaluated on the client .. but it contains illegal tokens in json. By switching the proxy to "ajax" the result will look something like this:

{"data":[{"id":"467","firstName ....

I included a note to remember to switch the proxy type in https://github.com/jacobandresen/extjs-in-action-examples/blob/patch-1/examples/ch07/README.txt

With regards to Ext JS direct and symfony then I think the protocol is still the same, so the Symfony plugin should still be useful. @grgur knows more than me about Direct. @grgur do you expect that @powerblue can use the Symfony Direct plugin with Ext JS 4?

@powerblue : let me know if the instructions in the README.txt file are sufficient for you on centos. I expect that you will be able to inspect the datastore content if you change the proxy type.

@powerblue
Copy link
Author

I changed the code to the following, and am trying to inspect the data store but am getting an undefined error when running employeeStore.first();

employeeStore.first();

undefined

<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

    <link rel="stylesheet" type="text/css" href="../../ext4/resources/css/ext-all.css" />
    <script type="text/javascript" src="../../ext4/ext-all-debug.js"></script>
</head>
<body>

<script type='text/javascript'>
    var urlRoot = '[ the domain ]/ext4/crud.php?model=Employee&method=';
    var employeeStore = Ext.create('Ext.data.Store', {
        model : 'Employee',
        proxy : {
            type   : 'ajax',
            api    : {
                create  : urlRoot + 'CREATE',
                read    : urlRoot + 'READ',
                update  : urlRoot + 'UPDATE',
                destroy : urlRoot + 'DESTROY'
            },
            reader : {
                type            : 'json',
                root            : 'data',
                idProperty      : 'id',
                successProperty : 'meta.success'
            },
            writer : {
                type           : 'json',
                encode         : true,
                writeAllFields : true,
                root           : 'data',
                allowSingle    : true,
                batch          : false,
                writeRecords   : function(request, data) {
                    request.jsonData = data;
                    return request;
                }
            }
        }
    });
    employeeStore.load();
</script>

</body>
</html>

@jacobandresen
Copy link
Contributor

Looks like you are missing a declaration of the "Employee" store as declared in listing 7.5 "The Employee model with validations". I noticed an error in the example listing where listing 7.4 and listing 7.5 had been mixed up. I fixed this in https://github.com/jacobandresen/extjs-in-action-examples/blob/patch-1/examples/ch07/7.4_The_Employee_Store.html and updated https://github.com/jacobandresen/extjs-in-action-examples/blob/patch-1/examples/ch07/README.txt . Thanks for hanging in there @powerblue.:)

remember that if you tweak the code in e.g 7.4_The_Employee_Store.html then crud.php will be right next to it .. so your code be something like https://gist.github.com/jacobandresen/02d7351a17e284a0d9aa

Remember that if your urlRoot endpoint is on another domain , then you will need jsonp.

@powerblue
Copy link
Author

Ok, there don't seem to be any errors in the javascript console now, with the following existing on the server, when proxy is set to ajax.

Is there a list of javascript commands available that can be used to inspect the store in addition to employeeStore.first(); ?

Also, does crud.php call the employee.php and department.php and use them to manipulate the database?
If using symfony, would those need to be rewritten in symfony?
Does the symfony stack have similar files?

7.4_The_Employee_Store.html:

<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

    <link rel='stylesheet' type='text/css' href='../../ext4/resources/css/ext-all.css'/>
    <script type='text/javascript' src='../../ext4/ext-all-debug.js'></script>
    <script type='text/javascript' src='7.5_The_Employee_model_with_validations.js'></script>
</head>
<body>

<script type='text/javascript'>
    var urlRoot = 'http://[ domain ].com/ext4/crud.php?model=Employee&method=';
    var employeeStore = Ext.create('Ext.data.Store', {
        model : 'Employee',
        proxy : {
            type   : 'ajax',
            api    : {
                create  : urlRoot + 'CREATE',
                read    : urlRoot + 'READ',
                update  : urlRoot + 'UPDATE',
                destroy : urlRoot + 'DESTROY'
            },
            reader : {
                type            : 'json',
                root            : 'data',
                idProperty      : 'id',
                successProperty : 'meta.success'
            },
            writer : {
                type           : 'json',
                encode         : true,
                writeAllFields : true,
                root           : 'data',
                allowSingle    : true,
                batch          : false,
                writeRecords   : function(request, data) {
                    request.jsonData = data;
                    return request;
                }
            }
        }
    });
    employeeStore.load();
</script>
</body>
</html>

And also:

7.5_The_Employee_model_with_validations.js:

Ext.define('Employee', {
    extend: 'Ext.data.Model',
    idProperty: 'id',
    fields: [
        {name: 'id',type: 'int'},
        {name: 'departmentId', type: 'int' },
        {name:'dateHired', type:'date', format:'Y-m-d'},
        {name:'dateFired', type:'date', format:'Y-m-d'},
        {name:'dob', type:'date', format: 'Y-m-d'},
        'firstName',
        'lastName',
        'middle',
        'title',
        'street',
        'city',
        'state',
        'zip',
        'departmentName',
        'rate',
        'officePhone',
        'homePhone',
        'mobilePhone',
        'email'
    ],
    validations: [
       {type: 'presence', field: 'firstName'},
       {type: 'presence', field: 'lastName'},
       {type: 'presence', field: 'departmentId'},
       {type: 'format', field: 'email',  matcher: /@/}
    ],
    associations: [{
        type: 'belongsTo',
        model:'Department',
        associationKey: 'departmentId'
    }]
});

And also:

crud.php

<?php
mysql_connect("localhost", "db_user", "user") or die ("could not connect:" . mysql_error());
mysql_select_db("db_user");

//Data access objects
require_once("department.php");
require_once("employee.php");

//Utility classes for communcation with client
class Meta
{
    public $success = false;
    public $msg = "";
}

;

class Response
{
    public $data;
    public $meta;
}

;

//Utility functions for handling XML
function generate_xml_from_array($array, $node_name)
{
    $xml = '';
    if (is_array($array) || is_object($array)) {
        foreach ($array as $key => $value) {
            if (is_numeric($key)) {
                $key = $node_name;
            }
            $xml .= '<' . $key . '>' . "" . generate_xml_from_array($value, $node_name) . '</' . $key . '>' . "";
        }
    } else {
        $xml = htmlspecialchars($array, ENT_QUOTES) . "";
    }
    return $xml;
}

function generate_valid_xml_from_array($array, $node_block = 'response', $node_name = 'node')
{
    $xml = '<?xml version="1.0" encoding="UTF-8" ?>' . "\n";
    $xml .= '<' . $node_block . '>' . "\n";
    $xml .= generate_xml_from_array($array, $node_name);
    $xml .= '</' . $node_block . '>' . "\n";
    return $xml;
}

function xml_encode($obj)
{
    return generate_valid_xml_from_array($obj, get_class($obj));
}

function xml_decode($xmlstr)
{
    return simplexml_load_string($xmlstr);
}

//process incoming parameters
$param = array();
$param["model"] = $_REQUEST['model'];
$param["id"] = $_REQUEST['id'];
$param["detail"] = $_REQUEST['detail'];
$param["parent"] = $_REQUEST['parent'];
$param["callback"] = $_REQUEST['callback'];
$param["format"] = $_REQUEST['format'];

if (!isset($param["model"])) {
    $param["model"] = "Employee";
}
if (!isset($param["detail"])) {
    $param["detail"] = false;
}
if (!isset($param["format"])) {
    $param["format"] = "json";
}

$method = $_REQUEST['method'];
if (!isset($method)) {
    $method = "READ";
}

$datain = json_decode($_REQUEST["JSON"]);
$data = array();
$msg = "";
$model = $param["model"];

//perform CRUD operations
try {
    $response = new Response();
    switch ($method) {
        case 'CREATE':
            $raw = '';
            $httpContent = fopen('php://input', 'r');
            while ($kb = fread($httpContent, 1024)) {
                $raw .= $kb;
            }
            fclose($httpContent);
            $datain = json_decode($raw);
            $response->data = $model::create($datain);
            break;
        case 'READ':
            $response->data = $model::read($param);
            break;
        case 'UPDATE':
            $raw = '';
            $httpContent = fopen('php://input', 'r');
            while ($kb = fread($httpContent, 1024)) {
                $raw .= $kb;
            }
            fclose($httpContent);
            $datain = json_decode($raw);
            $model::update($datain[0]);
            break;
        case 'DESTROY':
            $raw = '';
            $httpContent = fopen('php://input', 'r');
            while ($kb = fread($httpContent, 1024)) {
                $raw .= $kb;
            }
            fclose($httpContent);
            $datain = json_decode($raw);
            $response->data = $model::destroy($datain);
            break;
    }
    $response->meta = new Meta();
    $response->meta->success = "true";
    $response->meta->msg = "";
} catch (Exception $e) {
    $response = new Response();
    $response->data = array();
    $response->meta = new Meta();
    $response->meta->success = false;
    $response->meta->msg = "error";
}

if ($param["format"] == "xml") {
    header('Content-type: application/xml');
    $dataout = xml_encode($response);
} else {
    header('Content-type: application/json');
    $dataout = json_encode($response);
}

if (isset($param["callback"])) {
    print $param["callback"] . '(' . $dataout . '")';
} else {
    print $dataout;
}
?>

Thanks

@jacobandresen
Copy link
Contributor

Great to hear that you have no errors now :)

You could also try "last" and "count". You retrieve single items using "getAt"

You can find a list of method calls on the store here: http://docs.sencha.com/extjs/4.2.1/#!/api/Ext.data.Store

I also noticed that sencha released "App Inspector for Sencha" for google chrome . Look for it on the chrome webshop. It also let's you inspect the datastore visually. Great tool :)

When you are ready to proceed you can continue to chapter 8 in the book. It uses the same datastores . In Chapter 8 you will also have something to look at on the screen :)

@powerblue
Copy link
Author

"App Inspector for Sencha" for google chrome doesnt appear to work at all, though:

employeeStore.last();

and

employeeStore.count();

seem to work.

@jacobandresen
Copy link
Contributor

Good to hear that "last" and "count" are working for you. Sorry to hear that "App Inspector for Sencha" is not working for you. Feel free to report issues about App Inspector here: https://github.com/senchalabs/AppInspector/ .

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants
@jacobandresen @moduscreate @powerblue and others