root/original/common/class.contract.php

<?
  require_once( "db.php" );
  require_once( "class.killlist.php" );
  require_once( "class.graph.php" );
  require_once( "class.pagesplitter.php" );

  class Contract
  {
    function Contract( $ctr_id  = 0 )
    {
      $this->ctr_id_ = $ctr_id;
      $this->contracttargets_ = array();

      // overall kill/losslist      
      $this->klist_ = new KillList();
      $this->llist_ = new KillList();
      if ( CORP_ID ) {
        $this->klist_->addInvolvedCorp( new Corporation( CORP_ID ) );
        $this->llist_->addVictimCorp( new Corporation( CORP_ID ) );
      }
      if ( ALLIANCE_ID ) {
        $this->klist_->addInvolvedAlliance( new Alliance( ALLIANCE_ID ) );  
        $this->llist_->addVictimAlliance( new Alliance( ALLIANCE_ID ) );
      }
      $this->contractpointer_ = 0;
      $this->qry_ = null;
    }
    
    function execQuery()
    {
      if ( $this->qry_ )
        return;

      $this->qry_ = new DBQuery();
      // general
      $sql = "select * from kb3_contracts ctr
               where ctr.ctr_id = ".$this->ctr_id_;
             
      $this->qry_ = new DBQuery();
      if ( !$this->qry_->execute( $sql ) )
        die( $this->qry_->getErrorMsg() );
        
      $row = $this->qry_->getRow();
      $this->ctr_name_ = $row['ctr_name'];
      $this->ctr_started_ = $row['ctr_started'];
      $this->ctr_ended_ = $row['ctr_ended'];
      $this->campaign_ = ( $row['ctr_campaign'] == "1" );
      
      // get corps & alliances for contract
      $sql = "select ctd.ctd_crp_id, ctd.ctd_all_id, ctd.ctd_reg_id
                from kb3_contract_details ctd
               where ctd.ctd_ctr_id = ".$row['ctr_id']."
              order by 3, 2, 1";
      
      $caqry = new DBQuery();
      $caqry->execute( $sql ) or die( $caqry->getErrorMsg() );
                   
      while ( $carow = $caqry->getRow() ) {
        $contracttarget = & new ContractTarget( $this, $carow['ctd_crp_id'], $carow['ctd_all_id'], $carow['ctd_reg_id'] );
        array_push( $this->contracttargets_, $contracttarget );
        if ( $carow['ctd_crp_id'] ) {
          $this->klist_->addVictimCorp( new Corporation( $carow['ctd_crp_id'] ) );
          $this->llist_->addInvolvedCorp( new Corporation( $carow['ctd_crp_id'] ) );
        } elseif ( $carow['ctd_all_id'] ) {
          $this->klist_->addVictimAlliance( new Alliance( $carow['ctd_all_id'] ) );
          $this->llist_->addInvolvedAlliance( new Alliance( $carow['ctd_all_id'] ) );        
        } elseif ( $carow['ctd_reg_id'] ) {
          $this->klist_->addRegion( new Region( $carow['ctd_reg_id'] ) );        
          $this->llist_->addRegion( new Region( $carow['ctd_reg_id'] ) );        
        }       
      }

      $this->klist_->setStartDate( $this->getStartDate() );
      $this->llist_->setStartDate( $this->getStartDate() );
      if ( $this->getEndDate() != "" ) {
        $this->klist_->setEndDate( $this->getEndDate() );
        $this->llist_->setEndDate( $this->getEndDate() );        
      }
      
    }

    function getID()
    {
      return $this->ctr_id_;
    }
    
    function getName()
    {
      $this->execQuery();
      return $this->ctr_name_;
    }
    
    function getStartDate()
    {
      $this->execQuery();
      return $this->ctr_started_;
    }

    function getEndDate()
    {
      $this->execQuery();
      return $this->ctr_ended_;
    }

    function getRunTime()
    {
      if ( $this->getEndDate() != "" )
        $datet = getdate( strtotime( $this->getEndDate() ) );
      else
        $datet = getdate( strtotime( date( "Y-m-d" ) ) );

      $datef = getdate( strtotime( $this->getStartDate() ) );
      return $datet['yday']-$datef['yday'];
    }

    function getCampaign()
    {
      $this->execQuery();
      return $this->campaign_;
    }

    function getCorps()
    {
      $this->execQuery();
      return $this->corps_;
    }
    
    function getAlliances()
    {
      $this->execQuery();
      return $this->alliances_;
    }
    
    function getKills()
    {
      $this->execQuery();
      return $this->klist_->getCount();
    }
    
    function getLosses()
    {
      $this->execQuery();
      return $this->llist_->getCount();
    }

    function getKillISK()
    {
      $this->execQuery();
      if ( !$this->klist_->getISK() ) $this->klist_->getAllKills();
      return $this->klist_->getISK();
    }
    
    function getLossISK()
    {
      $this->execQuery();
      if ( !$this->llist_->getISK() ) $this->llist_->getAllKills();
      return $this->llist_->getISK();
    }    
    
    function getEfficiency()
    {
      $this->execQuery();
      if ( $this->klist_->getISK() )
        $efficiency = round( $this->klist_->getISK() / ( $this->klist_->getISK() + $this->llist_->getISK() ) * 100, 2 );
      else
        $efficiency = 0;
      
      return $efficiency;
    }
    
    function getKillList()
    {
      $this->execQuery();
      return $this->klist_;
    }

    function getLossList()
    {
      $this->execQuery();
      return $this->llist_;
    }

    function getContractTarget()
    {
      if ( $this->contractpointer_ > 10 )
        return null;

      $target = $this->contracttargets_[$this->contractpointer_];
      if ( $target )
        $this->contractpointer_++;
      return $target;
    }

    function add( $name, $type, $startdate, $enddate = "" )
    {
      $qry = new DBQuery();
      if ( $type == "campaign" ) $campaign = 1; else $campaign = 0;
      if ( $enddate != "" ) $enddate = "'".$enddate."'"; else $enddate = "null";

      if ( !$this->ctr_id_ ) {
        $sql = "insert into kb3_contracts values ( null, '".$name."',
                                                   '".KB_SITE."', ".
                                                   $campaign.",
                                                   '".$startdate."',
                                                   ".$enddate." )";
        $qry->execute( $sql ) or die( $qry->getErrorMsg() );
        $this->ctr_id_ = $qry->getInsertID();
      }
      else {
        $sql = "update kb3_contracts set ctr_name = '".$name."',
                                         ctr_started = '".$startdate."',
                                         ctr_ended = ".$enddate."
                                     where ctr_id = ".$this->ctr_id_;
        $qry->execute( $sql ) or die( $qry->getErrorMsg() );
        $this->ctr_id_ = $qry->getInsertID();
      }
    }

    function remove()
    {
      $qry = new DBQuery();

      $qry->execute( "delete from kb3_contracts
                       where ctr_id = ".$this->ctr_id_ );

      $qry->execute( "delete from kb3_contract_details
                       where ctd_ctr_id = ".$this->ctr_id_ );
    }

    function validate()
    {
      $qry = new DBQuery();

      $qry->execute( "select * from kb3_contracts
                       where ctr_id = ".$this->ctr_id_."
                         and ctr_site = '".KB_SITE."'" );
      return ( $qry->recordCount() > 0 );
    }
  }
  
  class ContractTarget
  {
    function ContractTarget( $contract, $crp_id, $all_id, $reg_id )
    {
      $this->contract_ = $contract;
      $this->crp_id_ = $crp_id;
      $this->all_id_ = $all_id;
      $this->reg_id_ = $reg_id;

      $this->klist_ = & new KillList();
      $this->llist_ = & new KillList();
      
      if ( $this->crp_id_ ) {
        $this->type_ = "corp";
        $this->klist_->addVictimCorp( new Corporation( $this->crp_id_ ) );
        $this->llist_->addInvolvedCorp( new Corporation( $this->crp_id_ ) );
        $this->id_ = $this->crp_id_;
      } elseif ( $this->all_id_ ) {
        $this->type_ = "alliance";
        $this->klist_->addVictimAlliance( new Alliance( $this->all_id_ ) );
        $this->llist_->addInvolvedAlliance( new Alliance( $this->all_id_ ) );
        $this->id_ = $this->all_id_;
      } elseif ( $this->reg_id_ ) {
        $this->type_ = "region";
        $this->klist_->addRegion( new Region( $this->reg_id_ ) );
        $this->llist_->addRegion( new Region( $this->reg_id_ ) );
        $this->id_ = $this->reg_id_;
      }
        
      if ( CORP_ID ) {
        $this->klist_->addInvolvedCorp( new Corporation( CORP_ID ) );
        $this->llist_->addVictimCorp( new Corporation( CORP_ID ) );
      }
      if ( ALLIANCE_ID ) {
        $this->klist_->addInvolvedAlliance( new Alliance( ALLIANCE_ID ) );  
        $this->llist_->addVictimAlliance( new Alliance( ALLIANCE_ID ) );
      }
      
      $this->klist_->setStartDate( $contract->getStartDate() );
      $this->llist_->setStartDate( $contract->getStartDate() );
      if ( $contract->getEndDate() != "" ) {
        $this->klist_->setEndDate( $contract->getEndDate() );
        $this->llist_->setEndDate( $contract->getEndDate() );        
      }
    }

    function getID()
    {
      return $this->id_;
    }
    
    function getName()
    {
      if ( $this->name_ == "" ) {
        $qry = new DBQuery();
        switch ( $this->type_ ) {
          case "corp":
            $qry->execute( "select crp_name as name from kb3_corps where crp_id = ".$this->crp_id_ );
            break;
          case "alliance":   
            $qry->execute( "select all_name as name from kb3_alliances where all_id = ".$this->all_id_ );
            break;
          case "region":   
            $qry->execute( "select reg_name as name from kb3_regions where reg_id = ".$this->reg_id_ );
            break;
        }
        $row = $qry->getRow();
        $this->name_ = $row['name'];
      }
      return $this->name_;
    }
    
    function getType()
    {
      return $this->type_;
    }
    
    function getKillList()
    {
      return $this->klist_;
    }

    function getLossList()
    {
      return $this->llist_;
    }
    
    function getEfficiency()
    {
      if ( $this->klist_->getISK() )
        $efficiency = round( $this->klist_->getISK() / ( $this->klist_->getISK() + $this->llist_->getISK() ) * 100, 2 );
      else
        $efficiency = 0;

      return $efficiency;
    }
    
    function getKills()
    {
    }
    
    function getLosses()
    {
    }

    function add()
    {
      $qry = new DBQuery();
      $sql = "insert into kb3_contract_details
                     values ( ".$this->contract_->getID().",";
      switch( $this->type_ ) {
        case "corp":
          $sql .= $this->id_.", 0, 0 )";
          break;
        case "alliance":
          $sql .= "0, ".$this->id_.", 0 )";
          break;
        case "region":
          $sql .= "0, 0, ".$this->id_." )";
          break;
      }
      $qry->execute( $sql ) or die( $qry->getErrorMsg() );
    }

    function remove()
    {
      $qry = new DBQuery();
      $sql = "delete from kb3_contract_details
                    where ctd_ctr_id = ".$this->contract_->getID();
      switch( $this->type_ ) {
        case "corp":
          $sql .= " and ctd_crp_id = ".$this->id_;
          break;
        case "alliance":
          $sql .= " and ctd_all_id = ".$this->id_;
          break;
        case "region":
          $sql .= " and ctd_reg_id = ".$this->id_;
          break;
      }
      $qry->execute( $sql ) or die( $qry->getErrorMsg() );
    }
  }

  class ContractList
  {
    function ContractList()
    {
      $this->qry_ = new DBQuery();
      $this->active_ = "both";
      $this->contractcounter_ = 1;
    }
    
    function execQuery()
    {
      if ( $this->qry_->executed() )
        return;

      $sql = "select ctr.ctr_id, ctr.ctr_started, ctr.ctr_ended, ctr.ctr_name
                from kb3_contracts ctr
               where ctr.ctr_site = '".KB_SITE."'";
      if ( $this->active_ == "yes" )
        $sql .= " and ( ctr_ended is null or now() <= ctr_ended )";
      elseif ( $this->active_ == "no" )
        $sql .= " and ( now() >= ctr_ended )";
      
      if ( $this->campaigns_ )
        $sql .= " and ctr.ctr_campaign = 1";
      else
        $sql .= " and ctr.ctr_campaign = 0";
        
      $sql .= " order by ctr_ended, ctr_started desc";

      //if ( $this->limit_ )
      //  $sql .= " limit ".( $this->page_ / $this->limit_ ).", ".$this->limit_;

      $this->qry_ = new DBQuery();
      $this->qry_->execute( $sql ) or die( $this->qry_->getErrorMsg() );
    }

    function setActive( $active )
    {
      $this->active_ = $active;
    }
    
    function setCampaigns( $campaigns )
    {
      $this->campaigns_ = $campaigns;
    }

    function setLimit( $limit )
    {
      $this->limit_ = $limit;
    }

    function setPage( $page )
    {
      $this->page_ = $page;
      $this->offset_ = ( $page * $this->limit_ ) - $this->limit_;
    }

    function getContract()
    {
      //echo "off: ".$this->offset_."<br>";
      //echo "cnt: ".$this->contractcounter_."<br>";
      //echo "limit: ".$this->limit_."<br>";
      $this->execQuery();
      if ( $this->offset_ && $this->contractcounter_ < $this->offset_ ) {
        for ( $i = 0; $i < $this->offset_; $i++ ) {
          $row = $this->qry_->getRow();
          $this->contractcounter_++;
        }
      }
      if ( $this->limit_ && ( $this->contractcounter_ - $this->offset_ ) > $this->limit_ )
        return null;

      $row = $this->qry_->getRow();
      if ( $row ) {
        $this->contractcounter_++;
        return new Contract( $row['ctr_id'] );
      }
      else
        return null;
    }

    function getCount()
    {
      $this->execQuery();
      return $this->qry_->recordCount();
    }

    function getActive()
    {
      return $this->active_;
    }
  }

  class ContractListTable
  {
    function ContractListTable( $contractlist )
    {
      $this->contractlist_ = $contractlist;
    }

    function paginate( $paginate, $page = 1 )
    {
      if ( !$page ) $page = 1;
      $this->paginate_ = $paginate;
      $this->contractlist_->setLimit( $paginate );
      $this->contractlist_->setPage( $page );
    }
    
    function generate()
    {
      if ( $this->contractlist_->getCount() ) {
        $rowid = 0;
        $html .= "<table class=kb-table width=\"98%\" align=center cellspacing=1>";
        $html .= "<tr class=kb-table-header>";
        $html .= "<td class=kb-table-cell width=180>Name</td>";
        $html .= "<td class=kb-table-cell width=80 align=center>Start date</td>";
        if ( $this->contractlist_->getActive() == "no" )
          $html .= "<td class=kb-table-cell width=80 align=center>End date</td>";
        $html .= "<td class=kb-table-cell width=50 align=center>Kills</td>";
        $html .= "<td class=kb-table-cell width=70 align=center>ISK (M)</td>";
        $html .= "<td class=kb-table-cell width=50 align=center>Losses</td>";
        $html .= "<td class=kb-table-cell width=70 align=center>ISK (M)</td>";
        $html .= "<td class=kb-table-cell width=70 align=center colspan=2>Efficiency</td>";        
        $html .= "</tr>";
        
        $odd = false;
        $rowclass = "kb-table-row-even";
        while ( $contract = $this->contractlist_->getContract() ) {
          if ( $odd ) {
            $rowclass = "kb-table-row-even";
            $odd = false;
          }
          else {
            $rowclass = "kb-table-row-odd";
            $odd = true;
          }
          
          $html .= "<tr class=".$rowclass." onmouseover=\"this.className='kb-table-row-hover';\" onmouseout=\"this.className='".$rowclass."';\" onClick=\"window.location.href='?a=cc_detail&ctr_id=".$contract->getID()."';\">";
          $html .= "<td class=kb-table-cell><b>".$contract->getName()."</b></td>";
          $html .= "<td class=kb-table-cell align=center>".substr( $contract->getStartDate(), 0, 10 )."</td>";
          if ( $this->contractlist_->getActive() == "no" ) {
            if ( $contract->getEndDate() == "" )
              $ended = "Active";
            else
              $ended = substr( $contract->getEndDate(), 0, 10 );
            $html .= "<td class=kb-table-cell align=center>".$ended."</td>";
          }
          if ( $contract->getKills() == 0 )
            $kclass = "kl-null";
          else
            $kclass = "kl-kill";

          if ( $contract->getLosses() == 0 )
            $lclass = "kl-null";
          else
            $lclass = "kl-loss";
                      
          $html .= "<td class=".$kclass." align=center>".$contract->getKills()."</td>";
          $html .= "<td class=".$kclass." align=center>".$contract->getKillISK()."</td>";
          $html .= "<td class=".$lclass." align=center>".$contract->getLosses()."</td>";
          $html .= "<td class=".$lclass." align=center>".$contract->getLossISK()."</td>";          
          $bar = new BarGraph( $contract->getEfficiency(), 100, 75 );
          $html .= "<td class=kb-table-cell align=center width=40><b>".$contract->getEfficiency()."%</b></td>";
          $html .= "<td class=kb-table-cell align=left width=75>".$bar->generate()."</td>";
          $html .= "</tr>";
        }
        $html .= "</table>";
        $pagesplitter = new PageSplitter( $this->contractlist_->getCount(), 10 );
        $html .= $pagesplitter->generate();
      }
      else $html .= "None.";

      return $html;
    }
  }

?>