Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Class to handle the edit page.

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

namespace StringLocator\Extension\SQL;

[5] Fix | Delete

[6] Fix | Delete

use StringLocator\String_Locator;

[7] Fix | Delete

[8] Fix | Delete

/**

[9] Fix | Delete

* Edit class.

[10] Fix | Delete

[11] Fix | Delete

class Edit {

[12] Fix | Delete

[13] Fix | Delete

/**

[14] Fix | Delete

* Class constructor.

[15] Fix | Delete

[16] Fix | Delete

public function __construct() {

[17] Fix | Delete

add_filter( 'string_locator_view', array( $this, 'sql_edit_page' ) );

[18] Fix | Delete

[19] Fix | Delete

add_filter( 'admin_body_class', array( $this, 'admin_body_class' ) );

[20] Fix | Delete

add_filter( 'string_locator_editor_fields', array( $this, 'editor_form_fields' ) );

[21] Fix | Delete

}

[22] Fix | Delete

[23] Fix | Delete

/**

[24] Fix | Delete

* Generate form fields that need ot be a part of the editor interface for this data type.

[25] Fix | Delete

[26] Fix | Delete

* @param array $fields An array of form fields to output in hidden elements.

[27] Fix | Delete

[28] Fix | Delete

* @return array

[29] Fix | Delete

[30] Fix | Delete

public function editor_form_fields( $fields ) {

[31] Fix | Delete

if ( isset( $_GET['file-type'] ) && 'sql' === $_GET['file-type'] ) {

[32] Fix | Delete

$fields = array_merge(

[33] Fix | Delete

array(

[34] Fix | Delete

'sql-column' => $_GET['sql-column'],

[35] Fix | Delete

'sql-table' => $_GET['sql-table'],

[36] Fix | Delete

'sql-primary-column' => $_GET['sql-primary-column'],

[37] Fix | Delete

'sql-primary-type' => $_GET['sql-primary-type'],

[38] Fix | Delete

'sql-primary-key' => $_GET['sql-primary-key'],

[39] Fix | Delete

[40] Fix | Delete

$fields

[41] Fix | Delete

);

[42] Fix | Delete

}

[43] Fix | Delete

[44] Fix | Delete

return $fields;

[45] Fix | Delete

}

[46] Fix | Delete

[47] Fix | Delete

/**

[48] Fix | Delete

* Append a helper class ot the wp-admin body class.

[49] Fix | Delete

[50] Fix | Delete

* @param string $class The classes for the admin body class.

[51] Fix | Delete

[52] Fix | Delete

* @return string

[53] Fix | Delete

[54] Fix | Delete

public function admin_body_class( $class ) {

[55] Fix | Delete

if ( isset( $_GET['file-type'] ) && 'sql' === $_GET['file-type'] && current_user_can( String_Locator::$default_capability ) ) {

[56] Fix | Delete

$class .= ' file-edit-screen';

[57] Fix | Delete

}

[58] Fix | Delete

[59] Fix | Delete

return $class;

[60] Fix | Delete

}

[61] Fix | Delete

[62] Fix | Delete

/**

[63] Fix | Delete

* Conditionally filter the editor interface for SQL files.

[64] Fix | Delete

[65] Fix | Delete

* @param string $include_path The path to the editor interface.

[66] Fix | Delete

[67] Fix | Delete

* @return string

[68] Fix | Delete

[69] Fix | Delete

public function sql_edit_page( $include_path ) {

[70] Fix | Delete

if ( ! isset( $_GET['file-type'] ) || 'sql' !== $_GET['file-type'] || ! current_user_can( String_Locator::$default_capability ) ) {

[71] Fix | Delete

return $include_path;

[72] Fix | Delete

}

[73] Fix | Delete

[74] Fix | Delete

// Validate the table name.

[75] Fix | Delete

if ( ! isset( $_GET['sql-table'] ) || ! validate_sql_fields( $_GET['sql-table'] ) ) {

[76] Fix | Delete

return $include_path;

[77] Fix | Delete

}

[78] Fix | Delete

[79] Fix | Delete

// Validate the primary column

[80] Fix | Delete

if ( ! isset( $_GET['sql-primary-column'] ) || ! validate_sql_fields( $_GET['sql-primary-column'] ) ) {

[81] Fix | Delete

return $include_path;

[82] Fix | Delete

}

[83] Fix | Delete

[84] Fix | Delete

// A primary key needs to be provided, this could be anything so we just make sure it is set and not empty.

[85] Fix | Delete

if ( ! isset( $_GET['sql-primary-key'] ) || empty( $_GET['sql-primary-key'] ) ) {

[86] Fix | Delete

return $include_path;

[87] Fix | Delete

}

[88] Fix | Delete

[89] Fix | Delete

return STRING_LOCATOR_PLUGIN_DIR . '/includes/Extension/SQL/views/editor/sql.php';

[90] Fix | Delete

}

[91] Fix | Delete

}

[92] Fix | Delete

[93] Fix | Delete

new Edit();

[94] Fix | Delete

[95] Fix | Delete