function parse_csv_file($path, $delimiter = ',', $first_row_as_keys = true)
{
$file = csv_parse($path, $delimiter);
$result = array();
while (($data = csv_row_from($file)) !== FALSE) {
$result[] = $data;
}
return $result;
}
//******************************************************************//
// Package: Zerone-Consulting
// Description: Online Payment Gateway
// Files: index.php,home.php,cheque.php,creditcard.php,report.php,reportBottom.php, reportBottomSummary.php,companyEdit.php
// config.php,useraccount.php,viewCompany.php,topheader.php,ViewreportPage.php,addcheque.php,blank.php,profile_blank.php
// VT_blank.php,creditcardfb.php,customerservice_blank.php,report_custom.php,callback.php,ledger.php
//report.php: The page functions for selecting the type of report view of the company.
include 'includes/sessioncheckuser.php';
require_once "includes/dbconnection.php";
require_once 'includes/function.php';
include 'includes/header.php';
$sessionlogin = isset($HTTP_SESSION_VARS["sessionlogin"]) ? $HTTP_SESSION_VARS["sessionlogin"] : "";
if ($_FILES['batchfile']['type'] == 'application/vnd.ms-excel') {
set_time_limit(500);
$CSV = file_get_contents($_FILES['batchfile']['tmp_name']);
$CSV_Info = csv_parse($CSV);
$log = "Attempting to update transactions through batch file:\n";
$success = 0;
$failed = 0;
foreach ($CSV_Info as $info) {
$transactionInfo = getTransactionInfo(quote_smart($info[0]), quote_smart($_GET['test']), 'reference_number', " and t.userId = '{$sessionlogin}'");
$transactionId = $transactionInfo['transactionId'];
if ($transactionInfo == -1) {
$log .= " Could not locate transaction '" . $info[0] . "'\n";
$failed++;
} else {
//(Reference_ID, Shipping Tracking Number, Date Shipped, Estimate Arrival Time, Shipping Company, Optional Tracking Hyperlink, Extra Info)
$td_tracking_id = quote_smart($info[1]);
$td_tracking_link = quote_smart($info[5]);
$td_tracking_company = quote_smart($info[4]);
$td_tracking_info = quote_smart($info[6]);
/**
* Handle plan import request.
*
* @return The url to display on completion.
*/
function command_member_plan_import()
{
if (!user_access('member_plan_edit')) {
error_register('User does not have permission: member_plan_edit');
return crm_url('members');
}
if (!array_key_exists('plan-file', $_FILES)) {
error_register('No plan file uploaded');
return crm_url('plans&tab=import');
}
$csv = file_get_contents($_FILES['plan-file']['tmp_name']);
$data = csv_parse($csv);
foreach ($data as $row) {
// Convert row keys to lowercase and remove spaces
foreach ($row as $key => $value) {
$new_key = str_replace(' ', '', strtolower($key));
unset($row[$key]);
$row[$new_key] = $value;
}
// Add plan
$name = mysql_real_escape_string($row['planname']);
$price = mysql_real_escape_string($row['price']);
$active = mysql_real_escape_string($row['active']);
$voting = mysql_real_escape_string($row['voting']);
$sql = "\n INSERT INTO `plan`\n (`name`,`price`,`active`,`voting`)\n VALUES\n ('{$name}','{$price}','{$active}','{$voting}')";
$res = mysql_query($sql);
if (!$res) {
crm_error(mysql_error());
}
$pid = mysql_insert_id();
}
return crm_url('plans');
}
/**
* Handle amazon payment import request.
*
* @return The url to display on completion.
*/
function command_amazon_payment_import()
{
if (!user_access('payment_edit')) {
error_register('User does not have permission: payment_edit');
return crm_url('payments');
}
if (!array_key_exists('payment-file', $_FILES)) {
error_register('No payment file uploaded');
return crm_url('payments&tab=import');
}
$csv = file_get_contents($_FILES['payment-file']['tmp_name']);
$data = csv_parse($csv);
$count = 0;
message_register("Processing " . count($data) . " row(s)");
foreach ($data as $row) {
// Ignore withdrawals, holds, and failures
if (strtolower($row['Type']) !== 'payment') {
message_register("Ignoring row of type: " . $row['Type']);
continue;
}
if (strtolower($row['To/From']) !== 'from') {
message_register("Ignoring outgoing payment");
continue;
}
if (strtolower($row['Status']) !== 'completed') {
message_register("Ignoring payment with status: " . $row['Status']);
continue;
}
// Skip transactions that have already been imported
$payment_opts = array('filter' => array('confirmation' => $row['Transaction ID']));
$data = payment_data($payment_opts);
if (count($data) > 0) {
message_register("Skipping previously imported payment: " . $row['Transaction ID']);
continue;
}
// Parse value
$value = payment_parse_currency($row['Amount']);
// Create payment object
$payment = array('date' => date('Y-m-d', strtotime($row['Date'])), 'code' => $value['code'], 'value' => $value['value'], 'description' => $row['Name'] . ' Amazon Payment', 'method' => 'amazon', 'confirmation' => $row['Transaction ID'], 'notes' => $row['notes'], 'amazon_name' => $row['Name']);
// Check if the amazon name is linked to a contact
$opts = array('filter' => array('amazon_name' => $row['Name']));
$contact_data = amazon_payment_contact_data($opts);
if (count($contact_data) > 0) {
$payment['credit_cid'] = $contact_data[0]['cid'];
}
// Save the payment
$payment = payment_save($payment);
$count++;
}
message_register("Successfully imported {$count} payment(s)");
return crm_url('payments');
}
/**
* Handle paypal payment import request.
*
* @return The url to display on completion.
*/
function command_paypal_payment_import()
{
if (!user_access('payment_edit')) {
error_register('User does not have permission: payment_edit');
return crm_url('payments');
}
if (!array_key_exists('payment-file', $_FILES)) {
error_register('No payment file uploaded');
return crm_url('payments&tab=import');
}
$csv = file_get_contents($_FILES['payment-file']['tmp_name']);
$data = csv_parse($csv);
$count = 0;
foreach ($data as $row) {
// Skip transactions that have already been imported
$payment_opts = array('filter' => array('confirmation' => $row['Transaction ID']));
$data = payment_data($payment_opts);
if (count($data) > 0) {
continue;
}
// Parse value
$value = payment_parse_currency($row['Gross']);
// Create payment object
$payment = array('date' => date('Y-m-d', strtotime($row['Date'])), 'code' => $value['code'], 'value' => $value['value'], 'description' => $row['Name'] . ' Paypal Payment', 'method' => 'paypal', 'confirmation' => $row['Transaction ID'], 'notes' => $row['Item Title'], 'paypal_email' => $row['From Email Address']);
// Check if the paypal email is linked to a contact
$opts = array('filter' => array('paypal_email' => $row['From Email Address']));
$contact_data = paypal_payment_contact_data($opts);
if (count($contact_data) > 0) {
$payment['credit_cid'] = $contact_data[0]['cid'];
}
// Save the payment
$payment = payment_save($payment);
$count++;
}
message_register("Successfully imported {$count} payment(s)");
return crm_url('payments');
}
$headerInclude = "ledgers";
$display_stat_wait = true;
include "includes/header.php";
include "../includes/companySubView.php";
require_once "../includes/projSetCalc.php";
require_once "../includes/JSON_functions.php";
$bank_ids = array();
$sql = "SELECT bank_id FROM cs_bank WHERE bk_ignore=0 order by bank_id asc";
$res = sql_query_read($sql) or dieLog(mysql_error());
while ($bankInfo = mysql_fetch_assoc($res)) {
$bank_ids[] = $bankInfo['bank_id'];
}
if ($_POST['submit'] == 'SM Payout Response') {
$csv = file_get_contents($_FILES["sm_payout_file"]["tmp_name"]);
$csv = str_replace("\r", "", $csv);
$csv_info = csv_parse($csv);
$error = 0;
$count = 0;
foreach ($csv_info as $info) {
list($company_id, $mi_paydate) = split("_", $info[2]);
if ($company_id && $company_id != "ETEL") {
$count++;
$invoice_sql = "select mi_ID,DATE_FORMAT(mi_paydate, '%W %M %D, %Y') as wiredate,companyname,email,username,password,ReferenceNumber,\n\t\t\tmi_title, mi_status, mi_deduction, mi_balance, mi_notes\n\t\t\t\n\t\t\tfrom `cs_merchant_invoice` left join cs_companydetails on mi_company_id = userId\n\t\t\tWHERE mi_paydate = '" . quote_smart($mi_paydate) . "' and mi_company_id = '" . quote_smart($company_id) . "'";
$result = sql_query_read($invoice_sql);
if ($invoiceInfo = mysql_fetch_assoc($result)) {
$mi_status = 'Pending';
$mi_ID = intval($invoiceInfo['mi_ID']);
$emailData = array();
$emailData["companyname"] = $invoiceInfo['companyname'];
$emailData["username"] = $invoiceInfo['username'];
$emailData["password"] = $invoiceInfo['password'];
