#!/usr/bin/perl

use strict;
use CGI;
use JSON;
use Storable qw (dclone);

use Opals::Context;
use Opals::Template qw(
  tmpl_read
  tmpl_write
  tmpl_rangedPageList
  tmpl_redirect
  tmpl_preference
);
use Opals::User qw(
  user_currentUserID
);

use Opals::Eq_Transfer;

use Opals::Equipment qw(
  eq_itemType_getList
);


use Opals::Log;
use JSON;

my $dbh = Opals::Context->dbh();
END { $dbh->disconnect(); }

my $cgi   = CGI->new;
my $input = $cgi->Vars();
my $eq_transfer = Opals::Eq_Transfer->new(dbh=>$dbh);

my ($permission, $cookieList, $template) =
  tmpl_read({ dbh => $dbh, cgi => $cgi, tmplFile => 'eqmnt/record/transferItem.tmpl', });

my $uIdInfo       = user_currentUserID($dbh, $cgi);
my $fieldList     = _eq_definition_getList();
my $transferList = $eq_transfer->eq_transfer_getList({pSize=>5,pNum=>1});

my $fieldMap ={};
foreach my $f(@$fieldList){
  $fieldMap->{$f->{'id'}}= {name=>$f->{'name'}, id=>$f->{'id'}};
}

my $buildingList = _eq_building_getList($dbh);

$template->param(
  fieldList     => to_json($fieldList),
  geFieldList   => to_json($fieldList),
  fieldMap      => to_json($fieldMap),
  buildingList  => ( ref($buildingList) eq 'ARRAY' && @{$buildingList} ? to_json($buildingList): '[]' ),
  transferList  => $transferList ? to_json($transferList): {} ,
);

tmpl_write($dbh, $cgi, $cookieList, $template);

#-----------------------------------------------------------------------

sub _eq_definition_getList {
  my ($dbh, $sf) = @_;
  my @retList = ();
  @retList = (
    { id => "eq_barcode", defType => "item",   name => "Barcode",                        selected => 1 },
    { id => "18",         defType => "item",   name => "Building Code",                  selected => 0 },
    { id => "31",         defType => "item",   name => "Date Acquired/Assigned/Install", selected => 0 },
    { id => "26",         defType => "item",   name => "District Code",                  selected => 0 },
    { id => "7",          defType => "item",   name => "District inventory #",           selected => 0 },
    { id => "eq_name",    defType => "record", name => "Equipment Name",                 selected => 0 },
    { id => "9",          defType => "item",   name => "Funding Source",                 selected => 0 },
    { id => "36",         defType => "record", name => "General Accessories Notes",      selected => 0 },
    { id => "33",         defType => "record", name => "General Notes",                  selected => 0 },
    { id => "43",         defType => "item",   name => "IP Address",                     selected => 0 },
    { id => "8",          defType => "item",   name => "Item Designation",               selected => 0 },
    { id => "38",         defType => "item",   name => "Items Status Notes",             selected => 0 },
    { id => "typeId",     defType => "item",   name => "Item Type",                      selected => 0 },
    { id => "11",         defType => "item",   name => "Location in building",           selected => 0 },
    { id => "1",          defType => "record", name => "Manufacturer",                   selected => 0 },
    { id => "16",         defType => "record", name => "Manufacturer URL",               selected => 0 },
    { id => "3",          defType => "record", name => "Model",                          selected => 0 },
    { id => "28",         defType => "record", name => "Online Manual",                  selected => 0 },
    { id => "42",         defType => "item",   name => "P.O. Number",                    selected => 0 },
    { id => "6",          defType => "item",   name => "Price ",                         selected => 0 },
    { id => "5",          defType => "item",   name => "Serial#",                        selected => 0 },
    { id => "47",         defType => "item",   name => "Slot Number",                    selected => 0 },
    { id => "45",         defType => "item",   name => "Software Key",                   selected => 0 },
    { id => "27",         defType => "record", name => "Supplier URL ",                  selected => 0 },
    { id => "39",         defType => "item",   name => "Vendor Name",                    selected => 0 },
    { id => "14",         defType => "record", name => "Warranty Notes",                 selected => 0 },
  );
  foreach my $r (@retList) {
    if ($r->{'id'} eq $sf) {
      $r->{'selected'} = 1;
    }
  }
  return \@retList;
}

sub _eq_building_getList {
    my ($dbh) = @_;
    my @list =();
    my $sql = 
    my $sql = (<<_SQL_) ;
select l.code as code, l.code as id, l.name as name 
from eq_locationDirectory l 
    order by l.name
_SQL_
    my $sth = $dbh->prepare($sql);
    $sth->execute();
    while(my $rec = $sth->fetchrow_hashref) {
        push @list, $rec;
    }
    $sth->finish;
    return \@list;
}
