FieldDefLookupTable.cpp

/**************************************************************************
###########################################################################
##
## $SHOWOFFDB_BEGIN_LICENSE$
## Copyright (C) 2011 Lorimark Solutions, LLC and/or its subsidiary(-ies).
##  All rights reserved.
##  Contact: Lorimark Solutions, LLC (info@showoff-db.org)
##
## This file is part of the Showoff Database Application Framework.
##
##  Commercial Usage
##  Licensees holding valid ShowoffDB Commercial licenses may use this file in
##   accordance with the ShowoffDB Commercial License Agreement provided with the
##   Software or, alternatively, in accordance with the terms contained in
##   a written agreement between you and Lorimark Solutions, LLC.
##
## GNU Lesser General Public License Usage
##  Alternatively, this file may be used under the terms of the GNU Lesser
##   General Public License version 2.1 as published by the Free Software
##   Foundation and appearing in the file LICENSE.LGPL included in the
##   packaging of this file.  Please review the following information to
##   ensure the GNU Lesser General Public License version 2.1 requirements
##   will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
##
## In addition, as a special exception, Lorimark Solutions, LLC gives
##  you certain additional rights.  These rights are described in the
##  Lorimark Solutions, LLC ShowoffDB LGPL Exception version 1.0, included in
##  the file LGPL_EXCEPTION.txt in this package.
##
## GNU General Public License Usage
##  Alternatively, this file may be used under the terms of the GNU
##   General Public License version 3.0 as published by the Free Software
##   Foundation and appearing in the file LICENSE.GPL included in the
##   packaging of this file.  Please review the following information to
##   ensure the GNU General Public License version 3.0 requirements will be
##   met: http://www.gnu.org/copyleft/gpl.html.
##
## If you have questions regarding the use of this file, please contact
##   Lorimark Solutions, LLC at info@showoff-db.org.
## $SHOWOFFDB_END_LICENSE$
##
#############################################################################
****************************************************************************/

#include <Wt/WText.h>
#include <Wt/WDialog.h>
#include <Wt/WPushButton.h>
#include <Wt/WContainerWidget.h>
#include <Wt/WAbstractItemModel.h>
#include <Wt/WLineEdit.h>
#include <Wt/WVBoxLayout.h>
#include <Wt/WTableView.h>
#include <Wt/WModelIndex.h>

#include <Wtx/Core/Core.h>
#include <Wtx/Util/Util.h>

#include "FieldDefLookupTable.h"

namespace STATIC {

class TableView
: public Wt::WContainerWidget
{
  public:

    TableView();

    void setModel( const std::shared_ptr<Wt::WAbstractItemModel > & model );

    std::shared_ptr<Wt::WAbstractItemModel > m_model;

}; // endclass TableView

TableView::TableView()
: Wt::WContainerWidget()
{
}

void TableView::setModel( const std::shared_ptr<Wt::WAbstractItemModel > & model )
{
}


class TableLineEdit
: public Wt::WLineEdit
{
  public:

    TableLineEdit
    (
     int sid,
     std::shared_ptr<Wt::WAbstractItemModel> (*getModel)(int sid,int tid,const std::string & filter,Wtx::Dbo::Session & session),
     std::unique_ptr<Wt::WTableView> (*getTableView)(int sid,int tid,const std::string & filter,Wtx::Dbo::Session & session),
     Wtx::Dbo::Session & s
    )
    : m_session(s),
      m_sourceID(sid),
      m_getModel(getModel),
      m_getTableView(getTableView)
    {
      changed()   .connect( this, &TableLineEdit::on_changed   );
      focussed()  .connect( this, &TableLineEdit::on_focussed  );
//      textInput() .connect( this, &TableLineEdit::on_textInput );

    } // endSmartLineEdit( std::shared_ptr<Wt::WAbstractItemModel> model, Wtx::Dbo::Session & s )

    /*
    ** this returns the ID value of the string
    **
    */
    int find_id( const std::string & value )
    {
      int retVal = -1;
      int count = 0;
      if( m_model )
      {

        auto v = Wtx::Core::toupper( value );

        for( int i=0; i < m_model-> rowCount(); i++ )
        {
          auto id = Wt::asNumber(m_model-> index( i, 0 ).data());
          auto ky = Wtx::Core::toupper( Wt::asString(m_model-> index( i, 1 ).data()).toUTF8() );

          if( ky.find(v) != std::string::npos )
          {
            count++;
            retVal = id;
          }

          if( count > 1 )
            break;

        }

        if( count == 1 )
          return retVal;
      }

      return -1;

    } // endint get_id( const std::string & value )

    /*
    ** this returns the ID value of the string
    **
    */
    int get_id( const std::string & value )
    {
      if( m_model )
      {
        for( int i=0; i < m_model-> rowCount(); i++ )
        {
          auto id = Wt::asNumber(m_model-> index( i, 0 ).data());
          auto ky = Wt::asString(m_model-> index( i, 1 ).data()).toUTF8();

          if( value == ky )
          {
            return id;
          }

        }
      }

      return -1;

    } // endint get_id( const std::string & value )

    /*
    ** this returns the string value of the ID
    **
    */
    std::string get_string( int index )
    {
      if( m_model && index > -1 )
      {
        for( int i=0; i < m_model-> rowCount(); i++ )
        {
          auto id = Wt::asNumber( m_model-> index( i, 0 ).data() );
          auto ky = Wt::asString( m_model-> index( i, 1 ).data() ).toUTF8();

          if( index == id )
          {
            return ky;
          }

        }

      }

      return "";

    } // endstd::string get_string( int index )

    /*
    ** this is kind of crummy.  this is supposed to load
    **  the model, but if an .id. value is specified then
    **  its supposed to only load that id.  but if no .id.
    **  is specified (id==-1) then this is supposed to
    **  load the _whole_ model.  The idea being, it should
    **  not load the model until it's absolutely necessary.
    **  the concept is that we only need to load one item
    **  out of the model if we're just loading the widget.
    **  we only need 1 item to get the widget loaded, to
    **  convert the id number in to a string-value.  but
    **  if the user never selects this control, then there's
    **  no reason to load ALL the data, it just slows down
    **  the user interface. this is my best attempt at
    **  lazy-loading.
    **
    */
    void loadModel( int id, const std::string & filter )
    {
      if( !m_loaded && m_getModel )
      {
//        std::cout << __FILE__ << ":" << __LINE__ << " Loading Model: " << id << " " << m_sourceID << " " << m_targetID << std::endl;
        m_model = m_getModel( m_sourceID, id, filter, m_session );
//        setModel( m_model );
//        setModelColumn(1);

//        std::cout << __FILE__ << ":" << __LINE__ << " " << (void*)m_model.get() << std::endl;
//        std::cout << __FILE__ << ":" << __LINE__ << " " << m_model-> rowCount() << std::endl;

        if( id == -1 )
          m_loaded = true;
      }
    }

    void on_focussed()
    {
#ifdef NEVER
      std::cout << __FILE__ << ":" << __LINE__
        << " " << m_sourceID
        << " " << m_targetID
        << " " << m_valueText
        << std::endl
        ;
#endif

      loadModel(-1,"");

//      for( int i=0; i< count(); i++ )
//        if( itemText(i) == m_valueText )
//          setCurrentIndex(i);

      setValueText( m_valueText );

    }

//    void on_textInput()
//    {
//      std::cout << __FILE__ << ":" << __LINE__ << " " << Wt::WLineEdit::valueText() << std::endl;
//
//      if( !m_table )
//      {
//      }
//    }

    /*
    ** this fires when the widget looses focus and the value in it
    **  is different than from when it started
    **
    */
    void on_changed()
    {
      auto value = Wt::WLineEdit::valueText().toUTF8();

      if( value == "" )
      {
        m_targetID = -1;
        m_valueText = "";
        return;
      }

      m_targetID = find_id( value );

      if( m_targetID == -1 )
      {
        auto dialog = addChild( std::make_unique<Wt::WDialog>("item picker") );
        dialog-> rejectWhenEscapePressed(true);
        dialog-> show();
        auto cw = dialog-> contents()-> addNew<Wt::WContainerWidget>();
        auto lw = std::make_unique<Wt::WVBoxLayout>();

        auto u_search = std::make_unique<Wt::WLineEdit>(value);
        auto search = u_search.get();
        search-> setDisabled(true);
        lw-> addWidget( std::move( u_search ) );

        if( m_getTableView )
        {
#ifdef NEVER
          std::cout << __FILE__ << ":" << __LINE__
            << " " << m_sourceID
            << " " << m_targetID
            << " " << search-> valueText().toUTF8()
            << std::endl
            ;
#endif

          auto u_table = m_getTableView( m_sourceID, m_targetID, search-> valueText().toUTF8(), m_session );
          auto table = u_table.get();

          /*
          ** make sure we actually ended up with a table-view
          **
          */
          if( table )
          {
            table-> doubleClicked().connect( dialog, &Wt::WDialog::accept );
            lw-> addWidget( std::move( u_table ), 1 );

            auto u_select = std::make_unique<Wt::WPushButton>("select");
            u_select-> clicked().connect( dialog, &Wt::WDialog::accept );
            lw-> addWidget( std::move( u_select ) );

            dialog-> finished().connect( [=]( Wt::DialogCode code )
            {
              /*
              ** he must hit the 'select' button
              **
              */
              if( dialog-> result() != Wt::DialogCode::Accepted )
                return;

              /*
              ** at most/least one row must be selected
              **
              */
              if( table-> selectedIndexes().size() != 1 )
                return;

              auto index = *table-> selectedIndexes().begin();

              m_targetID = Wt::asNumber( index.data() );
#ifdef NEVER
              std::cout << __FILE__ << ":" << __LINE__
                << " " << index.row()
                << " " << index.column()
                << " " << m_targetID
                << std::endl
                ;
#endif

              setValueText( get_string( m_targetID ) );

            });

          }

          /*
          ** even though we asked for a table-vew, we could not get one
          **  so alert the user.
          **
          */
          else
          {
            lw-> addWidget
            (
             std::make_unique<Wt::WText>
             (
              Wt::WString("FieldDefLookupTable.cpp:{1} 'getTableView' not returning view '{2}'")
              .arg( __LINE__ )
              .arg( m_field )
             )
            );

          }

        }

        else // if( !m_getTableView )
        {
          lw-> addWidget
          (
           std::make_unique<Wt::WText>
           (
            Wt::WString("FieldDefLookupTable.cpp:{1} 'getTableView' not set '{2}'")
            .arg( __LINE__ )
            .arg( m_field )
           )
          );
        }

        auto u_cancel = std::make_unique<Wt::WPushButton>("cancel");
        u_cancel-> clicked().connect( dialog, &Wt::WDialog::reject );
        lw-> addWidget( std::move( u_cancel ) );

        cw-> setLayout( std::move(lw) );

      } // endif( m_targetID == -1 )

      else
      {
        setValueText( get_string( m_targetID ) );
      }

#ifdef NEVER
      std::cout << __FILE__ << ":" << __LINE__
        << "\n targetID: " << m_targetID
        << "\n valueText: " << m_valueText
        << std::endl
        ;
#endif

#ifdef NEVER
      auto dialog = addChild( std::make_unique<Wt::WDialog>() );
      dialog-> rejectWhenEscapePressed();
      dialog-> contents()-> addNew<Wt::WText>("cannot put in false data");
      dialog-> show();
#endif

//      std::cout << __FILE__ << ":" << __LINE__ << " " << std::endl;

    } // endvoid on_changed()


    Wt::WString valueText() const
    {
      auto retVal = Wt::WString("[null]");

      if( m_targetID != -1 )
        retVal = Wt::WString("{1}: {2}]").arg( m_table ).arg( m_targetID );

#ifdef NEVER
      std::cout << __FILE__ << ":" << __LINE__
        << "\n m_loaded:   " << m_loaded
        << "\n m_field:    " << m_field
        << "\n m_table:    " << m_table
        << "\n m_sourceID: " << m_sourceID
        << "\n m_targetID: " << m_targetID
        << "\n retVal:     " << retVal
        << std::endl
        ;
#endif

      return retVal;

    } // endWt::WString valueText() const

    void setValueText( const Wt::WString & value )
    {
      m_valueText = value.toUTF8();

      /*
      ** if the value text is nothing, then wipe
      **  it so that nothing shows.
      **
      */
      if( m_valueText == "[null]" )
          m_valueText = "";

      else
      {
        if( m_valueText.find(":") != std::string::npos )
        {
          auto v = Wtx::Core::split( m_valueText, ':' );
          m_table = v.at(0);
          m_targetID = std::stoi(v.at(1));
          loadModel(m_targetID,"");
          m_valueText = get_string( m_targetID );

        }

      }

      Wt::WLineEdit::setValueText( m_valueText );

#ifdef NEVER
      std::cout << __FILE__ << ":" << __LINE__
        << "\n loaded:   " << m_loaded
        << "\n sourceID: " << m_sourceID
        << "\n targetID: " << m_targetID
        << "\n table:    " << m_table
        << "\n value:    " << value
        << "\n valueText:" << m_valueText
        << "\n valueText:" << Wt::WLineEdit::valueText()
        << std::endl
        ;
#endif

    } // endvoid setValueText( const Wt::WString & value )

    std::shared_ptr<Wt::WAbstractItemModel> (*m_getModel)(int sid, int tid, const std::string & filter, Wtx::Dbo::Session & session) = nullptr;
    std::unique_ptr<Wt::WTableView> (*m_getTableView)(int sid, int tid, const std::string & filter, Wtx::Dbo::Session & session) = nullptr;
    bool m_loaded = false;
    std::string m_field;
    std::string m_table;
    int m_sourceID = -1;
    int m_targetID = -1;
    std::string m_valueText;
    Wtx::Dbo::Session & m_session;
    std::shared_ptr<Wt::WAbstractItemModel> m_model = nullptr;

}; // endclass SmartLineEdit

} // endnamespace STATIC

Wtx::Dbo::FieldDefLookupTable::FieldDefLookupTable
(
 TableDef & td,
 const char * fn,
 int w,
 int h,
 Flags f,
 std::string lb,
 std::string ph,
 std::string inf,
 std::string tt,
 int ht
)
: Wtx::Dbo::FieldDefLookupBase( td, fn, w, w, f, lb, ph, inf, tt, ht )
{
}

Wtx::Dbo::FieldDefLookupTable::FieldDefLookupTable
(
 TableDef & td,
 const char * fn,
 std::string lb,
 std::string ph,
 std::string inf,
 std::string tt,
 int ht
)
: Wtx::Dbo::FieldDefLookupBase( td, fn, lb, ph, inf, tt, ht )
{
}

std::unique_ptr<Wt::WWidget> Wtx::Dbo::FieldDefLookupTable::createEditWidget( int sid, Wtx::Dbo::Session & session ) const
{
//  std::cout << __FILE__ << ":" << __LINE__
//    << "\n sid: " << sid
//    << std::endl
//    ;

  auto retVal = std::make_unique<STATIC::TableLineEdit>( sid, getLookupModel, getTableView, session );
  retVal-> m_table = "[" + targetTable;
  retVal-> m_field = fieldName();

  return retVal;

}