/**
  * @param $csvData
  * @param $tableName
  */
 public function __construct($csvFile = "", $tableName = "")
 {
     $this->csvFile = $csvFile;
     $this->tableName = $tableName;
     $this->load->model('Datamanagementqueries');
     $this->primaryColumn = Datamanagementqueries::getPrimaryKey($tableName);
 }
 public function __construct()
 {
     self::$dbObj = $this->db;
 }
Beispiel #3
0
                        </select>
                    </div>
                    <div class="panel-footer" style="text-align: right"><a href="#">Show All</a></div>
                </div>

                <div class="panel panel-default dm_tables" id="dm_descriptor">
                    <div class="panel-heading">Descriptors</div>
                    <div class="panel-body">
                        <form class="form-inline undo-overrides default-form-inline">
                            <div class="form-group">
                                <input id="dm_search_descriptor" class="form-control input-sm" placeholder="Filter.."/>
                             </div>
                        </form>                        
                        <select class="form-control dm_select" size="10" id="dm_select_descriptor">
                            <?php 
foreach (Datamanagementqueries::getDescriptorsList() as $obj) {
    ?>
                                <option value="<?php 
    echo $obj->TableName;
    ?>
"><?php 
    echo $obj->TableName;
    ?>
</option>
                            <?php 
}
?>

                        </select>
                    </div>
                    <div class="panel-footer" style="text-align: right"><a href="#">Show All</a></div>
Beispiel #4
0
 public function checkFile($file, $tableName)
 {
     $this->load->model('Datamanagementqueries');
     $content = array_map('str_getcsv', file($file));
     $columns = Datamanagementqueries::getTableDetails($tableName);
     foreach ($content[0] as $k => $column_name) {
         if (trim(strtolower($columns[$k]->COLUMN_NAME)) !== trim(strtolower($column_name))) {
             return false;
         }
     }
     return true;
 }