<?php

include_once('../config.php');

include_once('../dbmanager.php');

include_once('../batchprgmanager.php');

$db								= new dbmanager($dbHost,$dbUser,$dbPwd,$dbName);

$user							= new batchprgmanager($db);

require_once dirname(__FILE__) . '/PHPExcel/Classes/PHPExcel.php';

$objPHPExcel1 = new PHPExcel();

$objReader = new PHPExcel_Reader_Excel5();

$objReader->setReadDataOnly(false);

$objPHPExcel = $objReader->load( dirname(__FILE__) . '/obmc.xls' );

$rowIterator = $objPHPExcel->getActiveSheet()->getRowIterator();

foreach($rowIterator as $row){

	$cellIterator = $row->getCellIterator();

	$rowIndex = $row->getRowIndex();

	$dArray	= array();

	foreach ($cellIterator as $cell) {

		switch ($cell->getColumn()) {

			case 'A' :	$dArray['fld_doctors_deptid']=$cell->getCalculatedValue();		

						break;

			case 'C' :	$dArray['fld_doctors_name']=$cell->getCalculatedValue();

						break;

			case 'D' :	$dArray['fld_doctors_add1']=$cell->getCalculatedValue();

						break;

			case 'E' :	$dArray['fld_doctors_add2']=$cell->getCalculatedValue();

						break;

			case 'F' :	$dArray['fld_doctors_phone']=$cell->getCalculatedValue();

						break;				

		}

	}

	//print_r($dArray);echo "<br>";

	echo $drs							= $user->insertDoctor($dArray);

	//echo $cell = $sheet->getCell('C' . $rowIndex);

}

?>