Ok, Eric you are in there! Paul
2010/4/26 Eric Cho <e.ch...@yahoo.com>: > Oh. Thanks. > > This is my address for twitter. I hope you add this there. > > http://twitter.com/myfoxfree > > Appreciate! > > -Eric > > > ________________________________ > From: Paul Yasi <p...@coffeebuzz.com> > To: For users of CitrusDB discussion <citrusdb-users@lists.sourceforge.net> > Sent: Tue, April 27, 2010 8:58:38 AM > Subject: Re: [Citrusdb-users] I got error during conduct refund. > > I've added this code in there now. I also added your name to the code > contributor list. Do you have a domain name you would like listed > next to your name? > > http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/revision/242 > > Thanks, > > Paul > > 2010/4/26 Eric Cho <e.ch...@yahoo.com>: >> Oh sorry. >> >> I forgot to attach my code in tools/refund.php >> >> As at #2, I made this codes at line 46~ >> >> if ($refundamount == 0) { >> $query = "UPDATE billing_details SET >> refund_amount = 0.00, >> refund_date = null >> WHERE id = $detailid"; >> $result = $DB->Execute($query) or die ("$query Query Failed"); >> >> } else { >> >> $query = "UPDATE billing_details SET >> refund_amount = '$refundamount', >> refund_date = CURRENT_DATE >> WHERE id = $detailid"; >> $result = $DB->Execute($query) or die ("$query Query Failed"); >> } >> >> So I could cancel refunding by put price as 0.. before actually refund >> when >> I click refund button in tools menu. >> >> Please take a look this. >> >> Thanks. >> >> -Eric >> >> >> >> >> ________________________________ >> From: Eric Cho <e.ch...@yahoo.com> >> To: For users of CitrusDB discussion >> <citrusdb-users@lists.sourceforge.net> >> Sent: Mon, April 26, 2010 5:51:41 PM >> Subject: Re: [Citrusdb-users] I got error during conduct refund. >> >> Thanks for your reply. >> >> #1, >> >> As I tried 'creditcard' instead of 'prepaycc', it works well same as >> 'prepaycc'. (almostly 100% for me) >> >> What's exactly differences 'creditcard' and 'prepaycc'?? >> >> I could use both, since I can control billing date (upcoming). >> >> >> #2, >> >> When I tried refund I couldn't find a message such "You must manually >> process ... that you said. >> >> Anyway, I added exception code for cancel refunding before executing >> refund >> button in tools menu. >> >> (Since I will use it in a batch process on a regular basis.) >> >> I hope it helps you even less :) >> >> >> Thanks in everytime. >> >> Regards. >> >> -Eric >> >> >> >> ________________________________ >> From: Paul Yasi <p...@coffeebuzz.com> >> To: For users of CitrusDB discussion >> <citrusdb-users@lists.sourceforge.net> >> Sent: Mon, April 26, 2010 9:02:33 AM >> Subject: Re: [Citrusdb-users] I got error during conduct refund. >> >> Item 1: Refunds do not currently work for prepaycc billing types, >> only normal monthly creditcard bills. When you went into the refund >> report to indicate the amount of the refund it would have came back >> with a message: "You must manually process a refund for this billing >> method" Prepaycc had sort of been deprecated as a billing type since >> it's somewhat useless, except that is prevents the customer from being >> charged again in X months automatically if their previous billing >> failed. >> >> Item 2: the way it handle's importing prepaycc billing types is a bug, >> however the right fix for this is to change the importcc code that >> inserts into payment_history to always indicate a creditcard payment >> type instead of looking to whatever billing method is being used, >> since the import credit card tool will always be importing credit card >> payments. A prepaycc billing type is still paid with a creditcard >> payment type. Billing type and Payment Type are two different things. >> >> I just commited this change shown here: >> http://bazaar.launchpad.net/%7Epaul-citrusdb/citrusdb/gpg/revision/240 >> >> Item 3: My own card software gives me an "N" and some other software I >> had gave a "38" as a code, so I just have that in there for myself. >> >> Paul >> >> 2010/4/24 Eric Cho <e.ch...@yahoo.com>: >>> Hello. >>> >>> I did some of test for CitrusDB. >>> >>> I'm using that based on prepaycc (pre-pay Credit card), everything was >>> fine >>> but refund. >>> >>> When I tried to refund in the Billing's refund menu >>> >>> >>> (http://localhost/citrus-2.1/index.php?load=refund&type=tools&billingid=45&submit=Submit), >>> >>> That records didn't exported when I tried export for one text file in the >>> http://localhost/citrus-2.1/index.php?load=refundcc&type=tools . >>> >>> (There's result file for that but content was empty.) >>> >>> >>> >>> So, I analyzed related source, I found something miss. >>> >>> 1. refunded = 'y' shouldn't do there, because refund export page works as >>> loading refunded<>'y' >>> >>> tools/refund.php line 51~61 has been changed as commentation. >>> >>> 2. DB scheme. >>> >>> DROP TABLE IF EXISTS `payment_history`; >>> >>> CREATE TABLE `payment_history` ( >>> `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, >>> `creation_date` DATE NOT NULL DEFAULT '0000-00-00', >>> `transaction_code` VARCHAR(32) DEFAULT NULL, >>> `billing_id` INT(11) NOT NULL DEFAULT '0', >>> `creditcard_number` VARCHAR(16) DEFAULT NULL, >>> `creditcard_expire` INT(4) UNSIGNED ZEROFILL DEFAULT NULL, >>> `billing_amount` DECIMAL(9,2) DEFAULT NULL, >>> `response_code` VARCHAR(100) DEFAULT NULL, >>> `paid_from` DATE NOT NULL DEFAULT '0000-00-00', >>> `paid_to` DATE NOT NULL DEFAULT '0000-00-00', >>> `invoice_number` INT(128) DEFAULT NULL, >>> `status` >>> >>> >>> SET('authorized','declined','pending','donotreactivate','collections','turnedoff','credit','canceled','cancelwfee','pastdue','noticesent','waiting') >>> DEFAULT NULL, >>> `payment_type` >>> SET('creditcard','prepaycc','check','cash','eft','nsf','discount') >>> DEFAULT >>> NULL, >>> `check_number` VARCHAR(32) DEFAULT NULL, >>> `avs_response` VARCHAR(32) DEFAULT NULL, >>> PRIMARY KEY (`id`), >>> KEY `billing_id_index` (`billing_id`) >>> ) ENGINE=MYISAM AUTO_INCREMENT=142 DEFAULT CHARSET=latin1; >>> >>> (To sum up, there's only change of adding one enum for payment_type >>> column >>> as 'prepaycc' next to 'creditcard') >>> >>> >>> >>> 3. Not solved yet, I passed this step by wrote response as 'No' in the >>> import file. >>> >>> tools/importcc.php line 79~ >>> >>> if ($response_id == 'N') { if ($transaction_code == 'CREDIT' OR >>> $transaction_code == '38') { >>> >>> It's weird.. CREDIT (Refund) is suppose to be 'N' as response ?? >>> >>> I wonder whether that is your intention or not. >>> >>> >>> >>> My object of this mail is confirm that is whether good approach, and if >>> so, >>> willing to help for you. >>> >>> Please let me know if there's something wrong >>> >>> Have a good weekend! :) >>> >>> Regards. >>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Citrusdb-users mailing list >>> Citrusdb-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users >>> >>> >> >> >> >> -- >> The CitrusDB Project | http://www.citrusdb.org >> Open Source Customer Care & Billing System >> >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> Citrusdb-users mailing list >> Citrusdb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users >> >> >> >> >> ------------------------------------------------------------------------------ >> >> _______________________________________________ >> Citrusdb-users mailing list >> Citrusdb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users >> >> > > > > -- > The CitrusDB Project | http://www.citrusdb.org > Open Source Customer Care & Billing System > > ------------------------------------------------------------------------------ > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care & Billing System ------------------------------------------------------------------------------ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
