'name' => 'ignorelimit', // 'value' => 1, // 'checked' => 'checked' // ), // ); $form['export'] = array( '#type' => 'submit', '#value' => t('Export'), '#attributes' => array('class' => array('btn','btn-primary','float-left','pb-1')) ); // end of form builder $output = array( 'form' => $form, // 'table' => $table, 'date_recieved1' => $date_recieved1, // 'date_recieved2' => $date_recieved2, 'print_com_date_from' => $print_com_date_from, 'print_exp_date_to' => $print_exp_date_to, 'digital_com_date_from' => $digital_com_date_from, 'digital_exp_date_to' => $digital_exp_date_to, 'order_print_com_date_from' => $order_print_com_date_from, 'order_print_exp_date_to' => $order_print_exp_date_to, 'order_digital_com_date_from' => $order_digital_com_date_from, 'order_digital_exp_date_to' => $order_digital_exp_date_to, 'data_offset_container' => $data_offset_container, 'script' => $script // 'nav' => $nav_btn ); return $output; } } /** * Export the data to stripe via a background process. * * @return array An array containing the markup for a message to confirm the request has been submitted. */ function drupal_report_stripe_export_callback(){ global $user; if (!array_intersect(['Reports', 'tes-drupal-report'], $user->roles)) { header('Location: '.$GLOBALS['base_url']); } else { //Use for background process $base_url = $GLOBALS['base_url'].'/'.$_GET['q'].'?'; $export_url = $GLOBALS['base_url'].'/'.$_GET['q'].'/export?'; $q_url = ''; $offset = isset($_GET['offset']) && $_GET['offset'] != "" ? $_GET['offset'] : 0 ; $limit = isset($_GET['limit']) && $_GET['limit'] != "" ? $_GET['limit'] : 7000 ; $page = $_GET['page']; // $ignorelimit = $_GET["ignorelimit"]; $ignorelimit = 1; $data_collection = $_GET['data_collection']; $op = $_GET['op']; $os1 = $_GET['os1']; $os2 = $_GET['os2']; $os3 = $_GET['os3']; $os4 = $_GET['os4']; $os5 = $_GET['os5']; $os6 = $_GET['os6']; $os7 = $_GET['os7']; $os8 = $_GET['os8']; $os9 = $_GET['os9']; $os10 = $_GET['os10']; $os11 = $_GET['os11']; $os12 = $_GET['os12']; $os13 = $_GET['os13']; $os14 = $_GET['os14']; $os15 = $_GET['os15']; $os16 = $_GET['os16']; $os17 = $_GET['os17']; $os18 = $_GET['os18']; $uid = $_GET['uid']; $oid = $_GET['oid']; $nid = $_GET['nid']; $status = $_GET['status']; $dr1 = $_GET['dr1']; $pcdf = $_GET['pcdf']; $dcdf = $_GET['dcdf']; $pedt = $_GET['pedt']; $dedt = $_GET['dedt']; $email = $_GET['email']; $pt1 = $_GET['pt1']; $pt2 = $_GET['pt2']; $pt3 = $_GET['pt3']; $opcdf = $_GET['opcdf']; $opedt = $_GET['opedt']; $odcdf = $_GET['odcdf']; $odedt = $_GET['odedt']; $sap = $_GET['sap']; $key_param = array( "base_url" => $base_url, "export_url" => $export_url, "q_url" => $q_url, "offset" => $offset, "limit" => $limit, "page" => $page, "ignorelimit" => $ignorelimit, "data_collection" => $data_collection , "op" => $op, "os1" => $os1, "os2" => $os2, "os3" => $os3, "os4" => $os4, "os5" => $os5, "os6" => $os6, "os7" => $os7, "os8" => $os8, "os9" => $os9, "os10" => $os10, "os11" => $os11, "os12" => $os12, "os13" => $os13, "os14" => $os14, "os15" => $os15, "os16" => $os16, "os17" => $os17, "os18" => $os18, "uid" => $uid , "oid" => $oid , "nid" => $nid , "status" => $status, "dr1" => $dr1, "pcdf" => $pcdf, "dcdf" => $dcdf , "pedt" => $pedt , "dedt" => $dedt , "email" => $email, "pt1" => $pt1, "pt2" => $pt2, "pt3" => $pt3, "opcdf" => $opcdf, "opedt" => $opedt, "odcdf" => $odcdf, "odedt" => $odedt, "sap" => $sap, ); background_process_start("stripe_export_process",$user->mail,$key_param); // stripe_export_process($user->mail,$key_param); // END // stripe_export_process($user->mail, $key_param); $form['import_view'] = array( '#markup' => "

Your request has been submitted. Please wait while your report orders are being processed to send at your email.

" ); $output = array( 'import_view' => $form ); return $output; } } /** * This function is used to send export files to email * * @request TWS-1633 https://edgeprop.atlassian.net/browse/TWS-1633 * * @return '' Send the email */ function stripe_export_process($mail_to, $key_param, $type = 'drupal_report'){ // Construct the email parameters. $params = array( 'attachments' => array(), 'key_param' => $key_param, ); // Set the email recipient. $to = $mail_to; $type = 'email_with_attachment_' . $type; // Send the email. // drupal_mail('stripe_subscription', $type, $to, language_default(), $params); drupal_report_api_background($params["key_param"]); } /** * This function is hook from drupal_mail() to prepare a message based on parameters and attach files to email * * @request TWS-1633 https://edgeprop.atlassian.net/browse/TWS-1633 * * @param string $key - the email key * @param array $message - the email message content * @param array $params - the email parameters * @return void */ function stripe_subscription_mail($key, &$message, $params) { switch ($key) { case 'email_with_attachment_drupal_report': // Load the necessary Drupal core files for email attachments. module_load_include('inc', 'system', 'system.mail'); module_load_include('module', 'phpmailer'); // Get the modified parameter from $params. $modif_param = $params["key_param"]; // Construct the email parameters. $params = array( 'attachments' => array(), ); $current_date = date('Y-m-d\TH_i_s.u\Z'); $report_name = 'Export Report ' . $current_date; $message['subject'] = $report_name; $message['body'][] = 'Hello,'; // Generate the CSV content. $csv_content = drupal_report_api_background($modif_param); // Save the CSV content to a temporary file. $csv_file = file_directory_temp() . '/' . $report_name . '.csv'; file_put_contents($csv_file, $csv_content); // Get the file size. $filesize = filesize($csv_file); // Upload the CSV file to S3 - TWS-2556 watchdog("export_new_drupal_report", "Start preparing S3 upload", array()); $fp = fopen($csv_file, 'rb'); $binary = fread($fp, $filesize); fclose($fp); $s3_directory = "s3://new_drupal_report/"; $s3_file_path = $s3_directory . $report_name . ".csv"; if (file_prepare_directory($s3_directory, FILE_CREATE_DIRECTORY)) { // Upload the csv file to S3 $file = file_save_data($binary, $s3_file_path, FILE_EXISTS_REPLACE); if ($file) { watchdog("upload_to_s3", "File uploaded to S3 successfully", array()); $s3_url = file_create_url($s3_file_path); if ($filesize > 25 * 1024 * 1024) { // Check if file size is more than 25 MB // Update the email body with the S3 link and remove file attachment $message['body'][] = 'The file size is more than 25 MB, and it cannot be attached directly to the email. Please download the file by clicking the link below:'; $message['body'][] = $s3_url; } else { // Use the default body and attach the file, if the file size is less than 25 MB $message['body'][] = 'Please find the attached file.'; // Add the CSV file as an attachment. $message['params']['attachments'][] = array( 'filepath' => $csv_file, 'filemime' => 'text/csv', ); } } else { watchdog("upload_to_s3", "Failed to upload file to S3", array(), WATCHDOG_ERROR); } } else { watchdog("export_new_drupal_report", "Failed to prepare directory: " . $s3_directory, array(), WATCHDOG_ERROR); } break; case 'email_with_attachment_stripe_order': // Load the necessary Drupal core files for email attachments. module_load_include('inc', 'system', 'system.mail'); module_load_include('module', 'phpmailer'); $modif_param = $params["key_param"]; // Construct the email parameters. $params = array( 'attachments' => array(), ); $current_date = date('Y-m-d\TH_i_s.u\Z'); $report_name = 'Export Stripe Order ' . $current_date; $message['subject'] = $report_name; $message['body'][] = 'Hello,'; $message['body'][] = 'Please find the attached file.'; // Add the attachment to the email. // Generate the Excel content. $excel_content = cms_stripe_order_api_background($modif_param); // Save the Excel content to a temporary file. $excel_file = file_directory_temp() . '/'.$report_name.'.xls'; file_put_contents($excel_file, $excel_content); // Add the Excel file as an attachment. $message['params']['attachments'][] = array( 'filepath' => $excel_file, 'filemime' => 'text/xls', ); break; } } /** * Generates a CSV report for Drupal API in the background. * * @param array $array_param Associative array containing parameters: * - q_url: URL to query * - offset: Offset of the query * - limit: Limit of the query * - ignorelimit: Flag to ignore the limit * @throws None * @return None */ function drupal_report_api_background($array_param) { $q_url = $array_param["q_url"]; db_query("SET time_zone = 'Asia/Singapore';"); $sql = get_query_drupal_report_v2(true,$array_param); // $sql .= " ORDER BY odr.created desc "; $offset = $array_param["offset"] ; $limit = $array_param["limit"] ; $loop_limit = 3000 ; $loop_arr = $limit > $loop_limit ? intval($limit/$loop_limit) : 1; $loop_mod = $limit > $loop_limit ? $limit % $loop_limit : 0; $loop_limit = ($limit < $loop_limit) ? $limit : $loop_limit; // $sql .= "LIMIT " . $offset . ", " . $limit; if(isset($array_param["limit"]) && $array_param["limit"] != ''){ $get_count++; } if($get_count>0){ if(isset($array_param["limit"]) && $array_param["limit"] != ''){ $q_url .= 'limit='.$array_param["limit"].'&'; } if(isset($array_param["page"]) && $array_param["page"] != ''){ $q_url .= 'page='.$array_param["page"].'&'; } // echo "

";
        // print_r($sql_all);
        // echo "

"; // exit; $users = []; $created = ""; if($array_param["ignorelimit"]) $loop_arr = 0; for ($x = 0; $x <= $loop_arr; $x++) { $for_offset = ($x * $loop_limit) + $offset; $for_limit = ($loop_arr == $x) ? $loop_mod : $loop_limit; $orderby = " ORDER BY created desc "; $filterid = ""; if($offset == 0) { if($created != "") $filterid = " AND created < " . $created . " "; $loop_sql = " LIMIT " . $for_limit; }else{ $sql_join = $sql . $filterid . $orderby . " LIMIT " . $for_offset . ", 1"; $get_created = db_query($sql_join)->fetchAll(); if(count($get_created) == 0){ echo ''; exit(); } $created = $get_created[count($get_created)-1]->created; $filterid = " AND odr.created <= " . $created . " "; $loop_sql = " LIMIT " . $for_limit; } if($array_param["ignorelimit"]) $loop_sql = ""; $recurring_payment_status_sql = ""; if($array_param["data_collection"] == "google_order" || $array_param["data_collection"] == "apple_order"){ $recurring_payment_status_sql = " ( main.recurring_payment_status ) AS recurring_payment_status, "; } else if ($array_param["data_collection"] == "paypal_order" || $array_param["data_collection"] == "stripe_order") { $recurring_payment_status_sql = " ( CASE WHEN main.data_collection = 'paypal_order' THEN CASE WHEN pr.recurring_payment_status IS NULL THEN CASE WHEN po.paypal_original_recurring_status IS NULL THEN NULL ELSE po.paypal_original_recurring_status END ELSE pr.recurring_payment_status END WHEN main.data_collection = 'stripe_order' THEN CASE WHEN sr.recurring_payment_status IS NULL THEN CASE WHEN so.stripe_original_recurring_status IS NULL THEN NULL ELSE so.stripe_original_recurring_status END ELSE sr.recurring_payment_status END ELSE NULL END ) AS recurring_payment_status, "; } else { $recurring_payment_status_sql = " ( CASE WHEN main.data_collection = 'paypal_order' THEN CASE WHEN pr.recurring_payment_status IS NULL THEN CASE WHEN po.paypal_original_recurring_status IS NULL THEN NULL ELSE po.paypal_original_recurring_status END ELSE pr.recurring_payment_status END WHEN main.data_collection = 'stripe_order' THEN CASE WHEN sr.recurring_payment_status IS NULL THEN CASE WHEN so.stripe_original_recurring_status IS NULL THEN NULL ELSE so.stripe_original_recurring_status END ELSE sr.recurring_payment_status END WHEN main.data_collection = 'google_order' OR main.data_collection = 'apple_order' THEN main.recurring_payment_status ELSE NULL END ) AS recurring_payment_status, "; } $sql_all = "SELECT main.sub_no, main.data_collection, main.created, main.date_recieved, main.current_digital_expiry, main.current_print_expiry, main.uid, main.email, main.delivery_first_name, main.delivery_last_name, main.country_code_ship, main.delivery_phone, main.delivery_company, main.delivery_address_1, main.delivery_address_2, main.delivery_postal_code, main.delivery_city, main.delivery_zone, main.delivery_country, main.delivery_route_code, main.billing_first_name, main.billing_last_name, main.country_code_bill, main.billing_phone, main.billing_company, main.billing_address_1, main.billing_address_2, main.billing_postal_code, main.billing_city, main.billing_zone, main.billing_country, main.billing_route_code, main.digital_commencement_date, main.digital_expiry_date, main.print_commencement_date, main.print_expiry_date, main.payment_method, main.other_payment_method, main.product, main.number_of_issues, main.product_model, main.product_type, main.sku_product_type, main.quantity, main.gift, main.amount_with_gst, main.amount_without_gst, main.gst_amount, main.remarks, main.subscription_status, main.imported_record, main.payment_date, ". $recurring_payment_status_sql ." rt.field_renewal_type_value AS 'renewal_type', fped.field_print_expiry_duration_value AS 'print_expiry_duration', fded.field_digital_expiry_duration_value AS 'digital_expiry_duration' from (". $sql . $filterid . $orderby . $loop_sql ." ) main LEFT JOIN ( select distinct u.uid, r.order_id, r.status as recurring_payment_status from users u join uc_recurring_users r on u.uid = r.uid where u.uid != 0 order by uid ) pr on main.sub_no=pr.order_id LEFT JOIN ( select distinct u.uid, r.order_id, r.status as recurring_payment_status from users u join stripe_recurring_users r on u.uid = r.uid where u.uid != 0 order by uid ) sr on main.sub_no=sr.order_id LEFT JOIN ( SELECT uro.renewal_order_id, r.uid, r.status AS 'paypal_original_recurring_status' FROM uc_recurring_orders uro JOIN uc_recurring_users r ON uro.original_order_id = r.order_id LIMIT 400000 ) po ON main.sub_no = po.renewal_order_id AND main.uid = po.uid LEFT JOIN ( SELECT sro.renewal_order_id, r.uid, r.status AS 'stripe_original_recurring_status' FROM stripe_recurring_orders sro JOIN stripe_recurring_users r ON sro.original_order_id = r.order_id ) so ON main.sub_no = so.renewal_order_id AND main.uid = so.uid left JOIN (select * from ( select * from profile ) p where changed = (SELECT MAX(changed) from profile where uid = p.uid) group by uid) p ON main.uid = p.uid LEFT JOIN field_data_field_renewal_type rt ON p.pid = rt.entity_id LEFT JOIN field_data_field_print_expiry_duration fped ON p.pid = fped.entity_id LEFT JOIN field_data_field_digital_expiry_duration fded ON p.pid = fded.entity_id -- Start of Exclude email testing list LEFT JOIN email_testing_list etl ON main.email = etl.email WHERE etl.email IS NULL -- End of Exclude email testing list ORDER BY main.created desc"; // echo '

';
            // print_r($sql_all);
            // echo '

'; // exit; if($for_limit > 0 || $array_param["ignorelimit"]) { $query = db_query($sql_all)->fetchAll(); return drupal_report_generate_csv($query); } } } } /** * This function is used to call function generate excel from list orders * * @request TWS-1633 https://edgeprop.atlassian.net/browse/TWS-1633 * * @param array $order { * It's an order array that includes multiple fields for order details * } * * @return object in xml */ function cms_stripe_order_api_background($array_param){ global $user; db_query("SET time_zone = 'Asia/Singapore';"); $sql = get_stripe_order_sql($array_param['start_date'],$array_param['end_date']); $sql .= " ORDER BY order_id DESC "; $data = db_query($sql)->fetchAll(); return cms_stripe_order_generate_excel($data,$array_param['export_date'], $user->name); // return stripe_order_generate_csv($data, $array_param['export_date'], $user->name); } /** * Generates a CSV data from the given orders array. * * @param array $order an array of orders * @throws * @return string a string containing the CSV data */ function drupal_report_generate_csv($order){ $data = []; $data[] = array( 'Sub No.', 'Data Collection', 'Date Recieved', 'Profile digital expiry', 'Profile Print Expiry', 'Uid', 'Email', 'Multiple Orders', 'Delivery First Name', 'Delivery Last Name', 'Compliment', 'Sub Code (Digital Only)', 'Delivery Country Code', 'Delivery Phone', 'HP', 'Delivery Company', 'Delivery Address 1', 'Delivery Address 2', 'Delivery Postal Code', 'Delivery City', 'Delivery State', 'Delivery Country', 'Delivery Route Code', 'Billing First Name', 'Billing Last Name', 'Billing Country Code', 'Billing Phone', 'Billing Company', 'Billing Address 1', 'Billing Address 2', 'Billing Postal Code', 'Billing City', 'Billing State', 'Billing Country', 'Billing Route Code', 'Order Digital Commencement Date', 'Order Digital Expiry Date', 'Order Print Commencement Date', 'Order Print Expiry Date', 'Payment Method', 'Product', 'Number of Issues', 'Product Model (SKU)', 'Product Type', 'Quantity', 'Gift', 'Amount (with GST)', 'Base Subs Rate', 'Amount (without GST)', 'GST Amount', 'Remarks', 'Order Status', 'Profile Subscription Status', 'Imported Record', 'Recurring Payment Status', 'Payment Date', 'Renewal Type' ); foreach ($order as $obj) { // Total order from email if(isset($order_sum_of_email[strtolower($obj->email)])){ if($order_sum_of_email[strtolower($obj->email)]>1){ $order_count = 'YES'; } else { $order_count = 'NO'; } // $order_count = $order_sum_of_email[strtolower($obj->email)]; } else { $order_count = 'NO'; } // Product type if($obj->product_type==null){ $obj->product_type = $obj->sku_product_type; unset($obj->sku_product_type); } // order status and subscription status $order_status = ""; if($obj->data_collection == 'google_order' || $obj->data_collection == 'apple_order'){ $order_status = $obj->subscription_status; } else { switch ($obj->subscription_status) { case 'Handled_by_human_autorenewal': $order_status = 'Updated - A'; break; case 'Handled_by_human': $order_status = 'Updated'; break; case 'completed': $order_status = 'Paid'; break; case 'payment_received': $order_status = 'Payment Recieved'; break; case 'free_order': $order_status = 'Free Order'; break; case 'payment_refunded': $order_status = 'Payment Refunded'; break; case 'updated': $order_status = 'Updated'; break; case 'paypal_pending': $order_status = 'Paypal Pending'; break; case 'processing': $order_status = 'Processing'; break; case 'pending': $order_status = 'Pending'; break; case 'in_checkout': $order_status = 'In Checkout'; break; case 'abandoned': $order_status = 'Abandoned'; break; case 'canceled': $order_status = 'Expired'; break; default: $order_status = ''; break; } } $dt = strtotime('today'); $ddet = 0; $pdet = 0; if($obj->current_digital_expiry!=null || $obj->current_digital_expiry!=''){ $ddet = strtotime($obj->current_digital_expiry); } if($obj->current_print_expiry!=null || $obj->current_print_expiry!=''){ $pdet = strtotime($obj->current_print_expiry); } if($pdet > $dt || $ddet > $dt){ $subscription_status = 'Active'; } else { $subscription_status = 'Expired'; } // recurring payment status $recurring_payment_status = ""; if($obj->data_collection == 'google_order' || $obj->data_collection == 'apple_order'){ $recurring_payment_status = $obj->recurring_payment_status; } else { if($obj->recurring_payment_status === '0') { $recurring_payment_status = 'Active'; } elseif($obj->recurring_payment_status === '1'){ $recurring_payment_status = 'Expired'; } elseif($obj->recurring_payment_status === '2'){ $recurring_payment_status = 'Cancelled'; } elseif($obj->recurring_payment_status === '3'){ $recurring_payment_status = 'Suspended'; } else { $renewal_id = $obj->sub_no; // $original = db_select('uc_recurring_orders','ro') // ->fields('ro',array('original_order_id')) // ->condition('renewal_order_id',$renewal_id,'=') // ->execute() // ->fetchAll(); if($obj->data_collection == 'paypal_order') { $original = db_select('uc_recurring_orders','ro') ->fields('ro',array('original_order_id')) ->condition('renewal_order_id',$renewal_id,'=') ->execute() ->fetchAll(); } else { $original = db_select('stripe_recurring_orders','ro') ->fields('ro',array('original_order_id')) ->condition('renewal_order_id',$renewal_id,'=') ->execute() ->fetchAll(); } if(!empty($original)){ $original_id = $original[0]->original_order_id; // $sql3 = 'SELECT `status` // FROM uc_recurring_users // WHERE order_id = '.$original_id.' AND order_product_id IS not NULL'; if($obj->data_collection == 'paypal_order') { $sql3 = "SELECT `status` FROM uc_recurring_users WHERE order_id = $original_id AND order_product_id IS not NULL"; } else { $sql3 = "SELECT `status` FROM stripe_recurring_users WHERE order_id = $original_id"; } $status = db_query($sql3)->fetchAll(); if(!empty($status)){ $status_id = $status[0]->status; if($status_id === '0') { $recurring_payment_status = 'Active'; } elseif($status_id === '1'){ $recurring_payment_status = 'Expired'; } elseif($status_id === '2'){ $recurring_payment_status = 'Cancelled'; } elseif($status_id === '3'){ $recurring_payment_status = 'Suspended'; } else { $recurring_payment_status = 'No Recurring'; } } else { $recurring_payment_status = 'No Recurring'; } } else { $recurring_payment_status = 'No Recurring'; } } } //numbers $amount_with_gst = number_format($obj->amount_with_gst, 2, '.', ','); $amount_without_gst = number_format($obj->amount_without_gst, 2, '.', ','); $gst_amount = number_format($obj->gst_amount, 2, '.', ','); //payment method if($obj->payment_method=='other_method'){ if($obj->other_payment_method != ''){ // mask card number $pattern = '/([A-z]+-)([0-9]+)/'; if (preg_match($pattern, $obj->other_payment_method, $m)) { $last4 = $m[1]."****".substr($m[2], -4); $obj->other_payment_method = $last4; } $payment_method = $obj->other_payment_method; } else { $payment_method = $obj->payment_method; } } else { $payment_method = $obj->payment_method; } //imported record if(stripos($obj->imported_record,'imported') !== false && stripos($obj->imported_record,'malaysia') !== false) { $imported_record = 'Imported from VNP Malaysia'; } elseif(stripos($obj->imported_record,'imported') !== false && stripos($obj->imported_record,'singapore') !== false){ $imported_record = 'Imported record'; } else { $imported_record = ''; } $data[] = array( $obj->sub_no, $obj->data_collection, $obj->date_recieved, $obj->current_digital_expiry, $obj->current_print_expiry, $obj->uid, $obj->email, $order_count, $obj->delivery_first_name, $obj->delivery_last_name,'','', $obj->country_code_ship, $obj->delivery_phone,'', $obj->delivery_company, $obj->delivery_address_1, $obj->delivery_address_2, '=TEXT("' . $obj->delivery_postal_code . '","000000")', // Create the CSV row with the formatted postal code $obj->delivery_city, $obj->delivery_zone, $obj->delivery_country, $obj->delivery_route_code, $obj->billing_first_name, $obj->billing_last_name, $obj->country_code_bill, $obj->billing_phone, $obj->billing_company, $obj->billing_address_1, $obj->billing_address_2, '=TEXT("' . $obj->billing_postal_code . '","000000")', // Create the CSV row with the formatted postal code $obj->billing_city, $obj->billing_zone, $obj->billing_country, $obj->billing_route_code, $obj->digital_commencement_date, $obj->digital_expiry_date, $obj->print_commencement_date, $obj->print_expiry_date, $payment_method, // $obj->other_payment_method, $obj->product, $obj->number_of_issues, $obj->product_model, $obj->product_type, $obj->quantity, $obj->gift, $amount_with_gst,'', $amount_without_gst, $gst_amount, $obj->remarks, $order_status, $subscription_status, $imported_record, $recurring_payment_status, $obj->payment_date, $obj->renewal_type ); } $csv_data = ''; foreach ($data as $row) { // Escape double quotes within each field by doubling them $escaped_row = array_map(function($item) { return '"' . str_replace('"', '""', $item) . '"'; }, $row); // Join fields with comma and enclose them in double quotes $csv_data .= implode(',', $escaped_row) . "\n"; } return $csv_data; } function stripe_order_generate_csv($order, $export_date, $verified_by){ $data = []; $data[] = array( 'Export Date', 'Subreport Date', 'Order Id', 'Customer', 'Email', 'Product Name', 'Total', 'Purchase Date', 'Status', 'Product Type', 'Commencement Date', 'Sub Recurring', 'Latest Order Number', 'Verified By' ); foreach ($order as $obj) { $data[] = array( $export_date, '', $obj->order_id, $obj->customer, $obj->primary_email, $obj->stripe_product_name, $obj->order_total, $obj->purchase_date, $obj->order_status, $obj->product_type, $obj->commencement_date, $obj->recurring_payment_status, $obj->latest_order_number, $verified_by ); } $csv_data = ''; foreach ($data as $row) { $csv_data .= '"' . implode('","', $row) . '"' . "\n"; } return $csv_data; } /** * This function is used to generate list order to xml / excel * * @request TWS-1633 https://edgeprop.atlassian.net/browse/TWS-1633 * * @param array $order { * It's an order array that includes multiple fields for order details * } * @param date $export_date This param used for set export date * @param string $verified_by This param used for set verified by * * @return object in xml */ function cms_stripe_order_generate_excel($order,$export_date, $verified_by){ $data = []; $data[] = array( 'Export Date', 'Subreport Date', 'Created (UTC)', 'Order', 'Description', 'Amount', 'Amount Refunded', 'Currency', 'Converted Amount', 'Converted Amount Refunded', 'Fee', 'Status', 'Customer Email', 'Address Route Code', 'Product', 'SUB STATUS', 'PROCESS BY', 'COMM DATE', 'REMARK' ); foreach ($order as $obj) { $data[] = array( date('d-M-Y', strtotime($export_date)), '', date('d/m/Y H:i', $obj->created), $obj->order_id, $obj->stripe_product_name, $obj->order_total, $obj->amount_refunded, $obj->currency, $obj->order_total, $obj->amount_refunded, $obj->gst_amount, $obj->order_status, $obj->primary_email, $obj->address_route_code, $obj->product_type, $obj->recurring_payment_status, $verified_by, date('d-M-Y', strtotime($obj->commencement_date)), $obj->stripe_order_remark ); } // Generate Excel XML content $xml = ' '; // Add data to XML content foreach ($data as $row) { $xml .= ''; foreach ($row as $cell) { $xml .= '' . $cell . ''; } $xml .= ''; } // Close XML content $xml .= '

'; header('Content-Type: application/vnd.ms-excel'); // header('Content-Disposition: attachment; filename="example.xls"'); return $xml; // Output the XML content // echo $xml; // exit(); } /** * Initializes a date range picker with optional pre-selected date range and half-width option. * * @param string $id The ID of the input element to bind the date range picker to. * @param string|null $getdate A pre-selected date range in the format "YYYY-MM-DD - YYYY-MM-DD". * @param bool $half Whether to set the parent element to half width or not. * @return string The HTML and JavaScript code for the date range picker. */ function date_range_init_v2($id,$getdate=null,$half=false){ $string = ''; return $string; } /** * Retrieves a list of products based on the given data collection and filter parameters. * * @param string $data_collection The data collection to retrieve products from. * @param bool $is_api Whether to return the data in JSON format or not. * @throws Exception If there's an error in the database query. * @return mixed The list of products. */ function get_list_products($data_collection = "", $is_api = true){ $data_collection = isset($_GET['data_collection']) ? $_GET['data_collection'] : ""; $digital = isset($_GET['digital']) ? $_GET['digital'] : 0; $print = isset($_GET['print']) ? $_GET['print'] : 0; $digital_and_print = isset($_GET['digital_and_print']) ? $_GET['digital_and_print'] : 0; $where_condition_stripe = ""; $where_condition_paypal = ""; $i = 0; if($digital != 0){ if($i<1){ $where_condition_stripe .= ' AND (product_type = \'digital\') '; $where_condition_paypal .= ' WHERE (product_type = \'digital\') '; } else { $where_condition_stripe .= ' OR (product_type = \'digital\') '; $where_condition_paypal .= ' OR (product_type = \'digital\') '; } $i++; } if($print != 0){ if($i<1){ $where_condition_stripe .= ' AND (product_type = \'print\') '; $where_condition_paypal .= ' WHERE (product_type = \'print\') '; } else { $where_condition_stripe .= ' OR (product_type = \'print\') '; $where_condition_paypal .= ' OR (product_type = \'print\') '; } $i++; } if($digital_and_print != 0){ if($i<1){ $where_condition_stripe .= ' AND (product_type = \'digital and print\') '; $where_condition_paypal .= ' WHERE (product_type = \'digital and print\') '; } else { $sql .= ' or (product_type = \'digital_and_print\' or sku_product_type = \'digital_and_print\') '; $where_condition_stripe .= ' OR (product_type = \'digital and print\') '; $where_condition_paypal .= ' OR (product_type = \'digital_and_print\') '; } $i++; } if($data_collection == "stripe"){ $sql = "SELECT sp.sku, sp.product_name as title FROM stripe_products sp WHERE sp.sku IS NOT NULL " . $where_condition_stripe . " ORDER BY sp.id desc;"; } else if($data_collection == "paypal"){ $sql = "SELECT up.model as sku, nd.title FROM uc_products up JOIN node nd ON nd.vid = up.vid LEFT JOIN sku_product_type spt ON spt.model = up.model " . $where_condition_paypal . "ORDER BY up.nid desc;"; } else { $sql = "SELECT * FROM ( SELECT up.model as sku, nd.title FROM uc_products up JOIN node nd ON nd.vid = up.vid LEFT JOIN sku_product_type spt ON spt.model = up.model " . $where_condition_paypal . "UNION SELECT sp.sku, sp.product_name as title FROM stripe_products sp WHERE sp.sku IS NOT NULL " . $where_condition_stripe . ") main GROUP BY sku ORDER BY sku asc"; } $products = db_query($sql)->fetchAll(); if($is_api == true){ return drupal_json_output([ "status" => true, "data" => $products ]); } else { return $products; } } function get_query_drupal_report_v2($is_background_process = false, $param = [], $is_detail_order = false){ $p_data_collection = $_GET['data_collection']; $p_op = $_GET['op']; $p_os1 = $_GET['os1']; $p_os2 = $_GET['os2']; $p_os3 = $_GET['os3']; $p_os4 = $_GET['os4']; $p_os5 = $_GET['os5']; $p_os6 = $_GET['os6']; $p_os7 = $_GET['os7']; $p_os8 = $_GET['os8']; $p_os9 = $_GET['os9']; $p_os10 = $_GET['os10']; $p_os11 = $_GET['os11']; $p_os12 = $_GET['os12']; $p_os13 = $_GET['os13']; $p_os14 = $_GET['os14']; $p_os15 = $_GET['os15']; $p_os16 = $_GET['os16']; $p_os17 = $_GET['os17']; $p_os18 = $_GET['os18']; $p_uid = $_GET['uid']; $p_oid = $_GET['oid']; $p_nid = $_GET['nid']; $p_status = $_GET['status']; $p_dr1 = $_GET['dr1']; $p_pcdf = $_GET['pcdf']; $p_dcdf = $_GET['dcdf']; $p_pedt = $_GET['pedt']; $p_dedt = $_GET['dedt']; $p_email = $_GET['email']; $p_pt1 = $_GET['pt1']; $p_pt2 = $_GET['pt2']; $p_pt3 = $_GET['pt3']; $p_opcdf = $_GET['opcdf']; $p_opedt = $_GET['opedt']; $p_odcdf = $_GET['odcdf']; $p_odedt = $_GET['odedt']; $p_sap = $_GET['sap']; if($is_background_process == true || $is_detail_order == true){ $p_data_collection = $param['data_collection']; $p_op = $param['op']; $p_os1 = $param['os1']; $p_os2 = $param['os2']; $p_os3 = $param['os3']; $p_os4 = $param['os4']; $p_os5 = $param['os5']; $p_os6 = $param['os6']; $p_os7 = $param['os7']; $p_os8 = $param['os8']; $p_os9 = $param['os9']; $p_os10 = $param['os10']; $p_os11 = $param['os11']; $p_os12 = $param['os12']; $p_os13 = $param['os13']; $p_os14 = $param['os14']; $p_os15 = $param['os15']; $p_os16 = $param['os16']; $p_os17 = $param['os17']; $p_os18 = $param['os18']; $p_uid = $param['uid']; $p_oid = $param['oid']; $p_nid = $param['nid']; $p_status = $param['status']; $p_dr1 = $param['dr1']; $p_pcdf = $param['pcdf']; $p_dcdf = $param['dcdf']; $p_pedt = $param['pedt']; $p_dedt = $param['dedt']; $p_email = $param['email']; $p_pt1 = $param['pt1']; $p_pt2 = $param['pt2']; $p_pt3 = $param['pt3']; $p_opcdf = $param['opcdf']; $p_opedt = $param['opedt']; $p_odcdf = $param['odcdf']; $p_odedt = $param['odedt']; $p_sap = $param['sap']; } // TODOS // Start of : Main query if($p_data_collection == "stripe_order"){ $sql = "SELECT * FROM v_stripe_main_orders main"; } else if($p_data_collection == "paypal_order"){ $sql = "SELECT * FROM v_ubercart_main_orders main"; } else if($p_data_collection == "google_order"){ $sql = googleOrderSql(); } else if($p_data_collection == "apple_order"){ $sql = appleOrderSql(); } else { $sql = allOrderSql(); } // End of : Main query // Default where clause $sql .= ($p_data_collection == "google_order" || $p_data_collection == "apple_order") ? " AND uid != 0 " : " WHERE uid != 0 "; if($is_detail_order == false){ $sql .= " /* Remove Email Test Case */ AND email NOT LIKE '%edgeprop%' AND email NOT LIKE '%regression%' AND email NOT LIKE '%test%' AND( delivery_first_name IS NULL OR delivery_first_name NOT LIKE '%test%' ) AND( delivery_last_name IS NULL OR delivery_last_name NOT LIKE '%test%' ) AND( billing_first_name IS NULL OR billing_first_name NOT LIKE '%test%' ) AND( billing_last_name IS NULL OR billing_last_name NOT LIKE '%test%' )"; } $get_count=0; if (isset($p_op)) { if((isset($p_os1) && $p_os1 != "") || (isset($p_os2) && $p_os2 != "") || (isset($p_os3) && $p_os3 != "") || (isset($p_os4) && $p_os4 != "") || (isset($p_os5) && $p_os5 != "") || (isset($p_os6) && $p_os6 != "") || (isset($p_os7) && $p_os7 != "") || (isset($p_os8) && $p_os8 != "") || (isset($p_os9) && $p_os9 != "") || (isset($p_os10) && $p_os10 != "") || (isset($p_os11) && $p_os11 != "") || (isset($p_os12) && $p_os12 != "") || (isset($p_os13) && $p_os13 != "") || (isset($p_os14) && $p_os14 != "") || (isset($p_os15) && $p_os15 != "") || (isset($p_os16) && $p_os16 != "") || (isset($p_os17) && $p_os17 != "") || (isset($p_os18) && $p_os18 != "") ){ $sql .= ' AND ('; $i=0; if(isset($p_os1) && $p_os1 != ""){ if($i<1){ $sql .= ' subscription_status = \'abandoned\''; } else { $sql .= ' or subscription_status = \'abandoned\''; } $q_url .= 'os1='.$p_os1.'&'; $i++; $get_count++; } if(isset($p_os2) && $p_os2 != ""){ if($i<1){ $sql .= ' subscription_status = \'canceled\''; } else { $sql .= ' or subscription_status = \'canceled\''; } $q_url .= 'os2='.$p_os2.'&'; $i++; $get_count++; } if(isset($p_os3) && $p_os3 != ""){ if($i<1){ $sql .= ' subscription_status = \'in_checkout\''; } else { $sql .= ' or subscription_status = \'in_checkout\''; } $q_url .= 'os3='.$p_os3.'&'; $i++; $get_count++; } if(isset($p_os4) && $p_os4 != ""){ if($i<1){ $sql .= ' subscription_status = \'pending\''; } else { $sql .= ' or subscription_status = \'pending\''; } $q_url .= 'os4='.$p_os4.'&'; $i++; $get_count++; } if(isset($p_os5) && $p_os5 != ""){ if($i<1){ $sql .= ' subscription_status = \'processing\''; } else { $sql .= ' or subscription_status = \'processing\''; } $q_url .= 'os5='.$p_os5.'&'; $i++; $get_count++; } if(isset($p_os6) && $p_os6 != ""){ if($i<1){ $sql .= ' subscription_status = \'paypal_pending\''; } else { $sql .= ' or subscription_status = \'paypal_pending\''; } $q_url .= 'os6='.$p_os6.'&'; $i++; $get_count++; } if(isset($p_os7) && $p_os7 != ""){ if($i<1){ $sql .= ' subscription_status = \'payment_received\''; } else { $sql .= ' or subscription_status = \'payment_received\''; } $q_url .= 'os7='.$p_os7.'&'; $i++; $get_count++; } if(isset($p_os8) && $p_os8 != ""){ if($i<1){ $sql .= ' subscription_status = \'completed\''; } else { $sql .= ' or subscription_status = \'completed\''; } $q_url .= 'os8='.$p_os8.'&'; $i++; $get_count++; } if(isset($p_os9) && $p_os9 != ""){ if($i<1){ $sql .= ' subscription_status = \'Handled_by_human\''; } else { $sql .= ' or subscription_status = \'Handled_by_human\''; } $q_url .= 'os9='.$p_os9.'&'; $i++; $get_count++; } if(isset($p_os10) && $p_os10 != ""){ if($i<1){ $sql .= ' subscription_status = \'Handled_by_human_autorenewal\''; } else { $sql .= ' or subscription_status = \'Handled_by_human_autorenewal\''; } $q_url .= 'os10='.$p_os10.'&'; $i++; $get_count++; } if(isset($p_os11) && $p_os11 != ""){ if($i<1){ $sql .= ' subscription_status = \'payment_received\''; } else { $sql .= ' or subscription_status = \'payment_received\''; } $q_url .= 'os11='.$p_os11.'&'; $i++; $get_count++; } if(isset($p_os12) && $p_os12 != ""){ if($i<1){ $sql .= ' subscription_status = \'free_order\''; } else { $sql .= ' or subscription_status = \'free_order\''; } $q_url .= 'os12='.$p_os12.'&'; $i++; $get_count++; } if(isset($p_os13) && $p_os13 != ""){ if($i<1){ $sql .= ' subscription_status = \'pending\''; } else { $sql .= ' or subscription_status = \'pending\''; } $q_url .= 'os13='.$p_os13.'&'; $i++; $get_count++; } if(isset($p_os14) && $p_os14 != ""){ if($i<1){ $sql .= ' subscription_status = \'payment_refunded\''; } else { $sql .= ' or subscription_status = \'payment_refunded\''; } $q_url .= 'os14='.$p_os14.'&'; $i++; $get_count++; } if(isset($p_os15) && $p_os15 != ""){ if($i<1){ $sql .= ' subscription_status = \'updated\''; } else { $sql .= ' or subscription_status = \'updated\''; } $q_url .= 'os15='.$p_os15.'&'; $i++; $get_count++; } if(isset($p_os16) && $p_os16 != ""){ if($i<1){ $sql .= ' subscription_status LIKE \'%ACTIVE\''; } else { $sql .= ' or subscription_status LIKE \'%ACTIVE\''; } $q_url .= 'os16='.$p_os16.'&'; $i++; $get_count++; } if(isset($p_os17) && $p_os17 != ""){ if($i<1){ $sql .= ' subscription_status LIKE \'%EXPIRED\''; } else { $sql .= ' or subscription_status LIKE \'%EXPIRED\''; } $q_url .= 'os17='.$p_os17.'&'; $i++; $get_count++; } if(isset($p_os18) && $p_os18 != ""){ if($i<1){ $sql .= ' subscription_status LIKE \'%CANCELED\''; } else { $sql .= ' or subscription_status LIKE \'%CANCELED\''; } $q_url .= 'os18='.$p_os18.'&'; $i++; $get_count++; } $sql .= ' ) '; } if (isset($p_sap) && $p_sap != "") { $sql .= " AND amount_with_gst > 0"; $q_url .= 'amount_with_gst > 0 &'; $get_count++; } if (isset($p_uid) && $p_uid != "") { $sql .= " AND uid = '".$p_uid."'"; $q_url .= 'uid='.$p_uid.'&'; $get_count++; } if (isset($p_oid) && $p_oid != "") { $sql .= " AND sub_no = '".$p_oid."'"; $q_url .= 'oid='.$p_oid.'&'; $get_count++; } // if (isset($p_nid) && $p_nid != "") { if (isset($p_nid) && $p_nid != -1) { $sql .= ' AND product_model = \''.$p_nid.'\''; // if($_GET['data_collection'] == "stripe"){ // $sql .= " AND opd.sku = ".$p_nid; // } else if($_GET['data_collection'] == "paypal"){ // $sql .= " AND opd.sku = ".$p_nid; // } else { // } $q_url .= 'nid='.$p_nid.'&'; $get_count++; } if (isset($p_status) && $p_status != "") { switch ($p_status) { case 'active': // $sql .= " AND (UNIX_TIMESTAMP(STR_TO_DATE(current_print_expiry, '%d-%b-%y')) > UNIX_TIMESTAMP(CURDATE()) OR UNIX_TIMESTAMP(STR_TO_DATE(current_digital_expiry, '%d-%b-%y')) > UNIX_TIMESTAMP(CURDATE()))"; $sql .= " AND (current_digital_expiry_ts > UNIX_TIMESTAMP(CURDATE()) OR current_print_expiry_ts > UNIX_TIMESTAMP(CURDATE()))"; $q_url .= 'status='.$p_status.'&'; break; case 'expired': $sql .= " AND (current_digital_expiry_ts < UNIX_TIMESTAMP(CURDATE()) OR current_digital_expiry_ts IS NULL ) and (current_print_expiry_ts < UNIX_TIMESTAMP(CURDATE()) OR current_print_expiry_ts IS null )"; $q_url .= 'status='.$p_status.'&'; break; default: $q_url .= 'status=&'; break; } $get_count++; } if(isset($p_dr1) && $p_dr1 != ""){ $date = explode(" - ", $p_dr1); $sql .= ' AND (created >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND created <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; $q_url .= 'dr1='.$p_dr1.'&'; $get_count++; } if(isset($p_pcdf) && $p_pcdf != ""){ $date = explode(" - ", $p_pcdf); $sql .= ' AND (current_print_start_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND current_print_start_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(current_print_start, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(current_print_start, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND pr_acc.field_print_access_between_value >= UNIX_TIMESTAMP(DATE(\''.$p_pcdf.'\')) '; $q_url .= 'pcdf='.$p_pcdf.'&'; $get_count++; } if(isset($p_dcdf) && $p_dcdf != ""){ $date = explode(" - ", $p_dcdf); $sql .= ' AND (current_digital_start_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND current_digital_start_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(current_digital_start, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(current_digital_start, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND dg_acc.field_access_content_between_value >= UNIX_TIMESTAMP(DATE(\''.$p_dcdf.'\')) '; $q_url .= 'dcdf='.$p_dcdf.'&'; $get_count++; } if(isset($p_pedt) && $p_pedt != ""){ $date = explode(" - ", $p_pedt); $sql .= ' AND (current_print_expiry_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND current_print_expiry_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(current_print_expiry, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(current_print_expiry, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND pr_acc.field_print_access_between_value2 <= UNIX_TIMESTAMP(DATE(\''.$p_pedt.'\')) '; $q_url .= 'pedt='.$p_pedt.'&'; $get_count++; } if(isset($p_dedt) && $p_dedt != ""){ $date = explode(" - ", $p_dedt); $sql .= ' AND (current_digital_expiry_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND current_digital_expiry_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(current_digital_expiry, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(current_digital_expiry, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND dg_acc.field_access_content_between_value2 <= UNIX_TIMESTAMP(DATE(\''.$p_dedt.'\')) '; $q_url .= 'dedt='.$p_dedt.'&'; $get_count++; } if(isset($p_email) && $p_email != ""){ $sql .= ' AND (email = \''.$p_email.'\' or email like \''.$p_email.'%\' or email like \'%'.$p_email.'\' or email like \'%'.$p_email.'%\')'; $q_url .= 'email='.$p_email.'&'; $get_count++; } if((isset($p_pt1) && $p_pt1 != "") || (isset($p_pt2) && $p_pt2 != "") || (isset($p_pt3) && $p_pt3 != "")){ $sql .= ' AND ('; $i=0; if(isset($p_pt1) && $p_pt1 != ""){ if($i<1){ $sql .= ' (product_type = \'digital\' or sku_product_type = \'digital\') '; } else { $sql .= ' or (product_type = \'digital\' or sku_product_type = \'digital\') '; } $q_url .= 'pt1='.$p_pt1.'&'; $i++; $get_count++; } if(isset($p_pt2) && $p_pt2 != ""){ if($i<1){ $sql .= ' (product_type = \'print\' or sku_product_type = \'print\') '; } else { $sql .= ' or (product_type = \'print\' or sku_product_type = \'print\') '; } $q_url .= 'pt2='.$p_pt2.'&'; $i++; $get_count++; } if(isset($p_pt3) && $p_pt3 != ""){ if($i<1){ $sql .= ' ((product_type = \'digital_and_print\' or sku_product_type = \'digital_and_print\') or (product_type = \'digital and print\' or sku_product_type = \'digital and print\')) '; } else { $sql .= ' or ((product_type = \'digital_and_print\' or sku_product_type = \'digital_and_print\') or (product_type = \'digital and print\' or sku_product_type = \'digital and print\')) '; } $q_url .= 'pt3='.$p_pt3.'&'; $i++; $get_count++; } $sql .= ' ) '; } if(isset($p_opcdf) && $p_opcdf != ""){ $date = explode(" - ", $p_opcdf); $sql .= ' AND (print_commencement_date_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND print_commencement_date_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(print_commencement_date, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(print_commencement_date, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND pa.print_commencement_date >= UNIX_TIMESTAMP(DATE(\''.$p_opcdf.'\')) '; $q_url .= 'opcdf='.$p_opcdf.'&'; $get_count++; } if(isset($p_opedt) && $p_opedt != ""){ $date = explode(" - ", $p_opedt); $sql .= ' AND (print_expiry_date_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND print_expiry_date_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(print_expiry_date, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(print_expiry_date, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND pa.print_expiry_date <= UNIX_TIMESTAMP(DATE(\''.$p_opedt.'\')) '; $q_url .= 'opedt='.$p_opedt.'&'; $get_count++; } if(isset($p_odcdf) && $p_odcdf != ""){ $date = explode(" - ", $p_odcdf); $sql .= ' AND (digital_commencement_date_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND digital_commencement_date_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(digital_commencement_date, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(digital_commencement_date, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND da.digital_commencement_date >= UNIX_TIMESTAMP(DATE(\''.$p_odcdf.'\')) '; $q_url .= 'odcdf='.$p_odcdf.'&'; $get_count++; } if(isset($p_odedt) && $p_odedt != ""){ $date = explode(" - ", $p_odedt); $sql .= ' AND (digital_expiry_date_ts >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND digital_expiry_date_ts <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND (UNIX_TIMESTAMP(STR_TO_DATE(digital_expiry_date, "%d-%b-%y")) >= UNIX_TIMESTAMP(DATE(\''.$date[0].'\')) AND UNIX_TIMESTAMP(STR_TO_DATE(digital_expiry_date, "%d-%b-%y")) <= (UNIX_TIMESTAMP(DATE(\''.$date[1].'\')) + 86395) )'; // $sql .= ' AND da.digital_expiry_date <= UNIX_TIMESTAMP(DATE(\''.$p_odedt.'\')) '; $q_url .= 'odedt='.$p_odedt.'&'; $get_count++; } } return $sql; } /** * Generates the access date for the CMS. * * @request TWS-1895 * * @throws None * @return array The generated output. */ function cms_generate_access_date(){ // Add necessary JS and CSS files drupal_add_js('https://cdn.jsdelivr.net/momentjs/latest/moment.min.js'); drupal_add_js('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/js/bootstrap-datepicker.min.js'); drupal_add_css('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/css/bootstrap-datepicker.min.css',array('type' => 'external')); drupal_add_css('https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.2/css/bootstrap.css',array('type' => 'external')); drupal_add_css('html body.admin-menu , .breadcrumb { background-color : #e0e0d8}', array('type' => 'inline')); // Check for user role global $user; if (!array_intersect(['Reports', 'tes-drupal-report'], $user->roles)) { header('Location: '.$GLOBALS['base_url']); } else { // Generate HTML table $table = "

Start Date:

"; $table .= " "; // $table_html .= ''; $output = array( '#type' => 'markup', '#markup' => $table, '#prefix' => '

', '#suffix' => '

', ); return $output; } } /** * Generate an access date based on the start date and access duration. * * @request TWS-1895 * * @throws Some_Exception_Class if the start date is not provided in the URL. * @return array An associative array containing the digital start date, digital end date, print start date, and print end date. */ function generate_access_date(){ $access_duration = '+366 days'; // Get the value of 'start_date' from the URL $start_date = $_GET['start_date']; // Convert the start date to the "MM/DD/YYYY" format $start_date = date("d M Y", strtotime($start_date)); // Convert the start date to a timestamp using strtotime() $start_date_ts = strtotime($start_date); $digital_start_date = $start_date; $digital_end_date = strtotime($access_duration, $start_date_ts); $print_start_date = ""; $print_end_date = ""; $start_date_day=date('D', $start_date_ts); if (($start_date_day == "Fri") || ($start_date_day == "Sat") || ($start_date_day == "Sun")) { $monday_timestamp = strtotime('next monday', $start_date_ts); $monday_timestamp = strtotime('+14 days', $monday_timestamp); } else { $monday_timestamp = strtotime('next monday', $start_date_ts); $monday_timestamp = strtotime('+7 days', $monday_timestamp); } $print_start_date = $monday_timestamp; // @request TWS-2020 // $print_end_date = strtotime($access_duration, $monday_timestamp); // Print End Timestamp $access_duration = '+'.(52*7).' days'; // Number of issues 52 weeks = 1 year $print_end_date = strtotime($access_duration, $monday_timestamp); $result = array( 'digital_start_date' => $digital_start_date, 'digital_end_date' => date('d M Y', $digital_end_date), 'print_start_date' => date('d M Y', $print_start_date), 'print_end_date' => date('d M Y', $print_end_date) ); return drupal_json_output([ "status" => true, "data" => $result ]); } /** * Converts the given order status to a more human-readable format. * * @param string $order_status The order status to be converted. * @return string The converted order status. */ function convert_order_status($order_status){ switch ($order_status) { case 'Handled_by_human_autorenewal': $order_status = 'Updated - A'; break; case 'Handled_by_human': $order_status = 'Updated'; break; case 'completed': $order_status = 'Paid'; break; case 'payment_received': $order_status = 'Payment Recieved'; break; case 'free_order': $order_status = 'Free Order'; break; case 'payment_refunded': $order_status = 'Payment Refunded'; break; case 'updated': $order_status = 'Updated'; break; case 'paypal_pending': $order_status = 'Paypal Pending'; break; case 'processing': $order_status = 'Processing'; break; case 'pending': $order_status = 'Pending'; break; case 'in_checkout': $order_status = 'In Checkout'; break; case 'abandoned': $order_status = 'Abandoned'; break; case 'canceled': $order_status = 'Expired'; break; case 'deleted': $order_status = 'Deleted'; break; default: $order_status = ''; break; } return $order_status; } /** * Generates the SQL query to retrieve all Google orders from the database. * * @request TWS-2471 * * The query joins multiple tables to retrieve the required information. * It also uses LEFT JOINs to include optional fields. * * @return string The SQL query to retrieve all Google orders. */ function googleOrderSql() { // SQL query to retrieve all Google orders $sql = " SELECT * FROM ( SELECT go.latest_order_id AS sub_no, 'google_order' AS data_collection, UNIX_TIMESTAMP(go.created_at) AS created, DATE_FORMAT(go.created_at, '%d-%b-%y') AS date_recieved, FROM_UNIXTIME(dg_acc.field_access_content_between_value2, '%d-%b-%y') AS current_digital_expiry, FROM_UNIXTIME(pr_acc.field_print_access_between_value2, '%d-%b-%y') AS current_print_expiry, dg_acc.field_access_content_between_value2 AS current_digital_expiry_ts, pr_acc.field_print_access_between_value2 AS current_print_expiry_ts, go.uid, u.mail AS email, u.name AS delivery_first_name, u.name AS delivery_last_name, NULL AS country_code_ship, NULL AS delivery_phone, NULL AS delivery_company, NULL AS delivery_address_1, NULL AS delivery_address_2, NULL AS delivery_postal_code, NULL AS delivery_city, NULL AS delivery_zone, NULL AS delivery_country, NULL AS delivery_route_code, u.name AS billing_first_name, u.name AS billing_last_name, NULL AS country_code_bill, NULL AS billing_phone, NULL AS billing_company, NULL AS billing_address_1, NULL AS billing_address_2, NULL AS billing_postal_code, NULL AS billing_city, NULL AS billing_zone, NULL AS billing_country, NULL AS billing_route_code, DATE_FORMAT(go.start_time, '%d-%b-%y') AS digital_commencement_date, DATE_FORMAT(go.expiry_time, '%d-%b-%y') AS digital_expiry_date, NULL AS print_commencement_date, NULL AS print_expiry_date, UNIX_TIMESTAMP(go.start_time) AS digital_commencement_date_ts, UNIX_TIMESTAMP(go.expiry_time) AS digital_expiry_date_ts, NULL AS print_commencement_date_ts, NULL AS print_expiry_date_ts, NULL AS payment_method, NULL AS other_payment_method, products.product_name AS product, products.number_of_issues AS number_of_issues, products.product_id AS product_model, 'digital' AS product_type, products.product_id AS sku_product_type, 1 AS quantity, NULL AS gift, products.product_price AS amount_with_gst, NULL AS amount_without_gst, NULL AS gst_amount, go.remark AS remarks, go.subscription_state AS subscription_status, NULL AS imported_record, UNIX_TIMESTAMP(go.created_at) AS payment_date, ( CASE WHEN latest.notification_type = 2 OR latest.notification_type = 4 THEN 'Active' WHEN latest.notification_type = 13 THEN 'Expired' WHEN latest.notification_type = 3 THEN 'Cancelled' ELSE 'No Recurring' END) AS recurring_payment_status, NULL AS renewal_type, NULL AS print_expiry_duration, NULL AS digital_expiry_duration FROM google_in_app_subscription_details go JOIN users u ON u.uid = go.uid LEFT JOIN google_iap_products products ON products.product_id = go.product_id LEFT JOIN profile p ON p.uid = u.uid LEFT JOIN field_data_field_access_content_between dg_acc ON p.pid = dg_acc.entity_id LEFT JOIN field_data_field_print_access_between pr_acc ON p.pid = pr_acc.entity_id -- Get the latest order state for each purchase_token JOIN ( SELECT go.purchase_token, go.notification_type FROM ( SELECT go.purchase_token, MAX(go.created_at) AS max_created_at FROM google_in_app_subscription_details go GROUP BY go.purchase_token) AS latest INNER JOIN google_in_app_subscription_details go ON go.purchase_token = latest.purchase_token AND go.created_at = latest.max_created_at JOIN users u ON u.uid = go.uid LEFT JOIN google_iap_products products ON products.product_id = go.product_id) latest ON latest.purchase_token = go.purchase_token) main WHERE 1 = 1 "; return $sql; } /** * Returns the SQL query to retrieve all Apple orders from the database. * * @request TWS-2471 * * The query joins multiple tables to retrieve the required information. * It also uses UNION to combine the results of the appleOrderSql() and googleOrderSql() functions. * * @return string The SQL query to retrieve all Apple orders. */ function appleOrderSql() { $sql = " -- Retrieve all Apple orders from the database SELECT * FROM ( SELECT -- Concatenate original_purchase_token and purchase_token CONCAT('original_purchase_token: ', ap.original_purchase_token, ' | purchase_token: ', ap.purchase_token) AS sub_no, 'apple_order' AS data_collection, -- Convert created_at to Unix timestamp UNIX_TIMESTAMP(ap.created_at) AS created, -- Format created_at as 'dd-MMM-yy' DATE_FORMAT(ap.created_at, '%d-%b-%y') AS date_recieved, -- Format dg_acc.field_access_content_between_value2 as 'dd-MMM-yy' FROM_UNIXTIME(dg_acc.field_access_content_between_value2, '%d-%b-%y') AS current_digital_expiry, -- Format pr_acc.field_print_access_between_value2 as 'dd-MMM-yy' FROM_UNIXTIME(pr_acc.field_print_access_between_value2, '%d-%b-%y') AS current_print_expiry, dg_acc.field_access_content_between_value2 AS current_digital_expiry_ts, pr_acc.field_print_access_between_value2 AS current_print_expiry_ts, ap.uid, u.mail AS email, u.name AS delivery_first_name, u.name AS delivery_last_name, NULL AS country_code_ship, NULL AS delivery_phone, NULL AS delivery_company, NULL AS delivery_address_1, NULL AS delivery_address_2, NULL AS delivery_postal_code, NULL AS delivery_city, NULL AS delivery_zone, NULL AS delivery_country, NULL AS delivery_route_code, u.name AS billing_first_name, u.name AS billing_last_name, NULL AS country_code_bill, NULL AS billing_phone, NULL AS billing_company, NULL AS billing_address_1, NULL AS billing_address_2, NULL AS billing_postal_code, NULL AS billing_city, NULL AS billing_zone, NULL AS billing_country, NULL AS billing_route_code, DATE_FORMAT(ap.start_time, '%d-%b-%y') AS digital_commencement_date, DATE_FORMAT(ap.expiry_time, '%d-%b-%y') AS digital_expiry_date, NULL AS print_commencement_date, NULL AS print_expiry_date, UNIX_TIMESTAMP(ap.start_time) AS digital_commencement_date_ts, UNIX_TIMESTAMP(ap.expiry_time) AS digital_expiry_date_ts, NULL AS print_commencement_date_ts, NULL AS print_expiry_date_ts, NULL AS payment_method, NULL AS other_payment_method, products.product_name AS product, products.number_of_issues AS number_of_issues, products.product_id AS product_model, 'digital' AS product_type, products.product_id AS sku_product_type, 1 AS quantity, NULL AS gift, products.product_price AS amount_with_gst, NULL AS amount_without_gst, NULL AS gst_amount, ap.remark AS remarks, -- Determine subscription status based on notification_type and subscription_state CASE WHEN (ap.notification_type = 'SUBSCRIBED') OR(ap.notification_type = 'DID_RENEW' AND ap.subscription_state = '') THEN 'ACTIVE' WHEN ap.notification_type = 'DID_CHANGE_RENEWAL_STATUS' AND ap.subscription_state = 'AUTO_RENEW_DISABLED' THEN 'CANCELED' WHEN ap.notification_type = 'EXPIRED' AND ap.subscription_state = 'VOLUNTARY' THEN 'EXPIRED' ELSE NULL END AS subscription_status, NULL AS imported_record, -- Convert created_at to Unix timestamp UNIX_TIMESTAMP(ap.created_at) AS payment_date, -- Determine recurring payment status based on notification_type and subscription_state CASE WHEN (ap.notification_type = 'SUBSCRIBED') OR(ap.notification_type = 'DID_RENEW' AND ap.subscription_state = '') THEN 'ACTIVE' WHEN ap.notification_type = 'DID_CHANGE_RENEWAL_STATUS' AND ap.subscription_state = 'AUTO_RENEW_DISABLED' THEN 'CANCELED' WHEN ap.notification_type = 'EXPIRED' AND ap.subscription_state = 'VOLUNTARY' THEN 'EXPIRED' ELSE NULL END AS recurring_payment_status, NULL AS renewal_type, NULL AS print_expiry_duration, NULL AS digital_expiry_duration FROM apple_in_app_subscription_details ap JOIN users u ON u.uid = ap.uid LEFT JOIN apple_iap_products products ON products.product_id = ap.product_id LEFT JOIN profile p ON p.uid = u.uid LEFT JOIN field_data_field_access_content_between dg_acc ON p.pid = dg_acc.entity_id LEFT JOIN field_data_field_print_access_between pr_acc ON p.pid = pr_acc.entity_id -- Get the latest order state for each purchase_token JOIN ( SELECT ap.purchase_token, ap.notification_type FROM ( SELECT ap.purchase_token, MAX(ap.created_at) AS max_created_at FROM apple_in_app_subscription_details ap GROUP BY ap.purchase_token) AS latest INNER JOIN apple_in_app_subscription_details ap ON ap.purchase_token = latest.purchase_token AND ap.created_at = latest.max_created_at JOIN users u ON u.uid = ap.uid LEFT JOIN apple_iap_products products ON products.product_id = ap.product_id) latest ON latest.purchase_token = ap.purchase_token) main WHERE 1 = 1 "; return $sql; } /** * Returns the SQL query to retrieve all orders from the database. * * @request TWS-2471 * * The query uses UNION to combine the results of the googleOrderSql() and appleOrderSql() functions. * * @return string The SQL query to retrieve all orders. */ function allOrderSql() { // SQL query to retrieve all orders $sql = " SELECT * FROM ( -- Select all orders from the v_all_orders view SELECT main.sub_no, main.data_collection, main.created, main.date_recieved, main.current_digital_expiry, main.current_print_expiry, main.current_digital_expiry_ts, main.current_print_expiry_ts, main.uid, main.email, main.delivery_first_name, main.delivery_last_name, main.country_code_ship, main.delivery_phone, main.delivery_company, main.delivery_address_1, main.delivery_address_2, main.delivery_postal_code, main.delivery_city, main.delivery_zone, main.delivery_country, main.delivery_route_code, main.billing_first_name, main.billing_last_name, main.country_code_bill, main.billing_phone, main.billing_company, main.billing_address_1, main.billing_address_2, main.billing_postal_code, main.billing_city, main.billing_zone, main.billing_country, main.billing_route_code, main.digital_commencement_date, main.digital_expiry_date, main.print_commencement_date, main.print_expiry_date, main.digital_commencement_date_ts, main.digital_expiry_date_ts, main.print_commencement_date_ts, main.print_expiry_date_ts, main.payment_method, main.other_payment_method, main.product, main.number_of_issues, main.product_model, main.product_type, main.sku_product_type, main.quantity, main.gift, main.amount_with_gst, main.amount_without_gst, main.gst_amount, main.remarks, main.subscription_status, main.imported_record, main.payment_date, NULL AS recurring_payment_status, NULL AS 'renewal_type', NULL AS 'print_expiry_duration', NULL AS 'digital_expiry_duration' FROM v_all_orders main -- Combine the results of the googleOrderSql() and appleOrderSql() functions using UNION UNION " . googleOrderSql() . " UNION " . appleOrderSql() . " ) main "; return $sql; } {"status":"success","data":{"get_setting_message":{"Header_Promo":"Get the latest news updates in your mailbox","Sub_Header_Promo":"Never miss out on important financial news and get daily updates today","ticker_tape":[{"type":"Breaking News","message":null},{"type":"Breaking News","message":"\u003Ca href=\u0027https:\/\/www.theedgesingapore.com\/prints\/issue-1192-testing-times?utm_source=tes-tickertape\u0026utm_medium=teswebsite\u0026utm_campaign=\u0027\u003ERead the latest issue, \u003Cb\u003EIssue 1192: Testing times\u003C\/b\u003E here\u003C\/a\u003E"},{"type":null,"message":null}]},"dropdown_menu":{"views":[{"nid":"354475","node_created":"1768796633","title":"Edit title Cuppage Terrace, \u0027one-of-a-kind trophy asset\u0027 valued at $250 million, is up for sale","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/online%20Cuppage%20Terrace%20-%20Copy.jpg?PYCL.EkFurX401T3yHGa92F2dm_C7PKH","alias":"\/views\/oil-gas\/edit-title-cuppage-terrace-one-kind-trophy-asset-valued-250-million-sale","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"a day ago","date":"January 19, 2026"},{"nid":"354469","node_created":"1767170372","title":"test for workflow","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/shutterstock_1006916938%20%281%29.jpg?cMnh3GHNDrSOHhZDuQTMqcF.tl_l3Han","alias":"\/views\/billion-dollar-club-2025\/test-workflow","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"19 days ago","date":"December 31, 2025"},{"nid":"354445","node_created":"1762766248","title":"The Edge Singapore crowns market champions at the Billion Dollar Club Awards 2025","isPremium":true,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/Finale_1_crop_0_0.jpg?f3LyZDbz.EdmW2PfrMr6EaF_zg4WPnVV","alias":"\/views\/1000th-issue\/edge-singapore-crowns-market-champions-billion-dollar-club-awards-2025","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"November 10, 2025","date":"November 10, 2025"}],"latest":[{"nid":"354475","node_created":"1768796633","title":"Edit title Cuppage Terrace, \u0027one-of-a-kind trophy asset\u0027 valued at $250 million, is up for sale","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/online%20Cuppage%20Terrace%20-%20Copy.jpg?PYCL.EkFurX401T3yHGa92F2dm_C7PKH","alias":"\/views\/oil-gas\/edit-title-cuppage-terrace-one-kind-trophy-asset-valued-250-million-sale","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"a day ago","date":"January 19, 2026"},{"nid":"354472","node_created":"1767663833","title":"2025 Singapore Motorshow Preview","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/batch_20250109_095209.jpg?Ry7py_vK8fXhaHcm4GKgS2ojd299rjWs","alias":"\/news\/banking-finance\/2025-singapore-motorshow-preview","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"14 days ago","date":"January 06, 2026"},{"nid":"354471","node_created":"1767597002","title":"UOB struggles with Hong Kong, China property loans as prices sink 123","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/428906956%20%281%29_1_0_0_0_0_0_1.jpg?Cxw0f6V1LtxX4f6YyyME3twSdTk.IHC7","alias":"\/news\/banking-finance\/uob-struggles-hong-kong-china-property-loans-prices-sink-123","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"15 days ago","date":"January 05, 2026"}],"news":[{"nid":"354472","node_created":"1767663833","title":"2025 Singapore Motorshow Preview","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/batch_20250109_095209.jpg?Ry7py_vK8fXhaHcm4GKgS2ojd299rjWs","alias":"\/news\/banking-finance\/2025-singapore-motorshow-preview","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"14 days ago","date":"January 06, 2026"},{"nid":"354471","node_created":"1767597002","title":"UOB struggles with Hong Kong, China property loans as prices sink 123","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/428906956%20%281%29_1_0_0_0_0_0_1.jpg?Cxw0f6V1LtxX4f6YyyME3twSdTk.IHC7","alias":"\/news\/banking-finance\/uob-struggles-hong-kong-china-property-loans-prices-sink-123","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"15 days ago","date":"January 05, 2026"},{"nid":"354466","node_created":"1766371879","title":"UOB struggles with Hong Kong, China property loans as prices sink 000","isPremium":true,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/428906956%20%281%29_1_0_0_0_0_0_1.jpg?Cxw0f6V1LtxX4f6YyyME3twSdTk.IHC7","alias":"\/news\/banking-finance\/uob-struggles-hong-kong-china-property-loans-prices-sink-000","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"29 days ago","date":"December 22, 2025"}],"options":[{"nid":"354468","node_created":"1767085050","title":"A celebration of taste and technology: Why V-ZUG is the choice for the festive kitchen","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/V-ZUG%20Grand%20%28with%20Turkeys%29.jpg?llUxOgsFUpZOxJeazqFcd2zYYcMc66yH","alias":"\/options\/feature\/celebration-taste-and-technology-why-v-zug-choice-festive-kitchen","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"20 days ago","date":"December 30, 2025"},{"nid":"354441","node_created":"1762486300","title":"testing image","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/443784818-US-Pres-Donald_Trump-R-VP-JD-Vance-L-dinner-w_Central_Asian_leaders_in_the_East_Rm_of_the_Wh_Hse_in_WA_DC-Nov6.2025-px-Aaron_Schwartz_Bloomberg-APP_0.jpg?4jaNL6FGcnt02gxKZOiYRGH5aLczV4yV","alias":"\/options\/motoring-feature\/testing-image","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"November 07, 2025","date":"November 07, 2025"},{"nid":"354439","node_created":"1762484491","title":"5 gems of JMS 2025","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/LEI_BDC2025_TABLE_04.jpg?Z13D3zJiRZ2remWbXNGrqtPnN62sLe9b","alias":"\/options\/motoring-news\/5-gems-jms-2025","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"November 07, 2025","date":"November 07, 2025"}],"capital":[{"nid":"354462","node_created":"1764164242","title":"Zixin 1HFY2026 earnings double to RMB16.06 million","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/PEO_LIANG_CHENGWANG_03_AC_0_0_0_0.jpg?BNTBLh15KjFHGXYeyPJ0oQ2PLzmCJFYn","alias":"\/capital\/results\/zixin-1hfy2026-earnings-double-rmb1606-million","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"November 26, 2025","date":"November 26, 2025"},{"nid":"354362","node_created":"1759890403","title":"QA Riverstone shares surge on UOB Kay Hian\u0027s higher add target price of 98 cents led by AI-end demand url","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/PEO_WONG_TEEK_SOON_02_BT_1_0.jpg?FxBIEgBEv0hW.m7FRAf53a9N_YIvAm0d","alias":"\/capital\/brokers-calls\/qa-riverstone-shares-surge-uob-kay-hians-higher-add-target-price-98-cents-led","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"October 08, 2025","date":"October 08, 2025"},{"nid":"354354","node_created":"1759823172","title":"UOBKH expects Banyan Tree\u0027s residences segment to drive growth in 2027","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/Banyan%20Tree_0_4.jpg?ceCt_skoaNIe0vScu0uaaxuSOBd2TXDK","alias":"\/capital\/brokers-calls\/uobkh-expects-banyan-trees-residences-segment-drive-growth-2027","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"October 07, 2025","date":"October 07, 2025"}],"digitaledge":[{"nid":"354452","node_created":"1762921685","title":"GFTN unveils AI research engine for the financial services sector","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/Screenshot%202023-11-09%20095343_1.jpg?bP761WRdn88ih1X4_IZb7kQBqlpVJkRe","alias":"\/digitaledge\/artificial-intelligence\/gftn-unveils-ai-research-engine-financial-services-sector","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"November 12, 2025","date":"November 12, 2025"},{"nid":"354368","node_created":"1759995559","title":"Singapore financial firms lead AI adoption but still lose clients over onboarding delays","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/pexels-solomonikvik-33847223.jpg?v78TU3C.zjRvyYo0l1cmLKhyy25Ap2AI","alias":"\/digitaledge\/artificial-intelligence\/singapore-financial-firms-lead-ai-adoption-still-lose-clients","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"October 09, 2025","date":"October 09, 2025"},{"nid":"354364","node_created":"1759909370","title":"digital","isPremium":false,"cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/WAKUDA_Main%20Dining%20Room_1.jpg?N.lluXLeygeOmhnaIkrCBFtBSaY3cdtd","alias":"\/digitaledge\/digital-economy\/digital","category":null,"category_url":"\/","author":null,"author_url":null,"number_of_hours":"October 08, 2025","date":"October 08, 2025"}]},"trending_now":[{"nid":"360452","node_title":"UOB to issue $850 mil worth of perpetual capital securities with 3% distribution rate","alias":"\/news\/banking-finance\/uob-issue-850-mil-worth-perpetual-capital-securities-3-distribution-rate","created":"5 days ago","changed":"1768435919","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/428906956%20%281%29_1_0_0_0_0_0_0_0.jpg?EODAB.0_oEwanH.rUsxEyzLJjNIUwqM6","formatted_created":"2026-01-15 08:08:38","formatted_changed":"2026-01-15 08:11:59","author":"Felicia Tan","author_id":148580,"category_id":"33933","category":"Banking \u0026 finance","category_url":"\/flash-categories\/banking-finance","type":"popular_news","reading_time":1,"is_premium":false,"author_url":"\/authors\/Felicia-Tan","ga_stats_count_uniquepageviews_today_count":"6377"},{"nid":"360470","node_title":"Keppel, Singtel among PhillipCapital\u2019s \u2018Absolute 10\u2019 for monetisation theme","alias":"\/capital\/investing-strategies\/keppel-singtel-among-phillipcapitals-absolute-10-monetisation-theme","created":"4 days ago","changed":"1768527659","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/online%20KEPPEL%20STOCK%20IMAGE%20CREDIT%20KEPPEL%20CORPORATION%20-%20Copy.jpg?VkBq2u7jnmWNlYYr21jnRpeLMPqXHS7n","formatted_created":"2026-01-16 09:40:00","formatted_changed":"2026-01-16 09:40:59","author":"The Edge Singapore ","author_id":0,"category_id":"250","category":"Investing strategies","category_url":"\/flash-categories\/investing-strategies","type":"popular_news","reading_time":9,"is_premium":true,"author_url":"\/authors\/The-Edge-Singapore","ga_stats_count_uniquepageviews_today_count":"5825"},{"nid":"360562","node_title":"Fullerton Fund Management buys 330,300 shares in SATS, deemed interest increased to 40.01%","alias":"\/news\/insider-moves\/fullerton-fund-management-buys-330300-shares-sats-deemed-interest-increased-4001","created":"3 days ago","changed":"1768557780","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/ID9775-Electric%20Tractors%20%281%29-1-1_0.jpg?__EbdJqmZA_WzrGRXwLLeeMxEgozbEXA","formatted_created":"2026-01-16 18:01:31","formatted_changed":"2026-01-16 18:03:00","author":"Nicole Lim","author_id":181326,"category_id":"47303","category":"Insider moves","category_url":"\/flash-categories\/insider-moves","type":"popular_news","reading_time":1,"is_premium":false,"author_url":"\/authors\/Nicole-Lim","ga_stats_count_uniquepageviews_today_count":"3083"},{"nid":"360468","node_title":"With a \u2018big stir\u2019, Singapore is no longer \u2018extremely boring\u2019 market: OCBC\u2019s Wong ","alias":"\/capital\/investing-strategies\/big-stir-singapore-no-longer-extremely-boring-market-ocbcs-wong","created":"4 days ago","changed":"1768528259","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/Samuel%20Wong_7603%20-%20Copy.jpg?xLqkbQCga0C2oNhYoo1tVY3msueZ5IJt","formatted_created":"2026-01-16 09:50:00","formatted_changed":"2026-01-16 09:50:59","author":"The Edge Singapore ","author_id":0,"category_id":"250","category":"Investing strategies","category_url":"\/flash-categories\/investing-strategies","type":"popular_news","reading_time":9,"is_premium":true,"author_url":"\/authors\/The-Edge-Singapore","ga_stats_count_uniquepageviews_today_count":"2968"},{"nid":"360509","node_title":"Lion Global sees Singapore\u2019s small- mid-cap emerging as an asset class","alias":"\/capital\/investing-strategies\/lion-global-sees-singapores-small-mid-cap-emerging-asset-class","created":"4 days ago","changed":"1768532282","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/PEO_KENNETH_ONG_%26_ERICA_LAU_02_AC%20%281%29%20-%20resized.jpg?DYYiVr07JIt7UqelFe9txPA6ldw2mYd2","formatted_created":"2026-01-16 10:00:00","formatted_changed":"2026-01-16 10:58:02","author":"Teo Zheng Long","author_id":260868,"category_id":"250","category":"Investing strategies","category_url":"\/flash-categories\/investing-strategies","type":"popular_news","reading_time":8,"is_premium":true,"author_url":"\/authors\/Teo-Zheng-Long","ga_stats_count_uniquepageviews_today_count":"2598"}],"popular_flash_categories":[{"topic_name":"Broker\u0027s Calls","topic_url":"\/flash-categories\/brokers-calls","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/styles\/article_detail__1200x653_\/s3\/default_images\/default-pic_0.jpg","views":"1696785","topic_type":"TRENDING","topic_id":"brokers-calls","is_custom_url":false},{"topic_name":"Company in the news","topic_url":"\/flash-categories\/company-news","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/styles\/article_detail__1200x653_\/s3\/default_images\/default-pic_0.jpg","views":"866175","topic_type":"TRENDING","topic_id":"company-news","is_custom_url":false},{"topic_name":"Results","topic_url":"\/flash-categories\/results","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/styles\/article_detail__1200x653_\/s3\/default_images\/default-pic_0.jpg","views":"511080","topic_type":"TRENDING","topic_id":"results","is_custom_url":false},{"topic_name":"Banking \u0026 finance","topic_url":"\/flash-categories\/banking-finance","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/styles\/article_detail__1200x653_\/s3\/default_images\/default-pic_0.jpg","views":"272276","topic_type":"TRENDING","topic_id":"banking-finance","is_custom_url":false},{"topic_name":"Singapore economy","topic_url":"\/flash-categories\/singapore-economy","cover_uri":"https:\/\/edgemarkets-transferred.s3-ap-southeast-1.amazonaws.com\/styles\/article_detail__1200x653_\/s3\/default_images\/default-pic_0.jpg","views":"260296","topic_type":"TRENDING","topic_id":"singapore-economy","is_custom_url":false}]}}

The show must go on