HK_Advanced.cpp

Go to the documentation of this file.

/*******************************************************************/
#include "../headers/Advanced.h" 
 
HK_Advanced::HK_Advanced(){}
 
int HK_Advanced::CalcAvgLoss() 
{
    float Loss = 0;
    int A;
    
    for(A = 0; A < GetEggCount();A++) {
        Loss += HK_AdvEggs[A].CalcTotalLoss();
    }
    
    return Loss / A;
}
 
 
void HK_Advanced::Clear()
{
    HK_AdvID = -1;
    HK_AdvUnit = -1;
    HK_AdvDays = -1;
    HK_AdvEggs.clear();
    HK_AdvEggs.shrink_to_fit();
    HK_AdvUpdate = false;
    
}
 
void HK_Advanced::AddEgg(HK_Egg Egg){HK_AdvEggs.push_back(Egg);}
int HK_Advanced::GetID(){return HK_AdvID;}
int HK_Advanced::GetUnit(){return HK_AdvUnit;}
int HK_Advanced::GetDays(){return HK_AdvDays;}
vector<HK_Egg> HK_Advanced::GetEggs(){return HK_AdvEggs;}
HK_Egg HK_Advanced::GetEgg(int Select){return HK_AdvEggs[Select];}
int HK_Advanced::GetEggCount(){return HK_AdvEggs.size();}
 
int HK_Advanced::GetFertile()
{
    int Fertile = 0;
    
    for(int A = 0; A < GetEggCount(); A++)
        if(HK_AdvEggs[A].GetFertile() == 1)
            Fertile++;
    return Fertile;
}
int HK_Advanced::GetChicks()
{
    int Chicks = 0;
    
    for(int A = 0; A < GetEggCount(); A++)
        if(HK_AdvEggs[A].GetResult() == 0)
            Chicks++;
    return Chicks;
}
 
string HK_Advanced::GetSQL() {
    
    string sql = "INSERT INTO Advanced VALUES(" + to_string(GetID()) + "," +  
    to_string(GetEggCount()) + ","+ to_string(GetUnit()) + "," + to_string(GetDays()) + ","; 
    
    string tag1 = "", tag2 = "", tag3 = "";
    string fertile = "", pip = "";
    string result = "", resDate = "", eggCom = ""; 
    string dWeight = "", dComment = "";
    int a, b;
    HK_Egg Egg;
    vector<HK_Weight> weights;
    vector<string> daycomms;
    
    for(a = 0;a < (GetEggCount() - 1); a++) {
        Egg = GetEgg(a);
        tag1 += Egg.GetTag1() + "&"; 
        tag2 += Egg.GetTag2() + "&";
        tag3 += Egg.GetTag3() + "&";
        fertile += to_string(Egg.GetFertile()) + "/";
        pip += to_string(Egg.GetPipped()) + "/";
        result += to_string(Egg.GetResult()) + "/";
        resDate += Egg.GetDate().ToSortable("/") + "&";
        eggCom += Egg.GetComments() + "&";
        
        //Day Weight
        weights = Egg.GetDayWeight();
        for(b = 0; b < (GetDays() - 1); b++)
            dWeight += weights[b].GetString() + "/";
        dWeight += weights[b].GetString() + "&";
        
        //Day Comments
        daycomms = Egg.GetDayComments();
        for(b = 0; b < (GetDays() - 1); b++) {
            dComment += daycomms[b] + "|";
        }
        dComment +=  daycomms[b] + "&";
    }
 
    Egg = GetEgg(a);
    tag1 += Egg.GetTag1(); 
    tag2 += Egg.GetTag2();
    tag3 += Egg.GetTag3();
    fertile += to_string(Egg.GetFertile());
    pip += to_string(Egg.GetPipped());
    result += to_string(Egg.GetResult());
    resDate += Egg.GetDate().ToSortable("/");
    eggCom += Egg.GetComments();
        
   //Day Weight
    weights = Egg.GetDayWeight();
    for(b = 0; b < (GetDays() - 1); b++)
        dWeight += weights[b].GetString() + "/";
    dWeight += weights[b].GetString();
    
    //Day Comments
    daycomms = Egg.GetDayComments();
    for(b = 0; b < (GetDays() - 1); b++)
        dComment += daycomms[b] + "|";
    dComment +=  daycomms[b];
 
    //Add Tags
    sql += "'" + tag1 + "','" + tag2 + "','" + tag3 + "','";
    //Fertile & Pipped
    sql += fertile + "','" + pip + "','";
    //Result and comments
    sql += result + "','" + resDate + "','" + eggCom + "','";
    //Day weight and comments
    sql += dWeight + "','" + dComment + "');";
    
    return sql;
}
 
vector<string> HK_Advanced::GetUpdate()
{
    int A = 0,B = 0,Fertile = 0,Chicks = 0;
    vector<string> Sql, Results;
    
    Sql.push_back(" EggComments = '");
    Sql.push_back(" Tag1 = '");
    Sql.push_back(" Tag2 = '");
    Sql.push_back(" Tag3 = '");
    Sql.push_back(" Fertile = '");
    Sql.push_back(" Pipped = '");
    Sql.push_back(" Result = '");
    Sql.push_back(" ResultDate = '");
    Sql.push_back(" DayWeight = '");
    Sql.push_back(" DayComment = '");
    
    //Values
    for(A = 0;A < (GetEggCount() - 1); A++) {
        Sql[0] += HK_AdvEggs[A].GetComments() + "&";
        
        Sql[1] += HK_AdvEggs[A].GetTag1() + "&";
        Sql[2] += HK_AdvEggs[A].GetTag2() + "&";
        Sql[3] += HK_AdvEggs[A].GetTag3() + "&";
        
        Sql[4] += to_string(HK_AdvEggs[A].GetFertile()) + "/"; 
        Fertile += HK_AdvEggs[A].GetFertile();
        
        Sql[5] += to_string(HK_AdvEggs[A].GetPipped()) + "/"; 
        
        Sql[6] += to_string(HK_AdvEggs[A].GetResult()) + "/";
        if(HK_AdvEggs[A].GetResult() == 0)
            Chicks++;
        
        Sql[7] += HK_AdvEggs[A].GetDate().ToSortable("/") + "&";
        
        for(B = 0; B < (GetDays() - 1); B++)
            Sql[8] += to_string(HK_AdvEggs[A].GetDayWeight()[B].GetFloat()) + "/";
        Sql[8] += HK_AdvEggs[A].GetDayWeight()[B].GetString() + "&";
        
        for(B = 0; B < (GetDays() - 1); B++)
            Sql[9] += HK_AdvEggs[A].GetDayComments()[B] + "|";
        Sql[9] += HK_AdvEggs[A].GetDayComments()[B] + "&";
    }
    
    Sql[0] += HK_AdvEggs[A].GetComments();
    Sql[1] += HK_AdvEggs[A].GetTag1();
    Sql[2] += HK_AdvEggs[A].GetTag2();
    Sql[3] += HK_AdvEggs[A].GetTag3();
    
    Sql[4] += to_string(HK_AdvEggs[A].GetFertile()); 
    Fertile += HK_AdvEggs[A].GetFertile();
    
    Sql[5] += to_string(HK_AdvEggs[A].GetPipped()); 
    
    Sql[6] += to_string(HK_AdvEggs[A].GetResult());
    if(HK_AdvEggs[A].GetResult() == 0)
        Chicks++;
    
    Sql[7] += HK_AdvEggs[A].GetDate().ToSortable("/");
    
    for(B = 0; B < (GetDays() - 1); B++)
        Sql[8] += HK_AdvEggs[A].GetDayWeight()[B].GetString() + "/";
    Sql[8] += HK_AdvEggs[A].GetDayWeight()[B].GetString();
    
    for(B = 0; B < (GetDays() - 1); B++)
        Sql[9] += HK_AdvEggs[A].GetDayComments()[B] + "|";
    Sql[9] += HK_AdvEggs[A].GetDayComments()[B];
    
    //Add ID
    string Temp = "UPDATE Advanced SET ";
    unsigned int C = 0;
    for(C = 0; C < Sql.size() - 1; C++)
        Temp += Sql[C] + "', ";
    Temp += Sql[C] + "' WHERE ID = " + to_string(HK_AdvID) + ";";
    
    //Update Batch As Well
    Results.push_back(" UPDATE Batches SET FertileEggs = " + to_string(Fertile) + " WHERE ID = " + to_string(HK_AdvID) + ";");
    Results.push_back(" UPDATE Batches SET ChicksHatched = " + to_string(Chicks) + " WHERE ID = " + to_string(HK_AdvID) + ";");
    Results.push_back(Temp);
 
    return Results;
}
 
bool HK_Advanced::GetUpdateStatus(){return HK_AdvUpdate;}
 
HK_KeyValue HK_Advanced::Search(string Value, string BatchName)
{
    HK_KeyValue Results;
    
    for(int A = 0; A < GetEggCount(); A++)
        Results.Add(HK_AdvEggs[A].Search(Value,BatchName,(A + 1)));
    
    return Results;
}
 
void HK_Advanced::Set(int ID, int Unit, int Days, vector<HK_Egg> Eggs)
{
    HK_AdvID = ID;
    HK_AdvUnit = Unit;
    HK_AdvDays = Days;
    HK_AdvEggs = Eggs;
}
 
void HK_Advanced::SetID(int ID){HK_AdvID = ID;}
void HK_Advanced::SetUnit(int Unit){HK_AdvUnit = Unit;}
void HK_Advanced::SetDays(int Days){HK_AdvDays = Days;}
void HK_Advanced::SetEggs(vector<HK_Egg> Eggs){HK_AdvEggs = Eggs;}
void HK_Advanced::SetEgg(HK_Egg Egg, int Select){HK_AdvEggs[Select] = Egg;}
void HK_Advanced::SetUpdate(bool Status){HK_AdvUpdate = Status;}