#k보드 #케이보드 #구글 시트 #구글 스프레드시트
// '세이브 시트'를 위한 함수
add_filter('cosmosfarm_save_sheet_append_fields_content', 'custom_cosmosfarm_save_sheet_append_fields_content', 11, 2);
function custom_cosmosfarm_save_sheet_append_fields_content($fields_content, $content){
global $wpdb;
$board = $content->getBoard();
$user_id = $content->member_uid;
$user_total_point = intval(mycred_get_users_balance($user_id));
$content_insert_point = intval($wpdb->get_var($wpdb->prepare("SELECT `value` FROM `{$wpdb->prefix}kboard_board_meta` WHERE `board_id`=%d AND `key`='document_insert_up_point'", $board->id)));
$total_point = $user_total_point + $content_insert_point;
if(!isset($fields_content['media'])){
$fields_content['media'] = '';
}
if(!isset($fields_content['date'])){
$fields_content['date'] = date('Y-m-d H:i:s', strtotime($content->date));
}
if($content_insert_point && !isset($fields_content['user_point'])){
$fields_content['user_point'] = $total_point;
}
return $fields_content;
}