PHP Classes\Factory\Import\Instance\InstanceUploaderFromExcel Beispiele

Beispiel #1

Datei: cmdImportCommonMemberLoadsFromExcel.php Projekt: vokson/scad.constructor.php

 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');
 }

Beispiel #2

Datei: cmdImportParameterMembersFromExcel.php Projekt: vokson/scad.constructor.php

 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');
 }

Beispiel #3

Datei: cmdExecute.php Projekt: vokson/scad.constructor.php

 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();
 }

Beispiel #4

Datei: cmdUploadExcelConstructorFile.php Projekt: vokson/scad.constructor.php

 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');
 }

Beispiel #5

Datei: index_SM.php Projekt: vokson/scad.constructor.php

<?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);

Beispiel #6

Datei: index_TAF2_PR-205a.php Projekt: vokson/scad.constructor.php

 Classes\Utils\Timer\Timer::start('STEEL_MEMBER_UPLOAD');
 $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');

Beispiel #7

Datei: index_SP.php Projekt: vokson/scad.constructor.php

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/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');