function insertPayments($id, User $u)
{
$data = $this->db_yourmembers->selectPage($total, "select t.*, a.name as action from ?_ym_transaction t left join ?_ym_transaction_action a on t.action_id = a.id where user_id=? order by unixtime", $id);
$data = $data ? $data : array();
$payments = array();
foreach ($data as $d) {
if (!isset($payments[$d['transaction_id']])) {
$payments[$d['transaction_id']] = new YourMembers_Transaction($u);
}
$payments[$d['transaction_id']]->addTransactionData($d);
}
InvoiceCreator_Abstract::factory('standard', $this->db_yourmembers)->process($u, $payments);
}
function insertPayments($id, User $u)
{
$payments = $this->db_oss->select("\n select * \n from ?_payments p left join ?_payments_products pr on p.ID = pr.PaymentId \n where payment_system_code = 'paypal' and Status='completed' and UserID=? and Details like '%subscr_payment%'", $id);
$payments = $payments ? $payments : array();
//to add access if exists
$byPs = array('paypal' => array());
foreach ($payments as $p) {
$byPs['paypal'][] = $p;
}
foreach ($byPs as $paysys_id => $list) {
InvoiceCreator_Abstract::factory($paysys_id, $this->db_oss)->process($u, $list);
}
}
function insertPayments($member_id, User $u)
{
/**
* worldpay,safepay,metacharge,alertpay,localweb sets ORIG_ID to parent transaction
*
* paypal_pro sets $payment['data']['PAYPAL_PROFILE_ID']
*
* additional_access by product settings:
* $newp['receipt_id'] = 'ADDITIONAL ACCESS:' . $payment['receipt_id'];
* $newp['data'][0]['ORIG_ID'] = $payment_id;
*
*
*/
$payments = $this->db3->select("SELECT * FROM ?_payments \n WHERE member_id={$member_id} \n AND (completed > 0 OR receipt_id > '')\n AND (paysys_id <> '')\n ORDER BY payment_id");
$byPs = array();
foreach ($payments as $payment_id => $p) {
$p['data'] = @unserialize($p['data']);
$byPs[$p['paysys_id']][] = $p;
}
foreach ($byPs as $paysys_id => $list) {
InvoiceCreator_Abstract::factory($paysys_id)->process($u, $list);
}
// if ($payments)
// $u->checkSubscriptions(true);
}
function insertPayments($id, User $u)
{
$payments = $this->db_dap->select("SELECT t.*, u.id AS user_id FROM ?_transactions t\n LEFT JOIN ?_users u \n ON IF(u.paypal_email IS NULL OR u.paypal_email = '', u.email = t.payer_email, u.paypal_email = t.payer_email)\n WHERE u.id={$id}\n AND t.status IN (1,5)\n AND t.trans_type = 'subscr_payment'\n AND t.payment_status = 'Completed'\n ORDER BY t.id");
$payments = $payments ? $payments : array();
//to add access if exists
$byPs = array('paypal' => array());
foreach ($payments as $p) {
$byPs['paypal'][] = $p;
}
foreach ($byPs as $paysys_id => $list) {
InvoiceCreator_Abstract::factory($paysys_id, $this->db_dap)->process($u, $list);
}
}
function doWork(&$context)
{
$maxImported = (int) $this->getDi()->db->selectCell("SELECT `value` FROM ?_data\n WHERE `table`='user' AND `key`='wom:id'\n ORDER BY `id` DESC LIMIT 1");
$count = @$this->options['count'];
if ($count) {
$count -= $context;
}
if ($count < 0) {
return true;
}
$q = $this->db_wordpress->queryResultOnly("\n SELECT\n u.*,\n um1.meta_value as first_name,\n um2.meta_value as last_name,\n um3.meta_value as wp_optimizemember_subscr_gateway,\n um4.meta_value as wp_optimizemember_subscr_id,\n um5.meta_value as wp_optimizemember_paid_registration_times\n FROM ?_users u\n LEFT JOIN ?_usermeta um1 on u.ID = um1.user_id and um1.meta_key = 'first_name'\n LEFT JOIN ?_usermeta um2 on u.ID = um2.user_id and um2.meta_key = 'last_name'\n LEFT JOIN ?_usermeta um3 on u.ID = um3.user_id and um3.meta_key = 'wp_optimizemember_subscr_gateway'\n LEFT JOIN ?_usermeta um4 on u.ID = um4.user_id and um4.meta_key = 'wp_optimizemember_subscr_id'\n LEFT JOIN ?_usermeta um5 on u.ID = um5.user_id and um5.meta_key = 'wp_optimizemember_paid_registration_times'\n WHERE u.ID > ?d \n ORDER BY u.ID\n {LIMIT ?d} ", $maxImported, $count ? $count : DBSIMPLE_SKIP);
while ($r = $this->db_wordpress->fetchRow($q)) {
if (!$this->checkLimits()) {
return;
}
$u = $this->getDi()->userRecord;
$u->email = $r['user_email'];
$u->added = $r['user_registered'];
$u->login = $r['user_login'];
$u->name_f = (string) $r['first_name'];
$u->name_l = (string) $r['last_name'];
$u->is_approved = 1;
$u->data()->set('wom:id', $r['ID']);
$u->data()->set('signup_email_sent', 1);
// do not send signup email second time
$u->pass = $r['user_pass'];
if (@$this->options['keep_user_id']) {
$u->disableInsertPkCheck(true);
$u->user_id = $r['ID'];
}
try {
if (@$this->options['keep_user_id']) {
$u->insert(false)->refresh();
} else {
$u->insert();
}
if ($r['wp_optimizemember_subscr_gateway']) {
InvoiceCreator_Abstract::factory($r['wp_optimizemember_subscr_gateway'], $this->db_wordpress)->process($u, $r);
} elseif ($r['wp_optimizemember_paid_registration_times']) {
InvoiceCreator_Abstract::factory('Manual', $this->db_wordpress)->process($u, $r);
}
$context++;
} catch (Am_Exception_Db_NotUnique $e) {
echo "Could not import user: "******"<br />\n";
}
}
return true;
}
function insertPayments($id, User $u)
{
$payments = $this->db_ipb_nexus->select("\n SELECT p.ps_id, i.i_id, p.ps_start, p.ps_expire, p.ps_item_id, i.i_member, i.i_total, i.i_date, i.i_paid\n FROM ?_nexus_purchases p\n LEFT JOIN ?_nexus_invoices i ON p.ps_original_invoice = i.i_id\n WHERE\n i.i_member = {$id}\n AND i.i_status = 'paid'\n ORDER BY i_id\n ");
if (empty($payments)) {
return false;
}
InvoiceCreator_Abstract::factory('ccbill', $this->db_ipb_nexus)->process($u, $payments);
return true;
}
function insertPayments($id, User $u)
{
$payments = $this->db_drupal->select("\n select p.*, o.created as order_created,\n o.order_key as order_key,\n o.status as order_status,\n o.modified as order_modified\n from ?_ms_payments p left join ?_ms_orders o using(oid)\n where o.uid = ?\n order by p.pid desc", $id);
$payments = $payments ? $payments : array();
//to add access if exists
InvoiceCreator_Abstract::factory('standard', $this->db_drupal)->process($u, $payments);
}
function insertPayments($id, User $u)
{
$payments = $this->db_wordpress->select("\n(select concat('tr', transaction_ID) as id, transaction_subscription_ID as sub_id, transaction_user_ID as user_id, transaction_paypal_ID as txn_id, \ntransaction_total_amount as amount, transaction_status as status, '' as startdate, '' as expirydate, transaction_stamp as stamp , transaction_currency as currency from ?_m_subscription_transaction where transaction_user_ID=?)\nunion \n(select concat('rel', rel_id) as id, sub_id, user_id, '' as txn_id, 0 as amount, 'Access', startdate, expirydate, 0 as stamp, '' as currency from ?_m_membership_relationships where user_id =?)\norder by user_id desc\n", $id, $id);
$payments = $payments ? $payments : array();
//to add access if exists
InvoiceCreator_Abstract::factory('standard', $this->db_wordpress)->process($u, $payments);
}
