function doExecute(\Classes\Controller\Controller\Request $request) { \Classes\Utils\Timer\Timer::start('LOADS_UPLOAD'); // Получаем переменные $filename = $request->getProperty('filename'); $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $objectArray = $uploadFactory->upload($filename, new \Classes\Instance\Load\Member\CommonMemberLoad()); $notFoundObjects = \Classes\Factory\Model\Addition\MemberLoadAddition::add($objectArray); $request->addFeedback($notFoundObjects); \Classes\Utils\Timer\Timer::stop('LOADS_UPLOAD'); $request->addFeedback(\Classes\Utils\Timer\Timer::show('LOADS_UPLOAD')); include \Classes\Controller\Util\Utils::createViewName('importCommonMemberLoadsFromExcel'); }
function doExecute(\Classes\Controller\Controller\Request $request) { \Classes\Utils\Timer\Timer::start('PARAMETER_MEMBER_UPLOAD'); // Получаем переменные $filename = $request->getProperty('filename'); $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $objectArray = $uploadFactory->upload($filename, new \Classes\Instance\Member\ParameterMember()); foreach ($objectArray as &$object) { \Classes\Factory\Model\Addition\ParameterMemberAddition::add($object); } \Classes\Utils\Timer\Timer::stop('PARAMETER_MEMBER_UPLOAD'); $request->addFeedback(\Classes\Utils\Timer\Timer::show('PARAMETER_MEMBER_UPLOAD')); include \Classes\Controller\Util\Utils::createViewName('importParameterMembersFromExcel'); }
function doExecute(\Classes\Controller\Controller\Request $request) { // Delete temp files $this->deleteAllFilesFromTempFolder(); try { // Check command file $filename = $this->getTempFileName("constructor.xlsx"); if ($filename !== FALSE) { // Upload command file $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $objectArray = $uploadFactory->upload($filename, new \Classes\Instance\Command\Command()); foreach ($objectArray as &$object) { $this->doCommand($object); } } } catch (Exception $e) { $request->addFeedback("Exception: " . $e->getMessage() . "</br>"); include \util\Utils::createViewName('execute'); } $this->servicePrint(); }
function doExecute(\Classes\Controller\Controller\Request $request) { $request->addFeedback('UploadExcelConstructorFile'); // Получаем переменные $originName = $request->getProperty('filename'); $folderName = $request->getProperty('timestamp'); // Create new folder in TEMP $this->makeTempFolder($folderName); // Check command file $tempName = NULL; if (\Classes\Controller\Util\Utils::getTempFileName($originName, $tempName)) { // Upload command file $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $array = $uploadFactory->upload($tempName, new \Classes\Instance\Command\Command()); foreach ($array as $e) { $command = $e->getProperty('command'); $object = $e->getProperty('object'); $format = $e->getProperty('format'); $file = $e->getProperty('file'); // Prepare empty command row $row = array(); if (!is_null($command)) { $row['command'] = $command->get(); } if (!is_null($object)) { $row['object'] = $object->get(); } if (!is_null($format)) { $row['format'] = $format->get(); } if (!is_null($file)) { $row['file'] = $file->get(); } $request->addFeedback($row); } } include \Classes\Controller\Util\Utils::createViewName('uploadExcelConstructorFile'); }
<?php spl_autoload_extensions(".php"); spl_autoload_register(); /** PHPExcel_IOFactory */ include 'Classes/PHPExcel/IOFactory.php'; set_time_limit(36000); \Classes\Factory\Model\Model::$coordinateTolerance = 0.01; \Classes\Utils\Math\Constant::$epsilon = 0.01; try { // UPLOAD STEEL MEMBERS Classes\Utils\Timer\Timer::start('STEEL_MEMBER_UPLOAD'); $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $steelMemberArray = $uploadFactory->upload('./Source/Excel/Small_Model/Members.xlsx', new \Classes\Instance\Member\SteelMember()); foreach ($steelMemberArray as &$object) { Classes\Factory\Model\Addition\SteelMemberAddition::add($object); } Classes\Utils\Timer\Timer::stop('STEEL_MEMBER_UPLOAD'); // DELETE DOUBLE NODES \Classes\Utils\Timer\Timer::start('COMBINE_DOUBLE_NODES'); \Classes\Utils\Node\DoubleNodes::combineAll(array(Classes\Factory\Model\Model::getHashTable())); \Classes\Utils\Timer\Timer::stop('COMBINE_DOUBLE_NODES'); // DIVIDE MEMBERS BY NODES \Classes\Utils\Timer\Timer::start('DIVIDE_ALL_MEMBERS'); \Classes\Utils\Member\DivideMember::divideAllMembersByExistingNodes(); \Classes\Utils\Timer\Timer::stop('DIVIDE_ALL_MEMBERS'); // UPLOAD LOAD CASES Classes\Utils\Timer\Timer::start('LOAD_CASES_UPLOAD'); $loadCaseArray = $uploadFactory->upload('./Source/Excel/Small_Model/Load Cases.xlsx', new \Classes\Instance\LoadCase\LoadCase()); foreach ($loadCaseArray as $object) { Classes\Factory\Model\Addition\LoadCaseAddition::add($object);
$uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $steelMemberArray = $uploadFactory->upload('./Source/Excel/TAF2_PR-205a/PR-205a_SM.xlsx', new \Classes\Instance\Member\SteelMember()); foreach ($steelMemberArray as &$object) { Classes\Factory\Model\Addition\SteelMemberAddition::add($object); } // UPLOAD NEW STEEL MEMBERS $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $steelMemberArray = $uploadFactory->upload('./Source/Excel/TAF2_PR-205a/PR-205a_SM_new.xlsx', new \Classes\Instance\Member\SteelMember()); foreach ($steelMemberArray as &$object) { Classes\Factory\Model\Addition\SteelMemberAddition::add($object); } Classes\Utils\Timer\Timer::stop('STEEL_MEMBER_UPLOAD'); // UPLOAD RC MEMBERS Classes\Utils\Timer\Timer::start('RC_MEMBER_UPLOAD'); $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $rcMemberArray = $uploadFactory->upload('./Source/Excel/TAF2_PR-205a/PR-205a_RC.xlsx', new \Classes\Instance\Member\ParameterMember()); foreach ($rcMemberArray as &$object) { Classes\Factory\Model\Addition\ParameterMemberAddition::add($object); } Classes\Utils\Timer\Timer::stop('RC_MEMBER_UPLOAD'); // DELETE DOUBLE NODES \Classes\Utils\Timer\Timer::start('COMBINE_DOUBLE_NODES'); \Classes\Utils\Node\DoubleNodes::combineAll(array(Classes\Factory\Model\Model::getHashTable())); \Classes\Utils\Timer\Timer::stop('COMBINE_DOUBLE_NODES'); // DIVIDE MEMBERS BY NODES \Classes\Utils\Timer\Timer::start('DIVIDE_ALL_MEMBERS'); \Classes\Utils\Member\DivideMember::divideAllMembersByExistingNodes(); \Classes\Utils\Timer\Timer::stop('DIVIDE_ALL_MEMBERS'); // UPLOAD LOAD CASES Classes\Utils\Timer\Timer::start('LOAD_CASES_UPLOAD'); $loadCaseArray = $uploadFactory->upload('./Source/Excel/TAF2_PR-205a/PR-205a_Load_Cases.xlsx', new \Classes\Instance\LoadCase\LoadCase());
set_time_limit(36000); \Classes\Factory\Model\Model::$coordinateTolerance = 0.01; \Classes\Utils\Math\Constant::$epsilon = 0.01; try { // UPLOAD STEEL MEMBERS Classes\Utils\Timer\Timer::start('STEEL_MEMBER_UPLOAD'); $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $steelMemberArray = $uploadFactory->upload('./Source/Excel/Simple_Piperack/Steel_Members.xlsx', new \Classes\Instance\Member\SteelMember()); foreach ($steelMemberArray as &$object) { Classes\Factory\Model\Addition\SteelMemberAddition::add($object); } Classes\Utils\Timer\Timer::stop('STEEL_MEMBER_UPLOAD'); // UPLOAD RC MEMBERS Classes\Utils\Timer\Timer::start('RC_MEMBER_UPLOAD'); $uploadFactory = new \Classes\Factory\Import\Instance\InstanceUploaderFromExcel(); $rcMemberArray = $uploadFactory->upload('./Source/Excel/Simple_Piperack/RC_Members.xlsx', new \Classes\Instance\Member\ParameterMember()); foreach ($rcMemberArray as &$object) { Classes\Factory\Model\Addition\ParameterMemberAddition::add($object); } Classes\Utils\Timer\Timer::stop('RC_MEMBER_UPLOAD'); // DELETE DOUBLE NODES \Classes\Utils\Timer\Timer::start('COMBINE_DOUBLE_NODES'); \Classes\Utils\Node\DoubleNodes::combineAll(array(Classes\Factory\Model\Model::getHashTable())); \Classes\Utils\Timer\Timer::stop('COMBINE_DOUBLE_NODES'); // DIVIDE MEMBERS BY NODES \Classes\Utils\Timer\Timer::start('DIVIDE_ALL_MEMBERS'); \Classes\Utils\Member\DivideMember::divideAllMembersByExistingNodes(); \Classes\Utils\Timer\Timer::stop('DIVIDE_ALL_MEMBERS'); // UPLOAD LOAD CASES Classes\Utils\Timer\Timer::start('LOAD_CASES_UPLOAD'); $loadCaseArray = $uploadFactory->upload('./Source/Excel/Simple_Piperack/Load_Cases.xlsx', new \Classes\Instance\LoadCase\LoadCase());