fwolf / fwlib

	 * 							(non-indexed will use it's original name).

	 * @return string

	 */

	protected function GenSqlArrayAs($param, $use_as = true, $quote = false, $tas = true)

	{

		$sql = '';

		if (is_array($param) && !empty($param))

			foreach ($param as $k=>$v)

			{

				// If there are space in $v, it need to be quoted

				// so always quote it.

				if (is_int($k))

				{

					$sql .= ", $v";

				}

				else

				{

					// table AS a

					// tabel AS 'a'

					$s_split = ($quote) ? "'" : '';

					$s_as = ($use_as) ? 'AS' : '';

					if ($tas)

						$sql .= ", $v $s_as $s_split{$k}$s_split";

					else

						$sql .= ", $k $s_as $s_split{$v}$s_split";

				}

			}

		else

			$sql .= ", $param";

		$sql = substr($sql, 2);

		return $sql;

	} // end of func GenSqlArrayAs

	/**

     *                              alias.  Eg: {tbl1, a: tbl2}

     * @return string

     */

    protected function genSqlArrayAs(

        $param,

        $useAs = true,

        $quote = false,

        $reverse = true

    ) {

        $sql = '';

        if (!empty($param) && is_array($param)) {

            foreach ($param as $k => $v) {

                // If there are space in $v, it need to be quoted, so always

                // quote it except number (here will not have float value).

                if (is_int($k)) {

                    $sql .= ", $v";

                } else {

                    // table AS a

                    // table AS 'a'

                    $split = ($quote) ? "'" : '';

                    $as = ($useAs) ? 'AS ' : '';

                    // Reverse as is only useful for particular db type

                    // @codeCoverageIgnoreStart

                    if ($reverse) {

                        $sql .= ", $v $as$split{$k}$split";

                    } else {

                        $sql .= ", $k $as$split{$v}$split";

                    }

                    // @codeCoverageIgnoreEnd

                }

            }

        } else {

            $sql .= ", $param";

        }

        $sql = substr($sql, 2);

        return $sql;

    }

    /**