1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78

class CStateShortMap
{
public:
  CStateShortMap(int id, TDateTime time, TZReadOnlyQuery* query);
  void Load(TZReadOnlyQuery* query, TDateTime time);
  int GetTypeSize() const { return Items.size(); }
  char GetType(int idx)
  {
    return Items[idx].first;
  }
  std::vector< std::vector<CStateShortItem> >& GetItems(char type)
  {
    for(int i=0; i < Items.size(); i++)
    {
      if( Items[i].first == type )
        return Items[i].second;
    }
    return Items[0].second;
  }
private:
  const int Id;
  std::vector< std::pair<char, std::vector< std::vector<CStateShortItem> > > > Items;
};

CStateShortMap::CStateShortMap(int id, TDateTime time, TZReadOnlyQuery* query)
 : Id(id)
{
  Load( query, time );
}

void CStateShortMap::Load(TZReadOnlyQuery* query, TDateTime time)
{
  Items.clear();
  String sql;
  sql.sprintf( "select map.id_, equipment.type_"
               " from map left join equipment on map.equipment_id=equipment.id_"
               " where map.station_id=%d order by equipment.type_", Id );
  query->SQL->Text = sql;
  query->Open();
  vector< pair<int, char> > mapId;
  while( !query->Eof )
  {
    mapId.push_back( pair<int, char>(query->FieldByName( "id_" )->AsInteger, query->FieldByName( "type_" )->AsString[1]) );
    query->Next();
  }
  Items.clear();
  for(int i=0; i<mapId.size(); i++)
  {
    sql.sprintf( "select status.color, status.name_, map.number_equipment, equipment_status.status_id, equipment_status.begin_, equipment_status.plan_end_"
                 " from equipment_status left join map on equipment_status.map_id=map.id_"
                 " left join status on equipment_status.status_id=status.id_"
                 " where equipment_status.map_id=%d and begin_<='%s' order by equipment_status.begin_ desc limit 1",
                 mapId[i].first, time.FormatString("yyyy-mm-dd hh:nn:ss") );   //equipment_status.id_
    query->SQL->Text = sql;
    query->Open();
    if( query->Eof ) continue;
    int id[] = { 0, 1, 1, 1, 1, 2, 3, 1, 1, 1 };
    int j;
    for(j=0; j<Items.size(); j++)
      if( Items[j].first==mapId[i].second )
        break;
    if( j!=Items.size() )
      Items[j].second[id[query->FieldByName( "status_id" )->AsInteger]].push_back( CStateShortItem( query ) );
    else
    {
      Items.push_back( std::pair<char, std::vector< std::vector<CStateShortItem> > >( mapId[i].second, std::vector< std::vector<CStateShortItem> >() ) );
      Items[ Items.size()-1 ].second.resize( 4 );
      Items[ Items.size()-1 ].second[ id[query->FieldByName( "status_id" )->AsInteger] ].push_back( CStateShortItem( query ) );
    }
  }
  for(int i=0; i<Items.size(); i++)
  {
    sort( Items[i].second[0].begin(), Items[i].second[0].end() );
    sort( Items[i].second[1].begin(), Items[i].second[1].end() );
    sort( Items[i].second[2].begin(), Items[i].second[2].end() );
    sort( Items[i].second[3].begin(), Items[i].second[3].end() );
  }
}