// Generic CSV - Display an Editor form that allows the user to pick the CSV data to apply to each column
function selectGCSVColumns ( GCSVImport, csv, header ) {
		header.push('');
    selectGCSVImport = new $.fn.dataTable.Editor( {
        fields: [
			{
				"label": "Prefix:",
				"name": "prefix",
				"type": 'hidden'
			},
			{
				"label": "First Name:",
				"name": "first_name",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Middle Name:",
				"name": "middle_name",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Last Name:",
				"name": "last_name",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Suffix:",
				"name": "suffix",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Preferred Name:",
				"name": "preferred_name",
				"type": 'hidden'
			},
			{
				"label": "Title:",
				"name": "title",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Company Name:",
				"name": "company_name",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Nest:",
				"name": "nest",
				"type": 'hidden'
			},
			{
				"label": "Date of Birth:",
				"name": "date_of_birth",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Gender:",
				"name": "gender",
				"type": 'hidden'
			},
			{
				"label": "Phone:",
				"name": "phone_choice",
				"type": 'hidden'
			},
			{
				"label": "Home Phone:",
				"name": "home_phone",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Mobile Phone:",
				"name": "mobile_phone",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Work Phone:",
				"name": "work_phone",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Fax:",
				"name": "fax_phone",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Email:",
				"name": "email_choice",
				"type": 'hidden'
			},
			{
				"label": "Personal Email:",
				"name": "personal_email",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Work Email:",
				"name": "work_email",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Preferred Email Type:",
				"name": "preferred_email_type",
				"type": 'hidden'
			},
			{
				"label": "Street:",
				"name": "street",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "City:",
				"name": "city",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "State:",
				"name": "state",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Postal Code:",
				"name": "postal_code",
				"type": 'select',
				"options": header,
				"def": ''
			},
			{
				"label": "Source:",
				"name": "source",
				"className": "",
				"type": "hidden",
				"def": "Initial Market"
			},
			{
				"label": "MOD Email:",
				"name": "mod_email",
				"type": "hidden",
				"def": ""
			},
			{
				"label": "Street 2:",
				"name": "street2",
				"type": "hidden",
				"def": ""
			},
			{
				"label": "Index Count:",
				"name": "index_count",
				"className": "",
				"type": "hidden",
				"def": "2"
			}
		]
    });
	
    selectGCSVImport.create({
        title: 'Map CSV fields',
        buttons: 'Import '+csv.length+' records',
        message: 'Select the CSV column you want to use the data from for each field.'
    });
 
    selectGCSVImport.on('submitComplete', function (e, json, data, action) {
        // Use the host Editor instance to show a multi-row create form allowing the user to submit the data.
        GCSVImport.create( csv.length, {
            title: 'Confirm import',
            buttons: 'Submit',
            message: 'Click the <i>Submit</i> button to confirm the import of '+csv.length+' rows of data. Optionally, override the value for a field to set a common value by clicking on the field below.'
        } );
        for ( var i=0 ; i<fields.length ; i++ ) {
            var field = GCSVImport.field( fields[i] );
            var mapped = data[ field.name() ];
 
            for ( var j=0 ; j<csv.length ; j++ ) {
                field.multiSet( j, mapped ? csv[j][mapped] : '' );
            }
        }
    } );
}
 
// Generic CSV - Regular editor for the table
    GCSVImport = new $.fn.dataTable.Editor( {
        table: '#p200table',
		ajax: function ( method, url, d, successCallback, errorCallback ) {
            var output = { data: [] };
 
            if ( d.action === 'create' ) {
                // Create new row(s), using the current time and loop index as
                // the row id
                var dateKey = +new Date();
 
                $.each( d.data, function (key, value) {
                    var id = dateKey+''+key;
 
                    value.DT_RowId = id;
                    localSave[ id ] = value;
                    output.data.push( value );
                } );
            }
            else if ( d.action === 'edit' ) {
                // Update each edited item with the data submitted
                $.each( d.data, function (id, value) {
                    value.DT_RowId = id;
                    $.extend( localSave[ id ], value );
                    output.data.push( localSave[ id ] );
                } );
            }
            else if ( d.action === 'remove' ) {
                // Remove items from the object
                $.each( d.data, function (id) {
                    delete localSave[ id ];
                } );
            }
 
            // Store the latest `localSave` object for next reload
            localStorage.setItem( 'localSave', JSON.stringify(localSave) );
 
            // Show Editor what has changed
            successCallback( output );
        },
        fields: [
			{
				"label": "Prefix:",
				"name": "prefix",
				"type": 'hidden'
			},
			{
				"label": "First Name:",
				"name": "first_name"
			},
			{
				"label": "Middle Name:",
				"name": "middle_name"
			},
			{
				"label": "Last Name:",
				"name": "last_name"
			},
			{
				"label": "Suffix:",
				"name": "suffix"
			},
			{
				"label": "Preferred Name:",
				"name": "preferred_name",
				"type": 'hidden'
			},
			{
				"label": "Title:",
				"name": "title"
			},
			{
				"label": "Company Name:",
				"name": "company_name"
			},
			{
				"label": "Nest:",
				"name": "nest",
				"type": "select2",
				"def": "no nest",
				"opts": {
					"placeholder": "no nest",
					"allowClear": true,
					"minimumResultsForSearch": Infinity
				},
				"options": [
				]
			},
			{
				"label": "Date of Birth:",
				"name": "date_of_birth"
			},
			{
				"label": "Gender:",
				"name": "gender",
				"type": 'hidden'
			},
			{
				"label": "Phone:",
				"name": "phone_choice",
				"type": 'hidden'
			},
			{
				"label": "Home Phone:",
				"name": "home_phone"
			},
			{
				"label": "Mobile Phone:",
				"name": "mobile_phone"
			},
			{
				"label": "Work Phone:",
				"name": "work_phone"
			},
			{
				"label": "Fax:",
				"name": "fax_phone"
			},
			{
				"label": "Email:",
				"name": "email_choice",
				"type": 'hidden'
			},
			{
				"label": "Personal Email:",
				"name": "personal_email"
			},
			{
				"label": "Work Email:",
				"name": "work_email"
			},
			{
				"label": "Preferred Email Type:",
				"name": "preferred_email_type",
				"type": 'hidden'
			},
			{
				"label": "Street:",
				"name": "street"
			},
			{
				"label": "City:",
				"name": "city"
			},
			{
				"label": "State:",
				"name": "state"
			},
			{
				"label": "Postal Code:",
				"name": "postal_code"
			},
			{
				"label": "Source:",
				"name": "source",
				"className": "",
				"type": "hidden",
				"def": "Initial Market"
			},
			{
				"label": "MOD Email:",
				"name": "mod_email",
				"type": "hidden",
				"def": ""
			},
			{
				"label": "Street 2:",
				"name": "street2",
				"type": "hidden",
				"def": ""
			},
			{
				"label": "Index Count:",
				"name": "index_count",
				"className": "",
				"type": "hidden",
				"def": "2"
			}
		]
    } );
	var fields = GCSVImport.order();
    for ( var i=0 ; i<fields.length ; i++ ) {
        var field = GCSVImport.field( fields[i] );
	}
 
    // Generic CSV - Upload Editor - triggered from the import button. Used only for uploading a file to the browser
    var uploadGCSVImport = new $.fn.dataTable.Editor( {
        fields: [ {
            label: 'CSV file:',
            name: 'csv',
            type: 'upload',
            ajax: function ( files ) {
                // Ajax override of the upload so we can handle the file locally. Here we use Papa
                // to parse the CSV.
				Papa.parse(files[0], {
                    header: true,
                    skipEmptyLines: true,
                    complete: function (results) {
                        if ( results.errors.length ) {
                            console.log( results );
                            uploadGCSVImport.field('csv').error( 'CSV parsing error: '+ results.errors[0].message );
                        }
                        else {
                            uploadGCSVImport.close();
                            selectGCSVColumns( GCSVImport, results.data, results.meta.fields );
                        }
                    }
                });
            }
        } ]
    } );
	
/* Sets the sizes of the modal windows for the import */
uploadGCSVImport.on('open', function (e, mode, action) {
  var container = $(uploadGCSVImport.displayNode());
 
  container.removeClass('large medium small small-loginOverlay');
 
  if (action === 'create') {
    container.addClass('small upload');
  } else if (action === 'remove') {
  container.addClass('small upload');
  } else {
    container.addClass('small upload');
  }
});