public function employeeName($employeeid) { $employeesModel = new Employees(); $employee = $employeesModel->getById($employeeid); if (!$employee) { $employeeName = "Not Set"; } else { $employeeName = $employee->lastname . ", " . $employee->firstname; } return $employeeName; }
public function destroy($id) { $employees = Employees::find($id); $employees->delete(); Session::flash('success', 'Successfully deleted!'); return Redirect::to('/'); }
public function actionIndex() { $criteria = new CDbCriteria(); $criteria->condition = '`file`<>:null'; $criteria->params = array(':null' => ''); $roles = Rights::getAssignedRoles(Yii::app()->user->id); // check for single role $user_roles = array(); foreach ($roles as $role) { $user_roles[] = '"' . $role->name . '"'; } $teacher = Employees::model()->findByAttributes(array('uid' => Yii::app()->user->id)); $batches = Batches::model()->findAllByAttributes(array('employee_id' => $teacher->id)); foreach ($batches as $classteacher) { $batch[] = $classteacher->id; } $timetable = TimetableEntries::model()->findAllByAttributes(array('employee_id' => $teacher->id)); foreach ($timetable as $period) { $batch[] = $period->batch_id; } $unique_batch = array_unique($batch); if (count($unique_batch) > 0) { $criteria->condition .= ' AND (`placeholder`=:null OR `created_by`=:user_id OR (`placeholder` IN (' . implode(',', $user_roles) . ')) AND (`batch` IS NULL OR `batch` IN (' . implode(',', $unique_batch) . '))) '; } else { $criteria->condition .= ' AND (`placeholder`=:null OR `created_by`=:user_id) OR (`placeholder` IN (' . implode(',', $user_roles) . '))'; } $criteria->params[':user_id'] = Yii::app()->user->id; $criteria->order = '`created_at` DESC'; $files = FileUploads::model()->findAll($criteria); if (isset($_POST['Downfiles'])) { $selected_files = $_POST['Downfiles']; $slfiles = array(); foreach ($selected_files as $s_file) { $model = FileUploads::model()->findByPk($s_file); if ($model != NULL) { $slfiles[] = 'uploads/shared/' . $model->id . '/' . $model->file; } } $zip = Yii::app()->zip; $fName = $this->generateRandomString(rand(10, 20)) . '.zip'; $zipFile = 'compressed/' . $fName; if ($zip->makeZip($slfiles, $zipFile)) { $fcon = file_get_contents($zipFile); header('Content-type:text/plain'); header('Content-disposition:attachment; filename=' . $fName); header('Pragma:no-cache'); echo $fcon; unlink($zipFile); } else { Yii::app()->user->setFlash('success', 'Can\'t download'); } } $this->render('/fileUploads/index', array('files' => $files)); }
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++; } }
public function Employeenotassigned($id, $sub) { $results = array(); $emp = Employees::model()->findAllByAttributes(array('employee_department_id' => $id)); if ($emp != NULL) { $i = 0; foreach ($emp as $emp1) { if (EmployeesSubjects::model()->findByAttributes(array('employee_id' => $emp1->id, 'subject_id' => $sub)) == NULL) { $results[$i] = $emp1; $i++; } } } return $results; }
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 function action_entry() { // Set employees node $employees_node = $this->xml_content->appendChild($this->dom->createElement('employees')); $employees = array('0option' => array('@value' => '0', 'None')); $counter = 1; foreach (Employees::get() as $employee) { $employees[$counter . 'option'] = array('@value' => $employee['id'], $employee['lastname'] . ', ' . $employee['firstname']); $counter++; } xml::to_XML($employees, $employees_node); // This is for the select box if (count($_POST)) { $post = new Validation($_POST); $post->filter('trim'); $post->filter('floatval', 'sum'); $post->filter('floatval', 'vat'); $post->rule('strtotime', 'accounting_date'); $post->rule('strtotime', 'transfer_date'); $post->rule('Valid::not_empty', 'description'); if ($post->Validate()) { $new_transaction_data = array('accounting_date' => $post->get('accounting_date'), 'transfer_date' => $post->get('transfer_date'), 'description' => $post->get('description'), 'journal_id' => $post->get('journal_id'), 'vat' => $post->get('vat'), 'sum' => $post->get('sum'), 'employee_id' => $post->get('employee_id')); if (!isset($_GET['id'])) { $transaction = new Transaction(NULL, $new_transaction_data); $this->add_message('Transaction ' . $transaction->get_id() . ' added'); } else { $transaction = new Transaction($_GET['id']); $transaction->set($new_transaction_data); $this->add_message('Transaction ' . $transaction->get_id() . ' updated'); $this->set_formdata($transaction->get()); } } else { $this->add_form_errors($post->errors()); $this->set_formdata($post->as_array()); } } elseif (isset($_GET['id'])) { $transaction = new Transaction($_GET['id']); $this->set_formdata($transaction->get()); } else { $this->set_formdata(array('accounting_date' => date('Y-m-d', time()), 'transfer_date' => date('Y-m-d', time()))); } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionSendtogroup() { $model = new Sms(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Sms'])) { $model->attributes = $_POST['Sms']; if ($model->validate()) { if ($model->uid == 'parent') { $userlist = Guardians::model()->findAll(); } if ($model->uid == 'teacher') { $userlist = Employees::model()->findAll(); } if ($userlist != NULL) { foreach ($userlist as $user) { if ($user->mobile_phone) { // $status = SmsSettings::model()->sendSms($user->mobile_phone,0,$model->message) ; $mobile_phone = $user->mobile_phone; } else { $status = 0; $mobile_phone = 0; } $Sms = new Sms(); $Sms->uid = $user->uid; $Sms->phone_number = $mobile_phone; $Sms->message = $model->message; $Sms->status = $status; $Sms->save(); } } $this->redirect(array('index')); } } $this->render('create', array('model' => $model)); }
</tr> </table> </td> </tr> </table> </div> <!-- End Header --> <?php if (isset($_REQUEST['id'])) { ?> <br /><br /> <span align="center"><h4>EMPLOYEES MONTHLY ATTENDANCE REPORT</h4></span> <?php $employees = Employees::model()->findAll("employee_department_id=:x and is_deleted=:y", array(':x' => $_REQUEST['id'], ':y' => 0)); $department_name = EmployeeDepartments::model()->findByAttributes(array('id' => $_REQUEST['id'])); ?> <!-- Department details --> <div style="border:#CCC 1px; width:700px; padding:10px 10px; background:#E1EAEF;"> <table style="font-size:14px;"> <tr> <td style="width:100px;"><b><?php echo Yii::t('report', 'Department'); ?> </b></td> <td style="width:10px;">:</td> <td style="width:250px;"><?php echo ucfirst($department_name->name); ?> </td>
</div> </div>--> <div class="clear"></div> <div class="emp_right_contner"> <div class="emp_tabwrapper"> <div class="emp_tab_nav"> <?php $this->renderPartial('/default/emp_tab_nav'); ?> </div> <div class="clear"></div> <div class="emp_cntntbx" > <?php $employeelist = Employees::model()->findAll(array('condition' => 'uid=:x and is_deleted=:y', 'params' => array(':x' => 0, ':y' => 0), 'limit' => '1000', 'order' => 'id ASC')); ?> <div align="center" style="font-size:16px; font-style:bold; padding:10px 0px;"> <?php if (count($employeelist) != 0) { echo Yii::t('importcsv', 'You have not created user accounts for ') . count($employeelist) . ' employees ' . CHtml::submitButton(Yii::t('importcsv', 'Create Now'), array('confirm' => 'Are you sure?', 'name' => 'employeeuser', 'value' => 'Create Now', 'class' => 'formbut')); } else { echo Yii::t('importcsv', 'No data available'); } ?> </div> </div> </div> </div>
public function employeeAcct($employeeid) { $employeesModel = new Employees(); $employee = $employeesModel->getById($employeeid); return $employee->account_number; }
public function actionEmanage() { if (Yii::app()->request->isAjaxRequest) { $name = ''; $bat = ''; $ad = ''; $model = new Employees(); $criteria = new CDbCriteria(); $criteria->compare('is_deleted', 0); $criteria->condition = 'is_deleted=:is_del'; $criteria->params = array(':is_del' => 0); if (isset($_REQUEST['val'])) { $criteria->condition = $criteria->condition . ' and ' . 'first_name LIKE :match'; $criteria->params[':match'] = $_REQUEST['val'] . '%'; } if (isset($_REQUEST['ename']) and $_REQUEST['ename'] != NULL) { $criteria->condition = $criteria->condition . ' and ' . 'first_name LIKE :name'; $criteria->params[':name'] = $_REQUEST['ename'] . '%'; $name = $_REQUEST['ename']; } if (isset($_REQUEST['employeenumber']) and $_REQUEST['employeenumber'] != NULL) { $criteria->condition = $criteria->condition . ' and ' . 'employee_number LIKE :employeenumber'; $criteria->params[':employeenumber'] = $_REQUEST['employeenumber'] . '%'; $ad = $_REQUEST['employeenumber']; } if (isset($_REQUEST['Employees']['employee_department_id']) and $_REQUEST['Employees']['employee_department_id'] != NULL) { $model->employee_department_id = $_REQUEST['Employees']['employee_department_id']; $criteria->condition = $criteria->condition . ' and ' . 'employee_department_id = :employee_department_id'; $criteria->params[':employee_department_id'] = $_REQUEST['Employees']['employee_department_id']; $bat = $_REQUEST['Employees']['employee_department_id']; } if (isset($_REQUEST['Employees']['employee_category_id']) and $_REQUEST['Employees']['employee_category_id'] != NULL) { $model->employee_category_id = $_REQUEST['Employees']['employee_category_id']; $criteria->condition = $criteria->condition . ' and ' . 'employee_category_id = :employee_category_id'; $criteria->params[':employee_category_id'] = $_REQUEST['Employees']['employee_category_id']; } if (isset($_REQUEST['Employees']['employee_position_id']) and $_REQUEST['Employees']['employee_position_id'] != NULL) { $model->employee_position_id = $_REQUEST['Employees']['employee_position_id']; $criteria->condition = $criteria->condition . ' and ' . 'employee_position_id = :employee_position_id'; $criteria->params[':employee_position_id'] = $_REQUEST['Employees']['employee_position_id']; } if (isset($_REQUEST['Employees']['employee_grade_id']) and $_REQUEST['Employees']['employee_grade_id'] != NULL) { $model->employee_grade_id = $_REQUEST['Employees']['employee_grade_id']; $criteria->condition = $criteria->condition . ' and ' . 'employee_grade_id = :employee_grade_id'; $criteria->params[':employee_grade_id'] = $_REQUEST['Employees']['employee_grade_id']; } if (isset($_REQUEST['Employees']['gender']) and $_REQUEST['Employees']['gender'] != NULL) { $model->gender = $_REQUEST['Employees']['gender']; $criteria->condition = $criteria->condition . ' and ' . 'gender = :gender'; $criteria->params[':gender'] = $_REQUEST['Employees']['gender']; } if (isset($_REQUEST['Employees']['marital_status']) and $_REQUEST['Employees']['marital_status'] != NULL) { $model->marital_status = $_REQUEST['Employees']['marital_status']; $criteria->condition = $criteria->condition . ' and ' . 'marital_status = :marital_status'; $criteria->params[':marital_status'] = $_REQUEST['Employees']['marital_status']; } if (isset($_REQUEST['Employees']['blood_group']) and $_REQUEST['Employees']['blood_group'] != NULL) { $model->blood_group = $_REQUEST['Employees']['blood_group']; $criteria->condition = $criteria->condition . ' and ' . 'blood_group = :blood_group'; $criteria->params[':blood_group'] = $_REQUEST['Employees']['blood_group']; } if (isset($_REQUEST['Employees']['nationality_id']) and $_REQUEST['Employees']['nationality_id'] != NULL) { $model->nationality_id = $_REQUEST['Employees']['nationality_id']; $criteria->condition = $criteria->condition . ' and ' . 'nationality_id = :nationality_id'; $criteria->params[':nationality_id'] = $_REQUEST['Employees']['nationality_id']; } if (isset($_REQUEST['Employees']['dobrange']) and $_REQUEST['Employees']['dobrange'] != NULL) { $model->dobrange = $_REQUEST['Employees']['dobrange']; if (isset($_REQUEST['Employees']['date_of_birth']) and $_REQUEST['Employees']['date_of_birth'] != NULL) { if ($_REQUEST['Employees']['dobrange'] == '2') { $model->date_of_birth = $_REQUEST['Employees']['date_of_birth']; $criteria->condition = $criteria->condition . ' and ' . 'date_of_birth = :date_of_birth'; $criteria->params[':date_of_birth'] = date('Y-m-d', strtotime($_REQUEST['Employees']['date_of_birth'])); } if ($_REQUEST['Employees']['dobrange'] == '1') { $model->date_of_birth = $_REQUEST['Employees']['date_of_birth']; $criteria->condition = $criteria->condition . ' and ' . 'date_of_birth < :date_of_birth'; $criteria->params[':date_of_birth'] = date('Y-m-d', strtotime($_REQUEST['Employees']['date_of_birth'])); } if ($_REQUEST['Employees']['dobrange'] == '3') { $model->date_of_birth = $_REQUEST['Employees']['date_of_birth']; $criteria->condition = $criteria->condition . ' and ' . 'date_of_birth > :date_of_birth'; $criteria->params[':date_of_birth'] = date('Y-m-d', strtotime($_REQUEST['Employees']['date_of_birth'])); } } } elseif (isset($_REQUEST['Employees']['dobrange']) and $_REQUEST['Employees']['dobrange'] == NULL) { if (isset($_REQUEST['Employees']['date_of_birth']) and $_REQUEST['Employees']['date_of_birth'] != NULL) { $model->date_of_birth = $_REQUEST['Employees']['date_of_birth']; $criteria->condition = $criteria->condition . ' and ' . 'date_of_birth = :date_of_birth'; $criteria->params[':date_of_birth'] = date('Y-m-d', strtotime($_REQUEST['Employees']['date_of_birth'])); } } if (isset($_REQUEST['Employees']['joinrange']) and $_REQUEST['Employees']['joinrange'] != NULL) { $model->joinrange = $_REQUEST['Employees']['joinrange']; if (isset($_REQUEST['Employees']['joining_date']) and $_REQUEST['Employees']['joining_date'] != NULL) { if ($_REQUEST['Employees']['joinrange'] == '2') { $model->joining_date = $_REQUEST['Employees']['joining_date']; $criteria->condition = $criteria->condition . ' and ' . 'joining_date = :joining_date'; $criteria->params[':joining_date'] = date('Y-m-d', strtotime($_REQUEST['Employees']['joining_date'])); } if ($_REQUEST['Employees']['joinrange'] == '1') { $model->joining_date = $_REQUEST['Employees']['joining_date']; $criteria->condition = $criteria->condition . ' and ' . 'joining_date < :joining_date'; $criteria->params[':joining_date'] = date('Y-m-d', strtotime($_REQUEST['Employees']['joining_date'])); } if ($_REQUEST['Employees']['joinrange'] == '3') { $model->joining_date = $_REQUEST['Employees']['joining_date']; $criteria->condition = $criteria->condition . ' and ' . 'joining_date > :joining_date'; $criteria->params[':joining_date'] = date('Y-m-d', strtotime($_REQUEST['Employees']['joining_date'])); } } } elseif (isset($_REQUEST['Employees']['joinrange']) and $_REQUEST['Employees']['joinrange'] == NULL) { if (isset($_REQUEST['Employees']['joining_date']) and $_REQUEST['Employees']['joining_date'] != NULL) { $model->joining_date = $_REQUEST['Employees']['joining_date']; $criteria->condition = $criteria->condition . ' and ' . 'joining_date = :joining_date'; $criteria->params[':joining_date'] = date('Y-m-d', strtotime($_REQUEST['Employees']['joining_date'])); } } if (isset($_REQUEST['Employees']['status']) and $_REQUEST['Employees']['status'] != NULL) { $model->status = $_REQUEST['Employees']['status']; $criteria->condition = $criteria->condition . ' and ' . 'is_active = :status'; $criteria->params[':status'] = $_REQUEST['Employees']['status']; } $criteria->order = 'first_name ASC'; $total = Employees::model()->count($criteria); //$pages = new CPagination($total); //$pages->setPageSize(Yii::app()->params['listPerPage']); //$pages->applyLimit($criteria); // the trick is here! $posts = Employees::model()->findAll($criteria); $this->renderPartial('user_panel', array('model' => $model, 'list' => $posts, 'item_count' => $total, 'name' => $name, 'ad' => $ad, 'bat' => $bat)); } }
public function editrecordsAction() { $recordsModel = new Records(); $searchQuery = $this->getRequest()->getParam('search', false); $sort = $this->getRequest()->getParam('sort'); $sorttype = $this->getRequest()->getParam('sorttype'); $this->view->sort = $sort; $this->view->sorttype = $sorttype; if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); if (!isset($data['method'])) { $id = $data['id']; unset($data['id']); if ($data['substitute'] == 129) { $data['acct'] = '5-000-0-0000-0000-00000-0000-0'; } $recordsModel->updateRecord($id, $data); } else { if ($data['method'] == 'remove') { $recordsModel->deleteMultiple($data['ids']); } if ($data['method'] == 'skipToPage') { $this->_redirect($this->view->url(array('page' => $data['gotopage']))); } if ($data['method'] == 'search') { unset($data['method']); $search = array(); if (trim($data['startdate']) != '') { $startdate = date('Y-m-d', strtotime($data['startdate'])); $search['startdate'] = $startdate; } if (trim($data['enddate']) != '') { $enddate = date('Y-m-d', strtotime($data['enddate'])); $search['enddate'] = $enddate; } if (trim($data['reason']) != '') { $search['reason'] = $reason; } unset($data['startdate']); unset($data['enddate']); foreach ($data as $key => $value) { if (trim($value) != '') { $search[$key] = $value; } } if (!empty($search)) { $searchString = urlencode(base64_encode(serialize($search))); $this->_redirect($this->view->url(array('search' => $searchString))); } } } } $this->view->searchQuery = $searchQuery; $searchArray = unserialize(base64_decode(urldecode($searchQuery))); $this->view->search = (object) $searchArray; if ($this->_me->admin == 1) { $records = $recordsModel->getAll($sort, $sorttype, $searchArray); } else { $records = $recordsModel->getAllByLocation($this->_me->location, true, $searchArray); } $page = $this->_getParam('page', 1); $this->view->page = $page; $paginator = Zend_Paginator::factory($records); $paginator->setItemCountPerPage(20); $paginator->setCurrentPageNumber($page); $this->view->records = $paginator; $substitutesModel = new Substitutes(); $this->view->substitutes = $substitutesModel->getAll(); $locationsModel = new Locations(); $this->view->locations = $locationsModel->getAll(); $employeesModel = new Employees(); if ($this->_me->admin == 1) { $this->view->employees = $employeesModel->getAll(); } else { $this->view->employees = $employeesModel->getAllByLocation($this->_me->location); } }
public function actionDeleteLeave() { $flag = true; $delete = EmployeeAttendances::model()->findByAttributes(array('id' => $_REQUEST['id'])); $model = EmployeeAttendances::model()->DeleteAllByAttributes(array('id' => $_REQUEST['id'])); $employee = Employees::model()->findByAttributes(array('id' => $delete->employee_id)); $settings = UserSettings::model()->findByAttributes(array('user_id' => 1)); if ($settings != NULL) { $date = date($settings->displaydate, strtotime($delete->attendance_date)); } //Adding activity to feed via saveFeed($initiator_id,$activity_type,$goal_id,$goal_name,$field_name,$initial_field_value,$new_field_value) ActivityFeed::model()->saveFeed(Yii::app()->user->Id, '28', $delete->employee_id, ucfirst($employee->first_name) . ' ' . ucfirst($employee->middle_name) . ' ' . ucfirst($employee->last_name), $date, NULL, NULL); if ($flag) { Yii::app()->clientScript->scriptMap['jquery.js'] = false; $this->renderPartial('update', array('model' => $model, 'day' => $_GET['day'], 'month' => $_GET['month'], 'year' => $_GET['year'], 'emp_id' => $_GET['emp_id']), false, true); } }
<div class="panel" id="user_panel_handler"> <?php $model = new Employees(); $criteria = new CDbCriteria(); $criteria->order = 'first_name ASC'; $_REQUEST['val'] = 'A'; $criteria->condition = 'first_name LIKE :match AND is_deleted=:is_del'; $criteria->params = array(':match' => $_REQUEST['val'] . '%', ':is_del' => 0); $total = Employees::model()->count($criteria); //echo $criteria->condition; //print_r($criteria->params); //$pages = new CPagination($total); //$pages->setPageSize(Yii::app()->params['listPerPage']); //$pages->applyLimit($criteria); // the trick is here! $posts = Employees::model()->findAll($criteria); $this->renderPartial('user_panel', array('model' => $model, 'list' => $posts, 'item_count' => $total, 'name' => '', 'ad' => '', 'bat' => '')); ?> </div> <?php } ?> <?php if (!isset($_REQUEST['widget']) or isset($_REQUEST['widget']) and $_REQUEST['widget'] != NULL and $_REQUEST['widget'] != 1) { ?> <div class="panel"> <?php $this->renderPartial('batch_panel', array()); ?>
<div class="edit_bttns" style="width:550px; top:40px; left:30px;"> <ul> <!-- For attendence --> <li><span> <?php if (Yii::app()->controller->action->id == 'attendance' or Yii::app()->controller->action->id == 'studentattendance') { echo CHtml::link('<span>' . 'View My Attendance' . '</span>', array('/teachersportal/default/employeeattendance')); } ?> </span></li> <li><span> <?php $employee = Employees::model()->findByAttributes(array('uid' => Yii::app()->user->id)); $is_classteacher = Batches::model()->findAllByAttributes(array('employee_id' => $employee->id)); if ($is_classteacher != NULL) { if (Yii::app()->controller->action->id == 'attendance' or Yii::app()->controller->action->id == 'employeeattendance') { echo CHtml::link('<span>' . 'Manage Student Attendance' . '</span>', array('/teachersportal/default/studentattendance')); } } ?> </span></li> <li><span> <?php if (count($is_classteacher) > 1 and Yii::app()->controller->action->id == 'studentattendance' and isset($_REQUEST['id'])) { echo CHtml::link('<span>' . 'Change Batch' . '</span>', array('/teachersportal/default/studentattendance')); } ?> </span></li> <!-- End For attendence --> <li><span> <?php
<td> </td> <td> </td> <td> </td> </tr> <td><?php echo $form->labelEx($model, 'Teacher'); ?> </td> <td> </td> <?php $criteria = new CDbCriteria(); $criteria->condition = 'is_deleted=:is_del'; $criteria->params = array(':is_del' => 0); ?> <td><?php echo $form->dropDownList($model, 'employee_id', CHtml::listData(Employees::model()->findAll($criteria), 'id', 'concatened'), array('empty' => Yii::t('Batch', 'Select Class Teacher'))); ?> <?php echo $form->error($model, 'employee_id'); ?> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td><?php
/** * @access public * @global array $registry * @return render Template with Success or Failed Action delete of Employee */ public function delete() { global $registry; if (isset($_GET['employee_id']) && !empty($_GET['employee_id'])) { $employee = new Employees(); if ($employee->deleteEmployee($_GET['employee_id'])) { $this->registry['template']->data('desc', 'Employee deleted successfully'); $this->registry['template']->render('header'); $this->registry['template']->render('employee/success'); $this->registry['template']->render('footer'); } else { $this->failed(); } } }
echo CHtml::link(ucfirst($feed->goal_name), array('examination/exams/update', 'sid' => $goal->id, 'exam_group_id' => $goal->exam_group_id, 'id' => $examgroup->batch_id)); //echo $feed->goal_name; } else { echo $feed->goal_name; } } elseif ($feed->activity_type >= 20 and $feed->activity_type <= 22) { $goal = ExamScores::model()->findByAttributes(array('id' => $feed->goal_id)); if ($goal != NULL) { $exam = Exams::model()->findByAttributes(array('id' => $goal->exam_id)); $examgroup = ExamGroups::model()->findByAttributes(array('id' => $exam->exam_group_id)); echo CHtml::link(ucfirst($feed->goal_name), array('examination/examScores/update', 'sid' => $goal->id, 'examid' => $goal->exam_id, 'id' => $examgroup->batch_id)); } else { echo $feed->goal_name; } } elseif ($feed->activity_type >= 23 and $feed->activity_type <= 28) { $goal = Employees::model()->findByAttributes(array('id' => $feed->goal_id)); if ($goal != NULL and $goal->is_deleted != 1) { echo CHtml::link($feed->goal_name, array('employees/employees/view', 'id' => $goal->id)); } else { echo $feed->goal_name; } } // End Employee Activities } ?> </strong> <?php // Update values if (in_array($feed->activity_type, $update_array)) { if ($feed->initial_field_value == '' and $feed->new_field_value != '' and $feed->activity_type != 9 and $feed->activity_type != 27) { echo ' as <strong>' . $feed->new_field_value . '</strong>';
</tr> </table> </td> </tr> </table> </div> <!-- End Header --> <?php if (isset($_REQUEST['id'])) { ?> <br /><br /> <span align="center"><h4>INDIVIDUAL EMPLOYEE ATTENDANCE REPORT</h4></span> <?php $individual = Employees::model()->findByAttributes(array('id' => $_REQUEST['employee'], 'employee_department_id' => $_REQUEST['id'])); $department_name = EmployeeDepartments::model()->findByAttributes(array('id' => $_REQUEST['id'])); ?> <!-- Individual Details --> <div style="border:#CCC 1px; width:700px; padding:10px 10px; background:#E1EAEF;"> <table style="font-size:14px;"> <tr> <td style="width:100px;"> <strong><?php echo Yii::t('report', 'Name'); ?> </strong> </td> <td style="width:10px;"> <strong>:</strong>
public function scorelabel($data, $row) { $employee = Employees::model()->findByAttributes(array('uid' => Yii::app()->user->id)); $is_teaching = TimetableEntries::model()->countByAttributes(array('subject_id' => $data->subject_id, 'employee_id' => $employee->id)); if ($is_teaching > 0 or Yii::app()->controller->action->id == 'classexam') { return "Manage Scores"; } else { return "View Scores"; } }
public function actionEmpindividualpdf() { $employee_name = Employees::model()->findByAttributes(array('id' => $_REQUEST['employee'])); $pdf_name = ucfirst($employee_name->first_name) . ' ' . ucfirst($employee_name->last_name) . ' Employee Attendance Report.pdf'; # HTML2PDF has very similar syntax $html2pdf = Yii::app()->ePdf->HTML2PDF(); $html2pdf->WriteHTML($this->renderPartial('empindividualpdf', array(), true)); $html2pdf->Output($pdf_name); }
?> </td> <td align="center"><?php echo Yii::t('Courses', 'Class Teacher'); ?> </td> <td align="center"><?php echo Yii::t('Courses', 'Actions'); ?> </td> </tr> <?php foreach ($batches_id as $batch_id) { echo '<tr id="batchrow' . $batch_id->id . '">'; echo '<td style="text-align:center; padding-left:10px; font-weight:bold;">' . $batch_id->coursename . '</td>'; $teacher = Employees::model()->findByAttributes(array('id' => $batch_id->employee_id)); echo '<td align="center">'; if ($teacher) { echo $teacher->first_name . ' ' . $teacher->last_name; } else { echo '-'; } // Count if any exam timetables are published in a batch. $exams_published = ExamGroups::model()->countByAttributes(array('batch_id' => $batch_id->id, 'is_published' => 1)); // Count if any exam results are published in a batch. $result_published = ExamGroups::model()->countByAttributes(array('batch_id' => $batch_id->id, 'result_published' => 1)); echo '<td align="center">'; if ($exams_published > 0 or $result_published > 0) { echo CHtml::link(Yii::t('examination', 'View Examinations'), array('/teachersportal/default/classexam', 'bid' => $batch_id->id)); } else { echo Yii::t('examination', 'No Exam Scheduled');
?> </span><?php echo Yii::t('Batch', 'Employees'); ?> </li> </ul> <div class="clear"></div> </div> <div class="namelist"> <ul> <li><?php echo '<strong>' . Yii::t('Batch', 'Class Teacher : ') . '</strong>'; ?> <?php $employee = Employees::model()->findByAttributes(array('id' => $batch->employee_id)); if ($employee != NULL) { echo $employee->first_name . ' ' . $employee->middle_name . ' ' . $employee->last_name; } ?> </li> <!--<li><strong>Class Teacher:</strong>Mary Symon</li> <li><strong>Class Teacher:</strong>Mary Symon</li>--> </ul> <div class="clear"></div> </div> <?php $time = 'nt_red'; ?> <?php $week = Weekdays::model()->findByAttributes(array('batch_id' => $batch->id));
public function actionEmployee() { $data = Employees::model()->findAll(array('order' => 'first_name DESC', 'condition' => 'employee_department_id=:id', 'params' => array(':id' => (int) $_POST['did']))); $data = CHtml::listData($data, 'id', 'first_name'); foreach ($data as $value => $name) { echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true); } }
public function actionSearch() { $model = new Students(); $criteria = new CDbCriteria(); $criteria->condition = 'first_name LIKE :match or middle_name LIKE :match or last_name LIKE :match'; $criteria->params = array(':match' => $_POST['char'] . '%'); $criteria->order = 'first_name ASC'; $total = Students::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(Yii::app()->params['listPerPage']); $pages->applyLimit($criteria); // the trick is here! $posts = Students::model()->findAll($criteria); $emp = new Employees(); $criteria_1 = new CDbCriteria(); $criteria_1->condition = 'first_name LIKE :match or middle_name LIKE :match or last_name LIKE :match'; $criteria_1->params = array(':match' => $_POST['char'] . '%'); $criteria_1->order = 'first_name ASC'; $tot = Employees::model()->count($criteria_1); $pages_1 = new CPagination($total); $pages_1->setPageSize(Yii::app()->params['listPerPage']); $pages_1->applyLimit($criteria_1); // the trick is here! $posts_1 = Employees::model()->findAll($criteria_1); $this->render('search', array('model' => $model, 'list' => $posts, 'posts' => $posts_1, 'pages' => $pages, 'item_count' => $total, 'page_size' => 10)); //$stud = Students::model()->findAll('first_name LIKE '.$_POST['char']); //echo count($stud); //exit; //print_r($_POST); }
<div class="tt-subject"> <div class="subject">'; $set = TimetableEntries::model()->findByAttributes(array('batch_id' => $_REQUEST['id'], 'weekday_id' => $weekdays[6]['weekday'], 'class_timing_id' => $timing[$i]['id'])); if (count($set) == 0) { $is_break = ClassTimings::model()->findByAttributes(array('id' => $timing[$i]['id'], 'is_break' => 1)); if ($is_break == NULL) { echo CHtml::ajaxLink(Yii::t('weekdays', 'Assign'), $this->createUrl('TimetableEntries/settime'), array('onclick' => '$("#jobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'] . '").dialog("open"); return false;', 'update' => '#jobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'], 'type' => 'GET', 'data' => array('batch_id' => $_REQUEST['id'], 'weekday_id' => $weekdays[6]['weekday'], 'class_timing_id' => $timing[$i]['id']), 'dataType' => 'text'), array('id' => 'showJobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'])); } else { echo Yii::t('weekdays', 'Break'); } } else { $time_sub = Subjects::model()->findByAttributes(array('id' => $set->subject_id)); if ($time_sub != NULL) { echo $time_sub->name . '<br>'; } $time_emp = Employees::model()->findByAttributes(array('id' => $set->employee_id)); if ($time_emp != NULL) { echo '<div class="employee">' . $time_emp->first_name . '</div>'; } echo CHtml::link('', array('timetableEntries/remove', 'id' => $set->id, 'batch_id' => $_REQUEST['id']), array('confirm' => 'Are you sure?', 'class' => 'delete')); } echo '</div> </div> </div> <div id="jobDialog' . $timing[$i]['id'] . $weekdays[6]['weekday'] . '"></div> </td>'; } ?> <!--timetable_td --> </tr> <?php
<!--<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>--> <?php $this->breadcrumbs = array($this->module->id); if ($list != NULL) { //$sub = Employees::model()->findAll("is_deleted=:x", array(':x'=>0)); $data = ''; $empy = EmployeeDepartments::model()->findAll(); foreach ($empy as $empy_1) { $emp_number = Employees::model()->findAll("employee_department_id=:x and is_deleted=:y", array(':x' => $empy_1->id, ':y' => 0)); $data .= '{name:"' . $empy_1->name . '", y:' . count($emp_number) . ', sliced: true, selected: true,},'; } //echo $data; ?> <script type="text/javascript"> var chart; $(document).ready(function() { chart = new Highcharts.Chart({ chart: { renderTo: 'container', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false }, title: { text: 'Employee Strength' }, tooltip: { formatter: function() {
<th><?php echo Yii::t('attendance', 'Date'); ?> </th> <th><?php echo Yii::t('attendance', 'Halfday'); ?> </th> <th><?php echo Yii::t('attendance', 'Fullday'); ?> </th> </tr> <?php $data = Employees::model()->findAll("employee_department_id=:x", array(':x' => $_REQUEST['id'])); if ($data) { foreach ($data as $data1) { echo '<tr>'; echo '<td>' . $data1->first_name . '</td>'; echo '<td>'; $date = EmployeeAttendances::model()->findAllByAttributes(array('employee_id' => $data1->id)); $fullday = 0; $halfday = 0; ?> <?php foreach ($date as $date1) { $attd_month = date('m', strtotime($date1->attendance_date)); $attd_year = date('y', strtotime($date1->attendance_date)); $crrnt_month = date('m');
</td> <td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td valign="top" width="75%"><div style="padding-left:20px;"> <h1>Reports Dashboard</h1> <div class="clear"></div> <div style="margin-top:20px; width:80%" id="container"></div> <?php if ($list != NULL) { //$sub = Employees::model()->findAll("is_deleted=:x", array(':x'=>0)); $data = ''; $empy = EmployeeDepartments::model()->findAll(); foreach ($empy as $empy_1) { $emp_number = Employees::model()->findAll("employee_department_id=:x", array(':x' => $empy_1->id)); $data .= '{name:"' . $empy_1->name . '", y:' . count($emp_number) . ', sliced: true, selected: true,},'; } //echo $data; ?> <div class="pdtab_Con" style="width:97%"> <div style="font-size:13px; padding:5px 0px"><strong><?php echo '<strong>' . Yii::t('report', 'Recent Employee Admissions') . '</strong>'; ?> </strong></div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tbody> <tr class="pdtab-h">