WordPress.org
Get WordPress

Plugin Directory

Changeset 2722487


Ignore:
Timestamp:
05/12/2022 08:29:05 AM (4 years ago)
Author:
50storm
Message:

ver. 1.0.0 release.

Location:
my-affirmation
Files:
3 edited
7 copied

Legend:

Unmodified
Added
Removed

  • my-affirmation/tags/1.0.0/trunk/inc/model.php

    r2722397 r2722487  
    44
    55/**
    6  * Affimation class
     6 * Affirmation class
    77 */
    8 class Affimation
     8class Affirmation
    99{
    1010    /**
    … …  
    1212     */
    1313    public const AFFIRMATION_TABLE_NAME = 'affirmations';
    14 
    15     /**
    16      * activate_create_table function
    17      *
    18      * @return (int|false)
    19      */
    20     public static function activate_create_table()
    21     {
    22         global $wpdb;
    23         $charset_collate = $wpdb->get_charset_collate();
    24         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
    25         $sql = "CREATE TABLE $table_name (
    26                 id int(9) NOT NULL AUTO_INCREMENT,
    27                 affirmation varchar(255) NOT NULL DEFAULT '',
    28                 UNIQUE KEY id (id)
    29                ) $charset_collate;";
    30         //sqlを実行
    31         require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    32         dbDelta($sql);
    33         // 初期データ
    34         $wpdb->query("DELETE FROM $table_name");
    35 
    36         $wpdb->insert(
    37             $table_name,
    38             array(
    39           'id' => 1,
    40           'affirmation' => 'アファメーションの例文です。'
    41         ),
    42             array(
    43           '%s',
    44           '%s'
    45         )
    46         );
    47     }
    4814
    4915    /**
    … …  
    5622    {
    5723        global $wpdb;
    58         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     24        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    5925        $wpdb->insert(
    6026            $table_name,
    … …  
    7743    {
    7844        global $wpdb;
    79         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     45        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    8046        $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY RAND() LIMIT 1", ARRAY_A);
    8147        return $results;
    … …  
    9157    {
    9258        global $wpdb;
    93         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     59        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    9460        $results = $wpdb->get_results(
    9561            $wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $id),
    … …  
    10773    {
    10874        global $wpdb;
    109         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     75        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    11076        $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY id", ARRAY_A);
    11177        return $results;
    … …  
    12187    {
    12288        global $wpdb;
    123         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     89        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    12490        return $wpdb->update(
    12591            $table_name,
    … …  
    144110    {
    145111        global $wpdb;
    146         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     112        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    147113        return $wpdb->delete($table_name, array( 'id' => $id ), array( '%d' ));
    148114    }

  • my-affirmation/tags/1.0.0/trunk/my-affirmation.php

    r2722397 r2722487  
    2424// use MyAffirmationUtility\Debug;
    2525use MyAffirmationUtility\Validator;
    26 use MyAffirmationModel\Affimation;
     26use MyAffirmationModel\Affirmation;
    2727
    2828function my_affirmation_enqueue_styles()
    … …  
    5353add_action('plugins_loaded', 'my_affirmation_load_plugin_textdomain');
    5454
    55 register_activation_hook(__FILE__, array('Affimation', 'activate_create_table'));
     55/**
     56* activate_create_table function
     57*
     58* @return (int|false)
     59*/
     60function my_affirmation_activate_create_table()
     61{       
     62  global $wpdb;
     63  $charset_collate = $wpdb->get_charset_collate();
     64  $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
     65  $sql = "CREATE TABLE $table_name (
     66                id int(9) NOT NULL AUTO_INCREMENT,
     67                affirmation varchar(255) NOT NULL DEFAULT '',
     68                UNIQUE KEY id (id)
     69               ) $charset_collate;";
     70  //sqlを実行
     71  require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
     72  dbDelta($sql);
     73}
     74register_activation_hook(__FILE__, 'my_affirmation_activate_create_table');
    5675
    5776/**
    … …  
    7897function show_affirmation_admin_notice()
    7998{
    80   $my_affirmation = Affimation::select_one_affirmation_randomly();
     99  $my_affirmation = Affirmation::select_one_affirmation_randomly();
    81100  if (!empty($my_affirmation)) {
    82101    show_one_affirmation($my_affirmation[0]['affirmation']);
    … …  
    159178            return false;
    160179        }
    161         $record_affirmation = Affimation::select_one_affirmation_by_id($_GET['id']);
     180        $record_affirmation = Affirmation::select_one_affirmation_by_id($_GET['id']);
    162181        $affirmation = $record_affirmation['affirmation'];
    163182        // 編集・削除用のID
    … …  
    187206            $update_data['id'] = $sanitized_id;
    188207            $update_data['affirmation'] = $sanitized_affirmation;
    189             $updated_id = Affimation::update($update_data);
     208            $updated_id = Affirmation::update($update_data);
    190209            $affirmation_updated = true;
    191210            $message = "修正しました！";
    … …  
    215234            }
    216235            // execute deleting data
    217             Affimation::delete($sanitized_id);
     236            Affirmation::delete($sanitized_id);
    218237            $affirmation_deleted = true;
    219238            $message = "削除しました！";
    … …  
    250269
    251270        if (isset($_POST['affirmation']) && check_admin_referer('my_affirmation_options', 'my_affirmation_options_nonce')) {
    252             $insert_id = Affimation::insert_affirmation($sanitized_affirmation);
     271            $insert_id = Affirmation::insert_affirmation($sanitized_affirmation);
    253272            $affirmation_saved = true;
    254273            $affirmation = $sanitized_affirmation;
    … …  
    268287    }
    269288    // 毎回登録データ全て取得
    270     $affirmations = Affimation::select_all(); ?>
     289    $affirmations = Affirmation::select_all(); ?>
    271290 <div class="affirmation-input-are">
    272291   <div class="header">

  • my-affirmation/trunk/inc/model.php

    r2722397 r2722487  
    44
    55/**
    6  * Affimation class
     6 * Affirmation class
    77 */
    8 class Affimation
     8class Affirmation
    99{
    1010    /**
    … …  
    1212     */
    1313    public const AFFIRMATION_TABLE_NAME = 'affirmations';
    14 
    15     /**
    16      * activate_create_table function
    17      *
    18      * @return (int|false)
    19      */
    20     public static function activate_create_table()
    21     {
    22         global $wpdb;
    23         $charset_collate = $wpdb->get_charset_collate();
    24         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
    25         $sql = "CREATE TABLE $table_name (
    26                 id int(9) NOT NULL AUTO_INCREMENT,
    27                 affirmation varchar(255) NOT NULL DEFAULT '',
    28                 UNIQUE KEY id (id)
    29                ) $charset_collate;";
    30         //sqlを実行
    31         require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    32         dbDelta($sql);
    33         // 初期データ
    34         $wpdb->query("DELETE FROM $table_name");
    35 
    36         $wpdb->insert(
    37             $table_name,
    38             array(
    39           'id' => 1,
    40           'affirmation' => 'アファメーションの例文です。'
    41         ),
    42             array(
    43           '%s',
    44           '%s'
    45         )
    46         );
    47     }
    4814
    4915    /**
    … …  
    5622    {
    5723        global $wpdb;
    58         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     24        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    5925        $wpdb->insert(
    6026            $table_name,
    … …  
    7743    {
    7844        global $wpdb;
    79         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     45        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    8046        $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY RAND() LIMIT 1", ARRAY_A);
    8147        return $results;
    … …  
    9157    {
    9258        global $wpdb;
    93         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     59        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    9460        $results = $wpdb->get_results(
    9561            $wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $id),
    … …  
    10773    {
    10874        global $wpdb;
    109         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     75        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    11076        $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY id", ARRAY_A);
    11177        return $results;
    … …  
    12187    {
    12288        global $wpdb;
    123         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     89        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    12490        return $wpdb->update(
    12591            $table_name,
    … …  
    144110    {
    145111        global $wpdb;
    146         $table_name = $wpdb->prefix . Affimation::AFFIRMATION_TABLE_NAME;
     112        $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
    147113        return $wpdb->delete($table_name, array( 'id' => $id ), array( '%d' ));
    148114    }

  • my-affirmation/trunk/my-affirmation.php

    r2722397 r2722487  
    2424// use MyAffirmationUtility\Debug;
    2525use MyAffirmationUtility\Validator;
    26 use MyAffirmationModel\Affimation;
     26use MyAffirmationModel\Affirmation;
    2727
    2828function my_affirmation_enqueue_styles()
    … …  
    5353add_action('plugins_loaded', 'my_affirmation_load_plugin_textdomain');
    5454
    55 register_activation_hook(__FILE__, array('Affimation', 'activate_create_table'));
     55/**
     56* activate_create_table function
     57*
     58* @return (int|false)
     59*/
     60function my_affirmation_activate_create_table()
     61{       
     62  global $wpdb;
     63  $charset_collate = $wpdb->get_charset_collate();
     64  $table_name = $wpdb->prefix . Affirmation::AFFIRMATION_TABLE_NAME;
     65  $sql = "CREATE TABLE $table_name (
     66                id int(9) NOT NULL AUTO_INCREMENT,
     67                affirmation varchar(255) NOT NULL DEFAULT '',
     68                UNIQUE KEY id (id)
     69               ) $charset_collate;";
     70  //sqlを実行
     71  require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
     72  dbDelta($sql);
     73}
     74register_activation_hook(__FILE__, 'my_affirmation_activate_create_table');
    5675
    5776/**
    … …  
    7897function show_affirmation_admin_notice()
    7998{
    80   $my_affirmation = Affimation::select_one_affirmation_randomly();
     99  $my_affirmation = Affirmation::select_one_affirmation_randomly();
    81100  if (!empty($my_affirmation)) {
    82101    show_one_affirmation($my_affirmation[0]['affirmation']);
    … …  
    159178            return false;
    160179        }
    161         $record_affirmation = Affimation::select_one_affirmation_by_id($_GET['id']);
     180        $record_affirmation = Affirmation::select_one_affirmation_by_id($_GET['id']);
    162181        $affirmation = $record_affirmation['affirmation'];
    163182        // 編集・削除用のID
    … …  
    187206            $update_data['id'] = $sanitized_id;
    188207            $update_data['affirmation'] = $sanitized_affirmation;
    189             $updated_id = Affimation::update($update_data);
     208            $updated_id = Affirmation::update($update_data);
    190209            $affirmation_updated = true;
    191210            $message = "修正しました！";
    … …  
    215234            }
    216235            // execute deleting data
    217             Affimation::delete($sanitized_id);
     236            Affirmation::delete($sanitized_id);
    218237            $affirmation_deleted = true;
    219238            $message = "削除しました！";
    … …  
    250269
    251270        if (isset($_POST['affirmation']) && check_admin_referer('my_affirmation_options', 'my_affirmation_options_nonce')) {
    252             $insert_id = Affimation::insert_affirmation($sanitized_affirmation);
     271            $insert_id = Affirmation::insert_affirmation($sanitized_affirmation);
    253272            $affirmation_saved = true;
    254273            $affirmation = $sanitized_affirmation;
    … …  
    268287    }
    269288    // 毎回登録データ全て取得
    270     $affirmations = Affimation::select_all(); ?>
     289    $affirmations = Affirmation::select_all(); ?>
    271290 <div class="affirmation-input-are">
    272291   <div class="header">
Note: See TracChangeset for help on using the changeset viewer.