Skip to content

Instantly share code, notes, and snippets.

@tomredsky
Created June 14, 2018 08:48
Show Gist options
  • Save tomredsky/1ba3f9d0353b780405de848e6c4cf4c9 to your computer and use it in GitHub Desktop.
Save tomredsky/1ba3f9d0353b780405de848e6c4cf4c9 to your computer and use it in GitHub Desktop.
Nightly check on state of CM.iCS column
#!perl
use v5.22;
use warnings;
use Test::More;
use FindBin;
use lib "$FindBin::Bin/../xt/lib";
use JunoTest::Database;
my %tests = (
AGEEAS00 => 'Y',
ATLPRE00 => 'N',
EASYPX00 => 'Y',
GAOIMA00 => 'N',
GULSER00 => 'Y',
INDIGO01 => 'Y',
INMAGE00 => 'Y',
LATMEX00 => 'Y',
LATSTO00 => 'Y',
MULTIB00 => 'Y',
PHOSTO00 => 'Y',
STOPHO00 => 'N',
TOPPHO00 => 'N',
YOONIQ00 => 'Y',
);
my @codes = keys %tests;
my $schema = juno_db_schema();
my @companies = $schema->customers->search(
{
cod => { -in => \@codes},
})->all;
for my $comp (@companies) {
is $comp->tax_withholding, $tests{$comp->customer_code}, "Withhold tax is correct";
}
done_testing;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment