public function addNewbuilding($parentid) { addtolog("Model addNewBuilding begin"); $sql=" INSERT INTO `newbuildings_subitems` (`ParentID`) VALUES ('".$parentid."') ; "; $ret=$this->db->exec($sql); $ret=$this->addEvent('NewbuildingAdded','newbuildings_subitems','ParentID',$parentid,$ret->lastInsertID); addtolog("Model addNewBuilding end"); }
public function import() { // import functionality to get data from ISCentre addtolog("Controller import begin"); include_once ("controller/DBImport.php"); $this->dbimport = new DBImport($this->settings); // instantiate a class $action = getvariablereq ('action'); // get action from the request $data = getvariablereq ('data' ); // get JSON data from the request $data = str_replace('\"','"',$data); // fix some escaped paths (if any) $mtime = microtime(true); $thisfolder = substr($_SERVER['DOCUMENT_ROOT'].$_SERVER['SCRIPT_NAME'],0,strrpos($_SERVER['DOCUMENT_ROOT'].$_SERVER['SCRIPT_NAME'] ,"/"))."/data/temp/dbupdate"; @mkdirr ($thisfolder); switch ($action) { case ('update'): $this->dbimport->importtables($thisfolder); echo "Job done\n"; break; default: if (sizeof($_FILES)>0) { foreach ($_FILES as $file) { if (file_exists($thisfolder."/".$file['name'])) { unlink($thisfolder."/".$file['name']); } move_uploaded_file ($file['tmp_name'],$thisfolder."/".$file['name']); echo "File accepted"; } } break; } $fieldid = array(); addtolog("Controller import end"); }