<?php $importConfigID = $_POST['importConfigID']; $shortName = $_POST['shortName']; $configuration = $_POST['configuration']; $orgNameImported = $_POST['orgNameImported']; $orgNameMapped = $_POST['orgNameMapped']; if ($importConfigID != '') { $instance = new ImportConfig(new NamedArguments(array('primaryKey' => $importConfigID))); } else { $instance = new ImportConfig(); } $instance->shortName = $shortName; $instance->configuration = $configuration; try { $instance->save(); } catch (Exception $e) { echo $e->getMessage(); } try { //first remove all payment records, then we'll add them back $instance->removeOrgNameMappings(); $orgNameImportedArray = array(); $orgNameImportedArray = explode(':::', $_POST['orgNameImported']); $orgNameMappedArray = array(); $orgNameMappedArray = explode(':::', $_POST['orgNameMapped']); foreach ($orgNameImportedArray as $key => $value) { if ($value && $orgNameMapped[$key]) { $orgNameMapping = new OrgNameMapping(); $orgNameMapping->importConfigID = $instance->primaryKey; $orgNameMapping->orgNameImported = $orgNameImportedArray[$key];
session_start(); include_once 'directory.php'; $pageTitle = _('Resources import'); include 'templates/header.php'; ?> <div id="importPage"><h1><?php echo _("Delimited File Import"); ?> </h1> <?php // CSV configuration $required_columns = array('titleText' => 0, 'resourceURL' => 0, 'resourceAltURL' => 0, 'parentResource' => 0, 'organization' => 0, 'role' => 0); if ($_POST['submit']) { //get necessary configuration instances $importConfigInstanceArray = array(); $instance = new ImportConfig(); $importConfigInstanceArray = $instance->allAsArray(); $orgMappingInstance = new OrgNameMapping(); $orgMappings = array(); $configuration = json_decode($instance->configuration, true); $delimiter = $_POST['delimiter']; $uploaddir = 'attachments/'; $uploadfile = $uploaddir . basename($_FILES['uploadFile']['name']); if (move_uploaded_file($_FILES['uploadFile']['tmp_name'], $uploadfile)) { print '<p>' . _("The file has been successfully uploaded.") . '</p>'; // Let's analyze this file if (($handle = fopen($uploadfile, "r")) !== FALSE) { if (($data = fgetcsv($handle, 0, $delimiter)) !== FALSE) { $columns_ok = true; foreach ($data as $key => $value) { $available_columns[$value] = $key;
<?php $importConfigID = $_GET['importConfigID']; $importConfig = new ImportConfig(new NamedArguments(array('primaryKey' => $importConfigID))); try { $importConfig->removeImportConfig(); echo _("Import configuration successfully deleted."); } catch (Exception $e) { echo $e->getMessage(); }
<?php $instanceArray = array(); $obj = new ImportConfig(); $instanceArray = $obj->allAsArray(); echo "<div class='adminRightHeader'>" . _("Import Configuration") . "</div>"; if (count($instanceArray) > 0) { ?> <table class='linedDataTable' > <tr> <th><?php echo _("Name"); ?> </th> <th style='width:20px;'> </th> <th style='width:20px;'> </th> </tr> <?php foreach ($instanceArray as $instance) { echo "<tr>"; echo "<td>" . $instance['shortName'] . "</td>"; echo "<td><a href='ajax_forms.php?action=getAdminImportConfigUpdateForm&updateID=" . $instance['importConfigID'] . "&height=700&width=1024&modal=true' class='thickbox'><img src='images/edit.gif' alt='edit' title='edit'></a></td>"; echo "<td><a href='javascript:deleteImportConfig(\"ImportConfig\", \"" . $instance['importConfigID'] . "\");'><img src='images/cross.gif' alt='remove' title='remove'></a></td>"; echo "</tr>"; } ?> <br /> </table> <?php } else { echo "(none found)<br />";