| select distinct | |
| pt.id, | |
| pt.gig_id, | |
| pt.amount, | |
| pt.status, | |
| pt.created_at | |
| from payment_transactions pt | |
| join gigs g on g.id = pt.gig_id | |
| join gig_tip_logs pre_tip_log on pre_tip_log.gig_id = g.id and pre_tip_log.operation = 0 | |
| left join gig_tip_logs tip_confirmed_log on tip_confirmed_log.gig_id = g.id and tip_confirmed_log.operation = 1 |
People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |
| # | |
| # Domain Validator by Frank Rietta | |
| # (C) 2012 Rietta Inc. All Rights Reserved. | |
| # Licensed under terms of the BSD License. | |
| # | |
| # To use in a validation, add something like this to your model: | |
| # | |
| # validates :name, :domain => true | |
| # | |
| class DomainValidator < ActiveModel::EachValidator |