proximitySearch method

dynamic proximitySearch(
  1. dynamic selectQuery,
  2. GlobalSearchParameters params,
  3. LocalSqlDataStore sql
)

Implementation

proximitySearch(
    selectQuery, GlobalSearchParameters params, LocalSqlDataStore sql) {
  if (!params.isProximityEnabled) {
    return null;
  } else if (params.isProximityEnabled) {
    selectQuery = super.sql.address.select().join([
      joinHouseHoldAddress(sql),
      leftOuterJoin(
          sql.projectBeneficiary,
          sql.projectBeneficiary.beneficiaryClientReferenceId
              .equalsExp(sql.household.clientReferenceId))
    ])
      ..where(buildAnd([
        sql.address.relatedClientReferenceId.isNotNull(),
        sql.household.clientReferenceId.isNotNull(),
        if (params.latitude != null &&
            params.longitude != null &&
            params.maxRadius != null)
          CustomExpression<bool>('''
            (6371393 * acos(
                cos(${params.latitude! * math.pi / 180.0}) * cos((address.latitude * ${math.pi / 180.0}))
                * cos((address.longitude * ${math.pi / 180.0}) - ${params.longitude! * math.pi / 180.0})
                + sin(${params.latitude! * math.pi / 180.0}) * sin((address.latitude * ${math.pi / 180.0}))
            )) <= ${params.maxRadius!}
          '''),
        if (params.latitude != null &&
            params.longitude != null &&
            params.maxRadius != null)
          sql.address.longitude.isNotNull(),
        sql.address.latitude.isNotNull(),
      ]))
      ..orderBy([
        if (params.latitude != null &&
            params.longitude != null &&
            params.maxRadius != null)
          OrderingTerm(
            expression: CustomExpression<double>('''
              (6371393 * acos(
                  cos(${params.latitude! * math.pi / 180.0}) * cos((address.latitude * ${math.pi / 180.0}))
                  * cos((address.longitude * ${math.pi / 180.0}) - ${params.longitude! * math.pi / 180.0})
                  + sin(${params.latitude! * math.pi / 180.0}) * sin((address.latitude * ${math.pi / 180.0}))
              ))
            '''),
            mode: OrderingMode.asc,
          ),
      ]);
  }
  return selectQuery;
}