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">
