readme for ch7 is missing

moduscreate commented 10 years ago

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

powerblue commented 10 years ago

Yes

On Mon, Apr 14, 2014 at 2:46 PM, Modus Create notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40403129 .

powerblue commented 10 years ago

"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 powerblue111@gmail.comwrote:

Yes

On Mon, Apr 14, 2014 at 2:46 PM, Modus Create notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40403129 .

moduscreate commented 10 years ago

Many thanks for that.

powerblue commented 10 years ago

Will it be available very soon, when?

jacobandresen commented 10 years ago

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 commented 10 years ago

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 notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40535226 .

powerblue commented 10 years ago

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":"Phasellus.vitae@tellusnon.ca"},{"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":"Sed@et.org"},{"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":"ut.sem@lacusEtiam.edu"},{"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":"et.tristique.pellentesque@ipsumCurabitur.com"},{"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":"eu.erat@disparturient.com"},{"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":"per@eueuismodac.ca"},{"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":"at@Sedeget.org"},{"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":"penatibus.et@nisidictumaugue.edu"},{"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":"ultrices.Vivamus.rhoncus@lobortis.com"},{"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":"neque.tellus@aliquamarcuAliquam.com"},{"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":"id.mollis.nec@dolor.edu"},{"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":"lacus@Morbi.ca"},{"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":"neque.non@nasceturridiculus.edu"},{"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":"mauris@et.ca"},{"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":"ultrices.a@luctus.org"},{"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":"In@atarcu.org"},{"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":"tempor@ametorciUt.com"},{"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":"sem@infaucibusorci.edu"},{"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":"non.lorem.vitae@Quisqueporttitoreros.org"},{"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":"erat.vel.pede@arcu.com"},{"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":"Cum.sociis.natoque@maurissapien.com"},{"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":"Mauris@velit.org"},{"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":"tincidunt.nibh@interdum.ca"},{"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":"mi@gravidanon.edu"},{"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":"rutrum@interdum.ca"},{"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":"pede.Cras@bibendum.com"},{"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":"Fusce.aliquet.magna@dolorFusce.com"},{"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":"erat.in.consectetuer@Nam.ca"},{"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":"tellus.sem.mollis@egestasFuscealiquet.com"},{"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":"metus@musProinvel.com"},{"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":"eu@pharetrasedhendrerit.org"},{"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":"ullamcorper@nisimagna.ca"},{"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":"ante@commodoauctor.edu"},{"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":"lacinia.Sed@Integertinciduntaliquam.edu"},{"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":"Morbi.quis.urna@Nullasemper.com"},{"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":"ullamcorper.Duis@ligulaDonec.com"},{"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":"quis.diam.luctus@eu.ca"},{"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":"hendrerit.Donec.porttitor@Duis.com"},{"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":"Phasellus.nulla@Aliquamnisl.edu"},{"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":"eget.venenatis.a@Aeneansedpede.org"},{"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":"enim.Sed@imperdiet.org"},{"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":"semper.Nam.tempor@enimnisl.org"},{"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":"lacinia@posuere.ca"},{"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":"malesuada@fringillacursuspurus.org"},{"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":"sit.amet.diam@rutrum.com"},{"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":"interdum.feugiat.Sed@pharetraut.com"},{"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":"mi.eleifend.egestas@sapienmolestieorci.ca"},{"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":"sit@sapien.com"},{"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":"libero.est.congue@auctor.ca"},{"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":"nonummy@ipsum.edu"},{"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":"Aenean.eget.magna@enimcondimentumeget.org"},{"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":"varius@massa.ca"},{"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":"id@tincidunt.org"},{"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":"quis@Cras.edu"},{"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":"diam.luctus@ipsumcursus.org"},{"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":"congue.elit@mattis.ca"},{"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":"magna.Phasellus.dolor@semutdolor.ca"},{"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":"Suspendisse@Nuncmauris.edu"},{"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":"nunc.ullamcorper@vulputate.ca"},{"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":"facilisis.facilisis@Aeneaneuismod.org"},{"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":"Duis.dignissim@disparturientmontes.edu"},{"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":"pellentesque.eget.dictum@massaMaurisvestibulum.edu"},{"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":"nunc.nulla@dignissim.ca"},{"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":"Integer.in@mauris.ca"},{"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":"eleifend.vitae@estMauris.ca"},{"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":"Donec.est@amet.edu"},{"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":"amet.metus@mollisIntegertincidunt.ca"},{"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":"vestibulum.lorem.sit@luctusipsumleo.ca"},{"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":"sed.sem.egestas@risusDonec.edu"},{"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":"Donec@odiotristiquepharetra.edu"},{"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":"sollicitudin.a.malesuada@odioEtiam.edu"},{"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":"eget.magna.Suspendisse@tinciduntaliquam.org"},{"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":"nulla.Integer.vulputate@Etiamvestibulummassa.com"},{"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":"velit.eu.sem@egestasAliquamfringilla.org"},{"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":"Phasellus.nulla@ipsumleo.edu"},{"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":"Integer@odio.edu"},{"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":"Fusce.mollis@tellusPhasellus.com"},{"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":"cursus@vitaemauris.com"},{"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":"facilisi@ridiculusmus.org"},{"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":"nec.luctus.felis@ipsumcursus.edu"},{"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":"varius.orci@ridiculusmus.edu"},{"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":"In@euismodest.edu"},{"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":"consequat.enim@magna.org"},{"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":"Aliquam@dapibusligula.org"},{"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":"luctus.sit.amet@at.edu"},{"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":"cursus.Nunc.mauris@vellectus.edu"},{"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":"dis@ipsumSuspendisse.com"},{"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":"sagittis.placerat.Cras@diam.com"},{"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":"Nullam.nisl@Praesenteu.edu"},{"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":"gravida.nunc@malesuada.org"},{"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":"per@risus.edu"},{"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":"egestas.ligula@nislNulla.org"},{"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":"justo.Praesent@euismod.ca"},{"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":"Nam.porttitor@tinciduntvehicula.com"},{"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":"risus.In.mi@nonlacinia.edu"},{"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":"In.lorem@quisdiamPellentesque.ca"},{"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":"Etiam@condimentum.edu"},{"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":"Sed.congue.elit@pedeNuncsed.org"},{"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":"vulputate.risus.a@penatibusetmagnis.edu"},{"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":"euismod@disparturient.org"},{"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":"dolor.Quisque@atortorNunc.ca"},{"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":"diam.eu.dolor@diamProin.edu"},{"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":"Donec.sollicitudin@est.com"},{"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":"Phasellus.at@Nullamlobortisquam.com"},{"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":"nisl.sem.consequat@Seddiam.edu"},{"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":"sed.dictum.eleifend@tristique.com"},{"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":"sed.pede@Integertinciduntaliquam.edu"},{"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":"varius.et@necimperdietnec.ca"},{"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":"ac@iaculisodio.ca"},{"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":"dictum.eleifend@Maurisblandit.edu"},{"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":"elementum.dui@Morbiaccumsan.ca"},{"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":"est.tempor@necurnaet.org"},{"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":"Cras.lorem.lorem@leo.edu"},{"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":"felis.Nulla@convallis.edu"},{"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":"felis.Nulla.tempor@etrutrum.com"},{"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":"sed@vulputatevelit.ca"},{"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":"cubilia@mauris.org"},{"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":"egestas.Aliquam@euturpisNulla.com"},{"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":"ante.dictum.mi@adipiscing.ca"},{"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":"Donec.feugiat@arcuCurabitur.org"},{"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":"ac@acrisusMorbi.com"},{"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":"et@arcuetpede.ca"},{"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":"non.cursus@ProinmiAliquam.com"},{"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":"mattis.ornare@faucibuslectus.ca"},{"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":"et.malesuada@commodo.ca"},{"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":"Proin@sit.com"},{"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":"sit@nondapibusrutrum.edu"},{"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":"erat.Etiam@atnisi.org"},{"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":"Aliquam@lacusQuisque.com"},{"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":"aliquam@a.com"},{"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":"ipsum@lacusvariuset.ca"},{"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":"magnis@tellusjustosit.ca"},{"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":"scelerisque@mollislectuspede.ca"},{"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":"augue.porttitor.interdum@hymenaeosMaurisut.org"},{"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":"id.risus.quis@arcuet.edu"},{"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":"quam.elementum@elitelit.edu"},{"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":"Proin@pharetrautpharetra.ca"},{"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":"hymenaeos.Mauris@scelerisquelorem.com"},{"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":"Sed.pharetra@varius.org"},{"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":"at.pede@vulputatevelit.com"},{"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":"sociosqu.ad.litora@egestasnuncsed.com"},{"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":"Vestibulum.accumsan.neque@liberoDonecconsectetuer.edu"},{"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":"ante@nisinibhlacinia.org"},{"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":"ac.arcu@viverraDonec.org"},{"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":"arcu.Vivamus@arcuVestibulumante.org"},{"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":"egestas.lacinia@Morbiquis.ca"},{"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":"Fusce.dolor.quam@tellusidnunc.ca"},{"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":"montes.nascetur.ridiculus@nonenim.org"},{"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":"interdum.Curabitur@nuncrisus.edu"},{"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":"sagittis.Nullam@ametmetus.ca"},{"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":"suscipit.nonummy.Fusce@ridiculusmus.org"},{"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":"eu.tellus.eu@a.edu"},{"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":"Etiam.bibendum@primisinfaucibus.ca"},{"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":"nibh@Vestibulum.ca"},{"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":"at.libero@nec.edu"},{"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":"metus.Aenean@lectuspedeultrices.com"},{"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":"hendrerit.consectetuer@duiquis.com"},{"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":"egestas@tellussemmollis.ca"},{"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":"luctus.ut.pellentesque@faucibusorciluctus.ca"},{"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":"neque@tellus.edu"},{"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":"vitae.erat@eu.org"},{"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":"Duis@telluslorem.ca"},{"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":"vel.convallis.in@pharetra.com"},{"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":"ad.litora@aliquamenim.com"},{"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":"pretium@tristique.com"},{"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":"Praesent@faucibusidlibero.org"},{"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":"eros@loremac.com"},{"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":"Phasellus.at.augue@magna.ca"},{"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":"sit.amet@Donecegestas.edu"},{"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":"mollis.dui.in@Nullamvitaediam.ca"},{"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":"volutpat.Nulla.dignissim@Aliquam.ca"},{"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":"in.molestie@ligulaAeneangravida.org"},{"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":"risus.In.mi@luctusetultrices.com"},{"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":"Mauris.blandit@felisDonectempor.org"},{"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":"id.risus.quis@purusgravidasagittis.ca"},{"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":"in.hendrerit@Nullamsuscipit.ca"},{"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":"nec.urna@semegestasblandit.ca"},{"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":"sit.amet.consectetuer@Donecfeugiat.edu"},{"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":"tellus.Nunc.lectus@nonantebibendum.edu"},{"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":"Nunc@Suspendisse.org"},{"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":"enim.diam.vel@leo.com"},{"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":"sit.amet.ante@cursuspurus.ca"},{"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":"felis.orci@Sedmolestie.com"},{"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":"a.neque.Nullam@gravidaAliquamtincidunt.org"},{"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":"sapien.cursus.in@loremloremluctus.com"},{"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":"eget.ipsum@Nuncullamcorper.edu"},{"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":"semper.pretium@risus.edu"},{"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":"vitae@dolorsit.org"},{"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":"Phasellus.at@ultricesiaculisodio.org"},{"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":"lobortis@viverraMaecenas.edu"},{"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":"ante.ipsum.primis@ridiculusmus.com"},{"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":"faucibus.id@parturient.edu"},{"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 commented 10 years ago

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 commented 10 years ago

Hi - Running php 5.4.24 on centos - Thanks

On Wed, Apr 16, 2014 at 2:30 AM, Jacob Andresen notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40567330 .

powerblue commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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

jacobandresen commented 10 years ago

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 commented 10 years ago

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 notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40705487 .

powerblue commented 10 years ago

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 powerblue111@gmail.comwrote:

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 notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40705487 .

jacobandresen commented 10 years ago

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 commented 10 years ago

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 notifications@github.comwrote:

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/ModusCreateOrg/extjs-in-action-examples/issues/2#issuecomment-40742833 .

powerblue commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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

employeeStore.last();

and

employeeStore.count();

seem to work.

jacobandresen commented 10 years ago

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/ .

ModusCreateOrg / extjs-in-action-examples

readme for ch7 is missing #2