# encoding: utf-8
require 'spec_helper'
require 'date'


describe "Flexi Record" do

  it "Create" do
    fr = Osm::FlexiRecord.new(
      :id => 1,
      :section_id => 2,
      :name => 'name'
    )
    fr.id.should == 1
    fr.section_id.should == 2
    fr.name.should == 'name'
    fr.valid?.should be_true
  end

  describe "FlexiRecord::Column" do

    it "Create" do
      field = Osm::FlexiRecord::Column.new(
        :id => "f_1",
        :name => "Field Name",
        :editable => true,
        :flexi_record => Osm::FlexiRecord.new(),
      )

      field.id.should == 'f_1'
      field.name.should == 'Field Name'
      field.editable.should be_true
      field.valid?.should be_true
    end

    it "Sorts by flexirecord then id (system first then user)" do
      frc1 = Osm::FlexiRecord::Column.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 1), :id => 'f_1')
      frc2 = Osm::FlexiRecord::Column.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :id => 'a')
      frc3 = Osm::FlexiRecord::Column.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :id => 'b')
      frc4 = Osm::FlexiRecord::Column.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :id => 'f_1')
      frc5 = Osm::FlexiRecord::Column.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :id => 'f_2')

      columns = [frc3, frc2, frc1, frc5, frc4]
      columns.sort.should == [frc1, frc2, frc3, frc4, frc5]
    end

  end


  describe "FlexiRecord::Data" do

    it "Create" do
      rd = Osm::FlexiRecord::Data.new(
        :member_id => 1,
        :grouping_id => 2,
        :fields => {
          'firstname' => 'First',
          'lastname' => 'Last',
          'dob' => Date.new(1899, 11, 30),
          'total' => 3,
          'completed' => nil,
          'age' => nil,
          'f_1' => 'a',
          'f_2' => 'b',
        },
        :flexi_record => Osm::FlexiRecord.new()
      )

      rd.member_id.should == 1
      rd.grouping_id.should == 2
      rd.fields.should == {
        'firstname' => 'First',
        'lastname' => 'Last',
        'dob' => Date.new(1899, 11, 30),
        'total' => 3,
        'completed' => nil,
        'age' => nil,
        'f_1' => 'a',
        'f_2' => 'b',
      }
      rd.valid?.should be_true
    end

    it "Sorts by flexirecord, grouping_id then member_id" do
      frd1 = Osm::FlexiRecord::Data.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 1), :grouping_id => 1, :member_id => 1)
      frd2 = Osm::FlexiRecord::Data.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :grouping_id => 1, :member_id => 1)
      frd3 = Osm::FlexiRecord::Data.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :grouping_id => 2, :member_id => 1)
      frd4 = Osm::FlexiRecord::Data.new(:flexi_record => Osm::FlexiRecord.new(:section_id => 2), :grouping_id => 2, :member_id => 2)

      datas = [frd3, frd2, frd1, frd4]
      datas.sort.should == [frd1, frd2, frd3, frd4]
    end

  end


  it "Sorts by section ID then name" do
    fr1 = Osm::FlexiRecord.new(:section_id => 1, :name => 'A')
    fr2 = Osm::FlexiRecord.new(:section_id => 2, :name => 'B')
    fr3 = Osm::FlexiRecord.new(:section_id => 2, :name => 'C')
    records = [fr2, fr1, fr3]

    records.sort.should == [fr1, fr2, fr3]
  end


  describe "Using the API" do

    before :each do
      @flexi_record = Osm::FlexiRecord.new(:section_id => 1, :id => 2, :name => 'A Flexi Record')
    end

    it "Fetch Fields" do
      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[{\"id\":\"f_1\",\"name\":\"Field 1\",\"width\":\"150\"},{\"id\":\"f_2\",\"name\":\"Field 2\",\"width\":\"150\"}]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => [
            {"name" => "Field 1","field" => "f_1","width" => "150px","editable" => true},
            {"name" => "Filed 2","field" => "f_2","width" => "150px","editable" => true},
          ]}
        ]
      }
      FakeWeb.register_uri(:post, "https://www.onlinescoutmanager.co.uk/extras.php?action=getExtra&sectionid=1&extraid=2", :body => data.to_json, :content_type => 'application/json')

      fields = @flexi_record.get_columns(@api)
      fields.is_a?(Array).should be_true
      fields[0].valid?.should be_true
      fields[0].id.should == 'firstname'
      fields[1].id.should == 'lastname'
      fields[2].id.should == 'f_1'
      fields[3].id.should == 'f_2'
    end

    it "Add field (success)" do
      url = "https://www.onlinescoutmanager.co.uk/extras.php?action=addColumn&sectionid=1&extraid=2"

      post_data = {
        'apiid' => @CONFIGURATION[:api][:osm][:id],
        'token' => @CONFIGURATION[:api][:osm][:token],
        'userid' => 'user_id',
        'secret' => 'secret',
        'columnName' => 'name',
      }

      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[{\"id\":\"f_1\",\"name\":\"name\",\"width\":\"150\"}]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => [
            {"name" => "name","field" => "f_1","width" => "150px","editable" => true},
          ]}
        ]
      }
      HTTParty.should_receive(:post).with(url, {:body => post_data}) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }

      @flexi_record.add_column(@api, 'name').should be_true
    end

    it "Add field (failure)" do
      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => [
          ]}
        ]
      }
      HTTParty.should_receive(:post) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }

      @flexi_record.add_column(@api, 'name').should be_false
    end

    it "Update field (success)" do
      url = "https://www.onlinescoutmanager.co.uk/extras.php?action=renameColumn&sectionid=1&extraid=2"

      post_data = {
        'apiid' => @CONFIGURATION[:api][:osm][:id],
        'token' => @CONFIGURATION[:api][:osm][:token],
        'userid' => 'user_id',
        'secret' => 'secret',
        'columnId' => 'f_1',
        'columnName' => 'name',
      }

      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[{\"id\":\"f_1\",\"name\":\"name\",\"width\":\"150\"}]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => [
            {"name" => "name","field" => "f_1","width" => "150px","editable" => true},
          ]}
        ]
      }
      HTTParty.should_receive(:post).with(url, {:body => post_data}) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }

      col = Osm::FlexiRecord::Column.new(
        :flexi_record => @flexi_record,
        :id => 'f_1',
        :name => 'name',
        :editable => true
      )
      col.update(@api).should be_true
    end

    it "Update field (failure)" do
      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => [
          ]}
        ]
      }
      HTTParty.should_receive(:post) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }

      col = Osm::FlexiRecord::Column.new(
        :flexi_record => @flexi_record,
        :id => 'f_1',
        :name => 'name',
        :editable => true
      )
      col.update(@api).should be_false
    end

    it "Update field (uneditable)" do
      col = Osm::FlexiRecord::Column.new(
        :flexi_record => @flexi_record,
        :id => 'f_1',
        :name => 'name',
        :editable => false
      )
      expect{ col.update(@api) }.to raise_error(Osm::Forbidden)
    end

    it "Delete field (success)" do
      url = "https://www.onlinescoutmanager.co.uk/extras.php?action=deleteColumn&sectionid=1&extraid=2"

      post_data = {
        'apiid' => @CONFIGURATION[:api][:osm][:id],
        'token' => @CONFIGURATION[:api][:osm][:token],
        'userid' => 'user_id',
        'secret' => 'secret',
        'columnId' => 'f_1',
      }

      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => []}
        ]
      }

      HTTParty.should_receive(:post).with(url, {:body => post_data}) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }

      col = Osm::FlexiRecord::Column.new(
        :flexi_record => @flexi_record,
        :id => 'f_1',
        :name => 'name',
        :editable => true
      )
      col.delete(@api).should be_true
    end

    it "Delete field (failure)" do
      data = {
        "extraid" => "2",
        "sectionid" => "1",
        "name" => "A Flexi Record",
        "config" => "[{\"id\":\"f_1\",\"name\":\"name\",\"width\":\"150\"}]",
        "total" => "none",
        "extrafields" => "[]",
        "structure" => [
          {
            "rows" => [
              {"name" => "First name","field" => "firstname","width" => "150px"},
              {"name" => "Last name","field" => "lastname","width" => "150px"},
            ],
            "noscroll" => true
          },
          {"rows" => [
          ]}
        ]
      }
      HTTParty.should_receive(:post) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }

      col = Osm::FlexiRecord::Column.new(
        :flexi_record => @flexi_record,
        :id => 'f_1',
        :name => 'name',
        :editable => true
      )
      col.delete(@api).should be_false
    end

    it "Delete field (uneditable)" do
      col = Osm::FlexiRecord::Column.new(
        :flexi_record => @flexi_record,
        :id => 'f_1',
        :name => 'name',
        :editable => false
      )
      expect{ col.delete(@api) }.to raise_error(Osm::Forbidden)
    end

    it "Fetch Data" do
      data = {
        'identifier' => 'scoutid',
        'label' => "name",
        'items' => [{
          "scoutid" => "1",
          "firstname" => "First",
          "lastname" => "Last",
          "dob" => "",
          "patrolid" => "2",
          "total" => "",
          "completed" => "",
          "f_1" => "A",
          "f_2" => "B",
          "age" => "",
          "patrol" => "Green"
        }]
      }
      FakeWeb.register_uri(:post, "https://www.onlinescoutmanager.co.uk/extras.php?action=getExtraRecords&sectionid=1&extraid=2&termid=3&section=cubs", :body => data.to_json, :content_type => 'application/json')
      Osm::Section.stub(:get) { Osm::Section.new(:id => 1, :type => :cubs) }

      records = @flexi_record.get_data(@api, 3)
      records.is_a?(Array).should be_true
      records.size.should == 1
      record = records[0]
      record.member_id.should == 1
      record.grouping_id.should == 2
      record.fields.should == {
        'firstname' => 'First',
        'lastname' => 'Last',
        'dob' => nil,
        'total' => nil,
        'completed' => nil,
        'age' => nil,
        'f_1' => 'A',
        'f_2' => 'B',
      }
      record.valid?.should be_true
    end


    it "Update data (success)" do
      url = "https://www.onlinescoutmanager.co.uk/extras.php?action=updateScout"

      post_data = {
        'apiid' => @CONFIGURATION[:api][:osm][:id],
        'token' => @CONFIGURATION[:api][:osm][:token],
        'userid' => 'user_id',
        'secret' => 'secret',
        'termid' => 3,
        'scoutid' => 4,
        'column' => 'f_1',
        'value' => 'value',
        'sectionid' => 1,
        'extraid' => 2,
      }

      data = {
        'items' => [
          {'f_1' => 'value', 'scoutid' => '4'},
        ]
      }
      HTTParty.should_receive(:post).with(url, {:body => post_data}) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }
      Osm::Term.stub(:get_current_term_for_section) { Osm::Term.new(:id => 3) }

      fr = Osm::FlexiRecord.new(:section_id => 1, :id => 2)
      fr.stub(:get_columns) { [Osm::FlexiRecord::Column.new(:id => 'f_1', :editable => true)] }
      fr_data = Osm::FlexiRecord::Data.new(
        :flexi_record => fr,
        :member_id => 4,
        :grouping_id => 5,
        :fields => {'f_1' => '', 'f_2' => 'value'}
      )
      fr_data.fields['f_1'] = 'value'
      fr_data.update(@api).should be_true
    end

    it "Update data (failed)" do
      data = {
        'items' => [
          {'f_1' => 'old value', 'scoutid' => '4'},
        ]
      }

      HTTParty.stub(:post) { OsmTest::DummyHttpResult.new(:response=>{:code=>'200', :body=>data.to_json}) }
      Osm::Term.stub(:get_current_term_for_section) { Osm::Term.new(:id => 1) }

      fr = Osm::FlexiRecord.new(:section_id => 1, :id => 2)
      fr.stub(:get_columns) { [Osm::FlexiRecord::Column.new(:id => 'f_1', :editable => true)] }

      fr_data = Osm::FlexiRecord::Data.new(
        :flexi_record => fr,
        :member_id => 4,
        :grouping_id => 5,
        :fields => {'f_1' => 'old value'}
      )
      fr_data.fields['f_1'] = 'new value'
      fr_data.update(@api).should be_false
    end

    it "Update data (uneditable field)" do
      Osm::Term.stub(:get_current_term_for_section) { Osm::Term.new(:id => 1) }

      fr = Osm::FlexiRecord.new(:section_id => 1, :id => 2)
      fr.stub(:get_columns) { [Osm::FlexiRecord::Column.new(:id => 'f_1', :editable => false)] }

      fr_data = Osm::FlexiRecord::Data.new(
        :flexi_record => fr,
        :member_id => 4,
        :grouping_id => 5,
        :fields => {'f_1' => 'value'}
      )
      fr_data.update(@api).should be_true
    end


    it "Handles the total row" do
      data = {
        'identifier' => 'scoutid',
        'label' => "name",
        'items' => [{
          "scoutid" => "-1",
          "firstname" => "TOTAL",
          "lastname" => "",
          "dob" => "",
          "patrolid" => "-1",
          "total" => 100,
          "completed" => 0,
          "f_1" => 25,
          "f_2" => 75,
          "age" => "",
          "patrol" => ""
        },{
          "scoutid" => "1",
          "firstname" => "First",
          "lastname" => "Last",
          "dob" => "",
          "patrolid" => "2",
          "total" => "",
          "completed" => "",
          "f_1" => "A",
          "f_2" => "B",
          "age" => "",
          "patrol" => "Green"
        }]
      }
      FakeWeb.register_uri(:post, "https://www.onlinescoutmanager.co.uk/extras.php?action=getExtraRecords&sectionid=1&extraid=2&termid=3&section=cubs", :body => data.to_json, :content_type => 'application/json')
      Osm::Section.stub(:get) { Osm::Section.new(:id => 1, :type => :cubs) }

      records = @flexi_record.get_data(@api, 3)
      records.is_a?(Array).should be_true
      records.size.should == 1
      record = records[0]
      record.member_id.should == 1
      record.grouping_id.should == 2
      record.fields['firstname'].should == 'First'
      record.fields['lastname'].should == 'Last'
    end

  end

  describe "API Strangeness" do

    it "Calculated columns containing numbers not strings" do
      data = {
        'identifier' => 'scoutid',
        'label' => "name",
        'items' => [{
          "scoutid" => "1",
          "firstname" => "First",
          "lastname" => "Last",
          "dob" => "",
          "patrolid" => "2",
          "total" => 3,
          "completed" => 4,
          "f_1" => "A",
          "f_2" => "B",
          "age" => "",
          "patrol" => "Green"
        }]
      }
      FakeWeb.register_uri(:post, "https://www.onlinescoutmanager.co.uk/extras.php?action=getExtraRecords&sectionid=1&extraid=2&termid=3&section=cubs", :body => data.to_json, :content_type => 'application/json')
      Osm::Section.stub(:get) { Osm::Section.new(:id => 1, :type => :cubs) }

      flexi_record = Osm::FlexiRecord.new(:section_id => 1, :id => 2, :name => 'A Flexi Record')
      records = flexi_record.get_data(@api, 3)
      record = records[0]
      record.fields['total'].should == 3
      record.fields['completed'].should == 4
    end

  end

end