/**
* @covers Instaphp\Instagram\Locations::Search
*/
public function testSearch()
{
$res = $this->object->Search(['count' => 10, 'foursquare_v2_id' => $this->foursquarev2id]);
$this->assertInstanceOf('\\Instaphp\\Instagram\\Response', $res);
$this->assertNotEmpty($res->data);
$res = $this->object->Search(['lat' => $this->lat, 'lng' => $this->lng]);
$this->assertInstanceOf('\\Instaphp\\Instagram\\Response', $res);
$this->assertNotEmpty($res->data);
}
public function locationName($locationid)
{
$locationsModel = new Locations();
$location = $locationsModel->getById($locationid);
if (!$location) {
$locationName = "Not Set";
} else {
$locationName = $location->name;
}
return $locationName;
}
public function __construct()
{
$id = Locations::MakeID('Hitman_HQ');
$location0 = Locations::Find(0);
parent::__construct($id, new Position(1950, 170), new Position(1780, 340), 85, new Position(202.142, 1869.3627, 13.1406, 280), $location0, -1, 0, $id);
$this->LoadObjectsFromFile('hitman_hq.txt');
parent::AddEntrance(-1, 'main', new Position(2263.5876, -755.4053, 38.0447, 120.0885));
}
public function __construct()
{
$id = Locations::MakeID('Police_Department');
$location0 = Locations::Find(0);
parent::__construct($id, new Position(200, 130), new Position(290, 100), 30, new Position(246.3663, 108.5394, 1003.2188, 0), $location0, -1, 10, $id);
$this->AddEntrance(1239, 'street', new Position(1554.2861, -1675.6412, 16, 90));
$this->AddEntrance(1239, 'parking', new Position(1568.6268, -1691.0177, 5.8906, 180), new Position(214.8052, 118.2134, 1003.2188, 90));
$this->AddEntrance(1239, 'roof', new Position(1564.9879, -1685.7429, 28.3956, 180), new Position(237.9606, 114.7937, 1010.2188, 90));
}
function importRecords()
{
$csvPath = APPLICATION_PATH . "/../data/imports.csv";
$contents = file_get_contents($csvPath);
$lines = explode("\n", $contents);
$i = 0;
$recordsModel = new Records();
foreach ($lines as $line) {
if ($i > 0) {
$data = explode(",", $line);
$substitutesModel = new Substitutes();
$substitute = $substitutesModel->getBySecondaryId($data[13]);
$locationsModel = new Locations();
$location = $locationsModel->getByName($data[4]);
$nameSegments = explode("|", $data[3]);
$lastName = $nameSegments[0];
$firstName = $nameSegments[1];
$employeesModel = new Employees();
$employee = $employeesModel->getByName($firstName, $lastName);
if ($data[9] == 'FALSE' || $data[9] == FALSE) {
$leaveForm = 0;
} else {
$leaveForm = 1;
}
if (!$substitute) {
$subid = '129';
} else {
$subid = $substitute->id;
}
$recordData = array('date' => date('Y-m-d', strtotime($data[1])), 'employee' => @$employee->id, 'location' => @$location->id, 'substitute' => $subid, 'reason' => $data[6], 'notes' => $data[7], 'percent' => str_replace("%", "", $data[8]), 'leave_form' => $leaveForm, 'user' => 6, 'acct' => $data[14]);
try {
$recordsModel->insert($recordData);
} catch (Exception $e) {
echo $e->getMessage();
}
print_r($recordData);
}
$i++;
}
}
function importEmployees()
{
$locationsModel = new Locations();
$employeesModel = new Employees();
$csv = "20493,BEASLEY,JACQUELYN,JLL,Academic Coach,50000000000000000000000\n90674,WARD,GLENDA,JLL,Academic Coach,50000000000000000000000\n1463,MAYS,VAKESHA,NMS,Academic Coach,50000000000000000000000\n68120,MOORE,JOYCE,NMS,Academic Coach,50000000000000000000000\n54602,MAY,KAREN,SLM,Academic Coach,50000000000000000000000\n70975,OLIVER,HEATHER,SLM,Academic Coach,50000000000000000000000\n47798,CHASTAIN,STACI,SM,Academic Coach,50000000000000000000000\n87015,WARD,APRIL,SM,Academic Coach,50000000000000000000000\n20609,BESS,LASHONDA,SE,Academic Coach,50000000000000000000000\n36071,FINNEY-WILLIAMS,ANN,SE,Academic Coach,50000000000000000000000\n33075,GASKINS,ERIN,VHS,Academic Coach,50000000000000000000000\n71684,BROOKS,TAMELA,VHS,Academic Coach,50000000000000000000000\n76820,RAY,FREDONIA,VHS,Academic Coach,50000000000000000000000\n34185,EDGERTON,HILDA,VMS,Academic Coach,50000000000000000000000\n87758,SWILLEY,LEON,VMS,Academic Coach,50000000000000000000000\n22617,BROWN,MARILYN,WGN,Academic Coach,50000000000000000000000\n63673,MCCLELLAN,CHRISTY,WGN,Academic Coach,50000000000000000000000\n67722,MOODY,MAGGIE,WGN,Academic Coach,50000000000000000000000\n1439,PITTMAN,FADWA,CO,Admin Secretary,50000000000000000000000\n20508,RICE,DEBI,CO,Admin Secretary,50000000000000000000000\n35130,FAZEKAS,GLENDA,CO,Admin Secretary,50000000000000000000000\n53370,JENNINGS,JOY,CO,Admin Secretary,50000000000000000000000\n67560,MONTGOMERY,DAWN,SLM,Admin Secretary,50000000000000000000000\n27247,COLBURN,LISA,VECA,Admin Secretary,50000000000000000000000\n47361,HEZEKIAH,IMOGENE,VHS,Admin Secretary,50000000000000000000000\n56817,KELLEY,BRENDA,VHS,Admin Secretary,50000000000000000000000\n1136,OBRIEN,JOHN,VHS,All Sports Athletic Trainer,50000000000000000000000\n79324,ROESCH,EDWARD,CO,Superintendent,50000000000000000000000\n51020,HUDSON,ALVIN,CO,Asst. Superintendent of Operations,50000000000000000000000\n1506,DANG,KIM,CO,B/W Clerical Support,50000000000000000000000\n72495,PEEPLES,LADONNA,CO,Behavior Support Svcs.,50000000000000000000000\n56543,KAY,BEVERLY,CO,Benefits Coor.,50000000000000000000000\n49442,HOLLIMON,WILLIAM,NMS,Bookkeeper,50000000000000000000000\n70475,NICHOLS,GEORGIA,SM,Bookkeeper,50000000000000000000000\n63002,MATHIS,BETTY,SE,Bookkeeper,50000000000000000000000\n29726,WILLIAMS,BARBARA,VHS,Bookkeeper,50000000000000000000000\n45100,HARDY,BRENDA,VHS,Bookkeeper,50000000000000000000000\n90750,WARREN,ANGIE,WGN,Bookkeeper,50000000000000000000000\n1090,LAPKIEWICZ,JOHN,Transportation,Bus Drivers,50000000000000000000000\n11311,DAVIS,SONJA,Transportation,Bus Drivers,50000000000000000000000\n1153,STOKES,SHERYL,Transportation,Bus Drivers,50000000000000000000000\n1154,ECHOLS,RAVEN,Transportation,Bus Drivers,50000000000000000000000\n1171,JOHNSON,JOHN,Transportation,Bus Drivers,50000000000000000000000\n1172,VALLINA,KEREN,Transportation,Bus Drivers,50000000000000000000000\n1174,YEARBY,JOSEPH,Transportation,Bus Drivers,50000000000000000000000\n1186,BLACK,CHARLIE,Transportation,Bus Drivers,50000000000000000000000\n1222,RICHARDSON,ROBERT,Transportation,Bus Drivers,50000000000000000000000\n1281,MURRAY,CINELLA,Transportation,Bus Drivers,50000000000000000000000\n1291,GORDON,HERMAN,Transportation,Bus Drivers,50000000000000000000000\n1304,JONES,SHARON,Transportation,Bus Drivers,50000000000000000000000\n1313,HIPPS,ROBERT,Transportation,Bus Drivers,50000000000000000000000\n1345,FERGUSON,NIESHA,Transportation,Bus Drivers,50000000000000000000000\n1378,BROOKS,WEYLAND,Transportation,Bus Drivers,50000000000000000000000\n1416,BENNETT,TERESA,Transportation,Bus Drivers,50000000000000000000000\n1503,WALKER,ERNEY,Transportation,Bus Drivers,50000000000000000000000\n1504,JOHNSON,BARBARA,Transportation,Bus Drivers,50000000000000000000000\n15504,KELLY,MARCIE,Transportation,Bus Drivers,50000000000000000000000\n1561,ELLIS,KAREN,Transportation,Bus Drivers,50000000000000000000000\n1579,TILLMAN,TAMMI,Transportation,Bus Drivers,50000000000000000000000\n16524,BERRIAN,CAROLYN,Transportation,Bus Drivers,50000000000000000000000\n16631,BERRY,HENRY,Transportation,Bus Drivers,50000000000000000000000\n20559,BRANTLEY,RONALD,Transportation,Bus Drivers,50000000000000000000000\n22813,BROWN,TASHYNDA,Transportation,Bus Drivers,50000000000000000000000\n25347,CHAPMAN,EDWARD,Transportation,Bus Drivers,50000000000000000000000\n25985,CLARK,CYNTHIA,Transportation,Bus Drivers,50000000000000000000000\n26923,CODY,VIVIANN,Transportation,Bus Drivers,50000000000000000000000\n32432,DEVO,TONGELA,Transportation,Bus Drivers,50000000000000000000000\n35077,FAIRELL,GERALDINE,Transportation,Bus Drivers,50000000000000000000000\n35092,SLOCUMB,DIANE,Transportation,Bus Drivers,50000000000000000000000\n35310,FERGUSON,SHAMIKA,Transportation,Bus Drivers,50000000000000000000000\n42014,GRAHAM,JESSE,Transportation,Bus Drivers,50000000000000000000000\n45152,HARGETT,ROSE,Transportation,Bus Drivers,50000000000000000000000\n46191,HARVEY,ALLECE,Transportation,Bus Drivers,50000000000000000000000\n49603,HOLLIS,MARGARET,Transportation,Bus Drivers,50000000000000000000000\n53451,JOACHIM,STEPHANIE,Transportation,Bus Drivers,50000000000000000000000\n53954,JOHNSON,CARLTON,Transportation,Bus Drivers,50000000000000000000000\n57483,KING,BELTON,Transportation,Bus Drivers,50000000000000000000000\n62282,MARTIN,JARONE,Transportation,Bus Drivers,50000000000000000000000\n62925,MATCHETT,FRANCES,Transportation,Bus Drivers,50000000000000000000000\n63005,MATHIS,CALLIE,Transportation,Bus Drivers,50000000000000000000000\n63633,MCBURROUGH,JACQUILYN,Transportation,Bus Drivers,50000000000000000000000\n65965,MIDDLEBROOKS,SHALONDA,Transportation,Bus Drivers,50000000000000000000000\n69218,MOSELY,DIANE,Transportation,Bus Drivers,50000000000000000000000\n69833,NELSON,ALICE,Transportation,Bus Drivers,50000000000000000000000\n69840,NELSON,GWENDOLYN,Transportation,Bus Drivers,50000000000000000000000\n74309,PONDER,ARTHUR,Transportation,Bus Drivers,50000000000000000000000\n79318,ROE,DALE,Transportation,Bus Drivers,50000000000000000000000\n82955,SERMONS,CURTIS,Transportation,Bus Drivers,50000000000000000000000\n82960,YEARBY,MARGARET,Transportation,Bus Drivers,50000000000000000000000\n88587,THOMAS,ANNETTA,Transportation,Bus Drivers,50000000000000000000000\n96423,WOODS,PATRICIA,Transportation,Bus Drivers,50000000000000000000000\n1073,JOHNS,HORACE,Transportation,Mechanic,50000000000000000000000\n1077,BELTRAN,JAVIER,Transportation,Mechanic,50000000000000000000000\n86215,SPENCE,MARCUS,Transportation,Mechanic,50000000000000000000000\n20554,BOYETT,ANN,CO,Bus. Svcs.,50000000000000000000000\n55628,JONES,JEREMY,CO,Bus. Svcs.,50000000000000000000000\n97615,YEARGAN,JONI,CO,CLERICAL RESOURCE CENTER,50000000000000000000000\n43990,HAIGLER,CAROLYN,CO,Coor. K-3 Speech Language,50000000000000000000000\n25095,BROWN,SCARLET,CO,Curriculum Dir.,50000000000000000000000\n90289,WAKEFIELD,JAMES,CO,Dir. of Custodians,50000000000000000000000\n1450,NOBLES,KACI,CO,Dir. of Facilities & Maintenance,50000000000000000000000\n1652,JONES,ROBERT,CO,Dir. of Finance,50000000000000000000000\n87714,SWIFT,CARL,CO,Dir. of Instructional Tech,50000000000000000000000\n86700,STEEDLEY,JENNIFER,CO,Dir. of Public Relations,50000000000000000000000\n48328,HILLER,CRYSTAL,CO,Dir. of Purchasing,50000000000000000000000\n11399,BOYD,PAMELA,CO,Dir. of SNP,50000000000000000000000\n1123,LUCAS,LAURA,CO,Dir. of SPED,50000000000000000000000\n1523,MASON,COURTNEY,CO,General Secretary,50000000000000000000000\n55594,JONES,BRENDA,CO,General Secretary,50000000000000000000000\n71246,ORR,CLARA,CO,General Secretary,50000000000000000000000\n22683,BROWN,RAYCHEL,JLL,General Secretary,50000000000000000000000\n20598,BENNETT,SABINA,NMS,General Secretary,50000000000000000000000\n29082,COTHRON,JANET,NMS,General Secretary,50000000000000000000000\n1632,HENRY,RAMONDA,PLC,General Secretary,50000000000000000000000\n35046,EWINGS,CHANDRA,PLC,General Secretary,50000000000000000000000\n1060,KIMBROUGH,LECHA,Transportation,General Secretary,50000000000000000000000\n55860,JONES,VICKIE,Transportation,General Secretary,50000000000000000000000\n1459,SHIVER,NANCY,VHS,General Secretary,50000000000000000000000\n21325,BRIGGS,VIRGINIA,VHS,General Secretary,50000000000000000000000\n52774,JACKSON-WILLIAMS,TRACY,VHS,General Secretary,50000000000000000000000\n31020,DAVIS,BARBARA,VMS,General Secretary,50000000000000000000000\n23930,CHARLES,CHUB,CO,Hospital Homebound,50000000000000000000000\n1387,BROWN,JANMESHISKA,CO,Human Resources Asst.,50000000000000000000000\n57603,KLEIN,JANIA,CO,Human Resources Coor.,50000000000000000000000\n62385,LAWSON,SHEILA,CO,Human Resources Dir.,50000000000000000000000\n33690,DUNN,RONNIE,CO,HVAC A/C and Electrical,50000000000000000000000\n11055,ALVAREZ,CHARLES,CO,Instructional Supervisor,50000000000000000000000\n27195,COLE,DAVID,CO,Instructional Supervisor,50000000000000000000000\n32880,HOLT,DARA,CO,Instructional Supervisor,50000000000000000000000\n35254,MABRY,JOANN,CO,Instructional Supervisor,50000000000000000000000\n28172,CONRAD,ANNE,CO,Occupational Therapist,50000000000000000000000\n1223,CASHWELL,KILEY,CO,Payroll,50000000000000000000000\n22802,BROWN,SHELLIE,CO,Payroll Manager,50000000000000000000000\n39596,GLOVER,BUNNY,CO,Pre School,50000000000000000000000\n43101,GRIFFIN,TRACEY,CO,Psychologist,50000000000000000000000\n47535,HERNDON,WYNNIE,CO,Psychologist,50000000000000000000000\n82993,SERMONS,TRACIE,CO,Purchasing,50000000000000000000000\n46559,WOOTEN,SUSAN,CO,Receptionist,50000000000000000000000\n91733,WHITE,DANIELLE,CO,RT3 TCHR on Assignment,50000000000000000000000\n37055,FOLSOM,DEANNA,CO,School Social Work,50000000000000000000000\n87718,SWIFT,SUSAN,CO,School Social Work,50000000000000000000000\n42056,GRANT,BONNIE,CO,SPED,50000000000000000000000\n72904,PETERS,PAMELA,CO,SPED,50000000000000000000000\n78069,RICE,WANDA,CO,SPED,50000000000000000000000\n85537,COOPER,MYRA,CO,SPED,50000000000000000000000\n1427,CARTER,BARBARA,CO,SLP,50000000000000000000000\n33147,MCLEOD,PATRICIA,CO,SLP,50000000000000000000000\n43649,GRIMES,GINA,CO,SLP,50000000000000000000000\n52084,HUTCHINSON,KATHRYN,CO,SLP,50000000000000000000000\n27132,COLBERT,LASHAWNA,CO,Tech,50000000000000000000000\n58889,LEWIS,DIANE,CO,Tech,50000000000000000000000\n85427,SMITH,BENNIE,CO,Tech,50000000000000000000000\n90675,WARD,RALPH,CO,Tech,50000000000000000000000\n11330,BERRY,KENDRICK,CO,Tech Specialist,50000000000000000000000\n56544,KAY,JASON,CO,Tech Specialist,50000000000000000000000\n78109,RICHARDSON,KEITH,CO,Tech Specialist,50000000000000000000000\n85170,COPELAND,CHERYL,CO,Testing Coor.,50000000000000000000000\n44989,HARDEN,JAMIE,CO,Title 1 Dir.,50000000000000000000000\n89175,THORNTON,JENNIFER,CO,Title IIA/Grant Coor.,50000000000000000000000\n1397,LEWIS,DAVID,VHS,Auto Mechanics,51000301110001130002730\n1309,BRINSON,DAVID,PLC,Bus. Education,51000104110001130060020\n11346,BLANKUMSEE,AQILA,VHS,Bus. Education,51000301110001130002730\n1488,SOLOMON,ERIC,VHS,Bus. Education,51000301110001130002730\n27650,BUCKHAM,LORI,VHS,Bus. Education,51000301110001130002730\n47685,HERRING,SAMUEL,VHS,Bus. Education,51000301110001130002730\n85426,HARLESS,KELLIE,VHS,Bus. Education,51000301110001130002730\n31700,DAWKINS,AUBREY,VHS,Construction,51000301110001130002730\n65501,MIDDLETON,ALAN,VHS,Dir. of Tech/Career Education,51000301110001130002730\n1470,SIMMONS,MICHAEL,VHS,Drafting,51000301110001130002730\n30775,DARBY,PARIS,PLC,Early Childhood,51000102110001130060020\n1051,TROUTMAN,WHITNEE,JLL,EIP,51000107110001130001060\n39797,GEIGER,MEGAN,JLL,EIP,51000107110001130001060\n46198,HARVEY-BROWN,PHYLLIS,JLL,EIP,51000109110001130001060\n68673,MORGAN,ASHLEY,JLL,EIP,51000106110001130001060\n79987,ROGERS,PAMELA,JLL,EIP,51000107110001130001060\n80855,RYALS,VALERIE,JLL,EIP,51000109110001130001060\n90251,VU,SHERIE,JLL,EIP,51000107110001130001060\n97621,YODER,SARA,JLL,EIP,51000106110001130001060\n12215,COPELAND,NATASHA,SLM,EIP,51000106110001130003090\n14346,UMPLEBY,BRANDI,SLM,EIP,51000107110001130003090\n1495,TRUITT,GRETA,SLM,EIP,51000107110001130003090\n20475,ANDERSON,CAROL,SLM,EIP,51000106110001130003090\n20481,ANDERSON,ROBYN,SLM,EIP,51000109110001130003090\n65365,MEADOWS,EMILY,SLM,EIP,51000107110001130003090\n90101,VALDEZ,MARTHA-SUSAN,SLM,EIP,51000109110001130003090\n1637,SCHNEIDER,JENNIFER,SM,EIP,51000107110001130001010\n28838,COOPER,KRISTY,SM,EIP,51000109110001130001010\n52374,MCKINNON,LADENA,SM,EIP,51000107110001130001010\n58496,LAW,AMIE,SM,EIP,51000109110001130001010\n58557,HENNLY,VICTORIA,SM,EIP,51000107110001130001010\n72882,FOWLER,DONNA,SM,EIP,51000106110001130001010\n96870,KOETTER,DEITRICE,SM,EIP,51000109110001130001010\n33099,HARRELL,AMANDA,SE,EIP,51000107110001130020520\n68340,WISHAM,RYAN,SE,EIP,51000106110001130020520\n44727,HAYNES,ASHLEE,WGN,EIP,51000107110001130010520\n46399,HATTERMANN,JANET,WGN,EIP,51000109110001130010520\n47580,SANDERS,JAMIE,WGN,EIP,51000106110001130010520\n60160,FRALEIGH,L.,WGN,EIP,51000109110001130010520\n64355,MCDADE,AMY,WGN,EIP,51000107110001130010520\n64968,BRAUN,LESLIE,WGN,EIP,51000107110001130010520\n71930,PATE,CARRIE,WGN,EIP,51000107110001130010520\n72206,PAYTON,LYNDA,WGN,EIP,51000106110001130010520\n90132,VEDAS,PATTY,WGN,EIP,51000107110001130010520\n1489,WELLS,JENNE',PLC,English,51000104110001130060020\n88498,CUPP,ELOISE,PLC,English,51000104110001130060020\n10145,ALGER,DONNA,VHS,English,51000104110001130002730\n1451,LEWIS,MAURA,VHS,English,51000104110001130002730\n1467,MORRIS,JULIE,VHS,English,51000104110001130002730\n1493,LASSETER,MELANIE,VHS,English,51000104110001130002730\n1551,LAND,KASEY,VHS,English,51000104110001130002730\n24380,CALKINS,MELISSA,VHS,English,51000104110001130002730\n25225,CAESAR,CASSANDRA,VHS,English,51000104110001130002730\n25575,CHILDRESS,PAMELA,VHS,English,51000211110001130002730\n30890,STERN,MELISSA,VHS,English,51000221110001130002730\n33155,DROSSOS,NARCI,VHS,English,51000104110001130002730\n43660,GRIMES,ROBERT,VHS,English,51000104110001130002730\n44075,HALL,DONNA,VHS,English,51000104110001130002730\n51620,HUNTER-MARABLE,CORRIE,VHS,English,51000104110001130002730\n69094,MOSER,GNANN,VHS,English,51000104110001130002730\n87383,HOWARD,KATHARINE,VHS,English,51000104110001130002730\n90720,WARE,ANDRA,VHS,English,54020175010001130002730\n29739,HADDEN,LAWREN,SLM,ESOL,51000135110001130003090\n63674,MCCLELLAN,GINGER,SM,ESOL,51000135110001130001010\n1157,CORBETT,JANIE,VHS,ESOL,51000135110001130002730\n63630,GOODSON,RHONDA,VMS,ESOL,51000135110001130001030\n92576,CHRISTIAN,BARBARA,WGN,ESOL,51000135110001130010520\n1477,EDWARDS,WILLIE,JLL,5th GR TCHR,54020175010001130001060\n51715,HUNT,TRACEY,JLL,5th GR TCHR,51000105110001130001060\n79400,ROBINSON,SHEILA,JLL,5th GR TCHR,51000105110001130001060\n83790,SIMMONS,DARA,JLL,5th GR TCHR,51000105110001130001060\n1228,MCCRARY,ALISON,SLM,5th GR TCHR,54020175010001130003090\n1399,SERMONS,CHRISTIE,SLM,5th GR TCHR,51000105110001130003090\n32899,DOW,CAROLYN,SLM,5th GR TCHR,51000105110001130003090\n60750,LUKE,ERICA,SLM,5th GR TCHR,51000105110001130003090\n93545,BAKER,LAUREN,SLM,5th GR TCHR,51000105110001130003090\n34890,EMBRY,WILLIAM,SM,5th GR TCHR,51000105110001130001010\n45309,HARPER,CHARLOTTE,SM,5th GR TCHR,51000105110001130001010\n58198,LANGSTON,MELANIE,SM,5th GR TCHR,51000105110001130001010\n79980,RODGERS,BRENDA,SM,5th GR TCHR,51000105110001130001010\n1626,WOMBLE,LINDSEY,SE,5th GR TCHR,51000105110001130020520\n54062,MOORE,ELLENA,SE,5th GR TCHR,51000105110001130020520\n67260,MOBLEY,JANICE,SE,5th GR TCHR,51000105110001130020520\n1061,TANNER,KRISTIN,WGN,5th GR TCHR,51000105110001130010520\n20482,EARLE,CHRISTIE,WGN,5th GR TCHR,51000105110001130010520\n33728,DUPREE,MICHELLE,WGN,5th GR TCHR,54020175010001130010520\n45300,LONG,ADIA,WGN,5th GR TCHR,51000105110001130010520\n83591,GOFF,KRISTI,WGN,5th GR TCHR,51000105110001130010520\n1475,MILLER,AUTUMN,JLL,1st GR TCHR,51000102110001130001060\n20608,BENEFIELD,ANGELA,JLL,1st GR TCHR,51000102110001130001060\n86870,STEPHENSON,IVIE,JLL,1st GR TCHR,51000102110001130001060\n96849,BROWN,CHARLOTTE,JLL,1st GR TCHR,51000102110001130001060\n1629,KELLY,ANGEL,SLM,1st GR TCHR,51000102110001130003090\n1636,COVERT,HANNAH,SLM,1st GR TCHR,51000102110001130003090\n1643,HOWELL,RACHEL,SLM,1st GR TCHR,51000102110001130003090\n1667,PARRAMORE,KARRI,SLM,1st GR TCHR,51000102110001130003090\n17950,JACKSON,LAURA,SLM,1st GR TCHR,51000102110001130003090\n21445,BROCK,STEPHANIE,SLM,1st GR TCHR,51000102110001130003090\n24672,CARLSON,JENNIFER,SLM,1st GR TCHR,51000102110001130003090\n60125,HODGES,GLORIA,SLM,1st GR TCHR,51000102110001130003090\n1063,MCCORD,AMANDA,SM,1st GR TCHR,51000102110001130001010\n1085,HENDERSON,SHELLY,SM,1st GR TCHR,51000102110001130001010\n1457,KOVACH,LAURA,SM,1st GR TCHR,51000102110001130001010\n20583,BLAKLEY,ELIZABETH,SM,1st GR TCHR,51000102110001130001010\n27070,COILE,MELANIE,SM,1st GR TCHR,51000102110001130001010\n41217,GODWIN,BRANDI,SM,1st GR TCHR,51000102110001130001010\n65940,CONNELL,LAURA,SM,1st GR TCHR,51000102110001130001010\n91240,KAUTZMAN,STEPHANIE,SM,1st GR TCHR,51000102110001130001010\n94250,LYONS,MARIAN,SM,1st GR TCHR,51000102110001130001010\n1114,WEATHERS,STEPHANIE,SE,1st GR TCHR,51000102110001130020520\n24461,CAMPBELL,CHRISTINE,SE,1st GR TCHR,51000102110001130020520\n24469,CANNON,KELLI,SE,1st GR TCHR,51000102110001130020520\n66247,MILLER,JENNIFER,SE,1st GR TCHR,51000102110001130020520\n89734,TULLOS,MARGUERITE,SE,1st GR TCHR,51000102110001130020520\n1479,VOLLRATH,THERESA,WGN,1st GR TCHR,51000102110001130010520\n1674,KOENIG,JILLIAN,WGN,1st GR TCHR,51000102110001130010520\n20584,JOHNSON,KIMBERLY,WGN,1st GR TCHR,51000102110001130010520\n28444,MCSWAIN,ANGELA,WGN,1st GR TCHR,51000102110001130010520\n41279,GOLDEN,GAIL,WGN,1st GR TCHR,51000102110001130010520\n43739,GROW,BRANDI,WGN,1st GR TCHR,51000102110001130010520\n44124,HALL,VALERIE,WGN,1st GR TCHR,51000102110001130010520\n46137,HART,DEBRA,WGN,1st GR TCHR,51000102110001130010520\n54789,JOHNSON-LEWIS,TIFFANY,WGN,1st GR TCHR,51000102110001130010520\n63975,MCGUIRE,LAURA,WGN,1st GR TCHR,51000102110001130010520\n20629,BRANTLEY,JEDDA,JLL,4th GR TCHR,51000105110001130001060\n43120,WILLIAMS-GRIFFIN,IDELLA,JLL,4th GR TCHR,51000105110001130001060\n43801,GUESS,EVELYN,JLL,4th GR TCHR,54020175010001130001060\n53066,JEFFERSON,MARY,JLL,4th GR TCHR,51000105110001130001060\n71714,DAVIS,CHANTIL,JLL,4th GR TCHR,51000105110001130001060\n1444,HARRIS,RACHEL,SLM,4th GR TCHR,51000105110001130003090\n1465,GRIER,JERROD,SLM,4th GR TCHR,51000105110001130003090\n76708,RAPIER,JOYCE,SLM,4th GR TCHR,54020175010001130003090\n76870,DOYLE,APRIL,SLM,4th GR TCHR,51000105110001130003090\n97830,YOUNG,PAMELA,SLM,4th GR TCHR,51000105110001130003090\n1392,SUMNER,TRINITY,SM,4th GR TCHR,54020175010001130001010\n31631,DAVIS,TANYA,SM,4th GR TCHR,51000105110001130001010\n35027,EVERETT,CHRISTINE,SM,4th GR TCHR,51000105110001130001010\n42441,BOOKER-GREEN,JANNETTE,SM,4th GR TCHR,51000105110001130001010\n72486,PENN,SARAH,SM,4th GR TCHR,51000105110001130001010\n86290,SPIVEY,BRITTON,SM,4th GR TCHR,51000105110001130001010\n1237,SHARPE,VERONICA,SE,4th GR TCHR,54020175010001130020520\n34150,EARP,LINDA,SE,4th GR TCHR,51000105110001130020520\n57380,JOHNSON,LATOYA,SE,4th GR TCHR,51000105110001130020520\n12246,AUSTIN,ELIZABETH,WGN,4th GR TCHR,51000105110001130010520\n16825,BEST,SHANNON,WGN,4th GR TCHR,51000105110001130010520\n69579,BANNISTER,TERESA,WGN,4th GR TCHR,51000105110001130010520\n78222,RICKMAN,CHARLENE,WGN,4th GR TCHR,54020175010001130010520\n86356,HEETER,SHILA,WGN,4th GR TCHR,51000105110001130010520\n87382,STRICKLAND,JOANIE,WGN,4th GR TCHR,51000105110001130010520\n89385,MILLER,RACHEL,WGN,4th GR TCHR,54020175010001130010520\n37779,WHITTAKER,LAUREN,JLL,Gifted,51000135110001130001060\n64242,COLLIER,SHENELL,NMS,Gifted,51000211110001130001950\n24445,CAMPA,DONNA,SLM,Gifted,51000211110001130003090\n65404,MELTON,GINA,SM,Gifted,51000211110001130001010\n40594,GIBBS,DANIELLE,SE,Gifted,51000135110001130020520\n78612,ROBERTS,ERIN,VMS,Gifted,51000211110001130001030\n96107,WOOD,LISA,VMS,Gifted,51000211110001130001030\n24635,CARDELLA,ANNE,WGN,Gifted,51000211110001130010520\n37124,FORCE,WESLEY,VHS,Graphic Arts,51000301110001130002730\n89040,BREHM,LAURA,VHS,HB280 Math/Sci. Supplement,51000104110001130002730\n64969,MCQUAIG,DERRITH,VHS,Health Occupations,51000301110001130002730\n58760,LEFF,TAMMY,VHS,Health Sci.,51000301110001130002730\n82400,SCOTT,DONZETTA,VHS,Health Sci.,51000301110001130002730\n42015,GRAHAM,KENNETH,VHS,IN SCHOOL SUSPENSION,51000507110001130002730\n87573,BRANNICK,SHEILA,JLL,Int. Spec.,54020175010001130001060\n37122,FORCE,CAROLYN,SLM,Int. Spec.,54020175010001130003090\n71365,PAGE,BILLIE,SM,Int. Spec.,54020175010001130001010\n1448,WEBB,WHITNEY,JLL,K,51000101110001130001060\n33278,LAURENT,JUDY,JLL,K,51000101110001130001060\n84054,LEARY,DELDRA,JLL,K,51000101110001130001060\n89133,THORNHILL,KATHY,JLL,K,51000101110001130001060\n11184,ANDERSON,NICOLE,SLM,K,51000101110001130003090\n12645,BAHNSEN,WENDY,SLM,K,51000101110001130003090\n1501,GAY,MEREDITH,SLM,K,51000101110001130003090\n25277,TURNER,JANDA,SLM,K,51000101110001130003090\n37776,FRAZIER,TIFFANY,SLM,K,51000101110001130003090\n63619,MCALLISTER,MARY,SLM,K,51000101110001130003090\n63849,MCDOUGAL,DOROTHY,SLM,K,51000101110001130003090\n1213,DAVIS,ANGELA,SM,K,51000101110001130001010\n1225,BAKER,LARISSA,SM,K,51000101110001130001010\n13897,BARR,BROOKE,SM,K,51000101110001130001010\n1400,MCREE,KATHERINE,SM,K,51000101110001130001010\n14480,BAXTER,ANGELIA,SM,K,51000101110001130001010\n1486,WYANT,LEANNE,SM,K,51000101110001130001010\n50650,HOWELL,JANAE,SM,K,51000101110001130001010\n79328,ROESCH,LAURA,SM,K,51000101110001130001010\n81892,COSPER,JENNIFER,SM,K,51000101110001130001010\n11297,KAY,ELIZABETH,SE,K,51000101110001130020520\n1586,BUTLER,CARLA,SE,K,51000101110001130020520\n54812,JOHNSON,TRENNIA,SE,K,51000101110001130020520\n68409,MCCOGGLE,TIFFANY,SE,K,51000101110001130020520\n1201,SHOUP,KATHERINE,WGN,K,51000101110001130010520\n1580,MONROE,TALIA,WGN,K,51000101110001130010520\n20572,BLAKE,TELONICA,WGN,K,51000101110001130010520\n21350,OSBORNE,MARGO,WGN,K,51000101110001130010520\n21637,BROOMBERG,DWAN,WGN,K,51000101110001130010520\n35043,EWING,PATRICIA,WGN,K,51000101110001130010520\n49540,HUDSON,KAREN,WGN,K,51000101110001130010520\n67032,MINSON,STACY,WGN,K,51000101110001130010520\n97015,WRIGHT,SHEILA,WGN,K,51000101110001130010520\n10581,BLUE,DELVERNA,PLC,Math,51000104110001130060020\n1245,PATE,TIMOTHY,PLC,Math,51000104110001130060020\n1124,PARTEN,DEREK,VECA,Math,51000104110001130060010\n1642,CRAIG,DONNA,VECA,Math,51000104110001130060010\n11182,ANDERSON,MIXSON,VHS,Math,51000104110001130002730\n1127,ROBINSON,THOMAS,VHS,Math,51000104110001130002730\n1148,JIMISON,JONELLE,VHS,Math,54020175010001130002730\n1216,CRAWFORD,JACOB,VHS,Math,51000104110001130002730\n1266,KUDYK,KIMBERLE,VHS,Math,54020175010001130002730\n1311,MILLER,AMY,VHS,Math,51000104110001130002730\n1428,SWANSON,DAVID,VHS,Math,51000104110001130002730\n1434,RENFRO,NATHANIEL,VHS,Math,51000104110001130002730\n1468,MCLEOD,STEPHEN,VHS,Math,51000104110001130002730\n1628,LEACH,JOSHUA,VHS,Math,51000221110001130002730\n20606,BERRY,THOMAS,VHS,Math,51000104110001130002730\n23425,BURKS,APRIL,VHS,Math,51000104110001130002730\n25101,TURNER,ELESHIA,VHS,Math,51000104110001130002730\n32909,DOWDY,HEATHER,VHS,Math,51000104110001130002730\n47241,HENDERSON,JUSTIN,VHS,Math,51000104110001130002730\n51742,HUNTER,WANDA,VHS,Math,51000104110001130002730\n55618,JONES,JAMES,VHS,Math,51000104110001130002730\n66257,MILLER,JOHN,VHS,Math,51000104110001130002730\n70815,NORMAN,THOMAS,VHS,Math,51000211110001130002730\n72490,PENDLETON,ALICE,VHS,Math,51000104110001130002730\n54390,JOHNSON,GREGORY,VHS,Metals,51000301110001130002730\n1453,RAINGE,REGINALD,NMS,Mid. GR LA,54020175010001130001950\n1476,ALCIDONICE,SANDY,NMS,Mid. GR LA,54020175010001130001950\n29747,CREWS,VICTORIA,NMS,Mid. GR LA,51000108110001130001950\n29755,CRAWFORD,KIMBERLY,NMS,Mid. GR LA,51000108110001130001950\n55654,GREEN,L.,NMS,Mid. GR LA,51000108110001130001950\n57770,LAMPERT,LESLEE,NMS,Mid. GR LA,51000108110001130001950\n69720,NECK,CYNTHIA,NMS,Mid. GR LA,51000108110001130001950\n85766,SMITH,VALERIE,NMS,Mid. GR LA,51000108110001130001950\n1283,LEFILES,JESSICA,VECA,Mid. GR LA,51000108110001130060010\n44090,HALL,MEREDITH,VECA,Mid. GR LA,51000104110001130060010\n12703,BAKER,ELIZABETH,VMS,Mid. GR LA,51000108110001130001030\n1436,CROSBY,STEPHEN,VMS,Mid. GR LA,51000108110001130001030\n26550,CLEMENTS,CHRISTI,VMS,Mid. GR LA,51000108110001130001030\n39469,COOPER,NICOLE,VMS,Mid. GR LA,51000108110001130001030\n46175,CARTER,SHARON,VMS,Mid. GR LA,51000108110001130001030\n58552,LAYTON,GARLAND,VMS,Mid. GR LA,51000108110001130001030\n80004,ROGERS,WILLIAM,VMS,Mid. GR LA,51000108110001130001030\n91941,WHITFIELD,NADINE,VMS,Mid. GR LA,51000108110001130001030\n97500,YANCY,JANIDA,VMS,Mid. GR LA,51000108110001130001030\n1183,DOUGLAS,ANGEL,NMS,Mid. GR Math,51000108110001130001950\n1445,THOMPSON,SUNNY,NMS,Mid. GR Math,54020175010001130001950\n1482,LEPIC,RAYNE,NMS,Mid. GR Math,51000108110001130001950\n26880,COBB,DENCIE,NMS,Mid. GR Math,51000108110001130001950\n35346,FERREBEE,WILLIE,NMS,Mid. GR Math,51000108110001130001950\n55615,JONES,EVONNIE,NMS,Mid. GR Math,51000108110001130001950\n69836,NELSON,DON,NMS,Mid. GR Math,51000108110001130001950\n85420,SMITH,KAREN,NMS,Mid. GR Math,51000108110001130001950\n94136,WARREN-WILLIAMS,TIFFANIE,NMS,Mid. GR Math,51000108110001130001950\n1646,PRITCHETT,TONIE,PLC,Mid. GR Math,51000108110001130060020\n1134,SCOTT,JACQUE,VMS,Mid. GR Math,51000108110001130001030\n1268,GIBBS,ANDREW,VMS,Mid. GR Math,51000108110001130001030\n1608,TAYLOR,LATIA,VMS,Mid. GR Math,51000108110001130001030\n1619,MOORE,SARAH,VMS,Mid. GR Math,51000108110001130001030\n25250,CHAMBERS,ROBBIE,VMS,Mid. GR Math,51000108110001130001030\n41632,GOSIER,LATASHIA,VMS,Mid. GR Math,51000108110001130001030\n67519,MONCRIEF,JOSEPH,VMS,Mid. GR Math,51000108110001130001030\n88702,THOMAS,ELIZABETH,VMS,Mid. GR Math,51000108110001130001030\n88875,THOMAS,STEPHANIE,VECA,Mid. GRs Computer,51000104110001130060010\n1162,HEAD,TARA,NMS,Mid. GRs Sci.,51000108110001130001950\n1611,MCALPIN,LESLIE,NMS,Mid. GRs Sci.,51000108110001130001950\n1627,OSBORNE,CHRISTINA,NMS,Mid. GRs Sci.,51000108110001130001950\n20607,BEVERLY,BRENDA,NMS,Mid. GRs Sci.,51000108110001130001950\n25357,CHASTANG,MELANIE,NMS,Mid. GRs Sci.,51000108110001130001950\n90530,WALLER,SHIRLEY,NMS,Mid. GRs Sci.,51000108110001130001950\n92891,WILLIAMS,DONNA,NMS,Mid. GRs Sci.,51000108110001130001950\n46195,HARVEY,ANTAWN,PLC,Mid. GRs Sci.,51000108110001130060020\n64967,MCPHERSON,NANCY,PLC,Mid. GRs Sci.,51000108110001130060020\n1126,MARSHALL,JOHNNIE,VECA,Mid. GRs Sci.,51000108110001130060010\n1135,RAINEY,MYLES,VMS,Mid. GRs Sci.,51000108110001130001030\n1272,TIFT,ANDRALYN,VMS,Mid. GRs Sci.,51000108110001130001030\n1375,SCHNEIDER,CHARLES,VMS,Mid. GRs Sci.,54020175010001130001030\n1644,BROOKS,DEANNA,VMS,Mid. GRs Sci.,51000108110001130001030\n49105,HOGAN,JOHN,VMS,Mid. GRs Sci.,51000108110001130001030\n63642,MCCALL,ANNA,VMS,Mid. GRs Sci.,51000108110001130001030\n77133,PATTERSON,ESTHER,VMS,Mid. GRs Sci.,51000108110001130001030\n96443,WOOTEN,LANE,VMS,Mid. GRs Sci.,51000108110001130001030\n1458,PONDER,RACHEL,NMS,Mid. GRs SS,54020175010001130001950\n27360,ROSS,SAMETHA,NMS,Mid. GRs SS,51000108110001130001950\n49438,LAMPKIN,TIFFANY,NMS,Mid. GRs SS,51000108110001130001950\n56165,JORDAN,MARCUS,NMS,Mid. GRs SS,51000108110001130001950\n58870,LEE,OSCAR,NMS,Mid. GRs SS,51000108110001130001950\n81550,SANDERBECK,DIANE,NMS,Mid. GRs SS,51000108110001130001950\n91997,WHITWORTH,BRANDON,NMS,Mid. GRs SS,51000108110001130001950\n87576,SULLIVAN,ROBERT,PLC,Mid. GRs SS,51000104110001130060020\n1473,ARNETT,JORDAN,VECA,Mid. GRs SS,51000108110001130060010\n20636,BREEDEN,SHARON,VMS,Mid. GRs SS,51000108110001130001030\n29754,CRIBBS,MATTHEW,VMS,Mid. GRs SS,51000108110001130001030\n44123,HALL,STEVEN,VMS,Mid. GRs SS,51000108110001130001030\n46550,HAYNES,CYNTHIA,VMS,Mid. GRs SS,51000108110001130001030\n54721,JOHNSON,MARILYN,VMS,Mid. GRs SS,51000108110001130001030\n64231,MCINTOSH,WILLIAM,VMS,Mid. GRs SS,51000108110001130001030\n68098,MOORE,FERRELL,VMS,Mid. GRs SS,51000108110001130001030\n1472,LEWIS,LINDA,VHS,NJROTC,51000994010001130002730\n47238,HEMMELGARN,STEPHEN,VHS,NJROTC,51000994010001130002730\n87587,SUTTON,CURTIS,VHS,Public Safety,51000301110001130002730\n42019,GRAHAM,SHERRIE,NMS,REP,51000221110001130001950\n70874,NORTON,BEN,NMS,REP,51000221110001130001950\n1431,LAMAR,DE'MARKIUS,VMS,REP,51000221110001130001030\n62936,MATCHETT,LINDA,VMS,REP,51000221110001130001030\n23300,BURGMAN,TONY,PLC,Sci.,51000104110001130060020\n32700,DIXON,CHARLIE,PLC,Sci.,51000104110001130060020\n31703,CHRISTOPHER,JAMIE,VECA,Sci.,51000104110001130060010\n10147,ADAMS,DAVID,VHS,Sci.,51000104110001130002730\n10960,ALONSO,DENITA,VHS,Sci.,51000104110001130002730\n1650,SIMMONS,LISA,VHS,Sci.,51000211110001130002730\n1651,PATTERSON,CHARLES,VHS,Sci.,51000104110001130002730\n24997,CARTER,SHARON,VHS,Sci.,51000104110001130002730\n32896,DOUGHTY,BRENT,VHS,Sci.,51000104110001130002730\n32908,DOWLER,CAROL,VHS,Sci.,51000104110001130002730\n52212,HUTFILZ,REBECCA,VHS,Sci.,54020175010001130002730\n53365,JENNINGS,CHERYL,VHS,Sci.,51000104110001130002730\n56700,KEITH,HAZEL,VHS,Sci.,51000104110001130002730\n60312,LOWTHER,ROOSEVELT,VHS,Sci.,51000104110001130002730\n73880,PLUMLY,CINDY,VHS,Sci.,51000211110001130002730\n82000,SCARBOR,BENJAMIN,VHS,Sci.,51000211110001130002730\n88090,GUILBEAU,SONJA,VHS,Sci.,51000104110001130002730\n1618,WRIGHT,REJEANA,JLL,2nd GR TCHR,51000102110001130001060\n24465,CAMPBELL,JOCELYN,JLL,2nd GR TCHR,51000102110001130001060\n36800,NORWOOD,SHALINA,JLL,2nd GR TCHR,51000102110001130001060\n79197,ROBINSON,JOYCE,JLL,2nd GR TCHR,51000102110001130001060\n94242,KNIGHT,ZIDLAYIN,JLL,2nd GR TCHR,51000102110001130001060\n23069,BULLOCH,ASHLEY,SLM,2nd GR TCHR,51000102110001130003090\n23557,BURNHAM,STEPHANIE,SLM,2nd GR TCHR,54020175010001130003090\n39446,GARNER,LINDA,SLM,2nd GR TCHR,51000102110001130003090\n60801,LUKENS,JENNIFER,SLM,2nd GR TCHR,51000102110001130003090\n78285,RILEY,CICELY,SLM,2nd GR TCHR,51000102110001130003090\n13390,WALLER,PAMELA,SM,2nd GR TCHR,51000102110001130001010\n1440,WHITE,JERICA,SM,2nd GR TCHR,51000102110001130001010\n1454,BRADLEY,ALYSSA,SM,2nd GR TCHR,51000102110001130001010\n1502,JOINER,REBECCA,SM,2nd GR TCHR,51000102110001130001010\n1616,HOWARD,STEPHANIE,SM,2nd GR TCHR,51000102110001130001010\n29713,CRENSHAW,ALLYSON,SM,2nd GR TCHR,51000102110001130001010\n41297,HOLTON,JULIE,SM,2nd GR TCHR,51000102110001130001010\n42016,KIMBROUGH,REGINA,SM,2nd GR TCHR,51000102110001130001010\n29758,CREWS,SHARON,SE,2nd GR TCHR,51000102110001130020520\n58898,LEWIS,KIM,SE,2nd GR TCHR,54020175010001130020520\n82100,SCHWEITZER,GLENDA,SE,2nd GR TCHR,51000102110001130020520\n16780,SOLOMON,SARAH,WGN,2nd GR TCHR,51000102110001130010520\n31709,DAWSON,TAMMI,WGN,2nd GR TCHR,51000102110001130010520\n32965,DOWNING,LINDA,WGN,2nd GR TCHR,51000102110001130010520\n33295,LANE,WENDY,WGN,2nd GR TCHR,51000102110001130010520\n63657,MCCASKEY,JACQULINE,WGN,2nd GR TCHR,54020175010001130010520\n67727,JACKSON,MELANIE,WGN,2nd GR TCHR,51000102110001130010520\n85790,PAIGE,SANDRA,WGN,2nd GR TCHR,51000102110001130010520\n91435,BURFORD,WENDY,WGN,2nd GR TCHR,51000102110001130010520\n25127,CASTLEBERRY,CYNTHIA,PLC,SS,51000104110001130060020\n50376,JEFFORDS,ROBERT,PLC,SS,51000104110001130060020\n53355,JENNINGS,JAMES,PLC,SS,51000108110001130060020\n1279,HARRELL,MATTHEW,VHS,SS,54020175010001130002730\n1280,PARTEN,CRYSTAL,VHS,SS,51000104110001130002730\n1441,MORTONSON,SABRINA,VHS,SS,54020175010001130002730\n36250,FITZGERALD,MARIEH,VHS,SS,51000104110001130002730\n37120,ELDRIDGE,JENNIFER,VHS,SS,51000211110001130002730\n43996,HAIRE,CHARLES,VHS,SS,51000104110001130002730\n52092,JAMES,SANDRA,VHS,SS,51000104110001130002730\n52600,JACK,JOHN,VHS,SS,51000104110001130002730\n57593,KIRKLAND,GLADYS,VHS,SS,51000104110001130002730\n58499,LAWHORN,EVE,VHS,SS,51000211110001130002730\n85963,STONE,HOLLY,VHS,SS,51000104110001130002730\n87434,STRIGGLES,LARRY,VHS,SS,51000104110001130002730\n91740,WHITE,JAMES,VHS,SS,51000104110001130002730\n92080,WILCOX,EDWARD,VHS,SS,51000104110001130002730\n33670,DUNLAP,MARGARITA,VHS,Spanish,51000211110001130002730\n1109,LARKINS,TESHA,JLL,SPED,51000204110001130001060\n11306,BATTLES,SARA,JLL,SPED,51000204110001130001060\n1474,WILSON,KELLI,JLL,SPED,51000204110001130001060\n1647,STALVEY,TIERSA,JLL,SPED,51000204110001130001060\n39461,WHITEHEAD,SHIRLEY,JLL,SPED,51000205110001130001060\n1286,TAYLOR,JOHN,NMS,SPED,51000204110001130001950\n1648,CHANEY,HELEN,NMS,SPED,51000204110001130001950\n1655,MCMILLAN,KAYLA,NMS,SPED,51000204110001130001950\n1683,DARRAGH,CRAIG,NMS,SPED,51000204110001130001950\n41210,GOODMAN,DEIDRA,NMS,SPED,51000204110001130001950\n44656,HAMMOND,ERNEST,NMS,SPED,51000204110001130001950\n74480,PORTER-BARNES,MARILEE,NMS,SPED,51000204110001130001950\n88445,TERRELL,DEBORAH,NMS,SPED,51000203110001130001950\n62946,SMITH,PATRICE,PLC,SPED,51000204110001130060020\n63400,MAY,DEBORAH,PLC,SPED,51000204110001130060020\n1278,BERRYHILL,DEIDRE,SLM,SPED,51000204110001130003090\n1294,HERRING,KAYLA,SLM,SPED,51000204110001130003090\n75972,STONE,JOANN,SLM,SPED,51000204110001130003090\n77225,ORTMEYER,KIMBERLY,SLM,SPED,51000203110001130003090\n84040,SIMS,CATHY,SLM,SPED,51000204110001130003090\n85436,SMITH,LAURA,SLM,SPED,51000204110001130003090\n31022,DAVIS,CARLA,SM,SPED,51000204110001130001010\n37725,ANDREWS,KRISTIE,SM,SPED,51000204110001130001010\n39599,GAY,JENNIFER,SM,SPED,51000204110001130001010\n49180,HOLCOMBE,KIMBERLY,SM,SPED,51000204110001130001010\n57548,KING,TAMMY,SM,SPED,51000204110001130001010\n69835,NELSON,JESSICA,SM,SPED,51000204110001130001010\n86220,SPENCER,ELEANOR,SM,SPED,51000205110001130001010\n89737,TURNER,CHRISTIE,SM,SPED,51000205110001130001010\n72390,PELLOW,MELINDA,SE,SPED,51000204110001130020520\n91930,WHITE,STEPHEN,SE,SPED,51000204110001130020520\n1430,DENNIS,JACQUELYN,VHS,SPED,51000204110001130002730\n1464,TURNER,SANDY,VHS,SPED,51000204110001130002730\n1633,WATERS,LAVONDA,VHS,SPED,51000204110001130002730\n1649,BENJAMIN,CHAURITA,VHS,SPED,51000204110001130002730\n23051,BRYANT,SWANDOLYN,VHS,SPED,51000204110001130002730\n33057,WALLACE,CAROL,VHS,SPED,51000205110001130002730\n44649,HAMM,TAMMY,VHS,SPED,51000204110001130002730\n44726,HAYNES,ANTONIO,VHS,SPED,51000204110001130002730\n44880,HANNANS,JESSIE,VHS,SPED,51000205110001130002730\n52386,INGRAM,KATHY,VHS,SPED,51000204110001130002730\n54777,WILLIAMS,SHUNTINA,VHS,SPED,51000204110001130002730\n83310,SHARP,SHAWN,VHS,SPED,51000205110001130002730\n87000,STEWARD,TERRI,VHS,SPED,51000204110001130002730\n88126,TAYLOR,TRUETT,VHS,SPED,51000204110001130002730\n90229,VINCENT,LISA,VHS,SPED,51000204110001130002730\n92510,WILKERSON,RACHAEL,VHS,SPED,51000205110001130002730\n1152,HENDERSON,BRITTANY,VMS,SPED,51000204110001130001030\n1271,KELLY,RYAN,VMS,SPED,51000204110001130001030\n1288,BERRY,ASHLEY,VMS,SPED,51000204110001130001030\n1630,BISHOP,CAROLYN,VMS,SPED,51000204110001130001030\n23740,BURTON,ROBIN,VMS,SPED,51000204110001130001030\n24787,CARSWELL,DERROLYNNE,VMS,SPED,51000204110001130001030\n24793,COOK,SHANA,VMS,SPED,51000205110001130001030\n70242,NEWBERN,CAROLE,VMS,SPED,51000204110001130001030\n96130,BELLFLOWER,CHRISTY,VMS,SPED,51000204110001130001030\n1385,BAKER,KIMBERLY,WGN,SPED,51000204110001130010520\n1617,HERRINGTON,CHRISTINA,WGN,SPED,51000204110001130010520\n1659,SHEELEY,MARY,WGN,SPED,51000204110001130010520\n35498,FIGAROLA,PATRICIA,WGN,SPED,51000204110001130010520\n44653,HILTON,KRISTIE,WGN,SPED,51000204110001130010520\n70823,NORTH,KELLEY,WGN,SPED,51000204110001130010520\n78062,RICE,CHERYL,WGN,SPED,51000206110001130010520\n91250,WELDON,KATHY,WGN,SPED,51000203110001130010520\n1606,BAILIE,CALLIE,JLL,SLP,51000205110001130001060\n1671,SWILLEY,CAROLYN,NMS,SLP,51000204110001130001950\n39575,GASKINS,LAURIE,SLM,SLP,51000204110001130003090\n47376,HENRY,CANDEE,SLM,SLP,51000204110001130003090\n68089,MOORE,CALISTA,SM,SLP,51000204110001130001010\n1466,BLANTON,KARI,SE,SLP,51000204110001130020520\n71230,ORENSTEIN,LYNN,VMS,SLP,51000204110001130001030\n57787,LANCASTER,SYLVIA,WGN,SLP,51000204110001130010520\n25930,CLARKE,ALICIA,JLL,3rd GR TCHR,51000102110001130001060\n47335,HENRY,SPRING,JLL,3rd GR TCHR,51000102110001130001060\n91960,WHITMER,AMBER,JLL,3rd GR TCHR,51000102110001130001060\n1261,WILLIAMS,TIFFANY,SLM,3rd GR TCHR,51000102110001130003090\n1443,DOBARD,AMANDA,SLM,3rd GR TCHR,51000102110001130003090\n81800,SANTANA,DEBBIE,SLM,3rd GR TCHR,51000102110001130003090\n82820,SEBRING,MARY,SLM,3rd GR TCHR,51000102110001130003090\n1226,PARKS,SHAJUANTAE,SM,3rd GR TCHR,51000102110001130001010\n1537,TEASLEY,JANE,SM,3rd GR TCHR,51000102110001130001010\n20489,ARNOLD,KERI,SM,3rd GR TCHR,51000102110001130001010\n20490,BAILEY,TAMMY,SM,3rd GR TCHR,51000102110001130001010\n31754,DEAN,KERRI,SM,3rd GR TCHR,51000102110001130001010\n41215,GODWIN,ANGELA,SM,3rd GR TCHR,51000102110001130001010\n1645,CURBEAM,MONTEZ,SE,3rd GR TCHR,51000102110001130020520\n57613,KNIGHT,KIMBERLY,SE,3rd GR TCHR,51000102110001130020520\n96444,WOOTEN,WENDELL,SE,3rd GR TCHR,51000102110001130020520\n1374,COURY,BRITTNEY,WGN,3rd GR TCHR,54020175010001130010520\n22539,BROWN,KAYLA,WGN,3rd GR TCHR,51000102110001130010520\n31698,DAW,LISA,WGN,3rd GR TCHR,51000102110001130010520\n57762,LAMB,MELANIE,WGN,3rd GR TCHR,51000102110001130010520\n63638,MCCALL,SHEILA,WGN,3rd GR TCHR,51000102110001130010520\n80334,GAY,ROBIN,WGN,3rd GR TCHR,51000102110001130010520\n97820,YOUNG,FRANCES,WGN,3rd GR TCHR,51000102110001130010520\n52690,JACKSON,HOPE,VECA,VECA TCHR,5402017501000113001030\n63910,MCDUFFIE,LANITA,VECA,VECA TCHR,51000108110001130060010\n1613,BATTLE,LATRICE,JLL,Pre K,55600154010001130001060\n77810,RUCKER,KAYCEE,JLL,Pre K,55600154010001130001060\n1668,PELLITTERI,NICHOLE,SLM,Pre K,55600154010001130003090\n1371,GUPTON,SABRINA,WGN,Pre K,55600154010001130010520\n1485,CHURCHILL,KATHERINE,WGN,Pre K,55600154010001130010520\n51745,LEWIS,JESSICA,WGN,SPED,51000262010001130010520\n91021,FERGUSON,REBECCA,WGN,SPED,51000262010001130010520\n28837,COPELAND,LATEASHA,SLM,Para,55600154010001140003090\n10180,ADAMS,JO-ANN,VHS,Art,51000104110001130002730\n88626,THOMAS,DONNA,JLL,Art TCHR,51000102110001130001060\n87173,STONE,AIMEE,NMS,Art TCHR,51000108110001130001950\n47520,HERNDON,HANNAH,SLM,Art TCHR,51000105110001130003090\n87845,CABRAL,CHRISTINE,SLM,Art TCHR,51000102110001130003090\n1299,LANE,SHERRYL,SM,Art TCHR,51000102110001130001010\n22628,BROWN,PAUL,SM,Art TCHR,51000105110001130001010\n1284,GREGORY,GAIL,SE,Art TCHR,51000102110001130020520\n24780,CARSON-COOK,KAREN,VHS,Art TCHR,51000104110001130002730\n80340,MIDDLETON,TERESA,VHS,Art TCHR,51000104110001130002730\n1287,FABER,ANGELA,VMS,Art TCHR,51000108110001130001030\n83575,BASS,JOY,WGN,Art TCHR,51000102110001130010520\n48237,HILL,ANDREW,VHS,Band Asst. Dir.,51000104110001130002730\n88881,THOMAS,MICHAEL,VHS,Band High School Dir.,51000104110001130002730\n57400,KIMBROUGH,CURTIS,NMS,Band TCHR,51000108110001130001950\n73099,PHILLIPS,TAURENCE,VHS,Choral High School Dir.,51000104110001130002730\n1149,HEADEN,JONATHAN,NMS,Chorus,51000108110001130001950\n52392,IPINA,RICARDO,VHS,Drama,51000104110001130002730\n1446,WILSON,JOSEPH,VHS,Drivers Education,51000104110001130002730\n52900,STOKES,MICHELE,JLL,PE,51000102110001130001060\n70989,OLIVER,JONATHAN,JLL,PE,51000105110001130001060\n25110,CASSOTTA,ROBIN,SLM,PE,51000105110001130003090\n73129,SKRINE,TIEKA,SLM,PE,51000102110001130003090\n1469,MUEHLING,JASON,SM,PE,51000102110001130001010\n53367,JENNINGS,JOSHUA,SM,PE,51000105110001130001010\n89985,UMPLEBY,ALBERT,SM,PE,51000102110001130001010\n1560,HARVILLE,MARK,SE,PE,51000102110001130020520\n1145,DAVIS,KELLY,WGN,PE,51000105110001130010520\n1631,WINK,CAROL,WGN,PE,51000105110001130010520\n46205,HARVIN,MAURICE,WGN,PE,51000102110001130010520\n60800,LUKE,WENDY,WGN,PE,51000102110001130010520\n93535,THOMAS,KEISHA,JLL,Music,51000102110001130001060\n1585,PELLITTERI,BRITTANY,SLM,Music,51000102110001130003090\n89000,TURNMEYER,AMY,SM,Music,51000102110001130001010\n1285,COOPER,ASHLEY,SE,Music,51000102110001130020520\n11666,ARMSTRONG,KATHRYN,WGN,Music,51000105110001130010520\n80760,RUMSTAY,SUE,WGN,Music,51000102110001130010520\n1138,BURNS,CECILIA,VHS,French,51000104110001130002730\n50100,HUBERT,PAMELA,VHS,French,51000104110001130002730\n87860,TARPLEY,BRADLEY,VECA,Health/PE,51000104110001130060010\n1101,RODEMAKER,ALAN,VHS,Health/PE,51000104110001130002730\n1122,LOUDERMILK,JAMES,VHS,Health/PE,51000104110001130002730\n1418,GROVES,ROBERT,VHS,Health/PE,51000104110001130002730\n1471,POWERS,SAMANTHA,VHS,Health/PE,51000104110001130002730\n1592,SAVAGE,AAIRON,VHS,Health/PE,51000104110001130002730\n39454,WHITEHEAD,JANA,VHS,Health/PE,51000104110001130002730\n83845,SHUMAN,RUTHERFORD,VHS,Health/PE,51000104110001130002730\n32465,DENTON,EDGAR,NMS,Mid. GR PE,51000108110001130001950\n63930,MCFADDEN,FLORENCE,NMS,Mid. GR PE,51000108110001130001950\n82480,SCRUGGS,ANDRE,NMS,Mid. GR PE,51000108110001130001950\n38530,FUTCH,ROBERT,VMS,Mid. GR PE,51000108110001130001030\n63698,MCCONNEHEAD,KEITH,VMS,Mid. GR PE,51000108110001130001030\n87384,STRICKLAND,KELLIE,VMS,Mid. GR PE,51000108110001130001030\n53035,JARVIS,TONI,VMS,Mid. GR Theatrical Music,51000108110001130001030\n40543,THOMAS,MONIA,NMS,Mid. GRs Careers,51000108110001130001950\n60291,LOTT,PHYLLIS,VMS,Mid. GRs Careers,51000108110001130001030\n88096,TAYLOR,DEBRA,NMS,Mid. GRs Computer,51000108110001130001950\n25675,CHRISTIAN,KIMBERLY,VMS,Mid. GRs Computer,51000108110001130001030\n1609,HUSS,CHRISTINA,VMS,Mid. GRs Music,51000108110001130001030\n20631,BRASHIER,SUSAN,VMS,Mid. GRs Music,51000108110001130001030\n1143,PAREDES,MARCELA,VMS,Mid. GRs Spanish,51000108110001130001030\n20590,BRAGG,LARRY,NMS,Mid. GRs Tech,51000108110001130001950\n20546,BLEVINS,ROBERT,VMS,Mid. GRs Tech,51000108110001130001030\n13370,BARKLEY,CARMEN,VHS,Spanish,51000104110001130002730\n1366,FEIN,SARAH,VHS,Spanish,51000104110001130002730\n39477,MAJESKI,TANYA,VHS,Spanish,51000104110001130002730\n48326,HILTON,JANETTE,VHS,Spanish,51000104110001130002730\n18228,KING,PAMELA,JLL,Elementary Principal,51000999024001130001060\n31291,DAVIS,JOHN,SLM,Elementary Principal,51000999024001130003090\n41000,GLOVER,CHARLES,SM,Elementary Principal,51000999024001130001010\n66258,MILLER,KIM,SE,Elementary Principal,51000999024001130020520\n32598,DIAZ,FRANCISCO,WGN,Elementary Principal,51000999024001130010520\n78650,ROBERTS,MICHAEL,PLC,High School Principal,51000999024001130060020\n78115,RICHARDSON,JANICE,VHS,High School Principal,51000999024001130002730\n11001,ALTMAN,DANIEL,NMS,Mid. GRs Principal,51000999024001130001950\n57575,DELOACH,ELIZABETH,VMS,Mid. GRs Principal,51000999024001130001030\n29765,MCCRAE,LACONYA,JLL,Asst. Principal,51000999024001130001060\n29746,CROWELL,VIRGINIA,NMS,Asst. Principal,51000999024001130001950\n31693,DAW,KEVIN,NMS,Asst. Principal,51000999024001130001950\n88869,THOMAS,ROYCE,NMS,Asst. Principal,51000999024001130001950\n82495,SCURRY-BROOKLIN,CYNTHIA,PLC,Asst. Principal,51000999024001130060020\n51753,HUNT,LINDA,SLM,Asst. Principal,51000999024001130003090\n70910,NUNN,COTINA,SLM,Asst. Principal,51000999024001130003090\n31016,HAUGABROOK,ARTRICE,SM,Asst. Principal,51000999024001130001010\n48120,HIERS,JULIE,SM,Asst. Principal,51000999024001130001010\n1635,VINCENT,EMMANUEL,SE,Asst. Principal,51000999024001130020520\n93563,MCKINNEY,MAE,VECA,Asst. Principal,51000999024001130060010\n1614,MOODY,KENDRICK,VHS,Asst. Principal,51000999024001130002730\n25342,CHAPPUIS,DANIEL,VHS,Asst. Principal,51000999024001130002730\n25650,CHASTAIN,CHRISTOPHER,VHS,Asst. Principal,51000999024001130002730\n31708,DAY,LOOMIS,VHS,Asst. Principal,51000999024001130002730\n78050,MCTIER,MARY,VHS,Asst. Principal,51000999024001130002730\n86827,STEPHENS,DAVID,VHS,Asst. Principal,51000999024001130002730\n88868,THOMAS,RICKY,VHS,Asst. Principal,51000999024001130002730\n78260,RIDLEY-MARSHALL,LOUEL,VMS,Asst. Principal,51000999024001130001030\n81425,SAMARAS,JOHN,VMS,Asst. Principal,51000999024001130001030\n81470,SAMPSON,VALICA,VMS,Asst. Principal,51000999024001130001030\n82850,SEIPLE,LESTER,WGN,Asst. Principal,51000999024001130010520\n93041,WILLIAMS,ILA,WGN,Asst. Principal,51000999024001130010520\n44091,HALL,INGRID,VECA,Mid. GRs Principal,51000999024001130060010\n63680,MCCUTCHIN,DONNA,SLM,Para,51000205110001140003090\n1641,HARRISON,LAVAL,SLM,ISS Para,51000507110001140003090\n60161,LOCHER,MARSHALL,SM,ISS Para,51000507110001140001010\n57495,KING,MYRA,SE,ISS Para,51000507110001140020520\n1612,JONES,DEMARIO,VHS,ISS Para,51000507110001140002730\n1615,GREEN,D'TANYIAN,VHS,ISS Para,51000507110001140002730\n21345,BRINSON,KAREN,VMS,ISS Para,51000507110001140001030\n1083,WILSON,AVIS,JLL,Para,51000101110001140001060\n1407,STEVENSON,SARAH,JLL,Para,51000101110001140001060\n31601,DAVIS,TAMELA,JLL,Para,51000101110001140001060\n32890,BROWN,SAMANTHA,JLL,Para,51000206110001140001060\n47255,HENDERSON,SHAWN,JLL,Para,51000206110001140001060\n47320,SIMMONS,OBEATRICE,JLL,Para,51000507110001140001060\n56815,JOHNSON,ASHA,JLL,Para,51000101110001140001060\n68071,GORDON,CATHY,JLL,Para,51000131022201140001060\n88879,THOMAS,TRACELYN,JLL,Para,51000101110001140001060\n93452,WILLIAMS,JOYCE,JLL,Para,51000101110001140001060\n32984,DOWNS,WILMA,NMS,Para,51000206110001140001950\n52887,JAMES,BRIDGETTE,NMS,Para,51000205110001140001950\n58841,LEE,BARBARA,NMS,Para,51000131022201140001950\n67580,MONTGOMERY,SAUNDRA,NMS,Para,51000205110001140001950\n68726,MORRIS,ARQUILLIA,NMS,Para,51000507110001140001950\n10655,ALEXANDER,TONYOUR,SLM,Para,51000101110001140003090\n1297,STUBBS,MELISSA,SLM,Para,51000101110001140003090\n1522,SCHNETZER,JENNIFER,SLM,Para,51000101110001140003090\n22090,BROWN,JACQUELINE,SLM,Para,51000206110001140003090\n22799,BROWN,SHUNTARA,SLM,Para,51000101110001140003090\n23035,BRYANT,AVA,SLM,Para,51000101110001140003090\n32210,DELL,NANCY,SLM,Para,51000101110001140003090\n34537,EDWARDS,MARY,SLM,Para,51000101110001140003090\n44121,HALL,ROBIN,SLM,Para,51000205110001140003090\n47245,HENDERSON,LAVONIA,SLM,Para,51000205110001140003090\n53005,JARAMILLO,STEPHANIE,SLM,Para,51000101110001140003090\n73501,PITTMAN,JUDIE,SLM,Para,51000202110001140003090\n82510,SCURRY,MELISSA,SLM,Para,51000202110001140003090\n83378,SHAW,LEAH,SLM,Para,51000101110001140003090\n87414,STRICKLAND,TANEISHA,SLM,Para,51000131022201140003090\n1499,PLY,ANGELA,SM,Para,51000101110001140001010\n1500,COATS,LAUREN,SM,Para,51000101110001140001010\n1540,BELL,BRANDI,SM,Para,51000202110001140001010\n1638,WARREN,ELLEN,SM,Para,51000101110001140001010\n1657,WALKER,ASHLEY,SM,Para,51000101110001140001010\n20560,BRADLEY,MELISSA,SM,Para,51000205110001140001010\n20610,BERLIN,MARTHA,SM,Para,51000101110001140001010\n55653,JONES,MOLLIE,SM,Para,51000205110001140001010\n56548,KAZI,GOURI,SM,Para,51000101110001140001010\n57500,KING,ROSA,SM,Para,51000205110001140001010\n71635,PARKER,LEE,SM,Para,51000101110001140001010\n77853,REYNOLDS,BRITNEY,SM,Para,51000206110001140001010\n83380,SHAW,OLIVIA,SM,Para,51000101110001140001010\n83385,SHAW,SHARON,SM,Para,51000101110001140001010\n86638,STANALAND,KARLA,SM,Para,51000101110001140001010\n91328,WEST,ELIZABETH,SM,Para,51000131022201140001010\n1597,PATTERSON,ASHLEY,SE,Para,51000101110001140020520\n1640,JONES,ALESHIA,SE,Para,51000101110001140020520\n24995,CARTER,VIOLA,SE,Para,51000206110001140020520\n29770,CUMBESS,JUDITH,SE,Para,51000131022201140020520\n49570,HOLMES,EULA,SE,Para,51000101110001140020520\n71251,ORR,LINDA,SE,Para,51000101110001140020520\n80348,BEBO,SUSAN,SE,Para,51000101110001140020520\n90672,WARD,JAMES,SE,Para,54040282410001140020520\n11908,MCKINNON,CAROLYN,VHS,Para,51000202110001140002730\n1519,CLARK,CORA,VHS,Para,51000205110001140002730\n1670,CARTER,NYEASHA,VHS,Para,51000301110001140002730\n20533,BLACK,LATONYA,VHS,Para,51000205110001140002730\n42021,GRAHAM,TRACEY,VHS,Para,51000205110001140002730\n45450,HARRELL,CHARLES,VHS,Para,51000206110001140002730\n52766,JACKSON,VIRGIL,VHS,Para,51000206110001140002730\n53973,JOHNSON,CARLO,VHS,Para,51000205110001140002730\n56199,JORDAN,THOMAS,VHS,Para,51000205110001140002730\n58875,LEWIS,TAMMY,VHS,Para,51000205110001140002730\n58892,LEWIS,EDDIE,VHS,Para,51000206110001140002730\n58899,LEWIS,JOSEPHINE,VHS,Para,51000205110001140002730\n63913,DENEGALL,BRENDA,VHS,Para,51000205110001140002730\n78605,ROBERTS,BETTY,VHS,Para,51000205110001140002730\n88085,TAYLOR,GAYNELL,VHS,Para,51000205110001140002730\n88435,TERRELL,ANGELIA,VHS,Para,51000205110001140002730\n93680,WILLIAMS,PYNALE,VHS,Para,51000206110001140002730\n11282,ARNOLD,DELIA,VMS,Para,51000206110001140001030\n28860,COPELAND,TEREATHA,VMS,Para,51000206110001140001030\n41240,GOINS,SONJA,VMS,Para,51000205110001140001030\n42445,GREEN,JENNIFER,VMS,Para,51000131022201140001030\n56715,KELLEY,CARRIE,VMS,Para,51000205110001140001030\n63814,MCCRAE,PATRICIA,VMS,Para,51000206110001140001030\n87480,STRONG,BEVERLY,VMS,Para,51000205110001140001030\n12885,BAKER,LAVORIS,WGN,Para,51000101110001140010520\n1301,SMITH,RONNI,WGN,Para,51000101110001140010520\n1346,HUGHES,DEBORAH,WGN,Para,51000262010001140010520\n1498,BUNTE,KARA,WGN,Para,51000101110001140010520\n1510,THOMAS,JANICE,WGN,Para,51000101110001140010520\n1656,MONTGOMERY,MYAN,WGN,Para,54040282010001140010520\n34563,ELBAZ,JACKLYN,WGN,Para,51000101110001140010520\n35049,EWINGS,MARJORIE,WGN,Para,51000205110001140010520\n40695,WAKEFIELD,TRACY,WGN,Para,51000101110001140010520\n42154,GRAVLEE,MARGUERITE,WGN,Para,51000206110001140010520\n49435,HOLLIMON,ANGELA,WGN,Para,51000101110001140010520\n54759,JOHNSON,NELLIE,WGN,Para,51000507110001140010520\n55651,JONES,JULIET,WGN,Para,51000205110001140010520\n61213,MACKINZIE,JOANNA,WGN,Para,51000131022201140010520\n63668,MCCLAIN,KIM,WGN,Para,54040282010001140010520\n78116,REVILLS,PRINCESS,WGN,Para,51000206110001140010520\n81487,SAMUELS,LISA,WGN,Para,51000205110001140010520\n83891,SILVA,MARIAN,WGN,Para,51000101110001140010520\n84562,WILLIAMS,BRANDI,WGN,Para,51000262010001140010520\n85674,SMITH,PAULA,WGN,Para,51000101110001140010520\n86235,SPIKES,JUETHEL,WGN,Para,51000262010001140010520\n90671,WARD,JUDITH,WGN,Para,51000101110001140010520\n92190,JACKSON,LINDA,WGN,Para,51000101110001140010520\n97570,YATES,ELAINE,WGN,Para,51000205110001140010520\n1496,DAVIS,REBECCA,JLL,Pre K Para,55600154010001140001060\n47300,MILLER,ANGELA,JLL,Pre K Para,55600154010001140001060\n11178,ANDERSON,KANDICE,WGN,Pre K Para,55600154010001140010520\n67199,MITCHELL,SUSAN,WGN,Pre K Para,55600154010001140010520\n43885,GURLEY,LORILYN,VHS,HS REGISTRAR,50000000000000000000000\n86820,STEPHENS,DANA,VHS,HS REGISTRAR,50000000000000000000000\n21647,BROOME,BEVERLY,VMS,Registrar,50000000000000000000000\n50120,HORNE,CYNTHIA,VHS,Educational Interpreter,54040282410001450002730\n65570,MERCER,SUE,VHS,Educational Interpreter,54040282410001450002730\n1100,GILLESPIE,RANCE,VHS,Athletic Dir.,50000000000000000000000\n50280,HOUGH,LESLIE,JLL,School Nurse,50000000000000000000000\n1456,MATHENY,KELLY,NMS,School Nurse,50000000000000000000000\n65033,MCSWAIN,KIMBERLY,SLM,School Nurse,50000000000000000000000\n1556,BATSON,CHRISTINE,SM,School Nurse,50000000000000000000000\n39452,GARRETT,JENNIFER,SE,School Nurse,50000000000000000000000\n1130,KIELMA,DIANE,VHS,School Nurse,50000000000000000000000\n91721,WHITTINGTON,DEBORAH,VMS,School Nurse,50000000000000000000000\n1669,BRANDON,JENNE,WGN,School Nurse,50000000000000000000000\n90780,CRENSHAW,ALLISON,SM,SLP,50001000000000000000000\n82988,SERMONS,LINDA,JLL,Media Specialist,51000131022201130001060\n1682,BERRY,PAIGE,NMS,Media Specialist,51000131022201130001950\n41610,WALKER,NIEKISHA,SLM,Media Specialist,51000131022201130003090\n31595,BEAUFORT,MICHELLE,SM,Media Specialist,51000131022201130001010\n20300,WHITE EAGLE,NATASHA,SE,Media Specialist,51000131022201130020520\n46375,BENNETT,EBONYE,VHS,Media Specialist,51000131022201130002730\n58768,LEE,ALAN,VHS,Media Specialist,51000131022201130002730\n89720,TRUITT,KAREN,VMS,Media Specialist,51000131022201130001030\n83731,SHERMAN,PAMELA,WGN,Media Specialist,51000131022201130010520\n42057,HUDSON,ERICA,JLL,Counselor,50000000000000000000000\n1133,GILLESPIE,CLAUDETTE,SLM,Counselor,50000000000000000000000\n24496,CANNISTER,TRACY,SM,Counselor,50000000000000000000000\n65568,MERCER,SAMANTHA,SM,Counselor,50000000000000000000000\n29450,BOYD,DANITA,SE,Counselor,50000000000000000000000\n1483,WELCH,MEGAN,WGN,Counselor,50000000000000000000000\n40540,GIBBS,DAVESHA,WGN,Counselor,50000000000000000000000\n49441,HOLLIMON,WILLIAM,NMS,Counselor,50000000000000000000000\n90140,WILLIAMS,JENNIFER,NMS,Counselor,50000000000000000000000\n63024,FEDD,YOLANDA,PLC,Counselor,50000000000000000000000\n1327,DRAYTON,MELANIE,VHS,Counselor,50000000000000000000000\n40100,GIDDENS,SHERYL,VHS,Counselor,50000000000000000000000\n52680,JACKSON,HELEN,VHS,Counselor,50000000000000000000000\n58498,LAW,MICHAEL,VHS,Counselor,50000000000000000000000\n39600,GAY,THOMAS,VMS,Counselor,50000000000000000000000\n90522,WALKER,TARA,VMS,Counselor,50000000000000000000000\n87150,STOKES,ANGELA,SE,Migrant,50000000000000000000000\n30795,DARISO,TAMARA,JLL,Para,54020175029001140001060\n52609,JACKSON,ANITA,SE,Para,54020175029001140020520\n55755,JONES,RANDY,NMS,Hall Monitor,50000000000000000000000\n91026,WATSON,JEFFERY,VHS,Outside Security,50000000000000000000000\n1142,COLLINS,EDWARD,Transportation,Transportation Supervisor,50000000000000000000000\n31750,DEAN,JOYCE,VHS,Vocational Supervisor,50000000000000000000000\n97609,YEARBY,URAN,Transportation,Mechanic Supervisor,50000000000000000000000\n1048,BROWN,SETH,PLC,Dir. of LVCCY,50000000000000000000000\n";
$lines = explode("\n", $csv);
foreach ($lines as $line) {
if (trim($line) != '') {
$fields = explode(",", $line);
$empId = $fields[0];
$lastName = ucwords(strtolower($fields[1]));
$firstName = ucwords(strtolower($fields[2]));
$campusText = $fields[3];
$position = $fields[4];
$acct = $fields[5];
$campus = $locationsModel->getByName($campusText);
$campusID = $campus->id;
/* $employee = array(
'firstname'=>$firstName,
'lastname'=>$lastName,
'location'=>$campusID,
'position'=>$position,
'account_number'=>$acct,
'cp_id'=>''
);
print_r($employee);
*/
// $employeesModel->insert($employee);
$employee = $employeesModel->getByNameLocation($firstName, $lastName, $campusID);
if ($employee) {
$newData['cp_id'] = $empId;
$employeesModel->updateRecord($employee->id, $newData);
}
}
}
}
public static function deleteWebPage($gameId, $webPageId)
{
Locations::deleteLocationsForObject($gameId, 'WebPage', $webPageId);
Requirements::deleteRequirementsForRequirementObject($gameId, 'WebPage', $webPageId);
PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'WebPage', $webPageId);
$query = "DELETE FROM web_pages WHERE game_id = '{$gameId}' AND web_page_id = {$webPageId}";
$rsResult = Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error");
}
if (mysql_affected_rows()) {
return new returnData(0, TRUE);
} else {
return new returnData(0, FALSE);
}
}
public function deleteNode($gameId, $intNodeID)
{
Locations::deleteLocationsForObject($gameId, 'Node', $intNodeID);
Requirements::deleteRequirementsForRequirementObject($gameId, 'Node', $intNodeID);
PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'Node', $intNodeID);
$query = "DELETE FROM nodes WHERE game_id = {$gameId} AND node_id = {$intNodeID}";
$rsResult = Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error");
}
if (mysql_affected_rows()) {
return new returnData(0);
} else {
return new returnData(2, NULL, 'invalid node id');
}
}
public static function Init()
{
echo ">>>> Setting SAMP globals, PHP settings and timers ...\n";
SetGameModeText('ItalyMafia RPG v3.0');
AllowInteriorWeapons(1);
DisableInteriorEnterExits();
EnableStuntBonusForAll(false);
AllowAdminTeleport(true);
AddTimer(array('Core', 'SaveData'), 10000, 1);
ini_set('max_execution_time', 300);
echo ">>>> Starting logs ...\n";
Log::Init();
echo ">>>> Starting the keybinds manager ...\n";
Keybinds::Init();
echo ">>>> Starting the menus manager ...\n";
Menu::Init();
echo ">>>> Starting the skins manager ...\n";
Skins::Init();
echo ">>>> Starting the animations manager ...\n";
Animations::Init();
echo ">>>> Starting locations ...\n";
Locations::Init();
echo ">>>> Starting DB engine ...\n";
DB::Init();
echo ">>>> Starting houses ...\n";
Houses::Init();
echo ">>>> Starting factions ...\n";
Factions::Init();
echo ">>>> Starting players manager ...\n";
Players::Init();
echo ">>>> Starting vehicles manager ...\n";
Vehicles::Init();
echo ">>>> Starting accounts manager ...\n";
Accounts::Init();
echo ">>>> Starting messages manager ...\n";
Messages::Init();
echo ">>>> Creating the clock ...\n";
Core::StartClock();
echo ">>>> Starting gyms ...\n";
Gym::Init();
echo ">>>> Starting admins ...\n";
Admin::Init();
}
/**
* list locations
*
* @param resource the SQL result
* @return string the rendered text
*
* @see layouts/layout.php
**/
function layout($result)
{
global $context;
// empty list
if (!SQL::count($result)) {
$output = array();
return $output;
}
// we return an array of ($url => $attributes)
$items = array();
// process all items in the list
while ($item = SQL::fetch($result)) {
// url to view the location
$url = Locations::get_url($item['id']);
// initialize variables
$prefix = $suffix = '';
// flag new locations
if ($item['edit_date'] >= $context['fresh']) {
$suffix .= NEW_FLAG;
}
// build a valid label
if ($item['geo_place_name']) {
$label = Skin::strip($item['geo_place_name'], 10);
} else {
$label = $item['latitude'] . ', ' . $item['longitude'];
}
// the distance, if any
$distance = '';
if ($item['distance']) {
$distance = ' ' . round($item['distance'], -1) . ' km';
}
// list all components for this item
$items[$url] = array($prefix, $label, $suffix, 'basic', NULL);
}
// end of processing
SQL::free($result);
return $items;
}
public function test_create_instance_from_response()
{
$locations = Locations::fromResponse(include __DIR__ . '/../../_fixtures/location_response.php');
$this->assertInstanceOf(Locations::class, $locations);
$this->assertCount(10, $locations);
$this->assertSame('Berlin', $locations->getQuery());
$this->assertFalse($locations->isQueryCorrected());
foreach ($locations as $location) {
$this->assertInstanceOf(Location::class, $location);
}
$locationsAsArray = $locations->toArray();
$this->assertInternalType('array', $locationsAsArray);
$this->assertSame(range(0, 9), array_keys($locationsAsArray));
$location = $locationsAsArray[0];
$this->assertSame(2007, $location->getCount());
$this->assertNull($location->getItemId());
$this->assertSame('{Berlin}', $location->getName());
$this->assertSame(8514, $location->getPathId());
$this->assertSame('berlin', $location->getPathName());
$this->assertSame('path', $location->getType());
$this->assertFalse($location->isHotel());
$this->assertFalse($location->isAttraction());
$this->assertTrue($location->isPath());
}
public function deleteNote($noteId)
{
if ($noteId == 0) {
return new returnData(0);
}
//if 0, it would delete ALL notes
$noteObj = Module::queryObject("SELECT * FROM notes WHERE note_id = '{$noteId}' LIMIT 1");
Module::query("DELETE FROM note_tags WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM note_likes WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM note_flags WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM note_shares WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM folder_contents WHERE game_id = {$noteObj->game_id} AND content_type = 'PlayerNote' AND content_id = '{$noteId}'");
Module::query("DELETE FROM note_content WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM note_tags WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM note_likes WHERE note_id = '{$noteId}'");
Module::query("DELETE FROM notes WHERE note_id = '{$noteId}'");
Locations::deleteLocationsForObject($noteObj->game_id, "PlayerNote", $noteId);
$result = Module::query("SELECT note_id FROM notes WHERE parent_note_id = '{$noteId}'");
while ($commentNote = mysql_fetch_object($result)) {
Notebook::deleteNote($commentNote->note_id);
}
return new returnData(0);
}
public function rssObservations()
{
global $objObservation, $objInstrument, $objLocation, $objPresentations, $objObserver, $baseURL, $objUtil;
$dom = new DomDocument('1.0', 'US-ASCII');
// add root fcga -> The header
$rssInfo = $dom->createElement('rss');
$rssDom = $dom->appendChild($rssInfo);
$attr = $dom->createAttribute("version");
$rssInfo->appendChild($attr);
$attrText = $dom->createTextNode("2.0");
$attr->appendChild($attrText);
$attr = $dom->createAttribute("xmlns:content");
$rssInfo->appendChild($attr);
$attrText = $dom->createTextNode("http://purl.org/rss/1.0/modules/content/");
$attr->appendChild($attrText);
$attr = $dom->createAttribute("xmlns:dc");
$rssInfo->appendChild($attr);
$attrText = $dom->createTextNode("http://purl.org/dc/elements/1.1/");
$attr->appendChild($attrText);
$attr = $dom->createAttribute("xmlns:atom");
$rssInfo->appendChild($attr);
$attrText = $dom->createTextNode("http://www.w3.org/2005/Atom");
$attr->appendChild($attrText);
// add root - <channel>
$channelDom = $rssDom->appendChild($dom->createElement('channel'));
// add root - <channel> - <title>
$titleDom = $channelDom->appendChild($dom->createElement('title'));
$titleDom->appendChild($dom->createTextNode("DeepskyLog"));
// add root - <channel> - <description>
$descDom = $channelDom->appendChild($dom->createElement('description'));
$descDom->appendChild($dom->createTextNode("DeepskyLog - visual deepsky and comets observations"));
// add root - <channel> - <atom>
$atomDom = $channelDom->appendChild($dom->createElement('atom:link'));
$attr = $dom->createAttribute("href");
$atomDom->appendChild($attr);
$attrText = $dom->createTextNode($baseURL . "observations.rss");
$attr->appendChild($attrText);
$attr = $dom->createAttribute("rel");
$atomDom->appendChild($attr);
$attrText = $dom->createTextNode("self");
$attr->appendChild($attrText);
$attr = $dom->createAttribute("type");
$atomDom->appendChild($attr);
$attrText = $dom->createTextNode("application/rss+xml");
$attr->appendChild($attrText);
// add root - <channel> - <link>
$linkDom = $channelDom->appendChild($dom->createElement('link'));
$linkDom->appendChild($dom->createTextNode("http://www.deepskylog.org/"));
$theDate = date('r');
// add root - <channel> - <link>
$lbdDom = $channelDom->appendChild($dom->createElement('lastBuildDate'));
$lbdDom->appendChild($dom->createTextNode($theDate));
// Get the new deepsky observations of the last month
$theDate = date('Ymd', strtotime('-1 month'));
$_GET['minyear'] = substr($theDate, 0, 4);
$_GET['minmonth'] = substr($theDate, 4, 2);
$_GET['minday'] = substr($theDate, 6, 2);
$query = array("catalog" => '%', "mindate" => $objUtil->checkGetDate('minyear', 'minmonth', 'minday'));
$result = $objObservation->getObservationFromQuery($query, 'A');
while (list($key, $value) = each($result)) {
// add root - <channel> - <item>
$itemDom = $channelDom->appendChild($dom->createElement('item'));
$titleDom = $itemDom->appendChild($dom->createElement('title'));
$titleDom->appendChild($dom->createTextNode($value['observername'] . " : " . $value['objectname'] . " with " . htmlspecialchars_decode($objInstrument->getInstrumentPropertyFromId($value['instrumentid'], 'name')) . " from " . $objLocation->getLocationPropertyFromId($objObservation->getDsObservationProperty($value['observationid'], 'locationid'), 'name')));
$linkDom = $itemDom->appendChild($dom->createElement('link'));
$linkDom->appendChild($dom->createCDATASection($baseURL . "index.php?indexAction=detail_observation&observation=" . $value['observationid'] . "&QobsKey=0&dalm=D"));
$descDom = $itemDom->appendChild($dom->createElement('description'));
$descDom->appendChild($dom->createCDATASection($objPresentations->br2nl(utf8_encode($value['observationdescription']))));
$authorDom = $itemDom->appendChild($dom->createElement('dc:creator'));
$authorDom->appendChild($dom->createCDATASection($value['observername']));
$guidDom = $itemDom->appendChild($dom->createElement('guid'));
$guidDom->appendChild($dom->createTextNode("deepsky" . $value['observationid']));
$attr = $dom->createAttribute("isPermaLink");
$guidDom->appendChild($attr);
$attrText = $dom->createTextNode("false");
$attr->appendChild($attrText);
$pubDateDom = $itemDom->appendChild($dom->createElement('pubDate'));
date_default_timezone_set('UTC');
$time = -999;
$obs = $objObservation->getAllInfoDsObservation($value['observationid']);
$time = $obs['time'];
if ($time >= "0") {
$hour = (int) ($time / 100);
$minute = $time - 100 * $hour;
} else {
$hour = 0;
$minute = 0;
}
$date = $value['observationdate'];
$year = substr($date, 0, 4);
$month = substr($date, 4, 2);
$day = substr($date, 6, 2);
$pubDateDom->appendChild($dom->createTextNode(date("r", mktime($hour, $minute, 0, $month, $day, $year))));
}
include_once "cometobjects.php";
include_once "observers.php";
include_once "instruments.php";
include_once "locations.php";
include_once "cometobservations.php";
include_once "icqmethod.php";
include_once "icqreferencekey.php";
global $instDir, $objCometObject;
$objects = new CometObjects();
$observer = new Observers();
$instrument = new Instruments();
$observation = new CometObservations();
$location = new Locations();
$util = $this;
$ICQMETHODS = new ICQMETHOD();
$ICQREFERENCEKEYS = new ICQREFERENCEKEY();
$cometsResult = $observation->getObservationFromQuery($query);
while (list($key, $value) = each($cometsResult)) {
$objectname = $objCometObject->getName($observation->getObjectId($value));
// add root - <channel> - <item>
$itemDom = $channelDom->appendChild($dom->createElement('item'));
$title = htmlspecialchars_decode($objectname);
// Location and instrument
if ($observation->getLocationId($value) != 0 && $observation->getLocationId($value) != 1) {
$title = $title . " from " . htmlspecialchars_decode($location->getLocationPropertyFromId($observation->getLocationId($value), 'name'));
}
if ($observation->getInstrumentId($value) != 0) {
$title = $title . " with " . htmlspecialchars_decode($instrument->getInstrumentPropertyFromId($observation->getInstrumentId($value), 'name'));
}
$titleDom = $itemDom->appendChild($dom->createElement('title'));
$titleDom->appendChild($dom->createTextNode($title));
$linkDom = $itemDom->appendChild($dom->createElement('link'));
$linkDom->appendChild($dom->createCDATASection($baseURL . "index.php?indexAction=comets_detail_observation&observation=" . $value));
// Description
$description = $observation->getDescription($value);
if (strcmp($description, "") != 0) {
$descDom = $itemDom->appendChild($dom->createElement('description'));
$descDom->appendChild($dom->createCDATASection($objPresentations->br2nl(utf8_encode($description))));
} else {
$descDom = $itemDom->appendChild($dom->createElement('description'));
$descDom->appendChild($dom->createCDATASection(""));
}
$observerid = $observation->getObserverId($value);
$observername = $observer->getObserverProperty($observerid, 'firstname') . " " . $observer->getObserverProperty($observerid, 'name');
$authorDom = $itemDom->appendChild($dom->createElement('dc:creator'));
$authorDom->appendChild($dom->createCDATASection($observername));
$guidDom = $itemDom->appendChild($dom->createElement('guid'));
$guidDom->appendChild($dom->createTextNode("comet" . $value));
$attr = $dom->createAttribute("isPermaLink");
$guidDom->appendChild($attr);
$attrText = $dom->createTextNode("false");
$attr->appendChild($attrText);
$pubDateDom = $itemDom->appendChild($dom->createElement('pubDate'));
date_default_timezone_set('UTC');
$date = sscanf($observation->getLocalDate($value), "%4d%2d%2d");
$time = $observation->getLocalTime($value);
$hour = (int) ($time / 100);
$minute = $time - $hour * 100;
$pubDateDom->appendChild($dom->createTextNode(date("r", mktime($hour, $minute, 0, $date[1], $date[2], $date[0]))));
}
// generate xml
$dom->formatOutput = true;
// set the formatOutput attribute of
// domDocument to true
// save XML as string or file
$test1 = $dom->saveXML();
// put string in test1
print $test1;
}
public static function deleteItem($gameId, $itemId)
{
Locations::deleteLocationsForObject($gameId, 'Item', $itemId);
Requirements::deleteRequirementsForRequirementObject($gameId, 'Item', $itemId);
PlayerStateChanges::deletePlayerStateChangesThatRefrenceObject($gameId, 'Item', $itemId);
Module::removeItemFromAllPlayerInventories($gameId, $itemId);
$query = "DELETE FROM items WHERE item_id = {$itemId} AND game_id = '{$gameId}'";
$rsResult = Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error");
}
if (mysql_affected_rows()) {
return new returnData(0, TRUE);
} else {
return new returnData(0, FALSE);
}
}
$new_id = Util::uuid();
try {
$new = new Av_Sensor($new_id);
$new->set_properties(array('version' => '', 'has_nagios' => 0, 'has_ntop' => 1, 'has_vuln_scanner' => 1, 'has_kismet' => 0));
$new->set_name($sname);
$new->set_ip($ip);
$new->set_priority($priority);
$new->set_port($port);
$new->set_tzone($tzone);
$new->set_descr($descr);
foreach ($entities as $ctx) {
$new->add_new_ctx($ctx, $ctx);
}
$new->save_in_db($conn);
if ($location != '') {
Locations::insert_related_sensor($conn, $location, $new_id);
}
} catch (Exception $e) {
$config_nt = array('content' => $e->getMessage(), 'options' => array('type' => 'nf_error', 'cancel_button' => false), 'style' => 'width: 80%; margin: 20px auto; text-align:center;');
$nt = new Notification('nt_1', $config_nt);
$nt->show();
$db->close();
exit;
}
$db->close();
unset($_SESSION['_sensor_list']);
}
?>
<script type='text/javascript'>
if (!top.is_lightbox_loaded(window.name))
public function getProvince()
{
$this->__load();
return parent::getProvince();
}
public function addAction()
{
if ($this->_request->isPost()) {
if ($this->_request->getPost()) {
$form_values = $this->_request->getPost();
$locations = new Locations();
if ($form_values['location_level_add'] == 3) {
$parentId = $form_values['combo1_add'];
}
if ($form_values['location_level_add'] == 4) {
$parentId = $form_values['combo1_add'];
}
if ($form_values['location_level_add'] == 5) {
$parentId = $form_values['combo2_add'];
}
if ($form_values['location_level_add'] == 6) {
$parentId = $form_values['combo3_add'];
}
$province_id = $this->_em->find('Locations', $form_values['combo1_add']);
$locations->setProvince($province_id);
$locations->setLocationName($form_values['location_name_add']);
$geo_level_id = $this->_em->find('GeoLevels', $form_values['location_level_add']);
$locations->setGeoLevel($geo_level_id);
$location_types = $this->_em->find('LocationTypes', $form_values['location_type_id']);
$locations->setLocationType($location_types);
$parent_id = $this->_em->find('Locations', $parentId);
$locations->setParent($parent_id);
if ($form_values['location_level_add'] == 5 || $form_values['location_level_add'] == 6) {
$district_id = $this->_em->find('Locations', $form_values['combo2_add']);
$locations->setDistrict($district_id);
}
$locations->setCcmLocationId($form_values['ccm_location_id']);
$created_by = $this->_em->find('Users', $this->_user_id);
$locations->setCreatedBy($created_by);
$locations->setCreatedDate(App_Tools_Time::now());
$locations->setModifiedBy($created_by);
$locations->setModifiedDate(App_Tools_Time::now());
$this->_em->persist($locations);
$this->_em->flush();
}
}
$this->_redirect("/iadmin/manage-locations");
}
/**
* list articles
*
* @param resource the SQL result
* @return array
*
* @see layouts/layout.php
**/
function layout($result)
{
global $context;
// we return an array of ($url => $attributes)
$items = array();
// empty list
if (!SQL::count($result)) {
return $items;
}
// process all items in the list
include_once $context['path_to_root'] . 'articles/article.php';
include_once $context['path_to_root'] . 'comments/comments.php';
include_once $context['path_to_root'] . 'locations/locations.php';
while ($item = SQL::fetch($result)) {
// get the related overlay, if any
$overlay = Overlay::load($item, 'article:' . $item['id']);
// get the anchor
$anchor = Anchors::get($item['anchor']);
// provide an absolute link
$url = Articles::get_permalink($item);
// build a title
if (is_object($overlay)) {
$title = Codes::beautify_title($overlay->get_text('title', $item));
} else {
$title = Codes::beautify_title($item['title']);
}
// time of last update
$time = SQL::strtotime($item['edit_date']);
// the section
$section = '';
if ($item['anchor'] && ($anchor = Anchors::get($item['anchor']))) {
$section = ucfirst(trim(strip_tags(Codes::beautify_title($anchor->get_title()))));
}
// the icon to use
$icon = '';
if ($item['thumbnail_url']) {
$icon = $item['thumbnail_url'];
} elseif ($item['anchor'] && ($anchor = Anchors::get($item['anchor'])) && is_callable($anchor, 'get_bullet_url')) {
$icon = $anchor->get_bullet_url();
}
if ($icon) {
$icon = $context['url_to_home'] . $context['url_to_root'] . $icon;
}
// the author(s) is an e-mail address, according to rss 2.0 spec
$author = '';
if (isset($item['create_address'])) {
$author .= $item['create_address'];
}
if (isset($item['create_name']) && trim($item['create_name'])) {
$author .= ' (' . $item['create_name'] . ')';
}
if (isset($item['edit_address']) && trim($item['edit_address']) && $item['create_address'] != $item['edit_address']) {
if ($author) {
$author .= ', ';
}
$author .= $item['edit_address'];
if (isset($item['edit_name']) && trim($item['edit_name'])) {
$author .= ' (' . $item['edit_name'] . ')';
}
}
// some introductory text for this article
$article = new Article();
$article->load_by_content($item);
$introduction = $article->get_teaser('teaser');
// warns on restricted access
if (isset($item['active']) && $item['active'] != 'Y') {
$introduction = '[' . i18n::c('Restricted to members') . '] ' . $introduction;
}
// fix references
$introduction = preg_replace('/"\\//', '"' . $context['url_to_home'] . '/', $introduction);
// the article content
$description = '';
// other rss fields
$extensions = array();
// the geolocation for this page, if any
if ($location = Locations::locate_anchor('article:' . $item['id'])) {
$extensions[] = '<georss:point>' . str_replace(',', ' ', $location) . '</georss:point>';
}
// url for comments
if (is_object($anchor)) {
$extensions[] = '<comments>' . encode_link($context['url_to_home'] . $context['url_to_root'] . $anchor->get_url('comments')) . '</comments>';
}
// count comments
$comment_count = Comments::count_for_anchor('article:' . $item['id']);
$extensions[] = '<slash:comments>' . $comment_count . "</slash:comments>";
// the comment post url
$extensions[] = '<wfw:comment>' . encode_link($context['url_to_home'] . $context['url_to_root'] . Comments::get_url('article:' . $item['id'], 'service.comment')) . "</wfw:comment>";
// the comment Rss url
$extensions[] = '<wfw:commentRss>' . encode_link($context['url_to_home'] . $context['url_to_root'] . Comments::get_url('article:' . $item['id'], 'feed')) . "</wfw:commentRss>";
// the trackback url
$extensions[] = '<trackback:ping>' . encode_link($context['url_to_home'] . $context['url_to_root'] . 'links/trackback.php?anchor=' . urlencode('article:' . $item['id'])) . "</trackback:ping>";
// no trackback:about;
// list all components for this item
$items[$url] = array($time, $title, $author, $section, $icon, $introduction, $description, $extensions);
}
// end of processing
SQL::free($result);
return $items;
}
// not found
if (!isset($item['id'])) {
include '../error.php';
// permission denied
} elseif (!$permitted) {
Safe::header('Status: 401 Unauthorized', TRUE, 401);
Logger::error(i18n::s('You are not allowed to perform this operation.'));
// deletion is confirmed
} elseif (isset($_REQUEST['confirm']) && $_REQUEST['confirm'] == 'yes') {
// touch the related anchor before actual deletion, since the location has to be accessible at that time
if (is_object($anchor)) {
$anchor->touch('location:delete', $item['id']);
}
// if no error, back to the anchor or to the index page
if (Locations::delete($item['id'])) {
Locations::clear($item);
if (is_object($anchor)) {
Safe::redirect($context['url_to_home'] . $context['url_to_root'] . $anchor->get_url());
} else {
Safe::redirect($context['url_to_home'] . $context['url_to_root'] . 'users/');
}
}
// deletion has to be confirmed
} elseif (isset($_SERVER['REQUEST_METHOD']) && $_SERVER['REQUEST_METHOD'] == 'POST') {
Safe::header('Status: 401 Unauthorized', TRUE, 401);
Logger::error(i18n::s('The action has not been confirmed.'));
// ask for confirmation
} else {
// commands
$menu = array();
$menu[] = Skin::build_submit_button(i18n::s('Yes, I want to delete this location'), NULL, NULL, 'confirmed');
if (ossim_error()) {
echo "<rows>\n<page>1</page>\n<total>0</total>\n</rows>\n";
exit;
}
if (!empty($order)) {
$order = "`" . $order . "`";
$order .= POST('sortorder') == 'asc' ? '' : ' DESC';
} else {
$order = 'name';
}
$start = ($page - 1) * $rp;
$limit = "LIMIT {$start}, {$rp}";
$db = new ossim_db();
$conn = $db->connect();
$xml = '';
$locations = Locations::get_list($conn, "ORDER BY {$order} {$limit}");
if ($locations[0]) {
$total = $locations[0]->get_foundrows();
if ($total == 0) {
$total = count($locations);
}
} else {
$total = 0;
}
$xml .= "<rows>\n";
$xml .= "<page>{$page}</page>\n";
$xml .= "<total>{$total}</total>\n";
foreach ($locations as $location) {
$id = $location->get_id();
$name = $location->get_name();
$ctx = $location->get_ctx();
Util::response_bad_request(Token::create_error_message());
}
}
//Perform action
if (is_array($validation_errors) && !empty($validation_errors)) {
$error_msg = '<div style="padding-left:5px">' . _('The following errors occurred') . ":</div>\n <div style='padding: 5px 5px 5px 15px;'>" . implode('<br/>', $validation_errors) . '</div>';
Util::response_bad_request($error_msg);
}
$locations_id = POST('locations_id');
$name = POST('l_name');
$ctx = POST('ctx');
$desc = POST('desc');
$location = POST('search_location');
$longitude = POST('longitude');
$latitude = POST('latitude');
$cou = POST('country');
$sensor_list = POST('sensor_list');
try {
$db = new ossim_db();
$conn = $db->connect();
if (empty($locations_id)) {
$locations_id = Locations::insert($conn, $ctx, $name, $desc, $location, $latitude, $longitude, $cou);
} else {
Locations::update($conn, $locations_id, $name, $desc, $location, $latitude, $longitude, $cou);
}
Locations::save_location_sensors($conn, $locations_id, $sensor_list);
Util::memcacheFlush();
$db->close();
} catch (Exception $e) {
Util::response_bad_request($e->getMessage());
}
/**
** AddEntrance
** Sets the entrance for this location to be shown in the parent location
**
** Parameters:
** - modelid: Entrance pickup id (won't take effect if this is not a Location0 child)
** - position: Entrance coordinates
**/
public function AddEntrance($modelid, $name, Position $position, Position $start = null)
{
$id = 0;
if ($this->parent == Locations::Find(0)) {
if ($modelid != -1) {
$id = CreatePickup($modelid, 23, $position->x, $position->y, $position->z);
} else {
$id = -1;
}
} else {
$id = -1;
if ($this->parent != null) {
$this->parent->area->AddCheckpoint($position, 1.15);
}
}
if ($start == null) {
$start = $this->start;
}
$entrance = new LocationEntrance($id, $name, $position, $start, $this);
$this->entrances[] = $entrance;
$this->area->AddCheckpoint($start, 0.7);
return $entrance;
}
public function __construct($id)
{
$this->id = $id;
GetPlayerName($id, &$this->name);
$this->position = new Position();
$this->last_updated_position = new Position();
$this->spawn_position = new Position(0, 0, 0, 0);
$this->spawn_weapons = array();
$this->spawn_skin = 0;
$this->spawn_team = 0;
$this->UpdateSpawnInfo();
/* Initially, set the player in the location0 OOB sector */
$this->sector = Locations::Find(0)->Locate(new Position(99999999, 99999999), 0, 0);
$this->sector->AddPlayer($this);
$this->PreloadAnimLibs();
$this->SetColor(COLOR_CIVILIAN);
/* TODO: Set alpha to 0x00 when you build a release */
$this->SetAlpha(0xff);
$this->Update();
/* Hide this player nametag for all, and all nametags for him */
$this->seeingNametags = array_fill(0, MAX_PLAYERS, false);
foreach (Players::Get() as $p) {
$p->CanIdentify($this, false);
$this->CanIdentify($p, false);
}
GetPlayerIP($this->id, &$this->ip);
$this->guns = array_fill(0, 13, 0);
}
$locationset = $db_object->get_rsltset($query);
preg_match("/<{location_loopstart}>(.*?)<{location_loopend}>/s", $xTemplate, $match);
$replace = $match[1];
for ($i = 0; $i < count($locationset); $i++) {
$sub_denotes = $locationset[$i]["denotes"] + 1;
$name = $locationset[$i]["loc_name"];
$id = $locationset[$i]["loc_id"];
$re .= preg_replace("/<{(.*?)}>/e", "\$\$1", $replace);
}
$xTemplate = preg_replace("/<{location_loopstart}>(.*?)<{location_loopend}>/s", $re, $xTemplate);
echo $xTemplate;
}
function addnew_location($common, $db_object, $form_array, $denotes)
{
while (list($kk, $vv) = each($form_array)) {
${$kk} = $vv;
}
$location = $common->prefix_table("location");
$query = "insert into {$location} set loc_name='{$fLocation_name}',denotes='{$denotes}'";
$sub_id = $db_object->insert_data_id($query);
$location_relate = $common->prefix_table("location_relate");
$query = "insert into {$location_relate} set loc_id='{$id}',sub_id='{$sub_id}'";
$db_object->insert($query);
}
}
$locobj = new Locations();
if ($fAdd) {
$locobj->addnew_location($common, $db_object, $_POST, $denotes);
}
$locobj->location_display($common, $db_object, $denotes, $_POST, $id, $gbl_loc);
include "footer.php";
</tr>
</table>
</td>
</tr>
<tr>
<th>
<label for='location'><?php
echo _('Location');
?>
</label>
</th>
<td class="left">
<select name="location" id="location" class='vfield'>
<?php
$locations = Locations::get_list($conn);
foreach ($locations as $lc) {
echo "<option value='" . $lc->get_id() . "'>" . $lc->get_name() . "</option>";
}
?>
</select>
</td>
</tr>
<?php
} else {
if (Session::show_entities()) {
$e_url = Menu::get_menu_url('../acl/entities.php', 'configuration', 'administration', 'users', 'structure');
?>
<tr>
<th>
<label for='entities'><?php
session_start();
Errors::start();
if (!function_exists('http_response_code')) {
function http_response_code($code = NULL)
{
header(':', true, $code);
}
}
if (!Session::is_user() && (substr(LINK_FILE, 0, 4) == "ajax" && LINK_FILE != "ajax/login.php")) {
http_response_code(403);
exit(json_encode(array("error" => "Your session has timed out, or you have logged out in another tab. Please log in again.")));
}
if (substr(LINK_FILE, 0, 6) == "studio") {
MainTemplate::set_barebones(true);
if (isset($_REQUEST["key"])) {
if (is_null(Locations::get_by_key($_REQUEST["key"]))) {
exit("Sorry, you provided an invalid security key.");
}
} else {
Output::require_user();
}
}
if (LINK_FILE != "index.php" && LINK_FILE != "ajax/login.php" && substr(LINK_FILE, 0, 6) != "studio" && substr(LINK_FILE, 0, 5) != "audio") {
Output::require_user();
}
if (Session::is_developer()) {
ini_set("display_errors", "1");
ini_set("display_startup_errors", "1");
ini_set("html_errors", "1");
ini_set("docref_root", "http://www.php.net/");
ini_set("error_prepend_string", "<div class=\"alert alert-error\">");
<tr>
<td class='noborder' width='20%' valign='top'>
<div id="first" class="category-section">
<div id='location_list'>
<table class='noborder locations' width='100%' align="center">
<tbody>
<?php
$locations = is_array($locations) ? $locations : array();
foreach ($locations as $l) {
$id = $l->get_id();
$name = $l->get_name();
$icon = file_exists("../pixmaps/flags/" . $l->get_country() . ".png") ? '<img src="../pixmaps/flags/' . $l->get_country() . '.png" border="0" class="flag">' : '';
$total_n = Locations::count_related_networks($conn, $id);
$class = $total_n > 0 ? colorize_location($conn, $id) : 'l_error';
$sensors = Locations::get_related_sensors($conn, $id);
if (count($sensors) == 0) {
$tooltip = "0 " . _('Sensors') . "<br> {$total_n} " . _('Networks');
} else {
$tooltip = count($sensors) . " " . (count($sensors) == 1 ? _('Sensor') : _('Sensors')) . ":<br> ";
$tooltip .= "<ul>";
foreach ($sensors as $s) {
$tooltip .= "<li>" . $s[1] . " (" . $s[2] . ")</li>";
}
$tooltip .= "</ul>";
$tooltip .= "{$total_n} " . ($total_n == 1 ? _('Network') : _('Networks'));
}
?>
<tr class='<?php
echo $class;
}
// not found
if (!is_object($anchor) && $id != 'all' && $id != 'users') {
Logger::error(i18n::s('Reference a valid anchor, or all users.'));
} elseif (!isset($context['google_api_key']) || !$context['google_api_key']) {
Logger::error(i18n::s('Use the configuration panel for web services to enter your Google API key.'));
} else {
// insert anchor prefix
if (is_object($anchor)) {
$context['text'] .= $anchor->get_prefix();
}
// get markers
$items = array();
switch ($id) {
case 'all':
default:
$items = Locations::list_by_date(0, 100, 'raw');
break;
case 'users':
$items = Locations::list_users_by_date(0, 100, 'raw');
break;
}
// integrate with google maps
$context['text'] .= Locations::map_on_google($items, 2);
// insert anchor suffix
if (is_object($anchor)) {
$context['text'] .= $anchor->get_suffix();
}
}
// render the skin
render_skin();
}
// page details
if (is_array($details)) {
$context['text'] .= '<p class="details">' . ucfirst(implode(', ', $details)) . "</p>\n";
}
// insert anchor suffix
if (is_object($anchor)) {
$context['text'] .= $anchor->get_suffix();
}
// back to the anchor page
if (is_object($anchor) && $anchor->is_viewable()) {
$menu = array(Skin::build_link($anchor->get_url(), i18n::s('Back to main page'), 'button'));
$context['text'] .= Skin::build_block(Skin::finalize_list($menu, 'menu_bar'), 'bottom');
}
//
// populate the extra panel
//
// commands for associates and editors
if (Surfer::is_associate() || is_object($anchor) && $anchor->is_assigned()) {
$context['page_tools'][] = Skin::build_link(Locations::get_url($id, 'edit'), i18n::s('Edit'));
$context['page_tools'][] = Skin::build_link(Locations::get_url($id, 'delete'), i18n::s('Delete'));
// commands for the author
} elseif (Surfer::is($item['edit_id'])) {
$context['page_tools'][] = Skin::build_link(Locations::get_url($item['id'], 'edit'), i18n::s('Edit'));
}
// referrals, if any, in a sidebar
//
$context['components']['referrals'] =& Skin::build_referrals(Locations::get_url($item['id']));
}
// render the skin
render_skin();
public function getParent()
{
$this->__load();
return parent::getParent();
}