{"id":73830,"date":"2024-09-12T15:31:54","date_gmt":"2024-09-12T13:31:54","guid":{"rendered":"https:\/\/pl.wordpress.org\/support\/topic\/zmiana-tabeli-pobierania-i-zapisywania-customowych-postow\/"},"modified":"2024-09-12T15:31:54","modified_gmt":"2024-09-12T13:31:54","slug":"zmiana-tabeli-pobierania-i-zapisywania-customowych-postow","status":"publish","type":"topic","link":"https:\/\/pl.wordpress.org\/support\/topic\/zmiana-tabeli-pobierania-i-zapisywania-customowych-postow\/","title":{"rendered":"Zmiana tabeli pobierania i zapisywania customowych post\u00f3w"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Cze\u015b\u0107,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Chcia\u0142bym wordpresie we w\u0142asnym typie post\u00f3w podmieni\u0107 tabel\u0119 pobierania danych z&nbsp;<code>wp_posts<\/code>&nbsp;na&nbsp;<code>wp_moja_wlasna<\/code>&nbsp;tabele.<br \/>Przejrza\u0142em Internet w zad\u0142u\u017c i szerz, genialne chat boty te\u017c nie wiedz\u0105 jak zrobi\u0107.<br \/>odpowiednikiem jest np. tabela&nbsp;<code>wc_orders<\/code>&nbsp;i zapis zam\u00f3wie\u0144 w woocomerca<br \/>Pr\u00f3bowa\u0142em to robi\u0107 za pomoc\u0105:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>public function __construct() {\n    add_filter( 'manage_edit-joboffers_candidates_columns', array( $this, 'modify_job_offer_candidates_columns' );\n    add_action( 'manage_joboffers_candidates_posts_custom_column', array( $this, 'display_job_offer_candidates_data', 10, 2 );\n}\n\nfunction modify_job_offer_candidates_columns( $columns ) {\n    \/\/ Usuwamy domy\u015blne kolumny\n    unset( $columns&#091;'title'] );\n    unset( $columns&#091;'date'] );\n\n    \/\/ Dodajemy nowe kolumny\n    $columns&#091;'id'] = __( 'ID', 'job-offers-plugin' );\n    $columns&#091;'create_data'] = __( 'Data utworzenia', 'job-offers-plugin' );\n    $columns&#091;'name'] = __( 'Imi\u0119', 'job-offers-plugin' );\n    $columns&#091;'surname'] = __( 'Nazwisko', 'job-offers-plugin' );\n    $columns&#091;'phone'] = __( 'Telefon', 'job-offers-plugin' );\n    $columns&#091;'email'] = __( 'Email', 'job-offers-plugin' );\n    $columns&#091;'status'] = __( 'Status', 'job-offers-plugin' );\n\n    return $columns;\n}\nfunction display_job_offer_candidates_data( $column, $post_id ) {\n    global $wpdb;\n\n    \/\/ Zapytanie SQL do pobrania danych z tabeli wp_st_candidate_applications\n    $sql = \"SELECT <code>id<\/code>, <code>create_data<\/code>, <code>name<\/code>, <code>surname<\/code>, <code>phone<\/code>, <code>email<\/code>, <code>status<\/code> \n            FROM <code>wp_mojatabela<\/code> \n            WHERE <code>post_id<\/code> = %d\"; \n\n    $results = $wpdb-&gt;get_results( $wpdb-&gt;prepare( $sql, $post_id ) );\n\n    if ( ! empty( $results ) ) {\n        $candidate_data = $results&#091;0]; \/\/ Pobieramy pierwszy wynik (zak\u0142adamy, \u017ce jest tylko jeden kandydat na ofert\u0119)\n\n        switch ( $column ) {\n            case 'id':\n                echo $candidate_data-&gt;id;\n                break;\n            case 'create_data':\n                echo $candidate_data-&gt;create_data;\n                break;\n            case 'name':\n                echo $candidate_data-&gt;name;\n                break;\n            case 'surname':\n                echo $candidate_data-&gt;surname;\n                break;\n            case 'phone':\n                echo $candidate_data-&gt;phone;\n                break;\n            case 'email':\n                echo $candidate_data-&gt;email;\n                break;\n            case 'status':\n                echo $candidate_data-&gt;status;\n                break;\n        }\n    } else {\n        echo '-'; \/\/ Wy\u015bwietlamy \"-\" je\u015bli nie ma danych dla danego postu\n    }\n}<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-73830","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/73830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/73830\/revisions"}],"wp:attachment":[{"href":"https:\/\/pl.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=73830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}