Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 21st, 2012  |  syntax: None  |  size: 2.90 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. # in models/jc/invoice.rb
  2.  
  3. module JC
  4.   class Invoice
  5.     include FmStore::Layout
  6.  
  7.     set_layout "Invoice"
  8.     set_database "AR[jr]"
  9.  
  10.     belongs_to :project, :reference_key => "project_id"
  11.  
  12.     begin :FIELDS
  13.       field :service_code,       String, :fm_name => "srid"
  14.       field :invoice_id,         String, :fm_name => "invoice id", :identity => true
  15.       field :work_month,         String, :fm_name => "wk month"
  16.       field :work_year,          String, :fm_name => "wkyear"
  17.       field :company_id,         String, :fm_name => "clid"
  18.       field :project_id,         String, :fm_name => "ptid"
  19.       field :group_invoice,      String, :fm_name => "invoice no"
  20.       field :invoice_date,       Date,   :fm_name => "invoice date"
  21.       field :bill_month,         String, :fm_name => "bill month"
  22.       field :bill_year,          String, :fm_name => "bill year"
  23.       field :outstanding_amt,    String, :fm_name => "os amt"
  24.       field :receipt_date,       Date,   :fm_name => "receipt date.1"
  25.       field :amt_payable,        String, :fm_name => "amt payable"
  26.       field :amt_payable_w_gst,  String, :fm_name => "amt payable w gst"
  27.       field :gst_amt,            String, :fm_name => "gst amt"
  28.       field :cn_amt,             String, :fm_name => "cn amt"
  29.       field :cn_gst,             String, :fm_name => "cn gst"
  30.       field :total_cn_w_gst_raw, String, :fm_name => "credit note table::total cn w gst"
  31.       field :dn_amt,             String, :fm_name => "dn amt"
  32.       field :dn_gst,             String, :fm_name => "dn gst"
  33.       field :total_dn_w_gst_raw,     String, :fm_name => "debit note table::total dn w gst"
  34.       field :nett_payable,       String, :fm_name => "nett payable"
  35.       field :total_gst,          String, :fm_name => "total gst"
  36.       field :nett_payable_w_gst, String, :fm_name => "nett payable w gst"
  37.       field :project_title,      String, :fm_name => "project"
  38.       field :candidate,          String, :fm_name => "candidate"
  39.       field :candidate_id,       String, :fm_name => "caid"
  40.       field :job_title,          String, :fm_name => "job title"
  41.       field :modify_date,        Date,   :fm_name => "modify date"
  42.     end
  43.   end
  44. end
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51. # in project.rb
  52.  
  53. class Project
  54.   include FmStore::Layout
  55.  
  56.   set_layout "ProjectTeam_main"
  57.   set_database "master client"
  58.  
  59.   belongs_to :company, :reference_key => "company_id"
  60.  
  61.   # FIXME - this may be wrong, because we are representing a single email for an employer, not CTID!
  62.   # So what happen if the employer has 3 companies and thus 3 CTID but we do not keep that CTID.
  63.   belongs_to :employer, :class_name => "Employer::FmContact", :reference_key => "employer_id"
  64.  
  65.   has_many :employments, :reference_key => "project_id"
  66.   has_many :privileges, :reference_key => "project_id"
  67.  
  68.   # has_many :invoices, :reference_key => "project_id"
  69.   has_many :invoices, :class => "JC::Invoice", :reference_key => "project_id"
  70. end
create a new version of this paste RAW Paste Data