|
@@ 1927-1996 (lines=70) @@
|
| 1924 |
|
* @since 2.0 |
| 1925 |
|
* @return void |
| 1926 |
|
*/ |
| 1927 |
|
function give_v20_move_metadata_into_new_table_callback() { |
| 1928 |
|
global $wpdb; |
| 1929 |
|
$give_updates = Give_Updates::get_instance(); |
| 1930 |
|
|
| 1931 |
|
// form query |
| 1932 |
|
$payments = new WP_Query( array( |
| 1933 |
|
'paged' => $give_updates->step, |
| 1934 |
|
'status' => 'any', |
| 1935 |
|
'order' => 'ASC', |
| 1936 |
|
'post_type' => array( 'give_forms', 'give_payment' ), |
| 1937 |
|
'posts_per_page' => 100, |
| 1938 |
|
) |
| 1939 |
|
); |
| 1940 |
|
|
| 1941 |
|
if ( $payments->have_posts() ) { |
| 1942 |
|
$give_updates->set_percentage( $payments->found_posts, $give_updates->step * 100 ); |
| 1943 |
|
|
| 1944 |
|
while ( $payments->have_posts() ) { |
| 1945 |
|
$payments->the_post(); |
| 1946 |
|
global $post; |
| 1947 |
|
|
| 1948 |
|
$meta_data = $wpdb->get_results( |
| 1949 |
|
$wpdb->prepare( |
| 1950 |
|
"SELECT * FROM $wpdb->postmeta where post_id=%d", |
| 1951 |
|
get_the_ID() |
| 1952 |
|
), |
| 1953 |
|
ARRAY_A |
| 1954 |
|
); |
| 1955 |
|
|
| 1956 |
|
if ( ! empty( $meta_data ) ) { |
| 1957 |
|
foreach ( $meta_data as $index => $data ) { |
| 1958 |
|
// Check for duplicate meta values. |
| 1959 |
|
if( $result = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . ( 'give_forms' === $post->post_type ? $wpdb->formmeta : $wpdb->paymentmeta ) . " WHERE meta_id=%d", $data['meta_id'] ), ARRAY_A ) ) { |
| 1960 |
|
continue; |
| 1961 |
|
} |
| 1962 |
|
|
| 1963 |
|
switch ( $post->post_type ) { |
| 1964 |
|
case 'give_forms': |
| 1965 |
|
$data['form_id'] = $data['post_id']; |
| 1966 |
|
unset( $data['post_id'] ); |
| 1967 |
|
|
| 1968 |
|
Give()->form_meta->insert( $data ); |
| 1969 |
|
// @todo: delete form meta from post meta table after releases 2.0. |
| 1970 |
|
/*delete_post_meta( get_the_ID(), $data['meta_key'] );*/ |
| 1971 |
|
|
| 1972 |
|
break; |
| 1973 |
|
|
| 1974 |
|
case 'give_payment': |
| 1975 |
|
$data['payment_id'] = $data['post_id']; |
| 1976 |
|
unset( $data['post_id'] ); |
| 1977 |
|
|
| 1978 |
|
Give()->payment_meta->insert( $data ); |
| 1979 |
|
|
| 1980 |
|
// @todo: delete donation meta from post meta table after releases 2.0. |
| 1981 |
|
/*delete_post_meta( get_the_ID(), $data['meta_key'] );*/ |
| 1982 |
|
|
| 1983 |
|
break; |
| 1984 |
|
} |
| 1985 |
|
} |
| 1986 |
|
} |
| 1987 |
|
|
| 1988 |
|
}// End while(). |
| 1989 |
|
|
| 1990 |
|
wp_reset_postdata(); |
| 1991 |
|
} else { |
| 1992 |
|
// No more forms found, finish up. |
| 1993 |
|
give_set_upgrade_complete( 'v20_move_metadata_into_new_table' ); |
| 1994 |
|
} |
| 1995 |
|
|
| 1996 |
|
} |
| 1997 |
|
|
| 1998 |
|
/** |
| 1999 |
|
* Upgrade routine for splitting donor name into first name and last name. |
|
@@ 2293-2362 (lines=70) @@
|
| 2290 |
|
* @since 2.0.1 |
| 2291 |
|
* @return void |
| 2292 |
|
*/ |
| 2293 |
|
function give_v201_move_metadata_into_new_table_callback() { |
| 2294 |
|
global $wpdb; |
| 2295 |
|
$give_updates = Give_Updates::get_instance(); |
| 2296 |
|
|
| 2297 |
|
// form query |
| 2298 |
|
$payments = new WP_Query( array( |
| 2299 |
|
'paged' => $give_updates->step, |
| 2300 |
|
'status' => 'any', |
| 2301 |
|
'order' => 'ASC', |
| 2302 |
|
'post_type' => array( 'give_forms', 'give_payment' ), |
| 2303 |
|
'posts_per_page' => 100, |
| 2304 |
|
) |
| 2305 |
|
); |
| 2306 |
|
|
| 2307 |
|
if ( $payments->have_posts() ) { |
| 2308 |
|
$give_updates->set_percentage( $payments->found_posts, $give_updates->step * 100 ); |
| 2309 |
|
|
| 2310 |
|
while ( $payments->have_posts() ) { |
| 2311 |
|
$payments->the_post(); |
| 2312 |
|
global $post; |
| 2313 |
|
|
| 2314 |
|
$meta_data = $wpdb->get_results( |
| 2315 |
|
$wpdb->prepare( |
| 2316 |
|
"SELECT * FROM $wpdb->postmeta where post_id=%d", |
| 2317 |
|
get_the_ID() |
| 2318 |
|
), |
| 2319 |
|
ARRAY_A |
| 2320 |
|
); |
| 2321 |
|
|
| 2322 |
|
if ( ! empty( $meta_data ) ) { |
| 2323 |
|
foreach ( $meta_data as $index => $data ) { |
| 2324 |
|
// Check for duplicate meta values. |
| 2325 |
|
if( $result = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . ( 'give_forms' === $post->post_type ? $wpdb->formmeta : $wpdb->paymentmeta ) . " WHERE meta_id=%d", $data['meta_id'] ), ARRAY_A ) ) { |
| 2326 |
|
continue; |
| 2327 |
|
} |
| 2328 |
|
|
| 2329 |
|
switch ( $post->post_type ) { |
| 2330 |
|
case 'give_forms': |
| 2331 |
|
$data['form_id'] = $data['post_id']; |
| 2332 |
|
unset( $data['post_id'] ); |
| 2333 |
|
|
| 2334 |
|
Give()->form_meta->insert( $data ); |
| 2335 |
|
// @todo: delete form meta from post meta table after releases 2.0. |
| 2336 |
|
/*delete_post_meta( get_the_ID(), $data['meta_key'] );*/ |
| 2337 |
|
|
| 2338 |
|
break; |
| 2339 |
|
|
| 2340 |
|
case 'give_payment': |
| 2341 |
|
$data['payment_id'] = $data['post_id']; |
| 2342 |
|
unset( $data['post_id'] ); |
| 2343 |
|
|
| 2344 |
|
Give()->payment_meta->insert( $data ); |
| 2345 |
|
|
| 2346 |
|
// @todo: delete donation meta from post meta table after releases 2.0. |
| 2347 |
|
/*delete_post_meta( get_the_ID(), $data['meta_key'] );*/ |
| 2348 |
|
|
| 2349 |
|
break; |
| 2350 |
|
} |
| 2351 |
|
} |
| 2352 |
|
} |
| 2353 |
|
|
| 2354 |
|
}// End while(). |
| 2355 |
|
|
| 2356 |
|
wp_reset_postdata(); |
| 2357 |
|
} else { |
| 2358 |
|
// No more forms found, finish up. |
| 2359 |
|
give_set_upgrade_complete( 'v201_move_metadata_into_new_table' ); |
| 2360 |
|
} |
| 2361 |
|
|
| 2362 |
|
} |
| 2363 |
|
|
| 2364 |
|
/** |
| 2365 |
|
* Move data to new log table. |
WordImpress /
Give
