<?php

[0] Fix | Delete

[1] Fix | Delete

namespace StringLocator\Extension\SQL;

[2] Fix | Delete

[3] Fix | Delete

/**

[4] Fix | Delete

* Save class.

[5] Fix | Delete

*/

[6] Fix | Delete

class Save {

[7] Fix | Delete

[8] Fix | Delete

private $override_save = false;

[9] Fix | Delete

[10] Fix | Delete

/**

[11] Fix | Delete

* Class constructor.

[12] Fix | Delete

*/

[13] Fix | Delete

public function __construct() {

[14] Fix | Delete

add_filter( 'string_locator_save_params', array( $this, 'check_save_parameters' ) );

[15] Fix | Delete

add_filter( 'string_locator_save_handler', array( $this, 'maybe_handle_save' ) );

[16] Fix | Delete

}

[17] Fix | Delete

[18] Fix | Delete

/**

[19] Fix | Delete

* Check the save parameters to determine if the SQL handler should take over the save request.

[20] Fix | Delete

*

[21] Fix | Delete

* @param array $parameters An array of REST API request parameters.

[22] Fix | Delete

*

[23] Fix | Delete

* @return array

[24] Fix | Delete

*/

[25] Fix | Delete

public function check_save_parameters( $parameters ) {

[26] Fix | Delete

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

[27] Fix | Delete

$this->override_save = true;

[28] Fix | Delete

}

[29] Fix | Delete

[30] Fix | Delete

return $parameters;

[31] Fix | Delete

}

[32] Fix | Delete

[33] Fix | Delete

/**

[34] Fix | Delete

* Override the save handler if the parameters indicate that the SQL handler should take over.

[35] Fix | Delete

*

[36] Fix | Delete

* @param mixed $handler The class handling the save request.

[37] Fix | Delete

*

[38] Fix | Delete

* @return self|mixed

[39] Fix | Delete

*/

[40] Fix | Delete

public function maybe_handle_save( $handler ) {

[41] Fix | Delete

if ( ! $this->override_save ) {

[42] Fix | Delete

return $handler;

[43] Fix | Delete

}

[44] Fix | Delete

[45] Fix | Delete

return $this;

[46] Fix | Delete

}

[47] Fix | Delete

[48] Fix | Delete

/**

[49] Fix | Delete

* Funciton to trigger the save behavior.

[50] Fix | Delete

*

[51] Fix | Delete

* @param array $params An array of save parameters.

[52] Fix | Delete

*

[53] Fix | Delete

* @return array|\array[][]

[54] Fix | Delete

*/

[55] Fix | Delete

public function save( $params ) {

[56] Fix | Delete

global $wpdb;

[57] Fix | Delete

[58] Fix | Delete

$content = $params['string-locator-editor-content'];

[59] Fix | Delete

[60] Fix | Delete

/**

[61] Fix | Delete

* Filter if the save process should be performed or not.

[62] Fix | Delete

*

[63] Fix | Delete

* @attr bool $can_save Can the save be carried out.

[64] Fix | Delete

* @attr string $content The content to save.

[65] Fix | Delete

* @attr string $path Path to the file being edited.

[66] Fix | Delete

*/

[67] Fix | Delete

$can_save = apply_filters( 'string_locator_pre_save', true, $content, 'sql' );

[68] Fix | Delete

[69] Fix | Delete

if ( ! $can_save ) {

[70] Fix | Delete

return array(

[71] Fix | Delete

'notices' => apply_filters( 'string_locator_pre_save_fail_notice', array() ),

[72] Fix | Delete

);

[73] Fix | Delete

}

[74] Fix | Delete

[75] Fix | Delete

if ( 'int' === $params['sql-primary-type'] ) {

[76] Fix | Delete

$original = $wpdb->get_var(

[77] Fix | Delete

$wpdb->prepare(

[78] Fix | Delete

'SELECT ' . $params['sql-column'] . ' FROM ' . $params['sql-table'] . ' WHERE ' . $params['sql-primary-column'] . ' = %d LIMIT 1', // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- It is not possible to prepare a table or column name, but these are instead validated in `/includes/Search/class-sql.php` before reaching this point.

[79] Fix | Delete

$params['sql-primary-key']

[80] Fix | Delete

)

[81] Fix | Delete

);

[82] Fix | Delete

} else {

[83] Fix | Delete

$original = $wpdb->get_var(

[84] Fix | Delete

$wpdb->prepare(

[85] Fix | Delete

'SELECT ' . $params['sql-column'] . ' FROM ' . $params['sql-table'] . ' WHERE ' . $params['sql-primary-column'] . ' = %s LIMIT 1', // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- It is not possible to prepare a table or column name, but these are instead validated in `/includes/Search/class-sql.php` before reaching this point.

[86] Fix | Delete

$params['sql-primary-key']

[87] Fix | Delete

)

[88] Fix | Delete

);

[89] Fix | Delete

}

[90] Fix | Delete

[91] Fix | Delete

$wpdb->update(

[92] Fix | Delete

$params['sql-table'],

[93] Fix | Delete

array(

[94] Fix | Delete

$params['sql-column'] => $content,

[95] Fix | Delete

),

[96] Fix | Delete

array(

[97] Fix | Delete

$params['sql-primary-column'] => $params['sql-primary-key'],

[98] Fix | Delete

)

[99] Fix | Delete

);

[100] Fix | Delete

[101] Fix | Delete

/**

[102] Fix | Delete

* Filter if the save process completed as it should or if warnings should be returned.

[103] Fix | Delete

*

[104] Fix | Delete

* @attr bool $save_successful Boolean indicating if the save was successful.

[105] Fix | Delete

* @attr string $content The edited content.

[106] Fix | Delete

* @attr string $original The original content.

[107] Fix | Delete

* @attr string $path The path to the file being edited.

[108] Fix | Delete

*/

[109] Fix | Delete

$save_successful = apply_filters( 'string_locator_post_save', true, $content, $original, 'sql' );

[110] Fix | Delete

[111] Fix | Delete

/**

[112] Fix | Delete

* Check the status of the site after making our edits.

[113] Fix | Delete

* If the site fails, revert the changes to return the sites to its original state

[114] Fix | Delete

*/

[115] Fix | Delete

if ( ! $save_successful ) {

[116] Fix | Delete

$wpdb->update(

[117] Fix | Delete

$params['sql-table'],

[118] Fix | Delete

array(

[119] Fix | Delete

$params['sql-column'] => $original,

[120] Fix | Delete

),

[121] Fix | Delete

array(

[122] Fix | Delete

$params['sql-primary-column'] => $params['sql-primary-key'],

[123] Fix | Delete

)

[124] Fix | Delete

);

[125] Fix | Delete

[126] Fix | Delete

return array(

[127] Fix | Delete

'notices' => apply_filters( 'string_locator_post_save_fail_notice', array() ),

[128] Fix | Delete

);

[129] Fix | Delete

}

[130] Fix | Delete

[131] Fix | Delete

return array(

[132] Fix | Delete

'notices' => array(

[133] Fix | Delete

array(

[134] Fix | Delete

'type' => 'success',

[135] Fix | Delete

'message' => __( 'The database entry has been updated.', 'string-locator' ),

[136] Fix | Delete

),

[137] Fix | Delete

),

[138] Fix | Delete

);

[139] Fix | Delete

}

[140] Fix | Delete

[141] Fix | Delete

}

[142] Fix | Delete

[143] Fix | Delete

new Save();

[144] Fix | Delete

[145] Fix | Delete