', strip_tags($ary_acquire_info_json['t']));
}
$acquire_info_json = json_encode($ary_acquire_info_json, JSON_UNESCAPED_UNICODE);
$ip = $_SERVER['REMOTE_ADDR'] ?? '';
$ua = $_SERVER['HTTP_USER_AGENT'] ?? '';
$ret = $wpdb->insert(self::TBL_ENTERPRISE_ACQUIRE
, ['acquire_info_json'=>$acquire_info_json, 'sent'=>0, 'datetime'=>$now,'ip'=>$ip,'ua'=>$ua]);
return $ret;
}
public static function fetch($id)
{
global$wpdb;
$row = $wpdb->get_row('SELECT * FROM '.self::TBL_ENTERPRISE_ACQUIRE.' WHERE id='.$id);
return $row;
}
public static function fetchTop5RowsWhichNeverSent()
{
return self::fetchBySent(0,5);
}
private static function fetchBySent($sent,$limit)
{
global$wpdb;
$row = $wpdb->get_results('SELECT * FROM '.self::TBL_ENTERPRISE_ACQUIRE.' WHERE sent='.$sent.' ORDER BY `datetime` ASC LIMIT '.$limit);
return $row;
}
public static function updateSent($id)
{
global$wpdb;
return $wpdb->update(self::TBL_ENTERPRISE_ACQUIRE,
['sent'=>1],
['id'=>$id]);
}
public static function postToSheet(){
require_once $_SERVER['DOCUMENT_ROOT'].'/google_apiclient/GoogleSheetsAssistant.php';
$spreadsheetId = '1pnnP96lXXs_Q3jgWf4Ye697CquSKdzlbPEhtfm-Igb4';
$assistant = new GoogleSheetsAssistant($service_account_key,$spreadsheetId);
$name = $_POST['name'] ?? '';
$call = $_POST['call'] ?? '';
$company = $_POST['company'] ?? '';
$job = $_POST['job'] ?? '';
$phone = $_POST['phone'] ?? '';
$email = $_POST['email'] ?? '';
$text = $_POST['asktext'] ?? '';
$listed_company = $_POST['listed_company'] ?? '';
$requirement = $_POST['requirement'] ?? '';
$number_of_trainees = $_POST['number_of_trainees'] ?? '';
$budget_allocation = $_POST['budget_allocation'] ?? '';
$industrial_classification = $_POST['industrial_classification'] ?? '';
$values=[
[
date("Y/m/d"),
$company,
$name,
$call,
$job,
$phone,
$email,
$listed_company,
$requirement,
$number_of_trainees,
$budget_allocation,
$industrial_classification,
$text,
]
];
try {
//find first empty
$emptyRow = $assistant->findFirstEmptyRow("企業專區詢問!A:B");
// echo "第一個空白列 Row Index:" .$emptyRow;
// echo "
";
//write data
$R = $emptyRow;
$range = "企業專區詢問!A$R:M$R";
// $values = [["Data 1", "Data 2", "Data 3", "Data 4"]];
$result = $assistant->writeData($range, $values);
// echo "寫入格數" .$result;
// echo "
";
}catch (Exception $e) {
}
}
}